public UserDetailsResponseDTO GetUserById(int userId)
{
var userDetailsResponse = new UserDetailsResponseDTO();
userDetailsResponse.UserDetails = new List <UserDetailsDTO>();
using (SqlConnection con = new SqlConnection(CS))
{
var cmd = new SqlCommand("Select * from [dbo].[USER] u where u.id = @userId", con);
cmd.Parameters.AddWithValue("@userId", userId);
cmd.CommandType = CommandType.Text;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
var userDetails = new UserDetailsDTO();
userDetails.Name = rdr["NAME"].ToString();
userDetails.Email = rdr["EMAIL"].ToString();
userDetails.MobileNo = Convert.ToInt32(rdr["MOBILENO"]);
userDetails.UserRole = rdr["USERROLEID"].ToString();
userDetails.UserStatus = rdr["USERSTATUSID"].ToString();
userDetailsResponse.UserDetails.Add(userDetails);
}
return(userDetailsResponse);
}
}
public void UserCanViewTheirCurrentDetails()
{
var userDetails = new UserDetailsResponseDTO { Id = Guid.NewGuid(), Username = "******", Name = "John Polling", Email = "*****@*****.**" };
var authenticatedUser = new AuthenticatedUserDTO
{Id = Guid.NewGuid(), Type = UserType.Administrator};
var fields = new List<FormField>
{
new FormField {Id = "Id"},
new FormField {Id = "Username"},
new FormField {Id = "Name"},
new FormField {Id = "Email"}
};
Context.Session["user"] = authenticatedUser;
With.Mocks(mockery)
.Expecting(() =>
{
Expect.Call(userService.LoadDetails(authenticatedUser.Id)).Return(userDetails);
Expect.Call(() => readerService.ReadViewModelProperties());
Expect.Call(readerService.FormFields).Return(fields);
})
.Verify(() => controller.Show());
Assert.AreEqual(userDetails, controller.PropertyBag["details"]);
Assert.AreEqual(fields, controller.PropertyBag["fields"]);
Assert.AreEqual("/Shared/Form", controller.SelectedViewName);
}
public UserDetailsResponseDTO GetUserById(int userId)
{
UserRepository userRepo = new UserRepository();
UserDetailsResponseDTO UserDetailsResponse = new UserDetailsResponseDTO();
var response = userRepo.GetUserById(userId);
if (response != null)
{
return(response);
}
return(UserDetailsResponse);
}
public UserDetailsResponseDTO GetAllUsers()
{
UserRepository userRepo = new UserRepository();
var UserDetailsResponse = new UserDetailsResponseDTO();
var response = userRepo.GetAllUsers();
if (response != null)
{
return(response);
}
return(UserDetailsResponse);
}
