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