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(); }