public override bool FeaturesUpdate(Features feature)
{
DBCommands.PopulateParams("@FeatureID", feature.FeatureID);
DBCommands.PopulateParams("@FeatureName", feature.FeatureName);
DBCommands.PopulateParams("@MainFeature", feature.MainFeature);
DBCommands.PopulateParams("@FeatureDescription", feature.FeatureDescription);
return(DBCommands.ExecuteNonQuery("p_Feature_Update"));
}
public override bool AppRequestUpdate(AppRequest request)
{
DBCommands.PopulateParams("@AppRequestID", request.AppRequestID);
DBCommands.PopulateParams("@DateRequested", request.DateRequested);
DBCommands.PopulateParams("@BusinessID", request.AppBusiness.BusinessID);
DBCommands.PopulateParams("@DevStatus", request.DevStatus);
return(DBCommands.ExecuteNonQuery("p_AppRequest_Update"));
}
public override bool UserInfoUpdate(UserInfo user)
{
DBCommands.PopulateParams("@UserName", user.UserName);
DBCommands.PopulateParams("@ProfileImage", user.ProfileImage);
DBCommands.PopulateParams("@Phone", user.Phone);
DBCommands.PopulateParams("@Name", user.Name);
DBCommands.PopulateParams("@AddBusiness", user.AddBusiness);
DBCommands.PopulateParams("@GroupUsers", MapGroupListToTable(user.GroupUsers));
return(DBCommands.ExecuteNonQuery("p_UserInfo_Update"));
}
public override bool RequestedFeatureUpdate(FeatureRequested feature)
{
DBCommands.PopulateParams("@FeatureRequestedID", feature.FeatureRequestedID);
DBCommands.PopulateParams("@AppRequestID", feature.AppRequestID);
DBCommands.PopulateParams("@FeatureID", feature.RequestedFeature.FeatureID);
DBCommands.PopulateParams("@DateRequested", feature.DateRequested);
DBCommands.PopulateParams("@DevStatus", feature.DevStatus);
DBCommands.PopulateParams("@AssignedTo", feature.AssignedTo);
DBCommands.PopulateParams("@Active", feature.Active);
return(DBCommands.ExecuteNonQuery("p_FeatureRequested_Update"));
}
public override bool BusinessUpdate(Business business)
{
DBCommands.PopulateParams("@BusinessID", business.BusinessID);
DBCommands.PopulateParams("@BusinessName", business.BusinessName);
DBCommands.PopulateParams("@BusinessEmail", business.BusinessEmail);
DBCommands.PopulateParams("@BusinessAddress", business.BusinessAddress);
DBCommands.PopulateParams("@BusinessHoursStart", business.BusinessHoursStart);
DBCommands.PopulateParams("@BusinessHoursEnd", business.BusinessHoursEnd);
DBCommands.PopulateParams("@WebsiteUrl", business.WebsiteUrl);
DBCommands.PopulateParams("@FacebookUrl", business.FacebookUrl);
DBCommands.PopulateParams("@ImageGalleryUrl", business.ImageGalleryUrl);
DBCommands.PopulateParams("@Other", business.Other);
DBCommands.PopulateParams("@TypeOfBusiness", business.TypeOfBusiness);
DBCommands.PopulateParams("@AppLink", business.AppLink);
DBCommands.PopulateParams("@IsPublic", business.IsPublic);
DBCommands.PopulateParams("@AppStatus", business.AppStatus);
DBCommands.PopulateParams("@UserName", business.user.UserName);
return(DBCommands.ExecuteNonQuery("p_Business_Update"));
}
public override bool FeatureDelete(int featureID)
{
DBCommands.PopulateParams("@FeatureID", featureID);
return(DBCommands.ExecuteNonQuery("p_Feature_Delete"));
}