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