public ActionResult GetByFilter(string manager, string product, string date)
{
SaleRowsModel saleRowsModel = new SaleRowsModel();
var newManager = managerRepository.GetEntity(new DAL.Models.Manager()
{
ManagerName = manager
});
if (newManager != null)
{
var dataM = saleInfoRepository.Items.Where(x => x.ID_Manager == newManager.ID_Manager);
foreach (var saleInfo in dataM)
{
var newDate = saleInfo.SaleDate;
var managerName = managerRepository.GetEntityNameById(saleInfo.ID_Manager.Value);
var clientName = clientRepository.GetEntityNameById(saleInfo.ID_Client.Value);
var newProduct = productRepository.GetEntityNameById(saleInfo.ID_Product.Value);
saleRowsModel.ListRow.Add(new SaleRowModel()
{
ManagerName = managerName.ManagerName, Date = newDate, ClientName = clientName.ClientName, ProductName = newProduct.ProductName, ProductCost = newProduct.ProductCost
});
}
}
if (!string.IsNullOrEmpty(product) && !product.Equals("-"))
{
saleRowsModel.ListRow = saleRowsModel.ListRow.Where(x => x.ProductName.Equals(product)).ToList();
}
if (!string.IsNullOrEmpty(date))
{
saleRowsModel.ListRow = saleRowsModel.ListRow.Where(x => x.Date.Contains(date)).ToList();
}
return(View("~/Areas/Default/Views/Saleinfo/SaleRows.cshtml", saleRowsModel));
}
public ActionResult Index(int page = 1)
{
//var list = saleInfoRepository.Items.OrderByDescending(x => x.ID_Sale);
SaleRowsModel saleRowsModel = new SaleRowsModel();
//var newManager = managerRepository.GetEntity(new DAL.Models.Manager() { ManagerName = manager });
//if (newManager != null)
//{
var dataM = saleInfoRepository.Items.Select(x => x);
foreach (var saleInfo in dataM)
{
var newDate = saleInfo.SaleDate;
var managerName = managerRepository.GetEntityNameById(saleInfo.ID_Manager.Value);
var clientName = clientRepository.GetEntityNameById(saleInfo.ID_Client.Value);
var newProduct = productRepository.GetEntityNameById(saleInfo.ID_Product.Value);
saleRowsModel.ListRow.Add(new SaleRowModel()
{
ManagerName = managerName.ManagerName, Date = newDate, ClientName = clientName.ClientName, ProductName = newProduct.ProductName, ProductCost = newProduct.ProductCost
});
}
//}
return(View(saleRowsModel));
}