public LoginUserDTO Set_Inactive_Data(LoginUserSearchDTO searchModel)
{
log.MethodStart();
LoginUserDTO objReturn = new LoginUserDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objUserLogin = _db.TCUserLogins.FirstOrDefault(x => x.usr_username == searchModel.usr_username);
if (objUserLogin != null)
{
objUserLogin.usr_status = "I";
objUserLogin.usr_active = false;
_db.SaveChanges();
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public List <LoginUserPermissionDTO> Get_LoginUserPermission_List(LoginUserSearchDTO searchModel)
{
log.MethodStart();
List <LoginUserPermissionDTO> objReturn = new List <LoginUserPermissionDTO>();
using (var trans = _db.Database.BeginTransaction())
{
try
{
objReturn = _db.LoginUserPermissionDTOs.FromSqlRaw <LoginUserPermissionDTO>("sp_Check_UserLoginPermission {0}", searchModel.usr_username).ToList();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public async Task <LoginUserDTO> Set_TimeoutUser_DataAsync(LoginUserSearchDTO searchModel)
{
LoginUserDTO objModel = new LoginUserDTO();
List <LoginUserPermissionDTO> objList = new List <LoginUserPermissionDTO>();
objModel = await _apiHelper.GetDataByModelAsync <LoginUserDTO, LoginUserSearchDTO>("loginuserdata_api/SetTimeoutUserData", searchModel);
return(objModel);
}
public LoginUserDTO GetLoginUserData([FromBody] LoginUserSearchDTO searchModel)
{
var objReturn = _service.Get_LoginUser_Data(searchModel);
if (objReturn != new LoginUserDTO())
{
objReturn.str_LoginUserPermission_List = _service.Get_LoginUserPermission_Data(searchModel.usr_username);
objReturn.str_LoginUserRolePermission_List = _service.Get_LoginUserRolePermission_Data(objReturn.str_LoginUserPermission_List);
}
return(objReturn);
}
public LoginUserDTO Get_LoginUser_Data(LoginUserSearchDTO searchModel)
{
log.MethodStart();
LoginUserDTO objReturn = new LoginUserDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objResult = _db.LoginUserDTOs.FromSqlRaw <LoginUserDTO>("sp_Check_UserLogin {0}, {1}", searchModel.usr_username, searchModel.usr_password).ToList();
if (objResult.Count > 0)
{
objReturn = objResult.FirstOrDefault();
_db.LogUserLogins.Add(new LogUserLogin()
{
log_usr_id = objReturn.usr_username,
log_access_ip = searchModel.usr_clientIp,
log_session_id = searchModel.usr_sessionId,
log_login_timestamp = DateTime.Now,
log_status = "Login"
});
var objUserLogin = _db.TCUserLogins.FirstOrDefault(x => x.usr_username == searchModel.usr_username);
if (objUserLogin != null)
{
objUserLogin.usr_accessFailedCount = 0;
}
_db.SaveChanges();
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public LoginUserDTO Set_TimeoutUser_Data(LoginUserSearchDTO searchModel)
{
log.MethodStart();
LoginUserDTO objReturn = new LoginUserDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objResult = _db.LogUserLogins.FirstOrDefault(x => x.log_usr_id == searchModel.usr_username && x.log_session_id == searchModel.usr_sessionId);
if (objResult != null)
{
objResult.log_logout_timestamp = DateTime.Now;
objResult.log_status = "Logout";
objResult.log_remark = "Timeout";
_db.SaveChanges();
trans.Commit();
objReturn = new LoginUserDTO()
{
usr_username = objResult.log_usr_id
};
}
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public LoginUserDTO SetTimeoutUserData([FromBody] LoginUserSearchDTO searchModel)
{
var objReturn = _service.Set_TimeoutUser_Data(searchModel);
return(objReturn);
}
public LoginUserDTO SetInactiveData([FromBody] LoginUserSearchDTO searchModel)
{
var objReturn = _service.Set_Inactive_Data(searchModel);
return(objReturn);
}
public LoginUserDTO SetWrongPasswordData([FromBody] LoginUserSearchDTO searchModel)
{
var objReturn = _service.Set_WrongPassword_Data(searchModel);
return(objReturn);
}
public List <LoginUserPermissionDTO> GetLoginUserPermissionData([FromBody] LoginUserSearchDTO searchModel)
{
var objReturn = _service.Get_LoginUserPermission_List(searchModel);
return(objReturn);
}
public async Task <LoginUser> Check_LoginUser_DataAsync(LoginUserSearchDTO searchModel)
{
log.MethodStart();
LoginUser loginUser = new LoginUser();
try
{
//searchModel.usr_clientIp = _httpContextAccessor.HttpContext.Connection.LocalIpAddress.ToString();
searchModel.usr_sessionId = Guid.NewGuid().ToString().ToUpper();
LoginUserDTO objModel = new LoginUserDTO();
List <LoginUserPermissionDTO> objList = new List <LoginUserPermissionDTO>();
//log.Info(JsonSerializer.Serialize(searchModel));
objModel = await _apiHelper.GetDataByModelAsync <LoginUserDTO, LoginUserSearchDTO>("loginuserdata_api/GetLoginUserData", searchModel);
//log.Info(JsonSerializer.Serialize(objModel));
if (objModel?.usr_id != 0)
{
loginUser.Username = objModel.usr_username;
loginUser.Firstname = objModel.usr_firstname;
loginUser.Lastname = objModel.usr_lastname;
loginUser.ClientIp = searchModel.usr_clientIp;
loginUser.SessionId = searchModel.usr_sessionId;
loginUser.SessionTimeStamp = DateTime.Now;
loginUser.SessionTimeout = _timeoutDuration;
loginUser.LoginUserPermissionList = JsonSerializer.Deserialize <List <LoginUserPermissionDTO> >(objModel.str_LoginUserPermission_List);
loginUser.LoginUserRolePermissionList = JsonSerializer.Deserialize <List <LoginUserRolePermissionDTO> >(objModel.str_LoginUserRolePermission_List);
//objList = await _apiHelper.GetDataListByModelAsync<LoginUserPermissionDTO, LoginUserSearchDTO>("loginuserdata_api/GetLoginUserPermissionData", searchModel);
//log.Info(JsonSerializer.Serialize(objList));
if (loginUser.LoginUserPermissionList.Count > 0)
{
var objListFirst = loginUser.LoginUserPermissionList.FirstOrDefault();
loginUser.rol_code = objListFirst.usp_rol_code;
loginUser.rol_name = objListFirst.usp_rol_name;
loginUser.arh_code = objListFirst.usp_arh_code;
loginUser.arh_name = objListFirst.usp_arh_name;
loginUser.prv_code = objListFirst.usp_prv_code;
loginUser.prv_name = objListFirst.usp_prv_name;
loginUser.hos_code = objListFirst.usp_hos_code;
loginUser.hos_name = objListFirst.usp_hos_name;
loginUser.lab_code = objListFirst.usp_lab_code;
loginUser.lab_name = objListFirst.usp_lab_name;
RoleSearchDTO searchData = new RoleSearchDTO()
{
sch_rol_code = loginUser.rol_code
};
loginUser.rol_permission_List = await _apiHelper.GetDataListByModelAsync <RolePermissionDTO, RoleSearchDTO>("role_api/Get_PermissionListByModel", searchData);
}
}
}
catch (Exception ex)
{
// TODO: Handle failure
//trans.Rollback();
log.Error(ex.Message);
log.Error(ex.InnerException.Message);
}
finally
{
//trans.Dispose();
}
log.MethodFinish();
return(loginUser);
}