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