public static void addSurety(SuretyModel surety)
{
DBConnection.OpenConnection();
SqlCommand command = new SqlCommand();
command.Connection = DBConnection.ConnectionString;
command.CommandText = "INSERT INTO [Surety]([name], [address], [tel]) VALUES(@Sname, @Saddress, @Stel);";
command.Parameters.AddWithValue("@Sname", surety.Name);
command.Parameters.AddWithValue("@Saddress", surety.Address);
command.Parameters.AddWithValue("@Stel", surety.Tel);
command.ExecuteNonQuery();
DBConnection.CloseConnection();
}
private void addButton_Click(object sender, EventArgs e)
{
if (!validate())
{
return;
}
MemberModel member = new MemberModel()
{
MemberNo = memberNoTextBox.Text,
Name = nameTextBox.Text,
Address = addressTextBox.Text,
RegDate = regDatePicker.Value,
Gender = GenderClass.getGenderType(genderComboBox.SelectedIndex),
Nic = nicMaskedTextBox.Text,
Dob = dobDatePicker.Value,
Tel = telMaskedTextBox.Text,
};
SuretyModel surety = new SuretyModel()
{
Name = suretyNameTextBox.Text,
Address = suretyAddressTextBox.Text,
Tel = suretyTelMaskedTexBox.Text
};
try
{
MemberController.addMemberSurety(member, surety);
MessageBox.Show("Member is successfully entered.", "Add Member",
MessageBoxButtons.OK, MessageBoxIcon.Information
);
initDefault();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
public static void addMemberSurety(MemberModel member, SuretyModel surety)
{
SuretyController.addSurety(surety);
DBConnection.OpenConnection();
SqlCommand command = new SqlCommand();
command.Connection = DBConnection.ConnectionString;
#region Get Surety No
command.CommandText = "SELECT MAX(suretyID) FROM Surety;";
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
surety.SuretyID = reader.GetInt32(0);
}
reader.Close();
#endregion
DBConnection.CloseConnection();
addMember(member, surety.SuretyID);
}
