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