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