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