public ApplicationUser GetUser(LoginViewModelParam param)
{
var result = new ApplicationUser();
try
{
using (SqlConnection conn = _connectionHelper.DefaultConnectionDB())
{
using (SqlCommand cmd = new SqlCommand(SpHelper.GetUser, conn))
{
conn.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DisplayUserGUID", param.DisplayUserGUID);
using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
// get details from reader
if (rdr.HasRows)
{
while (rdr.Read())
{
result = new ApplicationUser()
{
UserID = rdr.CustomGetValue <string>("UserID"),
DisplayUserGUID = rdr.CustomGetValue <string>("DisplayUserGUID"),
UserName = rdr.CustomGetValue <string>("UserName"),
Password = rdr.CustomGetValue <string>("Password"),
EmailAddress = rdr.CustomGetValue <string>("Email"),
FirstName = rdr.CustomGetValue <string>("FirstName"),
LastName = rdr.CustomGetValue <string>("LastName"),
IsActive = rdr.CustomGetValue <bool>("IsActive"),
Role = rdr.CustomGetValue <string>("Role")
};
}
}
}
}
}
}
catch (Exception ex)
{
_log.Write("Exception in DataAccess; Message: " + ex.Message);
}
finally
{
}
return(result);
}
public IDbResponse AddUser(LoginViewModelParam param)
{
IDbResponse result = new DbResponse();
try
{
result = _dataAccess.AddUser(param);
}
catch (Exception ex)
{
_log.Write("Exception in BusinessAccess; Message: " + ex.Message);
}
finally
{
}
return(result);
}
public ApplicationUser GetUser(LoginViewModelParam param)
{
var result = new ApplicationUser();
try
{
result = _dataAccess.GetUser(param);
}
catch (Exception ex)
{
_log.Write("Exception in BusinessAccess; Message: " + ex.Message);
}
finally
{
}
return(result);
}
public LoginViewModel AuthenticateUser(LoginViewModelParam param)
{
var result = new LoginViewModel();
try
{
result = _dataAccess.AuthenticateUser(param);
}
catch (Exception ex)
{
_log.Write("Exception in BusinessAccess; Message: " + ex.Message);
}
finally
{
}
return(result);
}
public IDbResponse UpdateUser(LoginViewModelParam param)
{
IDbResponse result = new DbResponse();
try
{
using (SqlConnection conn = _connectionHelper.DefaultConnectionDB())
{
using (SqlCommand cmd = new SqlCommand(SpHelper.UpdateUser, conn))
{
conn.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LoginUser", param.LoginUser);
cmd.Parameters.AddWithValue("@DisplayUserGUID", param.DisplayUserGUID);
cmd.Parameters.AddWithValue("@UserName", param.UserName);
cmd.Parameters.AddWithValue("@Password", param.Password);
cmd.Parameters.AddWithValue("@Email", param.EmailAddress);
cmd.Parameters.AddWithValue("@FirstName", param.FirstName);
cmd.Parameters.AddWithValue("@LastName", param.LastName);
cmd.Parameters.AddWithValue("@Role", param.Role);
using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
// get details from reader
if (rdr.HasRows)
{
while (rdr.Read())
{
result.IsSuccess = rdr.CustomGetValue <bool>("IsSuccess");
result.Message = rdr.CustomGetValue <string>("Message");
}
}
}
}
}
}
catch (Exception ex)
{
_log.Write("Exception in DataAccess; Message: " + ex.Message);
}
finally
{
}
return(result);
}
public ActionResult <IDbResponse> Authenticate([FromBody] LoginViewModelParam user)
{
if (user == null || string.IsNullOrEmpty(user.UserName) || string.IsNullOrEmpty(user.Password))
{
return(BadRequest("bad request.."));
}
var resp = _businessAccess.AuthenticateUser(user);
if (resp.IsSuccess)
{
var tokenString = _JwtConfigurator.GenerateToken(resp);
return(Ok(new { Token = tokenString }));
}
else
{
return(Unauthorized());
}
}
