public JsonResult GetBillGenerateList(string month, int year) { try { List <BillGenerateVM> _objList = _dishBillGenerateDA.GetBillList(month, year).OrderByDescending(x => x.billDetailId).ToList(); int totalRows = _objList.Count; int start = Convert.ToInt32(Request["start"]); int length = Convert.ToInt32(Request["length"]); string searchValue = Request["search[value]"]; string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][name]"]; string sortDirection = Request["order[0][dir]"]; if (!string.IsNullOrEmpty(searchValue)) { _objList = _objList.Where(x => x.customerSerial.ToLower().Contains(searchValue.ToLower()) || x.month.ToLower().Contains(searchValue.ToLower()) || x.yearName.ToLower().Contains(searchValue.ToLower())).ToList(); } //_objList = _objList.OrderBy(sortColumnName + " " + sortDirection).ToList<CustomerVM>(); _objList = _objList.Skip(start).Take(length).ToList(); return(Json(new { success = true, data = _objList, draw = Request["draw"], recordsTotal = totalRows, recordsFiltered = totalRows }, JsonRequestBehavior.AllowGet)); //return Json(new { success = true, data = _objList }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ShowReport(string fileType, string reportType, int?cid, int?receivedBy, int?collectedBy, bool?isActive, int?zoneId, string fromDate = "", string toDate = "", string ctype = "", string month = "", int year = 0, int pageNo = 0) { LocalReport lr = new LocalReport(); if (reportType == "AllDishCustomerDetails") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "AllDishCustomerDetails.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("isActive", isActive == null ? null : isActive.ToString())); reportParameters.Add(new ReportParameter("zoneId", zoneId + "")); lr.SetParameters(reportParameters); var dataList = _da.GetDishCustomerList(isActive, zoneId ?? 0, 0) ?? new List <CustomerVM>(); rd = new ReportDataSource("CustomerDataSet", dataList); lr.DataSources.Add(rd); } else if (reportType == "AllInternetCustomerDetails") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "AllInternetCustomerDetails.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("isActive", isActive == null ? null : isActive.ToString())); reportParameters.Add(new ReportParameter("zoneId", zoneId + "")); lr.SetParameters(reportParameters); var dataList = _da.GetInternetCustomerList(isActive, zoneId ?? 0, 0) ?? new List <CustomerVM>(); rd = new ReportDataSource("CustomerDataSet", dataList); lr.DataSources.Add(rd); } else if (reportType == "DishBillDetails") { DateTime rptFromDate = DateTime.ParseExact(fromDate, "dd/MM/yyyy", null); DateTime rptToDate = DateTime.ParseExact(toDate, "dd/MM/yyyy", null); string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), ctype == "0" ? "AllDishBillDetails.rdlc" : "AllDishBillDetailsByType.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("fromDate", rptFromDate.ToString())); reportParameters.Add(new ReportParameter("toDate", rptToDate.ToString())); reportParameters.Add(new ReportParameter("cid", cid.ToString())); reportParameters.Add(new ReportParameter("receivedBy", receivedBy.ToString())); reportParameters.Add(new ReportParameter("collectedBy", collectedBy.ToString())); if (ctype != "0") { reportParameters.Add(new ReportParameter("ctype", ctype)); } lr.SetParameters(reportParameters); if (ctype == "0") { var dataList = _da.GetDishBillCollections(rptFromDate, rptToDate, cid ?? 0, receivedBy ?? 0, collectedBy ?? 0) ?? new List <PCOHRApp.Models.BillCollectionVM>(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); } else { var dataList = _da.GetDishBillCollectionByType(rptFromDate, rptToDate, cid ?? 0, receivedBy ?? 0, collectedBy ?? 0, ctype) ?? new List <PCOHRApp.Models.BillCollectionVM>(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); } } else if (reportType == "InternetBillDetails") { DateTime rptFromDate = DateTime.ParseExact(fromDate, "dd/MM/yyyy", null); DateTime rptToDate = DateTime.ParseExact(toDate, "dd/MM/yyyy", null); string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), ctype == "0" ? "AllInternetBillDetails.rdlc" : "AllInternetBillDetailsByType.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("fromDate", rptFromDate.ToString())); reportParameters.Add(new ReportParameter("toDate", rptToDate.ToString())); reportParameters.Add(new ReportParameter("cid", cid.ToString())); reportParameters.Add(new ReportParameter("receivedBy", receivedBy.ToString())); reportParameters.Add(new ReportParameter("collectedBy", collectedBy.ToString())); if (ctype != "0") { reportParameters.Add(new ReportParameter("ctype", ctype)); } lr.SetParameters(reportParameters); if (ctype == "0") { var dataList = _da.GetInternetBillCollections(rptFromDate, rptToDate, cid ?? 0, receivedBy ?? 0, collectedBy ?? 0) ?? new List <PCOHRApp.Models.BillCollectionVM>(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); } else { var dataList = _da.GetInternetBillCollectionByType(rptFromDate, rptToDate, cid ?? 0, receivedBy ?? 0, collectedBy ?? 0, ctype) ?? new List <PCOHRApp.Models.BillCollectionVM>(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); } } else if (reportType == "DishBillDue") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "DishCustomerDue.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("zoneId", zoneId + "")); lr.SetParameters(reportParameters); var dataList = _da.GetDishCustomerDue(zoneId ?? 0) ?? new List <PCOHRApp.Models.BillCollectionVM>(); lr.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); lr.Refresh(); } else if (reportType == "InternetBillDue") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "InternetCustomerDue.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("zoneId", zoneId + "")); lr.SetParameters(reportParameters); var dataList = _da.GetInternetCustomerDue(zoneId ?? 0) ?? new List <PCOHRApp.Models.BillCollectionVM>(); lr.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); lr.Refresh(); } else if (reportType == "DishPaymentHistory") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "DishPaymentHistory.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("cid", cid + "")); lr.SetParameters(reportParameters); var dataList = _da.GetDishPaymentHistory(cid ?? 0) ?? new List <PCOHRApp.Models.BillCollectionVM>(); lr.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); } else if (reportType == "InternetPaymentHistory") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "InternetPaymentHistory.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("cid", cid + "")); lr.SetParameters(reportParameters); var dataList = _da.GetInternetPaymentHistory(cid ?? 0) ?? new List <PCOHRApp.Models.BillCollectionVM>(); lr.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); } else if (reportType == "HostList") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "HostList.rdlc"); lr.ReportPath = path; var dataList = _hostDa.GetHostList() ?? new List <HostVM>(); lr.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("HostDataSet", dataList); lr.DataSources.Add(rds); } else if (reportType == "MonthWiseDishBillGenerate") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "MonthWiseDishBillGenerate.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("month", month)); reportParameters.Add(new ReportParameter("year", year + "")); lr.SetParameters(reportParameters); var dataList = _dishBillGenerateDA.GetBillList(month, year) ?? new List <BillGenerateVM>(); lr.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("BillDataSet", dataList); lr.DataSources.Add(rds); } else if (reportType == "MonthWiseInternetBillGenerate") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "MonthWiseInternetBillGenerate.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); reportParameters.Add(new ReportParameter("month", month)); reportParameters.Add(new ReportParameter("year", year + "")); lr.SetParameters(reportParameters); var dataList = _internetBillGenerateDA.GetBillList(month, year) ?? new List <BillGenerateVM>(); lr.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("BillDataSet", dataList); lr.DataSources.Add(rds); } else if (reportType == "DishBillCollectionPageWise") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "DishBillDetails.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); lr.SetParameters(reportParameters); var dataList = _da.GetDishCollectionPageWise(year, pageNo, receivedBy ?? 0) ?? new List <BillCollectionVM>(); lr.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); } else if (reportType == "InternetBillCollectionPageWise") { string path = System.IO.Path.Combine(Server.MapPath("~/Reports"), "InternetBillDetails.rdlc"); lr.ReportPath = path; ReportParameterCollection reportParameters = new ReportParameterCollection(); lr.SetParameters(reportParameters); var dataList = _da.GetInternetCollectionPageWise(year, pageNo, receivedBy ?? 0) ?? new List <BillCollectionVM>(); lr.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("CollectionDataSet", dataList); lr.DataSources.Add(rds); } string rptType = fileType; string mimeType; string encoding; string fileNameExtension; string deviceInfo = "<DeviceInfo>" + " <OutputFormat>" + fileType + "</OutputFormat>" + "</DeviceInfo>"; Warning[] warnings; string[] streams; byte[] renderedBytes; renderedBytes = lr.Render( rptType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings); return(File(renderedBytes, mimeType)); }