/// <summary>
/// [Bug] Xóa Item có Liên Kết khóa ngoại với bảng Vật Tư
/// </summary>
/// <returns>bool</returns>
public int Delete(DM_Don_vi_tinh dvt)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
help.ent.DM_Don_vi_tinh.Attach(dvt);
help.ent.DM_Don_vi_tinh.Remove(dvt);
return help.ent.SaveChanges();
//Mở
//m_dbConnection.Open();
////Chuẩn bị
//string sql = "";
//sql += "Delete from DM_Don_vi_tinh ";
//sql += "WHERE ID_Don_vi_tinh=@ID_Don_vi_tinh";
//SqlCommand command = new SqlCommand(sql, m_dbConnection);
//command.Parameters.Add("@ID_Don_vi_tinh", SqlDbType.Int).Value = ID_Don_vi_tinh;
//command.CommandType = CommandType.Text;
////Run
//int result = command.ExecuteNonQuery();
////Đóng
//m_dbConnection.Close();
//return result;
}
/// <summary>
/// Update ALL
/// </summary>
/// <returns></returns>
public int Update(DM_Don_vi_tinh dvt)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
int temp = 0;
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
using (var context = help.ent)
{
context.DM_Don_vi_tinh.Attach(dvt);
context.Entry(dvt).State = EntityState.Modified;
temp = help.ent.SaveChanges();
dbcxtransaction.Commit();
}
}
return temp;
////Mở
//m_dbConnection.Open();
////Chuẩn bị
//string sql = "";
//sql += "UPDATE DM_Don_vi_tinh ";
////sql += "Set ID_Don_vi_tinh=@ID_Don_vi_tinh, ";
//sql += "SET Ten_don_vi_tinh=@Ten_don_vi_tinh ";
//sql += "WHERE ID_Don_vi_tinh=@ID_Don_vi_tinh";
//SqlCommand command = new SqlCommand(sql, m_dbConnection);
//command.Parameters.Add("@ID_Don_vi_tinh", SqlDbType.Int).Value = ID_Don_vi_tinh;
//command.Parameters.Add("@Ten_don_vi_tinh", SqlDbType.NVarChar, 50).Value = Ten_don_vi_tinh;
//command.CommandType = CommandType.Text;
////Run
//int result = command.ExecuteNonQuery();
////Đóng
//m_dbConnection.Close();
//return result;
}
