public static int Update(DatabaseHelper help, Chi_Tiet_Phieu_Nhap_Vat_Tu pn)
{
try
{
{
{
help.ent.Chi_Tiet_Phieu_Nhap_Vat_Tu.Attach(pn);
help.ent.Entry(pn).State = EntityState.Modified;
help.ent.SaveChanges();
}
}
return 1;
}
catch (Exception ex)
{
return 0;
}
}
public int removebyKey(SQLDAL DAL, string ma_Phieunhap, string ma_vat_tu)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
Chi_Tiet_Phieu_Nhap_Vat_Tu deptBook = new Chi_Tiet_Phieu_Nhap_Vat_Tu { Ma_vat_tu = ma_vat_tu, Ma_phieu_nhap = ma_Phieunhap };
help.ent.Entry(deptBook).State = EntityState.Deleted;
help.ent.SaveChanges();
dbcxtransaction.Commit();
return 1;
}
return 0;
}
public int Update(Chi_Tiet_Phieu_Nhap_Vat_Tu pn)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
int temp = 0;
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
using (var context = help.ent)
{
context.Chi_Tiet_Phieu_Nhap_Vat_Tu.Attach(pn);
context.Entry(pn).State = EntityState.Modified;
temp = help.ent.SaveChanges();
dbcxtransaction.Commit();
}
}
return temp;
}
public int Delete(Chi_Tiet_Phieu_Nhap_Vat_Tu pn)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
help.ent.Chi_Tiet_Phieu_Nhap_Vat_Tu.Attach(pn);
help.ent.Chi_Tiet_Phieu_Nhap_Vat_Tu.Remove(pn);
return help.ent.SaveChanges();
}
