/// <summary>
/// Cập nhật lại table DIEM và BANGDIEM trong database
/// </summary>
public void UpdateDiem(BangDiemHocSinh _BangDiem, String _NamHoc, int _MaHocKy, String _MaMon)
{
int?_MaDiem15 = _BangDiem._MaDiem15;
int?_MaDiem1T = _BangDiem._MaDiem1T;
int?_MaDiemHK = _BangDiem._MaDiemHK;
if (_BangDiem._MaDiem15 != null)
{
DB.usp_UpdateDiem(_BangDiem._MaDiem15, "D15", _BangDiem._Diem15);
}
else
{
if (_BangDiem._Diem15 != null)
{
_MaDiem15 = LayMaDiemCuoi() + 1;
DB.usp_InsertDiem(_MaDiem15, "D15", _BangDiem._Diem15);
}
}
if (_BangDiem._MaDiem1T != null)
{
DB.usp_UpdateDiem(_BangDiem._MaDiem1T, "D1T", _BangDiem._Diem1Tiet);
}
else
{
if (_BangDiem._Diem1Tiet != null)
{
_MaDiem1T = LayMaDiemCuoi() + 1;
DB.usp_InsertDiem(_MaDiem1T, "D1T", _BangDiem._Diem1Tiet);
}
}
if (_BangDiem._MaDiemHK != null)
{
DB.usp_UpdateDiem(_BangDiem._MaDiemHK, "DHK", _BangDiem._DiemHK);
}
else
{
if (_BangDiem._DiemHK != null)
{
_MaDiemHK = LayMaDiemCuoi() + 1;
DB.usp_InsertDiem(_MaDiemHK, "DHK", _BangDiem._DiemHK);
}
}
DB.usp_UpdateBangdiem(_BangDiem._MaHocSinh, _MaMon, _MaHocKy, _NamHoc, _MaDiem15, _MaDiem1T, _MaDiemHK);
}
