public static String GetUserPreference(int userID, int siteID, int programID, string preferenceType) { String _result = string.Empty; using (var db = new Data.DBMEdition01Context()) { ExceptionLogServices exceptionLog = new ExceptionLogServices(); try { var _ret = db.ApiGetUserPreference(userID, siteID, programID, preferenceType); if (_ret.Count > 0) { _result = _ret.FirstOrDefault().PreferenceValue; } } catch (Exception ex) { string sqlParam = "ApiMobileSaveTracerResponse(" + userID + "," + siteID + "," + programID + "," + preferenceType + ")"; string methodName = "JCRAPI/Business/UserServices/MenuStateInit"; exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userID, siteID, sqlParam, string.Empty); return(null); } } return(_result); }
public static string SaveAttachmentFile(string fileName, byte[] p2, string appCode) { UsmCcmInsertFileReturnModel rtn; ExceptionLogServices exceptionLog = new ExceptionLogServices(); using (var db = new DBFileTableContext()) { //rtn = db.usmc(fileName, p2,).FirstOrDefault().stream_id.ToString(); // rtn = _result.ToString(); try { rtn = db.UsmCcmInsertFile(fileName, p2, appCode).FirstOrDefault(); } catch (Exception ex) { string sqlParam = "UsmCcmInsertFile(" + fileName + "," + p2 + "," + appCode + ")"; string methodName = "JCRAPI/Business/FilesServices/SaveAttachmentFile"; exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, null, sqlParam, string.Empty); return(null); } } return(rtn.stream_ID.ToString()); }
public static void UpdateUserPreference(UserPreference userPref) { using (var db = new Data.DBMEdition01Context()) { ExceptionLogServices exceptionLog = new ExceptionLogServices(); try { db.ApiUpdateUserPreference(userPref.UserID, userPref.SiteID, userPref.ProgramID, userPref.preferenceType, userPref.PreferenceValue); } catch (Exception ex) { string sqlParam = "ApiUpdateUserPreference(" + userPref.UserID + "," + userPref.SiteID + "," + userPref.ProgramID + "," + userPref.preferenceType + "," + userPref.PreferenceValue + ")"; string methodName = "JCRAPI/Business/UserServices/UpdateUserPreference"; exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userPref.UserID, userPref.SiteID, sqlParam, string.Empty); } } }
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 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 static List <ApiGetProgramsBySiteReturnModel> GetProgramsBySite(int siteID) { List <ApiGetProgramsBySiteReturnModel> _result; using (var db = new Data.DBMEdition01Context()) { ExceptionLogServices exceptionLog = new ExceptionLogServices(); try { _result = db.ApiGetProgramsBySite(siteID); } catch (Exception ex) { string sqlParam = "ApiGetUserSites(" + siteID + ")"; string methodName = "JCRAPI/Business/SiteServices/GetProgramsBySite"; exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, siteID, 0, sqlParam, string.Empty); return(null); } } return(_result); }
public static List <ApiGetAllUserSitesReturnModel> GetUserSites(int userID) { List <ApiGetAllUserSitesReturnModel> _result; using (var db = new Data.DBAMPContext()) { ExceptionLogServices exceptionLog = new ExceptionLogServices(); try { _result = db.ApiGetAllUserSites(userID); } catch (Exception ex) { string sqlParam = "ApiGetUserSites(" + userID + ")"; string methodName = "JCRAPI/Business/SiteServices/ApiGetUserSites"; exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userID, 0, sqlParam, string.Empty); return(null); } } return(_result); }
public TracerCategoryServices() { exceptionLog = new ExceptionLogServices(); }
public static string ValidatePasswordRules(int userId, string newPassword) { //get existing site settings string attributeList = ""; int siteId; string existingPassword; List <ApiSelectSiteAttributeMapReturnModel> passwordRestrictions = new List <ApiSelectSiteAttributeMapReturnModel>(); attributeList = ((int)Enums.CodeCategoryEnum.SitePasswordResetInterval).ToString() + "," + ((int)Enums.CodeCategoryEnum.SitePasswordSpecialRequirements).ToString() + "," + ((int)Enums.CodeCategoryEnum.SitePasswordLength).ToString() + "," + ((int)Enums.CodeCategoryEnum.SitePasswordUpperCaseRequirements).ToString() + "," + ((int)Enums.CodeCategoryEnum.SitePasswordNumericRequirements).ToString(); ExceptionLogServices exceptionLog = new ExceptionLogServices(); using (var db = new DBAMPContext()) { try { siteId = db.ApiGetUserDefaultSiteId(userId).FirstOrDefault().DefaultSelectedSiteId; } catch (Exception ex) { string sqlParam = "ApiGetUserDefaultSiteId(" + userId + ")"; string methodName = "JCRAPI/Business/UserServices/ValidatePasswordRules"; exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty); siteId = 0; } try { existingPassword = db.ApiGetUserPassword(userId).FirstOrDefault().AttributeValue; } catch (Exception ex) { string sqlParam = "ApiGetUserPassword(" + userId + ")"; string methodName = "JCRAPI/Business/UserServices/ValidatePasswordRules"; exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, siteId, sqlParam, string.Empty); existingPassword = string.Empty; } } using (var db = new DBMEdition01Context()) { try { passwordRestrictions = db.ApiSelectSiteAttributeMap(siteId, attributeList); } catch (Exception ex) { string sqlParam = "ApiSelectSiteAttributeMap(" + siteId + "," + attributeList + ")"; string methodName = "JCRAPI/Business/UserServices/ValidatePasswordRules"; exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, siteId, sqlParam, string.Empty); existingPassword = string.Empty; } } bool textRestrictions = false; string retValue = ""; bool passwordGood = true; foreach (var restriction in passwordRestrictions) { int rowCode = Convert.ToInt32(restriction.AttributeTypeID.ToString()); int rowValue = Convert.ToInt32(restriction.AttributeValueID.ToString()); switch (rowCode) { case (int)Enums.CodeCategoryEnum.SitePasswordLength: if (newPassword.Trim().Length < rowValue) { retValue += "###Minimum Password Length is " + rowValue.ToString() + " Characters"; passwordGood = false; } break; case (int)Enums.CodeCategoryEnum.SitePasswordResetInterval: string encyptEnteredPwd = ""; if (newPassword.Trim().Length > 0) { encyptEnteredPwd = CryptHelpers.Encrypt(newPassword.Trim(), WebConstants.EncryptionKey); } if (encyptEnteredPwd == existingPassword) { retValue += "###Existing password cannot be used"; passwordGood = false; } break; case (int)Enums.CodeCategoryEnum.SitePasswordSpecialRequirements: if (rowValue == 1) { char[] anyChars = { '!', '#', '$', '%', '&', '(', ')', '*', '+', ',', '.', '/', ':', '<', '=' , '>', '?', '@', '[', '\\', ']', '^', '_', '`', '{', '|', '}', '~', '"' }; // special chars int index = newPassword.IndexOfAny(anyChars); if (index < 0) { passwordGood = false; retValue += "###At least one Special Character is required: ! # $ % & ( ) * + , . / : < = > ? @ [ \\ ] ^ _ ` { | } ~ \" Characters below cannot be used ' - ; "; } textRestrictions = true; } break; case (int)Enums.CodeCategoryEnum.SitePasswordUpperCaseRequirements: if (rowValue == 1) { char[] anyChars = { 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O' , 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z' }; // special chars int index = newPassword.IndexOfAny(anyChars); if (index < 0) { passwordGood = false; retValue += "###At least one Upper Case Character is required "; } textRestrictions = true; } break; case (int)Enums.CodeCategoryEnum.SitePasswordNumericRequirements: if (rowValue == 1) { char[] anyChars = { '0', '1', '2', '3', '4', '5', '6', '7', '8', '9' }; // special chars int index = newPassword.IndexOfAny(anyChars); if (index < 0) { passwordGood = false; retValue += "###At least one Numeric Character is required "; } textRestrictions = true; } break; } } if (textRestrictions) { char[] anyChars = { 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z' }; // special chars int index = newPassword.IndexOfAny(anyChars); if (index < 0) { passwordGood = false; retValue += "###At least one Lower Case Character is required"; } } if (passwordGood) { retValue = ""; } return(retValue); }