/// <summary> /// Function to fill unit combobox /// </summary> public void UnitComboFill() { try { UnitSP spUnit = new UnitSP(); DataTable dtblUnit = new DataTable(); dtblUnit = spUnit.UnitViewAll(); dgvcmbConsumptionunitId.DataSource = dtblUnit; dgvcmbConsumptionunitId.ValueMember = "unitId"; dgvcmbConsumptionunitId.DisplayMember = "unitName"; dgvcmbProductionunitId.DataSource = dtblUnit; dgvcmbProductionunitId.ValueMember = "unitId"; dgvcmbProductionunitId.DisplayMember = "unitName"; } catch (Exception ex) { MessageBox.Show("SJ:21" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Grid Unit combofill, all are the unit fill here /// </summary> public void DgvUnitComboFill() { try { UnitSP spUnit = new UnitSP(); DataTable dtblUnit = new DataTable(); dtblUnit = spUnit.UnitViewAll(); dgvtxtSalesInvoicembUnitName.DataSource = dtblUnit; dgvtxtSalesInvoicembUnitName.ValueMember = "unitId"; dgvtxtSalesInvoicembUnitName.DisplayMember = "unitName"; } catch (Exception ex) { MessageBox.Show("SI: 24" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Unit combo fill /// </summary> public void DGVUnitComboFill() { try { UnitSP spUnit = new UnitSP(); DataTable dtblUnit = new DataTable(); dtblUnit = spUnit.UnitViewAll(); dgvcmbUnit.DataSource = dtblUnit; DataRow dr = dtblUnit.NewRow(); dr[2] = "NA"; dtblUnit.Rows.InsertAt(dr, 0); dgvcmbUnit.ValueMember = "unitId"; dgvcmbUnit.DisplayMember = "unitName"; } catch (Exception ex) { MessageBox.Show("SQ:07" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill unit combobox in grid /// </summary> public void UnitComboFill() { try { DataTable dtbl = new DataTable(); UnitSP spUnit = new UnitSP(); dtbl = spUnit.UnitViewAll(); cmbUnit.DataSource = dtbl; cmbUnit.DisplayMember = "unitName"; cmbUnit.ValueMember = "unitId"; cmbUnit.SelectedValue = -1; } catch (Exception ex) { MessageBox.Show("PC:52" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill DataGridView Unit combobox /// </summary> public void DGVUnitComboFill() { TransactionsGeneralFill TransactionGeneralFillObj = new TransactionsGeneralFill(); try { UnitSP spUnit = new UnitSP(); DataTable dtblUnit = new DataTable(); dtblUnit = spUnit.UnitViewAll(); dgvcmbUnit.DataSource = dtblUnit; dgvcmbUnit.ValueMember = "unitId"; dgvcmbUnit.DisplayMember = "unitName"; } catch (Exception ex) { MessageBox.Show("PR:07" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }