public int addYield(MySqlConnection conn, Yield yield) { string addYield = "INSERT INTO yield (yieldType, quantity, storageUnitName, storageCapacity)" + "VALUES ('" + yield.YieldType + "', '" + yield.Quantity + "', '" + yield.StorageUnitName + "')"; MySqlCommand sqlComm = new MySqlCommand(addYield, conn); return(sqlComm.ExecuteNonQuery()); }
private void btnSave_Click(object sender, EventArgs e) { conn.connect(); Yield yield = new Yield(); yield.YieldType = textBoxYType.Text; yield.Quantity = Decimal.Parse(numYQuantity.Value.ToString()); yield.StorageUnitName = comboBoxStrUName.Text; YieldHandler yHandlr = new YieldHandler(); yHandlr.addYield(conn.getConn(), yield); MessageBox.Show("Yield Added!"); this.Close(); }