public void FillVehicleDashboard()
{
try
{
pnl_Display.Controls.Clear();
string procName = "";
string title = "";
string titleColor = "";
string ProcessName = "";
string VehicleCount = "";
for (int i = 0; i < 8; i++)
{
if (i == 0)
{
procName = "GetVehiclePositionInfo_BodyShop";
title = "Front Office";
titleColor = "#006666";
ProcessName = "Gate";
DataTable dtVehicle = new DataTable();
dtVehicle = GetVehicles(procName, ProcessName);
lbWGate.Text = dtVehicle.Rows.Count.ToString();
}
else if (i == 1)
{
procName = "GetVehiclePositionInfo_BodyShop";
title = "Dismantling";
titleColor = "#ff6b31";
ProcessName = "Dismantling";
DataTable dtVehicle1 = new DataTable();
dtVehicle1 = GetVehicles(procName, ProcessName);
lbRO.Text = dtVehicle1.Rows.Count.ToString();
}
else if (i == 2)
{
procName = "GetVehiclePositionInfo_BodyShop";
title = "Denting";
titleColor = "#53a145";
ProcessName = "Denting";
DataTable dtVehicle2 = new DataTable();
dtVehicle2 = GetVehicles(procName, ProcessName);
lbWorkshop.Text = dtVehicle2.Rows.Count.ToString();
}
else if (i == 3)
{
procName = "GetVehiclePositionInfo_BodyShop";
title = "Painting";
titleColor = "#275d8b";
ProcessName = "Painting";
dtVehicle = GetVehicles(procName, ProcessName);
lbWA.Text = dtVehicle.Rows.Count.ToString();
}
else if (i == 4)
{
procName = "GetVehiclePositionInfo_BodyShop";
title = "Refitting";
titleColor = "#11a285";
ProcessName = "Refitting";
dtVehicle = GetVehicles(procName, ProcessName);
lbRT.Text = dtVehicle.Rows.Count.ToString();
}
else if (i == 5)
{
procName = "GetVehiclePositionInfo_BodyShop";
title = "Final Inspection";
titleColor = "#6d4270";
ProcessName = "Final Inspection BodyShop";
dtVehicle = GetVehicles(procName, ProcessName);
lbFI.Text = dtVehicle.Rows.Count.ToString();
}
else if (i == 6)
{
procName = "GetVehiclePositionInfo_BodyShop";
title = "Reinspection";
titleColor = "#d59010";
ProcessName = "Reinspection";
dtVehicle = GetVehicles(procName, ProcessName);
lbWash.Text = dtVehicle.Rows.Count.ToString();
}
else if (i == 7)
{
procName = "GetVehiclePositionInfo_BodyShop";
title = "Vehicle Ready";
titleColor = "#95a112";
ProcessName = "Vehicle Ready";
dtVehicle = GetVehicles(procName, ProcessName);
lbVR.Text = dtVehicle.Rows.Count.ToString();
}
var cell = new HtmlTableCell();
cell.VAlign = "Top";
cell.Style.Value = "width:11.11%;";
//var Row = new HtmlTableRow();
// DataTable dtVehicle = new DataTable();
dtVehicle = GetVehicles(procName, ProcessName);
int totalVehicle = dtVehicle.Rows.Count;
Panel pnl = new Panel();
pnl.ID = ("pnl_" + i.ToString());
// pnl.Style.Value = "width:100%;height:340px;background-color:#FFFFFF;overflow:auto;cellspacing='0'; cellpadding='0';";
pnl.CssClass = "PanelStyle1";
for (int j = 0; j < totalVehicle; j++)
{
Panel pnla = new Panel();
PositionDisplay_bodyshop vt = (PositionDisplay_bodyshop)Page.LoadControl("PositionDisplay_bodyshop.ascx");
int Length = dtVehicle.Rows[j]["RegNo"].ToString().Length;
if (dtVehicle.Rows[j]["RegNo"].ToString().Length > 10)
{
vt.RegNo = dtVehicle.Rows[j]["RegNo"].ToString().Substring(Length - 10, 10);
}
else
{
vt.RegNo = dtVehicle.Rows[j]["RegNo"].ToString();
}
vt.Model = dtVehicle.Rows[j]["VehicleModel"].ToString();
vt.VehicleImage = DataManager.car_image(dtVehicle.Rows[j]["ModelImageUrl"].ToString());
vt.Slno = dtVehicle.Rows[j]["Slno"].ToString();
//if (dtVehicle.Rows[j]["Position"].ToString() != "Gate")
vt.LastProcess = DataManager.jcr_image(dtVehicle.Rows[j]["PositionUrl"].ToString());
// lblSlno.Text = dtVehicle.Rows[j]["Slno"].ToString();
vt.VehicleColor = GetPositionColor(dtVehicle.Rows[j]["Position"].ToString().Trim());
//vt.PDTCheck = true;
//vt.PDT = dtVehicle.Rows[j]["PDT"].ToString();
vt.PDTImage = DataManager.jcr_image(dtVehicle.Rows[j]["PDTStatus"].ToString());
if (dtVehicle.Rows[j]["ServiceAdvisor"].ToString().Length > 10)
{
vt.ServiceAdvisor = dtVehicle.Rows[j]["ServiceAdvisor"].ToString().Substring(0, 10);
}
else
{
vt.ServiceAdvisor = dtVehicle.Rows[j]["ServiceAdvisor"].ToString();
}
//vt.CWJDPImage = dtVehicle.Rows[j]["CWJDP"].ToString();
pnla.Controls.Add(vt);
pnla.Attributes.Add("onmouseover", "ShowLoadProcessInOutTime(event,'" + vt.Slno.ToString() + "','" + ProcessName + "')");
pnla.Attributes.Add("onmouseout", "hideTooltip(event)");
pnl.Controls.Add(pnla);
//cell.Controls.Add(pnl);
//Row.Controls.Add(cell);
}
Label lbl = new Label();
lbl.Style.Value = "width:99%;background-color:" + titleColor + ";vertical-align:middle;color:#FFFFFF; font-weight:bold;padding-left:5px;font-size:18px;";
lbl.Height = new Unit(64);
lbl.Width = new Unit(13);
//lbl.Text = "<table style='width: 99%; height: 100%;' border='0' cellspacing='0' cellpadding='0'><tr><td style='white-space:nowrap;'>" + title + "</td><td style='white-space:nowrap;text-align:right;padding-right:15px;border=1;'> " + totalVehicle.ToString() + "</td></tr></table>";
lbl.Text = "<table style='width: 99%; height: 100%;' border='0' cellspacing='0' cellpadding='0'><tr><td style='white-space:nowrap;text-align:center;border=1;font-family:Roboto, sans-serif; font-size:35px;'> " + totalVehicle.ToString() + "</td></tr><tr><td style='white-space:nowrap;text-align:center;font-family:Roboto, sans-serif; font-size:15px;'>" + title + "</td></tr></table>";
cell.Controls.Add(lbl);
cell.Controls.Add(pnl);
//DataTable dt = new DataTable();
//dt = GetVehicles(procName, ProcessName);
//int totalVehicle1 = dt.Rows.Count;
//for (int flag = 0; flag < totalVehicle1; flag++)
//{
// cell.Attributes.Add("onmouseover", "ShowLoadProcessInOutTime(event,'" + dt.Rows[flag]["Slno"].ToString() + "','" + ProcessName + "')");
// cell.Attributes.Add("onmouseout", "hideTooltip(event)");
// pnl_Display.Cells.Add(cell);
//}
pnl_Display.Controls.Add(cell);
// pnl_Display.Cells.Add(cell);
// tbl_Hover.Cells.Add(pnl_Display);
//pnl_Display.Attributes.Add("onmouseover", "ShowLoadProcessInOutTime(event,'" + lblSlno.Text.ToString() + "','" + ProcessName + "')");
//pnl_Display.Attributes.Add("onmouseout", "hideTooltip(event)");
// pnl_Display.Attributes.Add("onmouseover", "ShowLoadProcessInOutTime(event,'" + lblSlno.Text + "','Gate')");
}
}
catch (Exception ex)
{
}
}
public void FillVehicleIdleDashboard()
{
try
{
pnl_Idle_Display.Controls.Clear();
string procName = "";
string title = "";
string titleColor = "";
string ProcessName = "";
for (int i = 0; i < 8; i++)
{
if (i == 0)
{
procName = "GetVehicleIdlePositionInfo_BodyShop";
title = "Documents";
titleColor = "Gray";
ProcessName = "Documents";
dtVehicleI = GetVehicles(procName, ProcessName);
lbVH.Text = dtVehicleI.Rows.Count.ToString();
}
//else if (i == 1)
//{
// procName = "GetVehicleIdlePositionInfo_BodyShop";
// title = "Insurance Approval";
// titleColor = "#53a145";
// ProcessName = "Insurance Approval";
// dtVehicleI = GetVehicles(procName, ProcessName);
// VHR = int.Parse(dtVehicleI.Rows.Count.ToString());
//}
//else if (i == 2)
//{
// procName = "GetVehicleIdlePositionInfo_BodyShop";
// title = "Supplemantary Approval";
// titleColor = "#275d8b";
// ProcessName = "Supplemantary Approval";
// dtVehicleI = GetVehicles(procName, ProcessName);
// WA = int.Parse(dtVehicleI.Rows.Count.ToString());
//}
else if (i == 1)
{
procName = "GetVehicleIdlePositionInfo_BodyShop";
title = "Dismantling";
titleColor = "#ff6b31";
ProcessName = "Dismantling";
dtVehicleI = GetVehicles(procName, ProcessName);
FI = int.Parse(dtVehicleI.Rows.Count.ToString());
}
else if (i == 2)
{
procName = "GetVehicleIdlePositionInfo_BodyShop";
title = "Denting";
titleColor = "#53a145";
ProcessName = "Denting";
dtVehicleI = GetVehicles(procName, ProcessName);
Wash = int.Parse(dtVehicleI.Rows.Count.ToString());
}
else if (i == 3)
{
procName = "GetVehicleIdlePositionInfo_BodyShop";
title = "Painting";
titleColor = "#275d8b";
ProcessName = "Painting";
dtVehicleI = GetVehicles(procName, ProcessName);
Wash = int.Parse(dtVehicleI.Rows.Count.ToString());
}
else if (i == 4)
{
procName = "GetVehicleIdlePositionInfo_BodyShop";
title = "Refitting";
titleColor = "#11a285";
ProcessName = "Refitting";
dtVehicleI = GetVehicles(procName, ProcessName);
Wash = int.Parse(dtVehicleI.Rows.Count.ToString());
}
else if (i == 5)
{
procName = "GetVehicleIdlePositionInfo_BodyShop";
title = "Final Inspection";
titleColor = "#6d4270";
ProcessName = "Final Inspection BodyShop";
dtVehicleI = GetVehicles(procName, ProcessName);
Wash = int.Parse(dtVehicleI.Rows.Count.ToString());
}
else if (i == 6)
{
procName = "GetVehicleIdlePositionInfo_BodyShop";
title = "ReInspection";
titleColor = "#d59010";
ProcessName = "ReInspection";
dtVehicleI = GetVehicles(procName, ProcessName);
Wash = int.Parse(dtVehicleI.Rows.Count.ToString());
}
else if (i == 7)
{
procName = "GetVehicleIdlePositionInfo_BodyShop";
title = "Vehicle Ready";
titleColor = "#95a112";
ProcessName = "Vehicle Ready";
dtVehicleI = GetVehicles(procName, ProcessName);
Wash = int.Parse(dtVehicleI.Rows.Count.ToString());
}
var cell = new HtmlTableCell();
cell.VAlign = "Top";
cell.Style.Value = "width:11.11%;";
DataTable dtVehicle = new DataTable();
dtVehicle = GetVehicles(procName, ProcessName);
int totalVehicle = dtVehicle.Rows.Count;
Panel pnl1 = new Panel();
pnl1.ID = ("pnl1_" + i.ToString());
//pnl1.Style.Value = "width:100%;height:220px;background-color:#FFFFFF;overflow:auto;cellspacing='0'; cellpadding='0';";
pnl1.CssClass = "PanelStyle";
for (int j = 0; j < totalVehicle; j++)
{
Panel pnb = new Panel();
PositionDisplay_bodyshop vt = (PositionDisplay_bodyshop)Page.LoadControl("PositionDisplay_bodyshop.ascx");
int Length = dtVehicle.Rows[j]["RegNo"].ToString().Length;
if (dtVehicle.Rows[j]["RegNo"].ToString().Length > 10)
{
vt.RegNo = dtVehicle.Rows[j]["RegNo"].ToString().Substring(Length - 10, 10);
}
else
{
vt.RegNo = dtVehicle.Rows[j]["RegNo"].ToString();
}
vt.Model = dtVehicle.Rows[j]["VehicleModel"].ToString();
vt.VehicleImage = DataManager.car_image(dtVehicle.Rows[j]["ModelImageUrl"].ToString());
vt.VehicleColor = GetPositionColor(dtVehicle.Rows[j]["Position"].ToString().Trim());
lblSlno.Text = dtVehicle.Rows[j]["Slno"].ToString();
//vt.PDT = dtVehicle.Rows[j]["PDT"].ToString();
vt.PDTImage = DataManager.jcr_image(dtVehicle.Rows[j]["PDTStatus"].ToString());
if (ProcessName != "Gate")
{
vt.LastProcess = DataManager.jcr_image(dtVehicle.Rows[j]["PositionUrl"].ToString());
}
//vt.GateInTime = dtVehicle.Rows[j]["PDT"].ToString();
if (dtVehicle.Rows[j]["ServiceAdvisor"].ToString().Length > 12)
{
vt.ServiceAdvisor = dtVehicle.Rows[j]["ServiceAdvisor"].ToString().Substring(0, 12);
}
else
{
vt.ServiceAdvisor = dtVehicle.Rows[j]["ServiceAdvisor"].ToString();
}
//vt.CWJDPImage = dtVehicle.Rows[j]["CWJDP"].ToString();
//vt.Attributes.Add("onmouseover", "ShowLoadProcessInOutTime(event,'" + lblSlno.Text.ToString() + "','" + ProcessName + "')");
//vt.Attributes.Add("onmouseout", "hideTooltip(event)");
pnb.Controls.Add(vt);
if (ProcessName == "Vehicle Hold")
{
pnb.Attributes.Add("onmouseover", "ShowLoadProcessInOutTime(event,'" + lblSlno.Text.ToString() + "','" + ProcessName + "')");
pnb.Attributes.Add("onmouseout", "hideTooltip(event)");
}
else
{
pnb.Attributes.Add("onmouseover", "ShowLoadIdleInOutTime(event,'" + lblSlno.Text.ToString() + "')");
pnb.Attributes.Add("onmouseout", "hideTooltip(event)");
}
pnl1.Controls.Add(pnb);
}
Label lbl = new Label();
//if (ProcessName == "BodyShop")
// lbl.Style.Value = "width:99%;background-color:" + titleColor + ";vertical-align:middle;color:#000000; font-weight:bold;padding-left:5px;font-size:18px;";
//else
lbl.Style.Value = "width:99%;background-color:" + titleColor + ";vertical-align:middle;color:#FFFFFF; font-weight:bold;padding-left:5px;font-size:18px;";
lbl.Height = new Unit(24);
lbl.Width = new Unit(13);
lbl.Text = "<table style='width: 99%; height: 100%;' border='0' cellspacing='0' cellpadding='0'><tr><td style='white-space:nowrap;font-family:Roboto, sans-serif;font-size:15px;'>" + title + "</td><td style='white-space:nowrap;text-align:right;padding-right:15px;font-family:Roboto, sans-serif;font-size:15px;'>" + totalVehicle.ToString() + "</td></tr></table>";
cell.Controls.Add(lbl);
cell.Controls.Add(pnl1);
pnl_Idle_Display.Cells.Add(cell);
}
}
catch (Exception ex)
{
}
}
