public void getTopTenCampaignsByOpenRateData() { try { CampaignJobs objCampaignJob = CampaignJob.SelectAll(ConnectionString); //get campaigns whose sent count is greater than 20. List<CampaignJob> campaignJobs = (List<CampaignJob>)objCampaignJob.ToList().FindAll(delegate(CampaignJob job) { return job.DeliveredCount > 20; }); List<string> xValues = new List<string>(); List<string> yValues = new List<string>(); foreach (CampaignJob job in campaignJobs) { //get names of campaigns. CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(job.CampaignMasterID)); CampaignMaster objCampaignMaster = CampaignMaster.SelectOne(pk, ConnectionString); yValues.Add(objCampaignMaster.CampaignName); //Calculate openrate of campaigns //get sum of opencount of all jobs in this month. int opencount = Convert.ToInt32(campaignJobs.Sum(delegate(CampaignJob campjob) { return campjob.OpenCount; })); //get sum of sentcount of all jobs in this month. int sentcount = Convert.ToInt32(campaignJobs.Sum(delegate(CampaignJob campjob) { return campjob.DeliveredCount; })); //Calculate openrate for that particular month. if (sentcount != 0) { xValues.Add(Convert.ToString(Convert.ToDecimal(opencount) / Convert.ToDecimal(sentcount) * 100)); } showChartTopTenCampaignsByOpenRate(xValues.ToArray(), yValues.ToArray()); } } catch (Exception ex) { throw ex; } }
public void getRecipientStatusSnapshotData() { try { List<string> xValues = new List<string>(); List<decimal> yValues = new List<decimal>(); ContactMasters objContactMaster;// = ContactMaster.SelectAll(ConnectionString); if (ddlDays.SelectedIndex == 0) { objContactMaster = ContactMaster.SelectAllByToday(ConnectionString); lblFromDate.Text = DateTime.Now.ToString("dd/MM/yyyy"); lblToDate.Text = " - " + DateTime.Now.ToString("dd/MM/yyyy"); } else if (ddlDays.SelectedIndex > 0 && ddlDays.SelectedIndex < 4) { objContactMaster = ContactMaster.SelectAllByDays(Convert.ToInt32(ddlDays.SelectedValue), ConnectionString); lblFromDate.Text = DateTime.Now.AddDays(Convert.ToDouble(ddlDays.SelectedValue)).ToString("dd/MM/yyyy"); lblToDate.Text = " - " + DateTime.Now.Date.AddDays(-1).ToString("dd/MM/yyyy"); } else if (ddlDays.SelectedIndex == 4) { objContactMaster = ContactMaster.SelectAllByWeek(ConnectionString, ref fdate, ref tdate); lblFromDate.Text = fdate.ToString("dd/MM/yyyy"); lblToDate.Text = " - " + tdate.ToString("dd/MM/yyyy"); } else { objContactMaster = ContactMaster.SelectAllByMonths(DateTime.Now.AddMonths(Convert.ToInt32(ddlDays.SelectedValue)), DateTime.Now.AddMonths(-1), ConnectionString); arDates = new ArrayList(); arDates = FirstAndLastdates(Convert.ToInt32(ddlDays.SelectedValue)); lblFromDate.Text = Convert.ToDateTime(arDates[0]).ToString("dd/MM/yyyy"); lblToDate.Text = " - " + Convert.ToDateTime(arDates[1]).ToString("dd/MM/yyyy"); } //get active contacts. IEnumerable<ContactMaster> activeContacts = (IEnumerable<ContactMaster>)objContactMaster.ToList().FindAll(delegate(ContactMaster contact) { return contact.IsActive == true; }); xValues.Add("Active"); yValues.Add(activeContacts.Count()); //if (objContactMaster.Count() != 0) //yValues.Add(Convert.ToDecimal(activeContacts.Count()) / Convert.ToDecimal(objContactMaster.Count()) * 100); //else // yValues.Add(0); //get inactive contacts. IEnumerable<ContactMaster> inactiveContacts = (IEnumerable<ContactMaster>)objContactMaster.ToList().FindAll(delegate(ContactMaster contact) { return contact.IsActive == false && (contact.IsDeleted == false || contact.IsDeleted == null); }); xValues.Add("InActive"); yValues.Add(inactiveContacts.Count()); //get deleted contacts ContactDeleteds objContactsDeleted;// = ContactDeleted.SelectAll(ConnectionString); if (ddlDays.SelectedIndex == 0) { objContactsDeleted = ContactDeleted.SelectAllByToday(ConnectionString); } else if (ddlDays.SelectedIndex>0 && ddlDays.SelectedIndex < 4) objContactsDeleted = ContactDeleted.SelectAllByDays(Convert.ToInt32(ddlDays.SelectedValue), ConnectionString); else if (ddlDays.SelectedIndex == 4) objContactsDeleted = ContactDeleted.SelectAllByWeek(ConnectionString, ref fdate, ref tdate); else objContactsDeleted = ContactDeleted.SelectAllByMonths(DateTime.Now.AddMonths(Convert.ToInt32(ddlDays.SelectedValue)), DateTime.Now.AddMonths(-1), ConnectionString); xValues.Add("Deleted Contacts"); yValues.Add(objContactsDeleted.Count()); //get unverified contacts IEnumerable<ContactMaster> unverifiedContacts = (IEnumerable<ContactMaster>)objContactMaster.ToList().FindAll(delegate(ContactMaster contact) { return contact.IsVerified != true && contact.IsDeleted != true; }); xValues.Add("UnVerified Contacts"); yValues.Add(unverifiedContacts.Count()); //get inactive and unverified contacts. IEnumerable<ContactMaster> inactiveandunverifiedContacts = (IEnumerable<ContactMaster>)objContactMaster.ToList().FindAll(delegate(ContactMaster contact) { return contact.IsActive == false && contact.IsVerified != true && contact.IsDeleted != true; }); xValues.Add("InActive and UnVerified Contacts"); yValues.Add(inactiveandunverifiedContacts.Count()); //Show chart. showChartRecipientStatusSnapshot(xValues.ToArray(), yValues.ToArray()); } catch (Exception ex) { throw ex; } }
public void getTopTenCampaignsByOpenRateData() { try { CampaignJobs objCampaignJob;// = CampaignJob.SelectAll(ConnectionString); if (ddlDays.SelectedIndex == 0) { objCampaignJob = CampaignJob.SelectAllByToday(ConnectionString); lblFromDate.Text =DateTime.Now.ToString("dd/MM/yyyy"); lblToDate.Text = " - " + DateTime.Now.ToString("dd/MM/yyyy"); } else if (ddlDays.SelectedIndex > 0 && ddlDays.SelectedIndex < 4) { objCampaignJob = CampaignJob.SelectAllByDays(Convert.ToInt32(ddlDays.SelectedValue), ConnectionString); lblFromDate.Text = DateTime.Now.AddDays(Convert.ToDouble(ddlDays.SelectedValue)).ToString("dd/MM/yyyy"); //lblToDate.Text = " - " + DateTime.Now.ToString("dd/MM/yyyy"); lblToDate.Text = " - " + DateTime.Now.Date.AddDays(-1).ToString("dd/MM/yyyy"); } else if (ddlDays.SelectedIndex == 4) { objCampaignJob = CampaignJob.SelectAllByWeek(ConnectionString, ref fdate, ref tdate); lblFromDate.Text = fdate.ToString("dd/MM/yyyy"); lblToDate.Text = " - " + tdate.ToString("dd/MM/yyyy"); } else { objCampaignJob = CampaignJob.SelectAllByMonths(DateTime.Now.AddMonths(Convert.ToInt32(ddlDays.SelectedValue)), DateTime.Now.AddMonths(-1), ConnectionString); arDates = new ArrayList(); arDates = FirstAndLastdates(Convert.ToInt32(ddlDays.SelectedValue)); lblFromDate.Text = Convert.ToDateTime(arDates[0]).ToString("dd/MM/yyyy"); lblToDate.Text = " - " + Convert.ToDateTime(arDates[1]).ToString("dd/MM/yyyy"); } //get top 10 campaigns whose sent count is greater than 20 and in order by descending. IEnumerable<CampaignJob> campaignJobs = (IEnumerable<CampaignJob>)(objCampaignJob.ToList().FindAll(delegate(CampaignJob job) { return job.DeliveredCount > 0; }).OrderByDescending(delegate(CampaignJob job) { return job.DeliveredCount; })).Take(10); List<string> xValues = new List<string>(); List<decimal> yValues = new List<decimal>(); foreach (CampaignJob job in campaignJobs) { //get names of campaigns. CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(job.CampaignMasterID)); CampaignMaster objCampaignMaster = CampaignMaster.SelectOne(pk, ConnectionString); xValues.Add(objCampaignMaster.CampaignName); //Calculate openrate of campaigns //get sum of opencount of all jobs in this month. int opencount = Convert.ToInt32(job.OpenCount); //get sum of sentcount of all jobs in this month. int sentcount = Convert.ToInt32(job.DeliveredCount); //Calculate openrate for that particular month. if (sentcount != 0) { yValues.Add(Convert.ToDecimal(opencount) / Convert.ToDecimal(sentcount) * 100); } } //Show chart. showChartTopTenCampaignsByOpenRate(xValues.ToArray(), yValues.ToArray()); } catch (Exception ex) { throw ex; } }
public void getCampaignCompareCounts() { DataTable CampareDt = (DataTable)ViewState["CampareDt"]; List<string> xValues = new List<string>(); List<decimal> yValuesFirstCamp = new List<decimal>(); List<decimal> yValuesSecCamp = new List<decimal>(); List<decimal> yValuesThirdCamp = new List<decimal>(); for (int i = 0; i < CampareDt.Rows.Count; i++) { xValues.Add(CampareDt.Rows[i][0].ToString()); yValuesFirstCamp.Add(Convert.ToDecimal(CampareDt.Rows[i][1].ToString().Split('(')[0])); yValuesSecCamp.Add(Convert.ToDecimal(CampareDt.Rows[i][2].ToString().Split('(')[0])); if (CampareDt.Columns.Count == 4) yValuesThirdCamp.Add(Convert.ToDecimal(CampareDt.Rows[i][3].ToString().Split('(')[0])); } showCampaignCampareChart(CampareDt, xValues.ToArray(), yValuesFirstCamp.ToArray(), yValuesSecCamp.ToArray(), yValuesThirdCamp.ToArray()); }
//Vikas Kumar Bhatnagar public void getListHealthOverLast12MonthsDomainData() { try { IEnumerable<CampaignJob> campaignJobs; CampaignJobs objCampaignJob;// = CampaignJob.SelectAll(ConnectionString); if (ddlDays.SelectedIndex == 0) { objCampaignJob = CampaignJob.SelectAllDomianByToday(ConnectionString); lblFromDate.Text =DateTime.Now.ToString("dd/MM/yyyy"); lblToDate.Text = " - " + DateTime.Now.ToString("dd/MM/yyyy"); } else if (ddlDays.SelectedIndex == 3) { objCampaignJob = CampaignJob.SelectAllDomianLast90Days(ConnectionString); lblFromDate.Text = DateTime.Now.AddDays(Convert.ToDouble(ddlDays.SelectedValue)).ToString("dd/MM/yyyy"); //lblToDate.Text = " - " + DateTime.Now.ToString("dd/MM/yyyy"); lblToDate.Text = " - " + DateTime.Now.Date.AddDays(-1).ToString("dd/MM/yyyy"); } else if (ddlDays.SelectedIndex == 4) { objCampaignJob = CampaignJob.SelectAllDomianByWeek(ConnectionString, ref fdate, ref tdate); lblFromDate.Text = fdate.ToString("dd/MM/yyyy"); lblToDate.Text = " - " + tdate.ToString("dd/MM/yyyy"); } else if (ddlDays.SelectedIndex == 1) { objCampaignJob = CampaignJob.SelectAllDomianByWeek(ConnectionString, ref fdate, ref tdate); } else if (ddlDays.SelectedIndex == 6) { objCampaignJob = CampaignJob.SelectAllDomianLast90Days(ConnectionString); } else { objCampaignJob = CampaignJob.SelectAllDomianByMonth(ConnectionString); arDates = new ArrayList(); arDates = FirstAndLastdates(Convert.ToInt32(ddlDays.SelectedValue)); //lblFromDate.Text = "Current View : " + Convert.ToDateTime(arDates[0]).ToString("dd/MM/yyyy"); //lblToDate.Text = " - " + Convert.ToDateTime(arDates[1]).ToString("dd/MM/yyyy"); } //CampaignJobs objCampaignJob = CampaignJob.SelectAllDomianLast12Months(ConnectionString); //calculate last 12 month names to show on X-axis List<string> xValues = new List<string>(); List<decimal> yValues = new List<decimal>(); foreach (CampaignJob job in objCampaignJob) { //get names of campaigns. //CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(job.CampaignMasterID)); //CampaignMaster objCampaignMaster = CampaignMaster.SelectOne(pk, ConnectionString); xValues.Add(job.Domain); yValues.Add(Convert.ToDecimal(job.Accepted)); } //Show chart. showChartTopTenCampaignsByBounceRate2(xValues.ToArray(), yValues.ToArray()); } catch (Exception ex) { throw ex; } }
public void getGraphByCampaignId() { try { lblSubtitle1.Text = ddlcampaigns.SelectedItem.Text + " Campaign Report"; List<string> xValues = new List<string>(); List<decimal> yValuesSentCount = new List<decimal>(); List<decimal> yValuesOpenCount = new List<decimal>(); List<decimal> yValuesOpenCountChart = new List<decimal>(); List<decimal> yValuesClickCountChart = new List<decimal>(); CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(ddlcampaigns.SelectedValue)); CampaignMaster objCampaignMaster = CampaignMaster.SelectOne(pk, ConnectionString); CampaignJobPrimaryKey Camppk = new CampaignJobPrimaryKey(Convert.ToInt64(ddlcampaigns.SelectedValue)); //CampaignJob objCampaignJob = CampaignJob.SelectOne(Camppk, ConnectionString); CampaignJobs objCampaignJob = CampaignJob.SelectByField("CampaignMasterID", ddlcampaigns.SelectedValue.ToString(), ConnectionString); int opencount = 0; int sentcount = 0; int clickcount = 0; foreach (CampaignJob job in objCampaignJob) { //Calculate LastTopTenCampaignsSent //get sum of opencount of all jobs in this month. opencount = (job.OpenCount != null) ? Convert.ToInt32(job.OpenCount.ToString()) : 0; //opencount = Convert.ToInt32(job.OpenCount.ToString()); //get sum of sentcount of all jobs in this month. sentcount = (job.DeliveredCount != null) ? Convert.ToInt32(job.OpenCount.ToString()) : 0;//Convert.ToInt32(job.DeliveredCount.ToString()); //get sum of sentcount of all jobs in this month. clickcount = (job.ClickCount != null) ? Convert.ToInt32(job.OpenCount.ToString()) : 0;//Convert.ToInt32(job.ClickCount); } xValues.Add(objCampaignMaster.CampaignName); yValuesSentCount.Add(Convert.ToDecimal(sentcount)); yValuesOpenCount.Add(Convert.ToDecimal(opencount)); //this is to bind the open count chart if (sentcount > 0) { yValuesOpenCountChart.Add(Convert.ToDecimal(opencount) / Convert.ToDecimal(sentcount) * 100); } else { yValuesOpenCountChart.Add(0); } //Calculate click for that particular month. if (opencount != 0) { yValuesClickCountChart.Add(Convert.ToDecimal(clickcount) / Convert.ToDecimal(opencount) * 100); } else { yValuesClickCountChart.Add(0); } //Show chart for sent and open count showChartLastTopTenCampaignsSent(xValues.ToArray(), yValuesSentCount.ToArray(), yValuesOpenCount.ToArray()); //Show chart for open count showChartTopTenCampaignsByOpenRate(xValues.ToArray(), yValuesOpenCountChart.ToArray()); //Show chart for click count showChartTopTenCampaignsByClickRate(xValues.ToArray(), yValuesClickCountChart.ToArray()); } catch (Exception ex) { } }
public void getLastTopTenCampaignsSentData() { CampaignJobs objCampaignJob; try { DataTable campaignjobreport = CampaignJob.GetTop5CampaignJobs(4, ConnectionString); if (ddlDays.SelectedIndex == 0) { campaignjobreport = CampaignJob.GetCampaignNamesByDays(1, 1, ConnectionString); } else if (ddlDays.SelectedIndex == 1) { campaignjobreport = CampaignJob.GetCampaignNamesByDays(7, 0, ConnectionString); } else if (ddlDays.SelectedIndex == 2) { campaignjobreport = CampaignJob.GetCampaignNamesByDays(30, 0, ConnectionString); } else if (ddlDays.SelectedIndex == 3) { campaignjobreport = CampaignJob.GetCampaignNamesByDays(90, 0, ConnectionString); } ddlcampaigns.DataSource = campaignjobreport; ddlcampaigns.DataTextField = "CampaignName"; ddlcampaigns.DataValueField = "Id"; ddlcampaigns.DataBind(); if (campaignjobreport.Rows.Count > 0) { if (ddlcampaigns.SelectedIndex != 5) { objCampaignJob = SingleCampaignReports(); lblSubtitle1.Text = ddlcampaigns.SelectedItem.Text + " Campaign Report"; } else { objCampaignJob = AllCampaignReport(); lblSubtitle1.Text = "Last Top 10 Campaigns report"; } //get top 10 campaigns whose sent count is greater than 20 and in order by descending. //IEnumerable<CampaignJob> campaignJobs = (IEnumerable<CampaignJob>)(objCampaignJob.ToList().FindAll(delegate(CampaignJob job) { return job.DeliveredCount > 0; }).OrderByDescending(delegate(CampaignJob job) { return job.DeliveredCount; })).Take(10); IEnumerable<CampaignJob> campaignJobs = (IEnumerable<CampaignJob>)(objCampaignJob.ToList().FindAll(delegate(CampaignJob job) { return job.Status == 4; })); List<string> xValues = new List<string>(); List<decimal> yValuesSentCount = new List<decimal>(); List<decimal> yValuesOpenCount = new List<decimal>(); List<decimal> yValuesOpenCountChart = new List<decimal>(); List<decimal> yValuesClickCountChart = new List<decimal>(); if (campaignJobs != null) { foreach (CampaignJob job in campaignJobs) { //get names of campaigns. CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(job.CampaignMasterID)); CampaignMaster objCampaignMaster = CampaignMaster.SelectOne(pk, ConnectionString); xValues.Add(objCampaignMaster.CampaignName); //Calculate LastTopTenCampaignsSent //get sum of opencount of all jobs in this month. int opencount = Convert.ToInt32(job.OpenCount); //get sum of sentcount of all jobs in this month. int sentcount = Convert.ToInt32(job.DeliveredCount); //get sum of sentcount of all jobs in this month. int clickcount = Convert.ToInt32(job.ClickCount); yValuesSentCount.Add(Convert.ToDecimal(sentcount)); yValuesOpenCount.Add(Convert.ToDecimal(opencount)); //this is to bind the open count chart if (sentcount > 0) { yValuesOpenCountChart.Add(Convert.ToDecimal(opencount) / Convert.ToDecimal(sentcount) * 100); } else { yValuesOpenCountChart.Add(0); } //Calculate click for that particular month. if (opencount != 0) { yValuesClickCountChart.Add(Convert.ToDecimal(clickcount) / Convert.ToDecimal(opencount) * 100); } else { yValuesClickCountChart.Add(0); } } } //Show chart for sent and open count showChartLastTopTenCampaignsSent(xValues.ToArray(), yValuesSentCount.ToArray(), yValuesOpenCount.ToArray()); //Show chart for open count showChartTopTenCampaignsByOpenRate(xValues.ToArray(), yValuesOpenCountChart.ToArray()); //Show chart for click count showChartTopTenCampaignsByClickRate(xValues.ToArray(), yValuesClickCountChart.ToArray()); } } catch (Exception ex) { throw ex; } }
/// <summary> /// To get the top 10 campaigns /// </summary> public void getLastTopTenCampaignsSentData() { CampaignJobs campaignJobs = CampaignJob.SelectTop10SentCamps(ConnectionString); List<string> xValues = new List<string>(); List<Int32> yValuesSentCount = new List<Int32>(); List<Int32> yValuesOpenCount = new List<Int32>(); foreach (CampaignJob job in campaignJobs) { //get names of campaigns. CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(job.CampaignMasterID)); CampaignMaster objCampaignMaster = CampaignMaster.SelectOne(pk, ConnectionString); int opencount = 0, sentcount = 0; //Calculate LastTopTenCampaignsSent //get sum of opencount of all jobs in this month. opencount = Convert.ToInt32(job.OpenCount); //get sum of sentcount of all jobs in this month. sentcount = Convert.ToInt32(job.DeliveredCount); //Calculate openrate for that particular month. // for restricting the campaignjobs whcich have the sent count as zero if (sentcount != 0) { xValues.Add(objCampaignMaster.CampaignName); yValuesSentCount.Add(Convert.ToInt32(sentcount)); yValuesOpenCount.Add(Convert.ToInt32(opencount)); } } //Show chart. showChartLastTopTenCampaignsSent(xValues.ToArray(), yValuesSentCount.ToArray(), yValuesOpenCount.ToArray()); }
public void getTopTenCampaignsByClickRateData() { try { CampaignJobs objCampaignJob;// = CampaignJob.SelectAll(ConnectionString); //if (ddlDays.SelectedIndex == 0) // objCampaignJob = CampaignJob.SelectAll(ConnectionString); if (ddlDays.SelectedIndex < 3) objCampaignJob = CampaignJob.SelectAllByDays(Convert.ToInt32(ddlDays.SelectedValue), ConnectionString); else if (ddlDays.SelectedIndex == 3) objCampaignJob = CampaignJob.SelectAllByWeek(ConnectionString, ref fdate, ref tdate); else objCampaignJob = CampaignJob.SelectAllByMonths(DateTime.Now.AddMonths(Convert.ToInt32(ddlDays.SelectedValue)), DateTime.Now.AddMonths(-1), ConnectionString); //get top 10 campaigns whose sent count is greater than 20 and in order by descending. //IEnumerable<CampaignJob> campaignJobs = (IEnumerable<CampaignJob>)(objCampaignJob.ToList().FindAll(delegate(CampaignJob job) { return job.DeliveredCount > 20; }).OrderByDescending(delegate(CampaignJob job) { return job.DeliveredCount; })).Take(12); IEnumerable<CampaignJob> campaignJobs = (IEnumerable<CampaignJob>)(objCampaignJob.ToList().FindAll(delegate(CampaignJob job) { return job.Status == 4; })); List<string> xValues = new List<string>(); List<decimal> yValues = new List<decimal>(); foreach (CampaignJob job in campaignJobs) { //get names of campaigns. CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(job.CampaignMasterID)); CampaignMaster objCampaignMaster = CampaignMaster.SelectOne(pk, ConnectionString); xValues.Add(objCampaignMaster.CampaignName); //Calculate openrate of campaigns //get sum of opencount of all jobs in this month. int opencount = Convert.ToInt32(job.OpenCount); //get sum of sentcount of all jobs in this month. int clickcount = Convert.ToInt32(job.ClickCount); //Calculate openrate for that particular month. if (opencount != 0) { yValues.Add(Convert.ToDecimal(clickcount) / Convert.ToDecimal(opencount) * 100); } else { yValues.Add(0); } } //Show chart. showChartTopTenCampaignsByClickRate(xValues.ToArray(), yValues.ToArray()); } catch (Exception ex) { throw ex; } }