/// <summary> /// Used to get all the users based on pageNo and Records /// </summary> /// <returns></returns> public List<UserModel> GetAllUsers(int pageNo, int records,BusinessClasses.UserRole role) { try { using (var tde = new TimeDifferenceEntities()) { var roleId = Convert.ToInt32(role); return tde.Users.Where(m => m.IsActive && m.RoleId <= roleId).OrderBy(m => m.Id) .Skip((pageNo * records) - records).Take(records).Select( m => new UserModel { Email = m.Email, UserId = m.Id, UserName = m.UserName, Role = (BusinessClasses.UserRole)m.RoleId }).ToList(); } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to check if the login exist for any user /// </summary> /// <param name="loginInfo"></param> /// <returns></returns> public UserModel CheckLoginInfo(LoginModel loginInfo) { try { using (var tde = new TimeDifferenceEntities()) { var userData = tde.Users.FirstOrDefault( m => m.IsActive && m.Email == loginInfo.Email && m.Password == loginInfo.Password); if (userData == null) return null; return new UserModel { Email = userData.Email, Role = (BusinessClasses.UserRole)userData.RoleId, UserId = userData.Id, UserName = userData.UserName }; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to get the token information /// </summary> /// <param name="token"></param> /// <returns></returns> public Token GetTokenInformation(string token) { try { using (var tde = new TimeDifferenceEntities()) { return tde.Tokens.FirstOrDefault(m => m.AuthToken == token); } } catch (Exception ex) { return null; } }
/// <summary> /// Used to get timeZone entry /// </summary> /// <param name="timeZoneEntryId"></param> /// <returns></returns> public TimeZoneEntry GetTimeZoneEntry(int timeZoneEntryId) { try { using (var tde = new TimeDifferenceEntities()) { var entry = tde.TimeZoneEntries.FirstOrDefault(m => m.Id == timeZoneEntryId && m.IsActive); return entry; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to delete token based on user id /// </summary> /// <param name="userId"></param> /// <returns></returns> public bool DeleteTokensByUserId(int userId) { try { using (var tde = new TimeDifferenceEntities()) { var tokens = tde.Tokens.Where(m => m.UserId == userId); tde.Tokens.RemoveRange(tokens); tde.SaveChanges(); return true; } } catch (Exception ex) { return false; } }
/// <summary> /// Used to get all the timezone entry made by user /// </summary> /// <returns></returns> public List<TimeZoneEntry> GetAllTimeZoneBasedOnId(int pageNo, int records, int userId) { try { using (var tde = new TimeDifferenceEntities()) { return tde.TimeZoneEntries.Where(m => m.IsActive && m.UserId == userId).OrderBy(m => m.Id) .Skip((pageNo * records) - records).Take(records).ToList(); } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to delete Token /// </summary> /// <param name="token"></param> /// <returns></returns> public bool DeleteToken(string token) { try { using (var tde = new TimeDifferenceEntities()) { var tokenInfo = tde.Tokens.FirstOrDefault(m => m.AuthToken == token); if (tokenInfo == null) return false; tde.Tokens.Remove(tokenInfo); tde.SaveChanges(); return true; } } catch (Exception ex) { return false; } }
/// <summary> /// Used to delete timeZone entry /// </summary> /// <param name="timeZoneEntryId"></param> /// <returns></returns> public bool DeleteTimeZoneEntry(int timeZoneEntryId) { try { using (var tde = new TimeDifferenceEntities()) { var entry = tde.TimeZoneEntries.FirstOrDefault(m => m.Id == timeZoneEntryId); if (entry == null) return false; entry.IsActive = false; tde.SaveChanges(); return true; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to modify user Information /// </summary> /// <returns></returns> public bool ModifyUserInformationAdmin(UserModel userInformation) { try { using (var tde = new TimeDifferenceEntities()) { var userInfo = tde.Users.FirstOrDefault(m => m.IsActive && m.Id == userInformation.UserId); if (userInfo == null) return false; userInfo.Email = userInformation.Email; userInfo.UserName = userInformation.UserName; userInfo.RoleId = Convert.ToInt32(userInformation.Role); if (!string.IsNullOrEmpty(userInformation.Password)) { userInfo.Password = userInformation.Password; } tde.SaveChanges(); return true; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to save a timeZone Entry /// </summary> /// <returns></returns> public int SaveNewTimeZoneEntry(TimeZoneEntry entry) { try { using (var tde = new TimeDifferenceEntities()) { tde.TimeZoneEntries.Add(entry); tde.SaveChanges(); return entry.Id; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to get user information based on user ID /// </summary> /// <param name="userId"></param> /// <returns></returns> public UserModel GetUserInformationBasedOnId(int userId) { try { using (var tde = new TimeDifferenceEntities()) { var userData = tde.Users.FirstOrDefault(m => m.IsActive && m.Id == userId); if (userData == null) return null; return new UserModel { Email = userData.Email, Role = (BusinessClasses.UserRole)userData.RoleId, UserId = userData.Id, UserName = userData.UserName }; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to remove user from the database /// </summary> /// <param name="userId"></param> /// <returns></returns> public bool RemoveUser(int userId) { try { using (var tde = new TimeDifferenceEntities()) { var userInfo = tde.Users.FirstOrDefault(m => m.IsActive && m.Id == userId); if (userInfo == null) return false; userInfo.IsActive = false; tde.SaveChanges(); return true; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to register User /// </summary> /// <param name="registrationModel"></param> /// <returns></returns> public int RegisterUser(RegistrationModel registrationModel) { try { using (var tde = new TimeDifferenceEntities()) { var userData = new User { Email = registrationModel.Email, UserName = registrationModel.UserName, Password = registrationModel.Password, RoleId = Convert.ToInt32(registrationModel.RoleId), IsActive = true }; tde.Users.Add(userData); tde.SaveChanges(); return userData.Id; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to update the token information /// </summary> /// <param name="token"></param> /// <returns></returns> public bool UpdateToken(Token token) { try { using (var tde = new TimeDifferenceEntities()) { var tokenInfo = tde.Tokens.FirstOrDefault(m => m.AuthToken == token.AuthToken); if (tokenInfo == null) return false; tokenInfo.AuthToken = token.AuthToken; tokenInfo.ExpiresOn = token.ExpiresOn; tokenInfo.IssuedOn = token.IssuedOn; tokenInfo.UserId = token.UserId; tde.SaveChanges(); return true; } } catch (Exception ex) { return false; } }
/// <summary> /// Used to get tokens based on user id /// </summary> /// <param name="userId"></param> /// <returns></returns> public List<Token> GetTokensBasedOnUserId(int userId) { try { using (var tde = new TimeDifferenceEntities()) { return tde.Tokens.Where(m => m.UserId == userId).ToList(); } } catch (Exception ex) { return null; } }
/// <summary> /// Used to check if the email Id already Exist /// </summary> /// <param name="emailId"></param> /// <returns></returns> public bool IsEmailExist(string emailId) { try { using (var tde = new TimeDifferenceEntities()) { var userData = tde.Users.FirstOrDefault(m => m.IsActive && m.Email == emailId); return userData != null; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to filter data from database for DataTable /// </summary> /// <returns></returns> public List<UserModelDataTable> GetUsersDataTable(BusinessClasses.UserRole role) { try { using (var tde = new TimeDifferenceEntities()) { var roleId = Convert.ToInt32(role); return tde.Users.Where(m => m.IsActive && m.RoleId <= roleId).Select(m => new UserModelDataTable { Email = m.Email, Role = (BusinessClasses.UserRole)m.RoleId, UserId = m.Id, UserName = m.UserName, TimeZoneRecords = m.TimeZoneEntries.Count(c => c.IsActive) }).ToList(); } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to edit a timeZone Entry /// </summary> /// <returns></returns> public int ModifyTimeZoneEntry(TimeZoneEntry entry) { try { using (var tde = new TimeDifferenceEntities()) { var timeZoneEntry = tde.TimeZoneEntries.FirstOrDefault(m => m.IsActive && m.Id == entry.Id); if (timeZoneEntry == null) return -1; timeZoneEntry.City = entry.City; timeZoneEntry.Difference = entry.Difference; timeZoneEntry.EntryName = entry.EntryName; tde.SaveChanges(); return timeZoneEntry.Id; } } catch (Exception ex) { throw new Exception("Exception Occured", ex.InnerException); } }
/// <summary> /// Used to add token in the database /// </summary> /// <returns></returns> public bool InsertToken(Token token) { try { using (var tde = new TimeDifferenceEntities()) { tde.Tokens.Add(new Token { AuthToken = token.AuthToken, ExpiresOn = token.ExpiresOn, IssuedOn = token.IssuedOn, UserId = token.UserId, }); tde.SaveChanges(); return true; } } catch (Exception ex) { return false; } }