/// <summary> /// Delete a Gallery by the primary key /// </summary> /// <param name="galleryId">The gallery id.</param> /// <param name="commandText">The command text.</param> /// <returns></returns> private void Delete(int galleryId, string commandText) { SqlParameter[] parameters = { _database.MakeParameter("@GalleryId", SqlDbType.Int, 4, galleryId) }; _database.NonQuery(commandText, parameters); }
/// <summary> /// Moves a photo to a new gallery /// </summary> /// <param name="photo">The photo.</param> public void MovePhotoToNewGallery(Photo photo) { SqlParameter[] parameters = { _database.MakeParameter("@PhotoID", SqlDbType.Int, 4, photo.PhotoID) }; _database.NonQuery("Photo_MovePhotoToNewGallery", parameters); }
/// <summary> /// Inserts User into the Users Table /// </summary> /// <param name="user">A new populated user.</param> /// <returns>Insert Count</returns> public int Insert(User user) { SqlParameter[] parameters = { _database.MakeParameter("@Email", SqlDbType.NVarChar, 50, user.Email), _database.MakeParameter("@Password", SqlDbType.NVarChar, 150, user.Password), _database.MakeParameter("@FirstName", SqlDbType.NVarChar, 50, user.FirstName), _database.MakeParameter("@LastName", SqlDbType.NVarChar, 50, user.LastName), _database.MakeParameter("@Access", SqlDbType.TinyInt, 1, user.Access), _database.MakeParameter("@Website", SqlDbType.NVarChar, 200, user.Website) }; return(_database.NonQuery("User_Insert", parameters)); }