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