//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;
}
}
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;
}
}
//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 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;
}
}
//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;
}
}
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;
}
}
public int Update(int AlbumId, string UserId, int TypeId, string AlbumName, string FrontImage, string MainImage, string Description, string Status)
{
int i =0;
using (MediaEntities dbContext = new MediaEntities())
{
using (System.Transactions.TransactionScope transcope = new System.Transactions.TransactionScope())
{
//dbContext.CommandTimeout = Settings.CommandTimeout;
dbContext.Connection.Open();
string Alias = StringUtils.GenerateFriendlyString(AlbumName);
Media_Albums entity = dbContext.Media_Albums.Single(x => x.AlbumId == AlbumId);
entity.TypeId = TypeId;
entity.AlbumName = AlbumName;
entity.Alias = Alias;
entity.FrontImage = FrontImage;
entity.MainImage = MainImage;
entity.Description = Description;
entity.IPLastUpdate = IP;
entity.LastModifiedByUserId = new Guid(UserId);
entity.LastModifiedOnDate = System.DateTime.Now;
entity.Status = Status;
i = dbContext.SaveChanges();
dbContext.Connection.Close();
transcope.Complete();
}
}
return i;
}
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;
}
}
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;
}
}
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;
}
}
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;
}
}
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;
}
}
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;
}
}
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 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;
}
}
//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;
}
}
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;
}
}
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;
}
}
//INSERT- UPDATE - DELETE
public int Insert(string UserId, int TypeId, string AlbumName, string FrontImage, string MainImage, string Description, string Status)
{
int returnValue = 0;
using (MediaEntities dbContext = new MediaEntities())
{
using (System.Transactions.TransactionScope transcope = new System.Transactions.TransactionScope())
{
string Alias = StringUtils.GenerateFriendlyString(AlbumName);
dbContext.CommandTimeout = Settings.CommandTimeout;
System.Nullable<Int32> SortKey = (from u in dbContext.Media_Albums select u.SortKey).DefaultIfEmpty(0).Max() + 1;
Media_Albums entity = new Media_Albums();
entity.TypeId = TypeId;
entity.AlbumName = AlbumName;
entity.Alias = Alias;
entity.FrontImage = FrontImage;
entity.MainImage = MainImage;
entity.Description = Description;
entity.SortKey = (SortKey == null ? 1 : SortKey);
entity.IPLog = IP;
entity.CreatedByUserId = new Guid(UserId);
entity.CreatedOnDate = System.DateTime.Now;
entity.Status = Status;
dbContext.AddToMedia_Albums(entity);
returnValue = dbContext.SaveChanges();
transcope.Complete();
}
}
return returnValue;
}