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