private void btnAddMember_Click(object sender, EventArgs e)
{
frmMembers objfrmMemberToAdd = new frmMembers(ThefrmMain);
//insert Members
Member member = new Member();
member.EnvelopeNo = int.Parse(txtEnvelopeNumber.Text);
member.LastName = txtLastName.Text;
member.FirstName = txtFirstName.Text;
member.Address = txtAddress.Text;
member.City = txtCity.Text;
member.Zip = int.Parse(txtZip.Text);
member.Email = txtEmail.Text;
membersData.insertMembers(member);
this.Close();
}
//------------------------Members----------------------------------
public void insertMembers(Member member)
{
try
{
string cmdText = "INSERT INTO dbo.Donor(EnvelopeNumber,LastName,FirstName,Address,City,Zip,email) VALUES(@EnvelopeNumber,@LastName,@FirstName,@Address,@City,@Zip,@email)";
SqlCommand cmd = new SqlCommand(cmdText, connection);
cmd.Parameters.AddWithValue("@EnvelopeNumber", member.EnvelopeNo);
cmd.Parameters.AddWithValue("@LastName", member.LastName);
cmd.Parameters.AddWithValue("@FirstName", member.FirstName);
cmd.Parameters.AddWithValue("@Address", member.Address);
cmd.Parameters.AddWithValue("@City", member.City);
cmd.Parameters.AddWithValue("@Zip", member.Zip);
cmd.Parameters.AddWithValue("@email", member.Email);
connection.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
