// 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));
        }
Esempio n. 3
0
        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();
        }
Esempio n. 4
0
        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());
        }
Esempio n. 7
0
        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");
            }
        }