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