public ActionResult ViewPdfReportForSearchResult(int sellsPointId, string fromDate, string toDate)
{
try
{
List <DAL.ViewModel.VM_Product> productList = unitOfWork.CustomRepository.sp_ProductSell(Convert.ToDateTime(fromDate), Convert.ToDateTime(toDate), sellsPointId);
var newProductList = new List <DAL.ViewModel.VM_Product>();
foreach (var product in productList)
{
DAL.ViewModel.VM_Product newProduct = new DAL.ViewModel.VM_Product();
newProduct.ProductName = product.ProductName;
newProduct.UnitPrice = product.UnitPrice;
newProduct.Quantity = product.Quantity;
newProduct.Unit = product.Unit;
newProduct.TotalPrice = product.TotalPrice;
newProductList.Add(newProduct);
}
string StoreName = unitOfWork.StoreRepository.GetByID(sellsPointId).store_name;
int restaurantId = Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());;
string restaurantName = unitOfWork.RestaurantRepository.GetByID(restaurantId).Name;
string restaurantAddress = unitOfWork.RestaurantRepository.GetByID(restaurantId).Address;
LocalReport localReport = new LocalReport();
localReport.ReportPath = Server.MapPath("~/Reports/ProductSellReport.rdlc");
localReport.SetParameters(new ReportParameter("FromDate", fromDate.ToString()));
localReport.SetParameters(new ReportParameter("ToDate", toDate.ToString()));
localReport.SetParameters(new ReportParameter("StoreName", StoreName));
localReport.SetParameters(new ReportParameter("RestaurantName", restaurantName));
localReport.SetParameters(new ReportParameter("RestaurantAddress", restaurantAddress));
ReportDataSource reportDataSource = new ReportDataSource("ProductSellDataSet", newProductList);
localReport.DataSources.Add(reportDataSource);
string reportType = "pdf";
string mimeType;
string encoding;
string fileNameExtension;
//The DeviceInfo settings should be changed based on the reportType
//http://msdn.microsoft.com/en-us/library/ms155397.aspx
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>PDF</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0.5in</MarginTop>" +
" <MarginLeft>0in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0.5in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
//Render the report
renderedBytes = localReport.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
return(File(renderedBytes, mimeType));
}
catch (Exception ex)
{
return(Json(new { success = false, errorMessage = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GenerateReportForSearchResult(DateTime date)
{
try
{
List <DAL.ViewModel.VM_Product> productList = unitOfWork.CustomRepository.sp_ProductEntryHistoryForaSpecificDateFromSupplierToMainStore(date);
decimal totalAmount = 0;
var newProductList = new List <DAL.ViewModel.VM_Product>();
foreach (var product in productList)
{
DAL.ViewModel.VM_Product newProduct = new DAL.ViewModel.VM_Product();
newProduct.SupplierName = product.SupplierName;
newProduct.ProductName = product.ProductName;
newProduct.UnitPrice = product.UnitPrice;
newProduct.Quantity = product.Quantity;
newProduct.TotalPrice = product.TotalPrice;
newProductList.Add(newProduct);
}
totalAmount = productList.Select(s => s.TotalPrice).Sum();
int restaurantId = Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());;
string restaurantName = unitOfWork.RestaurantRepository.GetByID(restaurantId).Name;
string restaurantAddress = unitOfWork.RestaurantRepository.GetByID(restaurantId).Address;
LocalReport localReport = new LocalReport();
localReport.ReportPath = Server.MapPath("~/Reports/ProductEntryHistoryForaSpecificDateFromSupplierToMainStoreReport.rdlc");
localReport.SetParameters(new ReportParameter("Date", date.ToString()));
localReport.SetParameters(new ReportParameter("RestaurantName", restaurantName));
localReport.SetParameters(new ReportParameter("RestaurantAddress", restaurantAddress));
ReportDataSource reportDataSource = new ReportDataSource("ProductEntryHistoryForaSpecificDateFromSupplierToMainStoreDataSet", newProductList);
localReport.DataSources.Add(reportDataSource);
string reportType = "pdf";
string mimeType;
string encoding;
string fileNameExtension;
//The DeviceInfo settings should be changed based on the reportType
//http://msdn.microsoft.com/en-us/library/ms155397.aspx
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>PDF</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0.5in</MarginTop>" +
" <MarginLeft>0in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0.5in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
//Render the report
renderedBytes = localReport.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
var path = System.IO.Path.Combine(Server.MapPath("~/pdfReport"));
var saveAs = string.Format("{0}.pdf", Path.Combine(path, "myfilename"));
var idx = 0;
while (System.IO.File.Exists(saveAs))
{
idx++;
saveAs = string.Format("{0}.{1}.pdf", Path.Combine(path, "myfilename"), idx);
}
Session["report"] = saveAs;
using (var stream = new FileStream(saveAs, FileMode.Create, FileAccess.Write))
{
stream.Write(renderedBytes, 0, renderedBytes.Length);
stream.Close();
}
localReport.Dispose();
return(Json(new { success = true, successMessage = "Product Report generated.", result = productList, TotalAmount = totalAmount }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, errorMessage = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
