public static void AddOrderItems(OrderHeader orderHeader, int lastOrderId) { IstokDoorsDBContext db = new IstokDoorsDBContext(); foreach (var item in orderHeader.OrderItems) { db.usp_CreateOrderItem(lastOrderId, item.DoorId, item.Quantity, item.Discount); } db.SaveChanges(); }
public static void EditOrderHeaderData(OrderHeader orderHeader) { IstokDoorsDBContext db = new IstokDoorsDBContext(); var dbOrderHeader = db.OrderHeaders.Find(orderHeader.OrderId); dbOrderHeader.Memo = orderHeader.Memo; dbOrderHeader.PaymentTermId = orderHeader.PaymentTermId; dbOrderHeader.IsPaid = orderHeader.IsPaid; dbOrderHeader.PaymentReferece = orderHeader.PaymentReferece; db.SaveChanges(); }
public static void AddOrderHeaderData(OrderHeader orderHeader) { IstokDoorsDBContext db = new IstokDoorsDBContext(); OrderHeader myOrderHeader = new OrderHeader(); myOrderHeader.PaymentTermId = orderHeader.PaymentTermId; myOrderHeader.CustomerId = orderHeader.CustomerId; myOrderHeader.Memo = orderHeader.Memo; db.OrderHeaders.Add(myOrderHeader); db.SaveChanges(); }
//*********************** VALUES FOR PRODUCTION JOURNAL'S "IS MANUFACTURED" DDL public static void GetValuesForPrdJrnlIsManufacturedDDL(IEnumerable<ProductionJournal> orders) { var db = new IstokDoorsDBContext(); foreach (var item in orders) { var dropDownListItems = new List<SelectListItem>(); for (int i = item.IsManufacturedForBatch; i < item.ToBeManufacturedForBatch + 1; i++) { dropDownListItems.Add(new SelectListItem { Text = i.ToString(CultureInfo.InvariantCulture), Value = i.ToString(CultureInfo.InvariantCulture), }); } var selectedItem = dropDownListItems.First(x => x.Value == item.IsManufacturedForBatch.ToString()); selectedItem.Selected = true; item.DropDownListItems = dropDownListItems; } db.SaveChanges(); }
//*********************** VALUES FOR PLANNING JOURNAL'S "ALLOCATE FROM INVENTORY" DDL ************// public static void GetValuesForPlnJrnlLAllocateFromInvtrDDL(IEnumerable<PlanningJournal> orders) { var db = new IstokDoorsDBContext(); foreach (var item in orders) { var dropDownListItems = new List<SelectListItem>(); for (int i = 0; i < item.AllocValueForDDList + 1; i++) { dropDownListItems.Add(new SelectListItem { Text = i.ToString(CultureInfo.InvariantCulture), Value = i.ToString(CultureInfo.InvariantCulture), }); } var selectedItem = dropDownListItems.First(x => x.Value == item.AllocateFromInventory.ToString()); selectedItem.Selected = true; item.DropDownListItems = dropDownListItems; } db.SaveChanges(); }