public List <CustomCollectionFiles> GetCollectionListForMaster(int TopicId, char status)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
var query = from gtf in context.Gallery_Topics
join cl in context.Gallery_Collections
on gtf.Gallery_TopicId equals cl.TopicId
where gtf.Status == status && gtf.Gallery_TopicId == TopicId
select new { gtf, cl };
List <CustomCollectionFiles> list = new List <CustomCollectionFiles>();
foreach (var c in query)
{
CustomCollectionFiles file_obj = new CustomCollectionFiles();
file_obj.TopicId = c.gtf.Gallery_TopicId;
file_obj.CollectionId = c.cl.CollectionId;
file_obj.Title = c.cl.Title;
file_obj.IconFile = c.cl.IconFile;
file_obj.Description = c.cl.Description;
file_obj.ListOrder = Convert.ToInt32(c.cl.ListOrder);
file_obj.Tags = c.cl.Tags;
file_obj.Url = c.cl.Url;
file_obj.CreatedOnDate = Convert.ToDateTime(c.cl.CreatedOnDate);
file_obj.LastModifieddDate = Convert.ToDateTime(c.cl.LastModifieddDate);
file_obj.UserLog = c.cl.UserLog.ToString();
file_obj.UserLastUpdate = c.cl.UserLastUpdate.ToString();
file_obj.IPLog = c.cl.IPLog;
file_obj.IPLastUpdate = c.cl.IPLastUpdate;
file_obj.Status = c.cl.Status;
list.Add(file_obj);
}
return(list);
}
}
public List<CustomCollectionFiles> GetCollectionListForMaster(int TopicId, char status)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
var query = from gtf in context.Gallery_Topics
join cl in context.Gallery_Collections
on gtf.Gallery_TopicId equals cl.TopicId
where gtf.Status == status && gtf.Gallery_TopicId == TopicId
select new { gtf, cl };
List<CustomCollectionFiles> list = new List<CustomCollectionFiles>();
foreach (var c in query)
{
CustomCollectionFiles file_obj = new CustomCollectionFiles();
file_obj.TopicId = c.gtf.Gallery_TopicId;
file_obj.CollectionId = c.cl.CollectionId;
file_obj.Title = c.cl.Title;
file_obj.IconFile = c.cl.IconFile;
file_obj.Description = c.cl.Description;
file_obj.ListOrder = Convert.ToInt32(c.cl.ListOrder);
file_obj.Tags = c.cl.Tags;
file_obj.Url = c.cl.Url;
file_obj.CreatedOnDate = Convert.ToDateTime(c.cl.CreatedOnDate);
file_obj.LastModifieddDate = Convert.ToDateTime(c.cl.LastModifieddDate);
file_obj.UserLog = c.cl.UserLog.ToString();
file_obj.UserLastUpdate = c.cl.UserLastUpdate.ToString();
file_obj.IPLog = c.cl.IPLog;
file_obj.IPLastUpdate = c.cl.IPLastUpdate;
file_obj.Status = c.cl.Status;
list.Add(file_obj);
}
return list;
}
}