public long SaveUser(ClsUser objSave) { try { long UserId = 0; using (TransactionScope scope = new TransactionScope()) { using (this.objDataContext = new UserDataContext(Functions.StrConnection)) { objSave.strPassword = objSave.strPassword.EncryptString(); var result = this.objDataContext.InsertOrUpdateUser(objSave.lgId, 1, objSave.strFirstName, objSave.strSurName, objSave.strMobileNo, objSave.strEmailID, objSave.strUserName, objSave.strPassword, objSave.strAddress, "EMP/12345", objSave.lgRoleId, objSave.blIsActive, objSave.blIsLogin, mySession.Current.UserId, PageMaster.User, objSave.lgAdminUserId, objSave.intSessionDurationHour, objSave.intUnsuccessfulLoginAttempt, objSave.intPasswordExpirationCount).FirstOrDefault(); if (result != null) { UserId = result.InsertedId; this.objDataContext.InsertOrUpdateUserTrackerPermissions(0, UserId, objSave.blTripStartDate, objSave.blTripEndDate, objSave.blLocationStart, objSave.blLocationEnd, objSave.blTripReasonName, objSave.blReasonRemarks, objSave.blKmStart, objSave.blKmEnd, objSave.blKmDriven, objSave.blFuelStart, objSave.blFuelEnd, objSave.blUsername, objSave.blEntryDatetime, objSave.blEntryMethod, objSave.blEditable, objSave.blActive, objSave.blCompanyName, objSave.blEditColumn, objSave.blDeleteColumn, mySession.Current.UserId); } scope.Complete(); } return(UserId); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId); return(0); } }
public ClsUser GetUserByEmailId(string strEmailId) { ClsUser objClsUser = new ClsUser(); try { using (this.objDataContext = new UserDataContext(Functions.StrConnection)) { GetUserByEmailIdResult item = this.objDataContext.GetUserByEmailId(strEmailId).FirstOrDefault(); if (item != null) { objClsUser.lgId = item.Id; objClsUser.strEmailID = item.EmailID; objClsUser.strFirstName = item.FirstName; objClsUser.strSurName = item.SurName; objClsUser.strMobileNo = item.MobileNo; objClsUser.strPassword = item.Password; } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId); } return(objClsUser); }
public ClsUser ChangePassword(long lgUserId, string strUserPwd) { ClsUser objUserMaster = new ClsUser(); try { objUserMaster = this.GetUserByUserId(lgUserId); if (objUserMaster != null) { objUserMaster.strPassword = strUserPwd; } this.SaveUser(objUserMaster); } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId); } return(objUserMaster); }
public ClsUser GetUserByUserId(long lgUserId) { ClsUser objClsUser = new ClsUser(); try { using (this.objDataContext = new UserDataContext(Functions.StrConnection)) { GetUserByIdResult item = this.objDataContext.GetUserById(lgUserId).FirstOrDefault(); if (item != null) { objClsUser.lgId = item.Id; objClsUser.strFirstName = item.FirstName; objClsUser.strSurName = item.SurName; objClsUser.strMobileNo = item.MobileNo; objClsUser.strEmailID = item.EmailID; objClsUser.strUserName = item.UserName; objClsUser.strPassword = item.Password.DecryptString(); objClsUser.strConfirmPassword = item.Password.DecryptString(); objClsUser.strAddress = item.Address; objClsUser.lgRoleId = item.RoleId; objClsUser.lgBranchId = item.BranchId; objClsUser.strBranchName = item.UserBranchName; objClsUser.blIsActive = item.IsActive; objClsUser.blIsLogin = item.IsLogin; objClsUser.strEmployeeCode = item.EmployeeCode; objClsUser.lgVehicleDistributeId = item.VehicleDistributeId ?? 0; objClsUser.lgAdminUserId = item.AssignBy; objClsUser.intSessionDurationHour = item.SessionDurationHour; objClsUser.intUnsuccessfulLoginAttempt = item.UnsuccessfulLoginAttempt; objClsUser.intPasswordExpirationCount = item.PasswordExpirationCount; } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId); } return(objClsUser); }
public ClsUser ValidateLogin(string strUserName, string strPassword) { try { using (this.objDataContext = new UserDataContext(Functions.StrConnection)) { User objUser = this.objDataContext.Users.Where(n => n.UserName == strUserName && n.Password == strPassword && n.IsActive == true).FirstOrDefault(); if (objUser != null) { ClsUser objClsUser = new ClsUser(); objClsUser.lgId = objUser.Id; objClsUser.lgBranchId = objUser.BranchId; objClsUser.strFirstName = objUser.FirstName; objClsUser.strSurName = objUser.SurName; objClsUser.strMobileNo = objUser.MobileNo; objClsUser.strEmailID = objUser.EmailID; objClsUser.strUserName = objUser.UserName; objClsUser.strPassword = objUser.Password.DecryptString(); objClsUser.strAddress = objUser.Address; objClsUser.lgRoleId = objUser.RoleId; objClsUser.blIsActive = objUser.IsActive; objClsUser.blIsLogin = objUser.IsLogin; objClsUser.strEmployeeCode = objUser.EmployeeCode; objClsUser.lgAdminUserId = objUser.AssignBy; objClsUser.intSessionDurationHour = objUser.SessionDurationHour; objClsUser.dtPasswordExpireOn = objUser.PasswordExpireOn; objClsUser.intUnsuccessfulLoginAttempt = objUser.UnsuccessfulLoginAttempt; return(objClsUser); } return(null); } } catch (Exception ex) { throw ex; Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId); return(null); } }