protected void get_list_of_salary_scales_for_guards()
{
DataTable dt = Salary_scales.return_salary_scales("return_salary_scales");
if (dt.Rows.Count > 0)
{
this.gdv_salary_scales.DataSource = dt;
this.gdv_salary_scales.Columns[0].Visible = false;
this.gdv_salary_scales.Columns[1].Visible = false;
this.gdv_salary_scales.Columns[2].Visible = false;
this.gdv_salary_scales.Columns["basic_amount"].HeaderText = "Basic Amount";
this.gdv_salary_scales.Columns["salary_amount"].HeaderText = "Salary Amount";
this.gdv_salary_scales.Columns["scale_name"].HeaderText = "Scale Name";
this.gdv_salary_scales.Columns["transport_amount"].HeaderText = "Transport Amount";
this.gdv_salary_scales.Columns["housing_amount"].HeaderText = "Housing Amount";
this.gdv_salary_scales.Columns["scale_name"].Width = 220;
this.gdv_salary_scales.Columns["salary_amount"].DefaultCellStyle.ForeColor = Color.Blue;
this.gdv_salary_scales.RowsDefaultCellStyle.BackColor = Color.LightGray;
this.gdv_salary_scales.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
this.gdv_salary_scales.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
this.gdv_salary_scales.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_salary_scales.RowHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_salary_scales.DefaultCellStyle.SelectionBackColor = Color.Cyan;
this.gdv_salary_scales.DefaultCellStyle.SelectionForeColor = Color.Black;
foreach (DataGridViewColumn c in this.gdv_salary_scales.Columns)
{
c.DefaultCellStyle.Font = new System.Drawing.Font("Arial", 12.5f, GraphicsUnit.Pixel);
}
this.gdv_salary_scales.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
this.gdv_salary_scales.EnableHeadersVisualStyles = false;
}
}
//return list of salary scales
protected void get_list_of_salary_scales_for_guards()
{
DataTable dt = Salary_scales.return_salary_scales("return_salary_scales");
if (dt.Rows.Count > 0)
{
gdv_salary_scales.DataSource = dt;
gdv_salary_scales.Columns[0].Visible = false;
gdv_salary_scales.Columns[1].Visible = false;
gdv_salary_scales.Columns[2].Visible = false;
gdv_salary_scales.Columns["basic_amount"].HeaderText = "Basic Amount";
gdv_salary_scales.Columns["salary_amount"].HeaderText = "Salary Amount";
gdv_salary_scales.Columns["scale_name"].HeaderText = "Scale Name";
gdv_salary_scales.Columns["transport_amount"].HeaderText = "Transport Amount";
gdv_salary_scales.Columns["housing_amount"].HeaderText = "Housing Amount";
gdv_salary_scales.Columns["scale_name"].Width = 220;
gdv_salary_scales.Columns["salary_amount"].DefaultCellStyle.ForeColor = Color.Blue;
gdv_salary_scales.RowsDefaultCellStyle.BackColor = Color.LightGray;
gdv_salary_scales.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
// Set the row and column header styles.
gdv_salary_scales.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
gdv_salary_scales.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
gdv_salary_scales.RowHeadersDefaultCellStyle.BackColor = Color.Black;
// Set the selection background color for all the cells.
gdv_salary_scales.DefaultCellStyle.SelectionBackColor = Color.Cyan;
gdv_salary_scales.DefaultCellStyle.SelectionForeColor = Color.Black;
foreach (DataGridViewColumn c in gdv_salary_scales.Columns)
{
c.DefaultCellStyle.Font = new Font("Arial", 12.5F, GraphicsUnit.Pixel);
}
//set the background color of the header row
gdv_salary_scales.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
gdv_salary_scales.EnableHeadersVisualStyles = false;
}
}
