public static void insert(P_BienBanGiaoNhan obj,List<P_BienBan_CT_Phieu> lstCTPhieu,List<P_DonDatHang_CT_Phieu> lstDDHCTPhieu) { using(var model= ModelConnector.Connector()) { using(var trans= model.Database.BeginTransaction()) { try { model.P_BienBanGiaoNhan.Add(obj); model.P_BienBan_CT_Phieu.AddRange(lstCTPhieu); foreach (var item in lstDDHCTPhieu) { model.Entry(item).State = System.Data.Entity.EntityState.Modified; } model.SaveChanges(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new Exception(ex.ToString()); } } } }
public static void update(P_BienBanGiaoNhan obj,List<P_BienBan_CT_Phieu> lstCTPhieu,List<P_DonDatHang_CT_Phieu> lstDDHCTPhieu) { using(var model= ModelConnector.Connector()) { using(var tran= model.Database.BeginTransaction()) { try { model.Entry(obj).State = System.Data.Entity.EntityState.Modified; var listBB_CT = (from a in model.P_BienBan_CT_Phieu where a.SoBienBan == obj.SoBienBan select a).ToList(); foreach (var item in listBB_CT) { model.Entry(item).State = System.Data.Entity.EntityState.Deleted; var objPhieu = lstDDHCTPhieu.Where(a => a.SoPhieu == item.SoPhieu).FirstOrDefault(); if (objPhieu == null) { objPhieu = model.P_DonDatHang_CT_Phieu.Where(a => a.SoPhieu == item.SoPhieu).First(); objPhieu.TinhTrang = 0; model.Entry(objPhieu).State = System.Data.Entity.EntityState.Modified; } } model.P_BienBan_CT_Phieu.AddRange(lstCTPhieu); foreach (var item in lstDDHCTPhieu) { model.Entry(item).State = System.Data.Entity.EntityState.Modified; } model.SaveChanges(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw new Exception(ex.ToString()); } } } }
private void gridView_DoubleClick(object sender, EventArgs e) { int row = gridView.FocusedRowHandle; if (row < 0) return; P_BienBanGiaoNhan obj = new P_BienBanGiaoNhan(); obj = (P_BienBanGiaoNhan)gridView.GetFocusedRow(); fLapBienBan f = new fLapBienBan(true, obj); f.WindowState = FormWindowState.Maximized; f.ShowDialog(); }