コード例 #1
0
 public static List<Media_Albums> GetActiveListByTypeIdFixedNum(int TypeId, int iTotalItemCount)
 {
     using (System.Transactions.TransactionScope transScope = new System.Transactions.TransactionScope())
     {
         List<Media_Albums> lst = new List<Media_Albums>();
         using (MediaEntities dbContext = new MediaEntities())
         {
             try
             {
                 dbContext.CommandTimeout = 216000;
                 var query = from x in dbContext.Media_Albums where x.Status =="1" && x.TypeId ==TypeId orderby x.AlbumId descending select x;
                 int TotalItemCount = 0;
                 if (query.Count() > 0)
                 {
                     if (iTotalItemCount <= query.Count())
                         TotalItemCount = iTotalItemCount;
                     else
                         TotalItemCount = query.Count();
                 }                        
                 lst = query.Take(TotalItemCount).ToList();
                 transScope.Complete();
             }catch(Exception  ex){ex.InnerException.Message.ToString();}
             finally
             {
                 if (dbContext.Connection.State != System.Data.ConnectionState.Closed)                       
                     dbContext.Connection.Close();                       
             }
             return lst;
         }                
     }
 }
コード例 #2
0
        //INSERT- UPDATE - DELETE 
        public int Insert(string UserId, int TypeId, int ParentId, string Name, string Photo, string Description, string Status)
        {
            string Alias = module_obj.createTags(Name);
            using (MediaEntities dbContext = new MediaEntities())
            {
                dbContext.CommandTimeout = Settings.CommandTimeout;
                System.Nullable<Int32> ListOrder = (from u in dbContext.Media_Types select u.TypeId).DefaultIfEmpty(0).Max() + 1;

                Media_Topics topic_obj = new Media_Topics();
                topic_obj.TypeId = TypeId;
                topic_obj.Name = Name;
                topic_obj.Alias = Alias;
                topic_obj.ParentId = ParentId;
                topic_obj.ListOrder = (ListOrder == null ? 1 : ListOrder);
                topic_obj.Photo = Photo;
                topic_obj.Description = Description;
                topic_obj.IPLog = IP;
                topic_obj.CreatedByUserId = new Guid(UserId);
                topic_obj.CreatedOnDate = System.DateTime.Now;
                topic_obj.Status = Status;
                dbContext.AddToMedia_Topics(topic_obj);
                int i = dbContext.SaveChanges();
                return i;
            }
        }
コード例 #3
0
 public Media_Topics GetDetailById(int idx)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Topics topic_obj = dbContext.Media_Topics.Where(x => x.TopicId == idx).FirstOrDefault();
         return topic_obj;
     }   
 }        
コード例 #4
0
 public static List<Media_Composers> LoadAll()
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         _items = (from x in dbContext.Media_Composers select x).ToList();
         return _items;
     }
 }
コード例 #5
0
 public string GetTypePathByTypeId(int idx)
 {            
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         string TypePath = (from x in dbContext.Media_Types where x.TypeId == idx select x.TypePath).SingleOrDefault();
         return TypePath;
     }        
 }
コード例 #6
0
 public Media_Types GetDetails(int idx)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Types type_obj = dbContext.Media_Types.Where(x => x.TypeId == idx).FirstOrDefault();
         return type_obj;
     }   
 }
コード例 #7
0
 public List<Media_Topics> GetListByStatus(string Status)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         IQueryable<Media_Topics> query = from x in dbContext.Media_Topics select x;
         if (!string.IsNullOrEmpty(Status))
             query = query.Where(x => x.Status == Status);
         return query.ToList();
     }  
 }
コード例 #8
0
 public static List<Media_Composers> GetListByStatus(string status)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         IQueryable<Media_Composers> query = from x in dbContext.Media_Composers select x;
         if (string.IsNullOrEmpty(status))
             _items = query.ToList();
         else
             _items = query.Where(x => x.Status == status).ToList();
         return _items;
     }        
 }
コード例 #9
0
 //================================================================================
 public static List<Media_Artists> GetActiveListByFixedNum(int iTotalItemCount)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         var query = from x in dbContext.Media_Artists where x.Status.Equals("1") orderby x.ArtistId descending select x;
         int TotalItemCount = 0;                
         if (iTotalItemCount <= query.Count())
             TotalItemCount = iTotalItemCount;
         else
             TotalItemCount = query.Count();                
         return query.Take(TotalItemCount).ToList();
     }
 }
コード例 #10
0
 public List<Media_Types> GetListByStatus(string status)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         IQueryable<Media_Types> query = from x in dbContext.Media_Types select x;
         List<Media_Types> lst= new List<Media_Types>();
         if (string.IsNullOrEmpty(status))
             lst = query.ToList();
         else
             lst = query.Where(x => x.Status == status).ToList();
         return lst;
     }        
 }
