// mot ham lay du lieu cua sinh vien de add private SV getInforSV_GUI() { SV s = new SV(); s.MSSV = txtMSSV.Text; s.NameSV = txtName.Text; if (rdFemale.Checked) { s.Gender = false; } else { s.Gender = true; } s.NS = dateTimePicker1.Value; s.ID_Lop = ((CBBItems)cbbLSH.SelectedItem).Value; return(s); }
public void updateSV_BLL(SV s) { DAL_QLSV.Instance.updateSV_DAL(s); }
public void addSV_DAL(SV s) { string querry = "insert into dbo.SV values('" + s.MSSV + "','" + s.NameSV + "','" + s.Gender + "','" + s.NS + "','" + s.ID_Lop + "')"; DBHelper.Instance.ExecuteDB(querry); }
//ham add Sv public void addSV_BLL(SV s) { DAL_QLSV.Instance.addSV_DAL(s); }
//lam mot ham update SV public void updateSV_DAL(SV s) { string querry = "update dbo.SV set NameSV = '" + s.NameSV + "',Gender='" + s.Gender + "',NS='" + s.NS + "',ID_Lop='" + s.ID_Lop + "' where MSSV='" + s.MSSV + "'"; DBHelper.Instance.ExecuteDB(querry); }
public static Boolean CmpID_Lop(SV s1, SV s2) { return((s1.ID_Lop > s2.ID_Lop) ? true : false); }
public static Boolean CmpNS(SV s1, SV s2) { return((String.Compare(Convert.ToString(s1.NS), Convert.ToString(s2.NS)) > 0) ? true : false); }
public static Boolean CmpGender(SV s1, SV s2) { return((String.Compare(Convert.ToString(s1.Gender), Convert.ToString(s2.Gender)) > 0) ? true : false); }
public static Boolean CmpNameSV(SV s1, SV s2) { return((String.Compare(s1.NameSV, s2.NameSV) > 0) ? true : false); }