/// <summary> /// Fills PayHead in datagridview on cell begin edit /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvSalaryPackage_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { try { PayHeadBll BllPayHead = new PayHeadBll(); List<DataTable> listObj = new List<DataTable>(); if (dgvSalaryPackage.CurrentCell.ColumnIndex == dgvSalaryPackage.Columns["dgvcmbPayHead"].Index) { listObj = BllPayHead.PayHeadViewAll(); if (listObj[0].Rows.Count < 2) { DataRow dr = listObj[0].NewRow(); dr[0] = 0; dr[1] = 0; listObj[0].Rows.InsertAt(dr, 0); } if (dgvSalaryPackage.RowCount > 1) { int inGridRowCount = dgvSalaryPackage.RowCount; for (int inI = 0; inI < inGridRowCount - 1; inI++) { if (inI != e.RowIndex) { int inTableRowcount = listObj[0].Rows.Count; for (int inJ = 0; inJ < inTableRowcount; inJ++) { if (dgvSalaryPackage.Rows[inI].Cells["dgvcmbPayHead"].Value != null && dgvSalaryPackage.Rows[inI].Cells["dgvcmbPayHead"].Value.ToString() != string.Empty) { if (listObj[0].Rows[inJ]["payHeadId"].ToString() == dgvSalaryPackage.Rows[inI].Cells["dgvcmbPayHead"].Value.ToString()) { listObj[0].Rows.RemoveAt(inJ); break; } } } } } } DataGridViewComboBoxCell dgvccPayHead = (DataGridViewComboBoxCell)dgvSalaryPackage[dgvSalaryPackage.Columns["dgvcmbPayHead"].Index, e.RowIndex]; dgvccPayHead.DataSource = listObj[0]; dgvccPayHead.ValueMember = "payHeadId"; dgvccPayHead.DisplayMember = "payHeadName"; } } catch (Exception ex) { MessageBox.Show("SPC24" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill PayHead combobox /// </summary> public void PayHeadComboFill() { try { PayHeadBll BllPayHead = new PayHeadBll(); List<DataTable> listPayHead = BllPayHead.PayHeadViewAll(); DataRow dr = listPayHead[0].NewRow(); dr[2] = "All"; listPayHead[0].Rows.InsertAt(dr, 0); cmbPayHead.DataSource = listPayHead[0]; cmbPayHead.ValueMember = "payHeadId"; cmbPayHead.DisplayMember = "payHeadName"; } catch (Exception ex) { MessageBox.Show("PHR:1 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill PayHead combobox /// </summary> public void GridPayHeadFill() { try { PayHeadBll BllPayHead = new PayHeadBll(); List<DataTable> listObj = new List<DataTable>(); listObj = BllPayHead.PayHeadViewAll(); DataRow drrow = listObj[0].NewRow(); listObj[0].Rows.InsertAt(drrow, 0); dgvcmbPayHead.DataSource = listObj[0]; dgvcmbPayHead.ValueMember = "payHeadId"; dgvcmbPayHead.DisplayMember = "payHeadName"; } catch (Exception ex) { MessageBox.Show("SPC6" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }