public async Task <IActionResult> Edit(long id, [Bind("order_id,cust_id,pickup_dri_id,sp_id,status_id,order_weight,order_pickup_add,order_deliver_add,deliver_dri_id,request_time,awaiting_pickup_time,pickup_time,washing_time,washing_completed_time,delivering_time,delivered_time,order_amount,payment_method")] Order_Header order_Header) { if (id != order_Header.order_id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(order_Header); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Order_HeaderExists(order_Header.order_id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(order_Header)); }
public Boolean SaveLog(Order_Header record) { try { var log = new Order_Header_Log { OrderNumber = record.OrderNumber, FacilityCode = record.FacilityCode, OrderStatusId = System.Convert.ToInt32(record.OrderStatusId), OrderStatusChangedBy = new UserManagement().getCurrentuser(), OrderStatusDateChanged = DateTime.Now, StartDate = record.StartDate, EndDate = record.EndDate, DatePrepared = record.DatePrepared, OrderTypeId = record.OrderTypeId, ProductCategoryId = 2 }; context.Order_Header_Log.Add(log); context.SaveChanges(); return(true); } catch (Exception e) { throw (e); } }
public async Task <IActionResult> Create([Bind("order_id,cust_id,pickup_dri_id,sp_id,status_id,order_weight,order_pickup_add,order_deliver_add,deliver_dri_id,request_time,awaiting_pickup_time,pickup_time,washing_time,washing_completed_time,delivering_time,delivered_time,order_amount,payment_method")] Order_Header order_Header) { if (ModelState.IsValid) { _context.Add(order_Header); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(order_Header)); }
public Boolean Save() { try { if (GetRecordByKey(mOrderNumber) == null) { var x = new Order_Header { OrderNumber = mOrderNumber, FacilityCode = mFacilityCode, StartDate = mStartDate, EndDate = mEndDate, DatePrepared = mDatePrepared, EditedBy = new UserManagement().getCurrentuser(), EditedDate = mEditedDate, //EmergencyOrder = mEmergencyOrder, FinalSubmission = mFinalSubmission, OrderTypeId = mOrderTypeId, OrderStatusId = mOrderStatusId, OrderStatusIdChangedBy = mOrderStatusIdChangedBy, OrderStatusIdDateChanged = mOrderStatusIdDateChanged, DateExpected = mDateExpected, RFSO_SentBackTofacility = mRFSO_SentBackTofacility }; context.Order_Header.Add(x); //////SaveLog(x); context.SaveChanges(); ////SaveLog(x); return(true); } else { return(false); } } catch (Exception x) { throw (x); } }
public IActionResult Index(SelectedItemsViewModel model) { if (model.SelecedIds != null) { string[] ItemsIDs = model.SelecedIds.Split(','); int[] myInts = Array.ConvertAll(ItemsIDs, int.Parse); var selected = model.Items.Where(t => myInts.Contains(t.ItemD)).ToList(); if (selected != null && selected.Count > 0) { List <Order_Details> order_DetailsList = new List <Order_Details>(); var userId = _userManager.GetUserId(User); var CheckUserHasOrder = _appDbContext.order_Header.FirstOrDefault(i => i.CustomerID == userId && i.Status == "Pending"); if (CheckUserHasOrder != null) { foreach (var item in selected) { Order_Details order_Details = new Order_Details(); order_Details.ItemName = item.Name; order_Details.ItemID = item.ItemD; order_Details.ItemPrice = item.Price; order_Details.Quantity = item.Quantity; order_Details.TotalPrice = (item.Price - item.Discount) * item.Quantity; order_Details.Uom = item.Uom; order_Details.Discount = item.Discount; order_Details.Order_Header = CheckUserHasOrder; order_DetailsList.Add(order_Details); } _appDbContext.order_Details.AddRange(order_DetailsList); _appDbContext.SaveChanges(); return(RedirectToAction("GetCardItems", "Home", new { @OrderID = CheckUserHasOrder.Order_Header_ID })); } else { Order_Header order_Header = new Order_Header(); order_Header.OrderDate = DateTime.Now; order_Header.CustomerID = userId; order_Header.Status = "Pending"; order_Header.Tax = 14; foreach (var item in selected) { Order_Details order_Details = new Order_Details(); order_Details.ItemName = item.Name; order_Details.ItemID = item.ItemD; order_Details.ItemPrice = item.Price; order_Details.Quantity = item.Quantity; order_Details.TotalPrice = (item.Price - item.Discount) * item.Quantity; order_Details.Uom = item.Uom; order_Details.Discount = item.Discount; order_DetailsList.Add(order_Details); } order_Header.Order_Details = order_DetailsList; _appDbContext.order_Header.Add(order_Header); _appDbContext.SaveChanges(); return(RedirectToAction("GetCardItems", "Home", new { @OrderID = order_Header.Order_Header_ID })); } } } return(View()); }
public Boolean SaveART(string OrderNo) { try { var allocated = context.Order_DrugDetails.Where(o => o.OrderNumber == OrderNo && o.Quantity_Allocated > 0).ToList().Count; if (allocated > 0) { if (GetRecordByKey(OrderNo) != null) { Order_Header t = new Order_Header(); t = GetRecordByKey(OrderNo); //DateTime eDate = t.EndDate; DateTime pDate = System.Convert.ToDateTime(t.DatePrepared); int facility = t.FacilityCode; var sapcode = context.A_Facilities.FirstOrDefault(a => a.FacilityCode == facility).SAP_Code; var x = new SAP_ExportHeader { OrderNumber = t.OrderNumber, AddedDate = System.DateTime.Now, AddedBy = new UserManagement().getCurrentuser(), CurrentReccord = true, RecordReadBySAP = false, DocNum = System.Convert.ToString(System.Convert.ToDateTime(pDate).Day + "" + System.Convert.ToDateTime(pDate).Month + "" + System.Convert.ToDateTime(pDate).Year + "" + facility), DocDate = System.Convert.ToDateTime(pDate), DocDueDate = System.Convert.ToDateTime(pDate), CardCode = sapcode,// t.A_Facilities.SAP_Code, DocEntry = mDocEntry, ProductCategory = 2, }; var order = context.SAP_ExportHeader.FirstOrDefault(o => o.OrderNumber == OrderNo); if (order == null) { context.SAP_ExportHeader.Add(x); context.SaveChanges(); } SAPExportDetails details = new SAPExportDetails(); details.SaveART(OrderNo); //var update = t; //update.OrderStatusId = 4; //context.Entry(t).CurrentValues.SetValues(update); //context.Entry(t).State = EntityState.Modified; //context.SaveChanges(); return(true); } else { // existing_records = true; return(false); } } else { // existing_records = true; return(false); } } catch (Exception x) { throw (x); } }