public Collection <ListItem> GetAddressByPartyCode(string partyCode) { Collection <ListItem> values = new Collection <ListItem>(); foreach (ShippingAddressView view in ShippingAddresses.GetShippingAddressView(AppUsers.GetCurrentUserDB(), partyCode)) { string address = string.Format(CultureInfo.InvariantCulture, "{0}{1}{2}{1}{3}{4}{5}{1}{6}{4}{7}", view.AddressLine1, Environment.NewLine, view.AddressLine2, view.Street, ", ", view.City, view.StateName, view.CountryName); values.Add(new ListItem(view.ShippingAddressCode, address)); } return(values); }
public IHttpActionResult AddAddress([FromBody] ShippingAddresses sa) { using (var db = new OMSEF()) { db.ShippingAddresses.Add(new ShippingAddress { Address1 = sa.Address1, Address2 = sa.Address2, City = sa.City, PinCode = sa.PinCode, State = sa.State }); db.SaveChanges(); } return(Ok()); }
public Collection <ListItem> GetAddressByPartyCode(string partyCode) { Collection <ListItem> values = new Collection <ListItem>(); using (DataTable table = ShippingAddresses.GetShippingAddressView(partyCode)) { string displayField = ConfigurationHelper.GetDbParameter("ShippingAddressDisplayField"); table.Columns.Add("shipping_address", typeof(string), displayField); foreach (DataRow dr in table.Rows) { values.Add(new ListItem(dr["shipping_address_code"].ToString(), dr["shipping_address"].ToString())); } } return(values); }
public IHttpActionResult UpdateAddress([FromBody] ShippingAddresses sa) { using (var db = new OMSEF()) { var shippingAddress = db.ShippingAddresses.Where(s => s.AddressID == sa.AddressID).FirstOrDefault(); if (shippingAddress != null) { shippingAddress.Address1 = sa.Address1; shippingAddress.Address2 = sa.Address2; shippingAddress.City = sa.City; shippingAddress.PinCode = sa.PinCode; shippingAddress.State = sa.State; } db.SaveChanges(); } return(Ok()); }
private void FillAddressCollection(List <Address> addresses, QIQOAddressType address_type) { if (address_type == QIQOAddressType.Billing) { BillingAddresses.Clear(); foreach (var addr in addresses) { BillingAddresses.Add(new AddressWrapper(addr)); } } else { ShippingAddresses.Clear(); foreach (var addr in addresses) { ShippingAddresses.Add(new AddressWrapper(addr)); } } }
public IHttpActionResult GetAddress(int id) { ShippingAddresses sa = new ShippingAddresses(); using (var db = new OMSEF()) { var userRole = db.ShippingAddresses.Where(s => s.AddressID == id).FirstOrDefault(); if (userRole != null) { sa.Address1 = userRole.Address1; sa.Address2 = userRole.Address2; sa.AddressID = userRole.AddressID; sa.City = userRole.City; sa.PinCode = userRole.PinCode; sa.State = userRole.State; } } return(Ok(sa)); }
public void Execute(ShippingAddressDto request) { if (Validate(request)) { var newShippingAddress = new ShippingAddresses { Active = true, DateCreated = DateTime.Now, User = _context.Users.Find(request.UserId), Country = request.Country, State = request.State, City = request.City, Address = request.Address, PostalCode = request.PostalCode }; _context.ShippingAddresses.Add(newShippingAddress); _context.SaveChanges(); } }
public IHttpActionResult GetallAddresses() { List <ShippingAddresses> shippingAddresses = new List <ShippingAddresses>(); using (var db = new OMSEF()) { var allAddresses = (from a in db.ShippingAddresses select a).ToList(); foreach (var a in allAddresses) { ShippingAddresses sa = new ShippingAddresses(); sa.Address1 = a.Address1; sa.Address2 = a.Address2; sa.AddressID = a.AddressID; sa.City = a.City; sa.PinCode = a.PinCode; sa.State = a.State; shippingAddresses.Add(sa); } } return(Ok(shippingAddresses)); }
public IActionResult SubmitOrder(BillingAddresses newBilling, ShippingAddresses newShipping, PaymentMethods newPayment, string month, string year) { var user = HttpContext.Session.GetInt32("user"); var cart = _context.Cart.Where(x => x.UsersId == (int)user).Include(y => y.Product).ToList(); string expiration = month + "/" + year; if (ModelState.IsValid) { _context.BillingAddresses.Add(newBilling); _context.ShippingAddresses.Add(newShipping); _context.SaveChanges(); PaymentMethods newPay = new PaymentMethods() { UsersId = (int)user, BillingAddressesId = newBilling.id, card_type = newPayment.card_type, card_name = newPayment.card_name, card_num = newPayment.card_num, card_ccv = newPayment.card_ccv, card_exp = expiration, nickname = newPayment.nickname, }; _context.PaymentMethods.Add(newPay); _context.SaveChanges(); Orders newOrder = new Orders() { UsersId = (int)user, BillingAddressesId = newBilling.id, ShippingAddressesId = newShipping.id, PaymentMethodsId = newPay.id, order_status = "Processing" }; _context.Orders.Add(newOrder); _context.SaveChanges(); foreach (var item in cart) { Inventory updateInventory = _context.Inventory.FirstOrDefault(x => x.ProductsId == item.ProductsId); Order_Products newItem = new Order_Products() { OrdersId = newOrder.id, ProductsId = item.ProductsId, quantity = item.quantity, cost = item.cost }; updateInventory.quantity_new -= item.quantity; updateInventory.quantity_sold += item.quantity; _context.Order_Products.Add(newItem); _context.Cart.Remove(item); _context.SaveChanges(); } return(RedirectToAction("OrderView")); } ViewBag.cart = _context.Cart.Where(x => x.UsersId == HttpContext.Session.GetInt32("user")) .Include(y => y.Product).ThenInclude(z => z.Prices) .Include(y => y.Product).ThenInclude(z => z.product_img).ToList(); ViewBag.cost = 0; foreach (var item in ViewBag.cart) { ViewBag.cost += item.cost; } return(View("Checkout")); }