public static List <ClsPhotoList> GetAlbumPhotoList_New(ClsPhotoListInput album) { try { MySqlParameter[] parameterList = new MySqlParameter[1]; parameterList[0] = new MySqlParameter("?AlbumId", album.albumId); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_1_USPAlbumList_New", parameterList); DataTable dtNewPhoto = result.Tables[0]; List <ClsPhotoList> NewPhotoList = new List <ClsPhotoList>(); if (dtNewPhoto.Rows.Count > 0) { NewPhotoList = GlobalFuns.DataTableToList <ClsPhotoList>(dtNewPhoto); foreach (ClsPhotoList g in NewPhotoList) { if (!string.IsNullOrEmpty(g.url)) { string ImageName = g.url.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + album.groupId + "/Album" + album.albumId + "/"; g.url = path + ImageName; } } } ClsPhotoListOutput photoList = new ClsPhotoListOutput(); photoList.newPhotos = NewPhotoList; return(photoList.newPhotos); } catch (Exception ex) { throw ex; } }
public object GetAlbumPhotoList_New(ClsPhotoListInput album) { dynamic TBAlbumPhotoListResult; try { List <ClsPhotoList> Result = Gallery.GetAlbumPhotoList_New(album); if (Result.Count != 0) { TBAlbumPhotoListResult = new { status = "0", message = "success", updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), Result }; } else { TBAlbumPhotoListResult = new { status = "0", message = "Record not found", Result }; } } catch { TBAlbumPhotoListResult = new { status = "1", message = "failed" }; } return(new { TBAlbumPhotoListResult }); }