/// <summary>
/// Method to update club member
/// </summary>
/// <param name="clubMember">club member</param>
/// <returns>true / false</returns>
public bool UpdateClubMember(ClubMemberModel clubMember)
{
using (OleDbCommand dbCommand = new OleDbCommand())
{
// Set the command object properties
dbCommand.Connection = new OleDbConnection(this.ConnectionString);
dbCommand.CommandType = CommandType.Text;
dbCommand.CommandText = Scripts.sqlUpdateClubMember;
// Add the input parameters to the parameter collection
dbCommand.Parameters.AddWithValue("@Name", clubMember.Name);
dbCommand.Parameters.AddWithValue("@DateOfBirth", clubMember.DateOfBirth.ToShortDateString());
dbCommand.Parameters.AddWithValue("@Occupation", (int)clubMember.Occupation);
dbCommand.Parameters.AddWithValue("@MaritalStatus", (int)clubMember.MaritalStatus);
dbCommand.Parameters.AddWithValue("@HealthStatus", (int)clubMember.HealthStatus);
dbCommand.Parameters.AddWithValue("@Salary", clubMember.Salary);
dbCommand.Parameters.AddWithValue("@NumberOfChildren", clubMember.NumberOfChildren);
dbCommand.Parameters.AddWithValue("@Id", clubMember.Id);
// Open the connection, execute the query and close the connection
dbCommand.Connection.Open();
var rowsAffected = dbCommand.ExecuteNonQuery();
dbCommand.Connection.Close();
return(rowsAffected > 0);
}
}
public string AddMember(ClubMemberModel clubmember)
{
try {
using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["socialclubdb"].ConnectionString))
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = Script.Insert;
command.Parameters.AddWithValue("@Name", clubmember.Name);
command.Parameters.AddWithValue("@DateOfBirth", (DateTime)clubmember.DateOfBirth);
command.Parameters.AddWithValue("@Occupation", clubmember.Occupation);
command.Parameters.AddWithValue("@Health", clubmember.Healthstatus);
command.Parameters.AddWithValue("@MaritialStatus", clubmember.MaritialStatus);
command.Parameters.AddWithValue("@NoOfChildren", clubmember.NumberOfchildren);
command.Parameters.AddWithValue("@Salary", clubmember.Salary);
command.Connection = con;
command.Connection.Open();
var rowsaffected = Convert.ToString(command.ExecuteNonQuery());
con.Close();
return(rowsaffected);
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// Method to add new member
/// </summary>
/// <param name="clubMember">club member model</param>
/// <returns>true or false</returns>
public bool AddClubMember(ClubMemberModel clubMember)
{
using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SocialClubDBConnection"].ConnectionString))
{
// Set the command object properties
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = Scripts.SqlInsertClubMember;
// Add the input parameters to the parameter collection
command.Parameters.AddWithValue("@Name", clubMember.Name);
command.Parameters.AddWithValue("@DateOfBirth", (DateTime)clubMember.DateOfBirth);
command.Parameters.AddWithValue("@Occupation", (int)clubMember.Occupation);
command.Parameters.AddWithValue("@MaritalStatus", (int)clubMember.MaritalStatus);
command.Parameters.AddWithValue("@HealthStatus", (int)clubMember.HealthStatus);
command.Parameters.AddWithValue("@Salary", clubMember.Salary);
command.Parameters.AddWithValue("@NumberOfChildren", clubMember.NumberOfChildren);
// Open the connection, execute the query and close the connection
command.Connection = con;
command.Connection.Open();
var rowsAffected = command.ExecuteNonQuery();
command.Connection.Close();
return(rowsAffected > 0);
}
}
public bool AddClubMember(ClubMemberModel clubMember)
{
DataTable dataTable = new DataTable();
OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter();
OleDbCommand addClubMember = new OleDbCommand();
OleDbConnection conn = new OleDbConnection();
addClubMember.Connection = conn;
addClubMember.CommandType = CommandType.Text;
addClubMember.CommandText = scripts.sqlInsertClubMember;
addClubMember.Parameters.AddWithValue("@Name", clubMember.Name);
addClubMember.Parameters.AddWithValue("@DateOfBirth", clubMember.DateOfBirth.ToShortDateString());
addClubMember.Parameters.AddWithValue("@Occupation", (int)clubMember.Occupation);
addClubMember.Parameters.AddWithValue("@MaritalStatus", (int)clubMember.MaritalStatus);
addClubMember.Parameters.AddWithValue("@HealthStatus", (int)clubMember.HealthStatus);
addClubMember.Parameters.AddWithValue("@Salary", clubMember.Salary);
addClubMember.Parameters.AddWithValue("@NumberOfChildren", clubMember.NumberOfChildren);
addClubMember.Connection.Open();
var rowsAffected = addClubMember.ExecuteNonQuery();
addClubMember.Connection.Close();
return(rowsAffected > 0);
}
private void btnRegister_Click(object sender, EventArgs e)
{
try {
if (this.Validation())
{
ClubMemberModel clubmember = new ClubMemberModel()
{
Id = 0,
Name = txtName.Text.Trim(),
DateOfBirth = dtdateTimePicker1.Value,
Occupation = (Occupation)cmbOccupation.SelectedValue,
Healthstatus = (Health)cmbHealth.SelectedValue,
MaritialStatus = (MaritialStatus)cmbMaritialStatus.SelectedValue,
NumberOfchildren = txtnoOofChildren.Text.Trim() == string.Empty ? 0 : Convert.ToInt16(txtnoOofChildren.Text),
Salary = txtSalary.Text.Trim() == string.Empty ? 0 : Convert.ToInt32(txtSalary.Text)
};
var Succes = this.clubmemberaccess.AddMember(clubmember);
if (Succes != "0")
{
MessageBox.Show("Ädded");
this.ResetAll();
}
else
{
MessageBox.Show(Succes);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Click event to update the data
/// </summary>
/// <param name="sender">sender object</param>
/// <param name="e">event args</param>
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (this.ValidateUpdate())
{
ClubMemberModel clubMemberModel = new ClubMemberModel()
{
Id = this.memberId,
Name = txt2Name.Text.Trim(),
DateOfBirth = dt2DateOfBirth.Value,
Occupation = (Occupation)cmb2Occupation.SelectedValue,
HealthStatus = (HealthStatus)cmb2HealthStatus.SelectedValue,
MaritalStatus = (MaritalStatus)cmb2MaritalStatus.SelectedValue,
Salary = txt2Salary.Text.Trim() == string.Empty ? 0 : Convert.ToDecimal(txt2Salary.Text),
NumberOfChildren = txt2NoOfChildren.Text.Trim() == string.Empty ? 0 : Convert.ToInt16(txt2NoOfChildren.Text)
};
var flag = this.clubMemberService.UpdateClubMember(clubMemberModel);
if (flag)
{
DataTable data = this.clubMemberService.GetAllClubMembers();
this.LoadDataGridView(data);
MessageBox.Show(
Resources.Update_Successful_Message,
Resources.Update_Successful_Message_Title,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show(
this.errorMessage,
Resources.Registration_Error_Message_Title,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
this.ShowErrorMessage(ex);
}
}
/// <summary>
/// Click event to handle registration
/// </summary>
/// <param name="sender">sender object</param>
/// <param name="e">event data</param>
private void Register_Click(object sender, EventArgs e)
{
try
{
// Check if the validation passes
if (this.ValidateRegistration())
{
// Assign the values to the model
ClubMemberModel clubMemberModel = new ClubMemberModel()
{
Id = 0,
Name = txtName.Text.Trim(),
DateOfBirth = dtDateOfBirth.Value,
Occupation = (Occupation)cmbOccupation.SelectedValue,
HealthStatus = (HealthStatus)cmbHealthStatus.SelectedValue,
MaritalStatus = (MaritalStatus)cmbMaritalStatus.SelectedValue,
Salary = txtSalary.Text.Trim() == string.Empty ? 0 : Convert.ToDecimal(txtSalary.Text),
NumberOfChildren = txtNoOfChildren.Text.Trim() == string.Empty ? 0 : Convert.ToInt16(txtNoOfChildren.Text)
};
// Call the service method and assign the return status to variable
var success = this.clubMemberService.RegisterClubMember(clubMemberModel);
// if status of success variable is true then display a information else display the error message
if (success)
{
// display the message box
MessageBox.Show(
Resources.Registration_Successful_Message,
Resources.Registration_Successful_Message_Title,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
// Reset the screen
this.ResetRegistration();
}
else
{
// display the error messge
MessageBox.Show(
Resources.Registration_Error_Message,
Resources.Registration_Error_Message_Title,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
else
{
// Display the validation failed message
MessageBox.Show(
this.errorMessage,
Resources.Registration_Error_Message_Title,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
this.ShowErrorMessage(ex);
}
}
/// <summary>
/// Service method to update club member
/// </summary>
/// <param name="clubMember">club member</param>
/// <returns>true / false</returns>
public bool UpdateClubMember(ClubMemberModel clubMember)
{
return(this.memberAccess.UpdateClubMember(clubMember));
}
/// <summary>
/// Service method to create new member
/// </summary>
/// <param name="clubMember">club member model</param>
/// <returns>true or false</returns>
public bool RegisterClubMember(ClubMemberModel clubMember)
{
return(this.memberAccess.AddClubMember(clubMember));
}
public bool AddClubMember(ClubMemberModel clubMember)
{
return(memberAccess.AddClubMember(clubMember));
}
