public bool AddSurcharge(PalletForceOrder order, int extraTypeID, string userName) { EF.DataContext DB = EF.DataContext.Current; VigoOrder vo = DB.VigoOrderSet.Include("VigoOrderExtras").FirstOrDefault(o => o.OrderId == order.OrderID); var extraTypes = DB.ExtraTypeSet.ToList(); if (vo.VigoOrderExtras.FirstOrDefault(e => e.ExtraType.ExtraTypeId == extraTypeID) == null) { var extraType = extraTypes.FirstOrDefault(et => et.ExtraTypeId == extraTypeID); if (extraType != null) { VigoOrderExtra extra = new VigoOrderExtra(); extra.ExtraType = extraType; vo.VigoOrderExtras.Add(extra); } } DB.SaveChanges(); return(true); }
public bool RemoveSurcharge(PalletForceOrder order, int extraTypeID, string userName) { try { EF.DataContext DB = EF.DataContext.Current; VigoOrder vo = DB.VigoOrderSet.Include("VigoOrderExtras").Include("VigoOrderExtras.ExtraType").FirstOrDefault(o => o.OrderId == order.OrderID); if (vo.VigoOrderExtras.FirstOrDefault(e => e.ExtraType.ExtraTypeId == extraTypeID) != null) { VigoOrderExtra extra = vo.VigoOrderExtras.FirstOrDefault(e => e.ExtraType.ExtraTypeId == extraTypeID); vo.VigoOrderExtras.Remove(extra); DB.DeleteObject(extra); } DB.SaveChanges(); return(true); } catch (Exception ex) { throw; } return(true); }