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