//return guards for batch deploy.... protected void get_list_of_guards_for_batch_deploy() { DataTable dt = Guard_deployment.select_list_of_guards_by_branch_and_date_for_batch_deployment("select_list_of_guards_by_branch_and_date_for_batch_deployment", cbo_branch.Text); if (dt.Rows.Count > 0) { //set value of deployment date DataRow dtRow = dt.Rows[0]; dt_deployment_date.Value = Convert.ToDateTime(dtRow["next_deploy_date"]); gdv_deployment_summary.DataSource = dt; gdv_deployment_summary.Columns["deploy_type"].Visible = false; gdv_deployment_summary.Columns["branch_name"].Visible = false; gdv_deployment_summary.Columns["guard_auto_id"].Visible = false; gdv_deployment_summary.Columns["firearm_serial"].Visible = false; gdv_deployment_summary.Columns["number_of_ammunitions"].Visible = false; gdv_deployment_summary.Columns["is_leave_day_for_guard"].Visible = false; gdv_deployment_summary.Columns["is_public_holiday"].Visible = false; gdv_deployment_summary.Columns["deploy_date"].Visible = false; gdv_deployment_summary.Columns["is_weekend"].Visible = false; gdv_deployment_summary.Columns["guard_name"].HeaderText = "Guard"; gdv_deployment_summary.Columns["guard_number"].HeaderText = "Guard"; gdv_deployment_summary.Columns["next_deploy_date"].HeaderText = "Day"; gdv_deployment_summary.Columns["client_name"].HeaderText = "Client"; gdv_deployment_summary.Columns["client_code"].HeaderText = "Client Code"; gdv_deployment_summary.Columns["client_location"].HeaderText = "Location"; gdv_deployment_summary.Columns["shift_type"].HeaderText = "Shift"; gdv_deployment_summary.Columns["guard_name"].Width = 250; gdv_deployment_summary.RowsDefaultCellStyle.BackColor = Color.LightGray; gdv_deployment_summary.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige; // Set the row and column header styles. gdv_deployment_summary.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gdv_deployment_summary.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; gdv_deployment_summary.RowHeadersDefaultCellStyle.BackColor = Color.Black; // Set the selection background color for all the cells. gdv_deployment_summary.DefaultCellStyle.SelectionBackColor = Color.DeepSkyBlue; gdv_deployment_summary.DefaultCellStyle.SelectionForeColor = Color.Black; foreach (DataGridViewColumn c in gdv_deployment_summary.Columns) { c.DefaultCellStyle.Font = new Font("Arial", 11F, GraphicsUnit.Pixel); } //set the background color of the header row gdv_deployment_summary.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue; gdv_deployment_summary.EnableHeadersVisualStyles = false; //set batch save status as not saved chk_save_status.Checked = false; } else { gdv_deployment_summary.DataSource = dt; } }
protected void get_list_of_guards_for_batch_deploy() { DataTable dt = Guard_deployment.select_list_of_guards_by_branch_and_date_for_batch_deployment("select_list_of_guards_by_branch_and_date_for_batch_deployment", this.cbo_branch.Text, SystemConst._user_id); if (dt.Rows.Count <= 0) { this.gdv_deployment_summary.DataSource = dt; return; } DataRow dtRow = dt.Rows[0]; this.dt_deployment_date.Value = Convert.ToDateTime(dtRow["next_deploy_date"]); this.gdv_deployment_summary.DataSource = dt; this.gdv_deployment_summary.Columns["deploy_type"].Visible = false; this.gdv_deployment_summary.Columns["branch_name"].Visible = false; this.gdv_deployment_summary.Columns["guard_auto_id"].Visible = false; this.gdv_deployment_summary.Columns["firearm_serial"].Visible = false; this.gdv_deployment_summary.Columns["number_of_ammunitions"].Visible = false; this.gdv_deployment_summary.Columns["is_leave_day_for_guard"].Visible = false; this.gdv_deployment_summary.Columns["is_public_holiday"].Visible = false; this.gdv_deployment_summary.Columns["deploy_date"].Visible = false; this.gdv_deployment_summary.Columns["is_weekend"].Visible = false; this.gdv_deployment_summary.Columns["guard_name"].HeaderText = "Guard"; this.gdv_deployment_summary.Columns["guard_number"].HeaderText = "Guard Number"; this.gdv_deployment_summary.Columns["next_deploy_date"].HeaderText = "Day"; this.gdv_deployment_summary.Columns["client_name"].HeaderText = "Client"; this.gdv_deployment_summary.Columns["client_code"].HeaderText = "Client Code"; this.gdv_deployment_summary.Columns["client_location"].HeaderText = "Location"; this.gdv_deployment_summary.Columns["shift_type"].HeaderText = "Shift"; this.gdv_deployment_summary.Columns["guard_name"].Width = 250; this.gdv_deployment_summary.RowsDefaultCellStyle.BackColor = Color.LightGray; this.gdv_deployment_summary.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige; this.gdv_deployment_summary.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; this.gdv_deployment_summary.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; this.gdv_deployment_summary.RowHeadersDefaultCellStyle.BackColor = Color.Black; this.gdv_deployment_summary.DefaultCellStyle.SelectionBackColor = Color.DeepSkyBlue; this.gdv_deployment_summary.DefaultCellStyle.SelectionForeColor = Color.Black; foreach (DataGridViewColumn c in this.gdv_deployment_summary.Columns) { c.DefaultCellStyle.Font = new System.Drawing.Font("Arial", 11f, GraphicsUnit.Pixel); } this.gdv_deployment_summary.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue; this.gdv_deployment_summary.EnableHeadersVisualStyles = false; this.chk_save_status.Checked = false; lblCount.Text = dt.Rows.Count.ToString() + " Guards Loaded"; }