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