/// <summary>
/// Returns list of images available in the photo Albums database
/// </summary>
/// <param name="cond"></param>
/// <returns></returns>
public DataView GetImages(string cond)
{
AlbumsDS _ds = new AlbumsDS();
IDataAdapter Adp = base.GetAdapter(cte.PhotoAlbumImagesAdp);
DataView images = ((AlbumsDS)base.FillData(Adp, _ds, cond)).PhotoAlbumImages.DefaultView;
images.Sort = "sort asc";
DataTable dt = images.Table;
dt.Columns.Add("Thumb");
dt.Columns.Add("Large");
dt.Columns.Add("Original");
if (dt.Rows.Count > 0)
{
int albumId = (int)dt.Rows[0]["AlbumId"];
string path = PhotoAlbumsManager.GetImagesPath(albumId);
foreach (DataRow dr in dt.Rows)
{
dr["Thumb"] = string.Format("{0}/Thumb/{1}", path, dr["FileName"]);
dr["Large"] = string.Format("{0}/Large/{1}", path, dr["FileName"]);
dr["Original"] = string.Format("{0}/Original/{1}", path, dr["FileName"]);
}
}
dt.AcceptChanges();
return(dt.DefaultView);
}
public DataTable GetAlbumsByNetwork(int MemberId, DateTime?Date, string condition)
{
if (String.Compare(WebContext.Profile.dbUserName, Config.GetFromWebConfig("Admin"), true) == 0)
{
PhotoAlbumsManager paMgr = new PhotoAlbumsManager();
return(paMgr.GetPhotoAlbums(condition).Table);
}
else
{
StringBuilder cond = new StringBuilder();
cond.Append(" and " + GetRelationQueryByMember(MemberId));
if (Date != null)
{
cond.Append(string.Format(" and DateAdded>='{0}'", Date));
}
string sql = string.Format("select * from AlbumsFullView where 1=1" + (condition != null ? condition : "") + " {0}",
cond.ToString());
return(DBUtils.GetDataSet(sql, _lib).Tables[0]);
}
}
