protected void Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Data.Videos obj = new Data.Videos();
obj.Id = Id;
obj.Name = txtName.Text;
obj.Link = txtLink.Text;
obj.Language = ddlLanguage.SelectedValue;
obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1";
obj.Active = chkActive.Checked ? "1" : "0";
if (Insert == true)
{
VideosService.Videos_Insert(obj);
}
else
{
VideosService.Videos_Update(obj);
}
BindGrid();
pnView.Visible = true;
pnUpdate.Visible = false;
Insert = false;
}
}
public ActionResult UpdateFeatured([FromQuery] string Ids, Boolean Featured)
{
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
Videos item = new Videos()
{
Id = Int32.Parse(MyModels.Decode(Ids, API.Models.Settings.SecretId + ControllerName).ToString()), Featured = Featured
};
try
{
if (item.Id > 0)
{
item.CreatedBy = int.Parse(HttpContext.Request.Headers["Id"]);
item.ModifiedBy = int.Parse(HttpContext.Request.Headers["Id"]);
dynamic UpdateFeatured = VideosService.UpdateFeatured(item);
TempData["MessageSuccess"] = "Cập nhật Nổi Bật thành công";
return(Json(new MsgSuccess()));
}
else
{
TempData["MessageError"] = "Cập nhật Nổi Bật Không thành công";
return(Json(new MsgError()));
}
}
catch
{
TempData["MessageError"] = "Cập nhật Nổi Bật không thành công";
return(Json(new MsgError()));
}
}
public ActionResult DeleteItem(string Id)
{
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
Videos model = new Videos()
{
Id = Int32.Parse(MyModels.Decode(Id, API.Models.Settings.SecretId + ControllerName).ToString())
};
try
{
if (model.Id > 0)
{
model.CreatedBy = int.Parse(HttpContext.Request.Headers["Id"]);
model.ModifiedBy = int.Parse(HttpContext.Request.Headers["Id"]);
VideosService.DeleteItem(model);
TempData["MessageSuccess"] = "Xóa thành công";
return(Json(new MsgSuccess()));
}
else
{
TempData["MessageError"] = "Xóa Không thành công";
return(Json(new MsgError()));
}
}
catch {
TempData["MessageSuccess"] = "Xóa không thành công";
return(Json(new MsgError()));
}
}
public ActionResult SaveItem(Videos model)
{
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
int IdDC = Int32.Parse(MyModels.Decode(model.Ids, API.Models.Settings.SecretId + ControllerName).ToString());
VideosModel data = new VideosModel()
{
Item = model
};
data.ListItemsType = VideosService.GetListSelectItemsType();
if (ModelState.IsValid)
{
if (model.Id == IdDC)
{
model.CreatedBy = int.Parse(HttpContext.Request.Headers["Id"]);
model.ModifiedBy = int.Parse(HttpContext.Request.Headers["Id"]);
VideosService.SaveItem(model);
if (model.Id > 0)
{
TempData["MessageSuccess"] = "Cập nhật thành công";
}
else
{
TempData["MessageSuccess"] = "Thêm mới thành công";
}
return(RedirectToAction("Index"));
}
}
return(View(data));
}
public async Task GetVideos()
{
var videosService = new VideosService(BaseUri, HttpClient);
var videos = await videosService.GetVideosAsync();
Assert.IsTrue(videos.Any());
}
public async Task DetailTest()
{
var fake = Mock.Of <IVideosRepo>();
var videoService = new VideosService(fake);
var id = "2";
await videoService.DetailsVideos(id);
}
protected void grdVideos_ItemCommand(object source, DataGridCommandEventArgs e)
{
string strCA = e.CommandArgument.ToString();
switch (e.CommandName)
{
case "Edit":
Insert = false;
Id = strCA;
dt = VideosService.Videos_GetByTop("1", "Id=" + Id, "");
txtName.Text = dt.Rows[0]["Name"].ToString();
txtLink.Text = dt.Rows[0]["Link"].ToString();
PageHelper.LoadDropDownListLanguage(ddlLanguage);
ddlLanguage.SelectedValue = dt.Rows[0]["Language"].ToString();
txtOrd.Text = dt.Rows[0]["Ord"].ToString();
chkActive.Checked = dt.Rows[0]["Active"].ToString() == "1" || dt.Rows[0]["Active"].ToString() == "True";
pnView.Visible = false;
pnUpdate.Visible = true;
break;
case "Active":
string strA = "";
string str = e.Item.Cells[2].Text;
strA = str == "1" ? "0" : "1";
SqlDataProvider sql = new SqlDataProvider();
sql.ExecuteNonQuery("Update [Videos] set Active=" + strA + " Where Id='" + strCA + "'");
BindGrid();
break;
case "Delete":
VideosService.Videos_Delete(strCA);
BindGrid();
break;
}
}
//private List<Videos> videos = new List<Videos>(200);
public HomeController(ILogger <HomeController> logger, UserManager <IdentityUser> userManager,
ProfileService profileService, VideosService videosService)
{
_logger = logger;
this.userManager = userManager;
this.profileService = profileService;
this.videosService = videosService;
}
public async Task RemoveTest()
{
var fake = Mock.Of <IVideosRepo>();
var videoService = new VideosService(fake);
var video = new Video()
{
Desc = "desc2", Url_Video = "url2", TherapyId = "3"
};
await videoService.Delete(video);
}
public async Task AddTest()
{
var fake = Mock.Of <IVideosRepo>();
var videoService = new VideosService(fake);
var video = new Video()
{
Desc = "desc", Url_Video = "url", TherapyId = "1"
};
await videoService.AddAndSave(video);
}
public async Task UpdateTest()
{
var fake = Mock.Of <IVideosRepo>();
var videoService = new VideosService(fake);
var video = new Video()
{
Desc = "desc1", Url_Video = "url1", TherapyId = "2"
};
await videoService.Update(video);
}
public async Task GetVideosWithPagination()
{
var videosService = new VideosService(BaseUri, HttpClient);
var firstPageOfVideos = await videosService.GetVideosAsync(1, 2);
var secondPageOfVideos = await videosService.GetVideosAsync(2, 2);
Assert.IsTrue(firstPageOfVideos.Any());
Assert.IsTrue(secondPageOfVideos.Any());
Assert.AreNotEqual(firstPageOfVideos.First().VideoId, secondPageOfVideos.First().VideoId);
}
private void BindGrid()
{
grdVideos.DataSource = VideosService.Videos_GetByTop("", "", "Ord");
grdVideos.DataBind();
if (grdVideos.PageCount <= 1)
{
grdVideos.PagerStyle.Visible = false;
}
else
{
grdVideos.PagerStyle.Visible = true;
}
}
public MergeVersionsManager(ILibraryManager libraryManager, ICollectionManager collectionManager, ILogger <VideosService> logger, IServerConfigurationManager serverConfigurationManager,
IHttpResultFactory httpResultFactory,
IUserManager userManager,
IDtoService dtoService,
IAuthorizationContext authContext,
IFileSystem fileSystem)
{
_session = new SessionInfo(_sessionManager, logger);
_libraryManager = libraryManager;
_userManager = userManager;
_logger = logger;
_timer = new Timer(_ => OnTimerElapsed(), null, Timeout.Infinite, Timeout.Infinite);
_videoService = new VideosService(_logger, serverConfigurationManager, httpResultFactory, libraryManager, userManager, dtoService, authContext);
_fileSystem = fileSystem;
}
public async Task VideoGetByIdCorrectly()
{
var videoList = new List <Video>();
var videoRepo = new Mock <IDeletableEntityRepository <Video> >();
videoRepo.Setup(x => x.All()).Returns(videoList.AsQueryable());
videoRepo.Setup(x => x.AddAsync(It.IsAny <Video>()))
.Callback((Video x) => videoList.Add(x));
await videoRepo.Object.AddAsync(this.test);
var videoService = new VideosService(videoRepo.Object);
var videoResult = videoService.GetById(this.test.Id);
Assert.Equal(test, videoResult);
}
public async Task CreateArticleShouldBeSuccessfull()
{
var options = new DbContextOptionsBuilder <SportsNewsContext>()
.UseInMemoryDatabase(databaseName: "VideosTests")
.Options;
var dbContext = new SportsNewsContext(options);
var repository = new DbRepository <Video>(dbContext);
var videosService = new VideosService(repository);
await videosService.Create(1, "test");
var count = repository.All().Count();
Assert.Equal(1, count);
}
public async Task CreateNewVideoShouldAddCorrectly()
{
var videoList = new List <Video>();
var videoRepo = new Mock <IDeletableEntityRepository <Video> >();
videoRepo.Setup(x => x.All()).Returns(videoList.AsQueryable());
videoRepo.Setup(x => x.AddAsync(It.IsAny <Video>()))
.Callback((Video r) => videoList.Add(r));
var videoService = new VideosService(videoRepo.Object);
await videoService.CreateAsync(test.Title, test.Description, test.VideoUrl, test.Category);
await videoService.CreateAsync(test2.Title, test2.Description, test2.VideoUrl, test2.Category);
Assert.Equal(videoList[0].Title, this.test.Title);
Assert.Equal(videoList[1].Title, this.test2.Title);
Assert.NotEqual(videoList[1].Title, this.test.Title);
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
DataGridItem item = default(DataGridItem);
for (int i = 0; i < grdVideos.Items.Count; i++)
{
item = grdVideos.Items[i];
if (item.ItemType == ListItemType.AlternatingItem | item.ItemType == ListItemType.Item)
{
if (((CheckBox)item.FindControl("ChkSelect")).Checked)
{
string strId = item.Cells[1].Text;
VideosService.Videos_Delete(strId);
}
}
}
grdVideos.CurrentPageIndex = 0;
BindGrid();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Request.Cookies["CurrentLanguage"] != null)
{
Lang = Request.Cookies["CurrentLanguage"].Value;
}
DataTable dtVanBan = NewsService.News_GetByTop("", "Active=1 AND GroupNewsId IN (Select Id from GroupNews where Active=1 AND [Index]=1 AND Language='" + Lang + "') AND Language='" + Lang + "'", "Date DESC");
if (dtVanBan.Rows.Count > 0)
{
rptVanBan.DataSource = PageHelper.ModifyData(dtVanBan, Consts.CON_VAN_BAN);
rptVanBan.DataBind();
rptVanBan01.DataSource = dtVanBan;
rptVanBan01.DataBind();
}
dtVanBan.Clear();
dtVanBan.Dispose();
DataTable dtVideo = VideosService.Videos_GetByTop("10", "Active=1 AND Language='" + Lang + "'", "Ord");
if (dtVideo.Rows.Count > 0)
{
vId = dtVideo.Rows[0]["Link"].ToString();
VideoName = dtVideo.Rows[0]["Name"].ToString();
rptVideo.DataSource = dtVideo;
rptVideo.DataBind();
}
DataTable dtNews = NewsService.News_GetByTop("10", "Active=1 AND GroupNewsId IN (Select Id from GroupNews where Active=1 AND [Index]=0) AND Language='" + Lang + "'", "Views DESC");
rptReadMost.DataSource = PageHelper.ModifyData(dtNews, Consts.CON_TIN_TUC);
rptReadMost.DataBind();
DataTable dtLink = LinkWebService.LinkWeb_GetByTop("", "Active=1 AND Lang='" + Lang + "'", "Ord");
rptLinkWeb.DataSource = dtLink;
rptLinkWeb.DataBind();
}
}
catch (Exception ex)
{
MailSender.SendMail("", "", "Error System", ex.Message);
}
}
public VideosServiceTests()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString());
this.videoRepository = new EfDeletableEntityRepository <Video>(new ApplicationDbContext(options.Options));
this.service = new VideosService(this.videoRepository);
this.video = new Video
{
Id = "id",
CategoryId = 1,
ChannelId = "channelId",
UserId = "userId",
Description = "Description",
Url = "mDC8ZSKTWKc&t=1s",
Title = "Title",
};
}
public IActionResult Index([FromQuery] SearchVideos dto)
{
int TotalItems = 0;
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
VideosModel data = new VideosModel()
{
SearchData = dto
};
data.ListItems = VideosService.GetListPagination(data.SearchData, API.Models.Settings.SecretId + ControllerName);
if (data.ListItems != null && data.ListItems.Count() > 0)
{
TotalItems = data.ListItems[0].TotalRows;
}
data.Pagination = new API.Areas.Admin.Models.Partial.PartialPagination()
{
CurrentPage = data.SearchData.CurrentPage, ItemsPerPage = data.SearchData.ItemsPerPage, TotalItems = TotalItems, QueryString = Request.QueryString.ToString()
};
return(View(data));
}
public async Task DeleteVideoCorrectly()
{
var videoList = new List <Video>();
var videoRepo = new Mock <IDeletableEntityRepository <Video> >();
videoRepo.Setup(x => x.All()).Returns(videoList.AsQueryable());
videoRepo.Setup(x => x.AddAsync(It.IsAny <Video>()))
.Callback((Video c) => videoList.Add(c));
videoRepo.Setup(x => x.Delete(It.IsAny <Video>()))
.Callback((Video c) => videoList.Remove(c));
await videoRepo.Object.AddAsync(this.test);
var videoService = new VideosService(videoRepo.Object);
await videoService.Delete(this.test.Id);
Assert.False(this.test.IsDeleted);
}
public async Task DeleteShouldBeSuccessfull()
{
var options = new DbContextOptionsBuilder <SportsNewsContext>()
.UseInMemoryDatabase(databaseName: "VideosTests2")
.Options;
var dbContext = new SportsNewsContext(options);
var repository = new DbRepository <Video>(dbContext);
var videosService = new VideosService(repository);
await videosService.Create(1, "dasasd");
await videosService.Create(1, "dasasd");
var id = repository.All().FirstOrDefault().Id;
await videosService.Delete(id);
var count = repository.All().Count();
Assert.Equal(1, count);
}
public async Task GetAllReturnsAllVideosCorrectly()
{
var videoList = new List <Video>();
var videoRepo = new Mock <IDeletableEntityRepository <Video> >();
videoRepo.Setup(x => x.All()).Returns(videoList.AsQueryable());
videoRepo.Setup(x => x.AddAsync(It.IsAny <Video>()))
.Callback((Video r) => videoList.Add(r));
var videoService = new VideosService(videoRepo.Object);
await videoService.CreateAsync(test.Title, test.Description, test.VideoUrl, test.Category);
await videoService.CreateAsync(test2.Title, test2.Description, test2.VideoUrl, test2.Category);
var resultList = videoService.GetAll().ToList().OrderBy(x => x.CreatedOn).ToList();
Assert.Equal(videoList[0].Title, resultList[0].Title);
Assert.Equal(videoList[0].Id, resultList[0].Id);
Assert.Equal(videoList[1].Title, resultList[1].Title);
Assert.Equal(videoList[1].Id, resultList[1].Id);
}
public async Task GetEmbededLinkWorkFine()
{
var videoList = new List <Video>();
var videoRepo = new Mock <IDeletableEntityRepository <Video> >();
videoRepo.Setup(x => x.All()).Returns(videoList.AsQueryable());
videoRepo.Setup(x => x.AddAsync(It.IsAny <Video>()))
.Callback((Video r) => videoList.Add(r));
var videoService = new VideosService(videoRepo.Object);
await videoService.CreateAsync(test.Title, test.Description, test.VideoUrl, test.Category);
await videoService.CreateAsync(test2.Title, test2.Description, test2.VideoUrl, test2.Category);
var embededLink = videoService.GetEmbededVideoLink(test.VideoUrl);
var embededLink2 = videoService.GetEmbededVideoLink(test2.VideoUrl);
Assert.Equal("w2ze3Z6BAmg", embededLink);
Assert.Equal("03ILbXdE8b4", embededLink2);
}
public async Task GetLatestVideosGetsNoMoreThanFiveUniqueVideos()
{
var store = new Mock <IUserStore <ApplicationUser> >();
var userManager = new UserManager <ApplicationUser>(store.Object, null, null, null, null, null, null, null, null);
var videoList = new List <Video>();
var videoRepo = new Mock <IDeletableEntityRepository <Video> >();
videoRepo.Setup(x => x.All()).Returns(videoList.AsQueryable());
videoRepo.Setup(x => x.AddAsync(It.IsAny <Video>()))
.Callback((Video r) => videoList.Add(r));
var videoService = new VideosService(videoRepo.Object);
await videoService.CreateAsync(test.Title, test.Description, test.VideoUrl, test.Category);
await videoService.CreateAsync(test2.Title, test2.Description, test2.VideoUrl, test2.Category);
var listResult = videoService.GetLatestVideos();
Assert.Equal(videoList.OrderByDescending(x => x.CreatedOn), listResult);
}
public IActionResult SaveItem(string Id = null)
{
VideosModel data = new VideosModel();
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
int IdDC = Int32.Parse(MyModels.Decode(Id, API.Models.Settings.SecretId + ControllerName).ToString());
data.SearchData = new SearchVideos()
{
CurrentPage = 0, ItemsPerPage = 10, Keyword = ""
};
data.ListItemsType = VideosService.GetListSelectItemsType();
if (IdDC == 0)
{
data.Item = new Videos();
}
else
{
data.Item = VideosService.GetItem(IdDC, API.Models.Settings.SecretId + ControllerName);
}
return(View(data));
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Request.Cookies["CurrentLanguage"] != null)
{
Lang = Request.Cookies["CurrentLanguage"].Value;
}
DataTable dtVideo = VideosService.Videos_GetByTop("", "Active = 1 AND Language = '" + Lang + "'", "Ord");
for (int i = 0; i < dtVideo.Rows.Count; i++)
{
rptVideos.DataSource = dtVideo;
rptVideos.DataBind();
}
}
}
catch (Exception ex)
{
MailSender.SendMail("", "", "Error System", ex.Message);
}
}
public async Task GetVideosTest()
{
var videos = new List <Video>
{
new Video()
{
Desc = "desc3", Url_Video = "url3", TherapyId = "4"
},
new Video()
{
Desc = "desc4", Url_Video = "url4", TherapyId = "5"
},
};
var fakeRepositoryMock = new Mock <IVideosRepo>();
fakeRepositoryMock.Setup(x => x.GetAll()).ReturnsAsync(videos);
var videoService = new VideosService(fakeRepositoryMock.Object);
var resultVideos = await videoService.GetVideo();
Assert.Collection(resultVideos, video =>
{
Assert.Equal("desc3", video.Desc);
Assert.Equal("url3", video.Url_Video);
Assert.Equal("4", video.TherapyId);
},
video =>
{
Assert.Equal("desc4", video.Desc);
Assert.Equal("url4", video.Url_Video);
Assert.Equal("5", video.TherapyId);
});
}
public void UpdateVimeoJsonFile()
{
var vimeoVideoService = new VideosService();
vimeoVideoService.UpdateVimeoVideos("umbraco");
}
