/// <summary> /// This method is used for the Reactivate the inactive user /// </summary> /// <param name="i_sConnectionString">Connection string</param> /// <param name="i_tblUserInfo">User Info Datatable object</param> /// /// <param name="i_nLoggedInUserID">Logged In User Id</param> /// <returns></returns> public Boolean ReactivateUser(string i_sConnectionString, int i_UserInfoId, int i_nLoggedInUserID) { try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { return(objUserInfoDAL.ReactivateUser(i_sConnectionString, i_UserInfoId, i_nLoggedInUserID)); } } catch (Exception exp) { throw exp; } }
/// <summary> /// This function will be called for updating the users last login time. /// The login time will be updated whenever user logins to the system. /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_objUserInfoDTO"></param> /// <returns></returns> public void UpdateUserLastLoginTime(string i_sConnectionString, string i_sLoginId) { try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { objUserInfoDAL.UpdateUserLastLoginTime(i_sConnectionString, i_sLoginId); } } catch (Exception exp) { throw exp; } }
/// <summary> /// This method is used for the insert/Update User Separation. /// </summary> /// <param name="i_sConnectionString">Connection string</param> /// <param name="i_tblUserInfo">User Info Datatable object</param> /// /// <param name="i_nLoggedInUserID">Logged In User Id</param> /// <returns></returns> public Boolean SaveUserEulaAcceptance(string i_sConnectionString, int i_nUserInfo, int i_nDocumentID, bool i_nEulaAcceptanceFlag) { try { using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { objUserInfoDAL.SaveUserEulaAcceptance(i_sConnectionString, i_nUserInfo, i_nDocumentID, i_nEulaAcceptanceFlag); } } catch (Exception exp) { throw exp; } return(true); }
/// <summary> /// This method is used for the insert/Update User Separation. /// </summary> /// <param name="i_sConnectionString">Connection string</param> /// <param name="i_tblUserInfo">User Info Datatable object</param> /// /// <param name="i_nLoggedInUserID">Logged In User Id</param> /// <returns></returns> public Boolean SaveUserSeparation(string i_sConnectionString, DataTable i_tblUserInfo, int i_nLoggedInUserID) { try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { objUserInfoDAL.SaveUserSeparation(i_sConnectionString, i_tblUserInfo, i_nLoggedInUserID); } } catch (Exception exp) { throw exp; } return(true); }
/// <summary> /// This method is used for the get user Details /// </summary> /// <param name="i_sConnectionString">DB Connection string</param> /// <param name="LoggedInId">LoggedInId</param> /// <returns>Object Authentication DTO</returns> public List <AuthenticationDTO> GetUserLoginDetails(string i_sConnectionString, string LoggedInId, string CalledFrom) { List <AuthenticationDTO> lstUserLoginDetails = new List <AuthenticationDTO>(); try { using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { lstUserLoginDetails = objUserInfoDAL.GetUserLoginDetails(i_sConnectionString, LoggedInId, CalledFrom).ToList <AuthenticationDTO>(); } } catch (Exception exp) { throw exp; } return(lstUserLoginDetails); }
/// <summary> /// /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_objUserInfoDTO"></param> /// <returns></returns> public InsiderTradingDAL.PasswordPolicyDTO GetPasswordPolicy(string i_sConnectionString) { PasswordPolicyDTO res = null; try { using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { res = objUserInfoDAL.GetPasswordPolicy(i_sConnectionString); } } catch (Exception exp) { throw exp; } return(res); }
/// <summary> /// This method is used to save Contact Details List /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_objPreclearanceRequestNonImplCompanyDTO"></param> /// <returns></returns> public ContactDetails InsertUpdatecontactDetails(string i_sConnectionString, DataTable dt_ContactDetails) { ContactDetails objContactDetailsDTO = null; try { using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { objContactDetailsDTO = objUserInfoDAL.InsertUpdatecontactDetails(i_sConnectionString, dt_ContactDetails); } } catch (Exception ex) { throw; } return(objContactDetailsDTO); }
public List <ContactDetails> GetContactDetails(string i_sConnectionString, int i_nUserInfoId) { List <ContactDetails> lstGroupDocumentList = new List <ContactDetails>(); //InsiderTradingDAL.CompanyDAL objCompanyDAL = new InsiderTradingDAL.CompanyDAL(); try { using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { lstGroupDocumentList = objUserInfoDAL.GetContactDetails(i_sConnectionString, i_nUserInfoId).ToList <ContactDetails>(); } } catch (Exception exp) { throw exp; } return(lstGroupDocumentList); }
/// <summary> /// This method is used for fetching the list of users for whom the PerformedPeriodEnd flag is set i.e. /// for Employees, Corporate and Non Employee types users. /// </summary> /// <param name="i_sConnectionString">Connection string for which database</param> /// <returns>User Information List</returns> public List <UserInfoDTO> GetPeriodEndPerformedUserInfoList(string i_sConnectionString) { List <UserInfoDTO> userInfoList = new List <UserInfoDTO>(); try { using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { userInfoList = objUserInfoDAL.GetPeriodEndPerformedUserInfoList(i_sConnectionString); } } catch (Exception exp) { throw exp; } return(userInfoList); }
public List <ContactDetails> GetRelativeDetails(string i_sConnectionString, int i_nUserInfoId) { List <ContactDetails> GetRelativeDetails = new List <ContactDetails>(); //InsiderTradingDAL.CompanyDAL objCompanyDAL = new InsiderTradingDAL.CompanyDAL(); try { using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { GetRelativeDetails = objUserInfoDAL.GetRelativeDetails(i_sConnectionString, i_nUserInfoId).ToList <ContactDetails>(); } } catch (Exception exp) { throw exp; } return(GetRelativeDetails); }
public UserInfoDTO BlockUnblockUser(string i_sConnectionString, int UserInfoID, bool IsBlocked, string Blocked_UnBlock_Reason, int CreatedBy) { UserInfoDTO objUserInfoDTO = null; try { using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { objUserInfoDTO = objUserInfoDAL.BlockUnblockUser(i_sConnectionString, UserInfoID, IsBlocked, Blocked_UnBlock_Reason, CreatedBy); } } catch (Exception ex) { throw; } return(objUserInfoDTO); }
/// <summary> /// /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_objUserInfoDTO"></param> /// <returns></returns> public PasswordManagementDTO GetUserFromHashCode(string i_sConnectionString, string i_sHashCode) { PasswordManagementDTO res = null; try { using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { res = objUserInfoDAL.GetUserFromHashCode(i_sConnectionString, i_sHashCode); } } catch (Exception exp) { throw exp; } return(res); }
/// <summary> /// This method is used for the insert/Update User details. /// </summary> /// <param name="i_sConnectionString">Connection string</param> /// <param name="i_objUserInfoDTO">User Info Object</param> /// <returns></returns> public UserInfoDTO InsertUpdateUserDetails(string i_sConnectionString, UserInfoDTO i_objUserInfoDTO) { UserInfoDTO objUserInfoDTO = null; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { objUserInfoDTO = objUserInfoDAL.InsertUpdateUserDetails(i_sConnectionString, i_objUserInfoDTO); } } catch (Exception exp) { throw exp; } return(objUserInfoDTO); }
/// <summary> /// This function will be used for validating if the given user is registered under the given company database. /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_objUserDetailsDTO"></param> public bool ValidateUser(string i_sConnectionString, AuthenticationDTO i_objAuthenticationDTO, ref UserInfoDTO o_objUserInfoDTO) { bool bReturn = false; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { bReturn = objUserInfoDAL.ValidateUser(i_sConnectionString, i_objAuthenticationDTO, ref o_objUserInfoDTO); } } catch (Exception exp) { throw exp; } return(bReturn); }
/// <summary> /// /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_sLoginId"></param> /// <param name="o_nReturnValue"></param> /// <param name="o_nErroCode"></param> /// <param name="o_sErrorMessage"></param> /// <returns></returns> public InsiderTradingDAL.TokenDetailsDTO SaveFormTokenStatus(string i_sConnectionString, int inp_UserId, int inp_FormId, string inp_CookieName) { InsiderTradingDAL.TokenDetailsDTO res = null; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { res = objUserInfoDAL.SaveFormTokenStatus(i_sConnectionString, inp_UserId, inp_FormId, inp_CookieName); } } catch (Exception exp) { throw exp; } return(res); }
/// <summary> /// /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_sLoginId"></param> /// <param name="o_nReturnValue"></param> /// <param name="o_nErroCode"></param> /// <param name="o_sErrorMessage"></param> /// <returns></returns> public InsiderTradingDAL.SessionDetailsDTO GetCookieStatus(string i_sConnectionString, int inp_UserId, string inp_CookieName, bool inp_isNew, bool inp_isUpdateCookie) { InsiderTradingDAL.SessionDetailsDTO res = null; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { res = objUserInfoDAL.GetCookieStatus(i_sConnectionString, inp_UserId, inp_CookieName, inp_isNew, inp_isUpdateCookie); } } catch (Exception exp) { throw exp; } return(res); }
/// <summary> /// /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_objUserInfoDTO"></param> /// <returns></returns> public bool DeleteUserDetails(string i_sConnectionString, int i_nUserInfoId, int i_nLoggedInUserID) { bool bReturn = false; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { bReturn = objUserInfoDAL.DeleteUserDetails(i_sConnectionString, i_nUserInfoId, i_nLoggedInUserID); } } catch (Exception exp) { throw exp; } return(bReturn); }
/// <summary> /// /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_sLoginId"></param> /// <param name="o_nReturnValue"></param> /// <param name="o_nErroCode"></param> /// <param name="o_sErrorMessage"></param> /// <returns></returns> public InsiderTradingDAL.UserInfoDTO GetUserAuthencticationDetails(string i_sConnectionString, string i_sLoginId) { InsiderTradingDAL.UserInfoDTO res = null; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { res = objUserInfoDAL.GetUserAuthencticationDetails(i_sConnectionString, i_sLoginId); } } catch (Exception exp) { throw exp; } return(res); }
/// <summary> /// /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_objUserInfoDTO"></param> /// <returns></returns> public bool ChangePassword(string i_sConnectionString, ref PasswordManagementDTO i_objPwdMgmtDTO) { bool bReturn = false; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { bReturn = objUserInfoDAL.ChangePassword(i_sConnectionString, ref i_objPwdMgmtDTO); } } catch (Exception exp) { throw exp; } return(bReturn); }
/// <summary> /// /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_objUserInfoDTO"></param> /// <returns></returns> public PasswordManagementDTO ForgetPassword(string i_sConnectionString, PasswordManagementDTO i_objPwdMgmtDTO) { PasswordManagementDTO res = null; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { res = objUserInfoDAL.ForgetPassword(i_sConnectionString, i_objPwdMgmtDTO); } } catch (Exception exp) { throw exp; } return(res); }
public bool CheckConcurrentSessionConfiguration(string i_sConnectionString) { bool bReturn = false; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { bReturn = objUserInfoDAL.CheckConcurrentSessionConfiguration(i_sConnectionString); } } catch (Exception exp) { throw exp; } return(bReturn); }
public InsiderTradingDAL.UserEducationDTO GetUserDetails(string i_sConnectionString, int i_nUserInfoId, int UEW_id) { InsiderTradingDAL.UserEducationDTO res = null; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { res = objUserInfoDAL.GetUserEducationDetails(i_sConnectionString, i_nUserInfoId, UEW_id); } } catch (Exception exp) { throw exp; } return(res); }
/// <summary> /// This method is used for the insert/Update DMAT details. /// </summary> /// <param name="i_sConnectionString">Connection string</param> /// <param name="i_nDMATAccountHoderID">DMATAccountHoderID to delete</param> /// <param name="nLoggedInUserId">Logged In User</param> /// <returns>Returns boolean value based on the result</returns> public bool DeleteFormToken(string i_sConnectionString, int i_nLoggedInUserID, int i_FormID) { bool bReturn = false; try { //DMATDetailsDAL objDMATDetailsDAL = new DMATDetailsDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { bReturn = objUserInfoDAL.DeleteFormToken(i_sConnectionString, i_nLoggedInUserID, i_FormID); } } catch (Exception exp) { bReturn = false; throw exp; } return(bReturn); }
/// <summary> /// This method is used for get user info list by User Type. /// </summary> /// <param name="i_sConnectionString">Connection string for which database</param> /// <param name="i_objUserInfoDTO">User Type Object</param> /// <returns>User Information List</returns> public IEnumerable <UserInfoDTO> GetUserInfoList(string i_sConnectionString, UserInfoDTO i_objUserInfoDTO, out int o_nReturnValue, out int o_nErroCode, out string o_sErrorMessage) { IEnumerable <UserInfoDTO> userInfoList = null; o_nReturnValue = 0; o_nErroCode = 0; o_sErrorMessage = ""; try { //InsiderTradingDAL.UserInfoDAL objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL(); using (var objUserInfoDAL = new InsiderTradingDAL.UserInfoDAL()) { userInfoList = objUserInfoDAL.GetUserInfoList(i_sConnectionString, i_objUserInfoDTO); } } catch (Exception exp) { throw exp; } return(userInfoList); }