Khóa luận tốt nghiệp: Xây dựng website du lịch trực tuyến sử dụng ASP.NET MVC 4

BO CIAO DVC VA DAD T30

TRIIING D31 HQC THANG LONG

ar-aaans-----

KHOA LUAN TOT NGHIEP

XAY DING WEBSITE DU LICH TR!J'C TUYEN SIT DUNG ASP.NET MVC 4

: ThS. Trin Quang Duy

Ciao vien hinting din (cid:9)

Sinh vien thut hien (cid:9)

: Phan' Vinh An — A16788

Chuyen ngInh (cid:9)

: Khoa hos nuty ILA

HA NOI - 2014

all NO! DAU

Tnrac day viec lcinh doanh bin tour du ljch chi don than cic ding viec nhu quip 19 tour, at tour, thong ke doanh thu th8ng qua fay tb vi bang tinh excel... Tuy nhien, den khi nhu au di du ljch theo tour cult Mulch hang ngiy cing tang thi viec quitn 19 bang giey Os khang can hieu qua, viec quin 19 dot tour, doanh thu se rat nhieu thin gian vi thieu slit.

Ctng von viec ang dung CNTT duqc phit then moth trong nfrang nim vita qua, vi de dip *rig nhu ciu di du ljch ngiy cing tang tins kith hang vi riling cao hieu qui tong viec quin 19 tour, at tour hay tinh toin doanh thu... He thong lcinh doanh quin 19 bin tour true tuyen di duqc ra dbi.

He thong bin tour trim tuyen: la mOt phin he dinh cho khich !Ling Public c6 the book tour gift ch6 vi thanh toil) trot tuyen thong qua cic hinh thirc thanh town: Visa, ATM, vi dien term Nth do, tint hem rat nhieu Uri gian vi cong sac cho khich hing mei khi co nhu cAu di du ljch. Website du ljch Inc tuyen ii mOt the hien clut he Sang bin tour du ljch trot tuyen.

Sr ra din dm he thong bin tour trim tuyen di giup giim thieu lion the ye khang gian vi thin gian rat nhilu gills viec lien kit ban tour, tang khi Ming quin tri mOt cich hieu qui, &at thieu thOi gian cho than vien ding nhu ban quin tri, tang them doanh thu bin hing, gap phiin to citu nei gin ket khich ling vai cang ty du ljch, th8ng qua cic kenn thong tin da chi& WA nhieu lien ich, klvich hang c6 the tra cau cic thong tin du ljch trong vi ngoii nuOc ten website moi hit moi nai.

NO1 dung bio cio dirge chic 1km 5 chums chink:

1. TONG QUAN VE ASP.NET MVC FRAMEWORK

Giai thieu ye MVC vi qui trInh hoot dOng cult ASP.NET MVC Framework

2. D4C TA YEU CAU 111 THONG

Cic ac diem co bin cita he thong bin tour trot toy& vi ac ti yeu au he thong.

3. PHAN TECH THIET ICE HI THONG

Chuang nay bao gem tic giai (top ctia phlin phis) tich nhu: phan tich thiet ice CSDL, thiet Ice chat Wing...

4. lay DUNG CHtt NANG

Chuang nay di vao viec xiy dung co the tfmng chic ning cM he thong theo m8 hinh MVC bao gem cic: Model, View , Controller.

5. TRIEN KHAI iiNG DUNG

Chuang nay huOng din each milt bitn vi trien khai mOt img dung ASP.NET MVC.

2/971 HI thong bin tour du Ijch trvc to+

LEI CAM UN

Em xin chin thanh cam an bO men tin Toin - Tin twang Dai hoc Thing Long di

to dieu Iden cho em thvc hien di tai nay.

Em xin cam an they TAW Quang Duy, ngueri di ten tinh gitlp do chi be° em trong suot qua trinh thvc hien kh6a luon nay. Trong thbi gian dugs they hiding din, chi bao em de hoc hei duqc nit nhieu kien thtic bet ich ciin thief.

Mac do di co ging holm thin de di kh6a lualn vei tit al nii hrc cult ban than niumg chic chin khong thiku khei nheng thieu sot. Kith mong gut they c6 ten filth chi bao.

Mt t len nu e, em xin chin thinh cam on sv giip der cis gut they c6 va In& mong duqc sv d6ng Op qujr Mu dui tit ca moi ngutri de em c6 the lien b0 hon. Kirsh chile gut they co lute Won mph kh6e, g#t hai duqc nhieu thanh Ong trong sv nghiep.

Ha NOi, very 4 Acing 12 ndm 2014

Sinh vien Myr hien

PHAM VINH AN

3/97 I HI thong bin tour du Itch Inc tuyin

MVC LUC

8 DANH MUC CAC THU4T NGU VA it WET TAT (cid:9)

9

11 DANH MIJC BINH ANH (cid:9) CHUONG 1. TONG QUAN VE ASKNET MVC FRAMEWORK (cid:9)

11 1.1. Gi61 &leo ve ma hinh MVC (cid:9)

11 1.1.1. Cac thanh phan mia MVC (cid:9)

12 1.1.2. Hoot dang cia ma hinh MVC (cid:9)

12 (cid:9) 1.1.1 UY dam va nhitac diim cia MVC

13 1.2. G161 Mau vi ASP.NET (cid:9)

13 1.3. ASP.NET WebForm truyin thong (cid:9)

15 1.4. ASP.NET MVC Framework (cid:9)

15 1.4.1. Nguan gic (cid:9)

15 1.4.2. Clic thanh pion ca ban mia ASP.NET MVC (cid:9)