コード例 #11
0
 //=================================================================================================
 public static List<Media_PlayLists> GetActiveListByTypeIdFixedNum(int TypeId, int iTotalItemCount)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         var query = from x in dbContext.Media_PlayLists where x.Status=="1" && x.TypeId==TypeId orderby x.PlayListId descending select x;
         int TotalItemCount = 0;
         if (query.Count() > 0)
         {
             if (iTotalItemCount <= query.Count())
                 TotalItemCount = iTotalItemCount;
             else
                 TotalItemCount = query.Count();
         }
         return query.Take(TotalItemCount).ToList();
     }
 }
コード例 #12
0
        public static List<Media_Composers> LoadDatedItemsByPage(string status, int startRow, int pageSize, string sortBy, bool sortAscending)
        {
            using (MediaEntities dbContext = new MediaEntities())
            {
                //List<Media_Artists> list = (from p in dbContext.Media_Artists select p).Skip(startRow * pageSize).Take(pageSize).ToList();

                SortData(sortBy, sortAscending);
                //copy to an array
                int count = pageSize;
                _items = GetListByStatus(status);
                if ((_items.Count - startRow) < count) count = _items.Count - startRow;
                Media_Composers[] pagearray = new Media_Composers[count];

                _items.CopyTo(startRow, pagearray, 0, count);
                //then create a list from array
                List<Media_Composers> page = new List<Media_Composers>(pagearray);
                return page;
            }
        }
コード例 #13
0
        //INSERT- UPDATE - DELETE 
        public int Insert(string UserId, string TypeName, string TypeExt, string TypePath, string Description, string Status)
        {
            using (MediaEntities dbContext = new MediaEntities())
            {
                dbContext.CommandTimeout = Settings.CommandTimeout;
                System.Nullable<Int32> ListOrder = (from u in dbContext.Media_Types select u.TypeId).DefaultIfEmpty(0).Max() + 1;

                Media_Types type_obj = new Media_Types();
                type_obj.TypeName = TypeName;
                type_obj.TypeExt = TypeExt;
                type_obj.TypePath = TypePath;
                type_obj.Description = Description;
                type_obj.CreatedByUserId = new Guid(UserId);
                type_obj.CreatedOnDate = System.DateTime.Now;                
                type_obj.IPLog = IP;
                type_obj.ListOrder = (ListOrder == null ? 1 : ListOrder);
                type_obj.Status = Status;
                dbContext.AddToMedia_Types(type_obj);
                int i  = dbContext.SaveChanges();
                return i;
            }
        }
コード例 #14
0
        //INSERT- UPDATE - DELETE 
        public int Insert(string UserId, string ComposerName, string FrontImage, string MainImage, string Description, string Status)
        {
            using (MediaEntities dbContext = new MediaEntities())
            {
                string Alias = StringUtils.GenerateFriendlyString(ComposerName);
                dbContext.CommandTimeout = Settings.CommandTimeout;
                System.Nullable<Int32> ListOrder = (from u in dbContext.Media_Composers select u.ListOrder).DefaultIfEmpty(0).Max() + 1;

                Media_Composers composers_obj = new Media_Composers();
                composers_obj.ComposerName = ComposerName;
                composers_obj.Alias = Alias;
                composers_obj.FrontImage = FrontImage;
                composers_obj.MainImage = MainImage;
                composers_obj.Description = Description;
                composers_obj.ListOrder = (ListOrder == null ? 1 : ListOrder);
                composers_obj.IPLog = IP;    
                composers_obj.CreatedOnDate = System.DateTime.Now;
                composers_obj.CreatedByUserId = new Guid(UserId);            
                composers_obj.Status = Status;
                dbContext.AddToMedia_Composers(composers_obj);
                int i  = dbContext.SaveChanges();
                return i;
            }
        }
コード例 #15
0
 public int UpdateSortKey(string UserId, int PlayListId, int SortOrder)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_PlayLists playLists_obj = dbContext.Media_PlayLists.Single(x => x.PlayListId == PlayListId);
         playLists_obj.IPModifiedLog = IP;
         playLists_obj.LastModifiedOnDate = System.DateTime.Now;
         playLists_obj.LastModifiedByUserId = new Guid(UserId);
         playLists_obj.SortOrder = SortOrder;
         int i = dbContext.SaveChanges();
         return i;
     }
 }
