public ActionResult Reports(ReportSearchParams reportSearchModel)
{
try
{
ReportViewer reportViewer = LoadReport(reportSearchModel);
ViewBag.ReportViewer = reportViewer;
}
catch (Exception)
{
throw;
}
return(View());
}
private ReportViewer LoadReport(ReportSearchParams reportSearchModel)
{
#region Server Report
//ReportViewer reportViewer = new ReportViewer();
//reportViewer.ProcessingMode = ProcessingMode.Remote;
//reportViewer.SizeToReportContent = true;
//reportViewer.Width = System.Web.UI.WebControls.Unit.Percentage(100);
//reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);
//reportViewer.ServerReport.ReportPath = string.Format(ColorTrend.Common.GetAppKeyValue("ReportsPath"), reportName);
//reportViewer.ServerReport.ReportServerUrl = new Uri(ColorTrend.Common.GetAppKeyValue("ReportServerName"));
//reportViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials(ColorTrend.Common.GetAppKeyValue("ReportServerUser"), ColorTrend.Common.GetAppKeyValue("ReportServerPassword"), "");
#endregion
string reportName = "";
if (reportSearchModel == null || string.IsNullOrEmpty(reportSearchModel.ReportName))
{
reportName = "Empty";
}
else
{
reportName = reportSearchModel.ReportName;
}
#region Local Report
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.SizeToReportContent = true;
reportViewer.Width = System.Web.UI.WebControls.Unit.Percentage(100);
reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);
//TODO: To use our report path
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + string.Format(@"Reports\{0}.rdlc", reportName);
//TODO: To get datasource as per report;
reportViewer.LocalReport.DataSources.Clear();
// string value = SessionManagement.CurrentLang.ToString();
string value = SessionManagement.Language;
string lang = "EN";//default lang
if (value != "")
{
lang = value;
}
//TODO: Globalisation Of Reports
switch (reportName)
{
case "EmployeePresence":
ReportDataSet dsEP = new ReportDataSet();
usp_GetEmployeePresence1TableAdapter daEP = new usp_GetEmployeePresence1TableAdapter();
dsEP.EnforceConstraints = false;
daEP.Fill(dsEP.usp_GetEmployeePresence1, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
List <ReportParameter> parmE = new List <ReportParameter>();
DataTable dtEP = dsEP.Tables["usp_GetEmployeePresence1"];
ReportDataSource rptDataSourceEP = new ReportDataSource("GetEmployeePresence", dtEP);
reportViewer.LocalReport.DataSources.Add(rptDataSourceEP);
ReportParameter[] EmployeePresenceParm = new ReportParameter[] {
new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("EmployeePresence", new CultureInfo(lang))),
new ReportParameter("Date", Resources.Resource.ResourceManager.GetString("Date", new CultureInfo(lang))),
new ReportParameter("Start", Resources.Resource.ResourceManager.GetString("Start", new CultureInfo(lang))),
new ReportParameter("Stop", Resources.Resource.ResourceManager.GetString("Stop", new CultureInfo(lang)))
};
reportViewer.LocalReport.SetParameters(EmployeePresenceParm);
break;
case "EmployeeSms":
ReportDataSet dsES = new ReportDataSet();
usp_GetEmployeeSMSTableAdapter daES = new usp_GetEmployeeSMSTableAdapter();
dsES.EnforceConstraints = false;
daES.Fill(dsES.usp_GetEmployeeSMS, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
List <ReportParameter> parmES = new List <ReportParameter>();
DataTable dtES = dsES.Tables["usp_GetEmployeeSMS"];
ReportDataSource rptDataSourceES = new ReportDataSource("Getsms", dtES);
reportViewer.LocalReport.DataSources.Add(rptDataSourceES);
break;
case "ListCustomers":
ReportDataSet ds = new ReportDataSet();
usp_GetCustomersTableAdapter da = new usp_GetCustomersTableAdapter();
da.Fill(ds.usp_GetCustomers, SessionManagement.FactoryID, reportSearchModel.FilterSearch);
DataTable dt = ds.Tables["usp_GetCustomers"];
ReportDataSource rptDataSource = new ReportDataSource("GetCustomers", dt);
reportViewer.LocalReport.DataSources.Add(rptDataSource);
ReportParameter[] parm = new ReportParameter[] {
new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("ListCustomers", new CultureInfo(lang))),
new ReportParameter("Number", Resources.Resource.ResourceManager.GetString("Number", new CultureInfo(lang))),
new ReportParameter("CustomerName", Resources.Resource.ResourceManager.GetString("CustomerName", new CultureInfo(lang))),
new ReportParameter("Phone", Resources.Resource.ResourceManager.GetString("Phone", new CultureInfo(lang))),
new ReportParameter("Address", Resources.Resource.ResourceManager.GetString("Address", new CultureInfo(lang)))
};
reportViewer.LocalReport.SetParameters(parm);
break;
}
reportViewer.LocalReport.Refresh();
#endregion
return(reportViewer);
}
private ReportViewer LoadReport(ReportSearchParams reportSearchModel)
{
#region Server Report
//ReportViewer reportViewer = new ReportViewer();
//reportViewer.ProcessingMode = ProcessingMode.Remote;
//reportViewer.SizeToReportContent = true;
//reportViewer.Width = System.Web.UI.WebControls.Unit.Percentage(100);
//reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);
//reportViewer.ServerReport.ReportPath = string.Format(ColorTrend.Common.GetAppKeyValue("ReportsPath"), reportName);
//reportViewer.ServerReport.ReportServerUrl = new Uri(ColorTrend.Common.GetAppKeyValue("ReportServerName"));
//reportViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials(ColorTrend.Common.GetAppKeyValue("ReportServerUser"), ColorTrend.Common.GetAppKeyValue("ReportServerPassword"), "");
#endregion
string reportName = "";
if (reportSearchModel == null || string.IsNullOrEmpty(reportSearchModel.ReportName))
{
reportName = "Empty";
}
else
{
reportName = reportSearchModel.ReportName;
}
#region Local Report
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.SizeToReportContent = true;
reportViewer.Width = System.Web.UI.WebControls.Unit.Percentage(100);
reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);
//TODO: To use our report path
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + string.Format(@"Reports\{0}.rdlc", reportName);
//TODO: To get datasource as per report;
reportViewer.LocalReport.DataSources.Clear();
// string value = SessionManagement.CurrentLang.ToString();
string value = SessionManagement.Language;
string lang = "EN";//default lang
if (value != "")
{
lang = value;
}
//TODO: Globalisation Of Reports
switch (reportName)
{
case "EmployeePresence":
ReportDataSet dsEP = new ReportDataSet();
usp_GetEmployeePresence1TableAdapter daEP = new usp_GetEmployeePresence1TableAdapter();
dsEP.EnforceConstraints = false;
daEP.Fill(dsEP.usp_GetEmployeePresence1, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
List<ReportParameter> parmE = new List<ReportParameter>();
DataTable dtEP = dsEP.Tables["usp_GetEmployeePresence1"];
ReportDataSource rptDataSourceEP = new ReportDataSource("GetEmployeePresence", dtEP);
reportViewer.LocalReport.DataSources.Add(rptDataSourceEP);
ReportParameter[] EmployeePresenceParm = new ReportParameter[]{
new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("EmployeePresence", new CultureInfo(lang))),
new ReportParameter("Date",Resources.Resource.ResourceManager.GetString("Date", new CultureInfo(lang))),
new ReportParameter("Start",Resources.Resource.ResourceManager.GetString("Start", new CultureInfo(lang))),
new ReportParameter("Stop",Resources.Resource.ResourceManager.GetString("Stop", new CultureInfo(lang)))
};
reportViewer.LocalReport.SetParameters(EmployeePresenceParm);
break;
case "EmployeeSms":
ReportDataSet dsES = new ReportDataSet();
usp_GetEmployeeSMSTableAdapter daES = new usp_GetEmployeeSMSTableAdapter();
dsES.EnforceConstraints = false;
daES.Fill(dsES.usp_GetEmployeeSMS, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
List<ReportParameter> parmES = new List<ReportParameter>();
DataTable dtES = dsES.Tables["usp_GetEmployeeSMS"];
ReportDataSource rptDataSourceES = new ReportDataSource("Getsms", dtES);
reportViewer.LocalReport.DataSources.Add(rptDataSourceES);
break;
case "ListCustomers":
ReportDataSet ds = new ReportDataSet();
usp_GetCustomersTableAdapter da = new usp_GetCustomersTableAdapter();
da.Fill(ds.usp_GetCustomers, SessionManagement.FactoryID, reportSearchModel.FilterSearch);
DataTable dt = ds.Tables["usp_GetCustomers"];
ReportDataSource rptDataSource = new ReportDataSource("GetCustomers", dt);
reportViewer.LocalReport.DataSources.Add(rptDataSource);
ReportParameter[] parm = new ReportParameter[]{
new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("ListCustomers", new CultureInfo(lang))),
new ReportParameter("Number",Resources.Resource.ResourceManager.GetString("Number", new CultureInfo(lang))),
new ReportParameter("CustomerName",Resources.Resource.ResourceManager.GetString("CustomerName", new CultureInfo(lang))),
new ReportParameter("Phone",Resources.Resource.ResourceManager.GetString("Phone", new CultureInfo(lang))),
new ReportParameter("Address",Resources.Resource.ResourceManager.GetString("Address", new CultureInfo(lang)))
};
reportViewer.LocalReport.SetParameters(parm);
break;
}
reportViewer.LocalReport.Refresh();
#endregion
return reportViewer;
}
public ActionResult Reports(ReportSearchParams reportSearchModel)
{
try
{
ReportViewer reportViewer = LoadReport(reportSearchModel);
ViewBag.ReportViewer = reportViewer;
}
catch (Exception)
{
throw;
}
return View();
}