public int UpdateTag(TagViewModel tag)
{
TagOfVideo old_tag = DAManager.TagOfVideoRepository.Get(t => t.TagId == tag.TagId).FirstOrDefault();
if (old_tag != null)
{
old_tag.MetaDescription = tag.MetaDescription;
old_tag.MetaTitle = tag.MetaTitle;
old_tag.TagId = tag.TagId;
old_tag.TagName = tag.TagName;
old_tag.FrontTitle = tag.FrontTitle;
old_tag.FrontDescription = tag.FrontDescription;
}
else
{
return(-1);
}
try
{
DAManager.Save();
return(old_tag.TagId);
}
catch (Exception ex)
{
logService.WriteError(ex.Message, ex.Message, ex.StackTrace, ex.Source);
return(-1);
}
}
public bool IsTagExist(string tag, int tag_id = 0)
{
TagOfVideo db_tag = DAManager.TagOfVideoRepository.Get(t => t.TagName == tag).FirstOrDefault();
if (db_tag == null || (tag_id != 0 && tag_id == db_tag.TagId))
{
return(false);
}
return(true);
}
public VideoCategoryViewModel GetVideosTag(string tag, int page, int page_size, int image_width, int image_height, int description_length = 40)
{
tag = tag.Replace("-", "_");
TagOfVideo db_tag = DAManager.TagOfVideoRepository.Get(t => t.TagName == tag).FirstOrDefault();
if (db_tag == null)
{
return(null);
}
VideoCategoryViewModel result_viewmodel = new VideoCategoryViewModel()
{
Name = db_tag.FrontTitle, MetaDescription = db_tag.MetaDescription, MetaTitle = db_tag.MetaTitle
};
List <ListVideoViewModel> result = new List <ListVideoViewModel>();
IQueryable <VideoTag> tag_videos = DAManager.VideoTagsRepository.Get(at => at.Tag == tag && at.Video.IsPublished == true && DbFunctions.CreateDateTime(at.Video.PublishDate.Year, at.Video.PublishDate.Month, at.Video.PublishDate.Day, at.Video.PublishDate.Hour, at.Video.PublishDate.Minute, at.Video.PublishDate.Second) <= DateTime.Now, a => a.OrderByDescending(ar => ar.Video.PublishDate), "Video.VideoImages.Image").Skip((page - 1) * page_size).Take(page_size);
foreach (VideoTag AC in tag_videos.ToList())
{
ListVideoViewModel video = new ListVideoViewModel()
{
Title = AC.Video.Title, URL = AC.Video.URL
};
video.Description = StringsUtility.StripHTML(AC.Video.Description);
if (video.Description.Length > description_length)
{
video.Description = video.Description.Substring(0, description_length);
}
if (AC.Video.VideoImages.Count() > 0)
{
video.ImageURL = ImageService.GenerateImageFullPath(AC.Video.VideoImages.First().Image.URL, image_width.ToString(), image_height.ToString());
}
result.Add(video);
}
result_viewmodel.Videos = result;
int total_videos = DAManager.VideoTagsRepository.Get(at => at.Tag == tag && at.Video.IsPublished == true && DbFunctions.CreateDateTime(at.Video.PublishDate.Year, at.Video.PublishDate.Month, at.Video.PublishDate.Day, at.Video.PublishDate.Hour, at.Video.PublishDate.Minute, at.Video.PublishDate.Second) <= DateTime.Now).Count();
//Set pagination properties
result_viewmodel.PageNumber = page;
result_viewmodel.PageSize = page_size;
result_viewmodel.TotalItems = total_videos;
return(result_viewmodel);
}
public int AddNewTag(TagViewModel tag)
{
TagOfVideo db_tag = new TagOfVideo()
{
MetaDescription = tag.MetaDescription, TagName = tag.TagName, MetaTitle = tag.MetaTitle, FrontTitle = tag.FrontTitle, FrontDescription = tag.FrontDescription
};
DAManager.TagOfVideoRepository.Insert(db_tag);
try
{
DAManager.Save();
}
catch (Exception ex)
{
logService.WriteError(ex.Message, ex.Message, ex.StackTrace, ex.Source);
return(-1);
}
return(db_tag.TagId);
}
