/// <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));
}
/// <summary>
/// Get the gallery by it's Id
/// </summary>
/// <param name="galleryId">The gallery id.</param>
/// <returns></returns>
public Gallery RetrieveGalleryByGalleryId(int galleryId)
{
SqlParameter[] parameters =
{
_database.MakeParameter("@GalleryId", SqlDbType.Int, 4, galleryId)
};
GalleryItem items = GetItemUserId;
SqlDataReader reader = _database.Reader("Gallery_SelectByPrimaryKey", parameters);
Gallery gallery = Populate(reader, items);
return(gallery);
}
/// <summary>
/// Retrieves a random photo from a specified gallery
/// </summary>
/// <param name="galleryId">The gallery id.</param>
/// <returns></returns>
public Photo RetrieveRandomPhotoByGalleryId(int galleryId)
{
Photo photo = new Photo();
SqlParameter[] parameters =
{
_database.MakeParameter("@GalleryId", SqlDbType.Int, 4, galleryId)
};
SqlDataReader reader = _database.Reader("Photo_RetreiveRandomPhotoByGalleryId", parameters);
List <Photo> photos = PopulatePhotos(reader);
if (photos.Count > 0)
{
photo = photos[0];
}
return(photo);
}
