protected void gridFabStatus_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { if (e.Item is GridDataItem) { GridDataItem item = (GridDataItem)e.Item; for (int i = 0; i < item.Cells.Count; i++) { item.Cells[i].Text = item.Cells[i].Text.ToString(CultureInfo.InvariantCulture.NumberFormat); } double total_scope = Convert.ToDouble(item.Cells[2].Text); double sg_done = Convert.ToDouble(item.Cells[3].Text); double mat_avl = Convert.ToDouble(item.Cells[4].Text); double jc_issued = Convert.ToDouble(item.Cells[5].Text); double weld_done = Convert.ToDouble(item.Cells[6].Text); double nde_done = Convert.ToDouble(item.Cells[7].Text); double spl_paint = Convert.ToDouble(item.Cells[8].Text); double sent_to_site = Convert.ToDouble(item.Cells[9].Text); var sg_dt = new DataTable(); sg_dt.Columns.Add("SCOPE_TEXT"); sg_dt.Columns.Add("SCOPE_VALUE"); sg_dt.Columns.Add("COLOR_CODE"); sg_dt.Rows.Add("SPOOLGEN PROGRESS", Math.Round(sg_done * 100 / total_scope, 1), "#4DCA5E"); sg_dt.Rows.Add("BALANCE", Math.Round(100 - Math.Round(sg_done * 100 / total_scope, 1), 1), "#D6D6D6"); RadHtmlChart2.DataSource = sg_dt; RadHtmlChart2.DataBind(); sg_dt = new DataTable(); sg_dt.Columns.Add("SCOPE_TEXT"); sg_dt.Columns.Add("SCOPE_VALUE"); sg_dt.Columns.Add("COLOR_CODE"); sg_dt.Rows.Add("SPOOLGEN PROGRESS", Math.Round(mat_avl * 100 / total_scope, 1), "#4DCA5E"); sg_dt.Rows.Add("BALANCE", Math.Round(100 - Math.Round(mat_avl * 100 / total_scope, 1), 1), "#D6D6D6"); RadHtmlChart3.DataSource = sg_dt; RadHtmlChart3.DataBind(); sg_dt = new DataTable(); sg_dt.Columns.Add("SCOPE_TEXT"); sg_dt.Columns.Add("SCOPE_VALUE"); sg_dt.Columns.Add("COLOR_CODE"); sg_dt.Rows.Add("SPOOLGEN PROGRESS", Math.Round(jc_issued * 100 / total_scope, 1), "#4DCA5E"); sg_dt.Rows.Add("BALANCE", Math.Round(100 - Math.Round(jc_issued * 100 / total_scope, 1), 1), "#D6D6D6"); RadHtmlChart4.DataSource = sg_dt; RadHtmlChart4.DataBind(); sg_dt = new DataTable(); sg_dt.Columns.Add("SCOPE_TEXT"); sg_dt.Columns.Add("SCOPE_VALUE"); sg_dt.Columns.Add("COLOR_CODE"); sg_dt.Rows.Add("SPOOLGEN PROGRESS", Math.Round(weld_done * 100 / total_scope, 1), "#4DCA5E"); sg_dt.Rows.Add("BALANCE", Math.Round(100 - Math.Round(weld_done * 100 / total_scope, 1), 1), "#D6D6D6"); RadHtmlChart5.DataSource = sg_dt; RadHtmlChart5.DataBind(); sg_dt = new DataTable(); sg_dt.Columns.Add("SCOPE_TEXT"); sg_dt.Columns.Add("SCOPE_VALUE"); sg_dt.Columns.Add("COLOR_CODE"); sg_dt.Rows.Add("SPOOLGEN PROGRESS", Math.Round(nde_done * 100 / total_scope, 1), "#4DCA5E"); sg_dt.Rows.Add("BALANCE", Math.Round(100 - Math.Round(nde_done * 100 / total_scope, 1), 1), "#D6D6D6"); RadHtmlChart6.DataSource = sg_dt; RadHtmlChart6.DataBind(); sg_dt = new DataTable(); sg_dt.Columns.Add("SCOPE_TEXT"); sg_dt.Columns.Add("SCOPE_VALUE"); sg_dt.Columns.Add("COLOR_CODE"); sg_dt.Rows.Add("SPOOLGEN PROGRESS", Math.Round(spl_paint * 100 / total_scope, 1), "#4DCA5E"); sg_dt.Rows.Add("BALANCE", Math.Round(100 - Math.Round(spl_paint * 100 / total_scope, 1), 1), "#D6D6D6"); RadHtmlChart7.DataSource = sg_dt; RadHtmlChart7.DataBind(); sg_dt = new DataTable(); sg_dt.Columns.Add("SCOPE_TEXT"); sg_dt.Columns.Add("SCOPE_VALUE"); sg_dt.Columns.Add("COLOR_CODE"); sg_dt.Rows.Add("SPOOLGEN PROGRESS", Math.Round(sent_to_site * 100 / total_scope, 1), "#4DCA5E"); sg_dt.Rows.Add("BALANCE", Math.Round(100 - Math.Round(sent_to_site * 100 / total_scope, 1), 1), "#D6D6D6"); RadHtmlChart8.DataSource = sg_dt; RadHtmlChart8.DataBind(); } }
protected void ddlSubcon_SelectedIndexChanged(object sender, DropDownListEventArgs e) { lablesc.Text = ddlSubcon.SelectedText; if (ddlSubcon.SelectedText == "ICAD") { SpoolgenGrid.DataSourceID = null; FabProgressGrid.DataSourceID = null; SpoolgenGrid.DataSourceID = "ICADspgnTableDataSrouce"; FabProgressGrid.DataSourceID = "ICADfabTableDataSource"; } if (ddlSubcon.SelectedText == "EPIC") { SpoolgenGrid.DataSourceID = null; FabProgressGrid.DataSourceID = null; SpoolgenGrid.DataSourceID = "EPICspgnTableDataSrouce"; FabProgressGrid.DataSourceID = "EPICfabTableDataSource"; } if (ddlSubcon.SelectedText == "DIVISION-7") { SpoolgenGrid.DataSourceID = null; FabProgressGrid.DataSourceID = null; SpoolgenGrid.DataSourceID = "D7spgnTableDataSrouce"; FabProgressGrid.DataSourceID = "D7fabTableDataSource"; } if (ddlSubcon.SelectedText == "PENTA GLOBAL") { SpoolgenGrid.DataSourceID = null; FabProgressGrid.DataSourceID = null; SpoolgenGrid.DataSourceID = "PentaspgnTableDataSrouce"; FabProgressGrid.DataSourceID = "PentafabTableDataSource"; } if (ddlSubcon.SelectedText == "STS") { SpoolgenGrid.DataSourceID = null; FabProgressGrid.DataSourceID = null; SpoolgenGrid.DataSourceID = "STSspgnTableDataSrouce"; FabProgressGrid.DataSourceID = "STSfabTableDataSource"; } if (ddlSubcon.SelectedText == "DYCC-7") { SpoolgenGrid.DataSourceID = null; FabProgressGrid.DataSourceID = null; SpoolgenGrid.DataSourceID = "DYCC7spgnTableDataSrouce"; FabProgressGrid.DataSourceID = "DYCC7fabTableDataSource"; } RadHtmlChart10.DataSourceID = "SplSGPrgsVsActualDataSource"; RadHtmlChart100.DataSourceID = "DWGProgressDataSource"; RadHtmlChart101.DataSourceID = "PIPDeliveryDataSource"; RadHtmlChart5.DataSourceID = "FLANGEDeliveryDataSource"; RadHtmlChart6.DataSourceID = "FITTINGDeliveryDataSource"; RadHtmlChart7.DataSourceID = "AvlWorkFrontDataSource"; RadHtmlChart8.DataSourceID = "CurrentWorkDataSource"; RadHtmlChart9.DataSourceID = "SplFabPrgsVsActualDataSource"; RadHtmlChart10.DataBind(); RadHtmlChart100.DataBind(); SpoolgenGrid.Rebind(); RadHtmlChart101.DataBind(); RadHtmlChart5.DataBind(); RadHtmlChart6.DataBind(); RadHtmlChart7.DataBind(); RadHtmlChart8.DataBind(); RadHtmlChart9.DataBind(); FabProgressGrid.Rebind(); }