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