public MediaListModel GetMediaByType(string type)
{
MediaListModel newModel = new MediaListModel();
using (var db = new MediaEntities())
{
var query = db.Media.Where(x => x.Type == type);
var mediaSearch = query.ToList();
mediaSearch.ForEach(media =>
{
newModel.MediaList.Add(
new MediaModel()
{
Id = media.Id,
Author = media.Author,
Path = media.Path,
Caption = media.Caption,
Description = media.Description
});
});
}
return(newModel);
}
//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);
}
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);
}
//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 MediaListModel GetAllMedia()
{
MediaListModel model = new MediaListModel();
using (var db = new MediaEntities())
{
var query = db.Media.Select(x => x);
var bikeList = query.ToList();
bikeList.ForEach(x =>
model.MediaList.Add(
new MediaModel()
{
Id = x.Id,
Author = x.Author,
Caption = x.Caption,
Description = x.Description,
Path = x.Path,
Type = (MediaType)Enum.Parse(typeof(MediaType), x.Type),
Category = (MediaCategory)Enum.Parse(typeof(MediaCategory), x.Category)
}
)
);
}
return(model);
}
//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 static List<Media_Albums> GetTotalItemCountActiveList(int? pageIndex, int? pageSize, int iTotalItemCount)
//{
// using (MediaEntities dbContext = new MediaEntities())
// {
// var lst = GetActiveListByFixedNum(iTotalItemCount);
// //if no page size specified, set page size to total # of rows in data table
// int _pagesize = (pageSize.HasValue) ? pageSize.Value : lst.Count;
// //paging logic <-> default to page 1 if no page supplied
// int _page = (pageIndex.HasValue) ? pageIndex.Value : 1;
// return lst.Skip((_page - 1) * _pagesize).Take(_pagesize).ToList();
// }
//}
//public static string LoadPaginationLinks(int? pageSize, int iTotalItemCount)
//{
// string pagination_link = string.Empty;
// using (MediaEntities dbContext = new MediaEntities())
// {
// var lst = GetActiveListByFixedNum(iTotalItemCount);
// int TotalItemCount = 0;
// if (iTotalItemCount > lst.Count)
// TotalItemCount = lst.Count;
// else
// TotalItemCount = iTotalItemCount;
// int PageCount = 0;
// if (TotalItemCount > 0)
// PageCount = (int)Math.Ceiling(TotalItemCount / (double)pageSize);
// for (int i = 1; i <= PageCount; i++)
// {
// pagination_link += "<a href=\"javascript:void(0);\" onclick=\"ajaxAlbum(" + i + "," + pageSize + "," + iTotalItemCount + ")\">" + i + "</a>";
// }
// }
// return pagination_link;
//}
//public static string LoadAlbumListWithPagination(int? pageIndex, int? pageSize, int iTotalItemCount)
//{
// string strHTML = string.Empty;
// List<Media_Albums> lst = MediaAlbums.GetTotalItemCountActiveList(pageIndex, pageSize, iTotalItemCount);
// if (lst.Count > 0)
// {
// string result = string.Empty;
// foreach (var x in lst)
// {
// result += "<a href=\"#\"><h4><span>" + x.AlbumName + "</span></h4></a>";
// }
// strHTML = "<div class='album_info'>" + result + "</div><br/>"
// + "<div class='album_pagination'>"
// + LoadPaginationLinks(pageSize, iTotalItemCount)
// + "</div>";
// }
// return strHTML;
//}
public Media_Albums GetDetails(int idx)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
Media_Albums albums_obj = dbContext.Media_Albums.Where(x => x.AlbumId == idx).FirstOrDefault();
return(albums_obj);
}
}
public Media_Types GetDetails(int idx)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
Media_Types type_obj = dbContext.Media_Types.Where(x => x.TypeId == idx).FirstOrDefault();
return(type_obj);
}
}
public Media_Composers GetDetails(int idx)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
Media_Composers composers_obj = dbContext.Media_Composers.Where(x => x.ComposerId == idx).FirstOrDefault();
return(composers_obj);
}
}
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 string GetTypePathByTypeId(int idx)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
string TypePath = (from x in dbContext.Media_Types where x.TypeId == idx select x.TypePath).SingleOrDefault();
return(TypePath);
}
}
public Media_Topics GetDetailById(int idx)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
Media_Topics topic_obj = dbContext.Media_Topics.Where(x => x.TopicId == idx).FirstOrDefault();
return(topic_obj);
}
}
public static List <Media_Composers> LoadAll()
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
_items = (from x in dbContext.Media_Composers select x).ToList();
return(_items);
}
}
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);
}
}
/* ------------------------------------------------------------------------------- */
private void LoadGenres()
{
using (var ctx = new MediaEntities())
{
foreach (Genre G in ctx.Genres)
{
ListItem newItem = new ListItem();
newItem.Text = G.Genre1;
newItem.Value = G.GenreID.ToString();
Genres.Items.Add(newItem);
}
}
}
public List <Media_Topics> GetListByStatus(string Status)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
IQueryable <Media_Topics> query = from x in dbContext.Media_Topics select x;
if (!string.IsNullOrEmpty(Status))
{
query = query.Where(x => x.Status == Status);
}
return(query.ToList());
}
}
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);
}
}
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);
}
}
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);
}
}
private void LoadCustomers()
{
using (var ctx = new MediaEntities())
{
// Befolka Customer Dropdown
foreach (Customer C in ctx.Customers)
{
ListItem newItem = new ListItem();
newItem.Text = C.CustomerName;
newItem.Value = C.CustomerID.ToString();
Customers.Items.Add(newItem);
}
}
}
public int UpdateStatus(string UserId, int TypeId, string Status)
{
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.Status = Status;
type_obj.LastModifiedByUserId = new Guid(UserId);
type_obj.ModifiedDate = System.DateTime.Now;
int i = dbContext.SaveChanges();
return(i);
}
}
public int UpdateSortKey(string UserId, int TopicId, int ListOrder)
{
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.ListOrder = ListOrder;
topic_obj.LastModifiedByUserId = new Guid(UserId);
topic_obj.LastModifiedDate = System.DateTime.Now;
int i = dbContext.SaveChanges();
return(i);
}
}
//================================================================================
public static List <Media_Artists> GetActiveListByFixedNum(int iTotalItemCount)
{
using (MediaEntities dbContext = new MediaEntities())
{
var query = from x in dbContext.Media_Artists where x.Status.Equals("1") orderby x.ArtistId descending select x;
int TotalItemCount = 0;
if (iTotalItemCount <= query.Count())
{
TotalItemCount = iTotalItemCount;
}
else
{
TotalItemCount = query.Count();
}
return(query.Take(TotalItemCount).ToList());
}
}
public ActionResult Create(Image im)
{
string fileName = Path.GetFileNameWithoutExtension(im.ImageFile.FileName);
string extension = Path.GetExtension(im.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
im.FilePath = "~/Images/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Images/") + fileName);
im.ImageFile.SaveAs(fileName);
using (MediaEntities db = new MediaEntities())
{
db.Images.Add(im);
db.SaveChanges();
}
ModelState.Clear();
return(RedirectToAction("Index"));
}
public static List <Media_Composers> GetListByStatus(string status)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
IQueryable <Media_Composers> query = from x in dbContext.Media_Composers select x;
if (string.IsNullOrEmpty(status))
{
_items = query.ToList();
}
else
{
_items = query.Where(x => x.Status == status).ToList();
}
return(_items);
}
}
public List <Media_Types> GetListByStatus(string status)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
IQueryable <Media_Types> query = from x in dbContext.Media_Types select x;
List <Media_Types> lst = new List <Media_Types>();
if (string.IsNullOrEmpty(status))
{
lst = query.ToList();
}
else
{
lst = query.Where(x => x.Status == status).ToList();
}
return(lst);
}
}
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 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);
}
}
public ActionResult Create(MediaFile mediafile)
{
string fileName = Path.GetFileNameWithoutExtension(mediafile.upload.FileName);
string extension = Path.GetExtension(mediafile.upload.FileName);
fileName = fileName + extension;
mediafile.FilePath = "~/Music/" + fileName;
mediafile.MediaFileType = extension;
fileName = Path.Combine(Server.MapPath("~/Music/") + fileName);
mediafile.upload.SaveAs(fileName);
using (MediaEntities db = new MediaEntities())
{
db.MediaFiles.Add(mediafile);
db.SaveChanges();
}
ModelState.Clear();
return(RedirectToAction("Index"));
}
