//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); } }
public void Delete(int key) { Media_PlayLists item = _items.Find(delegate(Media_PlayLists d) { return(d.PlayListId == key); }); if (item != null) { _items.Remove(item); } }
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); } }
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); } }
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); } }
private void LoadData() { MediaPlayLists artist_obj = new MediaPlayLists(); Media_PlayLists entity = artist_obj.GetDetails(_idx); string FrontImage = entity.FrontImage; string MainImage = entity.MainImage; imgPhoto.ImageUrl = upload_front_image_dir + "/" + FrontImage; ViewState["FrontImage"] = FrontImage; ViewState["MainImage"] = MainImage; txtPlayListName.Text = entity.PlayListName; txtDescription.Text = entity.Description; string Status = entity.Status; PopulateStatus2DDL(Status); string TypeId = ddlMediaTypeList.SelectedValue; PopulateMediaTypeList2DDL(TypeId); }
public List <Media_PlayLists> LoadDatedItemsByPage(string status, int startRow, int pageSize, string sortBy, bool sortAscending) { using (MediaEntities dbContext = new MediaEntities()) { SortData(sortBy, sortAscending); //copy to an array int count = pageSize; _items = GetListByStatus(status); if ((_items.Count - startRow) < count) { count = _items.Count - startRow; } Media_PlayLists[] pagearray = new Media_PlayLists[count]; _items.CopyTo(startRow, pagearray, 0, count); //then create a list from array List <Media_PlayLists> page = new List <Media_PlayLists>(pagearray); return(page); //_items = (from p in dbContext.Media_PlayLists select p).OrderBy(x => x.SortOrder).Skip(startRow * pageSize).Take(pageSize).ToList(); //return _items; } }