chapter 7- system coding

8/19/2019 Chapter 7- System Coding

http://slidepdf.com/reader/full/chapter-7-system-coding 1/12

CHAPTER 7

SYSTEM CODING

7.1 SAMPLE CODE:

Data Access.cs

namespace RFID_ATM{

class Data_Access { public SqlConnection cn;

public SqlCommand cmd; public SqlDataAdapter da; public SqlDataReader dr; public DataSet ds;

public void D!pen"# { cn $ ne% SqlConnection"&server$'AC()R;database$votin*; Inte*ratedSecurit+$ true&#; cn.!pen"#; ,

public void DCMD"strin* quer+# {

D!pen"#; cmd $ ne% SqlCommand"quer+- cn#;

cmd.)ecute/on0uer+"#;

, public void DADA1T)R"strin* quer+-strin* tbl# { D!pen"#; 22ds.Clear"#; da $ ne% SqlDataAdapter"quer+- cn#; ds $ ne% DataSet"#;

da.Fill"ds- tbl#;



,

public void DReader"strin* quer+# {

D!pen"#; cmd $ ne% SqlCommand"quer+- cn#; dr $ cmd.)ecuteReader"#; , public void DReaderClose"# { cn.Close"#; cmd $ null; dr.Close"#; , public void DCMDClose"# { cn.Close"#; cmd $ null;

, public void DConClose"# { cn.Close"#;

,

internal ob3ect dr4"int p# { t5ro% ne% /otImplemented)ception"#; ,

internal void DADA1T)R"strin* p#

{ t5ro% ne% /otImplemented)ception"#; ,

,,



6serin7o.cs

usin* S+stem;

usin* S+stem.Collections.8eneric;usin* S+stem.ComponentModel;usin* S+stem.Data;usin* S+stem.Dra%in*;usin* S+stem.Tet;usin* S+stem.9indo%s.Forms;usin* RFID_ATM;

namespace RFID

{ public partial class 6ser_In7o : Form { public 6ser_In7o"# { InitialieComponent"#; , Data_Access da $ ne% Data_Access"#; private void 6ser_In7o_<oad"ob3ect sender- )ventAr*s e#

{ t5is.9indo%State $ Form9indo%State.Maimied; da.DADA1T)R"&Select a.Fldaccno as =oterID_/um-a.Fld/ame as

/ame-a.7name as Fat5er_/ame-a.mname as Mot5er_/ame-a.se as 8ender-a.FldD!as D!-a.FldAddress as Address-s.statename as State-c.cit+name as Cit+-ar.areanameas Area-a.Fld1incode as 1incode 7rom AccountDet a-statemaster s-areamasterar-cit+master c %5ere a.Fldcit+$c.cit+id and a.state$s.stateid and a.area$ar.areaid&-&AccountDet&#; data8rid=ie%4.DataSource $ da.ds.Tables>[email protected]=ie%;

da.DConClose"#; , strin* RFID4 $ &&- RFID $ &&; private void tt6serId_TetC5an*ed"ob3ect sender- )ventAr*s e# { i7 "tt6serId.Tet.<en*t5 B$ # { return; , strin* clearTet $ tt6serId.Tet.Substrin*"?- #; strin* cip5erTet $ Cr+ptor)n*ine.)ncr+pt"clearTet- true#;



RFID4 $ cip5erTet;

clearTet $ tt6serId.Tet.Substrin*"- #; cip5erTet $ Cr+ptor)n*ine.)ncr+pt"clearTet- true#;

RFID $ cip5erTet; da.DADA1T)R"&Select a.Fldaccno as =oterID_/um-a.Fld/ame as

/ame-a.7name as Fat5er_/ame-a.mname as Mot5er_/ame-a.se as 8ender-a.FldD!as D!-a.FldAddress as Address-s.statename as State-c.cit+name as Cit+-ar.areanameas Area-Fld1incode as 1incode 7rom AccountDet a-statemaster s-areamasterar-cit+master c %5ere a.Fldcit+$c.cit+id and a.state$s.stateid and a.area$ar.areaid andFldAcc/o liEe & G tt6serId.Tet G &H&- &AccountDet&#; data8rid=ie%4.DataSource $ da.ds.Tables>[email protected]=ie%; da.DConClose"#;

i7 "da.ds.Tables>[email protected]%s.Count $$ ?# { Messa*eo.S5o%"&/o Suc5 a Data For our (e+ & G tt6serId.Tet G&&-&caption&-Messa*eouttons.!( -Messa*eoIcon.0uestion #; tt6serId.Tet $ &&; , ,

private void tnClear_ClicE"ob3ect sender- )ventAr*s e# {

tt6serId.Tet $ &&; da.DADA1T)R"&Select a.Fldaccno as =oterID_/um-a.Fld/ame as

/ame-a.7name as Fat5er_/ame-a.mname as Mot5er_/ame-a.se as 8ender-a.FldD!as D!-a.FldAddress as Address-s.statename as State-c.cit+name as Cit+-ar.areanameas Area-a.Fld1incode as 1incode 7rom AccountDet a-statemaster s-areamasterar-cit+master c %5ere a.Fldcit+$c.cit+id and a.state$s.stateid and a.area$ar.areaid&-&AccountDet&#; data8rid=ie%4.DataSource $ da.ds.Tables>[email protected]=ie%; da.DConClose"#;

,

private void *roupo4_)nter"ob3ect sender- )ventAr*s e# {

