public int ChangePassword(ChangeAdminPassword changePassword)
{
Query = "UPDATE MainAdmin SET Password = @newPassword WHERE AdminId = @adminId AND Password = @oldPassword";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("newPassword", changePassword.NewPassword);
Command.Parameters.AddWithValue("adminId", changePassword.AdminId);
Command.Parameters.AddWithValue("oldPassword", changePassword.OldPassword);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public string ChangePassword(ChangeAdminPassword changePassword)
{
bool validOldPassword = aMainAdminGateway.IsAdminOldPasswordValid(changePassword.AdminId, changePassword.OldPassword);
if (validOldPassword)
{
int rowAffected = aMainAdminGateway.ChangePassword(changePassword);
if (rowAffected > 0)
{
return("Success");
}
else
{
return("Password changing failed.");
}
}
else
{
return("Given old password is wrong. Please try again!");
}
}
