/// <summary>
/// Update ALL
/// </summary>
/// <returns></returns>
public int Update(DM_Vat_Tu vt)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
int temp = 0;
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
using (var context = help.ent)
{
context.DM_Vat_Tu.Attach(vt);
context.Entry(vt).State = EntityState.Modified;
temp = help.ent.SaveChanges();
dbcxtransaction.Commit();
}
}
return temp;
////Mở
//m_dbConnection.Open();
////Chuẩn bị
//string sql = "";
//sql += "UPDATE DM_Vat_Tu ";
//sql += "Set Ma_vat_tu=@Ma_vat_tu, ";
//sql += "Ten_vat_tu=@Ten_vat_tu, ";
//sql += "ID_Don_vi_tinh=@ID_Don_vi_tinh, ";
//sql += "Mo_ta=@Mo_ta ";
//sql += "WHERE Ma_vat_tu=@old_Ma_vat_tu";
//SqlCommand command = new SqlCommand(sql, m_dbConnection);
//command.Parameters.Add("@Ma_vat_tu", SqlDbType.VarChar, 50).Value = Ma_vat_tu;
//command.Parameters.Add("@old_Ma_vat_tu", SqlDbType.VarChar, 50).Value = old_Ma_vat_tu;
//command.Parameters.Add("@Ten_vat_tu", SqlDbType.NVarChar, 50).Value = Ten_vat_tu;
//command.Parameters.Add("@ID_Don_vi_tinh", SqlDbType.Int).Value = ID_Don_vi_tinh;
//command.Parameters.Add("@Mo_ta", SqlDbType.NVarChar, 50).Value = Mo_ta;
//command.CommandType = CommandType.Text;
////Run
//int result = command.ExecuteNonQuery();
////Đóng
//m_dbConnection.Close();
//return result;
}
/// <summary>
/// Xoa by ID
/// </summary>
/// <returns>bool</returns>
public int Delete(DM_Vat_Tu vt)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
help.ent.DM_Vat_Tu.Attach(vt);
help.ent.DM_Vat_Tu.Remove(vt);
help.ent.SaveChanges();
dbcxtransaction.Commit();
return 1;
}
////Mở
//m_dbConnection.Open();
////Chuẩn bị
//string sql = "";
//sql += "Delete from DM_Vat_Tu ";
//sql += "WHERE Ma_vat_tu=@Ma_vat_tu";
//SqlCommand command = new SqlCommand(sql, m_dbConnection);
//command.Parameters.Add("@Ma_vat_tu", SqlDbType.VarChar, 50).Value = Ma_vat_tu;
//command.CommandType = CommandType.Text;
////Run
//int result = command.ExecuteNonQuery();
////Đóng
//m_dbConnection.Close();
//return result;
}
