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