Download - Aravind Bca
-
8/10/2019 Aravind Bca
1/104
LEARNING POINTA-20, SECTOR- 16, NOIDA (U.P.)
LC CODE: 0950
A
PROJECT REPORT
ON
E-BILLING & INVOICE SSTE!
P"#$%: NOIDA
D#%: '0.09.201
SUB!ITTED B
ARAVIND U!AR
BCA
R*"" N*. 5+1116902
R%* /%3 4 /"""%4 * %/%%4 * 7% 3%8%% *
BCA ##3%3 * S !#4#" U4;% ?EALT?, !EDICAL AND TEC?NOLOGICAL SCIENCE
DISTANCE EDUCATION @ING, SNDICATE ?OUSE, !ANIPAL = 5+610
1 5+1116902
-
8/10/2019 Aravind Bca
2/104
STUDENT DECLARATION
I ARAVIND KUMAR, hereby declare that the project report entitled "E-
Billing & Invoice System" submitted in partial fulllment of thereuirements for the de!ree of "#A to $i%%im Manipal Uni&ersity, India, is
my ori!inal 'or% and not submitted for the a'ard of any other de!ree,
Diploma, (ello'ship or any other similar title or pri)es*
+lace Noida $tudent
Date: 30.09.2014 ARAVIND U!AR
Roll No. -5+1116902
2 5+1116902
-
8/10/2019 Aravind Bca
3/104
EXAMINERS CERTIFICATION
T7% P*%$ R%* *
P*%$ E4"%3 "E-Billing & Invoice System" #*;%3 #43 #$$%#"% 4
/#"< & *.
I4%4#" E#4% E%4#" E#4%
(N#%, /#"$#*4 & D%84#*4) (N#%, /#"$#*4 )
3 5+1116902
-
8/10/2019 Aravind Bca
4/104
CERTIFICATE
This is to certify that the project report entitled "E-Billing & Invoice System"isa
bonafied or! carried o"t by #R#$%ND &'(#R, a st"dent of )CA in a tea* "nder
able +"idance and s"per,ision.
This is to f"rther certify that this is an ori+inal done and the report thron has not been
earlier for the aard of any diplo*a or de+ree to any instit"te of "ni,ersity.
S84#/% * P*%$ G/3%
D#%:
S84#/% * C#433#%
Na*e: ARAVIND U!AR
R%8. N*. 5+1116902
SC C*3%: 0950
S84#/% * C%4% ?%#3
SC C*3%: 0950SC N#% : LP, N*3#
4 5+1116902
-
8/10/2019 Aravind Bca
5/104
ACNO@LEDGE!ENT
ords often fail to e/press ones inner feelin+s of +ratit"de and indebtedness to
ones benefactors b"t then it is the only readily a,ailable *edi"* thro"+h hich the
"ndersi+ned can e/press their sincere than!s to all those ho are associated ith the
or! in one ay or the other
% ac!noled+e *y sincere +ratit"de toards *y #$/"< 8/3%, L%#448 P*4,
N*3# (U.P.) for their ,al"able +"idance and s"pport at all ti*e.
% o"ld li!e to than! all the respondents itho"t hose cooperation *y st"dy
project o"ld not ha,e been co*plete.
ARAVIND U!AR
R%8. N*. 5+1116902SC C*3%: 0950
5+1116902
-
8/10/2019 Aravind Bca
6/104
TABLE O> CONTENT
C?APTER-1: PROJECT INTRODUCTION 09-10
1.1 %ntrod"ction1.2 5roject profile
C?APTER-2: GOAL 11-1
2.1 USER PRO>ILES
2.2 USAGE SU!!AR
2.3 R67'%R6(6NT88'((#R
2.3.1 )"siness Re"ire*ents 2.3.2 'ser Re"ire*ents
2.3.3 ;perational Re"ire*ents
2.3.4 8yste* Re"ire*ents2.3. 8'%T
3.3 R6>%#)%>%T 3.4 8#)%>%T
3. 86>#T%;N
C?APTER- SOLUTION ARC?ITECTURE 21-26
.1 IN>RASTRUCTURE
.2 CONCEPTUAL DESIGN
4.3 >;B%D68%BN 4.4 5C8%D68%BN
= 5+1116902
-
8/10/2019 Aravind Bca
7/104
C?APTER-5: EBILLING AND INVOICE SSTE! DATA DICTIONAR
2+-'0
5.1 TABLE : PRODUCT!ASTER
.2 T#)>6: )%>>.3 T#)>6: )%>>D6T#%>8
.4 T#)>6: 6: '86R(#8T6R
C?APTER-6: STRUCTURED ANALSIS '1-'
3.1 %ntrod"ction
3.2 Tools 'sed in 8tr"ct"red #nalysis
3.2.1 OR! DESIGN AND CODING '5-95
@.1 ?r*8plas @.2 ?r*>o+in
@.3 ?r*(ain
@.4 ?r*5rod"cts @. ?r*)ill
@.= ?r*Reports
@.@ ?r*5rint)il
@.A 5rod"ct8"**ary Repor @.9 ?r*)ill8"**ary
@.10 ?r*6/portData
@.11 ?r*'tlity
@.12 ?r*
-
8/10/2019 Aravind Bca
8/104
C?APTER- EBILLING AND INVOICE SSTE! TEST PLANE 9-102
A.1 %NTR;D'
-
8/10/2019 Aravind Bca
9/104
PROJECT INTRODUCTION
1.1 I4*3/$*4
1.2 P*%$ P*"%
9 5+1116902
-
8/10/2019 Aravind Bca
10/104
1.1 INTRODUCTION
This project is foc"sed on e-billin+ and in,oice syste* . Donloads and "ploads c"sto*er and
order infor*ation hich affects acco"ntin+ in,entory and prod"ct data. $ie c"sto*er and
prod"ct data as described in *etrics trac! orders and deli,eries.
The client "ses (8 6/cel and *aintains their prod"ct list c"sto*er list and prints the in,oice
hoe,er it is not possible the* to share the data fro* *"ltiple syste* in *"lti "ser en,iron*ent
there is lot of d"plicate or! and chance of *ista!e. hen the prod"ct price are chan+ed they need
to "pdate each and e,ery e/cel file. There is no option to find and print pre,io"s sa,ed in,oice.
There is no sec"rityE any body can access any report and sensiti,e data also no reports to find o"t
the sales ,ol"*e stoc! list and s"**ary report. This e)illin+ and in,oicin+ syste* is "sed to
o,erco*e the entire proble* hich they are facin+ c"rrently and *a!in+ co*plete ato*iFation of
*an"al billin+ and in,oicin+ syste*
10
-
8/10/2019 Aravind Bca
11/104
1.2 P*%$ P*"%
5roject Title: 6-)%>>%NB #ND %N$;%
-
8/10/2019 Aravind Bca
12/104
GOAL
2.1 USERPRO>ILES
2.2 USAGESU!!AR
2.' REUIRE!ENTSSU!!AR
2.'.1 B/4% R%/%%4
2.'.2 U% R%/%%4
2.'.' O%#*4#" R%/%%4
2.'. S
-
8/10/2019 Aravind Bca
13/104
2.1 User Profiles
The folloin+ "ser types are e/pected for the e)illin+ and %n,oicin+ 8yste*:
U% B% D%$*4 * U% A$*4
8ales Representati,e Donloads and "ploads c"sto*er and order
infor*ation hich affects acco"ntin+ in,entory and
prod"ct data. $ie c"sto*er and prod"ct data as
described in *etrics trac! orders and deli,eries.
(ana+er #ll sales representati,e "se actions and *ana+e*ent
reports "ota establish*ent reportin+ and
adj"st*ent.
#cco"ntant $ie and print stoc!s trac! orders. 'pdate prod"ct
details li!e price.(%8 6/ec"ti,e Benerate reports ,ie and print in,entory reports
,ie and print stoc! reports.
13
-
8/10/2019 Aravind Bca
14/104
2.2 'sa+e 8"**ary
e)illin+ and %n,oicin+ 8yste* ill address the folloin+ "se cases. The co*plete "sa+e scenarios
ill be co*pleted d"rin+ the infor*ation-+atherin+ process. 'se cases ill be created and
prioritiFed. 8elected "se cases ill be e/panded into "sa+e scenarios and feat"res that are deri,ed
fro* both "se cases and the "sa+e scenarios as represented in the folloin+ dia+ra*:
'sa+e
s"**ary
"se case
14
-
8/10/2019 Aravind Bca
15/104
2.' R%/%%4 S/#!#4
+. >P*3/$
+.5 >B""
+.6 >R%*
+.+ >P4B"
+. P*3/$S/#< R%*
+.9 >B""S/#E*D##
+.11 >U"C*#$A43R%#D###%
+.1' >B#$/D###% +.1 >C*#4C"%4I4*
+.16 >C7#48%P#*3
+.1+ !*3G%4
+.1 !*3B*%
+.19 !*3RT*@*3
3=
-
8/10/2019 Aravind Bca
37/104
+.1 >S"#7
L(od"le to sho start"p screenI
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K e)illin+ 8yste* K
K(od"le to sho start"p screen
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
;ption 6/plicit
Di* r #s %nte+er Di* i #s %nte+er
5ri,ate 8"b ?or*>oadLI
K center the for*
(e.>eft O L8creen.Cei+ht - (e.Cei+htI 2 (e.Top O L8creen.idth - (e.idthI 2
K +et a rando* ,al"e to decide ho *any seconds
K start"p screen sho"ld be displayed
r O Rnd M P 1 6nd 8"b
5ri,ate 8"b ?or*'nloadL)y$al
-
8/10/2019 Aravind Bca
38/104
+.2 >L*84
L(od"le to #"thenticate 'serI
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K e)illin+ 8yste* K
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K >o+in (od"le K 'sed Table : "ser*aster
K(od"le to chec! "ser lo+in and load
K"ser ri+hts as per "ser type. KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
;ption 6/plicit Di* Rs #s Ne #D;D).Recordset
5ri,ate 8"b
-
8/10/2019 Aravind Bca
39/104
6/it 8"b
6nd %f
K chec! for "serna*e and passord
K "ery to "ser*aster ith "serna*e and passord
K if no record fo"nd chec! arn "ser for enter ,alid "ser na*ne and passord K if record fo"nd store "sern*ae "sertype in +lobal ,ariable for f"t"re "se.
%f Rs.8tate O ad8tate;pen Then Rs.o+in 6rror QI
T/t5assord.Te/t O QQ
T/t'serNa*e.8et?oc"sLI 6/it 8"b
6nd %f
6nd 8"b
5ri,ate 8"b oadLI
K open the +lobal connection %f
-
8/10/2019 Aravind Bca
40/104
hile Rs.6;? O ?alse
o+in O Nothin+
6nd 8"b
@.3 ?r*(ain
LBi,e "ser access to different *od"leI
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM K e)illin+ 8yste*
K
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM K (ain 8creen
K 'sed Table : N#
K(od"le to sho diffrent options KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
;ption 6/plicit
5ri,ate 8"b (D%?or*#cti,ateLI
K sho the lo+in for* as *od"las for first ti*e
K hen *ain for* acti,ate first ti*e %f o+in O ?alse Then
?r*>o+in.8hoL1I
6nd %f >bleft O (e.idth - 5ict"re1.idth - 400 6nd 8"b
5ri,ate 8"b Toolbar1)"tton
-
8/10/2019 Aravind Bca
41/104
K in desi+n ti*e e set !ey ,al"e for each toolbar b"tton
%f )"tton.&ey O Qe/itQ Then
6nd 6lse%f )"tton.&ey O Qprod"ct*asterQ Then
?r*5rod"cts.8hoL1I
6lse%f )"tton.&ey O QbillQ Then ?r*)ill.8hoL1I
6lse%f )"tton.&ey O Q"tilityQ Then
?r*'tility.8hoL1I 6lse%f )"tton.&ey O QreportsQ Then
?r*Reports.8hoL1I
6lse%f )"tton.&ey O Qco*panyQ Then
?r*
-
8/10/2019 Aravind Bca
42/104
7r8tr O Qselect prods"btype fro* prod"ct*aster here prodtypeOKQ
st5rod"ct8"bType.st5rod"ct8"bType.>ist
-
8/10/2019 Aravind Bca
43/104
T/tNa*e.Te/t O QQ
T/tRate.Te/t O 0
-
8/10/2019 Aravind Bca
44/104
Rs.'pdateLI
Rs.>Q Then 7r8tr O Qselect prods"btype fro* prod"ct*aster order by prods"btypeQ
6lse
7r8tr O Qselect prods"btype fro* prod"ct*aster here prodtypeOKQ st5rod"ct8"bType.
-
8/10/2019 Aravind Bca
45/104
Rs.(o,eNe/tLI
6nd hile
K sho the first record %f >st5rod"ct8"bType.>ist>Q %f Rs.8tate O ad8tate;pen Then Rs.
-
8/10/2019 Aravind Bca
46/104
hile Rs.6;? O ?alse
>st5rod"ct8"bType.#dd%te*LRsLQprods"btypeQII
Rs.(o,eNe/tLI 6nd hile
K select the first record
%f >st5rod"ct8"bType.>ist
-
8/10/2019 Aravind Bca
47/104
DisplayRecordLI
6nd 8"b
5ri,ate 8"b T/tNa*e&eyDonL)y$al &ey6%8T
%f >Q
6nd %f
%f &eyst5rod"ct8"bType.>ist%nde/ S >st5rod"ct8"bType.>ist
-
8/10/2019 Aravind Bca
48/104
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K Ne(odify )ill (od"le
K 'sed Table : )ill K : )ill Details
K : 5rod"ct
K :
-
8/10/2019 Aravind Bca
49/104
blRsord.
-
8/10/2019 Aravind Bca
50/104
?or i O 0 To Rs2.Record.6nabled O Tr"e
T/toc!ed O ?alse
T/t#ddress1.>oc!ed O ?alse T/t#ddress2.>oc!ed O ?alse
DtDate.6nabled O Tr"e
T/t>ocation.>oc!ed O ?alse T/toc!ed O ?alse
6lse
(s+)o/LQNo 5re,io"s Details fo"nd for in,oice...Q T/t%n,oiceNo.Te/t ,b6/cla*ationI
-
8/10/2019 Aravind Bca
51/104
T/t#ddress1.>oc!ed O Tr"e
T/t#ddress2.>oc!ed O Tr"e
DtDate.6nabled O ?alse T/t>ocation.>oc!ed O Tr"e
T/toc!ed O Tr"e
6nd %f
%f R81.8tate O ad8tate;pen Then R81.
-
8/10/2019 Aravind Bca
52/104
-
8/10/2019 Aravind Bca
53/104
6nd %f
%f %sN"*ericLT/t
-
8/10/2019 Aravind Bca
54/104
%f R81.Recordocation.Te/tI R81LQchalannoQI O $alLT/t
-
8/10/2019 Aravind Bca
55/104
R81LQtotala*tQI O $alL>blTotal#*o"nt.
-
8/10/2019 Aravind Bca
56/104
K insert in bill details for each ,alidated +rid ro
%f Rs2.8tate O 1 Then Rs2.ast8no Rs2LQbillsnoQI O sno
Rs2LQprodsnoQI O 5rod8no
Rs2LQtyQI O $alL(f1.Te/t(atri/Li 2II Rs2LQrateQI O $alL(f1.Te/t(atri/Li 3II
Rs2LQa*tQI O $alL(f1.Te/t(atri/Li 4II
Rs2.'pdateLI
%f Rs2.8tate O 1 Then Rs2.ast8no O >ast8no P 1
6nd %f
Ne/t
K co**it the transaction
-
8/10/2019 Aravind Bca
57/104
5ri,ate 8"b ?or*>oadLI
K cnter the for*
(e.>eft O L8creen.idth - (e.idthI 2 (e.Top O L8creen.Cei+ht - (e.Cei+htI 2
K reset connection
-
8/10/2019 Aravind Bca
58/104
oc!ed O T1
T/toc!ed O T1 T/t%n,oiceNo.)ac!
-
8/10/2019 Aravind Bca
59/104
6nd %f
6nd 8"b
5ri,ate 8"b T/t#ddress2&ey5ressL)y$al &ey#scii #s %nte+erI
K *o,e the foc"s to ne/t control
%f &ey#scii O 13 Then 8end&eysLQUtabVQI
6nd %f
6nd 8"b
5ri,ate 8"b T/t
-
8/10/2019 Aravind Bca
60/104
5ri,ate 8"b T/tost?oc"sLI
K *o,e the foc"s to ne/t control
T/t&ey5ressL)y$al &ey#scii #s %nte+erI
K *a!e fle/ +ird editable *o,e th te/tbo/ in +id cell for enterin+ ,al"e K chec! heathe e press enter !ey
K if yes..*o,e the control to ne/t +rod
Di* t #s %nte+er
%f &ey#scii O 13 #nd (f1..Te/t K sho total
(f1.Te/t(atri/L(f1.Ro (f1.
-
8/10/2019 Aravind Bca
61/104
Di* T1 #s Do"ble
?or / O 1 To (f1.Ros - 1
T1 O T1 P $alL(f1.Te/t(atri/L/ 4II Ne/t
>blTotal#*o"nt.blRsord O RsordL>blTotal#*o"nt.
-
8/10/2019 Aravind Bca
62/104
%f R81.8tate O ad8tate;pen Then R81.blTotal#*o"nt.
-
8/10/2019 Aravind Bca
63/104
*o,ete/tbo/LI
c*b,al.8el8tart O 0
c*b,al.8el>en+th O >enLc*b,al.Te/tI 6nd %f
6nd 8"b
5"blic 8"b setheadin+LI
K creatin+ for the +rid
Di* & #s %nte+er
Di* t #s %nte+er
(f1.
-
8/10/2019 Aravind Bca
64/104
-
8/10/2019 Aravind Bca
65/104
Rs.;penLQselect prods"btype fro* prod"ct*aster order by prods"btypeQ oc!Read;nlyI
hile Not Rs.6;?
c*b,al.#dd%te*LRsL0II
Rs.(o,eNe/tLI 6nd hile
6lse%f (f1..$isible O Tr"e Then %f TGT$#>.6nabled O Tr"e Then
TGT$#>.8et?oc"sLI 6nd %f
6nd %f
6nd %f
-
8/10/2019 Aravind Bca
66/104
L5rint o"t of the billI
==
-
8/10/2019 Aravind Bca
67/104
@.= ?r*Reports
L8ho Different Report ;ptionsI
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K e)illin+ 8yste* K
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K 8ho report options K
K
Kallo "ser to select diffrent report
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
;ption 6/plicit
5ri,ate 8"b
-
8/10/2019 Aravind Bca
68/104
K sho print bill
?r*5rint)ill.8hoL1I
6nd 8"b
5ri,ate 8"b oadLI K center the for*
(e.(o,e L8creen.idth - idthI 2 L8creen.Cei+ht - Cei+htI 2
6nd 8"b
@.@ ?r*5rint)ill
L5rint already sa,ed billI
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K e)illin+ 8yste* K
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K 5rint already sa,ed bill
K 'sed Table : bill K : billdetails
K(od"le to allo "ser to select the in,oice
Kno fro* seleted date ran+e Kand open the bill by its in,oicebill no
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
=A
-
8/10/2019 Aravind Bca
69/104
;ption 6/plicit
Di* Rs #s Ne #D;D).Recordset
5ri,ate 8"b
-
8/10/2019 Aravind Bca
70/104
6/it 8"b
6nd %f
6nd 8"b
5ri,ate 8"b ?or*>oadLI
K center for*
(e.(o,e L8creen.idth - idthI 2 L8creen.Cei+ht - Cei+htI 2
>st%n,oiceNo.
-
8/10/2019 Aravind Bca
71/104
@.A 5rod"ct8"**ary Report
L8ho 5rod"ct 8"**ary report in crystal reportI
@.9 ?r*)ill8"**ary
L8ho bill s"**ary for partic"lar date ran+eI
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM K e)illin+ 8yste*
KKMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM K 8ho s"**ery of bill
K 'sed Table : bill
K : billdetails
Ksho bill s"**ary for seleted date Kran+e sho report in crystal report
K*o,e data into te*p table and sho
@1
-
8/10/2019 Aravind Bca
72/104
Kreport fro* te*p table
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
;ption 6/plicit
5ri,ate 8"b
-
8/10/2019 Aravind Bca
73/104
DT5ic!er2.$al"e O Date
6nd 8"b
)ill 8"**ary Report
@.10 ?r*6/portData
L6/port prod"ct Data in ?le/Brid and (8-6/cel ith for*attin+I
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K e)illin+ 8yste* K
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K 6/port prod"ct*aster in +rid and *s-e/cel
K 'sed Table : prod"ct*aster Kopen the prod"ct*aster in +rid
Kdisplay record in fle/ +rid ith +rop" by prod"ct type
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
@3
-
8/10/2019 Aravind Bca
74/104
;ption 6/plicit
5ri,ate 8"b
-
8/10/2019 Aravind Bca
75/104
Khead
/ O 6s.Ran+eLQ#1:Q R2I
/.?ont.)old O Tr"e /.?ont.ine8tyle O /line8tyle O /line8tyle O /l
-
8/10/2019 Aravind Bca
76/104
KT;T#>
R2 O Ret"rn#lphabetL(f1.
-
8/10/2019 Aravind Bca
77/104
(f1.
-
8/10/2019 Aravind Bca
78/104
(f1.Ros O (f1.Ros P 1
Rs2.(o,eNe/tLI Ne/t
R81.(o,eNe/tLI
Ne/t
6nd 8"b
5ri,ate 8"b ?or*>oadLI K cnter the for*
(e.>eft O L8creen.idth - (e.idthI
(e.Top O L8creen.Cei+ht - (e.Cei+htI
6nd 8"b
6/port prod"ct Data (8-6/cel ith for*attin+
@A
-
8/10/2019 Aravind Bca
79/104
@.11 ?r*'tlity
LTo #ccess different "tility pro+ra* li!e co*pact bac!"p chan+e passord etc.I
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K e)illin+ 8yste*
K
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM K 8ho options for "tilities
K
K Kallo "ser to select diffrent options
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
;ption 6/plicit
5ri,ate 8"b
-
8/10/2019 Aravind Bca
80/104
6nd 8"b
5ri,ate 8"b oadLI
K center the for*
(e.(o,e L8creen.idth - idthI 2 L8creen.Cei+ht - Cei+htI 2
K chec! "ser type and sho diffrent options as per "ser ri+hts
%f >
-
8/10/2019 Aravind Bca
81/104
@.12 ?r*
-
8/10/2019 Aravind Bca
82/104
K co*pact teh database
db6.oadLI
K center the for*
(e.(o,e L8creen.idth - idthI 2 L8creen.Cei+ht - Cei+htI 2 K set the pro+ress bar initial ,al"e
5ro+ress)ar1.(in O 0
5ro+ress)ar1.(a/ O 100
6nd 8"b
5ri,ate 8"b Ti*er1Ti*erLI K sho the pro+ress of co*pact process
%f 5ro+ress)ar1.$al"e S 100 Then
5ro+ress)ar1.$al"e O 5ro+ress)ar1.$al"e P 10 6lse
(s+)o/LQ5rocess
-
8/10/2019 Aravind Bca
83/104
@.13 ?r*)ac!"pDatabase
LTo ta!e bac!"p of *ain database data.*db.I
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM K e)illin+ 8yste* K
KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
K )ac!"p the Database Ldata.*dbI K 'sed Table : N#
K(od"le to ta!e a copy of data.*db in
Kdiffrent location ith ti*estra*p KMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
;ption 6/plicit
K Declare ?ile 8yste* ,ariable Di* ?s #s Ne ?ile8yste*;bject
Di* Ne?ile #s 8trin+
5ri,ate 8"b
-
8/10/2019 Aravind Bca
84/104
6nd %f
Te/t1.Te/t O 8
6nd %f
6nd 8"b
5ri,ate 8"b
-
8/10/2019 Aravind Bca
85/104
(e.(o,e L8creen.idth - idthI 2 L8creen.Cei+ht - Cei+htI 2
K ne bac!"p file na*e li!e data04010A1@4.*db Ne?ile O QDataQ ?or*atLNo QddnnyyhhnnQI Q.*dbQ
>abel2.
-
8/10/2019 Aravind Bca
86/104
@.14 ?r*
-
8/10/2019 Aravind Bca
87/104
R81.DeleteLI
astLI
A@
-
8/10/2019 Aravind Bca
88/104
6nd %f
-
8/10/2019 Aravind Bca
89/104
6/it 8"b
6nd %f
%f #dd6dit O Q#DDQ Then R81.#ddNeLI
R81LQco*panyna*eQI O T/t
-
8/10/2019 Aravind Bca
90/104
(e.(o,e L8creen.idth - idthI 2 L8creen.Cei+ht - Cei+htI 2
K reset connection
K clear all te/t
-
8/10/2019 Aravind Bca
91/104
K enable disable b"ttons
-
8/10/2019 Aravind Bca
92/104
-
8/10/2019 Aravind Bca
93/104
astLI
6nd %f
-
8/10/2019 Aravind Bca
94/104
6nd 8"b
5ri,ate 8"b
-
8/10/2019 Aravind Bca
95/104
6nd %f
%f #dd6dit O Q#DDQ Then
R81.#ddNeLI R81LQclientna*eQI O T/t
-
8/10/2019 Aravind Bca
96/104
R81.;penLQselect M fro* client*aster order by clientna*e Q oc!;pti*isticI
%f R81.Record
-
8/10/2019 Aravind Bca
97/104
>abel1@.
-
8/10/2019 Aravind Bca
98/104
EBILLING AND INVOICE SSTE! TEST PLANE
A.1 %NTR;D'
-
8/10/2019 Aravind Bca
99/104
%B""48 #43 I4;*$% S
-
8/10/2019 Aravind Bca
100/104
.' T% S#%8UTURE EN?ANCE!ENT
This project as de,eloped to f"lfill "ser and b"siness re"ire*entE hoe,er there are lots of scope
to i*pro,e the perfor*ance of the e)illin+ and %n,oice 8yste* in the area of "ser interface database
perfor*ance and "ery processin+ ti*e. 6tc.
8o there are *any thin+s for f"t"re enhance*ent of this project. The f"t"re enhance*ents that are
possible in the project are as follos.
>in!in+ and inte+ration of any le+acy syste* for acco"ntin+.
%nte+ration ith tra,el a+ent thro"+h eb 8er,ices
#5 applications
6lectronic Data %nterchan+e L6D%I syste* beteen ban!s other credit ,erification a+ency
and their ,endors
%n the area of data sec"rity and syste* sec"rity.
5ro,ide *ore online tips and help.
103
-
8/10/2019 Aravind Bca
104/104
BIBLIOGRAPHY
V/#" B#$ 6 - B"#$ B** < S%;%4 ?*"H4%
!#%48 V/#" B#$
S*#% E484%%48 < R*8% P%#4
.8**8"%.$*
http://www.google.com/http://www.google.com/