public string getDataForPaiChart(int cmpnId)
{
try
{
string json = "";
cmpnObj.campaignId = cmpnId.ToString();
DataTable dtTemp = cmpnObj.getCampaignDetailsForView();
DataTable dtCmpnReport = new DataTable();
string qry = "";
int cnt = 1;
for (int i = 3; i < dtTemp.Columns.Count; i++)
{
if (dtTemp.Rows[0][i].ToString() != "")
{
if (i == 3)
{
qry += string.Format(@"select count(case when digit={0} then 1 end)y ,Option{0} label
from campaignmaster cm, campaignReports cp where cm.campaignId=cp.campaignId and cm.campaignId={1}", cnt, cmpnId);
}
else
{
qry += string.Format(@" union select count(case when digit={0} then 1 end)y ,Option{0} label
from campaignmaster cm, campaignReports cp where cm.campaignId=cp.campaignId and cm.campaignId={1}", cnt, cmpnId);
}
}
cnt++;
}
if (dtTemp.Columns.Count > 0)
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText = qry;
dtCmpnReport = dalObj.getSelectDataByInlineQuery(cmd, out errMsg);
}
}
if (dtCmpnReport.Rows.Count > 0)
{
json = JsonConvert.SerializeObject(dtCmpnReport, Newtonsoft.Json.Formatting.Indented);
return(json);
}
else
{
return(json);
}
}
catch (Exception)
{
return("");
}
}
protected void btnViewCampaign_Click(object sender, EventArgs e)
{
try
{
LinkButton btnViewCampaign = (LinkButton)sender;
cmpinObj.campaignId = btnViewCampaign.CommandArgument;
div1.Visible = false;
div2.Visible = true;
cmpinObj.campaignId = btnViewCampaign.CommandArgument;
DataTable dtTemp = cmpinObj.getCampaignDetailsForView();
if (dtTemp.Rows.Count > 0)
{
rptCamDetailsView.DataSource = dtTemp;
rptCamDetailsView.DataBind();
}
else
{
rptCampaignView.DataSource = null;
rptCampaignView.DataBind();
}
}
catch (Exception ex)
{
throw;
}
}