16 MVC (cid:9) 1.4.3. Qua trinh hoot (fang cia mat ang dyng ASP.NET

17 1.4.4. Mot so` &A rthng not bat caa ASP.NET MVC Framework (cid:9)

17 1.4.5. Liu dilm (cid:9)

17 1.4.6. Nhuvc diem (cid:9)

18 1.4.7. So sank gift ASP.NET webforn: va ASP.NET MVC (cid:9)

20 1.4.8. Khai km mai sing dyng ASP.NET MVC Framework (cid:9)

28 CHUC1NG 2. D4C Ti YEU CAU He THONG (cid:9)

28 2.1. TO sao con hi thong bin tour du Itch trwc tuyin (cid:9)

29 2.2. Cie dlic diem cc bin cia hi thong bin tour du itch trwc tuyin (cid:9)

29 2.3. Dec ti yeu au (cid:9)

29 2.3.1. Quan tc: Tour (cid:9)

32 2.3.2. Hart Tow (cid:9)

34 2.3.3. Qua 1, don dat Tour (cid:9)

36 2.3.4. Danh mite dia dam du lich (cid:9)

38 2.3.1 Quanoi tin ttic (cid:9)

40 2.3.6. Thong led (cid:9)

42 2.3.7. Quin li: tai khocin (cid:9)

4/971 Hi thong bin tour du gch1rwc tuyin

44

CHUONG 3. PHAN TECH TH1ET ICE HS THONG (cid:9)

44 3.1. PHAN TICH THEET Kg CO Sti Dtr LIP (cid:9)

44

45

3.1.1. M6 hinh quan he at lieu (cid:9) 3.1.2. Danh sach being va mo to (cid:9)

46

3.1.3. Bang Country (cid:9)

46

3.1.4. Bang ProvinceCity (cid:9)

47

3.1.1 Bang Location (cid:9)

47

3.1.6. Bang TourType (cid:9)

48

3.1.7. Bang TemplateTour (cid:9)

48

3.1.8. Bang TemplateTourDetail (cid:9)

49

3.1.9. Bang Tour (cid:9)

49

3.1.10. Bang TourDetail (cid:9)

50

3.1.11. Bang TourHotelDetail (cid:9)

50

3.1.12. Bang BookTour (cid:9)

51

3.1.13. Bang BookTourDetail (cid:9)

51

3.1.14. Being Account (cid:9)

52

3.1.15. Bang Customer (cid:9)

52

3.1.16. Bang News (cid:9)

53

3.1.17. Bang Hotel (cid:9)

53

3.1.18. Bang HotelRoomType (cid:9)

54

3.1.19. Bang BookRoom (cid:9)

54

3.1.20. Bang BookRoomDetail (cid:9)

55 3.2. THAT Kt CHfIC NANG (cid:9)

55

3.2.1. Trang cini. (cid:9)

12.2. Trang quan tri (cid:9)

60

65 CHIIONG 4. XAY MING CHOt NANG (cid:9)

65 4.1. CLu tric mil nguIn then 'den Ink MVC (cid:9)

4.1.1. Models (cid:9)

65

67

4.1.2. Controllers (cid:9)

68

4.1.3. Views (cid:9)

5/97 I HI thong bin tour du Ijch bye tuyin

69 4.2. Quin if Tour (cid:9)

69

4.2.1. Ca so. dit lieu (cid:9)

71

4.2.2. Models (cid:9)

73

4.2.3. Controller (cid:9)

74

4.2.4. Views (cid:9)

75

4.2.5. Javascript (cid:9)

76 4.3. Nit tour (cid:9)

76

4.3.1. Ca set dri lieu (cid:9)

77

4.3.2. Model (cid:9)

78

4.3.3. Controller (cid:9)

78

4.3.4. View (cid:9)

79

79

4.4. Quin ty don Chit tour (cid:9) 4.4.1. Ca sa de lieu (cid:9)

79

4.4.2. Model (cid:9)

80

4.4.3. Controller (cid:9)

80

4.4.4. View (cid:9)

81 4.5. Danh myc dja diim du Ijch (cid:9)

81

4.5.1. Ca so da lieu (cid:9)

82

4.5.2. Model (cid:9)

83

4.5.3. Controller (cid:9)

84

4.5.4. View (cid:9)

85 4.6. Quin If tin bit (cid:9)

85

4.6.1. Ca so at lieu (cid:9)

85

4.6.2. Model (cid:9)

86

4.6.3. Controller (cid:9)

86

4.6.4. View (cid:9)

87 4.7. Thong ke (cid:9)

87

4.7.1. Model (cid:9)

87

4.7.2. Controller (cid:9)

88

4.7.3. View (cid:9)

88 4.8. Quin If tii khoin (cid:9)

6/97 I HI th6ng bin tour du Ijch bye tuyin

88

4.8.1. Ca so. da lieu (cid:9)

89

4.8.2. Model (cid:9)

89

4.8.3. Controller (cid:9)

89

4.8.4. View (cid:9)

91 MIXING 5. MIEN KHAI (NG DVNG (cid:9)

91 5.1. Cic buoy trim khai (cid:9)

91 5.2. Trail khai VnTravel site (cid:9)

5.3. Clu Mph HS cho Framework MVC sdr dung microsoft web platform 92 installer (cid:9)

94 5.4. Them VnTravel site vio HS (cid:9)

96 'CET LU3N (cid:9)

97 TAI LI$U THAM KiiA0 (cid:9)

7/97 I HI thong bin tour du Lich tryc tuyin

DANH MIX CAC THU4T NGtY VA Tir WET TAT

ICI 1;11

(I.:\ (cid:9)

ilu

I 1111,11 11"11 (cid:9)

I II (cid:9)

(cid:9)

(cid:9) Nen tang Framework

(cid:9) HyperText Markup Language HTML

(cid:9) Uniform Resource Locator URL

(cid:9) Nen tang Platform

8/971 lif thong bin tour du lich tryc toy&

DANH MVC HINH ANH

11

Hinh 1.1 M6 hinh MVC (cid:9)

12

Hinh 1.2 Quy trinh hopt dOng cua mo hinh MVC (cid:9)

13

Hinh 1.3 Gong nghe ASP.NET WebForm (cid:9)

15

MA 1.4 Ccic think phdn co. ban cues ASP.NET MVC (cid:9)

18

!link 1.5 ASP.NET WebForm vi ASP.NET MVC (cid:9)

20

Hinh 1.6 Kheti 4w :Mg dim ASP.NET MVC (cid:9)

21

Hinh 1.7 HOp thogi New ASP.NET MVC3 (cid:9)

22

Hinh 1.8 Minh hpa mot Solution Explorer cilia ASP.NET MVC3 (cid:9)

23

Hinh 1.9 Giao dien ca ban khi chgy sing dim ASP.NET MVC c6 san (cid:9)

24

HIM 1.10 Kit nil ca so dit lieu bdng Entity Framework — Mak 1 (cid:9)

25

Hinh 1.11 Kit not ca so da lieu bang Entity Framework — buck 2 (cid:9)

25

Hinh 1.12 Kit nil ca ser da lieu ding Entity Framework — bulk 3 (cid:9)

26

Hinh 1.13 Kit ndi ca sit da lieu bang Entity Framework — buck 4 (cid:9)

27

Hinh 1.14 Kit ntli ca sb dit lieu bdng Entity Framework — bu6c 5 (cid:9)

27

Rink 1.15 Kit not ca sit dd. lieu bang Entity Framework — but 6 (cid:9)

30

Hinh 2.1 Quy trinh quern if; tour (cid:9)

32

Hinh 2.2 Quy trinh dOt tour (cid:9)

Hinh 23 Quy trinh pan lir don dOt tow (cid:9)

34

36

Hinh 2.4 Quy trinh gucin lf) dank mgc dja diim du lick (cid:9)

Hinh 2.5 Quy trinh quern OS tin tar (cid:9)

38

40

Hinh 2.6 Bao ctio thong ke (cid:9)

Hinh 2.7 Quy trinh quern ly tai khocin (cid:9)

42

Hinh 3.1 Ca so (Milieu wean he thing (cid:9)

44

'fink 12 Trang quern trj (cid:9)

60

61

Hinh 3.3 Danh sack tour (cid:9)

61

Ifinh 3.4 Them tour mbi (cid:9)

Hinh 3.5 Danh MIX dam du ljch (cid:9)

62

Hinh 3.6 Them meti diim du ljch (cid:9)

62

Hinh 3.7. Quern ly tin tic (cid:9)

63

63

Hinh 3.8. Them m61 tin tic (cid:9)

9/97 HI thong bin tour du Lich trim tuyin

Hinh 3.9 Chic ruing thong ke (cid:9)

64

Hinh 3.10 Form tham so (cid:9)

64

Hinh 3.11 Hein 114 kit qua (cid:9)

64

Hinh 4.1. du trac ma' nguan theo kiln trac MVC

(cid:9)

65

Hinh 4.2 Thu myc Models (cid:9)

65

Hinh 4.3 Thu myc controllers (cid:9)

67

Hinh 4.4 Thu myc Views (cid:9)

68

Hinh 5.1 Man hinh Publish Web (cid:9)

91

Hinh 5.2 Man hinh Iva chon platform de chi 114t.

(cid:9)

92

Hinh 5.3 Man hinh kilm tra thi eldt .NET Framework viz ASP.NET

(cid:9)

93

Hinh 5.4 Kiim tra cai &ft SQL server (cid:9)

94

Hinh 5.5 Internet Information Services (IIS) Manager

(cid:9)

94

Hinh 5.6 Add Website Dialog (cid:9)

95

10/97 I HI th6ng bin tour du lich tryt tuyEn

Ting quan in ASP.NET MVC Framework CHISCING 1. TONG QUAN VE ASP.NET MVC FRAMEWORK

1.1. Gild thilu ve m8 hit& MVC

Khi cac phan mem ing dung ngly cing phat trim lin manh vi da dang thi vin 41 thilt Ice kiln tnic cho plain mem cans trb non phis tap han. Nhftng ling dung web gib day cuing di phat then den mOt tam cao mei, ching khang con la nhOng img cb,mg web thong thuirng vii chic riling hien thi thong tin mi la thong he thong thong tin h6 trq nhftng tang web tuong tic v6i ngutri ding. Nhieu giii phap thiet ke kik tnic he thong duqc dui ra vii muc Bich lam cho he thong linh hoot, mem deo, de phat trien vi ten tai lAu dal. Trong do, giai phip thiet Ice theo m8 hInh kiln tic MVC dtrqc Trygve Reenskaug de xuAt vao nhftng niim 70 curt the ky 20 to ra rat hieu quit.

M8 hInh MVC (Model - View - Controller, Hirsh 1.1) la mOt kiln frac phial mem hay m8 hinh thiet ke duqc sir dung tong ky thuit phan mem. N6 ginp cho cac nha phat trier tack *rig dung cis hp ra thanh 3 phan khic nhau Model, View vit Controller. Mil thinh phin co mOt nhiem vu rieng bier va dOc yeti cac thimh phan khic.

LLL Ctic thank phlin cia MVC

View

S

Controller

Model

!link 1.1 Me hinh MVC

Model

Day 11 thanh phan chive tit ca cac nghiep vu logic, phuong thftc xir ly, truy xuat

database, ded ft:mg m8 to dft lieu nhu cac Class, him xir1y...

View

Dim nhan vier hien °tilting tin, Wong tic veri nguM ding.

Controller

Gift nhiem vu nh$n diet' huing cac you cau tft nguiri ding vi goi ding nhftng

phuang thirc xi lt chimg.

11/971 HI thong bin tour du Lich tryt tuyin

Tang quan vi ASP.NET MVC Framework LL2. Hoot Ong cdo m6 hind MVC

Diy 1>1 mOt each dun giro (HInh 1.2) di m6 tit lai luhng sq lden duqc xfr trong

MVC:

- User ttumg tic v6i View, bing citch click vio button, user girl yeu au di. - Controller thin vi (lieu huang chtmg den dung pinning thirc xir lt 6 Model.

- Model nh$n thong tin vi thqc thi cic you au. - Khi Model hoin tit vi.c xir it, View se nh$n ket qui M Model vi hien thi lei

cho ngubi dung.

Yaw (cid:9)

I Mad

I ICI

I (cid:9)

(cid:9)

Ars

I I

Ifinh 1.2 Quy trinh how dOng aia m6 hinh MVC

L L3. Os memo& taupe ttlim cola MVC

4, has Sm:

The hichi tinh chuyen nghiep trong lip trinh, phis tick thiet ke. Do duqc chin thbh cic thanh phin doc lop nen gulp phis trier img dor% nhanh, don gitin, de fling cep, bio

12/97 I Elf thong bin tour du lfch trim tuyin

Tang quan vi ASP.NET MVC Framework

49 Nktnyc tam:

Doi veal dg an nh6 v.** ap dung m8 hinh MVC gay ding kenh, tan thin gian

trong qua trinh phitt trier. Tan thbi gian trung chuyin di lieu glut clic thanh phin.

1.2. GM tbilu vi ASP.NET

ASP.NET la mOt nin tang ph& then img dung web (web application framework) dugs phat tan va cung cep WA Microsoft, cho phis') nhftng ngubi lop trInh too ra nheng trang web Ong, nheng img dung web va nhing djch vu web Lin diu den dugc dua ra thi trubng vac* thing 2 Mtn 2002 can vgi phi& ban 1.0 ctla .NET framework, la gong nghe n6i tiep ciut Microsoft Active Server Pages(ASP). ASP.NET dugc bier djch duel ding Common Language Runtime (CLR), cho phep nheng ngubi 11p trinh viet ma ASP.NET yen bit 10 nem net Mo duct ha trg bgi .NET language. 1.3. ASP.NET WebForm truyin thong

ASP.NET la mOt buck nhity vqt khi lin diu xuit hien, nhim thu hgp khoang catch gift phitt trier Window Form huOng dai tugng (c6 trang thai) Ara phat tan web huOng HTML (khong tang Hirsh 1.3 dual diy minh boa c8ng nghe ASP.NET Webform

ASP.NET Web Forms A MANI mom ponsats (poen, butons. a.) plus a 'OSA objutothensd pregansins model

ASP.NET web sew A way to hoe .NET **Mambas la NI (cid:9) product), MS you Inflict sib IMP mats ard response

MET

codapYtlarm

A (cid:9)

(bnandasw at die time-o Yet Irk In lb own right)

Ilink 1.3 Con nghe ASP.NET WebForm

Vgi Web Forms, Microsoft di c6 in di HTTP va HTML bang cach m8 phgng giao dien ngubi dung nhulti mOt d6i tugng dilo khan (Control) c6 ciu trac hoot dOng phis Server.

Mai &Si tugng diiu lchien (Control) theo doi trang thiti cite no th8ng qua cac you au (sir dung tinh nAng ViewState), bieu then bing chc ml HTML khi can thiet. Ninth ra, ng con to dOng lc& ntai citc sty kien phis Client (nhtr sit kien bim button) ten cac sly kien phis Server dugs xt1 15, Mang (mg. Thuc te, Web Forms lit mOt 16p trUu tugng lcheng 16 dugc thiet key de cung cep giao dien co xir sit kien th6ng qua Web.

13/97 I HI thong bin tour du lids traps tuyin

Ting quan vi ASP.NET MVC Framework

Nheng aim ban chi cilia ASP.NET Web Forms —ASP.NET Web Forms truyen thong tong lit mOt tutng rit t6t, nhung thvc to lai phit sink nheng dieu phirc tap khic. Theo thin gian, vile se dung ASP.NET Web Forms di neu bet 16n mOt se thieu set;

—ViewState: Co the duy tri bang thii thing qua cic yeu ciu (request) thubng mang lai ket qui la nhftng kh6i Ku:mg km de lieu duqc chuyen giao gift client va server. De lieu nay c6 the len den hang trim Kbs 6 mOt irng dung web yea phii, va n6 di qua loi yeti bit kir yeu ciu nio. Dieu nay lam chi= di then gian chit phin h6i va lim tang nhu ciu Wing thong ctia server;

—Page life cycle (Chu irk ten Au cea mOt tang web): Li cc the kit n6i sv kiln phis client yeti mi xu 19 sv kiln phis server. N6 phirc top va a bi phi ver, —Y thec sal ye vile tich bilt cic thimh phin: Me hinh code-behind clot ASP.NET cung clip meat giiti phip cho phep itng dtmg dua code ra khei cic clang HTML vao thinh mOt 16p code-behind rieng bolt. Dieu nay duqc hoan xir 1St. Nhtmg thvc te, nghenh rOng ran yeti vile tech bill giao dien yeti (cid:9) nheng nha phit trien duqc khuyen khfch pha trOn mi giao dien yeti mi xb ljr 1mg dung (nhu la xi: 15f CSDL) tong nheng 16p code-behind khing 16. Neu lcheng c6 sv tech biet gift cic thimh phin, ket qui culi cimg c6 the rot kh6 hieu;

—Limited control over HTML (giiri han hem soit HTML): Server control tv tao ra cic ml HTML, nhung khong phii la mi HTML ma ta mong dqi. Ngoai vile mi HTML ctia thing thubng kh8ng twin theo lieu chuim web hole lcheng sir dung t6t CSS ma he thong cic server control can too ra cic gii tri ID phirc tap vi kh8ng doin three duqc, lim lch6 khin tong vile sir dung JavaScript;

—Khi fling Idem the thlip: Cic nbi thiet ke cis ASP.NET kheng the dv doin ring kiem the tv dOng se to dulnh mOt phin tit yeu cea ?CU huong phat trien phin mem. Kheng ngoc nhien khi lden true chit chi ma hp thiet ke la kheng phe hqp yeti vile tick hqp ldem the.

ASP.NET vlin tip tµc pith tan. Phi& bin 2.0 them mOt thanh phin chuin di giam bat se lucmg code ma chting ta cin phil tv viet. Vol phien bin gin Whit ASP.NET 4.5, mqi the di duqc ning cop ding ke. Phien bin ASP.NET 4.5 di ip dung mOt s6 tinh Kiang dui ASP.NET MVC vao Web Forms. Tuy v$y, van con mOt han chi ten ton ben trong no.

14/97 1 HI thong bin tour du lfch tryc tuyin

Tong quan vi ASP.NET MVC Framework 1.4. ASP.NET MVC Framework

Nhu di giei thieu 6 plain truck, mo5 hinh MVC v6i tru diem ctla minh dit duqc (rug ding trong met so the framework. Trong d6 phii ki den ASP.NET MVC, met framework ma ngu6n me mei, ay ding tren ASP.NET .

ASP.NET MVC Framework duqc thvc thi tren m6 hinh model—view—controller (MVC). N6 gqn nap, de clang him di* phin giao dien, tich hop cac tinh :tang elm ASP.NET. MVC Framework duqc djnh nghla trong namespace System.Web.Mvc vat lit met phitn cua Wiling gian ten System.Web.

1.4.1. Ngudn gic

Tuy cling nghe ASP.NET MVC mai duqc phis thin nhung n6 c6 ljch sir lk dot Nen tang MVC duqc pith minh bin Trygve Renskaug, Ong di vitt trang giiy diu tien nOi ve MVC vio Mm 1978. Ban diu ne dirge Eli 11 Thing Model View Editor pattern, nhung sau de n6 duqc dot ten lai 11 Model View Controller pattern.

ASP.NET MVC llin diu lien suit hien d6 1:1 trong dtr in mil ngu6n me

MonoRail.

Ngu6n geoc th$t sv de cho ra din cling nghe Microsoft ASP.NET MVC 11 do Scott Guthrie (mOt trong nhttng nhit sang too ra ASP.NET ) tren chuyen bay den Austin, Texas de nOi vi hOi thito Alt.NET vio thing 10-2007.

Phien bin ASP.NET MVC 1.0 dirge ra d6i vio nilm 2009.

1.4.2. Cdc thank pun cc ban caa ASP.NET MVC

IP ASP.NET MVC Framework

Rink 1.4 Ccic thank pidm co bin ctia ASP.NET MVC

Models: Cac d6i tuqng Models lit met phlin ctla img dung, cac d6i tuqng My thiet lOp logic cita phin de lieu cUa itng ding. Thong thutmg, the d6i tuqng model liy vi ltm tang thii mkt model trong CSDL. VI dv nhu, met d61 tuqng Product (sin ph1m) se lAy dit lieu ttY CSDL, thao tic ton de lieu vit se cep nhet da lieu tit lai vie bang Products 6 SQL Server.

15/971 HO thong bin tour du ljch trot tuyin

Tang quan vi ASP.NET MVC Framework

Views: Views la cic thinh phin ding de hien thj giao dien ngutri ding (UI). ThBng thutmg, view dupe to dtra vao th8ng tin de lieu Models. Vi du nhu, view ding de cep nh#t bing Products se hien thi cic hOp von ban, drop-down list, vi cic check box dua ten tang thii hien tai cis mOt d6i taco% Product.

Controllers: Controller lit cic thimh plain dung de quin 19 tuang tic ngutri dung, lam viec yell model vi chon view de hien thi giao dien ngutri ding. Trong mOt irng dung MVC, view chi duce ding di hien th1 thong tin, controller chiu trich nhiem quan 19 vit dip tri nOi dung do ngutri ding nhip vtl Wong tic vei ngutri ding. Vi du, controller se quip 19 cic de lieu ngutri ding gel len (query-sting values) vit gfri cic gii tri d6 don model, model se lity de lieu ttl CSDL nhe via cic gii tri thy.

M8 hlnh MVC gifip chins to to duqc cic (mg dung ml ching phitn tich rach rdi cic lchfa canh elm ling dung (logic ve nhop lieu, logic xis 19 tic vu vit logic ve giao dien). M8 hinh MVC chi ra mOi loth logic ke ten nen dirge thiep 1#p b diu tren irng dung. Logic giao dien (UI logic) thuOc ve views. Logic nh#p lieu (input logic) thuOc ye controller. VI logic tic vu (Business logic —11 logic xi 19 thong tin, muc dich chinh coo ling dung) thuOc ye model. Su phin chia nay giUp ching to giitm bet ducm str phirc top cis tug dung vit chi t#p trung vio m6i !this cosh cin duce cii Olt 6 moi thbi diem. Vi du nhu citing to chi cin tip trung vim giao dien (views) ma kh8ng phii quan tam den logic xt119 thong tin dm img dung.

St: phin tich rach rbi ba thitnh phis mkt (mg dung MVC con &it cho viec 1#p trInh dien ra song song. Vi du nhu met lttp trinh visa Run viec vei view, lop trinh vien thin hth lo th dat logic cis controller vi l‘tp trinh vien this ba co the trung vao logic tic vu cia model tth cling mOt thbi diem. 1.4.3. Qud Dinh hog! qng cia mQt kw Ong ASP.NET MVC

Cie giai down thuc hien cia mOt (mg dung ASP.NET MVC duqc trhrh bity duei My:

—Nh#n yeu citu diu lien: Trong file Global.asax, the d6i Wong Route duqc them

vie RouteTable;

—Thyme hien viec djnh tuyen: Module UrlRoutingTable se dung d6i tuqng Route diu lien thich hop hung tip RouteTable de to d6i tucmg RouteData. D6i him nay sau de lei to ra d6i tutyng RequestContext (IHttpContext);

—Tao ra trinh xis 19 yeu cow ling dung: D6i Wong MvcRouteHandler too ra mOt

the hien dm lop MvcHandler vI truyin vac, no the hien RequestContext;

16/97 I HI thong bin tour du Ijch try tit+

T6ng quan vi ASP.NET MVC Framework

- Too ra controller: Cic d6i ttrqng MvcHandler sir dung the hien cis RequestContext a xic djnh dei tuqng IcontrollerFactory qua de to ra the

hien controller;

- Thuc hien vai trb cis controller. The hien MvcHandler goi phucrng tit

Execute ctia controller;

- Goi action method: D61 tucmg ControllerActionlnvoker se xic djnh action

method cos mOt lap controller de gqi ra.

L4.4. Mft sti tusk ming nii b91 cda ASP.NET MVC Framework

- Tich bitch cic tic At cita tang dung.

- Co khi ning ma rOng (extensible) & khi ning !thing (pluggable). Cic thinh phin cis ASP.NET MVC duqc thiet ke de ching c6 the ductc thay the hoic thy chinh mOt cich di ding.

- ASP.NET MVC c6 thinh pit inh xo URL mph me, cho phep cluing to xiy dtmg nheng ang dung c6 cic dill chi URL xfic Lich vi di dm kiem. Cic dia chi URL Icheing clin phii c6 pan ma rOng cis ten tip tin vi duqc thiet ke de h8 trq cic mitt djnh dung ten phi hop vii viec t•Si tm Ma tim lam (URL).

- H8 trq the fifth Jiang c6 sin cis ASP.NET nhu ea chi xic that ngubi clung, quin 1St thinh vier, quyin, output caching vi data caching, seession vi profile, quin ljr tinh nag img dung, he th6ng ceu birth_

- Ta ASP.NET MVC 3 con be sung mOt view engine mai lit Razor View Engine cho phep thiet lip cic view nhanh chOng, di ding vi ton it ding sue hart so vai viec su dung Web Forms View Engine.

L4.5. Liu dlim

- Di ding quin It su phirc top cia ang dung bing cich chia img dung thinh ba

thinh phial model, view, controller.

- H8 trq tot hon cho m6 With phit men bug dung huffing kiem thin.

- He th6ng djnh tuyin munh me. - H8 trq tot cho cic ting dung ducyc ay dung bai nhang dOi cd nhieu lip trinh

vier vi thiet ke mi yin quart ljr &Km tinh rang cis (ling dung.

- H8 trq nhiang tinh fling tot nhet di c6 a ASP.NET .

1.4.6. Arbirpc diEm

- KhOng huang den su lden lint cho cic nlul phit tan ASP.NET webform kh6

khan.

17/971 H, thing bin tour du itch trim tuyin

(cid:9)

Tong quan ye ASP.NET MVC Framework

— Yeu c.Au c6 hieu biet ve HTTP, HTML, CSS vi JavaScript.

L4.7. So sdnh gilts ASP.NET webfonn vb ASP.NET MVC

Hinh 1.5 ASP.NET WebForm va ASP.NET MVC

.Net Framework: ha trq cac loui img dung nhu desktop, web vi the img dung console.

ASP.NET framework lit mOt plan ctia .NET framework (Hinh 1.5), duqc xi)/ dung nh&m ha trq cic img dung Web (caching, authentication va authorization). Trong do, Microsoft c6 2 huong phis trios web tren n3 n ASP.NET la ASP.NET Webforms vi ASP.NET MVC. Muc dlch ra dbi cint ASP.NET MVC chi 11 str they d6i ve mat to duy, n6 'thong hotin Won thay the cho c6 img dung ASP.NET Web Forms,

vi vies chqn htrang silo de xay dung mOt website 11 thy thuOc vio cfc nha pith then.

Su kilo biet gifts 2 huOng pilot trim nay duce the hien du6i bang sau.

\I I \ I \

I (cid:9)

I \ I

I In!' n inn

(cid:9)

Cic str kiOn duqc dieu khiEn bei

(cid:9) (cid:9) St) dung cu phip cart phip (cid:9) webform, tit tic su kien controllers, clic controls lch6ng tong trinh

va controls do server quart do server quan

It

(cid:9) Debug chuong trinh phii Debug c6 the sir dung cat unit Debug

18/971M Meng bin tour du Itch twc tuytn

(

N I I (cid:9)

I

Tong quan vi ASP.NET MVC Framework

test ld tra cac phuung thirc thcc hien ci bao g c m

tong controller cic 16rp truy cep dli lieu,

sc hien thi, dieu Ichien cic

controls/

(cid:9) (cid:9) Thuen lqi KM kW) khan Twang tic vol

javascript

19/97111e th6ng bin tour du ljch trce tuyin

Tong quan vi ASP.NET MVC Framework 1.4.8. ladi mo mdi ung dpng ASP.NET MVC Framework

KW tao mOt itng dyng MVC

Trong bO phin mom Visual Studio 2010 dil c6 sin ASP.NET MVC Framework, to to

mOt do an mei theo dubng din sau: File > New Project > Visual C# > Web >

ASP.NET MVC Web Application (Mull 1.6).

Hirsh 1.6 Kltui tgo ring dyng ASP.NET MVC

20/97 HO thang bin tour du 46 Inrc tuyin

Tong cinan vi ASP.NET MVC Framework Sau khi him OK, hOp thoai New ASP.NET MVC3 hien ra (Binh 1.7).

Project Temkin

5dect a template

M

Desaiptiove A default ASP.NET INC 4 project wilt an A account cornets thd usestome authentication.

Basic (cid:9)

Empty (cid:9)

Intranet Application

ti W API Singk Page Facebook Application Application

Mobile (cid:9) Application (cid:9)

V

Is engine Rex

q peak a unit test project Test project name

MvcAppicationt.Tests

Additional Into

Test framework Yowl Stud* Mit Test

Cancel

4

Hinh 1.7 HO thogi New ASP.NET MVC3

Chung ta ce the chon kieu template la Empty, Internet Application hoc Intranet

Application. - Empty se nto ra nhang thu muc va tip tin tdi thieu cho ling dung MVC3. -

Internet Application se nto ra met ling dung c6 s6 trang mac djnh, cluing ta co the mkt d6i va xay dung tren no.

- Toy chqn Intranet Application cling tuong ar nhu Internet Application, niumg duqc coca hinh sin de stl dung trang mei tilting Vic thqc ngtrbi dan,g thong qua ha tang Domain/ Active Directory.

Chang ta cOng c6 the too project test cling vol ling dung MVC tir cling met cart s6.

Ben canh d6, ta cling ce the chqn the dO ViewEngine lh ASPX hoic Razor.

21/971 11f thong bin tour du ljch trite tuyin

Tong quan vi ASP.NET MVC Framework (3 day, ta chip Internet Application, Razor ViewEngine Ara Ichang chin unit test

project. Bern OK de holm tit.

Solution Explorer se hien ra nhu hinh 1.8:

Search Solution Explorer (Ctrl.;)

I; Solution 'Mvapprocationt (1 project)

properties 0 oil References APP-Data 0 la App_Strt 0 a comet

a Controllers S Akers

▪

0 a Images 0 la Models S Saipts Views favicon.ico GlobeLaux

• Padcart‘corlfig Web.config

I. (cid:9)

Rink 1.8 Minh boa mat Solution Explorer coo ASP.NET MI7C3

1)11'6 II"

Bang duel day ma to nOi dung throng din ctla met du in MVC Internet Apllication.

/Content

La thu muc thubng chtia nhftng dft lieu tibh, nhu la hinh imh, tep tin css,...

Visual Web Developer tu dung them thu muc Themes vac.

trong Content. Thu attic themes la thu muc chira cac tep

Jquery va hinh anh. Trong du an nay ta co the mkt thu

themes. Visual Web Developer et-mg them 1 file CSS cat vio du an ten hi Site.css trong thu muc Content. File CSS la file a Oa 'chi ta mu& thay tthi style ciut (mg dung.

22/97 I H. thong bin tour du 106 type tuyin

quan vi ASP.NET MVC Framework

1)111111" , I,111

(cid:9) G• m cac lep d china cac me hInh di i tuqng cua ling /Models

dung. Models quin lt vi than tic vOi din lieu.

Thu muc Script luu trit clic file Jan Script caa img dung. /Scripts

Mac djnh Visual Web Developer se dot thu muc nay lam

char' de chira cac file Jquery. File "modernize la file Javascript a h6 trq HTML5 vil CSS3.

Bien (itch vi chgy

Val viec lqa chon Internet Application tut dO, ling dung cim chang to d>i c6 dA chat

Wing ea ban. Hinh 1.9 la ket qui khi chang to chay the bing each bim F5:

** no*

• a Illibragiala

<- 6 * (cid:9) 01 Os *ma 411.1 0 Man la Ohs.- •06.1•Sane- • 2,4 6.10 Cr% Or CO M.,. • • • m• • n WO n Wes.ati (cid:9)

Noe we

”ntal

err. tent,' (cid:9)

'UT MVC acpleal.on

(cid:9)

;i

Home Page_ 14,1 (cid:9)

ansepeaelhambp

illitalleUeleelle1 (cid:9)

es es

flat (cid:9)

• ereeftwed

hisCleasnIM1IIIM1114004041Inillp 0.11.111a Ws.

teememenenswesprersienil 4.0•1•Anateinhak 41•01thinIM. (cid:9) Weems Isms. we atone ens ay

410 adialindolleM100111.11•ineedle

emovemase veentom neb bleyeamselenllineeVe lene•seee "nee epees a.m.

• pyis yam oft le ~ay wise ing UMW *SIN& MIMS.

sembanwasuina.

IBM 1.9 Giao then co ban khi chgy sing Ming ASP.NET MVC cd siin

23/971 111 th6ng bin tour du ljch trgc twin

Tong quan vi ASP.NET MVC Framework De dfmg chuang trinh, ta t6 hqp phim Shift + F5 hoec chqn Debug Menu vi churl Stop

Debugging.

Kit nii ea se de lieu SQL Server bing Entity Framework

ADO.NET Entity Framework lit mat non tang thgtc 611 dung de lam vies WA CSDL.

Chtng ta c6 the truy van, thao tic v6i database gian nap thong qua cic d6i trqng LSp

trinh.

Chiang ta se kit n6i CSDL bing Entity Framework Database First. N6 se to Ong too ra data model vit the 16p cho chfing ta tO mat CSDL c6 sin. Day 11 mat cich tiep can

ph6 Win vi no thuc hien don gian, nhanh ch6ng.

Trong cira si Solution click chuOt pith chun Add > New Item...

asp

7 (cid:9)

IS (cid:9)

5 (cid:9)

lic ActionResult About()

]fink 1.10 Kit di co. ser de lieu being Entity Framework - buoy 1

24/971140 thing bin tour du lich tnrc tuyin

'ding quan in ASP.NET MVC Framework Tiep then, clam AD0.1VET Entity Data Model, bim Add

Hirsh 1.11 Kit nil cast di) lieu bang Entity Framework— Mak 2

Giao dien Bien m nhu ben duel, bim Next

Hinh 1.12 Kit nil ca st dl? lieu bibtg Entity Framework - buck 3

25/97 I H. thong bin tour du Ifeh true MAI

Tong quan vi ASP.NET MVC Framework ara so mei hien ra, to chbn New Connection vit toy clum csic thong so. Sau db bim

OK

bets information to cane to the selected data source or crock 'Change to choose a different data source and/or pods

Des source:

Hama SCIL Sava (SgiChent)

Chine-

Sever time

V

(cid:9)

localhost

Log on to the saver

0 Use Windows Authentication

Use SQL Saver Authentication

fa

Lisa name

11101101110

Eases&

Elan rw/ Possivad

Comte to a database

0 Select or area database name

V

(cid:9)

I HQTND

0 Attach a di abase file

Logical name:

Adoncei-

Caned

OK

Lest Connection I

Hinh 1.13 Kit nit co sh rift life bring Entity Framework - buoy 4

26/971111 thong bin tour du gch trwc tuyln

(cid:9) (cid:9)

Tong quan ve ASP.NET MVC Framework Tiep then, ta chop Next

Geese Ye Da Game aft

lil

:P

1111doletecesclft sheeldpeurapplkaleneneumneecellelliedeleS

v I (cid:9)

Nay Connection—

141110.1CRINft (cid:9)

1

Of le (cid:9)

an* a Pau* (cid:9)

vest

mut is an (cid:9) a sulk (cid:9)

be (cid:9)

Mauna you ilk. Os (cid:9)

Sup (cid:9)

asiive eft (cid:9)

ceenechen (cid:9)

%min (cid:9)

This COMISCti011 Ilbing apemen to caftan senlitft (cid:9) lathe (cid:9) conned to the dabble. (cid:9) le indult this saliat dft in the connectft AS*

cede.

ny appic (cid:9)

Aft

Meg. I (cid:9)

von (cid:9)

ft ift (cid:9)

free (cid:9)

the conftedest (cid:9)

0 ft include flue deb (cid:9)

. Yet jade*, sesta deb Mho cennectft *leg.

bey

gybes

shftednts

undulates mar/Medebidedinagreselkftiftbftletladll noar/MaidaftlerlaftwaidecuseeDftSiossftoeviderceeraclion sceskocalhomenftl cftbupHOTPapwailt seneleinftlfturer klicsupftrande••••••••••;MultipleftivallodiftsTftespneelecentesedf

Save entity attention satingn (cid:9)

in Webteelig

as

a (cid:9)

Cad

bmsh

(cid:9)

tin (cid:9)

1 (cid:9)

4 be.411/ II (cid:9)

Hinh 1.14 Kit ndi co so dft lieu bang Entity Framework - but 5

Cu6i ciing, ta ham Finish dhoti thinh vies kit not teri CSDL tit SQL Server

anew Vour Dolidiesealeldebal Salop

NOSY delelmoodliocesdo pow awl to lied•do gour eat

I,Vie

Del Stored Procedures end Funaons

10 'eureka or singulamin govieeted object neneoe

Indudeforsiin kw columns into mood

10 breed soleclod shoed pocedures and fondions imbibe way model

Model Plernoepocs imarramas

Canal

Rinkat nai co so de lieu bibtg Entity Framework - but 6

27/97 I HI thong bin tour du lich trim tuyin

BSc ti yin au hi thong CHITONG 2. 03C TA Au cAu He THONG

2.1. TO sao din he thOng bin tour du Itch true tuyln

Tnrac ay viec kinh doanh bin tour du lich chi don than tic ding viec nhu quin lSr tour, dat tour, th6ng ke doanh thu th6ng qua eh tel vi bang tinh excel... Tuy nhien, an lchi nhu au di du lich theo tour cilia khich hang ngiy cling tang till viec quan 15, bing gay tel 'thong con hieu qui, viec quin 1ST at tour, doanh thu s8 met nhieu theci gian vi thieu sot.

Gang voi viec Crng dung CNIT duqc phit then mph trong nhftng nim vita qua, vi de dip Ong nhu ciu di du ljch ngiy yin tin curt khich hing vi ring cao hieu qui trong viec quin l5r tour, at tour hay tinh toin doanh thu... He th6ng kinh doanh quin ljr bin tour trip tuyen di duqc m deli.

He th6ng bin tour trim tuyen: li mOt phis he dinh cho 'dutch hang Public co the book tour gift ch6 vi thanh town trot tuyen th8ng qua mac hlnh thirc thanh town: Visa, ATM, vi dien tam NhO de, tiet kiem rat nhieu thiri gian vi Gong sire cho Idifich bring m8i khi co nhu ciu di du lich. Website du lich trim tuyen th met the hien dm he th6ng bin tour du lich MK tuyen.

Su m deli ctia he th6ng bin tour trip men di gin!, giim thieu hp the ve khong gian vi thoi gian rat nhieu gifts viec lien ket bin tour, ding lchi Wing quin tri mOt each hieu qui, giim thieu thei gian cho nhin vien tang nhu ban quin tri, tang them doanh thu bin hing, gop phin tao eau noi gin ket khich hang vai Gong ty du lich, thong qua cic kenh thong tin da chieu v6i nhieu turn ich, khich king co thi tm dm cic thong tin du ljch trong vi ngoii nubs ten website mqi 16c mqi nai.

28/97 I H. thong bin tour du lich trim twin

yeu an h th6ng

2.2. Clic d$c dam ca bin cilia hi thong bin tour du Lich Inc tuyen

Quin libur

Quin 19 don at bur

Quin 19 dash muc dikn du lich

mm pwrn )

Quint' anti mot Iduldi sin

Quin19ln tie

Quin Id an

Meth hang (cid:9)

Clan N) Si Main

Boo duo thong )

khich king

- Tim !dem tour theo cic tieu chi (Nai di, nai den, ugly di,...). - D5t tour, thanh than We tuyen.

Si vet quin tri vien

Quin it S tour du lick. Quin 1S, danh muc cic Q.* diem du lick. Quin 15rdon dkit tour.

- Quin 15, danh num lchich son. - Quin tin tirc, bii viol. - Quin 15, tii ichoin. Bio cio thong ke.

23. D#c ti yen con

2.3.1. Qudn ly Tour

Tang quan:

Chuc Ming cho phep Quin tri vien quin 19 cic thong tin ye tour (tour milu, chi

tint tour mAu, tour, chi tint tour).

29/97 I He thong bin tour du fich tree tuyin

Bic ti yin clu hi th6ng Quy trinh:

Ifinh 2.1 Quy trinh qutin 0 tour

30/971 Hi th6ng bin tour du Lich tryc tuyin

Bic ti yin ciu hi Ming

Mo t6 quy trinh:

Neu Tour chua tin Admin TOl

Thong tin ye Tour duct them vio trong th6ng, ngtrtri quirt tri se th6ng tin ye Tour

cop nhOtki danh sach them Tour mei

Tour

Th6ng tin curt Tour dirge MA Tour Khi th6ng tin Tour T02 Admin

cep nhlt vio h$ thong, thay d6i, ngteri quail

cjp nh$t lai danh sitch It se cop nhOt lai

thong tin this Tour. tour

X6a Tour ra lchei he Admin MA Tour Ngtrtri quart ltthvc T03

thong, Cop nhot 13i danh hien x6a Tour

sitch Tour

Chi tilt ctic yeti c4u

• Liet ke danh sich Tour

th6ng hien thi clic thong tin de tour duce ltru trong • M6 to yeu eau: (cid:9) CSDL.

• ac thong tin can quart hien thi cat thong tin ca bin this Tour • Cac thong tin vi Tour

• M6 to yeu eau: Ngtrtri dimg chon loci Tour, he thong hien thi danh sich cac Tour theo loci Tour nib ngubi thing chon

• Cic thong tin can quin 1Sy:

o Ma tour o Lodi tour o Ten Tour o Mots o NOi dung o HInh tut o Sti ngity o Gilt tien o Phuan den o Noi xuSt phat o Diem den o Ngiy thing tin

31/97 I Hi thong bin tour du Itch tryc tuyin

1:4c ti yell au he thing 2.3.2. Mit Tour

Tang quan: Chirc tiling Cho phep kWh fling at tour du ljch ten trang chi! cila he thing.

IChich hang tint Idem vi Iva chip tour mute ding kj vi tier' Wing ding Icy.

Quy Dinh:

Hinh 2.2 Quy trinh ?Mt tour

32/971 HI thing bin tour du Itch trite tuyin

D$c ti you clu bil th6ng

Mci to quy trinh:

MA tour mu6n 4t

Mich hang chip Tour

DT01

1Chich

mu6n di tfr dash sich

Hang

Tour

Ithich hang nlajp DT02 1thich

nhttng thong tin duqc Hang

you ciu de dat Tour

Tao don d#t Tour Sau khi nh#p thong tin, Thong tin tie DT03 Kith

va hien thi tMng he th6ng kiln' tra tinh lchach hang, Hang

bio Oa thenh ceng hop 10 sau do tao dun Tour muon

4t Tour men vi luu tai 4t, chuyen

tong csdl di

33/97 I H{ thong bin tour du Ijch trim tuyin

Bic ti yin ciu hi thong 2.3.3. Quer, V don dot Tour

Tang quan

Chtic Wing cho phdp Quin tri vien quan 15, cac darn dat tour dm kWh hang.

Quy :rink

Rink 2.3 Quy trinh pain if don ddt tour

34/97 I 11f th6ng bin tour du Ijch trim tuyin

ti yeu au thong Mo tie quy trinh

Khi th8ng tin don at

Thong tin cult don d#t MA don DDT01 Admin

Tour dtrqc cep nh$t yao Tour they d6i, ngutri at Tour

he thong. quin 19 se cop nh$t lei

thong tin elk don.

X& don at Tour ra Ngubi quart ly thuc MA don DDT02 Admin

kW:4 he th6ng. Cep hien x6a don at Tour at Tour

nh$t lai danh sich don

at Tour.

Chi tilt yeu cdu

• Liet ke danh sich don at Tour

• M8 ti yeu (cid:9)

Ngubi dung chon hien thj danh sich loai Tour, he thong se hien thj th8ng tin ye danh sich cic don at Tour then thir to sip zip ngay thing gum din.

• Cic thong tin an quin ljr: hien thj cic thong tin co bin cos don at Tour

• Cie thong tin yi Tour

• M8 tit you ciu: Ngubi dung chon loai don at Tour di xic nhen hay chug xic nh#n, he thong hien thj danh sich cic don at Tau then loci don ma ngubi dung chon • Cic thong tin cin quan o Ten lchich hang o Email o s6 dien thoo o Dia chi o Ngity ding lcjr o S6 tre em thaw gia o S6 ngtrai len o Ngay lchei bath o Ngay ket thtic o Ma Tour o Ghi chti

35/97 I H. thong bin tour du Itch trnt tuyin

DSc ti yeu au he thong 2.3A Danh awe dja aim du lich

Tang quan

Veri chirc Wing nay quip tri vien co the quip 1S, thong tin ve cic dia diem du Lich

then the Tinh/Thinh pho - Quec gia.

Quy Dinh

Hinh 2.4 Quy trinh Dian ly$ dank myc dja dam du lick

36/97111f thong bin tour du ljch snit tit*

B#c ti yeu ciu he thong

Ma to quy trinh

Thong tin ve diem du lich DDLO I Admin thong tin

duct them vio trong he Neu Tour chug the tai, ngubi quen tri ve diem

thong, cep nhet 13i danh

se them diem du

du lich

sitch diem du ljch lich maxi

Thong tin coa diem du !Chi thong tin diem MA diem DDL 02 Admin

lich duqc cep nhet vio he du lich

thong. du lich thay doi, ngubi quit It se

cep nhet lai thong

tin cua Tour.

X6a diem du ljch ra khoi MA diem Ngubi quin It thvc DDL 03 Admin

he thOng. Cep nhet lai du lich hien x6a diem du

danh sich diem du lich lich

Chi hit yeu cciu

* uet ke danh sich dia diem du lich

• M8 tit yeu ciu: He th6ng hien thi cac thong tin cac diem du lich duqc luu trong CSDL.

• Clic thong tin cin quitn It: hien tlli clic thong tin ccr ban cos diem du lich

•:* Cac thong tin vi diem du lich

• M8 ti yeu cliu: He thong hien thi cac thong tin clic diem du lich duqc luu trong CSDL.

• Cic thong tin cin quin It: o MA tinh/thanh pht• o MA diem du lich o Dian giii o Binh (nth

37/97114f thong bin tour du lich trim tuyin

DSc tit you au he *kg 23.5. Quiin gn tin tar

Tang quan

Voi chirc Wing niy quite tri vien c6 the too mai, cep nhat, x6a dm tin tic du lich,

khuyen moi.

QUY trinh

Hinh 2.5 Quy trinh quart 0 lin nit

38/971 111 th6ng bin tour du gch trut tuyln

Dr ti yin can hi thong

Ato to quy trinh

NOi dung ve tin duqc NOi dung 1701 Admin

them vac) trong he Neu tin chua ten tai, ngubi quail tri se tin tile

thong, cop nhOt lai them tin mai

danh sich tin

Admin

NOi dung dui tin dupe KW nOi dung tin tin Ma tin T1'02

cap nhet vito he tilting, they d6i, ngubi quin

cop nhat lai danh sach 19 se cop nhtt lai

tin thong tin ctia tin.

X6a tin ra khei he Ngutti vim 19 thac Admin Ma tin T"TO3

thting, cOp nhtt lai hien x6a tin

Chi tilt yeu cciu

danh sich tin

• Liet ke danh sich (tit diem du Lich

• M8 ti yeu ciu: Mar& thing chip lord tin, he thong hien thi danh sich the tin theo lo3i Tour ma ngubi dung chin.

• Cie thong tin cAn quin ljr: hien thi clic thong tin co ban caa tin.

• Cie thong tin vi tin tire

• M8 ti yeu au: Ngutri dung chin logi tin, he th6ng hien thj danh sich clic tin theo loai Tour ma ngubi dung chop.

• Citc thong tin can quin ly:

o Ma tin o Lodi tin o NOi dung tom tilt o Ned dung chi flit o Ngutri thing o NO), citing

39/97 I Hi thong bin tour du Itch tryc tuyin

Blic ti yen con he thong 2.3.6 Thing ki

Tong quan

\Teti chum nAng nly quan tri vien ce the then dei duce clic tour then doanh thu, An

khich cling nhu it An Iduich de dieu chinh clic tour mOt cAch hop lt.

Q1/401 trinh

Hinh 2.6 Bao alo thing ki

40/97 I 111 thong bin tour du Ijch trim tuyin

BSc th you cilu ht thong

Mil td guy trinh

Th6ng ke doanh thu Admin TICBCO 1

Doanh thu tong khoing thbi gian Khoing then gian

Admin TICBCO2

Th6ng ke tour An kWh, it An khrich

Admin TKBCO3

Khoimg thbi gian Th6ng ke tour it An kWh

Danh Bach tour it An khach trong khoang thbi gian

Admin TKBC04

Th6ng ke tour An Bach Khoang thbi gian

Danh Bich tour An kWh trong Ichoing thbi gian

Chi tilt yeu dui

• , Danh sich bio do thong ke

• M8 tit you cAu: Liet ke danh sich tit° cao them cac tieu chi dm kiem khic nhau.

• Cie thOng tin an quan ly: thong tin di lim tieu chi th6ng ke

o Khoang thbi gian o Th8ng tin tour o Doanh thu

41/97 I HI th6ng bin tour du Ijch trite tuyin

BSc ti yin ciu he thting

2.3.7. Qudn 15 tell khodn

Tang quan

Voi chirc wing quitn It tai Ithohn, quitn tri vien co the quart lt danh each cac tali

khan tang he thong.

Quy trinh

Kush 2.7 Quy trinh vain 0 tat Idtolut

42/97 I HS thong bin tour du Itch trim tuyEn

Dr tai yen con he thong Me to quy trinit

, ...._

Thong tin ye Oki khoin Admin Thong tin Neu di khoitn chua T01

duqc them vito tong he di khoin ten tag, ngttati quim

th6ng, cop nhot lid danh tri se them tai khan

sich tai Ichorin mai

Thong tin cua tai khoin Admin IChi thong tin tali Ma thi T02

Ichoan thay d6i, duqc c#p nh$t vac, he khoin

th6ng, c$p nhot lai danh ngubi quitn 1S, se c‘p

nhtt lui thong tin sich tai khotin

caa di khoin.

X6a tii khoin ra Ichtri he Ma tii Ngubi quan lt thuc T03 Admin

hien x6a tii lchoitn th6ng, Cop nhilt lui danh khoin

sich tai khoin

Chi tilt yeu cdu

• Danh stich tali khoin • M8 ti yeu ciu: Liet ke danh sich tali khoin theo tieu chi tim kiem. • Ctic thong tin an quitn Cie thong tin cila tali khan dung de lam tieu chi tim kiem

• Clic thong tin chi fiat cim tai khoin

• M8 ti yeu ciu: Clic thong tin mkt tai khoin cin quart 15, (duqc nh#43 vio he th6ng khi them mei tii khoin)

• Cie thong tin ell quan lt: o Hq %fa Ten o New sinh o Glen Tinh o Dja chi o S6 dien thoui o Quyin hen o Username o Mat Ichiu

43/97 I HI thong bin tour du Lich Inc tuyin

• •

Phan tick that ki hi thong CHUUNG 3. PHAN TICH THAT Kt HS THONG

3.1. PHAN TICH THAT ICE CO SO Dv LIEU

3.12 MS Isiah quan he dit lifu

goy AS • Ara

A.

Ass

len S

ITT

AS.

,M1111411

Too011ooSsOme

Sanwa

SoloolO

BIIIVIMMANDON_

[SS

I ISOoonOwle

BSc SO

boas.

Ti

NolibmSsO

O

S

AW10.11=

• SO

MOSS

SolloSon

Csoilso As ra

or Soo

InkTASII sofa I wns

CS

1n1••n•••

Caaabr I SD

Sas

—

U

JIinh 3.1 Ccf sb dfr li#u tan hg thing

44/971 Hi thong ban tour du Ijch tier twin

Phin tick that ki hi thong

Danh sack bang va ma tel

IA

NI (cid:9)

I u m Raw , (cid:9)

II (cid:9)

Danh muc cic Tinh/Thanh ph6 ProvinceCity 2

Danh sich 1* tour TourType 4

Chi fiat tour mkt TemplateTourDetail 6

Chi dot tour TourDetail 8

Dan at tour 10 BookTour

Danh sich tIi khoin (quart tri) 12 Account

Danh sich tin tic 14 News

Loci phing theo khich sun 16 HotelRoomType

Chi tint (tat phong 18 BookRoomDetail

45/97 I He thiSng bin tour du Itch bye tuyin

Phin Lich that ki h th6ng

Country

3.L3. Bang Country

Description

Length Mow NuUs Default Value

Column Name Data Type

PK_Ma qu6c gia

q

20

varchar(20)

e CountrylD (cid:9)

Ten qu6c gia

128

CountryName nvarchar(128)

Diin gild

16

ntext

Description (cid:9)

Anil del then

128

nvarchar(128)

Image (cid:9)

Anh 1

rwarchar(128)

128

[Image 1] (cid:9)

Anh 2

nvarchar(128)

128

[Image 2] (cid:9)

Anh 3

nvarchar(128)

128

[Image 3] (cid:9)

Ann 4

nvarchar(128)

128

[Image 4] (cid:9)

128

nvarchar(128)

Tag (cid:9)

q El Ri RI I? Ri RI IRI 0

ProvinceCity

3.1A Bring ProvinceCity

Description

Length Mow Mt Default Value

Data Type

Column Name (cid:9)

PK_MA tinh *inn

¤

q

ProvinceCitylD (cid:9)

vardlar(—

20

Ten tern thank

q

128

ProvinceCityName nvarchar._

Fltihu0c qv& gia rub

q

20

varchar(-.

CountrylD (cid:9)

Dan giii

16

ntext

Description (cid:9)

128

marcher...

Image (cid:9)

Anh did diem Anh 1

nvarchar.“

128

[Image 1] (cid:9)

RI RI I?

Anh 2

nvarchar...

128

[Image 2] (cid:9)

Ann 3

nvarchar...

128

[Image 3] (cid:9)

IRI El

Anh 4

nvarchar...

128

[Image 4] (cid:9)

La not Mei harsh?

1

((0))

bit

IsStartPlace (cid:9)

128

nvarchar...

Tag (cid:9)

RI R1 I?

0

ak rang buck

I el l OH

46/97 I HI thong bain tour du Ijch trtrc twin

Phin Lich that ki hi thing 3.L5. Bong Location

Location

Description

q

PK_Ma tkem du kb

Data Type varchar(20)

Length Allow Nuts Default Value 20

Column Name LocatioND

Ten dilm du lich

q

nvardiar(128)

128

LocationName

Fklhutic tinhithiiiih oho nag

q

20

vardwr(20)

ProvinceCitylD

DO chi

128

nvarchar(128)

Address

16

Ned

Description

Efl

iwardiar(128)

128

Image

Dian gal Ann dal *in Anh 1

128

nvardwr(128)

[Image 1]

Anh 2

nvardwr(128)

128

[Image 2]

Anh 3

nvarchar(1 28)

128

[Image 3]

I?

Anh 4

nvarchar(128)

128

[Image 4]

128

nvardwr(128)

Tag

Efl

Nyi tliiii

Coe rang budc

TourType

3.1.6. Bdng TourType

Description

Column Name Data Type Length Allow Nulls Default Value (cid:9)

q

(cid:9)

PICMS Iasi tour

varchar(2— 20 (cid:9)

I TourTypelD (cid:9)

q

(cid:9)

Ten loci tour

TourTypeNa— nvarchar(— 128 (cid:9)

(cid:9)

Diin giii

16

ntext (cid:9)

Description (cid:9)

nvarchar(— 128

Tag (cid:9)

47/97 I HI thiSng bin tour du Lich tnrc tuyin

Phin Lich that ke hi thong

Template Tour

3.L 7. Bdng TemplateTour

Description

Data Type

Length Mad Nub Debult Value

Column Name

q

PICKS tour miu

V TemplideTourID

varcharf2—

20

q

TM tour

marched_

128

TourName

TourTypelD

varchar(2—

20

4

TourDuration

int

16

FILThudc loci tour nio TM gian Ma Si tour (tfnh then ngiy) Dign giii

Description

ntext

Image

marched—

128

Anh dpi drain Anh 1

128

nvarched—

Anh 2

marched—

128

Ann 3

nvarchad—

128

Anh 4

(Image 11 (Image 21 (Image 31 (Image 4]

nvarchad—

128

q RI GI RI 131 RI 121 Ea q

CreatoriD

varchar(2—

20

FK,Ngtfill to

0

Nisi lunL;

Cele rang buk

(cid:9)

Lien ket khea ngoai yeti Mktg AccountID b bing Account

CreatorlD

Tern plateTotirDetail

3.1.8. Bing TemplateTourDetail

Desaipdon

Column Name (cid:9)

Data Type Length Mem Nub Delatdt Va— (cid:9)

111 TemplateTourDetailD (cid:9)

verdure— 20 (cid:9)

TemplateTourlD (cid:9)

verc1ar(2— 20 (cid:9)

LocationID (cid:9)

varcher(2— 20 (cid:9)

4 (cid:9)

PILMI chi tilt tour FK_ThuOc tour ink nao FK_Thutic (Wm du 101 raw DM vio ngby thd mb Ms tour

Duration (cid:9)

int (cid:9)

The td

int (cid:9)

4 (cid:9)

(Order) (cid:9)

q (cid:9) q (cid:9) q (cid:9) &I (cid:9) a (cid:9) 0

Cow rang buOc

I 1•Il CI11

v iii Alin_

(cid:9)

48/971 HI thong bin tour du Itch tryc tuyin

Phin tich that ki hi th6ng 3.1.9. Bang Tour

Tour

Description

Default Value

Allow Ha

Deb Type

Length

Column Name

MIAS taw

q

20

varchar(20)

Twat

RL.Thutic tour miu nb

q

TemplateToudO

vardwt2O)

20

q

Ngly kid hlnh

3

DepartureDate

date

q

S6 Idsich tar da

4

int

NumberSeats

Gii tan natal Idn : >413 tu&

AdultPrice

money

800

l

em: tir9 din 12 tub

money

Chadthice

ODll

g g

8 8 8

BabyPrice

money

Gil em bt ttl 3 din 8 tudI Gib tsi ad sink titt 0 6612 tub

money

8

Infanta

((0)) (N'Opssi

TM tang tour (OpertActivhCana4Close)

I g

20

nvarcher(20)

Giim gii hay bat 1 V giim g t 0 la ladng glom gia

1

bit

Status swop

q

vardw(20)

20

CreatodD

R-41181140 tour

128

nvardter(128)

Tag

Ccic rang buoc

\ni a l um

(cid:9)

Lien kit Ich6a ngoai vOi trubng AccountID 6 bang Account

CreatorID

TourDetail

3.1.10.8dng TourDetail

Description

Mow Nulls Default Value (cid:9)

Data Type Length

Column Name

¤

(cid:9)

Plc_Mil chi tilt tour

TourDetailID

varchar(2— 20

(cid:9)

FK,Thu(ic tour Ma

varchar12— 20

TourlD

(cid:9)

F1(_Tai dittm du lich neo

varchar(2— 20

LocationID

0 0 0

Di bIng phddng ben 91

marchar(— 20

Shippinglnfo

Chi phf di tai

money (cid:9)

8

ShippingFee

Clic rang bu¢c

\

(cid:9)

Ii II rail

(cid:9)

Lien kit kb& ngoai veri trubng LocatitonlD 6 bang Locatiton

LocationlD

49/971111 th6ng bin tour du Itch tryc Wyatt

Phan tich thiet Id hi thong

3.1.11.1161g TourHotelDetail

TourHotelDetail

(cid:9) (cid:9)

Description

Data Type Length Allow Null Debutt Value

Column Name

q

(cid:9) ¤

Plf_MI chi Mt Ithech son theo tour

TourHotelDetailiD varchar(2— 20 (cid:9)

q

(cid:9) (cid:9)

FK,Thuftc tour nio

varchar(2— 20 (cid:9)

TourlD

q

(cid:9) (cid:9)

Rib diem du fich Mo

varchar(2— 20 (cid:9)

I.ocationlD

q

(cid:9)

FlcLob phi ng tai Idled) son So

HotelRoomTypelD varchar(2— 20 (cid:9)

q

(cid:9) (cid:9)

4 (cid:9)

lid (cid:9)

NumberRooms

55 MON PROM

0

Cat rang bu¢c

\ ill (Imp ,

I I'll C1 . 11

(cid:9)

(cid:9) Lien kit Ich6a ngoai v6i trubng LocatitonID b bang Locatiton LocadonID

BookTour

3.1.12.Bong BookTour

Desaiption

Length Mow Nulls Default Value

Column Name Data Type

q

¤

Plf_Mi at tour

varchatt2—

20

BookTourlD

FILES tour neo

q

varchar(2—

20

Tou rID

FILKhach hang Mt tour

q

varcbar(2—

20

CustomerlD

Ngiy Mt tour

(geMate())

datetime

8

DateSook

56 ngifte Idn

4

AduftNumbers

int

56 tre em

ChildNumbers

int

56 em be

BabyNumbers

int

4 4

S6 tre sd sinh

4

lilt

InfantNumbers

IR1

1: Qt thanh than 0: thta thanh ken

1

Payment

bit

Phirdng thdc thanh than

nvarchaft—

128

PaymentfAtt-

Ghi chd

nvardtaft—

255

Memo

0

Cat rang buoc

\ 1 . 1 (cid:9)

III I.!

(cid:9) Lien ket Ichea ngoai yeti trubng CustomerID er bang Customer CustomerID

50/97 I Hi th6ng bin tour du Lich bye twin

Phin deb that ki h4 thong

3.1.13.M:2g BookTourDetail

BookTotirDetaii

Desaiption

Column Name Data Type

MN& dii tilt dit tout

¤

flookTourDe-

vardtar(20)

Length Mow Nuk Default Value 20

20

yarchar(20)

BookTourlD

Tan Idiatti hang

128

nvarchad-

ContactName

8

datetime

NAY Ilinh

DateOfflirth

Gia &A: 0-NCtl -Nam

4

Gelder

int

0

0-Ngig6 16m1-Tre ema-Em bk3-Tre so sink

4

iM

Personkind

Dia chi

128

Address

twarthad-

0

Cac rang bu¢c

\ 4'1 ill1111,1

I int 1-) i

3.1.14.Bang Account

Account

Desaiption

Default Value

Allow Nulls

Column Name

Data Type

Length

PK_Mi tii Ichoin

q

¤

20

varchar(20)

AccountiD

q

Tin ding nhip

30

nvarchar(30)

Usemame

q

Mit khlu

50

vardur(50)

Password

Tin

128

mrarchar(128)

First name

128

nvarchar(128)

Lastname

NO vi dlrn Dia chi

255

nvarchar(255)

Address

56 ditn thosi

30

rwardur(30)

Phonetic,

2

128

nvarchar(128)

Email

DIa chl email Cip eto Quyin Quin tri

4

int

[Level]

2 0

51/97101 thong bin tour du Itch Ulm tuyin

Phan tich that la hi th6ng 3.1.15.Bdng Customer

Customer

Desaiption

Default Value

Length Mow Nulls

Column Name Data Type

PK_Ki khich hang

20

varchar(2_

T CustomerlD

Tan lien he

128

nvarchad—

ContactName

NA, sinh

3

date

BirthDate

Dia chi

255

nvarchar(—

Address

S6 dulng minh thd

30

nvarchar(—

IdentityNo

Sd dien thoai

30

nvardad—

PhoneNo

Dia chl email

128

nvarchar(—

Email

Tan Mug nh$p

30

nvarchad—

Username

Mat khiu

50

Password

varchar(5—

Di gang

maraud—

30

CellPhone

q RI El li3 IRI IA I? Iiii El 1311 0

News

3.1.16.Bting News

Description

Length Mow Nulls Default Value

Column Name Data Type

PK MS tin Vic

q

varchar(2—

20

NewsID

Loai tin

q

nvarchar(—

128

NewsType

Tieu dl tin

q

nvarchar(—

128

Title

Anh del dien

128

nvarchar(—

Image

N0i dung vat tat

q

16

ntext

[Content)

q

Nei dung chi tilt

16

ntext

Detail

Ngay ding tin

(getdateO)

8

datetime

DatePosted

Nglid clang tin

q

varchar(2—

20

CreatorlD

128

nvarchad—

Tag

Ciro rang Ingic

\

Inn2

I

I (cid:9)

52/971111 tiding bin tour du itch Ulm tuyin

Hotel

Phin Itch that Id h thong 3.1.17Bong Hotel

Description

Default Value

ANow Nub

length

Column Name Data Type

¤

&MI Ichich san

20

HotelID

varchar(2—

Tan Ichich san

HotelName

rwarchag—

128

FR_Thudc dnh/thanh phd

20

ProvinceCitylD

varchar(2—

Dia di

nvarcharl.

128

Address

so then that,'

30

Phonetic

rwarchag—

Dirt gib

16

ntect

Description

Anh dai din

128

rwarthag—

Image

Anh 1

(Image 11

nvarthar(—

1 28

Anh 2

128

warthog—

(Image 2]

Anh 3

128

(Image 3]

nvarchag—

Anh 4

[Image 4]

nvan:hag—

128

128

Tag

'warthog—

a a a a a a a a a

(cid:9)N

\

(hi

Clic rang bu¢c

HotelRoonitype

3.1.18.Bdng HotelRoonType

Description

Column Name (cid:9)

Data Type

¤

Plc_Mi loci phi:mg Iduich son

HotelRoomTypelD (cid:9)

varthar(2—

length Mow Nub Dobult Value 20

0

Tin Ioai phong Ichach son

128

HotelRoomTypeNarne (cid:9)

nvarchad-

FICJhudc khkh san nao

vardiar(2—

20

HotelID (cid:9)

Gil thud (1 ngiy)

8

Price (cid:9)

money

StS pheng con trdng

int

4

Emptykooms (cid:9)

16

Dein gib

Description (cid:9)

men

Anh

Image (cid:9)

nvarchag—

128

Anh 1

[Image 11 (cid:9)

nvarchag—

182

Anh 2

128

'warthog—

Omit, 21 (cid:9)

Anh 3

nvarchag—

128

[Image 3] (cid:9)

Anh 4

128

(Image 4] (cid:9)

wardwg—

Tag (cid:9)

nvarchag—

128

0 0 a a a a a a a

53/971 HI thong bin tour du lich bye tuyin

Phkn tich that kE he thong Clic rang buck

I

I k it (cid:9)

3. /.19.Bing BookRoom

BookRooni

Description

Default Value

Length Mow Nub

Column Name Data Type

q

PILMi dat ph6ng

varchar(2—

20

BooldloomID

R_Mi With hang

varchar(2—

20

CustomerlD

0

8

DateBook

datetime

Ng•iP 041

(Slaldek0)

Ngay nhan paling

ChedclnDate

date

3

Ngay tri phting

ChedcOutDate date

3

1: d3 thanh ban. 0: chits thanh to

Payment

bit

1

65

Phildng thdc thanh wan

PaymentMet.

nvardiar(—

128

0

Cac rang En*

3.1.20. Bing BookRoomDetail

BookRoomDetail

Description

Data Type Length Mow Nub Defauk Value (cid:9)

Column Name

(cid:9)

PILM8 dat phang chi at

marchad— 20 (cid:9)

7 BookRoomDetaillD

FR_Thugc ddri dot phong nao

BookRoomlD

vardur(2— 20 (cid:9)

q q (cid:9) q

(cid:9)

FILLoai phOng Wadi sin nao

HotelRoomTypelD

vardiar(2— 20 (cid:9)

q

(cid:9)

Sd phting dat

10 (cid:9)

NumberRooms

ncha r(10) (cid:9)

0

Ctic rang buck

III

\ ii (Iiin

(cid:9)

HotelRoomTypelD Lien ket WI& ngooi vai tinting HotelRoomTypelD a bang

HotelRoomType

54/971H1 thong bin tour du lich trip tuyin

Phin Lich that Iii thong 3.2. THEET ICE alit NANG

3.2.1. Tang chd

Sy di phin ri chttc ping

Let

Hal *

t)11

I

L

L Ouarr

ahi,H1 L (cid:9)

Un (cid:9)

55/971 thong bin tour du Ijch tnrc tuyin

Phin tfch that lci h thong

Giao thin trang chi

411 yinceyst

eLIS

CZ:M=1M

'="4"••—••••

••••••n• u/Seara Iola

•••••••••943

len/esti I. (cid:9) • •n •••••n••• n•1•0-

PRI

ato. s Sonia Ss .1 OS sails

sal a So a

.Sara a 1.• •••./sLe. a

slaw*

••••••

111111111•1= (cid:9)

N

esS su. W ••n•••••11

Mad Sew in

Min .../Sakesse

SlaSa

• I di SESS.

11.010•1101.

es dieS OD

Nes whuansessones grooSSISso Sea,

-1 MI

n-n-w- nit a a Ns roma Cret•mt•

56/971 Hi thong bin tour du Itch trice tuyin

(cid:9) (cid:9)

Phan dch that la hi thong Giao Win chit Wing ding nh$p

CIMILINn 111111n 111MIONNO

Ten ding oh/14 (cid:9)

Mit 1/1/14 (cid:9)

O

Nhe tai Main?

Oslo dien quin ly thong tin ci nhlin

I RAM.. t A PO 1/1 rl

tOaff

Ira cull diem thatth

[men um a Au 1 I ith (cid:9)

===

=MIIII =MEM

Cc

11121111111111111•0

— Tit ei —

•

GS) Win dm US tour

ddion/mY

57/97 I 111 thong bin tour du gch tryc tuyin

Phan tich that ki h{ thong Giao diin kit qui tim Idim

UV. (cid:9)

As

aim We Inn mak

do Masi MS la tit Tp. MI a NM

.101111*

- 41!

SANS

fl

Nina

Eat

NS*

CIE bit

1,510.001

11/1n14

21/11/2014

Tfe-Cle To (cid:9)

(KO (cid:9)

OS (cid:9)

nit

2

Hi The-Tha Setts (cid:9)

10•)

TOURO00005

na bit

Lilian

12/10/2014

WIN21)4

2

TOuRIE1CO6

Pa Sol deal Wag orb chie-14 Tras(llikt 4.4 *a duke ow do VI•liestro 4 ?dm Mewl) I ECO - Me bit WOO

e

SOPS

22/10/2014

MOH

I

TOUR000007

chola um st-c us Tia PionetniOng thin UM di, awl won (ECO . Oh llit Pim)

OA Olt 11113

NEtOln Mini-NON Wry IFIMCMy Otis.

- 11. (cid:9)

sass

wanes

muss

111 (cid:9) Solorla 01•41 Van (000.414v Of WS

Giao dien chi tik tour

Ssoul-Evarland-Nam1-36ju-Seoul 6N5D:Tong vi warn Manta show-Mho 16 46

TIENSOM

1t .w1 IC

111 An Do WI beep Audi as a.1 .J Dia flIA CIS POW as MI

24,660410.0vN11 measinerani -

nohvtlhli• siva .4.114.1 SO

I

ensues •

(cid:9)

TY el

SI at

:ESNS MSS ego

(cid:9)

wawa.

M.a. (cid:9)

ES Ono (cid:9)

Ti — see

%Jays bolImplio

OS ant

N. • Me (cid:9)

ethi (cid:9)

IS Pallmealeet. *St %WIMP

Mb IMO MU (cid:9)

OS beasPISo (OMOri

own. Own VS OM lis) TS a

CTIE It ha Ma dsa12

'EMMA (TSS IslIalo doe II ball Os IA ( OWN I ISO

58/971 HI thong bin tour du Itch tnrc tuyln

Phin tick that Ic6 hi th6ng Giao &In d$t tour

Lapis

* 0111.1712122346

Sooul-Endand-NanO-34du-Soou1 6,150:Tong vi Jam Moto ohow-Mise li do

Mum. TOIMINN fama RIM ik 3010600/ 111 NOW Its Mak 13/121/3314160216/c M NS NSW TN MBOONS SI chi dna* MI

innakir

1ylts I

IIPAIM(ta LISS Id 614

2a,HM1M1 4

14 =fall Si Ms &A USE

1017,5

TM ail (1V S nF lla 54111114)

7,497AMI

balpf (PA 5180

(PI* VIM Pa

Slab (*) (cid:9)

ISIS 36 *12 - Nips* Nwpc Ni • Thwit (cid:9)

Ha Pe

Mart (cid:9)

123456711

(6012.201") (cid:9)

;09117664321

Mawr) (cid:9)

Na (') (cid:9)

intramoiltmel

as di

Wog OM**

F-31 NINO Nw: j 2 j NI rill MS ,—(n 1:0611111

es Nis

fat 16pletn

[NW. 'j rNest4 16n oi

t TAR Van Nora

2311wArarli - NG • I IHuSlISn .l

2 VII Thu 116

Nay 'Mien •

in Pippin TAI

1 lin Xaki Sic

1

ION dm

1414.141

MI= [ 24-7-Ss MC: I (cid:9)

59/97 I 111 thong bin tour du Ijch trim tuyiin

Phan tich that ki hi thong

3.2.2. Trang gudn tri

1

()L OH Iv t,

Sa der phin ri chat ning

Trang quin tri

Ono och ask see Ns Pa

was aakman assookaaan

Ofer as wake we

Its 011010 OW WO Oslo *Omsk Cob 10 is 040 MR 6011.•

Ithich sin

aim du lich

Quin It tour

amose1...1

MI. War Is I* 0.• Sang 111111111•• pa... Oa

NenkilialdirlS1

mean a 08101011 Mak

(cid:9)

Thong Id

III khoin (cid:9)

Quin 19 tin We

(Avow saves m.. ves ....erne... ....nen.

Hinh 3.2 Trang quern tri

60/971 Hi thong bin tour du Ijch tnrc tuy&n

Phin tech that ki hi th6ng

Chit Ding gain 1 tour

Danh sash tour

Dena

Oes

0 X

•

IN

MOON

U No/ROOM 111► LM Leak Taal IM ,ECO. Seep St

• ¤

0 X

•

Oa

'NNW

0 NIS 110••.610~010 a. CINo-1 Iftrrnso ems NOS gm

Oxsx

0 X

• •

12/1•21n4

ii

TO1NC4W Owlet.* N-0. Ns lb 1•••••••****11**••••• 1100-

ONO

0 s * •

fine.

CI

TCOMPOON WM-IO. Nr 00 SIB OS la UNION. INII•NKr

x

•

•

MINNu

YY

Ii

tINNYMNwon NNW

_ (cid:9)

$ (cid:9)

SINN (cid:9)

r0~0000

•

•

aM

o x

Y

NINON.

IONS Tana IIIINOIDAIN4NOME0411•11001S11014 1

• •

•

O

Y

*flu

4Y

Tem dais US ON NA MOAN INN is•••• 308•10104•1•4:3•• •

TOU00

o x

•

•

Cl

TOWN

Rea NNIMis as NONNI MN, AN& NIN

Tim lot

Them tour

Hirsh 3.3 Dank slick tow

lam& (cid:9)

(Ow MICA NCO Ls TS PhwarTai•g •St NI thy NM Me IMO .111.111163.

Nay INAINS: (cid:9)

/ on/yyyy

I

56 PENNS* At I

_

•••••••

0•N a:

GIN'S (cid:9)

l•

elbeel*:

C No • so

K* a* (cid:9)

SIM

Hinh 3.4 Thins tour moi

61/971 H$ thong bin tour du I$ch true tuyin

Phin Itch that Id hi th6ng Danh Inc dam du lich

Danh sIch diem du Ikh

000 mks (cid:9)

•••

X

f) (cid:9)

Ns (cid:9)

1.00001017

WTw

00050

•

x

11100101-0n •10

U (cid:9)

Ca MON

LOCAONIIII

x

IsT *NM

LOCKING.

Wm

x

o (cid:9)

-011/f/a

U (cid:9)

IOC/01110•

11•1•Soin

x

U (cid:9)

LOC/4MM

Slaws so as Od•

x

10001041011a

U (cid:9)

1011168

LOCANIN2

0 X

U (cid:9)

aweli (cid:9)

e•

LOCA001023

111. Mom -

0 X

101000410Nas

0111010101 n.

0 Waal

I nr •••nMan (cid:9)

Hinh 3.5 Danh muc diexm du ljch

Them diem du lich

-111:

ia • Eil 0) .31 00 .0 • P GI•0••••11C•

•

" (cid:9)

- • Me Jaya- (cid:9) a • • • •• (cid:9)

91 1+•0"uUte• L (cid:9) • (cid:9) .0. a, (cid:9) • -.pro 00 (cid:9)

I 04. (cid:9)

• 9

" A'

Hinh 3.6 Them mei diem du licit

62/971111) th6ng bin tour du lfch tryc tuyin

(cid:9) (cid:9)

Danh each tin hit

•

tuft Os

Phin ticb that Id hi thong Quin lt tin tit

(cid:9)

K

Taxa SO s_

U

rowansT. Oics r ise. Os On mid to OASIS

0 X

Tad Su moo (cid:9)

IESINNO leoloica•YONI - SSISMOSISoloOode

•

Tee 514 SO; (cid:9)

0 K

100300007 "WO, 011t - avow -wk Os Om

•

0 K

1— stir (cid:9)

U moolSONS Ok lealowl•OsitaiodolOo• Oho

0

ROOM (cid:9)

_r

1100001109 MS loamb ud dlotnio0.10 Kw • Noolo nudow TY lin MOO Ow Sir IS 30501 10110•14

(cid:9)

0 x

OS SOU S (cid:9)

fl MSS INS /0 1St egos SOS sip&

(cid:9)

0 K

1•0• IMMO 800 (cid:9)

isslan mns Di Woo ono kw SOO So Si* Si on no ocor

(cid:9)

0 K

SSW 71•1101114 Y (cid:9)

MOMS OS oottas lor So NOSS Oft 0101101009

"I

7'

< K Too (cid:9)

Hinh 3.7. Quern lc) tin ilk

Them Si tin tilt

00004, MO

Tin

Tao do

• Mt

(cid:9) Na (cid:9)

=a•Olit[11.1 -0 1.

• C •

o/a3 (cid:9)

NIOWTML110131. (cid:9) t -. 440 • T (cid:9) 71 47;;;;;.. .ems w

Rink 3.8. 77tim mei tin nic

63/97 I 11{ thong bin tour du Ijch trot tuyin

Phin tich thiEt ki he thong Th6ng ke

Thong We

Thorp ke theo doarh thu theo thy' gian

Thong ke tour theo ;hut gian

Hinh 3.9 Chair ndng thong ki

Thong lee tour theo theti gian

(cid:9)

TO ngiy:

dd/s/ yyyy

(cid:9)

dd /../yyyy

Din NOY:

(cid:9)

Tour in khich

Lon

Hinh 3.10 Form therm so

Thong ke tour an Mich IV 01/09/2014 din 31/10/2014

(cid:9)

11103

Tao atle• Li• Cat NI MPS 1.41 lam Sig SIOSC•la •100604•• Cat

(cid:9)

11•11.111116•1•I• Towed, 11•1100.101•0111•1111

•

IOL •Ai MO. Nos ISO (cid:9)

110N1311 (cid:9)

TussiVal• Ism Fild•Ams sr *Mesons to TS arm aco. nit a Woo

N110111160ila•TI•Mie111esientip•IIIV•1•60•11111111111001

1110101:47 (cid:9)

1.44111.44•1CmOsliiamia 011141I V•811K0•11.

NI soli AY to Ms 01.0•• (cid:9)

TETONION (cid:9)

11•SIMINS1418•MadielIMItlY•vemelloiliestlilli

nil!. (cid:9)

teleas* WS • 01. CIS

itioataen (cid:9)

Wye all PM Savo* 4441,08 aCo (cid:9)

Hinh 3.11 Hiin th1 kit gut)

64/971111 th6ng bin tour du lich trvc tuyin

Xily dun chit ning

CHIAING 4. xAY MING CHIYC NANG

4.1. Ciiu tree mi flan then kiln tree MVC

• 4

IhsTrara

llirlialliniliMill 0 a F Properties

am References

►

►

►

P S App_ 0 la &editor &finder Class Content

►

P 5 Controllers Filters Image P la Models P la Scripts lia Views an faviconico P as GlobaLasas

▪ ►

la packages.config ICI Web.config

Hinh 4.1. Chu talc and ngudn theo kiln triic MVC

(3 day chi de cap den 3 phen chinh: Models, Controllers, Views

4. /. /. Models

Models (Binh 4.2) china Mc class del tucmg ducc VS tu sink m khi lien luinh kat nisi v6i CSDL ADO.NET Entity Data Model (TravelModel.edmx). Moi bang trong CSDL tucmg (mg WA met class trong ADO.NET Entity Data Model (Account, Country, Tour,...). Ngoai m can c6 clic model do LTV tu tao ra nhiim muc dich truyen nhan dit lieu duce nhanh chong (BookingModel,...).

fia Models • ► ► ►

•c* Booking/AS.1n •c• DatelimeltangeModeLcs a Co LoginAllodeLcs • ••jil Trevelkiodeladmx

► ela TravelModel.Costeast ► el) Travallodel.Designerx 41:1 TravelModeladroLdiag eb TramilModelit ► it Account.cs ► sib lioeldtoom.cs ► at BookRoomOstaiLcs ► at BookTour.cs ► at BookTourDebil.cs

►

eb Country.cs ► at Custom/tors Hirsh 4.2 Thu mix Models

65/97 I He thong bin tour du Lich trim tuyin

fly dyng chit ning

Vidviclassditucnig;AumountduipcsidivradmotgingikccounttrorgeSUL:

namespace VnTravel.Models

{

using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations;

public partial class Account

{

public Account()

{

this.News = new HashSet(); this.TemplateTours = new HashSet(); this.Tours at new HashSet();

}

public string AccountlD { get; set; } //Validate trading Username [Required(ErrorMessage = "Username kiting duvc b6 trong.")] [MinLength(5,ErrorMessage ="Tdi thidu 5 ki tu")] [MaxLength(30, ErrorMessage = "T6i da 30 ki tor)] public string Username { get; set; //Validate trubng Password [Required(ErrorMessage a "Password khong duct b6 trong.")] [MinLength(5, ErrorMessage = "Tdi thidu 5 ki tor)] [MaxLength(30, ErrorMessage = "Tdi da 30 ki tV")) public string Password { get; set; //Validate trubng Firstname [Required(ErrorMessage = "Ten khOng duct b6 trong.")] public string Firstname { get; set; //Validate trubng Lastname [Required(ErrorMessage = "H9 khong duqc b6 trdng.")] public string Lastname { get; set; public string Address { get; set; public string PhoneNo { get; set; //Validate trubng Email [Required(ErrorMessage . n "Email khong duqc b6 trong.")] [EmailAddress(ErrorMessage -"Email kh6ng dune)] public string Email { get; set; public Nullable Level { get; set;

public virtual ICollection News { get; set; public virtual ICollection TemplateTours { get; set; } public virtual ICollection Tours { get; set; }

}

}

66/97 I HI thong bin tour du Lich bye tuyin

fly dying chit Mug

4.1.2. Controllers

• a Controllers

a CP AdminConboller.cs 0 • c• Bookiiigratrallerscs 0 +Cu CustomeControkr.cs 0c ct HameControllerecs 0 a c• HotelController.cs NewsConbolltr.cs 0 co RegionController.cs 0 • col StaticsControllern 4' Cu TourController.cs kink 4.3 Thu mix controllers Controllers chits cat Controller duqc pink theo dai ttrog hoc chet rang quail 15 , vbi Minh 4.3) - la cic thinh phan dthg de quim lt Mang tic ngueri dung, lam vies model va chqn view di hien thi giao Bien ngubi dung (xis lt de lieu de hien thi tren View hoac lay de lieu to View de

Vi du AccountController c6 cac Action de ail ly clang nhap, dang xuat:

public ActionResult Login()

{

if (SessionrCustomerl -- null IA Session["Admin"] -a null)

return View();

if (SessionrCustomerl Is null)

return RedirectToAction("Index", "Home");

if (Session["Admin"] I. null)

return RedirectToAction("Index", "Admin");

return View();

}

[HttpPost] public ActionResult Login(LoginModel u)

{

string strError ""; if (ModelState.IsValid) {

string strPass • CommonFunction.MDS(u.Password); var testc (from m in db.Customers where (m.Username -- u.Username Si

m.Password -- strPass) select m).ToList();

var testa (from a in db.Accounts where (a.Username -a u.Username AA

a.Password am strPass) select a).ToList();

if (testc.Count > 9)

{

Session["Customer] • u.Username; return RedirectToAction("Index", "Home");

}

if (testa.Count > 9)

{

SessionrAdmin") • u.Username; return RedirectToAction("Index", "Admin");

}

else

{

strError a limml.validationSummary()'; ModelState.AddModelError("", "Sal ten (Sang nhap ho9c mot khiu");

67/97 I lif thong bin tour du Ijch trim tuyin

Xiy dying chic ning

}

} ViewBag.ErrorLogin strError; return View();

}

public ActionResult Logout() {

Session.RemoveAll(); return RedirectIoAction("Index", "Home");

}

4. L3. Views

• al Account

BOW] AddAccountahtml area Ceate.cshbni IOW EditAcanant.cshbvtl oDIVI ListAccount.cshbnl a003 Login.cshtml

IS Admin le Booking

Hinh 4.4 Thu mix Views

Views Chita clic View tuang (mg v6i cac ActionResult, ViewResult,... trong controller (Hinh 4.4), hien thj der lieu dugs truyen len, tucmg tic vei ngubi dimg qua giao dien vi truyen de lieu cho controllers xis ljr.

Vi du View them m6i 1 Account:

1111111VnTravel.Models.Account

I

ViewBag.Title 'Create"; Layout • " -/Views/Shared/_AdminLayout.cshtml";

Create

lusing (Html.BeginForm()) {

IHtml.ValidationSummary(true)

clegend>Accountglegend>

IHtml.LabelFor(model a> model.Username)

ml.ValidationMessageFor(model -> model.Username)

rml.EditorFor(model a> model.Username)