public DataTable GetVideosByCateHomeList(string strCate, string _lang)
{
string restr = strCate.Remove(strCate.LastIndexOf(",")).Replace(",", "','");
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.GetVideosByCateHomeList(restr, _lang));
}
public DataTable GetVideosByCateHomeAll(int n, string strCate, string approval, string _lang)
{
string restr = strCate.Remove(strCate.LastIndexOf(",")).Replace(",", "','");
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.GetVideosByCateHomeAll(n, restr, approval, _lang));
}
public void UpdateVideos(string strId, string value)
{
string restr = strId.Remove(strId.LastIndexOf(",")).Replace(",", "','");
VideosDAO videosDAO = new VideosDAO();
videosDAO.UpdateVideos(restr, value);
}
public void UpdateVideosApproval(string strId, string value, string username, DateTime date)
{
string restr = strId.Remove(strId.LastIndexOf(",")).Replace(",", "','");
VideosDAO videosDAO = new VideosDAO();
videosDAO.UpdateVideosApproval(restr, value, username, date);
}
public void DeleteVideos(string strId)
{
string restr = strId.Remove(strId.LastIndexOf(",")).Replace(",", "','");
VideosDAO videosDAO = new VideosDAO();
videosDAO.DeleteVideos(restr);
}
public ActionResult GetListVideoForChoose(int pagesize = 100)
{
IRepositryVideos <Fly_Videos> repository = new VideosDAO();
var listVideo = repository.getAllItems().ToList().Select(x => new { Title = x.VideosTitle, VideoLink = x.VideosLink, ImageLink = x.Fly_Picture.OriginalURL });
return(Json(new { result = listVideo.Take(pagesize) }));
}
public VideosController()
{
string connectionString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
string filePath = ConfigurationManager.AppSettings["logPath"];
dataAccess = new VideosDAO(connectionString, filePath);
}
/* contructor */
public VideoVM()
{
ListPositionGalleries = new List <Fly_PositionGallery>();
ListVideo = new List <Fly_Videos>();
ListSectionContents = new List <Fly_SectionContent>();
posGallery = new PositionGalleryDAO();
sectionVideo = new VideosDAO();
isPublish = true;
SectionContents = new Fly_SectionContent();
}
public ActionResult GetListEventVideo()
{
IRepositryVideos <Fly_Videos> repository = new VideosDAO();
var listItem = new List <Fly_Videos>();
try
{
listItem = repository.getAllItemsByType(PositionTab.EventClip).ToList();
}
catch (Exception ex)
{
return(Json(new { result = ex.Message, Message = ex.InnerException.Message }));
}
var rs = listItem.Select(x => new
{
id = x.VideosID,
title = x.VideosTitle,
link = x.VideosLink,
imglink = x.Fly_Picture.OriginalURL
});
return(Json(new { result = rs }, JsonRequestBehavior.AllowGet));
}
public DataTable VideosFollow(int Id, int cId, int n, string _lang)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.VideosFollow(Id, cId, n, _lang));
}
public Videos GetVideosById(int nId)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.GetVideosById(nId));
}
public void UpdateVideosApproval(int Id, string value, string username, DateTime date)
{
VideosDAO videosDAO = new VideosDAO();
videosDAO.UpdateVideosApproval(Id, value, username, date);
}
public void DeleteVideos(int nId)
{
VideosDAO videosDAO = new VideosDAO();
videosDAO.DeleteVideos(nId);
}
public DataTable GetVideosHot(int n, string approval, int cID, string _lang)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.GetVideosHot(n, approval, cID, _lang));
}
public DataTable GetVideosHot(int n, string _lang)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.GetVideosHot(n, _lang));
}
public DataTable GetVideosPagingApproved(int CateID, PagingInfo _paging, string _lang)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.GetVideosPagingApproved(CateID, _paging, _lang));
}
public void UpdateVideos(Videos videos)
{
VideosDAO videosDAO = new VideosDAO();
videosDAO.UpdateVideos(videos);
}
public void CreateVideos(Videos videos)
{
VideosDAO videosDAO = new VideosDAO();
videosDAO.CreateVideos(videos);
}
public Videos GetVideosHotTop1(string approval, string _lang)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.GetVideosHotTop1(approval, _lang));
}
public DataTable GetVideosViewHome(int n, string approval, string _lang)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.GetVideosViewHome(n, approval, _lang));
}
public int CreateVideosGet(Videos videos)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.CreateVideosGet(videos));
}
public DataTable GetVideosView(string _lang)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.GetVideosView(_lang));
}
public DataTable VideosSearch(string keyword, int cId, string _lang)
{
VideosDAO videosDAO = new VideosDAO();
return(videosDAO.VideosSearch(keyword, cId, _lang));
}
public void VideosClickUpdate(int nId)
{
VideosDAO videosDAO = new VideosDAO();
videosDAO.VideosClickUpdate(nId);
}
