private void SellsEntry_Load(object sender, EventArgs e) { fillData.fillDataGridView(this.sellsEntryDataGridView, goodsDetailQueryString, this.columnNameToDisplay, this.columnIndexToHide); sellsEntryCutomerComboBox.Items.Clear(); sellsEntryItemComboBox.Items.Clear(); try { FillFormWithData comboboxDataReader = new FillFormWithData(); MySqlDataReader reader1 = comboboxDataReader.getDataInComboBox("customer_data", "CUST_ID,CUST_FNAME,CUST_LNAME,CUST_AREA,CUST_DISTRICT"); MySqlDataReader reader2 = comboboxDataReader.getDataInComboBox("item_details", "ITEM_NAME"); if (!(reader1.HasRows)) { sellsEntryCutomerComboBox.Items.Add("Not Present In Database"); } if (!(reader2.HasRows)) { sellsEntryItemComboBox.Items.Add("Not Present In Database"); } while (reader1.Read()) { sellsEntryCutomerComboBox.Items.Add(new ComboBoxItem(reader1.GetString("CUST_FNAME") + " " + reader1.GetString("CUST_LNAME") + " " + helper.nullToEmpty(reader1.GetString("CUST_AREA") + " " + reader1.GetString("CUST_DISTRICT")), reader1.GetString("CUST_ID"))); } while (reader2.Read()) { sellsEntryItemComboBox.Items.Add(reader2.GetString("ITEM_NAME")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void GoodsEntry_Load(object sender, EventArgs e) { SetToolTip(); goodsEntryTradercomboBox.Items.Clear(); goodsEntryItemcomboBox.Items.Clear(); try { FillFormWithData comboboxDataReader = new FillFormWithData(); MySqlDataReader reader1 = comboboxDataReader.getDataInComboBox("trader_info", "TRDR_ID,TRDR_FNAME,TRDR_TMARK"); MySqlDataReader reader2 = comboboxDataReader.getDataInComboBox("item_details", "ITEM_NAME"); if (!(reader1.HasRows)) { goodsEntryTradercomboBox.Items.Add("Not Present In Database"); } if (!(reader2.HasRows)) { goodsEntryItemcomboBox.Items.Add("Not Present In Database"); } while (reader1.Read()) { goodsEntryTradercomboBox.Items.Add(new ComboBoxItem(reader1.GetString("TRDR_FNAME") + helper.nullToEmpty(reader1.GetString("TRDR_TMARK")), reader1.GetString("TRDR_ID"))); } while (reader2.Read()) { goodsEntryItemcomboBox.Items.Add(reader2.GetString("ITEM_NAME")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void AddArea_Load(object sender, EventArgs e) { try { FillFormWithData comboboxDataReader = new FillFormWithData(); MySqlDataReader reader = comboboxDataReader.getDataInComboBox("state", "STATE_NAME"); while (reader.Read()) { addAreaStatecomboBox.Items.Add(reader.GetString("STATE_NAME")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void custStateComboBox_DropDown(object sender, EventArgs e) { errorProvider1.Clear(); custStateComboBox.Items.Clear(); try { FillFormWithData comboboxDataReader = new FillFormWithData(); MySqlDataReader reader = comboboxDataReader.getDataInComboBox("state", "STATE_NAME"); while (reader.Read()) { custStateComboBox.Items.Add(reader.GetString("STATE_NAME")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void custDistrictComboBox_SelectedIndexChanged(object sender, EventArgs e) { errorProvider1.Clear(); distSelected = custDistrictComboBox.SelectedItem.ToString(); custAreaComboBox.Items.Clear(); try { FillFormWithData comboboxDataReader = new FillFormWithData(); MySqlDataReader reader = comboboxDataReader.getDataInComboBox("area", "AREA_NAME", "STATE_NAME", stateSelected, "DISTRICT_NAME", distSelected); while (reader.Read()) { custAreaComboBox.Items.Add(reader.GetString("AREA_NAME")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void AddTraderFrm_Load(object sender, EventArgs e) { try { FillFormWithData comboboxDataReader = new FillFormWithData(); MySqlDataReader reader = comboboxDataReader.getDataInComboBox("state", "STATE_NAME"); if (!(reader.HasRows)) { traderStateComboBox.Items.Add("Not Found In Databases"); } while (reader.Read()) { traderStateComboBox.Items.Add(reader.GetString("STATE_NAME")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void AddItem_Load(object sender, EventArgs e) { try { FillFormWithData comboboxDataReader = new FillFormWithData(); MySqlDataReader reader = comboboxDataReader.getDataInComboBox("product_category", "PRODUCT_CATEGORY_NAME"); if (!(reader.HasRows)) { addItemCategorycomboBox.Items.Add("Not Found In Databases"); } while (reader.Read()) { addItemCategorycomboBox.Items.Add(reader.GetString("PRODUCT_CATEGORY_NAME")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void traderStateComboBox_SelectedIndexChanged(object sender, EventArgs e) { errorProvider1.Clear(); stateSelected = traderStateComboBox.SelectedItem.ToString(); traderDistComboBox.Items.Clear(); try { FillFormWithData comboboxDataReader = new FillFormWithData(); MySqlDataReader reader = comboboxDataReader.getDataInComboBox("district", "DISTRICT_NAME", "STATE_NAME", stateSelected); if (!(reader.HasRows)) { traderDistComboBox.Items.Add("Not Found In Databases"); } while (reader.Read()) { traderDistComboBox.Items.Add(reader.GetString("DISTRICT_NAME")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }