// 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);
}
