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