public static DataTable GetPhotoByMemberPhotoID(int MemberPhotoID)
{
MemberPhotos mPhotos = new MemberPhotos();
mPhotos.MemberPhotoID = MemberPhotoID;
return(mPhotos.LoadByParams().Tables[0]);
}
public static void DeletePhoto(int MemberPhotoID)
{
MemberPhotos mPhotos = new MemberPhotos();
mPhotos.MemberPhotoID = MemberPhotoID;
mPhotos.Delete();
}
public static DataTable GetPhotos(int MemberID)
{
MemberPhotos mPhotos = new MemberPhotos();
mPhotos.MemberID = MemberID;
mPhotos.PhotoType = (int)Enumerations.PhotoType.Photo;
return(mPhotos.LoadByParams().Tables[0]);
}
public static int InsertAlbum(string AlbumName, int MemberID)
{
MemberPhotos mPhotos = new MemberPhotos();
mPhotos.MemberID = MemberID;
mPhotos.PhotoName = AlbumName;
mPhotos.PhotoType = (int)Enumerations.PhotoType.Album;
return(mPhotos.Save());
}
public static bool InsertPhoto(string PhotoUrl, int AlbumID, int MemberID)
{
try
{
MemberPhotos mPhotos = new MemberPhotos();
mPhotos.MemberID = MemberID;
mPhotos.PhotoUrl = PhotoUrl;
mPhotos.AlbumID = AlbumID;
mPhotos.PhotoType = (int)Enumerations.PhotoType.Photo;
mPhotos.Save();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
/// <summary>
/// Creates MemberPhotos for records In the prefilled DataReader, And puts them into a HashTable
/// </summary>
/// <param name="dr">The DataReader prefilled With the MemberPhotos records</param>
/// <returns>The Hashtable containing MemberPhotos objects And their ID As key.</returns>
protected static Hashtable ConvertReaderToHashTable(SqlDataReader dr)
{
Hashtable result = new Hashtable();
while (dr.Read())
{
MemberPhotos myMemberPhotos = new MemberPhotos();
myMemberPhotos.m_intMemberPhotoID = dr.GetSqlInt32(0);
myMemberPhotos.m_strPhotoName = dr.GetSqlString(1);
myMemberPhotos.m_strPhotoDesc = dr.GetSqlString(2);
myMemberPhotos.m_strPhotoUrl = dr.GetSqlString(3);
myMemberPhotos.m_intPhotoType = dr.GetSqlInt32(4);
myMemberPhotos.m_intAlbumID = dr.GetSqlInt32(5);
myMemberPhotos.m_intMemberID = dr.GetSqlInt32(6);
result.Add(myMemberPhotos.MemberPhotoID, myMemberPhotos);
}
return(result);
}
public static void DeleteAlbum(int MemberPhotoID)
{
MemberPhotos.DeleteAlbum(MemberPhotoID);
}
