public int AuthenticateGuest(string userLogin, string password, out string invalidMsg)
{
var userID = GetUserIdByLogonId(userLogin);
using (var db = new DBMEdition01Context())
{
try
{
var rtnPassCode = db.ApiUpdateSelectPasscode(userID, userID, 0).FirstOrDefault();
var passCodeDB = rtnPassCode.Passcode.HasValue ? rtnPassCode.Passcode.Value : 0;
if (rtnPassCode != null && string.Equals(password, passCodeDB.ToString(), StringComparison.InvariantCulture))
{
invalidMsg = string.Empty;
return(userID);
}
else
{
invalidMsg = "Invalid Passcode";
return(0);
}
}
catch (Exception ex)
{
string sqlParam = "ApiUpdateSelectPasscode(" + userID + "," + userID + "," + password + ")";
string methodName = "JCRAPI/Business/GuestUserServices/CreatePasscode";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userID, null, sqlParam, string.Empty);
invalidMsg = "There was an error authenticating the user. Please contact your Program Administrator.";
return(0);
}
}
}
public List <ApiMobileResponsesSelectByTracerIdReturnModel> GetTracerResponses(int?tracerId, string responseStatusCSV, int createdByUserID = 0)
{
List <ApiMobileResponsesSelectByTracerIdReturnModel> _result;
using (var db = new DBMEdition01Context())
{
try
{
_result = db.ApiMobileResponsesSelectByTracerId(tracerId, responseStatusCSV);
if (createdByUserID > 0)
{
_result = _result.Where(item => item.CreatedByID == createdByUserID).ToList();
}
}
catch (Exception ex)
{
string sqlParam = "ApiMobileResponsesSelectByTracerId(" + tracerId + "," + responseStatusCSV + ")";
string methodName = "JCRAPI/Business/TracerMobileServices/GetTracerResponses";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(null);
}
}
return(_result);
}
public List <ApiGetUserSecurityAttributesReturnModel> GetUserSecurityAttributes(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 <ApiGetUserSecurityAttributesReturnModel> _result;
using (var db = new DBMEdition01Context())
{
try
{
_result = db.ApiGetUserSecurityAttributes(userId, codeCategoryId, questionTyeId1, questionTyeId2);
}
catch (Exception ex)
{
string sqlParam = "ApiGetUserSecurityAttributes(" + userId + "," + codeCategoryId + "," + questionTyeId1 + "," + questionTyeId2 + ")";
string methodName = "JCRAPI/Business/UserServices/GetUserSecurityAttributes";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(null);
}
}
return(_result);
}
public ApiMobileValidateTracerGuestUserReturnModel ValidateTracerGuestUser(string email, out string rtnErr)
{
ApiMobileValidateTracerGuestUserReturnModel rtn = new ApiMobileValidateTracerGuestUserReturnModel();
List <ApiMobileValidateTracerGuestUserReturnModel> rtnData;
rtnErr = string.Empty;
using (var db = new DBMEdition01Context())
{
try
{
rtnData = db.ApiMobileValidateTracerGuestUser(email);
if (rtnData != null && rtnData.Count > 0)
{
rtn = rtnData.FirstOrDefault();
}
else
{
rtnErr = "No valid guest links available. Please contact your Program Administrator";
}
}
catch (Exception ex)
{
string sqlParam = "ApiMobileValidateTracerGuestUser(" + email + ")";
string methodName = "JCRAPI/Business/GuestUserServices/ValidateTracerGuestUser";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(null);
}
}
return(rtn);
}
public static List <AssignedUser> GetUsers(string lstUserIDs, int siteId)
{
List <ApiGetUsersReturnModel> _dbResult;
using (var db = new DBMEdition01Context())
{
try
{
_dbResult = db.ApiGetUsers(lstUserIDs);
var _usrList = _dbResult.Select(m => new AssignedUser
{
FirstName = m.FirstName,
LastName = m.LastName,
EmailAddress = m.EmailAddress,
UserId = m.UserID
}
).ToList();
return(_usrList);
}
catch (Exception ex)
{
string sqlParam = "ApiGetUsers(" + lstUserIDs + ")";
string methodName = "JCRAPI/Business/TaskService/GetUsers";
new ExceptionLogServices().ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteId, sqlParam, string.Empty);
return(null);
}
}
}
public int GetSiteIDByTracerCustomID(int tracerCustomID)
{
int siteID = 0;
using (var db = new DBMEdition01Context())
{
try
{
var _result = db.ApiSelectTracerSiteByTracerCustomId(tracerCustomID);
if (_result != null && _result.Count > 0)
{
siteID = (int)_result[0].SiteID;
}
}
catch (Exception ex)
{
string sqlParam = "ApiSelectTracerSiteByTracerCustomId(" + tracerCustomID + ")";
string methodName = "JCRAPI/Business/SiteServices/GetTracerSitesByUser";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(0);
}
}
return(siteID);
}
public List <ApiGuestUserTracerDetailSelectBySiteProgramReturnModel> GetGuestUserTracersBySiteProgram(int?userId, int?siteId, int?programId, int?statusId)
{
string localUserId = userId != null?userId.ToString() : "null";
string localSiteId = siteId != null?siteId.ToString() : "null";
string localProgramId = programId != null?programId.ToString() : "null";
string localStatusId = statusId != null?statusId.ToString() : "null";
List <ApiGuestUserTracerDetailSelectBySiteProgramReturnModel> rtn;
{
using (var db = new DBMEdition01Context())
{
try
{
rtn = db.ApiGuestUserTracerDetailSelectBySiteProgram(userId, siteId, programId, statusId);
}
catch (Exception ex)
{
string sqlParam = "ApiGuestUserTracerDetailSelectBySiteProgram(" + localUserId + "," + localSiteId + "," + localProgramId + "," + localStatusId + ")";
string methodName = "JCRAPI/Business/GuestUserServices/GetGuestUserTracersBySiteProgram";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, siteId, sqlParam, string.Empty);
return(null);
}
}
return(rtn);
}
}
public int SaveTracerCategory(TracerCategory tracerCategory)
{
try
{
ApiSaveTracerCategoryReturnModel _dbResult;
using (var db = new DBMEdition01Context())
{
_dbResult = db.ApiSaveTracerCategory(tracerCategory.TracerCategoryID,
tracerCategory.TracerCategoryName, tracerCategory.SiteID,
tracerCategory.UpdatedByID, false).FirstOrDefault();
}
return(_dbResult == null ? 0 : (int)_dbResult.TracerCategoryID);
}
catch (Exception ex)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.ApiSaveTracerCategory @TracerCategoryID='{0}'", tracerCategory.TracerCategoryID);
sb.AppendFormat(",@TracerCategoryName='{0}'", tracerCategory.TracerCategoryName);
sb.AppendFormat(",@SiteID='{0}'", tracerCategory.SiteID);
sb.AppendFormat(",@UpdatedByID='{0}'", tracerCategory.UpdatedByID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerCategoryServices/GetTracerCategoryBySite";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, tracerCategory.SiteID, sqlParam, string.Empty);
return(0);
}
}
public static List <SelectOption> GetTagsByCopAndProgramID(int?programId, string copName)
{
List <ApiGetTagsByCoPReturnModel> _dbResult;
using (var db = new DBMEdition01Context())
{
_dbResult = db.ApiGetTagsByCoP(programId, copName);
}
_dbResult.ForEach(m =>
{
var elements = GetElementsByCopId(programId, m.TagCode);
m.HeaderText = string.Format("{0} - {1}", m.TagCode, elements[0].JcrElementText);
}
);
var _result = _dbResult.Select(m =>
new SelectOption
{
Value = m.TagCode,
Name = formatString(m.HeaderText, 100)
}
).ToList();
return(_result);
}
public bool DeleteTracerCategory(int tracerCategoryId, int siteId, int updatedById, int?newTracerCategoryId = null)
{
try
{
var _dbResult = new ApiDeleteTracerCategoryReturnModel();
using (var db = new DBMEdition01Context())
{
_dbResult = db.ApiDeleteTracerCategory(tracerCategoryId, siteId, updatedById, newTracerCategoryId).FirstOrDefault();
}
return(_dbResult == null ? false : (bool)_dbResult.Result);
}
catch (Exception ex)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.ApiDeleteTracerCategory @TracerCategoryID='{0}'", tracerCategoryId);
sb.AppendFormat(",@SiteID='{0}'", siteId);
sb.AppendFormat(",@NewTracerCategoryID='{0}'", newTracerCategoryId);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerCategoryServices/DeleteTracerCategory";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteId, sqlParam, string.Empty);
return(false);
}
}
public List <AssignedUser> GetUsersDetails(string lstUserIDs, int siteID)
{
List <ApiGetUsersDetailsReturnModel> _dbResult;
using (var db = new DBMEdition01Context())
{
try
{
_dbResult = db.ApiGetUsersDetails(lstUserIDs, siteID);
var _usrList = _dbResult.Select(m => new AssignedUser
{
FirstName = m.FirstName,
LastName = m.LastName,
EmailAddress = m.EmailAddress,
IsExternal = m.IsExternal,
UserId = m.UserID
}
).OrderBy(x => x.FormattedFullName).ThenBy(x => x.UserRole).ToList();
return(_usrList);
}
catch (Exception ex)
{
string sqlParam = "ApiGetUsersDetails(" + lstUserIDs + "," + siteID + ")";
string methodName = "JCRAPI/Business/TracerService/GetUsersDetails";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteID, sqlParam, string.Empty);
return(null);
}
}
}
public List <AssignedUser> GetUsersForBrowsing(string searchString, string siteList)
{
List <ApiGetUsersForAssignmentReturnModel> _dbResult;
searchString = searchString == null ? "" : searchString;
using (var db = new DBMEdition01Context())
{
try
{
_dbResult = db.ApiGetUsersForAssignment(searchString, siteList);
var _usrList = _dbResult.Select(m => new AssignedUser
{
FirstName = m.FirstName,
LastName = m.LastName,
EmailAddress = m.EmailAddress,
IsExternal = m.IsExternal,
UserId = m.UserID,
UserRole = m.UserRole
}
).OrderBy(x => x.FormattedFullName).ThenBy(x => x.UserRole).ToList();
return(_usrList);
}
catch (Exception ex)
{
string sqlParam = "ApiGetUsersForAssignment(" + searchString + "," + siteList + ")";
string methodName = "JCRAPI/Business/TracerService/GetUsersForBrowsing";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
return(null);
}
}
}
private int GetPasswordResetInterval(int userId)
{
int result = 0;
using (var db = new DBMEdition01Context())
{
try
{
if (db.ApiGetPasswordResetInterval(userId).Count > 0)
{
try
{
result = (int)db.ApiGetPasswordResetInterval(userId).FirstOrDefault().Interval;
}
catch (Exception ex)
{
string sqlParam = "ApiGetPasswordResetInterval(" + userId + ")";
string methodName = "JCRAPI/Business/UserServices/GetPasswordResetInterval";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty);
}
}
}
catch (Exception ex)
{
string sqlParam = "ApiGetPasswordResetInterval(" + userId + ")";
string methodName = "JCRAPI/Business/UserServices/GetPasswordResetInterval";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
}
}
return(result);
}
public List <ApiMobileGuestUserSelectProgramsBySiteReturnModel> GetGuestUserProgramsBySiteId(int userId, int siteId, int productId)
{
List <ApiMobileGuestUserSelectProgramsBySiteReturnModel> rtn;
UserServices userService = new UserServices();
using (var db = new DBMEdition01Context())
{
try
{
rtn = db.ApiMobileGuestUserSelectProgramsBySite(userId, siteId, productId);
}
catch (Exception ex)
{
string sqlParam = "ApiMobileGuestUserSelectProgramsBySite(" + userId.ToString() + "," + siteId.ToString() + "," + productId.ToString() + ")";
string methodName = "JCRAPI/Business/GuestUserServices/GetGuestUserProgramsBySiteId";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, siteId, sqlParam, string.Empty);
return(null);
}
//Insert User's fav site and program if dont' have any
if (rtn.Count > 0)
{
if (rtn.Select(x => x.IsPrefered = 1).Count() == 0)
{
userService.SaveSiteProgramPreference(userId, siteId, rtn.FirstOrDefault().ProgramID);
}
}
}
return(rtn);
}
public static Guid?GetFileStreamIDbyFileDisplayName(string FileDisplayName)
{
var ampDbEntityContainer = new DBMEdition01Context();
var result = ampDbEntityContainer.ApiGetFileStreamIDbyFileDisplayName(FileDisplayName).FirstOrDefault().FileStreamID;
return(result);
}
public int UnpublishTracer(int?tracerId, int?updatedById)
{
int _result;
using (var db = new DBMEdition01Context())
{
_result = db.ApiUnpublishTracer(tracerId, updatedById);
}
return(_result);
}
public List <ApiMobileUpdateTracerQuestionAnswerReturnModel> UpdateTracerQuestionAnswer(int?observationId, int?userId, int?tracerQuestionId, int?tracerQuestionAnswerId, decimal?numerator, decimal?denominator, int?questionAnswer, int?questionNoteId, string questionNote, bool?IsResponseRequired, out string rtnMessage)
{
List <ApiMobileUpdateTracerQuestionAnswerReturnModel> _result = new List <ApiMobileUpdateTracerQuestionAnswerReturnModel>();
rtnMessage = string.Empty;
bool IsNotApplicable = false;
if (numerator == 0 && denominator == 0)
{
IsNotApplicable = true;
}
if (!IsNotApplicable)
{
if (denominator < 1)
{
rtnMessage = "Denominator must be greater than 0.";
}
if (numerator > denominator)
{
rtnMessage = "Numerator cannot be greater than the denominator.";
}
if (IsResponseRequired != null)
{
if (IsResponseRequired == true && numerator == null && denominator == null)
{
rtnMessage = "Response to this question is required.";
}
}
_result = null;
}
if (rtnMessage == string.Empty)
{
using (var db = new DBMEdition01Context())
{
try
{
_result = db.ApiMobileUpdateTracerQuestionAnswer(observationId, userId, tracerQuestionId, tracerQuestionAnswerId, numerator, denominator, questionAnswer, questionNoteId, questionNote);
}
catch (Exception ex)
{
string sqlParam = "ApiMobileUpdateTracerQuestionAnswer(" + observationId + "," + userId + "," + tracerQuestionId + "," + tracerQuestionAnswerId + "," + numerator + "," + denominator + "," + questionAnswer + "," + questionNoteId + "," + questionNote + ")";
string methodName = "JCRAPI/Business/TracerMobileServices/UpdateTracerQuestionAnswer";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(null);
}
}
}
return(_result);
}
public static ApiGetChapterStandardByEpTextIdReturnModel GetChapterStandardByEPTextID(string standardEffBeginDate, int epTextID, int programID)
{
ApiGetChapterStandardByEpTextIdReturnModel _result;
using (var db = new DBMEdition01Context())
{
_result = db.ApiGetChapterStandardByEpTextId(standardEffBeginDate, epTextID, programID).FirstOrDefault();
}
return(_result);
}
public static List <ApiGetEPsByStandardReturnModel> GetEPsByStandard(int userId, int productType, int siteId, int programId, int standardTextId, string standardEffBeginDate, int serviceProfileTypeId, int certificationItemId)
{
List <ApiGetEPsByStandardReturnModel> _dbResult;
using (var db = new DBMEdition01Context())
{
_dbResult = db.ApiGetEPsByStandard(userId, productType, siteId, programId, standardTextId, Convert.ToDateTime(standardEffBeginDate), serviceProfileTypeId, certificationItemId);
}
return(_dbResult);
}
public static void UpdateMSWorkFlow(int?mockSurveyWorkFlowId, int?userId, string siteIDs)
{
var dbEntityContainer = new DBMEdition01Context();
try
{
dbEntityContainer.ApiMsUpdateWorkFlow(mockSurveyWorkFlowId, userId, siteIDs);
}
catch (Exception ex)
{
throw ex;
}
}
public static ApiGetTracerByIdReturnModel GetTracerById(int?tracerCustomId)
{
ApiGetTracerByIdReturnModel _dbResult;
using (var db = new DBMEdition01Context())
{
_dbResult = db.ApiGetTracerById(tracerCustomId).ToList().FirstOrDefault();
}
return(_dbResult);
}
public List <ApiMobileGuestUserSelectSitesReturnModel> GetGuestUserSites(int userId, string email)
{
List <ApiMobileGuestUserSelectSitesReturnModel> rtn;
MailAddress address = new MailAddress(email);
string currentHost = "@" + address.Host;
bool isInvalidDomain;
int numberOfInactiveDepartments;
using (var db = new DBMEdition01Context())
{
try
{
rtn = db.ApiMobileGuestUserSelectSites((int)userId, (int)Enums.EProduct.Tracers);
if (rtn.Count > 0)
{
foreach (var item in rtn.ToList())
{
isInvalidDomain = GetGuestAccessDomains(item.SiteID, currentHost);
if (isInvalidDomain) //Check Domain Restriction
{
rtn.Remove(item);
}
numberOfInactiveDepartments = GetDepartmentCount(item.SiteID, item.ProgramID);
if (numberOfInactiveDepartments == 0) //Check Department
{
rtn.Remove(item);
}
if (item.RoleID == null)
{
item.RoleID = 7;
}
}
}
}
catch (Exception ex)
{
string sqlParam = "ApiMobileSaveTracerResponse(" + userId + ",2" + ")";
string methodName = "JCRAPI/Business/GuestUserServices/GetGuestUserSites";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(null);
}
}
rtn = rtn.GroupBy(x => x.SiteID).Select(g => g.First()).ToList();
return(rtn);
}
public static ApiGetCopTagByCmsStandardIdReturnModel GetCopTagByCmsStandardId(int?programId, int?cmsStandardId)
{
ApiGetCopTagByCmsStandardIdReturnModel _dbResult;
using (var db = new DBMEdition01Context())
{
_dbResult = db.ApiGetCopTagByCmsStandardId(programId, cmsStandardId).ToList().FirstOrDefault();
}
_dbResult.JcrElementText = formatString(_dbResult.JcrElementText, 0);
return(_dbResult);
}
public bool GetGuestAccessDomains(int siteId, string currentHost)
{
bool rtn = true;
List <String> guestSettings = new List <String>();
List <ApiSelectGuestAccessDomainBySiteReturnModel> rtnData;
using (var db = new DBMEdition01Context())
{
try
{
rtnData = db.ApiSelectGuestAccessDomainBySite(siteId);
if (rtnData.Count > 0)
{
var domains = rtnData[0].DomainName.ToString();
guestSettings.AddRange(domains.Split(';'));
bool isDomainEnabled = rtnData[0].DomainRestriction.ToString().Trim() == "0" ? false : true;
if (isDomainEnabled)
{
foreach (var domain in guestSettings)
{
if (string.Equals(domain.Trim(), currentHost.Trim(), StringComparison.InvariantCultureIgnoreCase))
{
rtn = false;
}
}
}
else
{
rtn = false;
}
}
}
catch (Exception ex)
{
string sqlParam = "ApiSelectGuestAccessDomainBySite(" + siteId + ")";
string methodName = "JCRAPI/Business/GuestUserServices/GetGuestAccessDomains";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteId, sqlParam, string.Empty);
return(false);
}
}
return(rtn);
}
public void MenuStateInit(Api.Models.UserMenuState.Init userPref)
{
using (var db = new DBMEdition01Context()) {
int result;
try
{
result = db.ApiMenuStateInit(userPref.UserID, userPref.SiteID, userPref.RoleID, userPref.AccessToEdition,
userPref.AccessToAMP, userPref.AccessToTracers, userPref.AccessToERAMP, userPref.AccessToERTracers);
}
catch (Exception ex)
{
string sqlParam = "ApiMenuStateInit(" + userPref.UserID + "," + userPref.SiteID + "," + userPref.RoleID + "," + userPref.AccessToEdition + "," + userPref.AccessToAMP + "," + userPref.AccessToTracers + "," + userPref.AccessToERAMP + "," + userPref.AccessToERTracers + ")";
string methodName = "JCRAPI/Business/MenuServices/MenuStateInit";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userPref.UserID, userPref.SiteID, sqlParam, string.Empty);
}
}
}
public void MenuStateSaveArg(int?userId, string key, string value)
{
using (var db = new DBMEdition01Context())
{
int result;
try
{
result = db.ApiMenuStateSaveArg(userId, key, value);
}
catch (Exception ex)
{
string sqlParam = "ApiMenuStateSaveArg(" + userId + "," + key + "," + value + ")";
string methodName = "JCRAPI/Business/MenuServices/MenuStateSaveArg";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
}
}
}
public void InsertGuestLinkAccessed(int userId, Guid guestLinkGuid)
{
int _result = 0;
using (var db = new DBMEdition01Context())
{
try
{
_result = db.ApiInsertGuestLinkAccessed(userId, guestLinkGuid);
}
catch (Exception ex)
{
string sqlParam = "ApiInsertGuestLinkAccessed(" + userId + "," + guestLinkGuid + ")";
string methodName = "JCRAPI/Business/TracerService/InsertGuestLinkAccessed";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
}
}
}
public static List <ApiGetElementsByTagReturnModel> GetElementsByCopId(int?programId, string tagCode)
{
List <ApiGetElementsByTagReturnModel> _dbResult;
using (var db = new DBMEdition01Context())
{
_dbResult = db.ApiGetElementsByTag(programId, tagCode);
}
_dbResult.ForEach(m =>
{
m.JcrElementText = formatString(m.JcrElementText, 0);
}
);
return(_dbResult);
}
public string CreatePasscode(string email)
{
string rtn;
var userData = new GuestUserInfo();
ApiSelectUserByUserLogonIdReturnModel userInfo;
UserServices userService = new UserServices();
userInfo = userService.GetUserByLogonId(email);
Random generator = new Random();
int passCode = generator.Next(10000, 99999);
using (var db = new DBMEdition01Context())
{
try
{
List <ApiUpdateSelectPasscodeReturnModel> rtnPassCode = db.ApiUpdateSelectPasscode(userInfo.UserID, userInfo.UserID, passCode);
}
catch (Exception ex)
{
string sqlParam = "ApiUpdateSelectPasscode(" + userInfo.UserID + "," + userInfo.UserID + "," + passCode + ")";
string methodName = "JCRAPI/Business/GuestUserServices/CreatePasscode";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userInfo.UserID, null, sqlParam, string.Empty);
return(null);
}
}
var actionTypeId = (int)Enums.ActionTypeEnum.GuestAccessPassCode;
Email setEmail = new Email();
setEmail.To = email;
setEmail.Subject = "Guest Passcode";
setEmail.Body = "Dear <strong>" + userInfo.FirstName + " " + userInfo.LastName + "</strong>,<br/><br/>Here is your new passcode. Please use this code to access your Guest Account.<br/><br/>" +
"<b>New Passcode: " + passCode + "</b><br/>" +
"<br/><i>Please note: This e-mail message was sent from a notification-only address that does not accept incoming e-mail. Do not reply to this message.</i>";
EmailHelpers.SendEmail(setEmail, actionTypeId, 0, userInfo.UserID, string.Empty, userInfo.FirstName + " " + userInfo.LastName);
rtn = "Email with new passcode successfully sent. Use the new passcode to view in-progress observations";
return(rtn);
}
public ApiMenuStateGetReturnModel GetMenuState(int?userId)
{
using (var db = new DBMEdition01Context()) {
ApiMenuStateGetReturnModel result;
try
{
result = db.ApiMenuStateGet(userId).FirstOrDefault();
}
catch (Exception ex)
{
string sqlParam = "ApiMenuStateGet(" + userId + ")";
string methodName = "JCRAPI/Business/MenuServices/GetMenuState";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
return(null);
}
return(result);
}
}
