private void SetRecords() { dataGridView1.Rows.Clear(); foreach (CallRecord record in msql.GetAllRecords()) { int lastRow = dataGridView1.Rows.Add("", record.ID, record.Date, record.Time, record.Name, record.Phone, record.Type, record.Brand, record.Reason, CallRecord.StatusToString(record.Status)); if (record.Status == ApplicationStatus.WrongCall) { dataGridView1.Rows[lastRow].DefaultCellStyle.BackColor = Color.Red; dataGridView1.Rows[lastRow].DefaultCellStyle.ForeColor = Color.White; } if (record.Status == ApplicationStatus.Accepted) { dataGridView1.Rows[lastRow].DefaultCellStyle.BackColor = Color.LightBlue; dataGridView1.Rows[lastRow].DefaultCellStyle.ForeColor = Color.Black; } } dataGridView1.Sort(dataGridView1.Columns[0], ListSortDirection.Descending); }
private void SetRecords() { dataGridView1.Rows.Clear(); foreach (CallRecord record in msql.GetAllRecords()) { int lastRow = dataGridView1.Rows.Add("", record.ID, record.Date, record.Time, record.Name, record.Phone, record.Type, record.Brand, record.Reason, CallRecord.StatusToString(record.Status)); dataGridView1[dataGridView1.ColumnCount - 1, lastRow].Value = "X"; dataGridView1[dataGridView1.ColumnCount - 2, lastRow].Value = " "; if (record.Status == ApplicationStatus.WrongCall) { dataGridView1.Rows[lastRow].DefaultCellStyle.BackColor = Color.Red; dataGridView1.Rows[lastRow].DefaultCellStyle.ForeColor = Color.White; } if (record.Status == ApplicationStatus.Accepted) { dataGridView1.Rows[lastRow].DefaultCellStyle.BackColor = Color.White; dataGridView1.Rows[lastRow].DefaultCellStyle.ForeColor = Color.Black; } if (record.Status == ApplicationStatus.RecordedAtDiagnostic) { dataGridView1.Rows[lastRow].DefaultCellStyle.BackColor = Color.Yellow; dataGridView1.Rows[lastRow].DefaultCellStyle.ForeColor = Color.Black; } if (record.Status == ApplicationStatus.OnReCall) { dataGridView1.Rows[lastRow].DefaultCellStyle.BackColor = Color.Wheat; dataGridView1.Rows[lastRow].DefaultCellStyle.ForeColor = Color.Black; } if (record.Status == ApplicationStatus.AtDiagnostic) { dataGridView1.Rows[lastRow].DefaultCellStyle.BackColor = Color.LightGreen; dataGridView1.Rows[lastRow].DefaultCellStyle.ForeColor = Color.Black; } } dataGridView1.Sort(dataGridView1.Columns[1], ListSortDirection.Descending); }