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();
}
}
public void PlaceOrder(PlaceOrderView POV)
{
Address paddr = new Address();
Address saddr = new Address();
using (CMSProjectEntities db = new CMSProjectEntities())
{
paddr.StreetAddress = POV.PickupAddressSA;
paddr.City = POV.PickupAddressCity;
paddr.State = POV.PickupAddressState;
paddr.Pincode = POV.PickupAddressPincode;
saddr.StreetAddress = POV.ShippingAddressSA;
saddr.City = POV.ShippingAddressCity;
saddr.State = POV.ShippingAddressState;
saddr.Pincode = POV.ShippingAddressPincode;
db.Addresses.Add(paddr);
db.SaveChanges();
db.Addresses.Add(saddr);
db.SaveChanges();
User user = db.Users.Where(o => o.Username.Equals(HttpContext.Current.User.Identity.Name)).FirstOrDefault();
CustomerUser CU = db.CustomerUsers.Where(o => o.UserID.Equals(user.UserID)).FirstOrDefault();
CustomerOrder CO = new CustomerOrder();
CO.CustomerID = CU.CustomerID;
CO.OrderDate = DateTime.Now;
CO.ShippedDate = null;
CO.PickupAddressID = db.Addresses.Where(o => o.StreetAddress.Equals(paddr.StreetAddress)).FirstOrDefault().AddressID;
CO.ShippingAddressID = db.Addresses.Where(o => o.StreetAddress.Equals(saddr.StreetAddress)).FirstOrDefault().AddressID;
CO.Weight = POV.Weight;
CO.OrderValue = POV.OrderValue;
db.CustomerOrders.Add(CO);
db.SaveChanges();
TrackingTBL tracking = new TrackingTBL();
tracking.OrderStatusID = 0;
tracking.OrderID = CO.OrderID;
db.TrackingTBLs.Add(tracking);
db.SaveChanges();
PaymentTBL pay = new PaymentTBL();
pay.Value = CO.OrderValue;
pay.PaymentDate = null;
pay.PaymentStatusID = 1;
pay.OrderID = CO.OrderID;
db.PaymentTBLs.Add(pay);
db.SaveChanges();
}
}
