public bool UpdateHocSinh(HOCSINH hs, PHANLOP pl)
{
try
{
SQLDataContext.SQLData.sp_SuaThongtinHocSinh(hs.MAHS, hs.HOTEN, hs.GIOITINH, hs.NGAYSINH, hs.DIACHI, hs.EMAIL, hs.TONGIAO, hs.HOTENCHAC, hs.NGHENGHIEPCHA, hs.HOTENME, hs.NGHENGHIEPME, pl.MALOP, hs.IMAGEE);
return(true);
}
catch
{
return(false);
}
}
public int ThemHocSinh(HOCSINH hs, PHANLOP pl)
{
try
{
var a = SQLDataContext.SQLData.sp_ThemHocSinh(hs.MAHS, hs.HOTEN, hs.GIOITINH, hs.NGAYSINH, hs.DIACHI, hs.EMAIL, hs.TONGIAO, hs.HOTENCHAC, hs.NGHENGHIEPCHA, hs.HOTENME, hs.NGHENGHIEPME, pl.MALOP, pl.MANAMHOC, pl.MAKHOI, hs.IMAGEE);
return(int.Parse(a.ToString()));
}
catch
{
return(1);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cbbDesClass.Text != "" && cbbDesTerm.Text != "" && cbbDesGrade.Text != "")
{
foreach (DataGridViewRow _studentDesItem in dGVDes.Rows)
{
if (_studentDesItem.Cells[2].Value == null)
{
var _checkClassQuery = (from P in frmLogin._database.GetTable <PHANLOP>()
where P.mahs == _studentDesItem.Cells[0].Value.ToString()
select P).ToList();
if (_checkClassQuery.Count == 1)
{
_checkClassQuery[0].manh = _idDesTerm[cbbDesTerm.SelectedIndex];
_checkClassQuery[0].makl = _idDesGrade[cbbDesGrade.SelectedIndex];
_checkClassQuery[0].malop = _idDesClass[cbbDesClass.SelectedIndex];
}
else
{
PHANLOP _newMember = new PHANLOP();
_newMember.mahs = _studentDesItem.Cells[0].Value.ToString();
_newMember.manh = _idDesTerm[cbbDesTerm.SelectedIndex];
_newMember.malop = _idDesClass[cbbDesClass.SelectedIndex];
_newMember.makl = _idDesGrade[cbbDesGrade.SelectedIndex];
frmLogin._database.PHANLOPs.InsertOnSubmit(_newMember);
}
}
}
try
{
frmLogin._database.SubmitChanges();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
