/// <summary> /// Function to use the Items Combo Fill /// </summary> public void ItemComboFill() { try { ProductCreationBll BllProductCreation = new ProductCreationBll(); List<DataTable> listObj = new List<DataTable>(); listObj = BllProductCreation.ProductViewAll(); cmbItem.DataSource = listObj[0]; cmbItem.ValueMember = "productId"; cmbItem.DisplayMember = "productName"; } catch (Exception ex) { MessageBox.Show("POS:17" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// To remove the selected product from the list in combo box /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvProductBOM_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { try { List<DataTable> listObj = new List<DataTable>(); ProductCreationBll BllProductCreation = new ProductCreationBll(); if (dgvProductBOM.CurrentCell.ColumnIndex == dgvProductBOM.Columns["dgvcmbRawMaterial"].Index) { if (isCallFromProductCreation) { listObj = BllProductCreation.ProductViewAllWithoutOneProduct(decProductIdForEdit); } else { listObj = BllProductCreation.ProductViewAll(); } if (listObj[0].Rows.Count > 0) { if (dgvProductBOM.RowCount > 1) { int inGridRowCount = dgvProductBOM.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 (dgvProductBOM.Rows[inI].Cells["dgvcmbRawMaterial"].Value != null && dgvProductBOM.Rows[inI].Cells["dgvcmbRawMaterial"].Value.ToString() != "") { if (listObj[0].Rows[inJ]["productId"].ToString() == dgvProductBOM.Rows[inI].Cells["dgvcmbRawMaterial"].Value.ToString()) { listObj[0].Rows.RemoveAt(inJ); break; } } } } } } DataGridViewComboBoxCell dgvccProductBom = (DataGridViewComboBoxCell)dgvProductBOM[dgvProductBOM.Columns["dgvcmbRawMaterial"].Index, e.RowIndex]; dgvccProductBom.DataSource = listObj[0]; DataRow drow = listObj[0].NewRow(); drow["productName"] = string.Empty; drow["productId"] = 0; listObj[0].Rows.InsertAt(drow, 0); dgvccProductBom.ValueMember = "productId"; dgvccProductBom.DisplayMember = "productName"; } } } catch (Exception ex) { MessageBox.Show("PB:28" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Fill the product name and the code for auto completeion /// </summary> /// <param name="isProductName"></param> /// <param name="editControl"></param> public void FillProducts(bool isProductName, DataGridViewTextBoxEditingControl editControl) { ProductCreationBll BllProductCreation = new ProductCreationBll(); try { List<DataTable> listObjProducts = new List<DataTable>(); listObjProducts = BllProductCreation.ProductViewAll(); ProductNames = new AutoCompleteStringCollection(); ProductCodes = new AutoCompleteStringCollection(); foreach (DataRow dr in listObjProducts[0].Rows) { ProductNames.Add(dr["productName"].ToString()); ProductCodes.Add(dr["productCode"].ToString()); } } catch (Exception ex) { MessageBox.Show("SI: 61" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// RawMaterialComboFill function /// </summary> public void RawMaterialComboFill() { try { List<DataTable> listObj = new List<DataTable>(); ProductCreationBll BllProductCreation = new ProductCreationBll(); if (isCallFromProductCreation) { listObj = BllProductCreation.ProductViewAllWithoutOneProduct(decProductIdForEdit); dgvcmbRawMaterial.DataSource = listObj[0]; DataRow drow = listObj[0].NewRow(); drow["productName"] = string.Empty; drow["productId"] = 0; listObj[0].Rows.InsertAt(drow, 0); dgvcmbRawMaterial.DisplayMember = "productName"; dgvcmbRawMaterial.ValueMember = "productId"; } else { listObj = BllProductCreation.ProductViewAll(); DataRow drow = listObj[0].NewRow(); drow["productName"] = string.Empty; drow["productId"] = 0; listObj[0].Rows.InsertAt(drow, 0); dgvcmbRawMaterial.DataSource = listObj[0]; dgvcmbRawMaterial.DisplayMember = "productName"; dgvcmbRawMaterial.ValueMember = "productId"; } } catch (Exception ex) { MessageBox.Show("PB:3" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }