public void LoadVendors() { AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection(); var dbconnect = new dbconnector(); using (MySqlConnection conn = connect.connector()) { conn.Open(); String getCustomer = "SELECT SUPPLIERNAME FROM SUPPLIER "; MySqlCommand comm = new MySqlCommand(getCustomer, conn); comm.CommandText = getCustomer; MySqlDataReader drd = comm.ExecuteReader(); if (drd.HasRows == true) { while (drd.Read()) { namesCollection.Add(drd["SUPPLIERNAME"].ToString()); } } drd.Close(); conn.Close(); vendorName.AutoCompleteMode = AutoCompleteMode.SuggestAppend; vendorName.AutoCompleteSource = AutoCompleteSource.CustomSource; vendorName.AutoCompleteCustomSource = namesCollection; } }
public void readdata() { using (MySqlConnection conn = connect.connector()) { string query = "SELECT NAME, IDMINVENTORY, QUANTITY FROM MENUITEM, MINVENTORY WHERE ID = PRODUCT_ID"; dt = new DataTable(); adapter = new MySqlDataAdapter(query, conn); adapter.Fill(dt); datagridview_inventory.DataSource = dt; } datagridview_inventory.Columns["idmInventory"].Visible = false; datagridview_inventory.Columns["name"].HeaderText = "Item Name"; datagridview_inventory.Columns["quantity"].HeaderText = "Quantity"; }
private void updateinventory() { var dbconnect = new dbconnector(); using (dbconnection = dbconnect.connector()) { using (var command = new MySqlCommand("UPDATE minventory SET quantity = @quantity WHERE idmInventory = @ayd;", dbconnection)) { dbconnection.Open(); command.Parameters.AddWithValue("@quantity", quantityadd()); command.Parameters.AddWithValue("@ayd", inventoryid); command.ExecuteNonQuery(); } } }
private void stockout() { var dbconnect = new dbconnector(); using (dbconnection = dbconnect.connector()) { dbconnection.Open(); using (var com = new MySqlCommand("INSERT INTO mstkout(idmInventory, quantity, stockout_date) VALUES(@inventoryid, @quantity, @date)", dbconnection)) { com.Parameters.AddWithValue("@inventoryid", inventoryid); com.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); com.Parameters.AddWithValue("@quantity", textBox2.Text); com.ExecuteNonQuery(); } } }
private void viewproducts_Load(object sender, EventArgs e) { using (MySqlConnection conn = connect.connector()) { string query = "SELECT * FROM menuitem WHERE status = 0"; dt = new DataTable(); adapter = new MySqlDataAdapter(query, conn); adapter.Fill(dt); dtgvarc.DataSource = dt; dtgvarc.Columns["id"].Visible = false; dtgvarc.Columns["status"].Visible = false; dtgvarc.Columns["name"].HeaderText = "Name"; dtgvarc.Columns["sell_price"].HeaderText = "Sell Price"; dtgvarc.Columns["cost_price"].HeaderText = "Cost Price"; } }
public void readdata() { using (MySqlConnection conn = connect.connector()) { //string query = "SELECT idmInventory, mInventorycol, stock_in_date, product_id, stock_out_date, quantity, status FROM minventory, menu_item WHERE minventory.status = 1 and menu_item.id = '" + Inventorymgt.inventoryid +"'"; string query = "select * from mstkout"; dt = new DataTable(); adapter = new MySqlDataAdapter(query, conn); adapter.Fill(dt); datagridview_stockout.DataSource = dt; datagridview_stockout.Columns["idmstkout"].Visible = false; datagridview_stockout.Columns["idmInventory"].Visible = false; datagridview_stockout.Columns["stockout_date"].HeaderText = "Stock Out Date"; datagridview_stockout.Columns["quantity"].HeaderText = "Quantity"; datagridview_stockout.Columns["mstkoutcol"].Visible = false; } }
public void supp() { using (MySqlConnection conn = connect.connector()) { String query = "SELECT supplierName FROM supplier"; MySqlCommand comm = new MySqlCommand(query, conn); comm.CommandText = query; conn.Open(); MySqlDataReader drd = comm.ExecuteReader(); cmbSup.Items.Clear(); while (drd.Read()) { cmbSup.Items.Add(drd["supplierName"].ToString()); } conn.Close(); } }