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);
}
}
