public string CreateChart1()
{
_fmsgrph.UserDistrictId = Convert.ToInt32(Session["UserdistrictId"].ToString());
var ds = _fmsgrph.GetSCAlert();
var strXml = "";
strXml += "<graph caption='Vehicle Expiry Alert ' YAxisName='No. of Vehicles' numDivLines='6' formatNumberScale='0' decimalPrecision='0' anchorSides='10' anchorRadius='3' anchorBorderColor='009900' rotateNames='1' animation='1' yAxisMinValue='0'>";
strXml += "<categories>";
strXml += "<category name='Vehicle Insurance' /> ";
strXml += "<category name='Road Tax' /> ";
strXml += "<category name='Pollution Under Control' /> ";
strXml += "<category name='Fitness Renewal' /> ";
strXml += "</categories>";
strXml += "<dataset seriesName='No. of Expired Vehicles' color='FE2E2E' showValues='1'>";
foreach (DataRow dr in ds.Tables[0].Rows)
{
strXml += " <set value='" + dr[0] + "' color='' link='FMSGeneralAlert.aspx?alert=VI'/>";
strXml += " <set value='" + dr[2] + "' color='' link='FMSGeneralAlert.aspx?alert=RT'/>";
strXml += " <set value='" + dr[4] + "' color='' link='FMSGeneralAlert.aspx?alert=PUC'/>";
strXml += " <set value='" + dr[6] + "' color='' link='FMSGeneralAlert.aspx?alert=FR'/>";
}
strXml += " </dataset>";
strXml += "<dataset seriesName='No. of Vehicles to be Expired within 1 Month' color='2E9AFE' showValues='1'>";
foreach (DataRow dr in ds.Tables[0].Rows)
{
strXml += " <set value='" + dr[1] + "' color='' link='FMSGeneralAlert.aspx?alert=VIMonth'/>";
strXml += " <set value='" + dr[3] + "' color='' link='FMSGeneralAlert.aspx?alert=RTMonth'/>";
strXml += " <set value='" + dr[5] + "' color='' link='FMSGeneralAlert.aspx?alert=PUCMonth'/>";
strXml += " <set value='" + dr[7] + "' color='' link='FMSGeneralAlert.aspx?alert=FRMonth'/>";
}
strXml += " </dataset>";
strXml += "</graph>";
return(FusionCharts.RenderChartHTML("FusionCharts/FCF_MSColumn3D.swf", "", strXml, "myNext", "560", "400", false));
}