/// <summary> /// On cell begin edit of dgvMultipleUnit /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvMultipleUnit_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { try { UnitBll bllUnit = new UnitBll(); List<DataTable> ListObj = new List<DataTable>(); if (dgvMultipleUnit.CurrentCell.ColumnIndex == dgvMultipleUnit.Columns["dgvcmbmultipleunit"].Index) { ListObj = bllUnit.UnitViewAllWithoutPerticularId(decUnitIdExcludeToFillCombo); if (ListObj[0].Rows.Count > 0) { if (dgvMultipleUnit.RowCount > 1) { int inGridRowCount = dgvMultipleUnit.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 (dgvMultipleUnit.Rows[inI].Cells["dgvcmbmultipleunit"].Value != null && dgvMultipleUnit.Rows[inI].Cells["dgvcmbmultipleunit"].Value.ToString() != "") { if (ListObj[0].Rows[inJ]["unitId"].ToString() == dgvMultipleUnit.Rows[inI].Cells["dgvcmbmultipleunit"].Value.ToString()) { ListObj[0].Rows.RemoveAt(inJ); break; } } } } } } DataGridViewComboBoxCell dgvccProductMultipleUnit = (DataGridViewComboBoxCell)dgvMultipleUnit[dgvMultipleUnit.Columns["dgvcmbmultipleunit"].Index, e.RowIndex]; DataRow drow = ListObj[0].NewRow(); drow["unitName"] = string.Empty; drow["unitId"] = 0; ListObj[0].Rows.InsertAt(drow, 0); dgvccProductMultipleUnit.DataSource = ListObj[0]; dgvccProductMultipleUnit.ValueMember = "unitId"; dgvccProductMultipleUnit.DisplayMember = "unitName"; } } } catch (Exception ex) { MessageBox.Show("PMU:29" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill the unit combobox /// </summary> /// <param name="decId"></param> public void UnitComboFill(decimal decId) { try { List<DataTable> ListObj = new List<DataTable>(); UnitBll bllUnit = new UnitBll(); ListObj = bllUnit.UnitViewAllWithoutPerticularId(decId); dgvcmbmultipleunit.DataSource = ListObj[0]; DataRow drow = ListObj[0].NewRow(); drow["unitName"] = string.Empty; drow["unitId"] = 0; ListObj[0].Rows.InsertAt(drow, 0); dgvcmbmultipleunit.DisplayMember = "unitName"; dgvcmbmultipleunit.ValueMember = "unitId"; } catch (Exception ex) { MessageBox.Show("PMU:2" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }