public void resetClientNameComboBox() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String sqlCommand = "Select SPLR_NAME, SPLR_ID FROM merp.suppliers"; cmd.CommandText = sqlCommand; MySqlDataAdapter da = new MySqlDataAdapter(sqlCommand, Varibles.getConnection()); DataSet ds = new DataSet(); da.Fill(ds); cmd.ExecuteNonQuery(); supplierNameComboBox.DisplayMember = "SPLR_NAME"; supplierNameComboBox.ValueMember = "SPLR_ID"; supplierNameComboBox.DataSource = ds.Tables[0]; supplierNameComboBox.AutoCompleteMode = AutoCompleteMode.Suggest; supplierNameComboBox.AutoCompleteSource = AutoCompleteSource.ListItems; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void fillProdTypes() { try { String sqlCommand = "SELECT PRDTYP_ID, PRDTYP_NAME FROM merp.prod_types"; cmd.CommandText = sqlCommand; MySqlDataAdapter da = new MySqlDataAdapter(sqlCommand, Varibles.getConnection()); DataSet ds = new DataSet(); da.Fill(ds); cmd.ExecuteNonQuery(); cmbbx_ProdType.DisplayMember = "PRDTYP_NAME"; cmbbx_ProdType.ValueMember = "PRDTYP_ID"; cmbbx_ProdType.DataSource = ds.Tables[0]; cmbbx_ProdType.AutoCompleteMode = AutoCompleteMode.Suggest; cmbbx_ProdType.AutoCompleteSource = AutoCompleteSource.ListItems; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void fillTreasuryEntryTypes() { try { Varibles.setConnection(); cmd = Varibles.getCommand(); String sqlCommand = "SELECT TRTYPE_ID, TRTYPE_NAME FROM merp.treasury_op_type"; cmd.CommandText = sqlCommand; MySqlDataAdapter da = new MySqlDataAdapter(sqlCommand, Varibles.getConnection()); DataSet ds = new DataSet(); da.Fill(ds); cmd.ExecuteNonQuery(); cmb_TEType.DisplayMember = "TRTYPE_NAME"; cmb_TEType.ValueMember = "TRTYPE_ID"; cmb_TEType.DataSource = ds.Tables[0]; // cmb_TEType.AutoCompleteMode = AutoCompleteMode.Suggest; // cmb_TEType.AutoCompleteSource = AutoCompleteSource.ListItems; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Varibles.closeConnection(); } }
private void FilterByInvTypeAllAndReturnSaleOnly() { DateTime date1 = new DateTime(dtp_from.Value.Year, dtp_from.Value.Month, dtp_from.Value.Day, 0, 0, 0); DateTime date2 = new DateTime(dtp_to.Value.Year, dtp_to.Value.Month, dtp_to.Value.Day, 23, 59, 59); try { String query = "SELECT INVLOG_PROD_ID, PRD_NAME, PRDTYP_NAME, PRD_WHLSALEPRICE, " + "PRD_SCTRPRICE, PRD_BUYPRICE, INVLOG_DATE, INVLOG_DESC, " + "INVLOG_OUTCOUNT, INVLOG_INCOUNT, INVLOG_INV_ID , current_buy_price , current_sell_price " + " FROM merp.inventory_log, merp.products, merp.prod_types , merp.invoices " + "WHERE INVLOG_PROD_ID = PRD_ID AND PRD_TYPE_ID = PRDTYP_ID AND inventory_log.INVLOG_INV_ID = invoices.INV_ID AND inventory_log.invoice_type = invoices.INV_TYPE_ID AND inventory_log.invoice_type = '" + SellReturnType + "'AND INVLOG_DATE >= '" + date1.ToString("yyyy-MM-dd HH:mm:ss") + "' AND INVLOG_DATE <= '" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "' ORDER BY INVLOG_DATE ASC "; cmd.CommandText = query; MySqlDataAdapter da = new MySqlDataAdapter(query, Varibles.getConnection()); DataSet ds = new DataSet(); da.Fill(ds); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void fillprodNames() { try { int prodTypeID = Convert.ToInt32(this.cmbbx_ProdType.SelectedValue); String sqlCommand = "SELECT PRD_ID, PRD_NAME, PRDTYP_NAME, PRD_BALANCE, PRD_WHLSALEPRICE, PRD_SCTRPRICE, PRD_BUYPRICE, merp.prod_types.is_supplies " + " FROM merp.products , merp.prod_types WHERE PRDTYP_ID = PRD_TYPE_ID AND PRD_TYPE_ID = " + prodTypeID; cmd.CommandText = sqlCommand; MySqlDataAdapter da = new MySqlDataAdapter(sqlCommand, Varibles.getConnection()); DataSet ds = new DataSet(); da.Fill(ds); cmd.ExecuteNonQuery(); cmbbx_ProdName.DisplayMember = "PRD_NAME"; cmbbx_ProdName.ValueMember = "PRD_ID"; cmbbx_ProdName.DataSource = ds.Tables[0]; cmbbx_ProdName.AutoCompleteMode = AutoCompleteMode.Suggest; cmbbx_ProdName.AutoCompleteSource = AutoCompleteSource.ListItems; cmbbx_ProdName.SelectedIndex = -1; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void fillProdTypes() { /* * cmbbx_ProdType.Items.Clear(); * * String query = "SELECT PRDTYP_ID, PRDTYP_NAME FROM merp.prod_types"; * cmd.CommandText = query; * * reader = cmd.ExecuteReader(); * * * * * while (reader.Read()) * { * * * prodTypes.Add(new ComboboxItem(reader.GetString(1), reader.GetInt32(0))); * * //cmbbx_NewProdType.Items.Add(item); * } * reader.Close(); * */ try { String sqlCommand = "SELECT PRDTYP_ID, PRDTYP_NAME FROM merp.prod_types"; cmd.CommandText = sqlCommand; MySqlDataAdapter da = new MySqlDataAdapter(sqlCommand, Varibles.getConnection()); DataSet ds = new DataSet(); da.Fill(ds); cmd.ExecuteNonQuery(); cmbbx_ProdType.DisplayMember = "PRDTYP_NAME"; cmbbx_ProdType.ValueMember = "PRDTYP_ID"; cmbbx_ProdType.DataSource = ds.Tables[0]; cmbbx_ProdType.AutoCompleteMode = AutoCompleteMode.Suggest; cmbbx_ProdType.AutoCompleteSource = AutoCompleteSource.ListItems; } catch (Exception ex) { MessageBox.Show(ex.Message); } }