public ActionResult GetMonthlyDepartmentReport(DateTime FromDate, DateTime ToDate) { var data = db.BillServices.Where(p => p.Paid == true && p.PaidDate >= FromDate && p.PaidDate <= ToDate).ToList(); var allDepartments = db.Departments.ToList(); var CrystalReportData = new List <DepartmentReportViewModel>(); foreach (var item in allDepartments) { var singleDept = new DepartmentReportViewModel(); singleDept.DepartmentName = item.DepartmentName; singleDept.Amount = data.Where(p => p.DepartmentId == item.Id).Sum(x => x.Quatity * x.Price); CrystalReportData.Add(singleDept); } BillPaymentsDataSet billPayments = new BillPaymentsDataSet(); foreach (var item in CrystalReportData) { billPayments.BillPayments.AddBillPaymentsRow(item.DepartmentName, item.Amount); } ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/CrystalReports/Finance/BillPyments.rpt"))); rd.SetDataSource(billPayments); rd.Subreports["RptReportHeader.rpt"].SetDataSource(HeaderAndFooterForReports.GetAllReportHeader()); rd.SetParameterValue("fromDate", FromDate); rd.SetParameterValue("toDate", ToDate); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); string fileName = " - " + DateTime.Today + ".pdf"; return(File(stream, "application/pdf", fileName)); }
public ActionResult GetDrugWiseReport(DateTime FromDate, DateTime ToDate, int?DrugId, int?insuaranceCompany) { DrugWiseReportDataSet drugWiseReportDataSet = new DrugWiseReportDataSet(); drugWiseReportDataSet = GetDrugTWiseReportData(FromDate, ToDate, DrugId, insuaranceCompany); ReportDocument Rd = new ReportDocument(); Rd.Load(Path.Combine(Server.MapPath("~/Areas/PharmacyModule/Reports/DrugWiseReport/DrugWiseReport.rpt"))); Rd.SetDataSource(drugWiseReportDataSet); Rd.Subreports["RptReportHeader.rpt"].SetDataSource(HeaderAndFooterForReports.GetAllReportHeader()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream Stream = Rd.ExportToStream( CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Stream.Seek(0, SeekOrigin.Begin); return(File(Stream, "application/pdf", "DrugWiseSummary.pdf")); }
public ActionResult GetCurrentStockReport(string ItemName, string CurrentStockFilter, bool?IsDonor) { var items = db.ItemMaster.Where(p => p.StoreName == "MS").ToList(); if (ItemName != null && ItemName.Length > 0) { items = items.Where(e => e.ItemName.Contains(ItemName)).ToList(); } if (CurrentStockFilter != null && !CurrentStockFilter.Equals("all")) { if (CurrentStockFilter.Equals("greater")) { items = items.Where(e => e.CurrentStock > 0).ToList(); } if (CurrentStockFilter.Equals("less")) { items = items.Where(e => e.CurrentStock == 0).ToList(); } } if (IsDonor != null && (bool)IsDonor) { } DataSetCurrentStock dataSet = new DataSetCurrentStock(); if (items.Count() > 0) { foreach (var item in items.OrderBy(E => E.ItemName)) { var date = (item.ExpiryDate ?? DateTime.Now.Date.AddYears(1)); dataSet.ItemMasterItem.AddItemMasterItemRow( item.BatchNo.ToUpper(), item.ItemName.ToUpper(), item.CurrentStock, //DateTime.Now, date, item.ReorderLevel, Convert.ToDecimal(item.CostPriceUnit) ); } } ReportDocument Rd = new ReportDocument(); Rd.Load(Path.Combine(Server.MapPath("~/Areas/PharmacyModule/Reports/CurrentStock/RptCurrentStock.rpt"))); Rd.SetDataSource(dataSet); Rd.Subreports["RptReportHeader.rpt"].SetDataSource(HeaderAndFooterForReports.GetAllReportHeader()); Rd.Subreports["RptReportFooter.rpt"].SetDataSource(HeaderAndFooterForReports.GetAllReportFooter()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream Stream = Rd.ExportToStream( CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Stream.Seek(0, SeekOrigin.Begin); string FileName = "PCurrentStock " + DateTime.Now.ToString() + ".pdf"; return(File(Stream, "application/pdf", FileName)); }