public ActionResult GetOrderExitReport(DateTime fromDate, DateTime toDate)
{
List <string> Exitheders = new List <string>();
Exitheders.Add("Product Name");
Exitheders.Add("Product Number");
Exitheders.Add("Client Name");
Exitheders.Add("Quantity");
Exitheders.Add("Cost");
Exitheders.Add("Exit Date");
var ordersExit = (from sto in orderExitService.GetAll().ToList()
join cli in clientService.GetAll().ToList() on sto.ClientId equals cli.UniqueId
join pro in productService.GetAll().ToList() on sto.ProductId equals pro.UniqueId
where sto.CreatedDate.Date >= fromDate.Date && sto.CreatedDate.Date <= toDate.Date && sto.IsActive == true
select new WMS.WebUI.Models.OrderExitReport
{
ProductName = pro.Name,
ProductNumber = pro.Number,
ClientName = cli.Name,
Quantity = sto.Quatity,
Cost = sto.Cost,
ExitDate = sto.ExitDate.ToString("dd-MM-yyyy")
}).ToList();
DataSet ds = new DataSet();
DataTable orderExitTable = ExportExcelhelper.ListToDataTable(ordersExit);
ds.Tables.Add(orderExitTable);
byte[] filecontent = ExportExcelhelper.ExportExcelDataset(ds, Exitheders, "Sell Orders", true, null, null, Exitheders.ToArray());
return(File(filecontent, ExportExcelhelper.ExcelContentType, "OrderExit.xlsx"));
}
public ActionResult GetOrderEntryReport(DateTime fromDate, DateTime toDate)
{
List <string> Entryheders = new List <string>();
Entryheders.Add("Product Name");
Entryheders.Add("Product Number");
Entryheders.Add("Supplier Name");
Entryheders.Add("Unit Name");
Entryheders.Add("Quantity");
Entryheders.Add("Cost");
Entryheders.Add("Entry Date");
var ordersEntry = (from sto in stockService.GetAll().ToList()
join sup in supplierService.GetAll().ToList() on sto.SupplierId equals sup.UniqueId
join pro in productService.GetAll().ToList() on sto.ProductId equals pro.UniqueId
join un in unitService.GetAll().ToList() on sto.UnitId equals un.UniqueId
where sto.CreatedDate.Date >= fromDate.Date && sto.CreatedDate.Date <= toDate.Date && sto.IsActive == true
select new OrderEnterReport
{
ProductName = pro.Name,
ProductNumber = pro.Number,
SupplierName = sup.Name,
UnitName = un.Name,
Quantity = sto.Quatity,
CostPerProduct = sto.CostPerProduct,
EntryDate = sto.EntryDate.ToString("dd-MM-yyyy")
}).ToList();
DataSet ds = new DataSet();
DataTable orderEntryTable = ExportExcelhelper.ListToDataTable(ordersEntry);
ds.Tables.Add(orderEntryTable);
byte[] filecontent = ExportExcelhelper.ExportExcelDataset(ds, Entryheders, "Purchase Orders", true, null, null, Entryheders.ToArray());
return(File(filecontent, ExportExcelhelper.ExcelContentType, "OrderEntries.xlsx"));
}