public string GetInactiveUserEmailIds(string lstEmailIDs)
{
List <ApiValidateInactiveEMailIdsReturnModel> _dbResult;
using (var db = new DBAMPContext())
{
try
{
lstEmailIDs = lstEmailIDs.Replace(" ", string.Empty);
_dbResult = db.ApiValidateInactiveEMailIds(lstEmailIDs);
string _usrList = _dbResult.Count > 0 ? _dbResult.FirstOrDefault().Inactive_EmailIds : "";
return(_usrList);
}
catch (Exception ex)
{
string sqlParam = "ApiValidateInactiveEmailIds(" + lstEmailIDs + ")";
string methodName = "JCRAPI/Business/TracerService/CreateGuestUserByEmailIds";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, 0, sqlParam, string.Empty);
return(null);
}
}
}
public bool IsUserRegistered(int userID)
{
var isUserRegistered = false;
using (var db = new DBAMPContext())
{
try
{
List <ApiSiteSelectByUserIdReturnModel> rtnData;
rtnData = db.ApiSiteSelectByUserId(userID);
if (rtnData.Count > 0)
{
List <ApiSiteSelectByUserIdReturnModel> rtnfiltered = rtnData.Where(x => x.RoleID != 7).ToList();
if (rtnfiltered.Count > 0)
{
isUserRegistered = true;
}
}
}
catch (Exception ex)
{
string sqlParam = "ApiSiteSelectByUserId(" + userID + ")";
string methodName = "JCRAPI/Business/GuestUserServices/IsUserRegistered";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userID, null, sqlParam, string.Empty);
return(false);
}
}
return(isUserRegistered);
}
/// <summary>
/// Method to validate token against expiry and existence in database.
/// </summary>
/// <param name="tokenId"></param>
/// <returns></returns>
public bool ValidateToken(string tokenValue, string userId)
{
Token token;
var db = new DBAMPContext();
int Id = Convert.ToInt32(userId);
token = db.Tokens.Where(t => t.AuthToken == tokenValue && t.UserId == Id).FirstOrDefault <Token>();
if (token != null)
{
if (!(DateTime.Now > token.ExpiresOn)) //if validated token, extend Expiry Time
{
token.ExpiresOn = token.ExpiresOn.AddSeconds(
Convert.ToDouble(ConfigurationManager.AppSettings["AuthTokenExpiry"]));
int rtn = db.ApiTokenUpdate(token.UserId, token.AuthToken, token.ExpiresOn);
return(true);
}
else //If expired token, delete it from DB
{
//int rtn = db.ApiTokenDelete(token.UserId, token.AuthToken);
KillToken(token);
return(false);
}
}
return(false);
}
public ApiGetEulaStatusReturnModel CheckEULAStatus(int userId)
{
ApiGetEulaStatusReturnModel rtn = new ApiGetEulaStatusReturnModel();
using (var db = new DBAMPContext())
{
try
{
List <ApiGetEulaStatusReturnModel> user;
user = db.ApiGetEulaStatus(userId);
if (user != null)
{
ApiGetEulaStatusReturnModel firstOrDefault = user.FirstOrDefault();
if (firstOrDefault != null)
{
rtn = firstOrDefault;
}
}
}
catch (Exception ex)
{
string sqlParam = "ApiGetEulaStatus(" + userId + ")";
string methodName = "JCRAPI/Business/UserServices/CheckEULAStatus";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(null);
}
}
return(rtn);
}
public List <ApiGetUserSecurityQuestionsReturnModel> GetUserSecurityQuestions(int?userId)
{
int codeCategoryId = (int)Jcr.Api.Enumerators.Enums.CodeCategoryEnum.SecurityQuestions;
int questionTyeId1 = (int)Jcr.Api.Enumerators.Enums.UserSecurityAttributeType.PasswordAnswer1;
int questionTyeId2 = (int)Jcr.Api.Enumerators.Enums.UserSecurityAttributeType.PasswordAnswer2;
List <ApiGetUserSecurityQuestionsReturnModel> _result;
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiGetUserSecurityQuestions(userId, codeCategoryId, questionTyeId1, questionTyeId2);
}
catch (Exception ex)
{
string sqlParam = "ApiGetUserSecurityQuestions(" + userId + "," + codeCategoryId + "," + questionTyeId1 + "," + questionTyeId2 + ")";
string methodName = "JCRAPI/Business/UserServices/GetUserSecurityQuestions";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(null);
}
}
return(_result);
}
public bool ValidateSecurityQuestionAnswer(int?userId, int?questionId, string answer)
{
bool rtn = false;
ApiValidateSecurityQuestionAnswerReturnModel.ResultSetModel1 _result;
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiValidateSecurityQuestionAnswer(userId, questionId, answer).ResultSet1.FirstOrDefault();
if (_result.ValidateAnswer.ToUpper() == "TRUE")
{
rtn = true;
}
}
catch (Exception ex)
{
string sqlParam = "ApiValidateSecurityQuestionAnswer(" + userId + "," + questionId + "," + answer + ")";
string methodName = "JCRAPI/Business/UserServices/ValidateSecurityQuestionAnswer";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(false);
}
return(rtn);
}
}
public GuestUserInfo CreateTracersGuestUser(string userLogonId, string firstName, string lastName, int?siteId)
{
ApiCreateTracersGuestUserReturnModel rtnData;
GuestUserInfo returnUser;
int roleId = (int)Enums.RoleType.GuestUser;
using (var db = new DBAMPContext())
{
try
{
rtnData = db.ApiCreateTracersGuestUser(userLogonId, firstName, lastName, siteId, roleId);
returnUser = ParseResultforNewGuestUser(rtnData);
if (returnUser.UserSiteInfo.SiteID > 0)
{
returnUser.UserSiteInfo.SiteName = GetSiteFullName(returnUser.UserSiteInfo.SiteID);
}
}
catch (Exception ex)
{
string sqlParam = "ApiCreateTracersGuestUser(" + userLogonId + "," + firstName + "," + lastName + "," + siteId + "," + roleId + ")";
string methodName = "JCRAPI/Business/GuestUserServices/CreateTracersGuestUser";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteId, sqlParam, string.Empty);
return(null);
}
}
return(returnUser);
}
public int GetUserIdByLogonId(string userLogin)
{
using (var db = new DBAMPContext())
{
ApiSelectUserIdByUserLogonIdReturnModel user;
try
{
user = db.ApiSelectUserIdByUserLogonId(userLogin).FirstOrDefault();
if (user != null)
{
return(user.UserID);
}
else
{
return(0);
}
}
catch (Exception ex)
{
string sqlParam = "ApiSelectUserIdByUserLogonId(" + userLogin + ")";
string methodName = "JCRAPI/Business/UserServices/GetUserIdByLogonId";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(0);
}
}
}
public void ExceptionLogInsert(string exceptionText, string pageName, string methodName, int?userId, int?siteId, string transSql, string httpReferrer)
{
using (var db = new DBAMPContext())
{
int?exceptionLogId;
exceptionLogId = db.ApiExceptionLogInsert(exceptionText, pageName, methodName, userId, siteId, transSql, httpReferrer, out exceptionLogId);
}
}
public void UpdateUserSecurityAttribute(int?userId, int?attributeTypeId, string attributeValue, System.DateTime?attributeActivationDate, System.DateTime?attributeExpirationDate)
{
using (var db = new DBAMPContext())
{
int result;
result = db.ApiUserSecurityAttributeUpdate(userId, attributeTypeId, attributeValue, attributeActivationDate, attributeExpirationDate);
}
}
public int AuthenticateTracerUserWithoutPassword(string userLogin, out string invalidMsg)
{
int rtn = 0;
using (var db = new DBAMPContext())
{
List <ApiTracerValidateUserWithNoPasswordReturnModel> rtnData;
try
{
ApiTracerValidateUserWithNoPasswordReturnModel user;
rtnData = db.ApiTracerValidateUserWithNoPassword(userLogin);
if (rtnData.Count > 0)
{
user = rtnData.FirstOrDefault();
if (user.UserID != null && user.ErrorCode == null)
{
rtn = (int)user.UserID;
invalidMsg = string.Empty;
}
else
{
if (user.UserID == null)
{
invalidMsg = "Invalid user.";
}
else if (user.ErrorCode == 4)
{
invalidMsg = "User does not have access. Password cannot be reset.";
}
else
{
invalidMsg = "Other Errors";
}
}
}
else
{
invalidMsg = "Invalid user";
}
}
catch (Exception ex)
{
string sqlParam = "ApiTracerValidateUserWithNoPassword(" + userLogin + ")";
string methodName = "JCRAPI/Business/UserServices/AuthenticateTracerUserWithoutPassword";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
invalidMsg = "Other Errors";
return(0);
}
}
return(rtn);
}
/// <summary>
/// Function to generate unique token with expiry against the provided userId.
/// Also add a record in database for generated token.
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public Token GenerateToken(int userId)
{
var db = new DBAMPContext();
Token token;
string AuthToken;
DateTime issuedOn;
DateTime expiredOn;
bool isValidateToken = false;
token = db.Tokens.Where(t => t.UserId == userId).FirstOrDefault <Token>();
if (token != null)
{
isValidateToken = ValidateToken(token.AuthToken, userId.ToString());
}
if (!isValidateToken)
{
AuthToken = Guid.NewGuid().ToString();
issuedOn = DateTime.Now;
expiredOn = DateTime.Now.AddSeconds(
Convert.ToDouble(ConfigurationManager.AppSettings["AuthTokenExpiry"]));
var tokendomain = new Token
{
UserId = userId,
AuthToken = AuthToken,
IssuedOn = issuedOn,
ExpiresOn = expiredOn
};
int rtn = db.ApiTokenInsert(userId, AuthToken, issuedOn, expiredOn);
}
else
{
issuedOn = token.IssuedOn;
expiredOn = token.ExpiresOn;
AuthToken = token.AuthToken;
}
var tokenModel = new Token()
{
UserId = userId,
IssuedOn = issuedOn,
ExpiresOn = expiredOn,
AuthToken = AuthToken
};
return(tokenModel);
}
public ApiGetUserByUserLogonIdReturnModel GetUserByUserLogonID(string loginID)
{
ApiGetUserByUserLogonIdReturnModel _result;
using (var db = new DBAMPContext()) {
try {
_result = db.ApiGetUserByUserLogonId(loginID);
} catch (System.Exception ex) {
string sqlParam = "ApiGetUserByUserLogonID(" + loginID + ")";
string methodName = "JCRAPI/Business/PasswordServices/GetUserByUserLogonID";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(null);
}
}
return(_result);
}
/// Public method to authenticate user by user name and password.
public int Authenticate(string userLogin, string password, int?subscriptionTypeId, out string invalidMsg)
{
ApiValidateUserReturnModel user;
int rtn;
using (var db = new DBAMPContext())
{
try
{
user = db.ApiValidateUser(userLogin, password, subscriptionTypeId, out rtn).FirstOrDefault();
if (rtn > 0)
{
if (rtn == 3)
{
invalidMsg = "Invalid username and/or password.";
}
else if (rtn == 4)
{
invalidMsg = "User does not have access.";
}
else
{
invalidMsg = "Other Errors";
}
return(0);
}
else
{
invalidMsg = string.Empty;
return(user.UserID);
}
}
catch (Exception ex)
{
string sqlParam = "ApiValidateUser(" + userLogin + "," + password + "," + subscriptionTypeId + ", out rtn)";
string methodName = "JCRAPI/Business/UserServices/Authenticate";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
invalidMsg = "Other Errors";
return(0);
}
}
}
public void KillToken(Token token)
{
ExceptionLogServices exceptionLog = new ExceptionLogServices();
using (var db = new DBAMPContext())
{
try
{
int rtn = db.ApiTokenDelete(token.UserId, token.AuthToken);
}
catch (Exception ex)
{
string sqlParam = "ApiTokenDelete(" + token.UserId + "," + token.AuthToken + ")";
string methodName = "JCRAPI/Business/TokenService/KillToken";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, token.UserId, null, sqlParam, string.Empty);
}
}
}
public ApiSelectSecurityQuestionsByIdReturnModel GetSecurityQuestionsById(int?questionTyeId)
{
ApiSelectSecurityQuestionsByIdReturnModel _result;
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiSelectSecurityQuestionsById(questionTyeId);
}
catch (System.Exception ex)
{
string sqlParam = "ApiSelectSecurityQuestionsById(" + questionTyeId + ")";
string methodName = "JCRAPI/Business/PasswordServices/GetSecurityQuestionsById";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(null);
}
}
return(_result);
}
public string GetSiteFullName(int siteID)
{
string returnValue = string.Empty;
using (var db = new DBAMPContext())
{
try
{
returnValue = db.ApiGetSiteFullName(siteID).ResultSet1.SingleOrDefault().SiteFullName;
}
catch (Exception ex)
{
string sqlParam = "ApiGetSiteFullName(" + siteID + ")";
string methodName = "JCRAPI/Business/GuestUserServices/GetSiteFullName";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteID, sqlParam, string.Empty);
return(null);
}
}
return(returnValue);
}
public ApiAddUserSecurityAttributeReturnModel AddUserSecurityAttribute(int?userId, int?attributeTypeId, string attributeValue, System.DateTime?attributeActivationDate, System.DateTime?attributeExpirationDate)
{
ApiAddUserSecurityAttributeReturnModel _result;
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiAddUserSecurityAttribute(userId, attributeTypeId, attributeValue, attributeActivationDate, attributeExpirationDate);
}
catch (Exception ex)
{
string sqlParam = "ApiAddUserSecurityAttribute(" + userId + "," + attributeTypeId + "," + attributeValue + "," + attributeActivationDate + "," + attributeExpirationDate + ")";
string methodName = "JCRAPI/Business/UserServices/AddUserSecurityAttribute";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(null);
}
}
return(_result);
}
public int UpdateUserSecurityAttributeUpdateByParent(int?userId, int?attributeTypeId, string attributeValue, System.DateTime?attributeActivationDate, System.DateTime?attributeExpirationDate, int?codeCategoryId, int?parentCodeId)
{
int _result;
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiUserSecurityAttributeUpdateByParent(userId, attributeTypeId, attributeValue, attributeActivationDate, attributeExpirationDate, codeCategoryId, parentCodeId);
}
catch (Exception ex)
{
string sqlParam = "ApiUserSecurityAttributeUpdateByParent(" + userId + "," + attributeTypeId + "," + attributeValue + "," + attributeActivationDate + "," + codeCategoryId + "," + parentCodeId + ")";
string methodName = "JCRAPI/Business/UserServices/UpdateUserSecurityAttributeUpdateByParent";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(0);
}
}
return(_result);
}
int IActionTracking.AddAppEventLog(int?programId, int?siteId, int?actionTypeId, int?userId)
{
int _result;
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiLogTracerActionSummaryByMonth(programId, siteId, actionTypeId, userId);
}
catch (Exception ex)
{
string sqlParam = "ApiLogTracerActionSummaryByMonth(" + programId + "," + siteId + "," + actionTypeId + "," + userId + ")";
string methodName = "JCRAPI/Business/IActionTracking/AddAppEventLog";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, siteId, sqlParam, string.Empty);
return(0);
}
}
return(_result);
}
public int InsertCustomerSupport(CustomerSupport customerSupport)
{
ExceptionLogServices exceptionLog = new ExceptionLogServices();
int _result;
DateTime submitTime = DateTime.Now;
//=============User for Expection Log=======
string userId = customerSupport.UserID;
string siteId = customerSupport.SiteID;
string HCOID = (customerSupport.HCOID == 0) ? "null" : customerSupport.HCOID.ToString();
string subject = customerSupport.Subject;
string body = customerSupport.Body;
string productId = customerSupport.EProductID.ToString();
string programId = customerSupport.ProgramID.ToString();
//==========================================
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiInsertCustomerSupport(Convert.ToInt32(customerSupport.UserID),
Convert.ToInt32(customerSupport.SiteID),
(customerSupport.HCOID == 0) ? null : customerSupport.HCOID,
submitTime,
customerSupport.Subject,
customerSupport.Body,
customerSupport.EProductID,
customerSupport.ProgramID);
}
catch (Exception ex)
{
string sqlParam = "ApiInsertCustomerSupport(" + userId + "," + siteId + "," + HCOID + "," + submitTime.ToString() + "," + subject + "," + body + "," + productId + "," + programId + ")";
string methodName = "JCRAPI/Business/CustomerSupportEmailServices/InsertCustomerSupport";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, Convert.ToInt32(userId), Convert.ToInt32(siteId), sqlParam, string.Empty);
return(0);
}
}
return(_result);
}
public bool IsFeatureEnabled(int siteID, int featureID)
{
bool rtn;
using (var db = new DBAMPContext())
{
try
{
rtn = db.ApiIsFeatureEnabled(siteID, featureID).ResultSet1.FirstOrDefault().IsEnabled;
}
catch (Exception ex)
{
string sqlParam = "ApiIsFeatureEnabled(" + siteID + "," + featureID + ")";
string methodName = "JCRAPI/Business/GuestUserServices/IsFeatureEnabled";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteID, sqlParam, string.Empty);
return(false);
}
}
return(rtn);
}
int IActionTracking.AddAppExceptionLog(string exceptionText, string pageName, string methodName, int?userId, int?siteId, string transSql, string httpReferrer)
{
int _result;
int?_exceptionLogId = 0;
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiExceptionLogInsert(exceptionText, pageName, methodName, userId, siteId, transSql, httpReferrer, out _exceptionLogId);
}
catch (Exception ex)
{
string sqlParam = "AddAppExceptionLog(" + exceptionText + "," + pageName + "," + methodName + "," + userId + "," + siteId + "," + transSql + "," + httpReferrer + "," + ")";
string sMethodName = "JCRAPI/Business/IActionTracking/AddAppExceptionLog";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", sMethodName, userId, siteId, sqlParam, string.Empty);
return(0);
}
}
return(_result);
}
/// <summary>
/// Fetches user details by id
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public User GetUserById(int userId)
{
User user;
using (var db = new DBAMPContext())
{
try
{
user = db.Users.Where(u => u.UserId == userId).FirstOrDefault <User>();
}
catch (Exception ex)
{
string sqlParam = " db.Users.Where(u => u.UserId ==" + userId + ")";
string methodName = "JCRAPI/Business/UserServices/GetUserById";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(null);
}
}
return(user);
}
//autocomplete
public List <ApiGetEmailListBySiteListReturnModel> GetEmailListBySiteList(string search, string siteList)
{
List <ApiGetEmailListBySiteListReturnModel> rtn;
using (var db = new DBAMPContext())
{
try
{
rtn = db.ApiGetEmailListBySiteList(search, siteList);
}
catch (Exception ex)
{
string sqlParam = "ApiGetEmailListBySiteList(" + search + "," + siteList + ")";
string methodName = "JCRAPI/Business/UserServices/GetEmailListBySiteList";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(null);
}
}
return(rtn);
}
public List <ApiSelectTracerSitesByUserReturnModel> GetTracerSitesByUser(int?userId, int?siteId, bool?filteredSites, bool isGuestUser = false)
{
List <ApiSelectTracerSitesByUserReturnModel> _result;
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiSelectTracerSitesByUser(userId, siteId, filteredSites, isGuestUser);
}
catch (Exception ex)
{
string sqlParam = "ApiSelectTracerSitesByUser(" + userId + "," + siteId + "," + filteredSites + ")";
string methodName = "JCRAPI/Business/SiteServices/GetTracerSitesByUser";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, siteId, sqlParam, string.Empty);
return(null);
}
}
return(_result);
}
public IEnumerable <UspSiteSelectReturnModel.ResultSetModel1> GetSiteById(int siteId)
{
UspSiteSelectReturnModel uspsiteselect_result;
using (var db = new DBAMPContext())
{
try
{
uspsiteselect_result = db.UspSiteSelect(siteId);
}
catch (Exception ex)
{
string sqlParam = "UspSiteSelect(" + siteId + ")";
string methodName = "JCRAPI/Business/SiteServices/GetSiteById";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteId, sqlParam, string.Empty);
return(null);
}
}
return(uspsiteselect_result.ResultSet1);
}
public bool CheckUserLoginFirstAfterProductRelease(int eProductId, int userId)
{
bool status = false;
string ProductReleasedDate = ConfigurationManager.AppSettings["ProductReleasedDate"].ToString();
using (var db = new DBAMPContext())
{
try
{
var rtn = db.ApiCheckUserLoginFirstAfterProductRelease(eProductId, userId, Convert.ToDateTime(ProductReleasedDate));
status = rtn.First().IsFirstLogin.Value;
}
catch (Exception ex)
{
string sqlParam = "CheckUserProductLoginStatusAfterRelease(" + eProductId + ", " + userId + ")";
string methodName = "JCRAPI/Business/UserServices/CheckUserLoginFirstAfterProductRelease";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(false);
}
}
return(status);
}
public ApiCodeSelectByIdReturnModel GetQuestions(int questionTyeId)
{
var codeCategoryId = (int)Enums.CodeCategoryEnum.SecurityQuestions;
ApiCodeSelectByIdReturnModel _result;
using (var db = new DBAMPContext())
{
try
{
_result = db.ApiCodeSelectById(codeCategoryId, questionTyeId);
}
catch (System.Exception ex)
{
string sqlParam = "ApiCodeSelectById(" + codeCategoryId + "," + questionTyeId + ")";
string methodName = "JCRAPI/Business/PasswordServices/GetQuestions";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(null);
}
}
return(_result);
}
public bool CheckUserToken(int userId)
{
Token token;
var db = new DBAMPContext();
int Id = Convert.ToInt32(userId);
token = db.Tokens.Where(t => t.UserId == Id).FirstOrDefault <Token>();
bool rtn = false;
if (token != null)
{
if (!(DateTime.Now > token.ExpiresOn)) //if validated token, extend Expiry Time
{
rtn = true;
}
else //If expired token, delete it from DB
{
//int rtn = db.ApiTokenDelete(token.UserId, token.AuthToken);
KillToken(token);
rtn = false;
}
}
return(rtn);
}