コード例 #16
0
 public int Update(int PlayListId,int TypeId, string UserId, string PlayListName, string FrontImage, string MainImage, string Description, string Status)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         string Alias = StringUtils.GenerateFriendlyString(PlayListName);
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_PlayLists entity = dbContext.Media_PlayLists.Single(x => x.PlayListId == PlayListId);
         entity.TypeId = TypeId;
         entity.PlayListName = PlayListName;
         entity.Alias = Alias;
         entity.FrontImage = FrontImage;
         entity.MainImage = MainImage;
         entity.Description = Description;
         entity.IPModifiedLog = IP;
         entity.LastModifiedOnDate = System.DateTime.Now;
         entity.LastModifiedByUserId = new Guid(UserId);
         entity.Status = Status;
         int i = dbContext.SaveChanges();
         return i;
     }        
 }
コード例 #17
0
        //INSERT- UPDATE - DELETE 
        public int Insert(string UserId, int TypeId, string PlayListName, string FrontImage, string MainImage, string Description, string Status)
        {
            using (MediaEntities dbContext = new MediaEntities())
            {
                string Alias = StringUtils.GenerateFriendlyString(PlayListName);
                dbContext.CommandTimeout = Settings.CommandTimeout;
                System.Nullable<Int32> SortOrder = (from u in dbContext.Media_PlayLists select u.SortOrder).DefaultIfEmpty(0).Max() + 1;

                Media_PlayLists entity = new Media_PlayLists();
                entity.TypeId = TypeId;
                entity.PlayListName = PlayListName;
                entity.Alias = Alias;
                entity.FrontImage = FrontImage;
                entity.MainImage = MainImage;
                entity.Description = Description;
                entity.SortOrder = (SortOrder == null ? 1 : SortOrder);
                entity.IPLog = IP;
                entity.CreatedOnDate = System.DateTime.Now;
                entity.CreatedByUserId = new Guid(UserId);
                entity.Status = Status;
                dbContext.AddToMedia_PlayLists(entity);
                int i  = dbContext.SaveChanges();
                return i;
            }
        }
コード例 #18
0
 public int UpdateSortKey(string UserId, int ArtistId, int ListOrder)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Artists artists_obj = dbContext.Media_Artists.Single(x => x.ArtistId == ArtistId);
         artists_obj.IPLastUpdate = IP;
         artists_obj.LastModifiedByUserId = new Guid(UserId);
         artists_obj.LastModifiedDate = System.DateTime.Now;
         artists_obj.ListOrder = ListOrder;
         int i = dbContext.SaveChanges();
         return i;
     }
 }
コード例 #19
0
 public int UpdateStatus(string UserId, int TopicId, string Status)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Topics topic_obj = dbContext.Media_Topics.Single(x => x.TopicId == TopicId);
         topic_obj.TopicId = TopicId;
         topic_obj.Status = Status;
         topic_obj.LastModifiedByUserId = new Guid(UserId);
         topic_obj.LastModifiedDate = System.DateTime.Now;
         int i = dbContext.SaveChanges();
         return i;
     }
 }
コード例 #20
0
        public int Delete(string UserId, int Idx, string Dir_Path)
        {
            using (MediaEntities dbContext = new MediaEntities())
            {
                dbContext.CommandTimeout = Settings.CommandTimeout;
                string filename = (from x in dbContext.Media_Topics where x.TopicId == Idx select x.Photo).SingleOrDefault();
                if (filename != null && filename != string.Empty)
                    module_obj.deleteFile(filename, Dir_Path);

                //Media_Topics topic_obj = (from x in dbContext.Media_Topics where x.TopicId == Idx select x).First();
                Media_Topics topic_obj = dbContext.Media_Topics.Single(x => x.TopicId == Idx);
                dbContext.DeleteObject(topic_obj);
                int i = dbContext.SaveChanges();
                return i;
            }
        } 
コード例 #21
0
 public int Update(string UserId, int TypeId, int TopicId, int ParentId, string Name, string Photo, string Description, string Status)
 {
     string Alias = module_obj.createTags(Name);
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Topics topic_obj = dbContext.Media_Topics.Single(x => x.TopicId == TopicId);
         topic_obj.TypeId = TypeId;
         topic_obj.TopicId = TopicId;
         topic_obj.Name = Name;
         topic_obj.Alias = Alias;
         topic_obj.ParentId = ParentId;
         topic_obj.Photo = Photo;
         topic_obj.Description = Description;
         topic_obj.IPLog = IP;
         topic_obj.CreatedByUserId = new Guid(UserId);
         topic_obj.CreatedOnDate = System.DateTime.Now;
         topic_obj.Status = Status;              
         int i = dbContext.SaveChanges();
         return i;
     }
 }
コード例 #22
0
 public int Delte(int TypeId)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         //Media_Types type_obj = (from x in dbContext.Media_Types where x.TypeId == TypeId select x).First();
         Media_Types type_obj = dbContext.Media_Types.Single(x => x.TypeId == TypeId);
         dbContext.DeleteObject(type_obj);
         int i = dbContext.SaveChanges();
         return i;
     }
 }
