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(); }