/**
* Method to update managers profile
*/
public void managerUpdateProfile(Staff memberToChange, String FirstName, String LastName, DateTime birthDate, String address, String email, double salary, int hoursAvailable, int roleID, int DepartmentID, Contract contract)
{
MySqlConnection conn = new MySqlConnection(connString);
// Open connection
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE person SET Firstname = @FirstN, Lastname = @LastN, Age = @Age, Address = @Address, Email = @Email, Salary = @Salary," +
"HoursAvailable = @HoursAvailable, IsAvailable = @IsAvailable, RoleID = @RoleID, DepartmentID = @DepartmentID, ContractID = @ContractID WHERE Id = @PersonID";
cmd.Parameters.AddWithValue("@PersonID", memberToChange.dbID);
cmd.Parameters.AddWithValue("@FirstN", FirstName);
cmd.Parameters.AddWithValue("@LastN", LastName);
cmd.Parameters.AddWithValue("@Age", birthDate);
cmd.Parameters.AddWithValue("@Address", address);
cmd.Parameters.AddWithValue("@Email", email);
cmd.Parameters.AddWithValue("@Salary", salary);
cmd.Parameters.AddWithValue("@HoursAvailable", hoursAvailable);
cmd.Parameters.AddWithValue("@IsAvailable", "Yes");
//cmd.Parameters.AddWithValue("@Passcode", passcode);
cmd.Parameters.AddWithValue("@RoleID", roleID);
cmd.Parameters.AddWithValue("@DepartmentID", DepartmentID);
cmd.Parameters.AddWithValue("@ContractID", contract);
cmd.ExecuteNonQuery();
memberToChange.editStaffMember(FirstName, LastName, birthDate, address, email);
}
/**
* Method to edit staff meber
*/
private void btnEditStaff_Click(object sender, EventArgs e)
{
ReadInfoFromForm();
//int passcode = Convert.ToInt32(txtBoxPasscode.Text);
dataBase.managerUpdateProfile(staffMember, FirstName, LastName, birthDate, address, email, salary, hoursAvailable, roleID, DepartmentID, contract);
staffMember.editStaffMember(FirstName, LastName, birthDate, address, email, salary, hoursAvailable, role, contract);
MessageBox.Show("Staff member edited successfully");
this.Close();
}
/**
* Method to user update profile
*/
public void updateProfile(Staff memberToChange, String FirstName, String LastName, DateTime birthDate, String address, String email)
{
MySqlConnection conn = new MySqlConnection(connString);
// Open connection
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE person SET Firstname = @Firstname, Lastname = @Lastname, Age = @Age, Address = @Address, Email = @Email WHERE Id = @Id";
cmd.Parameters.AddWithValue("@Firstname", FirstName);
cmd.Parameters.AddWithValue("@Lastname", LastName);
cmd.Parameters.AddWithValue("@Age", birthDate);
cmd.Parameters.AddWithValue("@Address", address);
cmd.Parameters.AddWithValue("@Email", email);
cmd.Parameters.AddWithValue("@Id", memberToChange.dbID);
cmd.ExecuteNonQuery();
memberToChange.editStaffMember(FirstName, LastName, birthDate, address, email);
}