public void LoadIncident()
{
incident = db.GetIncidentDetails(incidentNumber);
details.SetControlData(incident);
}
private void PopulateGridView(DataSet ds, DataGridView activeGrid)
{
/*
* CREATE TABLE "incidents" (
* `incidentNumber` INTEGER NOT NULL,
* `storeNumber` INTEGER NOT NULL,
* `contactName` TEXT,
* `createDateTime` TEXT NOT NULL,
* `contactType` TEXT,
* `problemType` TEXT,
* `status` TEXT,
* `priority` TEXT DEFAULT 'Normal',
* `posManual` INTEGER DEFAULT 0,
* `problem` TEXT,
* PRIMARY KEY(incidentNumber)
* )
*/
DataTable table = ds.Tables["incidents"];
table.Columns["incidentNumber"].ColumnName = "Incident";
table.Columns["storeNumber"].ColumnName = "Store";
table.Columns.Remove("contactName");
table.Columns["createDateTime"].ColumnName = "Date/Time";
table.Columns.Remove("contactType");
table.Columns.Remove("problemType");
table.Columns["status"].ColumnName = "Status";
//table.Columns.Remove("priority");
table.Columns.Remove("posManual");
table.Columns["problem"].ColumnName = "Problem";
activeGrid.DataSource = table;
foreach (DataGridViewColumn col in activeGrid.Columns)
{
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
if (col.Name == "priority")
{
col.Visible = false;
}
}
activeGrid.Columns["problem"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
foreach (DataGridViewRow row in activeGrid.Rows)
{
switch (row.Cells["priority"].Value.ToString().ToLower())
{
case "low":
row.DefaultCellStyle.BackColor = Color.LightBlue;
break;
case "high":
row.DefaultCellStyle.BackColor = Color.Orange;
break;
case "priority":
row.DefaultCellStyle.BackColor = Color.Red;
break;
}
switch (row.Cells["status"].Value.ToString().ToLower())
{
case "level 3":
row.DefaultCellStyle.BackColor = Color.Green;
row.DefaultCellStyle.ForeColor = Color.White;
break;
case "level 4":
row.DefaultCellStyle.BackColor = Color.Purple;
row.DefaultCellStyle.ForeColor = Color.White;
break;
}
Incident inc = new Incident();
inc.IncidentNumber = int.Parse(row.Cells["Incident"].Value.ToString());
string upd = db.GetLatestUpdateForIncident(inc);
if (upd != "")
{
row.Cells["problem"].Value = upd;
}
}
//Dictionary<string, string> desc = db.GetLatestUpdatesForOpenIncidents();
}
