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); }