public IHttpActionResult SalesLineChart()
{
var customerinvoice = cusinvrepo.GetAll();
List <string> date = new List <string>();
var fetchdate = customerinvoice.Select(x => x.OrderDate).Distinct().OrderBy(y => y.Date);
foreach (var item in fetchdate)
{
var i = item.ToString("dd-MM-yyyy");
date.Add(i);
}
List <double> sales = new List <double>();
foreach (var item in fetchdate)
{
var info = customerinvoice.Where(x => x.OrderDate == item).ToList();
double count = 0;
foreach (var i in info)
{
count = count + i.TotalWithTax;
}
sales.Add(Math.Round(count));
}
return(Ok(new { date, sales }));
}
public ActionResult SalesLineChart()
{
if (CheckAccess())
{
var customerinvoice = cusinvrepo.GetAll();
List <string> date = new List <string>();
var fetchdate = customerinvoice.Select(x => x.OrderDate).Distinct().OrderBy(y => y.Date);
foreach (var item in fetchdate)
{
var i = item.ToString("dd-MM-yyyy");
date.Add(i);
}
List <double> sales = new List <double>();
foreach (var item in fetchdate)
{
var info = customerinvoice.Where(x => x.OrderDate == item).ToList();
double count = 0;
foreach (var i in info)
{
count = count + i.TotalWithTax;
}
sales.Add(Math.Round(count));
}
return(Json(new { date, sales }, JsonRequestBehavior.AllowGet));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
public ActionResult Checkout(CustomerInvoice invoice)
{
if (CheckIfCustomer())
{
if (ModelState.IsValid)
{
CheckoutViewModel checkoutDetails = customerrepo.CheckoutDetails();
invoice.SubTotal = checkoutDetails.TotalPrice;
invoice.TotalWithTax = checkoutDetails.TotalPriceWithTax;
invoice.CustomerUserName = Session["UserName"].ToString();
cusinvrepo.Insert(invoice);
CustomerInvoice lastinvoice = null;
foreach (var item in cusinvrepo.GetAll())
{
lastinvoice = item;
}
foreach (var item in checkoutDetails.CartProductList)
{
CustomerLineItem lineItem = new CustomerLineItem();
lineItem.InvoiceId = lastinvoice.InvoiceId;
lineItem.ProductId = item.ProductId;
lineItem.Quantity = item.Quantity;
lineItem.UnitPrice = item.UnitPrice;
lineItem.Total = item.Quantity * item.UnitPrice;
cuslirepo.Insert(lineItem);
CompanyProduct product = comprodrepo.GetById(item.ProductId);
product.Quantity = product.Quantity - item.Quantity;
comprodrepo.Update(product);
}
customerrepo.ClearCart();
return(View("Conformation"));
}
else
{
TempData["Checkout"] = customerrepo.CheckoutDetails();
return(View(invoice));
}
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
public IHttpActionResult Checkout(CheckoutViewModel checkout)
{
if (ModelState.IsValid)
{
CustomerInvoice invoice = new CustomerInvoice();
invoice.OrderDate = checkout.OrderDate;
invoice.SubTotal = checkout.SubTotal;
invoice.TotalWithTax = checkout.TotalWithTax;
invoice.CreditCardType = checkout.CreditCardType;
invoice.CardNumber = checkout.CardNumber;
invoice.CustomerUserName = checkout.CustomerUserName;
cusinvrepo.Insert(invoice);
CustomerInvoice lastinvoice = null;
foreach (var item in cusinvrepo.GetAll())
{
lastinvoice = item;
}
foreach (var item in checkout.CartProductList)
{
CustomerLineItem lineItem = new CustomerLineItem();
lineItem.InvoiceId = lastinvoice.InvoiceId;
lineItem.ProductId = item.ProductId;
lineItem.Quantity = item.Quantity;
lineItem.UnitPrice = item.UnitPrice;
lineItem.Total = item.Quantity * item.UnitPrice;
cuslirepo.Insert(lineItem);
CompanyProduct product = comprodrepo.GetById(item.ProductId);
product.Quantity = product.Quantity - item.Quantity;
comprodrepo.Update(product);
}
return(Created("http://localhost:51045/api/customerinvoices" + invoice.InvoiceId, invoice));
}
else
{
return(BadRequest(ModelState));
}
}