Ejemplo n.º 1
0
        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));
        }
Ejemplo n.º 2
0
 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);
     }
 }
Ejemplo n.º 3
0
        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));
        }
Ejemplo n.º 4
0
 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);
     }
 }
Ejemplo n.º 5
0
        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());
        }
Ejemplo n.º 6
0
 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);
     }
 }