コード例 #23
0
        public int UpdateSortKey(string UserId, int TypeId, int ListOrder)
        {
            using (MediaEntities dbContext = new MediaEntities())
            {
                dbContext.CommandTimeout = Settings.CommandTimeout;

                Media_Types type_obj = dbContext.Media_Types.Single(x => x.TypeId == TypeId);
                type_obj.TypeId = TypeId;
                type_obj.ListOrder = ListOrder;
                type_obj.LastModifiedByUserId = new Guid(UserId);
                type_obj.ModifiedDate = System.DateTime.Now;
                int i = dbContext.SaveChanges();
                return i;
            }
        }
コード例 #24
0
 public int Update(int ComposerId, string UserId, string ComposerName, string FrontImage, string MainImage, string Description, string Status)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         string Alias = StringUtils.GenerateFriendlyString(ComposerName);
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Composers composers_obj = dbContext.Media_Composers.Single(x => x.ComposerId == ComposerId);
         composers_obj.ComposerName = ComposerName;
         composers_obj.Alias = Alias;
         composers_obj.FrontImage = FrontImage;
         composers_obj.MainImage = MainImage;
         composers_obj.Description = Description;
         composers_obj.IPModifiedLog = IP;
         composers_obj.LastModifiedOnDate = System.DateTime.Now;
         composers_obj.LastModifiedByUserId = new Guid(UserId);
         composers_obj.Status = Status;
         int i = dbContext.SaveChanges();
         return i;
     }        
 }
コード例 #25
0
 public int UpdateSortKey(string UserId, int ComposerId, int ListOrder)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Composers composers_obj = dbContext.Media_Composers.Single(x => x.ComposerId == ComposerId);
         composers_obj.IPModifiedLog = IP;
         composers_obj.LastModifiedByUserId = new Guid(UserId);
         composers_obj.LastModifiedOnDate = System.DateTime.Now;
         composers_obj.ListOrder = ListOrder;
         int i = dbContext.SaveChanges();
         return i;
     }
 }
コード例 #26
0
 public int Update(int TypeId, string UserId, string TypeName, string TypeExt, string TypePath, string Description, string Status)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         //Media_Types type_obj = (from x in dbContext.Media_Types where x.TypeId == TypeId select x).First();
         Media_Types type_obj = dbContext.Media_Types.Single(x => x.TypeId == TypeId);
         type_obj.TypeName = TypeName;
         type_obj.TypeExt = TypeExt;
         type_obj.TypePath = TypePath;
         type_obj.Description = Description;
         type_obj.IPModifiedLog = IP;
         type_obj.ModifiedDate = System.DateTime.Now;
         type_obj.LastModifiedByUserId = new Guid(UserId);
         type_obj.Status = Status;
         int i = dbContext.SaveChanges();
         return i;
     }
 }
コード例 #27
0
 public Media_PlayLists GetDetails(int idx)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_PlayLists playLists_obj = dbContext.Media_PlayLists.Where(x => x.PlayListId == idx).FirstOrDefault();
         return playLists_obj;
     }   
 }
コード例 #28
0
 public int Update(int ArtistId, string UserId, string ArtistName, string FrontImage, string MainImage, string Description, string Status)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         string Alias = StringUtils.GenerateFriendlyString(ArtistName);
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Artists artists_obj = dbContext.Media_Artists.Single(x => x.ArtistId == ArtistId);
         artists_obj.ArtistName = ArtistName;
         artists_obj.Alias = Alias;
         artists_obj.FrontImage = FrontImage;
         artists_obj.MainImage = MainImage;
         artists_obj.Description = Description;
         artists_obj.IPLastUpdate = IP;
         artists_obj.LastModifiedDate = System.DateTime.Now;
         artists_obj.LastModifiedByUserId = new Guid(UserId);
         artists_obj.Status = Status;
         int i = dbContext.SaveChanges();
         return i;
     }        
 }
コード例 #29
0
 public Media_Composers GetDetails(int idx)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Composers composers_obj = dbContext.Media_Composers.Where(x => x.ComposerId == idx).FirstOrDefault();
         return composers_obj;
     }   
 }
コード例 #30
0
 public int UpdateSortKey(string UserId, int AlbumId, int SortKey)
 {
     using (MediaEntities dbContext = new MediaEntities())
     {
         dbContext.CommandTimeout = Settings.CommandTimeout;
         Media_Albums album_obj = dbContext.Media_Albums.Single(x => x.AlbumId == AlbumId);
         album_obj.IPLastUpdate = IP;
         album_obj.LastModifiedByUserId = new Guid(UserId);
         album_obj.LastModifiedOnDate = System.DateTime.Now;
         album_obj.SortKey = SortKey;
         int i = dbContext.SaveChanges();
         return i;
     }
 }