private void AddDonations_Click(object sender, EventArgs e)
{
//insert Members
Donation donation = new Donation();
donation.EnvelopeNo = int.Parse(txtDonationEnvNum.Text);
donation.FundNumber = int.Parse(txtDonationsFundNum.Text);
donation.Fundamount = float.Parse(txtDonationsFundAmt.Text);
donation.MoneyType = txtDonMoneyType.Text;
donation.Description = txtDonationsSpecDesc.Text;
donationsData.insertDonation(donation);
this.Close();
}
//------------------------------Donations------------------------------
public void insertDonation(Donation donation)
{
try
{
string cmdText = "INSERT INTO dbo.Donation(EnvelopeNumber,FundID,Amount,MoneyType,Description) VALUES(@EnvelopeNumber,@FundID,@Amount,@MoneyType,@Description)";
SqlCommand cmd = new SqlCommand(cmdText, connection);
//cmd.Parameters.AddWithValue("@FundID", funds.FundNumber);
//cmd.Parameters.AddWithValue("@DonationID", donation.DonationID);
cmd.Parameters.AddWithValue("@EnvelopeNumber", donation.EnvelopeNo);
cmd.Parameters.AddWithValue("@FundID", donation.FundNumber);
cmd.Parameters.AddWithValue("@Amount", donation.Fundamount);
cmd.Parameters.AddWithValue("@MoneyType", donation.MoneyType);
cmd.Parameters.AddWithValue("@Description", donation.Description);
connection.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
