//Hàm xóa
public bool XoaDuLieu(EC_PhanCong_Day ec)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "dbo.[MonHoc_Delete_By_Ma]";
cmd.CommandType = CommandType.StoredProcedure;
try
{
con.MoKetNoi();
// Use connection object of base class
cmd.Connection = con.connect;
cmd.Parameters.AddWithValue("@Ma_MonHoc", ec.Ma_MonHoc);
cmd.Parameters.AddWithValue("@Ma_GiaoVien", ec.Ma_GiaoVien);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
throw new Exception("Lỗi khi xóa: " + e.ToString());
}
finally
{
con.DongKetNoi();
cmd.Dispose();
}
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(EC_PhanCong_Day businessObject, IDataReader dataReader)
{
businessObject.Ma_GiaoVien = dataReader.GetString(dataReader.GetOrdinal(EC_PhanCong_Day.PhanCong_DayFields.Ma_GiaoVien.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_PhanCong_Day.PhanCong_DayFields.Ma_MonHoc.ToString())))
{
businessObject.Ma_MonHoc = dataReader.GetString(dataReader.GetOrdinal(EC_PhanCong_Day.PhanCong_DayFields.Ma_MonHoc.ToString()));
}
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of SinhVien</returns>
internal List <EC_PhanCong_Day> PopulateObjectsFromReader(IDataReader dataReader)
{
List <EC_PhanCong_Day> list = new List <EC_PhanCong_Day>();
while (dataReader.Read())
{
EC_PhanCong_Day businessObject = new EC_PhanCong_Day();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
public void XoaDuLieu(EC_PhanCong_Day ec)
{
sql.XoaDuLieu(ec);
}
public void ThemDuLieu(EC_PhanCong_Day ec)
{
sql.ThemDuLieu(ec);
}
