private BangDiemTongQuat BangDiemTongQuatIDataReader(IDataReader Reader)
{
BangDiemTongQuat obj = new BangDiemTongQuat();
obj.IdBangDiemTongQuat = (Reader["IdBangDiemTongQuat"] is DBNull) ? int.MinValue : (int)Reader["IdBangDiemTongQuat"];
obj.MaUngSinh = (Reader["MaUngSinh"] is DBNull) ? int.MinValue : (int)Reader["MaUngSinh"];
obj.MaGiaiDoan = (Reader["MaGiaiDoan"] is DBNull) ? int.MinValue : (int)Reader["MaGiaiDoan"];
obj.MaHocKy = (Reader["MaHocKy"] is DBNull) ? int.MinValue : (int)Reader["MaHocKy"];
obj.MaMonHoc = (Reader["MaMonHoc"] is DBNull) ? int.MinValue : (int)Reader["MaMonHoc"];
obj.MaLop = (Reader["MaLop"] is DBNull) ? int.MinValue : (int)Reader["MaLop"];
obj.DiemTrungBinh = (Reader["DiemTrungBinh"] is DBNull) ? double.MinValue : (double)Reader["DiemTrungBinh"];
return(obj);
}
public int SuaBangDiemTongQuat(BangDiemTongQuat obj)
{
using (SqlConnection conn = getConnect())
{
try
{
conn.Open();
SqlCommand myCommand = new SqlCommand("Update BangDiemTongQuat set MaUngSinh = '" + obj.MaUngSinh + "', MaGiaiDoan = '" + obj.MaGiaiDoan + "', MaHocKy = '" + obj.MaHocKy + "', MaMonHoc = '" + obj.MaMonHoc + "', MaLop = '" + obj.MaLop + "', DiemTrungBinh = '" + obj.DiemTrungBinh + "' where IdBangDiemTongQuat = '" + obj.IdBangDiemTongQuat + "' ", conn);
myCommand.CommandType = CommandType.Text;
myCommand.ExecuteNonQuery();
conn.Close();
return(1);
}
catch
{
return(0);
}
}
}
public int ThemBangDiemTongQuat(BangDiemTongQuat obj)
{
using (SqlConnection conn = getConnect())
{
try
{
conn.Open();
SqlCommand myCommand = new SqlCommand("Insert into BangDiemTongQuat values('" + obj.MaUngSinh + "','" + obj.MaGiaiDoan + "','" + obj.MaHocKy + "','" + obj.MaMonHoc + "','" + obj.MaLop + "','" + obj.DiemTrungBinh + "') ", conn);
myCommand.CommandType = CommandType.Text;
myCommand.ExecuteNonQuery();
conn.Close();
return(1);
}
catch
{
return(0);
}
}
}
