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