public async Task<ActionResult> Edit()
{
if (User.Identity.IsAuthenticated)
{
ApplicationDbContext mycontext = new ApplicationDbContext();
UserStore<ApplicationUser> myStore = new UserStore<ApplicationUser>(mycontext);
ApplicationUserManager mgr = new ApplicationUserManager(myStore);
var user = await mgr.FindByNameAsync(User.Identity.Name);
WishlistActions grantMyWish = new WishlistActions();
CartActions cart = new CartActions();
ProductViewModel bridge = new ProductViewModel();
List<Book> bookList = new List<Book>();
List<Technology> deviceList = new List<Technology>();
myHandler = new BusinessLogicHandler();
bridge.allWishlistItems = new List<WishlistItem>();
bridge.allWishlistItems = grantMyWish.GetWishlistItems(user.Wishlists.WishlistID);
if(bridge.allWishlistItems != null)
{
bridge.allBook = new List<Book>();
foreach(var item in bridge.allWishlistItems)
{
if(myHandler.CheckProductType(item.ProductID))
{
Book myBook = new Book();
myBook = myHandler.GetBook(item.ProductID);
bookList.Add(myBook);
}
else
{
Technology myDevice = new Technology();
myDevice = myHandler.GetTechnologyDetails(item.ProductID);
deviceList.Add(myDevice);
}
}
//bridge.allBook = myHandler.GetBooks();
bridge.allTechnology = new List<Technology>();
//bridge.allTechnology = myHandler.GetTechnology();
bridge.allBook = bookList;
bridge.allTechnology = deviceList;
}
Session["wishlistTotal"] = grantMyWish.GetWishlistTotal(user.Wishlists.WishlistID);
Session["cartTotal"] = cart.GetTotalAsync(user.Carts.CartID);
return View(bridge);
}
else
return RedirectToAction("Login", "Account", null);
}
public ActionResult Details(int OrderNumber)
{
#region Prep Utilities
myHandler = new BusinessLogicHandler();
OrderLineModel model = new OrderLineModel();
#endregion
#region Get Order Details
model.OrderLineDetails = myHandler.GetOrderItemsList(OrderNumber);
model.OrderDetails = myHandler.GetOrder(OrderNumber);
model.SupplierDetails = myHandler.GetSupplier(model.OrderDetails.SupplierID);
#endregion
#region Get Order Total
model.totally = 0;
foreach(var item in model.OrderLineDetails)
{
if(myHandler.CheckProductType(item.ProductID))
{
Book myBook = new Book();
myBook = myHandler.GetBook(item.ProductID);
model.totally += (myBook.SellingPrice*item.Quantity);
}
else
{
Technology device = new Technology();
device = myHandler.GetTechnologyDetails(item.ProductID);
model.totally += (device.SellingPrice * item.Quantity);
}
}
#endregion
return PartialView(model);
}
public ActionResult CustomerDetails(int ProductID)
{
#region Prep Utilities
myHandler = new BusinessLogicHandler();
AddNewBookViewModel model = new AddNewBookViewModel();
book = new Book();
BookCategory category = new BookCategory();
Publisher pub = new Publisher();
Author authors = new Author();
#endregion
#region Check Type
if (myHandler.CheckProductType(ProductID))
{ }
else
{ return RedirectToAction("Details","Technology", new { ProductID = ProductID }); }
#endregion
#region Get Book Data
book = myHandler.User_GetBook(ProductID);
model.books = new Book();
model.books = book;
model.bookList = new List<Book>();
model.bookList.Add(book);
#endregion
#region Get Book Category Data
category = myHandler.GetBookType(book.BookCategoryID);
model.bc = new BookCategory();
model.bc = category;
model.bookCategoryList = new List<BookCategory>();
model.bookCategoryList.Add(category);
#endregion
#region Get Publisher Data
pub = myHandler.GetPublisher(book.PublisherID);
model.publisher = new Publisher();
model.publisher = pub;
model.PublisherList = new List<Publisher>();
model.PublisherList.Add(pub);
#endregion
#region Get Authors Data
model.AuthorList = myHandler.GetAuthorsPerBook(book.BookID);
#endregion
return View(model);
}
public ActionResult Checkout(FormCollection collection, ProductViewModel model)
{
Delivery shipping = new Delivery();
IEnumerable<Book> ifBooks = (IEnumerable<Book>)Session["myBooks"];
IEnumerable<Technology> ifGadget = (IEnumerable<Technology>)Session["myGadget"];
List<CartItem> myItems = (List<CartItem>)Session["myItems"];
myHandler = new BusinessLogicHandler();
#region Get Shipping Data
try
{
shipping = myHandler.GetDeliveryDetails(Convert.ToInt32(collection[1].ToString()));
if (ModelState.ContainsKey("I_DeliveryList"))
ModelState["I_DeliveryList"].Errors.Clear();
}
catch
{ ModelState.AddModelError("deliveryHelper.DeliveryServicePrice", "Please select a delivery service from dropdown !"); }
#endregion
#region Cathing model errors
var error = ModelState.Values.SelectMany(e => e.Errors);
var errors = ModelState
.Where(x => x.Value.Errors.Count > 0)
.Select(x => new { x.Key, x.Value.Errors })
.ToArray();
#endregion
int? IID = 0;
if (ModelState.IsValid)
{
#region Get User
string userName = User.Identity.GetUserName();
ApplicationDbContext dataSocket = new ApplicationDbContext();
UserStore<ApplicationUser> myStore = new UserStore<ApplicationUser>(dataSocket);
userMgr = new ApplicationUserManager(myStore);
var user = userMgr.FindByEmail(userName);
#endregion
try
{
#region Creating the reciept/invoice
Invoice reciept = new Invoice { User_Id = user.Id, DateCreated = DateTime.Now, DeliveryAddress = model.deliveryHelper.DeliveryAddress, DeliveryServiceID = Convert.ToInt32(collection[1].ToString()), Status = false };
try
{
InvoiceItem invoiceLine = new InvoiceItem();
invoiceLine = myHandler.GetInvoiceLastNumber(reciept);
foreach (var item in myItems)
{
invoiceLine.CartItemID = item.CartItemID;
invoiceLine.ProductID = item.ProductID;
invoiceLine.Quantity = item.Quantity;
#region Get Product Price
bool chk = false;
chk = myHandler.CheckProductType(item.ProductID);
if (chk)
{
Book book = new Book();
book = myHandler.GetBook(item.ProductID);
invoiceLine.Price = book.SellingPrice;
myHandler.AddinvoiceItem(invoiceLine);
}
else
{
Technology device = new Technology();
device = myHandler.GetTechnologyDetails(item.ProductID);
invoiceLine.Price = device.SellingPrice;
myHandler.AddinvoiceItem(invoiceLine);
}
#endregion
}
IID = invoiceLine.InvoiceID;
}
catch { }
#endregion
#region Placing the order
try
{
#region Prep Utilities
Order ord;
Book book = new Book();
Technology gadget = new Technology();
int supplierId = 0;
OrderItem orderLine = new OrderItem();
myHandler = new BusinessLogicHandler();
List<int> orders = new List<int>();
List<int> suppliers = new List<int>();
#endregion
foreach (var item in myItems)
{
if (myHandler.CheckProductType(item.ProductID))
{
book = myHandler.GetBook(item.ProductID);
supplierId = book.SupplierID;
if (suppliers.Contains(book.SupplierID))
{
int x = suppliers.IndexOf(supplierId);
orderLine.OrderNo = orders.ElementAt(x);
orderLine.ProductID = item.ProductID;
orderLine.Quantity = item.Quantity;
myHandler.AddOrderItem(orderLine);
}
else
{
suppliers.Add(supplierId);
ord = new Order { DateCreated = DateTime.Now.Date, SupplierID = supplierId, InvoiceID = IID.GetValueOrDefault(), DateLastModified = DateTime.Now.Date, Status = false };
orderLine = myHandler.AddOrder(ord);
orders.Add(orderLine.OrderNo);
orderLine.ProductID = item.ProductID;
orderLine.Quantity = item.Quantity;
myHandler.AddOrderItem(orderLine);
}
}
else
{
supplierId = ifGadget.SingleOrDefault(m => m.ProductID == item.ProductID).SupplierID;
if (suppliers.Contains(supplierId))
{
int y = suppliers.IndexOf(supplierId);
orderLine.OrderNo = orders.ElementAt(y);
orderLine.ProductID = item.ProductID;
orderLine.Quantity = item.Quantity;
myHandler.AddOrderItem(orderLine);
}
else
{
suppliers.Add(supplierId);
ord = new Order { DateCreated = DateTime.Now.Date, SupplierID = supplierId, InvoiceID = IID.GetValueOrDefault(), DateLastModified = DateTime.Now.Date, Status = false };
orderLine = myHandler.AddOrder(ord);
orders.Add(orderLine.OrderNo);
orderLine.ProductID = item.ProductID;
orderLine.Quantity = item.Quantity;
myHandler.AddOrderItem(orderLine);
}
}
}
}
catch { }
#endregion
}
catch
{/*Navigate to custom error page*/ }
Session["deliverData"] = model;
return RedirectToAction("Receipt", new { IID = IID });
}
else
{
#region Feed The Model
CartItem thishereItem = new CartItem();
try
{
ProductViewModel.CartHelper cartHelp;
List<ProductViewModel.CartHelper> itemList = new List<ProductViewModel.CartHelper>();
double cartTotal = 0;
if (myItems != null)
{
if (ifBooks != null)
{
var revised = from rev in ifBooks
join item in myItems on rev.ProductID equals item.ProductID
where rev.ProductID == item.ProductID
select new { rev.ProductID, rev.SellingPrice, item.Quantity };
foreach (var ite in revised)
{
cartHelp = new ProductViewModel.CartHelper();
cartHelp.ProductID = ite.ProductID;
cartHelp.TotalPerItem = (ite.SellingPrice * ite.Quantity);
cartTotal += (ite.SellingPrice * ite.Quantity);
itemList.Add(cartHelp);
}
}
if (ifGadget != null)
{
var revised = from rev in ifGadget
join item in myItems on rev.ProductID equals item.ProductID
where rev.ProductID == item.ProductID
select new { rev.ProductID, rev.SellingPrice, item.Quantity };
foreach (var ite in revised)
{
cartHelp = new ProductViewModel.CartHelper();
cartHelp.ProductID = ite.ProductID;
cartHelp.TotalPerItem = (ite.SellingPrice * ite.Quantity);
cartTotal += (ite.SellingPrice * ite.Quantity);
itemList.Add(cartHelp);
}
}
}
List<Company> company = new List<Company>(); myHandler = new BusinessLogicHandler();
company = myHandler.GetCompanyDetails();
double vat = 0;
foreach (var item in company)
{ vat = item.VATPercentage; }
//calc
double vatAmount = (cartTotal * vat);
double subTotal = (cartTotal - vatAmount);
ProductViewModel.CartConclude finishing = new ProductViewModel.CartConclude();
finishing.CartTotal = cartTotal;
finishing.VatAddedTotal = vatAmount;
finishing.SubTotal = subTotal;
model.ItsA_wrap = new List<ProductViewModel.CartConclude>();
model.ItsA_wrap.Add(finishing);
model.deliveryHelper.DeliveryServiceName = shipping.ServiceName;
model.deliveryHelper.DeliveryServicePrice = shipping.Price;
model.deliveryHelper.DeliveryServiceType = shipping.ServiceType;
model.secureCart = itemList;
model.allBook = new List<Book>();
model.allBook = ifBooks.ToList() ;
model.allCartItem = new List<CartItem>();
model.allCartItem = myItems;
model.allTechnology = new List<Technology>();
model.allTechnology = ifGadget.ToList();
}
catch { }
#endregion
#region Drop down data
DeliveryHandler deliver = new DeliveryHandler();
IEnumerable<Delivery> delivery = (IEnumerable<Delivery>)deliver.GetDeliveryList();
var dataStore = from name in delivery
select new { Value = name.DeliveryServiceID, Text = name.ServiceName };
ViewBag.DeliveryList = new SelectList(dataStore.ToList());
List<SelectListItem> deliveryI = new List<SelectListItem>();
deliveryI.Add(new SelectListItem { Text = "Delivery Service", Value = "", Selected = true });
foreach (var item in delivery)
{ deliveryI.Add(new SelectListItem { Text = item.ServiceName, Value = item.DeliveryServiceID.ToString() }); }
model.I_DeliveryList = new List<SelectListItem>();
model.I_DeliveryList = deliveryI;
ViewData["I_Delivery"] = deliveryI;
#endregion
return View(model);
}
}
public async Task<ActionResult> Receipt(int? IID)
{
List<CartItem> myItems = new List<CartItem>();
myItems = (List<CartItem>)Session["myItems"];
ProductViewModel model = new ProductViewModel();
myHandler = new BusinessLogicHandler();
model = (ProductViewModel)Session["deliverData"];
#region Get Cart Items
List<Book> ifBooks = new List<Book>();
List<Technology> ifGadget = new List<Technology>();
foreach (var item in myItems)
{
if (myHandler.CheckProductType(item.ProductID))
{
Book book = new Book();
book = myHandler.GetBook(item.ProductID);
ifBooks.Add(book);
}
else
{
Technology gadget = new Technology();
gadget = myHandler.GetTechnologyDetails(item.ProductID);
ifGadget.Add(gadget);
}
//try
//{
// Book book = new Book();
// book = myHandler.GetBook(item.ProductID);
// ifBooks.Add(book);
//}
//catch
//{
// Technology gadget = new Technology();
// gadget = myHandler.GetTechnologyDetails(item.ProductID);
// ifGadget.Add(gadget);
//}
}
model.allTechnology = ifGadget;
model.allBook = ifBooks;
model.allCartItem = myItems;
#endregion
#region Push User Details
string userName = User.Identity.GetUserName();
ApplicationDbContext dataSocket = new ApplicationDbContext();
UserStore<ApplicationUser> myStore = new UserStore<ApplicationUser>(dataSocket);
userMgr = new ApplicationUserManager(myStore);
var user = userMgr.FindByEmail(userName);
model.UserDetails = new ProvideUser();
model.UserDetails.Address = user.Address;
model.UserDetails.email = user.Email;
model.UserDetails.PhoneNumber = user.PhoneNumber;
CustomerContext customer = new CustomerContext();
Customer thisCust = new Customer();
thisCust = customer.Customers.FirstOrDefault(cust => cust.User_Id == user.Id);
model.UserDetails.LName = thisCust.LastName;
model.UserDetails.Name = thisCust.FirstName;
#endregion
#region Push Invoice nfo
model.recieptData = new Invoice();
model.recieptData = myHandler.GetInvoice(IID.GetValueOrDefault());
#endregion
#region Push Company nfo
myHandler = new BusinessLogicHandler();
model.company = new Company();
model.company = myHandler.GetCompanyDetail();
#endregion
#region Push Delivery nfo
Delivery shipping = new Delivery();
myHandler = new BusinessLogicHandler();
shipping = myHandler.GetDeliveryDetails(model.recieptData.DeliveryServiceID);
model.deliveryHelper.DeliveryServiceName = shipping.ServiceName;
model.deliveryHelper.DeliveryServicePrice = shipping.Price;
model.deliveryHelper.DeliveryServiceType = shipping.ServiceType;
#endregion
#region Calculate
List<ProductViewModel.CartHelper> itemList = new List<ProductViewModel.CartHelper>();
ProductViewModel.CartHelper cartHelp;
if (myItems != null)
{
if (ifBooks != null)
{
var revised = from rev in ifBooks
join item in myItems on rev.ProductID equals item.ProductID
where rev.ProductID == item.ProductID
select new { rev.ProductID, rev.SellingPrice, item.Quantity, item.CartItemID };
foreach (var ite in revised)
{
cartHelp = new ProductViewModel.CartHelper();
cartHelp.ProductID = ite.ProductID;
cartHelp.CartItemID = ite.CartItemID;
cartHelp.TotalPerItem = (ite.SellingPrice * ite.Quantity);
itemList.Add(cartHelp);
}
}
}
if (myItems != null)
{
if (ifGadget != null)
{
var revised = from rev in ifGadget
join item in myItems on rev.ProductID equals item.ProductID
where rev.ProductID == item.ProductID
select new { rev.ProductID, rev.SellingPrice, item.Quantity, item.CartItemID };
foreach (var ite in revised)
{
cartHelp = new ProductViewModel.CartHelper();
cartHelp.ProductID = ite.ProductID;
cartHelp.CartItemID = ite.CartItemID;
cartHelp.TotalPerItem = (ite.SellingPrice * ite.Quantity);
itemList.Add(cartHelp);
}
}
}
double cartTotal = Convert.ToDouble(Session["cartTotal"].ToString());
cartTotal = cartTotal / 100;
myHandler = new BusinessLogicHandler();
List<Company> company = myHandler.GetCompanyDetails();
double vat = 0;
cartTotal += Convert.ToDouble(model.deliveryHelper.DeliveryServicePrice);
foreach (var item in company)
{ vat = item.VATPercentage; }
vat = vat + 1;
double subTotal = cartTotal / vat;
double vatAmount = cartTotal - subTotal;
ProductViewModel.CartConclude finishing = new ProductViewModel.CartConclude();
finishing.CartTotal = cartTotal;
finishing.VatAddedTotal = vatAmount;
finishing.SubTotal = subTotal;
model.ItsA_wrap = new List<ProductViewModel.CartConclude>();
model.ItsA_wrap.Add(finishing);
model.secureCart = itemList;
#endregion
#region Clear the cart
foreach (var item in itemList)
{
myHandler = new BusinessLogicHandler();
myHandler.DeleteCartItem(item.CartItemID);
}
#endregion
#region Clear SESSION
Session["myItems"] = null;
Session["cartTotal"] = (double) await GetCartTotal(user.Carts.CartID);
#endregion
#region Prep for exporting to PDF
Session["pdf"] = model;
#endregion
return View(model);
}
public async Task<ActionResult> Checkout()
{
#region Data to Display
CartActions act = new CartActions(); WishlistActions wishAct = new WishlistActions();
ApplicationDbContext dataSocket = new ApplicationDbContext();
UserStore<ApplicationUser> myStore = new UserStore<ApplicationUser>(dataSocket);
userMgr = new ApplicationUserManager(myStore);
var thisUser = await userMgr.FindByNameAsync(User.Identity.Name);
int Id = (int)thisUser.Carts.CartID;
try
{ double nm = await GetCartTotal(Id); string[] xn = nm.ToString().Split('.'); Session["cartTotal"] = xn[0] + "," + xn[1]; }
catch { Session["cartTotal"] = act.GetTotalAsync(Id); }
Session["wishlistTotal"] = wishAct.GetWishlistTotal(thisUser.Wishlists.WishlistID);
//List<CartItem> myItems = new List<CartItem>();
ProductViewModel myNewModel = new ProductViewModel();
IEnumerable<CartItem> myItems = act.GetCartItemsAsync(Id);
if (myItems != null)
{
myHandler = new BusinessLogicHandler();
List<Book> ifBooks = new List<Book>();
List<Technology> ifGadget = new List<Technology>();
foreach (var item in myItems)
{
if (myHandler.CheckProductType(item.ProductID))
{
Book book = new Book();
book = myHandler.GetBook(item.ProductID);
ifBooks.Add(book);
}
else
{
Technology device = new Technology();
device = myHandler.GetTechnologyDetails(item.ProductID);
ifGadget.Add(device);
}
}
myNewModel.allBook = ifBooks;
myNewModel.allCartItem = myItems.ToList();
myNewModel.allTechnology = ifGadget;
List<ProductViewModel.CartHelper> itemList = new List<ProductViewModel.CartHelper>();
ProductViewModel.CartHelper cartHelp;
if (myItems != null)
{
var revised = from rev in ifBooks
join item in myItems on rev.ProductID equals item.ProductID
where rev.ProductID == item.ProductID
select new { rev.ProductID, rev.SellingPrice, item.Quantity };
foreach (var ite in revised)
{
cartHelp = new ProductViewModel.CartHelper();
cartHelp.ProductID = ite.ProductID;
cartHelp.TotalPerItem = (ite.SellingPrice * ite.Quantity);
itemList.Add(cartHelp);
}
}
if (myItems != null)
{
if (ifGadget != null)
{
var revised = from rev in ifGadget
join item in myItems on rev.ProductID equals item.ProductID
where rev.ProductID == item.ProductID
select new { rev.ProductID, rev.SellingPrice, item.Quantity };
foreach (var ite in revised)
{
cartHelp = new ProductViewModel.CartHelper();
cartHelp.ProductID = ite.ProductID;
cartHelp.TotalPerItem = (ite.SellingPrice * ite.Quantity);
itemList.Add(cartHelp);
}
}
}
double cartTotal = Convert.ToDouble(Session["cartTotal"].ToString());
cartTotal = cartTotal / 100;
List<Company> company = myHandler.GetCompanyDetails();
double vat = 0;
foreach (var item in company)
{ vat = item.VATPercentage; }
vat = vat + 1;
double subTotal = cartTotal / vat;
double vatAmount = cartTotal - subTotal;
ProductViewModel.CartConclude finishing = new ProductViewModel.CartConclude();
finishing.CartTotal = cartTotal;
finishing.VatAddedTotal = vatAmount;
finishing.SubTotal = subTotal;
myNewModel.ItsA_wrap = new List<ProductViewModel.CartConclude>();
myNewModel.ItsA_wrap.Add(finishing);
myNewModel.secureCart = itemList;
}
else
{ return RedirectToAction("Edit"); }
#endregion
#region Drop down data
DeliveryHandler deliver = new DeliveryHandler();
IEnumerable<Delivery> delivery = (IEnumerable<Delivery>)deliver.GetDeliveryList();
var dataStore = from name in delivery
select new { Value = name.DeliveryServiceID, Text = name.ServiceName };
ViewBag.DeliveryList = new SelectList(dataStore.ToList());
List<SelectListItem> deliveryI = new List<SelectListItem>();
deliveryI.Add(new SelectListItem { Text = "Delivery Service", Value = "", Selected = true });
foreach (var item in delivery)
{ deliveryI.Add(new SelectListItem { Text = item.ServiceName, Value = item.DeliveryServiceID.ToString() }); }
myNewModel.I_DeliveryList = new List<SelectListItem>();
myNewModel.I_DeliveryList = deliveryI;
ViewData["I_Delivery"] = deliveryI;
#endregion
#region Default Address
if (thisUser.Address != null)
{ myNewModel.deliveryHelper = new DeliveryHelper(); myNewModel.deliveryHelper.DeliveryAddress = thisUser.Address; }
#endregion
return View(myNewModel);
}
public async Task<ActionResult> Edit()
{
CartActions act = new CartActions(); WishlistActions wishAct = new WishlistActions();
ApplicationDbContext dataSocket = new ApplicationDbContext();
UserStore<ApplicationUser> myStore = new UserStore<ApplicationUser>(dataSocket);
userMgr = new ApplicationUserManager(myStore);
var thisUser = await userMgr.FindByNameAsync(User.Identity.Name);
int Id = (int)thisUser.Carts.CartID;
try
{ double nm = await GetCartTotal(Id); string[] xn = nm.ToString().Split('.'); Session["cartTotal"] = xn[0] + "," + xn[1]; }
catch { Session["cartTotal"] = act.GetTotalAsync(Id); }
Session["wishlistTotal"] = wishAct.GetWishlistTotal(thisUser.Wishlists.WishlistID);
List<CartItem> myItems = new List<CartItem>();
try
{ myItems = act.GetCartItemsAsync(Id).ToList();}
catch(ArgumentNullException)
{ myItems = null; }
myHandler = new BusinessLogicHandler();
List<Book> ifBooks = new List<Book>();
ProductViewModel myNewModel = new ProductViewModel();
List<Technology> ifGadget = new List<Technology>();
if (myItems != null)
{
foreach (var item in myItems)
{
if (myHandler.CheckProductType(item.ProductID))
{
Book book = new Book();
book = myHandler.GetBook(item.ProductID);
ifBooks.Add(book);
}
else
{
Technology device = new Technology();
device = myHandler.GetTechnologyDetails(item.ProductID);
ifGadget.Add(device);
}
}
myNewModel.allCartItem = new List<CartItem>();
myNewModel.allBook = new List<Book>();
myNewModel.allTechnology = new List<Technology>();
List<ProductViewModel.CartHelper> itemList = new List<ProductViewModel.CartHelper>();
ProductViewModel.CartHelper cartHelp;
if (myItems != null)
{
if (ifBooks != null)
{
var revised = from rev in ifBooks
join item in myItems on rev.ProductID equals item.ProductID
where rev.ProductID == item.ProductID
select new { rev.ProductID, rev.SellingPrice, item.Quantity };
foreach (var ite in revised)
{
cartHelp = new ProductViewModel.CartHelper();
cartHelp.ProductID = ite.ProductID;
cartHelp.TotalPerItem = (ite.SellingPrice * ite.Quantity);
itemList.Add(cartHelp);
}
}
}
if (myItems != null)
{
if (ifGadget != null)
{
var revised = from rev in ifGadget
join item in myItems on rev.ProductID equals item.ProductID
where rev.ProductID == item.ProductID
select new { rev.ProductID, rev.SellingPrice, item.Quantity };
foreach (var ite in revised)
{
cartHelp = new ProductViewModel.CartHelper();
cartHelp.ProductID = ite.ProductID;
cartHelp.TotalPerItem = (ite.SellingPrice * ite.Quantity);
itemList.Add(cartHelp);
}
}
}
double cartTotal = Convert.ToDouble(Session["cartTotal"].ToString());
cartTotal = cartTotal / 100;
List<Company> company = myHandler.GetCompanyDetails();
double vat = 0;
foreach (var item in company)
{ vat = item.VATPercentage; }
vat = vat + 1;
double subTotal = cartTotal / vat;
double vatAmount = cartTotal - subTotal;
ProductViewModel.CartConclude finishing = new ProductViewModel.CartConclude();
finishing.CartTotal = cartTotal;
finishing.VatAddedTotal = vatAmount;
finishing.SubTotal = subTotal;
myNewModel.allBook = ifBooks;
myNewModel.allCartItem = myItems;
myNewModel.allTechnology = ifGadget;
myNewModel.ItsA_wrap = new List<ProductViewModel.CartConclude>();
myNewModel.ItsA_wrap.Add(finishing);
myNewModel.secureCart = itemList;
return View(myNewModel);
}
else
{
myNewModel.ItsA_wrap = new List<ProductViewModel.CartConclude>();
return View(myNewModel);
}
}
public ActionResult Product(int ProductID)
{
#region Prep Utilities
myHandler = new BusinessLogicHandler();
UnifiedViewModel model = new UnifiedViewModel();
Author Author = new Author();
#endregion
#region Config Roles
if(User.IsInRole("supplier"))
{
model.iSupplier = true;
}
#endregion
#region Get the Data
if (myHandler.CheckProductType(ProductID))
{
model.Book = new Book();
model.Book = myHandler.GetBook(ProductID);
model.BookCategory = new BookCategory();
model.BookCategory = myHandler.GetBookCategory(model.Book.BookCategoryID);
model.Publisher = new Publisher();
model.Publisher = myHandler.GetPublisher(model.Book.PublisherID);
IEnumerable<BookAuthor> authorsINbook = myHandler.GetBookAuthors(model.Book.BookID);
model.Authors = new List<Author>();
foreach(var item in authorsINbook)
{
Author = myHandler.GetAuthorDetails(item.AuthorID);
model.Authors.Add(Author);
}
}
else
{
model.Device = new Technology();
model.Device = myHandler.GetTechnologyDetails(ProductID);
model.Manufacturer = new Manufacturer();
model.Manufacturer = myHandler.GetManufacturer(model.Device.ManufacturerID);
model.Category = new TechCategory();
model.Category = myHandler.GetTechnologyType(model.Device.TechCategoryID);
}
#endregion
return View(model);
}
public ActionResult Yearly(RangeViewModel model, FormCollection collector)
{
#region Prep Utilities
model.Month = new Models.Monthly();
BusinessLogicHandler myHandler = new BusinessLogicHandler();
model.MonthlySales = new List<Monthly>();
string date = collector.GetValue("Range.From").AttemptedValue;
model.Month.From = date;
string dateFrom = 01 + "/" + 01 + "/" + date;
DateTime from = Convert.ToDateTime(dateFrom);
date = collector.GetValue("Range.To").AttemptedValue;
model.Month.To = date;
dateFrom = 01 + "/" + 01 + "/" + date;
DateTime to = Convert.ToDateTime(dateFrom);
#endregion
try
{
#region Get init Data
IEnumerable<InvoiceItem> rawInvoiceData = myHandler.SalesGroupedByInvoiceID(from, to);
rawInvoiceData.OrderBy(m => m.InvoiceID);
#endregion
#region All
if (model.radioButtons == "All" || model.radioButtons == null)
{
foreach (var item in rawInvoiceData)
{
Monthly customJob = new Monthly();
Invoice invoice = new Invoice();
invoice = myHandler.GetInvoice(item.InvoiceID);
string xdate = invoice.DateCreated.ToString("yyyy", CultureInfo.CreateSpecificCulture("en-US"));
customJob.Month = xdate;
customJob.TotalSales = item.Price;
model.MonthlySales.Add(customJob);
}
}
#endregion
#region Books
else if (model.radioButtons == "Book")
{
foreach (var item in rawInvoiceData)
{
Monthly customJob = new Monthly();
Invoice invoice = new Invoice();
invoice = myHandler.GetInvoice(item.InvoiceID);
string xdate = invoice.DateCreated.ToString("yyyy", CultureInfo.CreateSpecificCulture("en-US"));
customJob.Month = xdate;
IEnumerable<InvoiceItem> rawItems = myHandler.GetInvoiceItems(item.InvoiceID);
foreach (var inv in rawItems)
{
if (myHandler.CheckProductType(inv.ProductID))
{
if (customJob.TotalSales == 0.0)
{ customJob.TotalSales = inv.Price * inv.Quantity; }
else { customJob.TotalSales += inv.Price * inv.Quantity; }
}
}
if (customJob.TotalSales == 0.0)
{ }
else
{ model.MonthlySales.Add(customJob); }
}
}
#endregion
#region Devices
else if (model.radioButtons == "Dev")
{
foreach (var item in rawInvoiceData)
{
Monthly customJob = new Monthly();
Invoice invoice = new Invoice();
invoice = myHandler.GetInvoice(item.InvoiceID);
string xdate = invoice.DateCreated.ToString("yyyy", CultureInfo.CreateSpecificCulture("en-US"));
customJob.Month = xdate;
IEnumerable<InvoiceItem> rawItems = myHandler.GetInvoiceItems(item.InvoiceID);
foreach (var inv in rawItems)
{
if (myHandler.CheckProductType(inv.ProductID))
{
}
else
{
if (customJob.TotalSales == 0.0)
{ customJob.TotalSales = inv.Price * inv.Quantity; }
else { customJob.TotalSales += inv.Price * inv.Quantity; }
}
}
if (customJob.TotalSales == 0.0)
{ }
else
{ model.MonthlySales.Add(customJob); }
}
}
#endregion
#region Clean Up My List
IEnumerable<Monthly> rawList = model.MonthlySales.Distinct();
rawList.OrderBy(m => m.Month);
List<string> Date = new List<string>();
List<double> metaPrice = new List<double>();
model.MonthlySales = new List<Monthly>();
foreach (var item in rawList)
{
if (Date.Contains(item.Month))
{
int y = Date.IndexOf(item.Month);
metaPrice[y] += item.TotalSales;
}
else
{
Date.Add(item.Month);
metaPrice.Add(item.TotalSales);
}
}
int zed = 0;
foreach (var item in Date)
{
Monthly month = new Monthly();
month.Month = item;
month.TotalSales = metaPrice[zed];
model.MonthlySales.Add(month);
zed++;
}
#endregion
#region Calc Total
model.Total = new TotalClass();
foreach (var item in model.MonthlySales)
{
model.Total.Total += item.TotalSales;
}
#endregion
}
catch
{
model.Total = new TotalClass();
}
return View(model);
}
public ActionResult Detailed(RangeViewModel model, FormCollection collector)
{
#region Prep Utilities
BusinessLogicHandler myHandler = new BusinessLogicHandler();
IEnumerable<InvoiceItem> invoiceItems;
model.Detailed = new List<DetailedCustom>();
string[] date = collector.GetValue("myRange.From").AttemptedValue.Split('/');
string dateFrom = date[1] + "/" + date[0] + "/" + date[2];
DateTime from = Convert.ToDateTime(dateFrom);
date = collector.GetValue("myRange.To").AttemptedValue.Split('/');
dateFrom = date[1] + "/" + date[0] + "/" + date[2];
model.myRange.To = Convert.ToDateTime(dateFrom);
DateTime to = Convert.ToDateTime(dateFrom);
#endregion
try
{
#region Get The Data
invoiceItems = myHandler.SalesGroupedByInvoiceID(from, to);
invoiceItems.OrderBy(m => m.InvoiceID);
#endregion
#region All
if (model.radioButtons == "All" || model.radioButtons == null)
{
int inv = 0;
foreach (var item in invoiceItems)
{
inv = item.InvoiceID;
DetailedCustom customJob = new DetailedCustom();
Invoice invoice = new Invoice();
invoice = myHandler.GetInvoice(item.InvoiceID);
string xdate = invoice.DateCreated.ToString("dddd dd MMMM yyyy", CultureInfo.CreateSpecificCulture("en-US"));
customJob.DateIssued = xdate;
customJob.InvoiceID = item.InvoiceID;
customJob.InvoiceTotal = item.Price;
model.Detailed.Add(customJob);
}
}
#endregion
#region Books
else if (model.radioButtons == "Book")
{
foreach (var item in invoiceItems)
{
DetailedCustom customJob = new DetailedCustom();
Invoice invoice = new Invoice();
invoice = myHandler.GetInvoice(item.InvoiceID);
string xdate = invoice.DateCreated.ToString("dddd dd MMMM yyyy", CultureInfo.CreateSpecificCulture("en-US"));
customJob.DateIssued = xdate;
customJob.InvoiceID = item.InvoiceID;
IEnumerable<InvoiceItem> rawItems = myHandler.GetInvoiceItems(item.InvoiceID);
foreach (var inv in rawItems)
{
if (myHandler.CheckProductType(inv.ProductID))
{
if (customJob.InvoiceTotal == 0.0)
{ customJob.InvoiceTotal = inv.Price * inv.Quantity; }
else { customJob.InvoiceTotal += inv.Price * inv.Quantity; }
}
}
if (customJob.InvoiceTotal == 0.0)
{ }
else
{ model.Detailed.Add(customJob); }
}
}
#endregion
#region Devices
else if (model.radioButtons == "Dev")
{
foreach (var item in invoiceItems)
{
DetailedCustom customJob = new DetailedCustom();
Invoice invoice = new Invoice();
invoice = myHandler.GetInvoice(item.InvoiceID);
string xdate = invoice.DateCreated.ToString("dd MMMM yyyy", CultureInfo.CreateSpecificCulture("en-US"));
customJob.DateIssued = xdate;
customJob.InvoiceID = item.InvoiceID;
IEnumerable<InvoiceItem> rawItems = myHandler.GetInvoiceItems(item.InvoiceID);
foreach (var inv in rawItems)
{
if (myHandler.CheckProductType(inv.ProductID))
{
}
else
{
if (customJob.InvoiceTotal == 0.0)
{ customJob.InvoiceTotal = inv.Price * inv.Quantity; }
else { customJob.InvoiceTotal += inv.Price * inv.Quantity; }
}
}
if (customJob.InvoiceTotal == 0.0)
{ }
else
{ model.Detailed.Add(customJob); }
}
}
#endregion
#region Clean Up List
model.Detailed.OrderBy(m => m.InvoiceID);
List<DetailedCustom> cleanList = new System.Collections.Generic.List<DetailedCustom>();
cleanList = model.Detailed.Distinct().ToList();
model.Detailed = new List<DetailedCustom>();
model.Detailed = cleanList;
#endregion
#region Calc Total
model.Total = new TotalClass();
foreach (var item in model.Detailed)
{
model.Total.Total += item.InvoiceTotal;
}
#endregion
}
catch
{ model.Total = new TotalClass(); }
return View(model);
}