2.2akiba-online

GovernorsStateUniversityOPUSOpenPortaltoUniversityScholarshipAllCapstoneProjectsStudentCapstoneProjectsSummer2014DesignandImplementationofE-CommerceSiteforOnlineShoppingSidharthaReddyVatrapuGovernorsStateUniversityFollowthisandadditionalworksat:https://opus.
govst.
edu/capstonesPartoftheDatabasesandInformationSystemsCommons,andtheSystemsArchitectureCommonsFormoreinformationabouttheacademicdegree,extendedlearning,andcertificateprogramsofGovernorsStateUniversity,gotohttp://www.
govst.
edu/Academics/Degree_Programs_and_Certifications/VisittheGovernorsStateComputerScienceDepartmentThisProjectSummaryisbroughttoyouforfreeandopenaccessbytheStudentCapstoneProjectsatOPUSOpenPortaltoUniversityScholarship.
IthasbeenacceptedforinclusioninAllCapstoneProjectsbyanauthorizedadministratorofOPUSOpenPortaltoUniversityScholarship.
Formoreinformation,pleasecontactopus@govst.
edu.
RecommendedCitationVatrapu,SidharthaReddy,"DesignandImplementationofE-CommerceSiteforOnlineShopping"(2014).
AllCapstoneProjects.
79.
https://opus.
govst.
edu/capstones/79DesignandImplementationofE-CommerceSiteforOnlineShopping1GraduateProjectDesignandImplementationofE-CommerceSiteforOnlineShoppingBySidharthaReddyVatrapuFortheDegreeMasterofComputerScience,WithaMajorinComputerScienceGovernorsStateUniversityUniversityPark,IL604842014DesignandImplementationofE-CommerceSiteforOnlineShopping3ABSTRACTIntoday'sfast-changingbusinessenvironment,it'sextremelyimportanttobeabletorespondtoclientneedsinthemosteffectiveandtimelymanner.
Ifyourcustomerswishtoseeyourbusinessonlineandhaveinstantaccesstoyourproductsorservices.
OnlineShoppingisalifestylee-commercewebapplication,whichretailsvariousfashionandlifestyleproducts(CurrentlyMen'sWear).
ThisprojectallowsviewingvariousproductsavailableenablesregistereduserstopurchasedesiredproductsinstantlyusingPayPalpaymentprocessor(InstantPay)andalsocanplaceorderbyusingCashonDelivery(PayLater)option.
ThisprojectprovidesaneasyaccesstoAdministratorsandManagerstoviewordersplacedusingPayLaterandInstantPayoptions.
Inordertodevelopane-commercewebsite,anumberofTechnologiesmustbestudiedandunderstood.
Theseincludemulti-tieredarchitecture,serverandclientsidescriptingtechniques,implementationtechnologiessuchasASP.
NET,programminglanguage(suchasC#)andrelationaldatabases.
Thisisaprojectwiththeobjectivetodevelopabasicwebsitewhereaconsumerisprovidedwithashoppingcartapplicationandalsotoknowaboutthetechnologiesusedtodevelopsuchanapplication.
Thisdocumentwilldiscusseachoftheunderlyingtechnologiestocreateandimplementane-commercewebsite.
DesignandImplementationofE-CommerceSiteforOnlineShopping4ACKNOWLEDGEMENTSIncompletingthisgraduateprojectIhavebeenfortunatetohavehelp,supportandencouragementfrommanypeople.
Iwouldliketoacknowledgethemfortheircooperation.
FirstandforemostdeeplythankfultoProfessorDr.
Soon-OkPark,forherwonderfulguidanceduringthisprojectworkinfieldofComputerScience,atGovernorsStateUniversity.
Iamalsothankfulforhercontinuousfeedbackandencouragementthroughoutthisprojectwork.
Herbroadknowledgeandhardworkingattitudehasleftmewithverydeepimpressionsandtheywillgreatlybenefitmethroughoutmylife.
IwouldliketothankmyprojectReadersDr.
Kong-ChengWongandDr.
SteveHyznyfortheirsupportthroughoutthisprojectwork.
DesignandImplementationofE-CommerceSiteforOnlineShopping5TABLEOFCONTENTSABSTRACT…3ACKNOWLDEGEMENT4LISTOFFIGURES…61.
0INTRDUCTION…72.
0OVERALLDESCSRIPTION…72.
1DESCRIPTION…72.
2USINGTHECODE…82.
3MASTERPAGEDETAILS…82.
4WEBPAGESDETAILS…82.
5PROJECTDETAILS…83.
0SYSTEMREQUREMENT93.
1USE-CASEDIAGRAM…94.
0ONLINESHOPPINGAPPLICATION…94.
1HOMEPAGE4.
2CLOTHINGPAGE(PRDUCTS)4.
3ORDERUSPAGE4.
4CONTACTUSPAGE4.
5ABOUTUSPAGE4.
6TRACKFORADMINPAGE4.
7REGISTERPAGE4.
8LOGIN4.
9ADMINPAGE4.
10ORDERVIEWFORUSER4.
11PAYPALFORPAYMENT4.
12SUCCESSPAGE4.
13FAILEDPAGE5.
0DATAMANAGEMENT…165.
1DATADESCRIPTION5.
2DATAOBJECTS5.
3DATATABLEDIAGRAM5.
4RELATIONSHIPS6.
0NON-FUNCTIONAL/OPERATIONALREQUIREMENTS………………….
196.
1SECURITY6.
2EFFICIENCYANDMAINTAINABLITY7.
0CONCLUSION…198.
0REFERENCE…21DesignandImplementationofE-CommerceSiteforOnlineShopping6ListofFiguresHOMEPAGE…10CLOTHINGPAGE(PRODUCTS)10ORDERUSPAGE…11CONTACTUSPAGE…11ABOUTUSPAGE…12TRACKFORADMINPAGE…12REGISTERPAGE…13LOGIN…13ADMINPAGE…14ORDERVIEWFORUSER…14PAYPALFORPAYMENT…15SUCCESSPAGE…15FAILEDPAGE…16DesignandImplementationofE-CommerceSiteforOnlineShopping71.
0INTRODUCTION:E-commerceisfastgaininggroundasanacceptedandusedbusinessparadigm.
Moreandmorebusinesshousesareimplementingwebsitesprovidingfunctionalityforperformingcommercialtransactionsovertheweb.
Itisreasonabletosaythattheprocessofshoppingonthewebisbecomingcommonplace.
Theobjectiveofthisprojectistodevelopageneralpurposee-commercestorewhereproductlikeclothescanbeboughtfromthecomfortofhomethroughtheInternet.
However,forimplementationpurposes,thispaperwilldealwithanonlineshoppingforclothes.
AnonlinestoreisavirtualstoreontheInternetwherecustomerscanbrowsethecatalogandselectproductsofinterest.
Theselecteditemsmaybecollectedinashoppingcart.
Atcheckouttime,theitemsintheshoppingcartwillbepresentedasanorder.
Atthattime,moreinformationwillbeneededtocompletethetransaction.
Usually,thecustomerwillbeaskedtofillorselectabillingaddress,ashippingaddress,ashippingoption,andpaymentinformationsuchascreditcardnumber.
Ane-mailnotificationissenttothecustomerassoonastheorderisplaced.
2.
0OVERALLDESCRIPTION:2.
1Description:Anymembercanregisterandviewavailableproducts.
Onlyregisteredmembercanpurchasemultipleproductsregardlessofquantity.
ContactUspageisavailabletocontactAdminforqueries.
Therearethreerolesavailable:Visitor,UserandAdmin.
Visitorcanviewavailableproducts.
Usercanviewandpurchaseproducts.
AnAdminhassomeextraprivilegeincludingallprivilegeofvisitoranduser.
Admincanaddproducts,editproductinformationandadd/removeproduct.
Admincanadduser,edituserinformationandcanremoveuser.
Admincanshipordertouserbasedonorderplacedbysendingconfirmationmail.
DesignandImplementationofE-CommerceSiteforOnlineShopping82.
2Usingthecode:1.
Attachthedatabaseinyour"SQLServerManagementStudioExpress".
2.
RuntheapplicationonMicrosoftVisualStudioaswebsite.
3.
Locatethedatabase.
2.
3MasterPagedetails:OnlineShoppingMasterPage(SimilarMasterPageforVisitor,UserandAdmin)2.
4WebPagesdetails:HomePageAboutUsPageClothingPageOrderUsPageContactUsPageAdminPageLoginPageRegisterPageTrack2.
5ProjectDetail:DesignandImplementationofE-CommerceSiteforOnlineShopping93.
0SYSTEMREQUREMENTS:3.
1USE-CASEDIAGRAM:DesignandImplementationofE-CommerceSiteforOnlineShopping104.
0ONLINESHOPPINGAPPLICATION:AnyonecanviewOnlineShoppingportalandavailableproducts,buteveryusermustloginbyhis/herUsernameandpasswordinordertopurchaseororderproducts.
Unregisteredmemberscanregisterbynavigatingtoregistrationpage.
OnlyAdminwillhaveaccesstomodifyroles,bydefaultdevelopercanonlybean'Admin'.
Onceuserregistersite,hisdefaultrolewillbe'User'.
4.
1HOMEPAGE:TheHomeScreenwillconsistofscreenwereonecanbrowsethroughtheproductswhichwehaveonourwebsiteFigure1:HomePageDesignandImplementationofE-CommerceSiteforOnlineShopping114.
2.
CLOTHINGPAGE(PRODUCTS):Thispageconsistsofproductdetails.
Thispageappearssameforbothvisitorsandusers.
Figure2:ClothingPage4.
3OrderUsPage:Registereduserscanorderdesiredproductsfromhere.
Figure3:OrderUsPageDesignandImplementationofE-CommerceSiteforOnlineShopping124.
4ContactUsPage:VisitorsandRegistereduserscancontactwebsiteownersoradministratorsfromhereFigure4:ContactUsPage4.
5ABOUTUSPAGE:ThispagedescribesaboutwebsiteandownersFigure5:AboutusPageDesignandImplementationofE-CommerceSiteforOnlineShopping134.
6TrackForAdminPage:WebsiteAdministratorscantrackandshipordershere.
Figure6:TrackingPageforAdmin.
4.
7REGISTERPAGE:NewuserscanregisterhereFigure7:RegisterPageDesignandImplementationofE-CommerceSiteforOnlineShopping144.
8LOGINPAGE:Loginpageforbothusersandadministrators.
4.
9AdminPage:OnlydifferenceyouseeinthispageisRole:Admin.
UserandAdminrolewillbecheckedoncethepagewasloginandSession["role"]willbeeitherAdminorUser.
IfcredentialsbelongtoAdminthenrolewillbeAdminandifcredentialsbelongtoUserthenrolewillbeUser.
Figure9:AdminPageDesignandImplementationofE-CommerceSiteforOnlineShopping154.
10ORDERVIEWFORUSER:Onceusersorderitemtheyareabletoseeorderedproductsandgrandtotal.
Figure10:OrderViewforUser4.
11PAYPALFORPAYMENT:Onceusersordersproductstheyareredirectedtopaymentpage.
LFigure11:PayPalPageDesignandImplementationofE-CommerceSiteforOnlineShopping16Figure4.
12:SuccessURLFigure12:SuccessURLFIGURE4.
12:FailedURLFigure12:FailedURLDesignandImplementationofE-CommerceSiteforOnlineShopping175.
0DataManagement5.
1DataDescriptionThisdatabaseconsistsofUsers:UserandAdmininformationisaddedtodatabasewithUniqueIDbasedontheirroles.
Shopping:Completeproductsinformationisstoredinthistable.
Orders:Customerorderedproducts,statusanddeliveryinformationisstoredinthistable.
5.
2DataObjectsUser:ID,UserName,Password,Email,RoleShopping:ID,Product,ProductID,Cost,Category,Image,DescriptionOrders:ID,Client,Product,Quantity,Price,Date,OrderShipped5.
3DatabaseTableDiagramDesignandImplementationofE-CommerceSiteforOnlineShopping185.
4Relationships:DesignandImplementationofE-CommerceSiteforOnlineShopping196.
0Non-Functional/OperationalRequirements6.
1SecurityPagesofthewebsitemustbeaccessinthewaytheywereintendedtobeaccessed.
Includedfilesshallnotbeaccessedoutsideoftheirparentfile.
Administratorcanonlyperformadministrativetaskonpagestheyareprivilegedtoaccess.
Customerswillnotbeallowedtoaccesstheadministratorpages.
6.
2EfficiencyandMaintainabilityPageloadsshouldbereturnedandformattedinatimelyfashiondependingontherequestbeingmade.
Administratorswillhavetheabilitytoedittheaspectsoftheorderforms,productdescriptions,pricesandwebsitedirectly7.
0Conclusion:TheInternethasbecomeamajorresourceinmodernbusiness,thuselectronicshoppinghasgainedsignificancenotonlyfromtheentrepreneur'sbutalsofromthecustomer'spointofview.
Fortheentrepreneur,electronicshoppinggeneratesnewbusinessopportunitiesandforthecustomer,itmakescomparativeshoppingpossible.
Asperasurvey,mostconsumersofonlinestoresareimpulsiveandusuallymakeadecisiontostayonasitewithinthefirstfewseconds.
"Websitedesignislikeashopinterior.
Iftheshoplookspoororlikehundredsofothershopsthecustomerismostlikelytoskiptotheothersite.
Hencewehavedesignedtheprojecttoprovidetheuserwitheasynavigation,retrievalofdataandnecessaryfeedbackasmuchaspossible.
Inthisproject,theuserisprovidedwithane-commercewebsitethatcanbeusedtobuybooksonline.
ToimplementthisasawebapplicationweusedASP.
NETastheTechnology.
ASP.
NEThasseveraladvantagessuchasenhancedperformance,scalability,built-insecurityandsimplicity.
DesignandImplementationofE-CommerceSiteforOnlineShopping20TobuildanywebapplicationusingASP.
NETweneedaprogramminglanguagesuchasC#,VB.
NET,J#andsoon.
C#wasthelanguageusedtobuildthisapplication.
FortheclientbrowsertoconnecttotheASP.
NETengineweusedMicrosoft'sInternetInformationServices(IIS)astheWebServer.
ASP.
NETusesADO.
NETtointeractwiththedatabaseasitprovidesin-memorycachingthateliminatestheneedtocontactthedatabaseserverfrequentlyanditcaneasilydeployandmaintainanASP.
NETapplication.
SQLwasusedasback-enddatabasesinceitisoneofthemostpopulardatabases,anditprovidesfastdataaccess,easyinstallationandsimplicity.
Agoodshoppingcartdesignmustbeaccompaniedwithuser-friendlyshoppingcartapplicationlogic.
Itshouldbeconvenientforthecustomertoviewthecontentsoftheircartandtobeabletoremoveoradditemstotheircart.
Theshoppingcartapplicationdescribedinthisprojectprovidesanumberoffeaturesthataredesignedtomakethecustomermorecomfortable.
Thisprojecthelpsinunderstandingthecreationofaninteractivewebpageandthetechnologiesusedtoimplementit.
ThedesignoftheprojectwhichincludesDataModelandProcessModelillustrateshowthedatabaseisbuiltwithdifferenttables,howthedataisaccessedandprocessedfromthetables.
ThebuildingoftheprojecthasgivenmeapreciseknowledgeabouthowASP.
NETisusedtodevelopawebsite,howitconnectstothedatabasetoaccessthedataandhowthedataandwebpagesaremodifiedtoprovidetheuserwithashoppingcartapplication.
DesignandImplementationofE-CommerceSiteforOnlineShopping218.
0References:1.
AnneBoehm,JoelMurach,Murach'sASP.
NET4WebProgrammingwithC#2010,4thEdition,Murach,2010.
2.
BryanSyverson,JoelMurach,Murach'sSQLServer2012fordevelopers,Murach,2012.
3.
http://www.
w3schools.
com/4.
http://msdn.
microsoft.
com/5.
http://agilemodeling.
com/6.
http://csharp-video-tutorials.
blogspot.
co.
uk/p/free-dot-net-video-tutorials-for.
html7.
http://csharp-video-tutorials.
blogspot.
com/p/free-aspnet-video-tutorial.
html8.
http://csharp-video-tutorials.
blogspot.
com/p/free-adonet-video-tutorial.
html