public static List <ICallDetail> GetCustomerListWithLoc(ICallDetail detail, DateTime currDate, int userId) { string strExecution = "[report].[uspGetCustomerListWithLoc]"; List <ICallDetail> lstCallDetail = new List <ICallDetail>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@LocId", detail.LocationId); oDq.AddVarcharParam("@AreaName", 50, detail.AreaName); oDq.AddIntegerParam("@SalesExecutiveId", detail.SalesPersionId); oDq.AddDateTimeParam("@CurrDate", currDate); oDq.AddIntegerParam("@UserId", userId); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { ICallDetail callDetail = new CallDetailEntity(); callDetail.AreaName = Convert.ToString(reader["AreaName"]); callDetail.GroupCompanyName = Convert.ToString(reader["GroupName"]); callDetail.Address = Convert.ToString(reader["Address"]); callDetail.Contact = Convert.ToString(reader["Contact"]); callDetail.Profile = Convert.ToString(reader["CustomerProfile"]); callDetail.TEU = Convert.ToInt32(reader["TEU"]); callDetail.SalesPersonName = Convert.ToString(reader["SalesPerson"]); lstCallDetail.Add(callDetail); } reader.Close(); } return(lstCallDetail); }
private void GenerateReport() { ReportBLL cls = new ReportBLL(); ICallDetail callDetail = new CallDetailEntity(); LocalReportManager reportManager = new LocalReportManager(rptViewer, "DailyCallRpt", ConfigurationManager.AppSettings["ReportNamespace"].ToString(), ConfigurationManager.AppSettings["ReportPath"].ToString()); string rptName = "DailyCallRpt.Rdlc"; DateTime fromDate; DateTime toDate; fromDate = Convert.ToDateTime(txtFromDt.Text, _culture); toDate = Convert.ToDateTime(txtToDt.Text, _culture); BuildEntity(callDetail); IEnumerable <ICallDetail> lst = cls.GetDailyCallData(fromDate, toDate, callDetail, _userId); rptViewer.Reset(); rptViewer.LocalReport.Dispose(); rptViewer.LocalReport.DataSources.Clear(); rptViewer.LocalReport.ReportPath = this.Server.MapPath(this.Request.ApplicationPath) + ConfigurationManager.AppSettings["ReportPath"].ToString() + "/" + rptName; //rptViewer.LocalReport.ReportPath = Server.MapPath("/" + ConfigurationManager.AppSettings["ReportPath"].ToString() + "/" + rptName); rptViewer.LocalReport.DataSources.Add(new ReportDataSource("ReportDataSet", lst)); rptViewer.LocalReport.SetParameters(new ReportParameter("CompanyName", Convert.ToString(ConfigurationManager.AppSettings["CompanyName"]))); rptViewer.LocalReport.SetParameters(new ReportParameter("FromDate", txtFromDt.Text)); rptViewer.LocalReport.SetParameters(new ReportParameter("ToDate", txtToDt.Text)); rptViewer.LocalReport.SetParameters(new ReportParameter("Location", ddlLoc.SelectedItem.Text)); rptViewer.LocalReport.SetParameters(new ReportParameter("SalesPerson", ddlSales.SelectedItem.Text)); rptViewer.LocalReport.SetParameters(new ReportParameter("Prospect", ddlPros.SelectedItem.Text)); rptViewer.LocalReport.SetParameters(new ReportParameter("CallType", ddlType.SelectedItem.Text)); rptViewer.LocalReport.Refresh(); }
private void GenerateReport() { ReportBLL cls = new ReportBLL(); ICallDetail callDetail = new CallDetailEntity(); LocalReportManager reportManager = new LocalReportManager(rptViewer, "CustomerListWithLoc", ConfigurationManager.AppSettings["ReportNamespace"].ToString(), ConfigurationManager.AppSettings["ReportPath"].ToString()); string rptName = "CustomerListWithLoc.rdlc"; BuildEntity(callDetail); IEnumerable <ICallDetail> lst = cls.GetCustomerListWithLoc(callDetail, _userId); rptViewer.Reset(); rptViewer.LocalReport.Dispose(); rptViewer.LocalReport.DataSources.Clear(); rptViewer.LocalReport.ReportPath = this.Server.MapPath(this.Request.ApplicationPath) + ConfigurationManager.AppSettings["ReportPath"].ToString() + "/" + rptName; rptViewer.LocalReport.DataSources.Add(new ReportDataSource("ReportDataSet", lst)); rptViewer.LocalReport.SetParameters(new ReportParameter("CompanyName", Convert.ToString(ConfigurationManager.AppSettings["CompanyName"]))); if (txtArea.Text != ResourceManager.GetStringWithoutName("ERR00016")) { rptViewer.LocalReport.SetParameters(new ReportParameter("AreaName", txtArea.Text)); } else { rptViewer.LocalReport.SetParameters(new ReportParameter("AreaName", txtArea.Text)); } rptViewer.LocalReport.SetParameters(new ReportParameter("Location", ddlLoc.SelectedItem.Text)); rptViewer.LocalReport.SetParameters(new ReportParameter("SalesPerson", ddlSales.SelectedItem.Text)); rptViewer.LocalReport.Refresh(); }
public static List <ICallDetail> GetCallTypeWiseDailyData(DateTime fromDate, DateTime toDate, ICallDetail detail, int userId) { string strExecution = "[report].[uspGetCallTypeWiseDailyData]"; List <ICallDetail> lstCallDetail = new List <ICallDetail>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddDateTimeParam("@FromDate", fromDate); oDq.AddDateTimeParam("@ToDate", toDate); oDq.AddIntegerParam("@LocId", detail.LocationId); oDq.AddIntegerParam("@SalesExecutiveId", detail.SalesPersionId); oDq.AddIntegerParam("@ProspectId", detail.ProspectId); oDq.AddIntegerParam("@CallTypeId", detail.CallTypeId); oDq.AddIntegerParam("@UserId", userId); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { ICallDetail callDetail = new CallDetailEntity(); if (reader["LocId"] != DBNull.Value) { callDetail.LocationId = Convert.ToInt32(reader["LocId"]); callDetail.LocationName = Convert.ToString(reader["LocName"]); } callDetail.ProspectFor = Convert.ToString(reader["ProspectName"]); callDetail.CallDate = Convert.ToDateTime(reader["CallDate"]); callDetail.GroupCompanyName = Convert.ToString(reader["GroupName"]); callDetail.CallType = Convert.ToString(reader["CallType"]); if (reader["NextCallOn"] != DBNull.Value) { callDetail.NextCallDate = Convert.ToDateTime(reader["NextCallOn"]); } callDetail.CallDetails = Convert.ToString(reader["Remarks"]); if (reader["SalesPersionId"] != DBNull.Value) { callDetail.SalesPersionId = Convert.ToInt32(reader["SalesPersionId"]); callDetail.SalesPersonName = Convert.ToString(reader["SalesPerson"]); } lstCallDetail.Add(callDetail); } reader.Close(); } return(lstCallDetail); }
public static List <ICallDetail> GetYearlyMisReportData(int year, ICallDetail detail, char reportType, int userId) { string strExecution = "[report].[uspGetYearlyMisReportData]"; List <ICallDetail> lstCallDetail = new List <ICallDetail>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@Year", year); oDq.AddIntegerParam("@LocId", detail.LocationId); oDq.AddIntegerParam("@ProspectId", detail.ProspectId); oDq.AddCharParam("@ReportType", 1, reportType); oDq.AddIntegerParam("@UserId", userId); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { ICallDetail callDetail = new CallDetailEntity(); callDetail.LocationId = Convert.ToInt32(reader["LocId"]); callDetail.LocationName = Convert.ToString(reader["LocName"]); callDetail.ProspectFor = Convert.ToString(reader["ProspectName"]); callDetail.Month1 = Convert.ToInt32(reader["Month1"]); callDetail.Month2 = Convert.ToInt32(reader["Month2"]); callDetail.Month3 = Convert.ToInt32(reader["Month3"]); callDetail.Month4 = Convert.ToInt32(reader["Month4"]); callDetail.Month5 = Convert.ToInt32(reader["Month5"]); callDetail.Month6 = Convert.ToInt32(reader["Month6"]); callDetail.Month7 = Convert.ToInt32(reader["Month7"]); callDetail.Month8 = Convert.ToInt32(reader["Month8"]); callDetail.Month9 = Convert.ToInt32(reader["Month9"]); callDetail.Month10 = Convert.ToInt32(reader["Month10"]); callDetail.Month11 = Convert.ToInt32(reader["Month11"]); callDetail.Month12 = Convert.ToInt32(reader["Month12"]); callDetail.Total = Convert.ToInt32(reader["Total"]); lstCallDetail.Add(callDetail); } reader.Close(); } return(lstCallDetail); }
public static List <ICallDetail> GetCustomerWithCallDetail(DateTime fromDate, DateTime toDate, ICallDetail detail, int userId) { string strExecution = "[report].[uspGetCustomerWithCallDetail]"; List <ICallDetail> lstCallDetail = new List <ICallDetail>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddDateTimeParam("@FromDate", fromDate); oDq.AddDateTimeParam("@ToDate", toDate); oDq.AddIntegerParam("@AreaId", detail.AreaId); oDq.AddIntegerParam("@LocId", detail.LocationId); oDq.AddIntegerParam("@UserId", userId); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { ICallDetail callDetail = new CallDetailEntity(); callDetail.AreaName = Convert.ToString(reader["AreaName"]); callDetail.GroupCompanyName = Convert.ToString(reader["GroupName"]); callDetail.Address = Convert.ToString(reader["Address"]); callDetail.Contact = Convert.ToString(reader["Contact"]); callDetail.Profile = Convert.ToString(reader["CustomerProfile"]); callDetail.CallDate = Convert.ToDateTime(reader["CallDate"]); callDetail.CallType = Convert.ToString(reader["CallType"]); if (reader["NextCallOn"] != DBNull.Value) { callDetail.NextCallDate = Convert.ToDateTime(reader["NextCallOn"]); } callDetail.CallDetails = Convert.ToString(reader["Remarks"]); lstCallDetail.Add(callDetail); } reader.Close(); } return(lstCallDetail); }
private void GenerateReport() { ReportBLL cls = new ReportBLL(); ICallDetail callDetail = new CallDetailEntity(); LocalReportManager reportManager = new LocalReportManager(rptViewer, "MISRptYearly", ConfigurationManager.AppSettings["ReportNamespace"].ToString(), ConfigurationManager.AppSettings["ReportPath"].ToString()); string rptName = "MISRptYearly.rdlc"; BuildEntity(callDetail); IEnumerable <ICallDetail> lst = cls.GetYearlyMisReportData(Convert.ToInt32(ddlYear.SelectedValue), callDetail, Convert.ToChar(ddlParam.SelectedValue), _userId); rptViewer.Reset(); rptViewer.LocalReport.Dispose(); rptViewer.LocalReport.DataSources.Clear(); rptViewer.LocalReport.ReportPath = this.Server.MapPath(this.Request.ApplicationPath) + ConfigurationManager.AppSettings["ReportPath"].ToString() + "/" + rptName; rptViewer.LocalReport.DataSources.Add(new ReportDataSource("ReportDataSet", lst)); rptViewer.LocalReport.SetParameters(new ReportParameter("CompanyName", Convert.ToString(ConfigurationManager.AppSettings["CompanyName"]))); rptViewer.LocalReport.SetParameters(new ReportParameter("Location", ddlLoc.SelectedItem.Text)); rptViewer.LocalReport.SetParameters(new ReportParameter("ReportType", ddlParam.SelectedItem.Text)); rptViewer.LocalReport.SetParameters(new ReportParameter("RptYear", ddlYear.SelectedItem.Text)); rptViewer.LocalReport.SetParameters(new ReportParameter("Prospect", ddlPros.SelectedItem.Text)); rptViewer.LocalReport.Refresh(); }
public static List <ICallDetail> GetLocationWiseLineSummary(DateTime fromDate, DateTime toDate, ICallDetail detail, int userId) { string strExecution = "[report].[uspGetLocationWiseLineSummary]"; List <ICallDetail> lstCallDetail = new List <ICallDetail>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddDateTimeParam("@FromDate", fromDate); oDq.AddDateTimeParam("@ToDate", toDate); oDq.AddIntegerParam("@LocId", detail.LocationId); oDq.AddIntegerParam("@ProspectId", detail.ProspectId); oDq.AddIntegerParam("@UserId", userId); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { ICallDetail callDetail = new CallDetailEntity(); callDetail.LocationId = Convert.ToInt32(reader["LocId"]); callDetail.LocationName = Convert.ToString(reader["LocName"]); callDetail.ProspectId = Convert.ToInt32(reader["ProspectId"]); callDetail.ProspectFor = Convert.ToString(reader["ProspectName"]); callDetail.SalesPersonName = Convert.ToString(reader["SalesPerson"]); callDetail.TEU = Convert.ToInt32(reader["TEU"]); callDetail.FEU = Convert.ToInt32(reader["FEU"]); callDetail.TEUActual = Convert.ToInt32(reader["TEUActual"]); callDetail.FEUActual = Convert.ToInt32(reader["FEUActual"]); lstCallDetail.Add(callDetail); } reader.Close(); } return(lstCallDetail); }
public static List <ICallDetail> GetMisReportData(DateTime fromDate, DateTime toDate, ICallDetail detail, char reportType, int userId) { string strExecution = "[report].[uspGetMisReportData]"; List <ICallDetail> lstCallDetail = new List <ICallDetail>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddDateTimeParam("@FromDate", fromDate); oDq.AddDateTimeParam("@ToDate", toDate); oDq.AddIntegerParam("@LocId", detail.LocationId); oDq.AddIntegerParam("@LineId", detail.ProspectId); oDq.AddCharParam("@ReportType", 1, reportType); oDq.AddIntegerParam("@UserId", userId); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { ICallDetail callDetail = new CallDetailEntity(); callDetail.LocationName = Convert.ToString(reader["LocName"]); callDetail.ProspectFor = Convert.ToString(reader["ProspectName"]); callDetail.GroupCompanyName = Convert.ToString(reader["GroupName"]); callDetail.Destination = Convert.ToString(reader["Destination"]); callDetail.SalesPersonName = Convert.ToString(reader["SalesPerson"]); callDetail.TEU = Convert.ToInt32(reader["TEU"]); callDetail.FEU = Convert.ToInt32(reader["FEU"]); callDetail.Total = Convert.ToInt32(reader["Total"]); lstCallDetail.Add(callDetail); } reader.Close(); } return(lstCallDetail); }