private BangDiemChiTiet BangDiemChiTietIDataReader(IDataReader Reader)
{
BangDiemChiTiet obj = new BangDiemChiTiet();
obj.IdBangDiemChiTiet = (Reader["IdBangDiemChiTiet"] is DBNull) ? int.MinValue : (int)Reader["IdBangDiemChiTiet"];
obj.IdBangDiemTongQuat = (Reader["IdBangDiemTongQuat"] is DBNull) ? int.MinValue : (int)Reader["IdBangDiemTongQuat"];
obj.MaDauDiem = (Reader["MaDauDiem"] is DBNull) ? int.MinValue : (int)Reader["MaDauDiem"];
obj.TenDauDiem = (Reader["TenDauDiem"] is DBNull) ? string.Empty : (string)Reader["TenDauDiem"];
obj.TrongSo = (Reader["TrongSo"] is DBNull) ? double.MinValue : (double)Reader["TrongSo"];
obj.Diem = (Reader["Diem"] is DBNull) ? double.MinValue : (double)Reader["Diem"];
return(obj);
}
public int ThemBangDiemChiTiet(BangDiemChiTiet obj)
{
using (SqlConnection conn = getConnect())
{
try
{
conn.Open();
SqlCommand myCommand = new SqlCommand("Insert into BangDiemChiTiet values('" + obj.IdBangDiemChiTiet + "','" + obj.IdBangDiemTongQuat + "','" + obj.MaDauDiem + "',N'" + obj.TenDauDiem + "','" + obj.TrongSo + "','" + obj.Diem + "') ", conn);
myCommand.CommandType = CommandType.Text;
myCommand.ExecuteNonQuery();
conn.Close();
return(1);
}
catch
{
return(0);
}
}
}
public int SuaBangDiemChiTiet(BangDiemChiTiet obj)
{
using (SqlConnection conn = getConnect())
{
try
{
conn.Open();
SqlCommand myCommand = new SqlCommand("Update BangDiemChiTiet set Diem = '" + obj.Diem + "' where IdBangDiemChiTiet = '" + obj.IdBangDiemChiTiet + "' and IdBangDiemTongQuat = '" + obj.IdBangDiemTongQuat + "' ", conn);
myCommand.CommandType = CommandType.Text;
myCommand.ExecuteNonQuery();
conn.Close();
BangDiemTongQuatDAL db = new BangDiemTongQuatDAL();
db.CapNhatDiemTrungBinh(obj.IdBangDiemTongQuat, TinhDiemTrungBinh(obj.IdBangDiemTongQuat));
return(1);
}
catch
{
return(0);
}
}
}
