private void _BindService()
{
DatabaseConnectivity dbcon = new DatabaseConnectivity();
List <Patch> service = dbcon.getAllUpdatedClientPatches(Convert.ToInt32(dropProduct.SelectedValue), Convert.ToInt32(dropEnvironment.SelectedValue));
if (service.Count > 0 && service != null)
{
GridView1.DataSource = service;
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Debug.WriteLine("Product: " + DropDownList1.Text);
//Console.WriteLine("GGG");
DatabaseConnectivity dbcon = new DatabaseConnectivity();
//PAMS for Parameter 1
//Test Env For Parameter 2
Debug.WriteLine("Product: " + DropDownList1.Text);
int product = Convert.ToInt32(DropDownList1.Text);
List <Patch> latestPatchOfClient = dbcon.getAllUpdatedClientPatches(product == 0 ? 1 : product, 3);
//Debug.WriteLine("Records Count: " + latestPatchOfClient.Count);
foreach (var item in latestPatchOfClient)
{
//Debug.WriteLine("Name:" + item.clientName + " | PatchHotNumber: " + item.patchHotNumber + " | PatchDeployedDate: " + item.patchDeployedDate + "\n");
TableRow row = new TableRow();
//Passed By Time Duration Calculation Logic
//Debug.WriteLine("=>" + item.patchNumberOfDaysPassed);
int numberOfDaysPassed = Convert.ToInt32(item.patchNumberOfDaysPassed == "" ? -1 : Convert.ToInt32(item.patchNumberOfDaysPassed));
switch (numberOfDaysPassed)
{
case 0:
row.BackColor = ColorTranslator.FromHtml("#f68787");
break;
case 1:
row.BackColor = ColorTranslator.FromHtml("#f8a978");
break;
case 2:
row.BackColor = ColorTranslator.FromHtml("#f1eb9a");
break;
case 3:
row.BackColor = ColorTranslator.FromHtml("#a4f6a5");
break;
case 4:
row.BackColor = ColorTranslator.FromHtml("#fff");
break;
case 5:
row.BackColor = ColorTranslator.FromHtml("#fff");
break;
case 6:
row.BackColor = ColorTranslator.FromHtml("#ffffff");
break;
case 7:
row.BackColor = ColorTranslator.FromHtml("#ffb6b9");
break;
case 8:
row.BackColor = ColorTranslator.FromHtml("#fff");
break;
case 9:
row.BackColor = ColorTranslator.FromHtml("#fff");
break;
case 10:
row.BackColor = ColorTranslator.FromHtml("#087");
break;
}
TableCell cellClientName = new TableCell();
cellClientName.Font.Size = FontUnit.Smaller;
cellClientName.ForeColor = Color.Black;
cellClientName.Text = item.clientName;
cellClientName.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellClientName);
TableCell cellClientType = new TableCell();
cellClientType.Font.Size = FontUnit.Smaller;
cellClientType.ForeColor = Color.Black;
cellClientType.Text = item.clientType;
cellClientType.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellClientType);
TableCell cellClientEnvType = new TableCell();
cellClientEnvType.Font.Size = FontUnit.Smaller;
cellClientEnvType.ForeColor = Color.Black;
cellClientEnvType.Text = item.clientEnvType;
cellClientEnvType.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellClientEnvType);
TableCell cellClientPOC = new TableCell();
cellClientPOC.Font.Size = FontUnit.Smaller;
cellClientPOC.ForeColor = Color.Black;
cellClientPOC.Text = item.clientPOCName;
cellClientPOC.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellClientPOC);
TableCell cellClientPOCName = new TableCell();
cellClientPOCName.Font.Size = FontUnit.Smaller;
cellClientPOCName.ForeColor = Color.Black;
cellClientPOCName.Text = item.numberOfPatches;
cellClientPOCName.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellClientPOCName);
TableCell cellPatchHotNumber = new TableCell();
cellPatchHotNumber.Font.Size = FontUnit.Smaller;
cellPatchHotNumber.ForeColor = Color.Black;
cellPatchHotNumber.Text = item.patchHotNumber;
cellPatchHotNumber.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellPatchHotNumber);
TableCell cellAppLink = new TableCell();
cellAppLink.Font.Size = FontUnit.Smaller;
cellAppLink.ForeColor = Color.Black;
cellAppLink.Text = "<a target=\"_blank\" href=\"" + item.clientAppLink + "\" >" + item.clientAppLink + "</a>";
cellAppLink.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellAppLink);
TableCell cellPatchQATested = new TableCell();
cellPatchQATested.Font.Size = FontUnit.Smaller;
cellPatchQATested.ForeColor = Color.Black;
cellPatchQATested.Text = item.patchQATested == "1" ? "Tested" : "Not Tested";
cellPatchQATested.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellPatchQATested);
TableCell cellPatchDeployedDate = new TableCell();
cellPatchDeployedDate.Font.Size = FontUnit.Smaller;
cellPatchDeployedDate.ForeColor = Color.Black;
//int spaceInDate = item.patchDeployedDate.IndexOf(' ');
//cellPatchDeployedDate.Text = item.patchDeployedDate.Substring(0, spaceInDate);
cellPatchDeployedDate.Text = item.patchDeployedDate.ToString();
cellPatchDeployedDate.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellPatchDeployedDate);
//
TableCell cellPatchPassedByTime = new TableCell();
cellPatchPassedByTime.Font.Size = FontUnit.Smaller;
cellPatchPassedByTime.ForeColor = Color.Black;
cellPatchPassedByTime.Text = numberOfDaysPassed + " Days Ago.";
cellPatchPassedByTime.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellPatchPassedByTime);
TableCell cellPatchStatus = new TableCell();
cellPatchStatus.Font.Size = FontUnit.Smaller;
cellPatchStatus.ForeColor = Color.Black;
cellPatchStatus.Text = item.patchStatus;
cellPatchStatus.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(cellPatchStatus);
//
//TableCell cellPatchFileServer = new TableCell();
//cellPatchFileServer.ForeColor = Color.Black;
//cellPatchFileServer.Text = "";
//cellPatchFileServer.HorizontalAlign = HorizontalAlign.Right;
//row.Cells.Add(cellPatchFileServer);
//
//TableCell cellPatchIP = new TableCell();
//cellPatchIP.ForeColor = Color.Black;
//cellPatchIP.Text = "";
//cellPatchIP.HorizontalAlign = HorizontalAlign.Right;
//row.Cells.Add(cellPatchIP);
//
//
//TableCell cellPatchDependency = new TableCell();
//cellPatchDependency.ForeColor = Color.Black;
//cellPatchDependency.Text = "";
//cellPatchDependency.HorizontalAlign = HorizontalAlign.Right;
//row.Cells.Add(cellPatchDependency);
//
//
tblInfo.ControlStyle.Height = Unit.Pixel(28);
tblInfo.Rows.Add(row);
}
}