public bool Create(ConsolidateSingleModel model) { using (var db = new EntityContext()) { using (var dbtransact = db.Database.BeginTransaction()) { TbConsolidateList consolidation = new TbConsolidateList { ConsolidatedDate = DateTime.Now, AmountOfItem = model.ItemId.Length, Customer = db.tbCustomers.FirstOrDefault(x => x.Id == model.CustomerId), Fee = model.Fee, }; db.tbConsolidateLists.Add(consolidation); db.SaveChanges(); db.Entry(consolidation).State = EntityState.Modified; consolidation.ConsolidateNumber = consolidation.Id.ToString().PadRight(6, '0'); db.SaveChanges(); foreach (var item in model.ItemId) { TbConsolidatedItems it = new TbConsolidatedItems { Consolidator = consolidation, Items = db.TbItems.FirstOrDefault(x => x.Id == item) }; db.tbConsolidatedItems.Add(it); } db.SaveChanges(); dbtransact.Commit(); return(true); } } }
public bool Update(ConsolidateSingleModel model) { throw new NotImplementedException(); }