private void btn_name_search_Click(object sender, EventArgs e) { if (cbo_guard_status.Text != String.Empty && cbo_branch_search.Text == String.Empty) { DataTable dt = Archieve_Lists.SEARCH_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS("FILTER_ARCHIEVE_BY_STATUS", cbo_guard_status.Text); if (dt != null) { gdv_guards.DataSource = dt; gdv_guards.Columns[0].Visible = false; gdv_guards.Columns[1].Visible = false; gdv_guards.Columns[2].HeaderText = "NAME"; gdv_guards.Columns[3].HeaderText = "BRANCH"; gdv_guards.Columns[4].HeaderText = "STATUS"; gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; gdv_guards.RowsDefaultCellStyle.BackColor = Color.LightGray; gdv_guards.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige; // Set the row and column header styles. gdv_guards.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gdv_guards.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; gdv_guards.RowHeadersDefaultCellStyle.BackColor = Color.Black; // Set the selection background color for all the cells. gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; } else { DataTable dt_null = null; gdv_statisctics.DataSource = dt_null; } } else if (cbo_guard_status.Text == String.Empty && cbo_branch_search.Text != String.Empty) { DataTable dt = Archieve_Lists.SEARCH_ARCHIEVED_GUARD_LIST_REPORT_BY_BRANCH("FILTER_ARCHIEVE_BY_STATION", cbo_branch_search.Text); if (dt != null) { gdv_guards.DataSource = dt; gdv_guards.Columns[0].Visible = false; gdv_guards.Columns[1].Visible = false; gdv_guards.Columns[2].HeaderText = "NAME"; gdv_guards.Columns[3].HeaderText = "BRANCH"; gdv_guards.Columns[4].HeaderText = "STATUS"; gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; gdv_guards.RowsDefaultCellStyle.BackColor = Color.LightGray; gdv_guards.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige; // Set the row and column header styles. gdv_guards.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gdv_guards.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; gdv_guards.RowHeadersDefaultCellStyle.BackColor = Color.Black; // Set the selection background color for all the cells. gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; } else { DataTable dt_null = null; gdv_statisctics.DataSource = dt_null; } } else if (cbo_guard_status.Text != String.Empty && cbo_branch_search.Text != String.Empty) { DataTable dt = Archieve_Lists.SEARCH_ARCHIEVED_GUARD_LIST_REPORT_BY_BRANCH_AND_STATUS("FILTER_ARCHIEVE_BY_STATION", cbo_branch_search.Text, cbo_guard_status.Text); if (dt != null) { gdv_guards.DataSource = dt; gdv_guards.Columns[0].Visible = false; gdv_guards.Columns[1].Visible = false; gdv_guards.Columns[2].HeaderText = "NAME"; gdv_guards.Columns[3].HeaderText = "BRANCH"; gdv_guards.Columns[4].HeaderText = "STATUS"; gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; gdv_guards.RowsDefaultCellStyle.BackColor = Color.LightGray; gdv_guards.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige; // Set the row and column header styles. gdv_guards.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gdv_guards.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; gdv_guards.RowHeadersDefaultCellStyle.BackColor = Color.Black; // Set the selection background color for all the cells. gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; } else { DataTable dt_null = null; gdv_statisctics.DataSource = dt_null; } } else { GET_GUARD_LIST(); } }
private void btn_name_search_Click(object sender, EventArgs e) { if (this.cbo_guard_status.Text != string.Empty && this.cbo_branch_search.Text == string.Empty) { DataTable _dt = Archieve_Lists.SEARCH_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS("FILTER_ARCHIEVE_BY_STATUS", this.cbo_guard_status.Text); if (_dt == null) { this.gdv_statisctics.DataSource = null; return; } this.gdv_guards.DataSource = _dt; this.gdv_guards.Columns[0].Visible = false; this.gdv_guards.Columns[1].Visible = false; this.gdv_guards.Columns[2].HeaderText = "NAME"; this.gdv_guards.Columns[3].HeaderText = "BRANCH"; this.gdv_guards.Columns[4].HeaderText = "STATUS"; this.gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; this.gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; this.gdv_guards.RowsDefaultCellStyle.BackColor = Color.LightGray; this.gdv_guards.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige; this.gdv_guards.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; this.gdv_guards.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; this.gdv_guards.RowHeadersDefaultCellStyle.BackColor = Color.Black; this.gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; this.gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; return; } if (this.cbo_guard_status.Text == string.Empty && this.cbo_branch_search.Text != string.Empty) { DataTable _dt = Archieve_Lists.SEARCH_ARCHIEVED_GUARD_LIST_REPORT_BY_BRANCH("FILTER_ARCHIEVE_BY_STATION", this.cbo_branch_search.Text); if (_dt == null) { this.gdv_statisctics.DataSource = null; return; } this.gdv_guards.DataSource = _dt; this.gdv_guards.Columns[0].Visible = false; this.gdv_guards.Columns[1].Visible = false; this.gdv_guards.Columns[2].HeaderText = "NAME"; this.gdv_guards.Columns[3].HeaderText = "BRANCH"; this.gdv_guards.Columns[4].HeaderText = "STATUS"; this.gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; this.gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; this.gdv_guards.RowsDefaultCellStyle.BackColor = Color.LightGray; this.gdv_guards.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige; this.gdv_guards.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; this.gdv_guards.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; this.gdv_guards.RowHeadersDefaultCellStyle.BackColor = Color.Black; this.gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; this.gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; return; } if (!(this.cbo_guard_status.Text != string.Empty) || !(this.cbo_branch_search.Text != string.Empty)) { this.GET_GUARD_LIST(); return; } DataTable dt = Archieve_Lists.SEARCH_ARCHIEVED_GUARD_LIST_REPORT_BY_BRANCH_AND_STATUS("FILTER_ARCHIEVE_BY_STATION", this.cbo_branch_search.Text, this.cbo_guard_status.Text); if (dt == null) { this.gdv_statisctics.DataSource = null; return; } this.gdv_guards.DataSource = dt; this.gdv_guards.Columns[0].Visible = false; this.gdv_guards.Columns[1].Visible = false; this.gdv_guards.Columns[2].HeaderText = "NAME"; this.gdv_guards.Columns[3].HeaderText = "BRANCH"; this.gdv_guards.Columns[4].HeaderText = "STATUS"; this.gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; this.gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; this.gdv_guards.RowsDefaultCellStyle.BackColor = Color.LightGray; this.gdv_guards.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige; this.gdv_guards.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; this.gdv_guards.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; this.gdv_guards.RowHeadersDefaultCellStyle.BackColor = Color.Black; this.gdv_guards.DefaultCellStyle.SelectionBackColor = Color.White; this.gdv_guards.DefaultCellStyle.SelectionForeColor = Color.Black; }