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; } }
/// <summary> /// Deprecated Method for adding a new object to the Media_Composers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToMedia_Composers(Media_Composers media_Composers) { base.AddObject("Media_Composers", media_Composers); }
/// <summary> /// Create a new Media_Composers object. /// </summary> /// <param name="composerId">Initial value of the ComposerId property.</param> /// <param name="iPLog">Initial value of the IPLog property.</param> public static Media_Composers CreateMedia_Composers(global::System.Int32 composerId, global::System.String iPLog) { Media_Composers media_Composers = new Media_Composers(); media_Composers.ComposerId = composerId; media_Composers.IPLog = iPLog; return media_Composers; }
//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; } }