public static void SendAlertToWorkers(bool isTest = false) { try { IEmailTools emailTools = AppTools.InitEmailTools(isTest); emailTools.SendToGroup(2, "A new request has been sent."); emailTools.SendToGroup(3, "A new request has been sent."); } catch (Exception ex) { DBCommands.RecordError(ex); } }
public static UserInfo GetUserByName(string userName, bool isTest = false) { ISprocCalls sprocCalls = AppTools.InitSprocCalls(isTest); UserInfo user = sprocCalls.UserInfoGetByUser(userName); if (user != null) { user.GroupUsers = GetGroupsByUserName(userName, sprocCalls); } return(user); }
public static bool DeleteUser(string userName, bool isTest = false) { try { IMembershipTools membershipTools = AppTools.InitMembershipTools(isTest); return(membershipTools.DeleteUser(userName)); } catch (Exception ex) { DBCommands.RecordError(ex); return(false); } }
private static string InsertUser(UserInfo user, bool isTest) { string errorMessage = string.Empty; IMembershipTools membershipTools = AppTools.InitMembershipTools(isTest); ISprocCalls sprocCalls = AppTools.InitSprocCalls(isTest); if (membershipTools.CreateUser(user.UserName, user.Email, user.Password) == false || sprocCalls.UserInfoUpdate(user) == false) { errorMessage = "Error saving user information."; } return(errorMessage); }
public static Features FeatureGetByID(int featureID, bool IsUnitTest = false) { Features feature = null; try { ISprocCalls sprocCalls = AppTools.InitSprocCalls(IsUnitTest); feature = sprocCalls.FeatureGetByID(featureID); } catch (Exception ex) { DBCommands.RecordError(ex); } return(feature); }
public static Business BusinessGetByUser(string userName, bool isTest = false) { Business business = new Business(); try { ISprocCalls sprocCalls = AppTools.InitSprocCalls(isTest); business = sprocCalls.GetBusinessByUser(userName); business.user = UserManager.GetUserByName(userName); } catch (Exception ex) { DBCommands.RecordError(ex); } return(business); }
public static void FeatureDelete(int featureID, out string errorMessage, bool isUnitTest = false) { try { errorMessage = string.Empty; ISprocCalls sprocCalls = AppTools.InitSprocCalls(isUnitTest); if (sprocCalls.FeatureDelete(featureID) == false) { errorMessage = "Error deleting feature."; } } catch (Exception ex) { errorMessage = ex.Message; DBCommands.RecordError(ex); } }
public static void BusinessUpdate(Business business, out string errorMessage, bool isTest = false) { try { errorMessage = ValidateBusiness(business); if (string.IsNullOrEmpty(errorMessage)) { ISprocCalls sprocCalls = AppTools.InitSprocCalls(isTest); if (sprocCalls.BusinessUpdate(business) == false) { errorMessage = "Error updating business."; } } } catch (Exception ex) { errorMessage = ex.Message; DBCommands.RecordError(ex); } }
public static void FeatureUpdate(Features feature, out string errorMessage, bool isUnitTest = false) { try { ISprocCalls sprocCalls = AppTools.InitSprocCalls(isUnitTest); errorMessage = ValidateFeature(feature); if (string.IsNullOrEmpty(errorMessage)) { if (sprocCalls.FeaturesUpdate(feature) == false) { errorMessage = "Error updating feature " + feature.FeatureName + "."; } } } catch (Exception ex) { errorMessage = ex.Message; DBCommands.RecordError(ex); } }
public static void RequestFeatureUpdate(List <FeatureRequested> features, out string errorMessage, bool isUnitTest = false) { try { errorMessage = string.Empty; ISprocCalls sprocCalls = AppTools.InitSprocCalls(isUnitTest); foreach (FeatureRequested request in features) { if (sprocCalls.RequestedFeatureUpdate(request) == false) { errorMessage = "Error gathering all features"; } } } catch (Exception ex) { errorMessage = ex.Message; DBCommands.RecordError(ex); } }
public static void AppRequestUpdate(AppRequest request, out string errorMessage, bool isUnitTest = false) { try { errorMessage = ValidateRequest(request); if (string.IsNullOrEmpty(errorMessage)) { ISprocCalls sprocCalls = AppTools.InitSprocCalls(isUnitTest); if (sprocCalls.AppRequestUpdate(request) == false) { errorMessage = "Error updating request."; } } } catch (Exception ex) { errorMessage = ex.Message; DBCommands.RecordError(ex); } }
public static List <Business> BusinessGetAll(bool isTest = false) { List <Business> businesses = new List <Business>(); try { ISprocCalls sprocCalls = AppTools.InitSprocCalls(isTest); DataTable table = sprocCalls.BusinessGetAll(); Business business; foreach (DataRow row in table.Rows) { business = new Business(); business.AppLink = (row["AppLink"] != DBNull.Value) ? row["AppLink"].ToString() : ""; business.AppStatus = (row["AppStatus"] != DBNull.Value) ? row["AppStatus"].ToString() : ""; business.BusinessAddress = (row["BusinessAddress"] != DBNull.Value) ? row["BusinessAddress"].ToString() : ""; business.BusinessEmail = (row["BusinessEmail"] != DBNull.Value) ? row["BusinessEmail"].ToString() : ""; business.BusinessHoursEnd = (row["BusinessHoursEnd"] != DBNull.Value) ? row["BusinessHoursEnd"].ToString() : ""; business.BusinessHoursStart = (row["BusinessHoursStart"] != DBNull.Value) ? row["BusinessHoursStart"].ToString() : ""; business.BusinessID = Convert.ToInt32(row["BusinessID"]); business.BusinessName = (row["BusinessName"] != DBNull.Value) ? row["BusinessName"].ToString() : ""; business.BusinessPhone = (row["BusinessPhone"] != DBNull.Value) ? row["BusinessPhone"].ToString() : ""; business.FacebookUrl = (row["FacebookUrl"] != DBNull.Value) ? row["FacebokUrl"].ToString() : ""; business.ImageGalleryUrl = (row["ImageGalleryUrl"] != DBNull.Value) ? row["ImageGalleryUrl"].ToString() : ""; business.IsPublic = Convert.ToBoolean(row["IsPublic"] != DBNull.Value) ? Convert.ToBoolean(row["IsPublic"]) : false; business.Other = (row["Other"] != DBNull.Value) ? row["Other"].ToString() : ""; business.TypeOfBusiness = (row["TypeOfBusiness"] != DBNull.Value) ? row["TypeOfBusiness"].ToString() : ""; business.user = UserManager.GetUserByName(row["UserName"].ToString()); business.WebsiteUrl = (row["WebsiteUrl"] != DBNull.Value) ? row["WebsiteUrl"].ToString() : ""; businesses.Add(business); } } catch (Exception ex) { DBCommands.RecordError(ex); } return(businesses); }