protected void Return_guard_salary_mappings()
{
DataTable dt = Salary_scales.return_guard_salary_mappings("return_guard_salary_mappings");
if (dt.Rows.Count > 0)
{
this.gdv_guard_salaries.DataSource = dt;
this.gdv_guard_salaries.Columns[0].HeaderText = "Guard Name";
this.gdv_guard_salaries.Columns[1].HeaderText = "Branch";
this.gdv_guard_salaries.Columns[2].HeaderText = "Duration Served(Years):0 Means Less than a year";
this.gdv_guard_salaries.Columns[3].HeaderText = "Posible Salary Scale";
this.gdv_guard_salaries.DefaultCellStyle.SelectionBackColor = Color.White;
this.gdv_guard_salaries.DefaultCellStyle.SelectionForeColor = Color.Black;
this.gdv_guard_salaries.RowsDefaultCellStyle.BackColor = Color.LightGray;
this.gdv_guard_salaries.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
this.gdv_guard_salaries.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
this.gdv_guard_salaries.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_guard_salaries.RowHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_guard_salaries.DefaultCellStyle.SelectionBackColor = Color.White;
this.gdv_guard_salaries.DefaultCellStyle.SelectionForeColor = Color.Black;
foreach (DataGridViewColumn c in this.gdv_guard_salaries.Columns)
{
c.DefaultCellStyle.Font = new System.Drawing.Font("Arial", 12.5f, GraphicsUnit.Pixel);
}
this.gdv_guard_salaries.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
this.gdv_guard_salaries.EnableHeadersVisualStyles = false;
}
}
protected void Return_guard_salary_mappings()
{
DataTable dt = Salary_scales.return_guard_salary_mappings("return_manual_guard_salary_scale_mappings");
if (dt.Rows.Count > 0)
{
this.gdv_guard_salaries.DataSource = dt;
this.gdv_guard_salaries.Columns["full_name"].HeaderText = "Guard Name";
this.gdv_guard_salaries.Columns["branch"].HeaderText = "Branch";
this.gdv_guard_salaries.Columns["Duration"].HeaderText = "Duration Served(Years)";
this.gdv_guard_salaries.Columns["salary_amount"].HeaderText = "Salary Amt";
this.gdv_guard_salaries.Columns["auto_id"].Visible = false;
this.gdv_guard_salaries.Columns["guard_number"].Visible = false;
this.gdv_guard_salaries.Columns["scale_auto_id"].Visible = false;
this.gdv_guard_salaries.Columns["full_name"].ReadOnly = true;
this.gdv_guard_salaries.Columns["branch"].ReadOnly = true;
this.gdv_guard_salaries.Columns["Duration"].ReadOnly = true;
this.gdv_guard_salaries.Columns["salary_amount"].ReadOnly = true;
this.gdv_guard_salaries.Columns["full_name"].Width = 200;
this.gdv_guard_salaries.Columns["salary_amount"].DefaultCellStyle.ForeColor = Color.Blue;
DataGridViewCheckBoxColumn chk_select_guard = new DataGridViewCheckBoxColumn()
{
Name = "column_select",
HeaderText = "Select Guard",
FalseValue = 0,
TrueValue = 1
};
this.gdv_guard_salaries.Columns.Insert(0, chk_select_guard);
this.gdv_guard_salaries.Columns["column_select"].ReadOnly = false;
this.gdv_guard_salaries.Columns["column_select"].Width = 50;
this.gdv_guard_salaries.DefaultCellStyle.SelectionBackColor = Color.White;
this.gdv_guard_salaries.DefaultCellStyle.SelectionForeColor = Color.Black;
this.gdv_guard_salaries.RowsDefaultCellStyle.BackColor = Color.LightGray;
this.gdv_guard_salaries.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
this.gdv_guard_salaries.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
this.gdv_guard_salaries.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_guard_salaries.RowHeadersDefaultCellStyle.BackColor = Color.Black;
this.gdv_guard_salaries.DefaultCellStyle.SelectionBackColor = Color.Cyan;
this.gdv_guard_salaries.DefaultCellStyle.SelectionForeColor = Color.Black;
foreach (DataGridViewColumn c in this.gdv_guard_salaries.Columns)
{
c.DefaultCellStyle.Font = new System.Drawing.Font("Arial", 12.5f, GraphicsUnit.Pixel);
}
this.gdv_guard_salaries.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
this.gdv_guard_salaries.EnableHeadersVisualStyles = false;
}
}
protected void Return_guard_salary_mappings()
{
DataTable dt = Salary_scales.return_guard_salary_mappings("return_guard_salary_mappings");
if (dt.Rows.Count > 0)
{
gdv_guard_salaries.DataSource = dt;
gdv_guard_salaries.Columns[0].HeaderText = "Guard Name";
gdv_guard_salaries.Columns[1].HeaderText = "Branch";
gdv_guard_salaries.Columns[2].HeaderText = "Duration Served(Years):0 Means Less than a year";
gdv_guard_salaries.Columns[3].HeaderText = "Posible Salary Scale";
gdv_guard_salaries.DefaultCellStyle.SelectionBackColor = Color.White;
gdv_guard_salaries.DefaultCellStyle.SelectionForeColor = Color.Black;
gdv_guard_salaries.RowsDefaultCellStyle.BackColor = Color.LightGray;
gdv_guard_salaries.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
// Set the row and column header styles.
gdv_guard_salaries.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
gdv_guard_salaries.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
gdv_guard_salaries.RowHeadersDefaultCellStyle.BackColor = Color.Black;
// Set the selection background color for all the cells.
gdv_guard_salaries.DefaultCellStyle.SelectionBackColor = Color.White;
gdv_guard_salaries.DefaultCellStyle.SelectionForeColor = Color.Black;
foreach (DataGridViewColumn c in gdv_guard_salaries.Columns)
{
c.DefaultCellStyle.Font = new Font("Arial", 12.5F, GraphicsUnit.Pixel);
}
//set the background color of the header row
gdv_guard_salaries.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
gdv_guard_salaries.EnableHeadersVisualStyles = false;
}
}
//return scale mapping
protected void Return_guard_salary_mappings()
{
DataTable dt = Salary_scales.return_guard_salary_mappings("return_manual_guard_salary_scale_mappings");
if (dt.Rows.Count > 0)
{
gdv_guard_salaries.DataSource = dt;
gdv_guard_salaries.Columns["full_name"].HeaderText = "Guard Name";
gdv_guard_salaries.Columns["branch"].HeaderText = "Branch";
gdv_guard_salaries.Columns["Duration"].HeaderText = "Duration Served(Years)";
gdv_guard_salaries.Columns["salary_amount"].HeaderText = "Salary Amt";
gdv_guard_salaries.Columns["auto_id"].Visible = false;
gdv_guard_salaries.Columns["guard_number"].Visible = false;
gdv_guard_salaries.Columns["scale_auto_id"].Visible = false;
//set read only properties for these columns
gdv_guard_salaries.Columns["full_name"].ReadOnly = true;
gdv_guard_salaries.Columns["branch"].ReadOnly = true;
gdv_guard_salaries.Columns["Duration"].ReadOnly = true;
gdv_guard_salaries.Columns["salary_amount"].ReadOnly = true;
gdv_guard_salaries.Columns["full_name"].Width = 200;
gdv_guard_salaries.Columns["salary_amount"].DefaultCellStyle.ForeColor = Color.Blue;
//insert the checkbox column at index 0 of the grid
DataGridViewCheckBoxColumn chk_select_guard = new DataGridViewCheckBoxColumn();
chk_select_guard.Name = "column_select";
chk_select_guard.HeaderText = "Select Guard";
chk_select_guard.FalseValue = 0;
chk_select_guard.TrueValue = 1;
gdv_guard_salaries.Columns.Insert(0, chk_select_guard);
//set checkbox column to allow edits.
gdv_guard_salaries.Columns["column_select"].ReadOnly = false;
gdv_guard_salaries.Columns["column_select"].Width = 50;
gdv_guard_salaries.DefaultCellStyle.SelectionBackColor = Color.White;
gdv_guard_salaries.DefaultCellStyle.SelectionForeColor = Color.Black;
gdv_guard_salaries.RowsDefaultCellStyle.BackColor = Color.LightGray;
gdv_guard_salaries.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
// Set the row and column header styles.
gdv_guard_salaries.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
gdv_guard_salaries.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
gdv_guard_salaries.RowHeadersDefaultCellStyle.BackColor = Color.Black;
// Set the selection background color for all the cells.
gdv_guard_salaries.DefaultCellStyle.SelectionBackColor = Color.Cyan;
gdv_guard_salaries.DefaultCellStyle.SelectionForeColor = Color.Black;
foreach (DataGridViewColumn c in gdv_guard_salaries.Columns)
{
c.DefaultCellStyle.Font = new Font("Arial", 12.5F, GraphicsUnit.Pixel);
}
//set the background color of the header row
gdv_guard_salaries.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
gdv_guard_salaries.EnableHeadersVisualStyles = false;
}
}
