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);
}
