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;
}
}
