// GET: Orders/Details/5 public ActionResult Details(int id) { IEnumerable <Lib.Customer> customers = CRepo.GetCustomers(); IEnumerable <Lib.Store> stores = SRepo.GetStores(); IEnumerable <Lib.Order> orders = ORepo.GetOrders(); List <Lib.OrderList> orderLists = ORepo.GetOrderLists(id).OrderBy(o => o.OrderId).ToList(); List <Lib.Products> products = PRepo.GetProducts().OrderBy(p => p.ItemId).ToList(); Lib.Order order = ORepo.GetOrderByOrderId(id); var viewModels = orders.Select(o => new Orders { OrderId = o.OrderId, StoreId = o.StoreId, CustomerId = o.CustomerId, DatePurchased = o.DatePurchased, Total = o.Total, //double total = db.tblCustomerOrders.Where(x => x.CustomerID == customer.CustomerID).Select(t => t.Amount ?? 0).Sum(); StoreName = stores.Single(s => s.Id == o.StoreId).Name, FirstName = customers.Single(c => c.Id == o.CustomerId).FirstName, LastName = customers.Single(c => c.Id == o.CustomerId).LastName, FullName = customers.Single(c => c.Id == o.CustomerId).FirstName + " " + customers.Single(c => c.Id == o.CustomerId).LastName }).ToList(); return(View()); }
// GET: Orders public ActionResult Index() { IEnumerable <Lib.Customer> customers = CRepo.GetCustomers(); IEnumerable <Lib.Store> stores = SRepo.GetStores(); IEnumerable <Lib.Products> products = PRepo.GetProducts(); IEnumerable <Lib.Order> orders = ORepo.GetOrders(); var viewModels = orders.Select(o => new Orders { OrderId = o.OrderId, StoreId = o.StoreId, CustomerId = o.CustomerId, DatePurchased = o.DatePurchased, Total = o.Total, StoreName = stores.Single(s => s.Id == o.StoreId).Name, FirstName = customers.Single(c => c.Id == o.CustomerId).FirstName, LastName = customers.Single(c => c.Id == o.CustomerId).LastName, FullName = customers.Single(c => c.Id == o.CustomerId).FirstName + " " + customers.Single(c => c.Id == o.CustomerId).LastName }).ToList(); decimal?totalSum = 0; decimal?maxNum = viewModels.Any() ? viewModels.Max(ma => ma.Total) : 0; decimal?minNum = viewModels.Any() ? viewModels.Min(ma => ma.Total) : 0; foreach (var item in viewModels) { totalSum += item.Total; } ViewBag.totalSum = totalSum; ViewBag.averageSum = totalSum / viewModels.Count(); ViewBag.maxNum = maxNum; ViewBag.minNum = minNum; return(View(viewModels)); }
private void txtIdSearch_ButtonClick(object sender, EventArgs e) { string sql = "select * from sale where id like'%" + this.txtIdSearch.Text + "%'"; this.dgvSale.AutoGenerateColumns = false; this.dgvSale.DataSource = SRepo.GetAll(sql).ToList(); this.dgvSale.ClearSelection(); this.dgvSale.Refresh(); }
private void PopulateGridView() { this.dgvSale.AutoGenerateColumns = false; this.dgvSale.DataSource = SRepo.GetAll().ToList(); this.dgvSale.ClearSelection(); this.dgvSale.Refresh(); this.lblTotalSale.Text = "Total Sale : " + SRepo.CalculateTotalPrice().ToString() + " Taka"; SRepo.calculateTotalPrice = 0; }
public ActionResult Create(Orders order) { try { // TODO: Add insert logic here var stores = SRepo.GetStores().ToList(); order.Stores = new List <Lib.Store>(); if (order.Stores == null) { foreach (var s in stores) { var tmpStore = new Lib.Store { Id = s.Id, Name = s.Name }; order.Stores.Add(tmpStore); } } var ord = new Lib.Order { StoreId = order.StoreId, DatePurchased = DateTime.Now, CustomerId = order.CustomerId, Total = 0 }; int orderCount = ORepo.GetOrders().Count() + 2; int oid = ORepo.GetOrders().Last().OrderId + 1; TempData["Order Id"] = oid; ORepo.InsertOrder(ord); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
// GET: Orders/Create public ActionResult Create() { List <Lib.Products> products = PRepo.GetProducts().OrderBy(p => p.ItemId).ToList(); List <Lib.OrderList> orderLists = new List <Lib.OrderList>(); List <Lib.Customer> Customers = CRepo.GetCustomers().ToList(); foreach (var product in products) { orderLists.Add(new Lib.OrderList { OrderId = 0, ItemId = 0, OrderListId = 0, ItemBought = 0 }); } List <SelectListItem> customerItems = new List <SelectListItem>(); foreach (var customer in Customers) { customerItems.Add(new SelectListItem() { Text = customer.FirstName + " " + customer.LastName, Value = customer.Id.ToString() }); } var viewModel = new Orders { Stores = SRepo.GetStores().ToList(), customerItems = customerItems, Products = products, OrderLists = orderLists }; return(View()); }
private void btnDone_Click(object sender, EventArgs e) { if (this.FillEntity() == true) { // this.FillEntity(); bool s = SRepo.SoldItemUpdate(sal); if (s == true) { bool m = MRepo.SoldItemUpdate(medi); MessageBox.Show("Update Successfull"); this.PopulateGridView(); this.pnlUpdate.Visible = false; } else { MessageBox.Show("Update Failed"); } } else { MessageBox.Show("Please Fill the Fields Correctly"); } }