private void GetReport()
{
try
{
DataTable dtgetreport = new DataTable();
dtgetreport = objBL_Common.campaignreport(Convert.ToInt32(Request.QueryString["CamprptId"].ToString()));
if (dtgetreport.Rows.Count > 0)
{
lblCampname.Text = dtgetreport.Rows[0].Field <string>("CampaignName").ToString();
lblRecipients.Text = dtgetreport.Rows[0].Field <int>("Recipients").ToString();
lblfromname.Text = dtgetreport.Rows[0].Field <string>("FromName").ToString();
lblSubject.Text = dtgetreport.Rows[0].Field <string>("Title").ToString();
lblDelivered.Text = dtgetreport.Rows[0].Field <DateTime>("SchduleDateTime").ToString();
lblSent.Text = dtgetreport.Rows[0].Field <int>("MailSent").ToString();
lblClick.Text = dtgetreport.Rows[0].Field <int>("IsRead").ToString();
lblbounced.Text = (dtgetreport.Rows[0].Field <int>("softbounce") + dtgetreport.Rows[0].Field <int>("hardbounce")).ToString();
lblsoftbounce.Text = dtgetreport.Rows[0].Field <int>("softbounce").ToString();
lblhardbounce.Text = dtgetreport.Rows[0].Field <int>("hardbounce").ToString();
lbltotalsentmail.Text = dtgetreport.Rows[0].Field <int>("MailSent").ToString();
int mailpercent = (((dtgetreport.Rows[0].Field <int>("MailSent") - Convert.ToInt32(lblbounced.Text)) / dtgetreport.Rows[0].Field <int>("MailSent")) * 100);
int openpercent = ((dtgetreport.Rows[0].Field <int>("IsRead") / dtgetreport.Rows[0].Field <int>("MailSent")) * 100);
lbltotalsentmailpercent.Text = mailpercent.ToString() + "%";
lblopenrate.Text = dtgetreport.Rows[0].Field <int>("IsRead").ToString();
lblopenratepercent.Text = openpercent.ToString() + "%";
lblsuccdeliver.Text = (dtgetreport.Rows[0].Field <int>("MailSent") - Convert.ToInt32(lblbounced.Text)).ToString();
lbltotopens.Text = dtgetreport.Rows[0].Field <int>("TotalReadCount").ToString();
lblnotopen.Text = ((dtgetreport.Rows[0].Field <int>("MailSent") - dtgetreport.Rows[0].Field <int>("IsRead")) - Convert.ToInt32(lblbounced.Text)).ToString();
lbltotclicks.Text = dtgetreport.Rows[0].Field <int>("IsRead").ToString();
spdelrate.Style["width"] = mailpercent + "%";
spopenrate.Style["width"] = openpercent + "%";
//ScriptManager.RegisterStartupScript(this, Page.GetType(), "mykey36", "chartmake();", true);//reportchart('35','35','30')
}
}
catch (Exception ex)
{
New_EmailCampaign.App_Code.GlobalFunction.StoreLog("CampaignReport.aspx:GetReport() - " + ex.Message);
}
}