,

private void data8rid=ie%4_CellContentClicE"ob3ect sender-Data8rid=ie%Cell)ventAr*s e#

{



,

private void tt6serId_(e+1ress"ob3ect sender- (e+1ress)ventAr*s e# {

, ,,

1art+edit.cs

usin* S+stem;usin* S+stem.Collections.8eneric;usin* S+stem.ComponentModel;usin* S+stem.Data;usin* S+stem.Dra%in*;usin* S+stem.Tet;usin* S+stem.9indo%s.Forms;usin* RFID;

namespace RFID_ATM{ public partial class part+edit : Form { public part+edit"# { InitialieComponent"#; , Data_Access da $ ne% Data_Access"#;

private void part+edit_<oad"ob3ect sender- )ventAr*s e# { t5is.9indo%State $ Form9indo%State.Maimied; da.DReader"&select part+name 7rom part+master&#; cmbpart+name.Items.Add"&JJselectJJ&#; %5ile "da.dr.Read"## { cmbpart+name.Items.Add"da.dr.8et=alue"?#.ToStrin*"##;

,



cmbpart+name.SelectedInde $ ?; ,

private void cmbpart+name_SelectedIndeC5an*ed"ob3ect sender- )ventAr*s e#

{ ttpart+name.Tet $ &&; ttpart+name.Tet $ cmbpart+name.SelectedItem.ToStrin*"#; da.DReader"&Select part+s+mbol 7rom part+master %5ere part+name$& Gcmbpart+name.SelectedItem.ToStrin*"# G &&#; i7 "da.dr.Read"## {

,

, strin* 7ileDes- 7ileini; private void tnro%s_ClicE"ob3ect sender- )ventAr*s e# { !penFileDialo* dl* $ ne% !penFileDialo*"#; Dialo*Result dl*Res $ dl*.S5o%Dialo*"#; i7 "dl*Res K$ Dialo*Result.Cancel# { pictureo4.Ima*e<ocation $ dl*.File/ame; 7ileDes $ dl*.File/ame;

7ileini $ 7ileDes.Substrin*"7ileDes.<astInde!7"&LL&# G 4#; , ,

private void btnsave_ClicE"ob3ect sender- )ventAr*s e# { da.DCMD"&update part+master set part+name$& G ttpart+name .Tet G&-part+s+mbol$& G pictureo4 .Ima*e G & %5ere part+name$& Gcmbpart+name.SelectedItem.ToStrin*"# G &&#;

da.DCMDClose"#; Messa*eo.S5o%"&Success7ull+ 6pdated&#; ttpart+name.Tet $ &&; pictureo4.Ima*e $ null; cmbpart+name.SelectedInde $ ?; ,

private void ttpart+name_(e+1ress"ob3ect sender- (e+1ress)ventAr*s e# {

i7 "Kc5ar.IsControl"e.(e+C5ar# c5ar.IsDi*it"e.(e+C5ar# #



{ e.'andled $ true; , strin* arr $ &KNOPHQ"#G$J>@LLL;-.2{,L&:BU&;

7or "int E $ ?; E B arr.<en*t5; EGG# { i7 "e.(e+C5ar $$ arr>E@# { e.'andled $ true; breaE;

, ,

,

private void button4_ClicE"ob3ect sender- )ventAr*s e# { t5is.Close"#; ,

private void btnne%_ClicE"ob3ect sender- )ventAr*s e# { pictureo4.Ima*e $ null;

ttpart+name.Tet $ &&; cmbpart+name.SelectedInde $ ?; ,

,

,

7.2 SAMPLE SCREENSHOTS



FIG. 8.2a Home Page for E!o"#$g

FIG. 8.2% Log#$ Page for E!o"#$



FIG. 8.2& Log#$ Page for A'm#$ De"a#()

FIG. 8.2' Log#$ Page for *)er De"a#()



FIG. 8.2e S+o,) "+e *)er I$forma"#o$

FIG. 8.2f S+o,) "+e Reg#)"ra"#o$ for a Ne, Par"-



FIG. 8.2g Ca$'#'a"e Reg#)"ra"#o$ )&&e))f((- )a/e'

FIG. 8.2+ *)er !o"#$g Log#$ Page



FIG. 8.2# *)er !o"er #) a''e' )&&e))f((-

FIG. 8.20 S+o,) "+e Page for E(e&"#o$ Re)("

chapter 7- system coding

Documents