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