public object GetAlbumsList_New(ClsAlbumListInput gallery) { dynamic TBAlbumsListResult; try { ClsAlbumListOutput Result = Gallery.GetGalleryList_New(gallery); if (Result != null) { TBAlbumsListResult = new { status = "0", message = "success", updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), Result }; } else { TBAlbumsListResult = new { status = "0", message = "Record not found", Result }; } } catch { TBAlbumsListResult = new { status = "1", message = "failed" }; } return(new { TBAlbumsListResult }); }
//public static ClsGetShowcaseDetailsOutPut GetShowcaseDetails(GetShowcaseDetails clschowcase) //{ // try // { // string sqlProc; // sqlProc = "V1_USPGetShowcaseDetails"; // MySqlParameter[] parameterList = new MySqlParameter[0]; // parameterList[0] = new MySqlParameter("?DistrictID", clschowcase.DistrictID); // //parameterList[1] = new MySqlParameter("?ProfileID", monthCal.profileId); // //parameterList[2] = new MySqlParameter("?Curr_Date", monthCal.selectedDate); // //parameterList[3] = new MySqlParameter("?UpdatedOn", monthCal.updatedOn); // DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList); // DataTable dtClub = result.Tables[0]; // List<GetShowcaseDetails> ClubList = new List<GetShowcaseDetails>(); // if (dtClub.Rows.Count > 0) // { // ClubList = GlobalFuns.DataTableToList<GetShowcaseDetails>(dtClub); // } // ClsGetShowcaseDetailsOutPut showcase = new ClsGetShowcaseDetailsOutPut(); // showcase.Club = ClubList; // return showcase; // } // catch // { // throw; // } //} public static ClsAlbumListOutput GetGalleryList_New(ClsAlbumListInput gallery) { try { MySqlParameter[] parameterList = new MySqlParameter[10]; parameterList[0] = new MySqlParameter("?grpId", gallery.groupId); parameterList[1] = new MySqlParameter("?district_id", gallery.district_id); parameterList[2] = new MySqlParameter("?category_id", gallery.category_id); parameterList[3] = new MySqlParameter("?year", gallery.year); parameterList[4] = new MySqlParameter("?club_id", gallery.club_id); parameterList[5] = new MySqlParameter("?SharType", gallery.SharType); parameterList[6] = new MySqlParameter("?ProfileId", gallery.profileId); parameterList[7] = new MySqlParameter("?ModuleID", gallery.moduleId); parameterList[8] = new MySqlParameter("?ClubRotaryType", gallery.ClubRotaryType); parameterList[9] = new MySqlParameter("?SearchText", gallery.searchText);//Nitesh Tiwari 27.03.2019 12.30 pm DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V7_1_USPGalleryList", parameterList); DataTable dtNewAlbums = result.Tables[0]; //DataTable dtTotals = result.Tables[0]; //DataTable dtDeletedAlbums = result.Tables[2]; List <ClsAlbumList> NewMemberList = new List <ClsAlbumList>(); //List<ClsTotalOutput> TotalList = new List<ClsTotalOutput>(); if (dtNewAlbums.Rows.Count > 0) { NewMemberList = GlobalFuns.DataTableToList <ClsAlbumList>(dtNewAlbums); //TotalList = GlobalFuns.DataTableToList<ClsTotalOutput>(dtTotals); foreach (ClsAlbumList g in NewMemberList) { if (!string.IsNullOrEmpty(g.image)) { string ImageName = g.image.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.image = path + ImageName; } if (!string.IsNullOrEmpty(g.AgendaDocID)) { string ImageName = g.AgendaDocID.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.AgendaDocID = path + ImageName; } if (!string.IsNullOrEmpty(g.MOMDocID)) { string ImageName = g.MOMDocID.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.MOMDocID = path + ImageName; } } } ClsAlbumListOutput galleryList = new ClsAlbumListOutput(); galleryList.newAlbums = NewMemberList; //galleryList.TotalList = TotalList; return(galleryList); } catch (Exception ex) { throw ex; } }
//private static TouchBaseWebAPI.Data.row_productionEntities _DBTouchbase = new TouchBaseWebAPI.Data.row_productionEntities(); public static ClsAlbumListOutput GetGalleryList(ClsAlbumListInput gallery) { try { MySqlParameter[] parameterList = new MySqlParameter[4]; parameterList[0] = new MySqlParameter("?ProfileId", gallery.profileId); parameterList[1] = new MySqlParameter("?GroupId", gallery.groupId); parameterList[2] = new MySqlParameter("?UpdatedOn", gallery.updatedOn); parameterList[3] = new MySqlParameter("?ModuleID", gallery.moduleId); // parameterList[3] = new MySqlParameter("?UpdatedOn", gallery.updatedOn); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V6_1_USPGalleryList", parameterList); DataTable dtNewAlbums = result.Tables[0]; DataTable dtUpdatedAlbums = result.Tables[1]; DataTable dtDeletedAlbums = result.Tables[2]; List <ClsAlbumList> NewMemberList = new List <ClsAlbumList>(); if (dtNewAlbums.Rows.Count > 0) { NewMemberList = GlobalFuns.DataTableToList <ClsAlbumList>(dtNewAlbums); foreach (ClsAlbumList g in NewMemberList) { if (!string.IsNullOrEmpty(g.image)) { string ImageName = g.image.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.image = path + ImageName; } } } List <ClsAlbumList> updatedMemberList = new List <ClsAlbumList>(); if (dtUpdatedAlbums.Rows.Count > 0) { updatedMemberList = GlobalFuns.DataTableToList <ClsAlbumList>(dtUpdatedAlbums); foreach (ClsAlbumList g in updatedMemberList) { if (!string.IsNullOrEmpty(g.image)) { string ImageName = g.image.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.image = path + ImageName; } } } ClsAlbumListOutput galleryList = new ClsAlbumListOutput(); galleryList.deletedAlbums = dtDeletedAlbums.Rows[0]["GalleryId"].ToString(); galleryList.newAlbums = NewMemberList; galleryList.updatedAlbums = updatedMemberList; return(galleryList); } catch (Exception ex) { throw ex; } }