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