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