public ActionResult UpdateOrders(OrderUpdateView OUV) { DataManager DM = new DataManager(); DM.UpdateOrder(OUV); return(Json(new { success = true, message = "Updated Successfully!" }, JsonRequestBehavior.AllowGet)); }
public ActionResult UpdateOrders(int id = 0) { OrderUpdateView OUV = new OrderUpdateView(); DataManager DM = new DataManager(); OUV = DM.CreateOUView(id); return(View(OUV)); }
public OrderUpdateView CreateOUView(int id) { using (CMSProjectEntities db = new CMSProjectEntities()) { var OrderList = db.CustomerOrders.ToList(); CustomerOrder order = db.CustomerOrders.Where(o => o.OrderID.Equals(id)).FirstOrDefault(); OrderUpdateView orders = new OrderUpdateView(); //Orders orders.OrderID = order.OrderID; orders.CustomerID = order.CustomerID; orders.OrderDate = order.OrderDate; if (order.ShippedDate.HasValue) { orders.ShippedDate = order.ShippedDate.GetValueOrDefault(); } else { orders.ShippedDate = null; } orders.PickupAddressID = order.PickupAddressID; orders.ShippingAddressID = order.ShippingAddressID; orders.Weight = order.Weight; orders.OrderValue = order.OrderValue; //Tracking orders.TrackingID = db.TrackingTBLs.Where(o => o.OrderID.Equals(orders.OrderID)).FirstOrDefault().TrackingID; orders.PickupBranchID = db.TrackingTBLs.Where(o => o.TrackingID.Equals(orders.TrackingID)).FirstOrDefault().PickupBranchID.GetValueOrDefault(); orders.ShippingBranchID = db.TrackingTBLs.Where(o => o.TrackingID.Equals(orders.TrackingID)).FirstOrDefault().ShippingBranchID.GetValueOrDefault(); orders.OrderStatusID = db.TrackingTBLs.Where(o => o.TrackingID.Equals(orders.TrackingID)).FirstOrDefault().OrderStatusID; //Payment orders.PaymentID = db.PaymentTBLs.Where(o => o.OrderID.Equals(orders.OrderID)).FirstOrDefault().PaymentID; if (db.PaymentTBLs.Where(o => o.PaymentID.Equals(orders.PaymentID)).FirstOrDefault().PaymentDate.HasValue) { orders.PaymentDate = db.PaymentTBLs.Where(o => o.PaymentID.Equals(orders.PaymentID)).FirstOrDefault().PaymentDate.GetValueOrDefault(); } else { orders.PaymentDate = null; } orders.PaymentStatusID = db.PaymentTBLs.Where(o => o.PaymentID.Equals(orders.PaymentID)).FirstOrDefault().PaymentStatusID; //Extras var paddr = db.Addresses.Where(o => o.AddressID.Equals(orders.PickupAddressID)).FirstOrDefault(); orders.PickupAddress = paddr.StreetAddress + ", " + paddr.City + ", " + paddr.State + " - " + paddr.Pincode; var saddr = db.Addresses.Where(o => o.AddressID.Equals(orders.ShippingAddressID)).FirstOrDefault(); orders.ShippingAddress = saddr.StreetAddress + ", " + saddr.City + ", " + saddr.State + " - " + saddr.Pincode; orders.Branches = GetActiveBranchesViews(); return(orders); } }
public void UpdateOrder(OrderUpdateView OUV) { using (CMSProjectEntities db = new CMSProjectEntities()) { CustomerOrder CO = new CustomerOrder(); CO.OrderID = OUV.OrderID; CO.CustomerID = OUV.CustomerID; CO.OrderDate = OUV.OrderDate; if (OUV.ShippedDate.HasValue) { CO.ShippedDate = OUV.ShippedDate; } else { CO.ShippedDate = null; } CO.PickupAddressID = OUV.PickupAddressID; CO.ShippingAddressID = OUV.ShippingAddressID; CO.Weight = OUV.Weight; CO.OrderValue = OUV.OrderValue; db.Entry(CO).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); PaymentTBL pay = new PaymentTBL(); pay.PaymentID = OUV.PaymentID; pay.Value = CO.OrderValue; if (OUV.PaymentDate.HasValue) { pay.PaymentDate = OUV.PaymentDate; } else { pay.PaymentDate = null; } pay.PaymentStatusID = OUV.PaymentStatusID; pay.OrderID = CO.OrderID; db.Entry(pay).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TrackingTBL tracking = new TrackingTBL(); tracking.TrackingID = OUV.TrackingID; tracking.PickupBranchID = OUV.PickupBranchID; tracking.ShippingBranchID = OUV.ShippingBranchID; tracking.OrderStatusID = OUV.OrderStatusID; tracking.OrderID = CO.OrderID; db.Entry(tracking).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }