private void BindVideo()
{
var dt = UserVideo.GetUserVideoByClubID(ClubID);
if (dt != null)
{
dt.Columns.Add("GoalPlayerName", typeof(string));
dt.Columns.Add("GoalRank", typeof(int));
foreach (DataRow dr in dt.Rows)
{
var v = Video.Cache.Load((Guid)dr["VideoGuid"]);
dr["GoalPlayerName"] = v.GoalPlayerName;
dr["GoalRank"] = Convert.ToInt16(v.GoalRank);
//dr["AdditionalData"] = (int)(Convert.ToInt16(dr["GoalRank"]) * 20);
}
}
gvVideo.DataSource = dt;
gvVideo.DataBind();
ltlVideoCount.Text =
$"<span title=\"同一视频计为一个,仅计算可获得视频\">已获得(总共)视频:<em>{dt.Rows.Count}/{Video.Cache.VideoList_Legend.Count}</em></span>";
}
public static void UpdateUserVideo(UserVideo userVideo)
{
TeachersEntities db = new TeachersEntities();
db.Entry(userVideo).State = EntityState.Modified;
db.SaveChanges();
}
public IHttpActionResult PutUserVideo(long id, UserVideo userVideo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != userVideo.PKUserVideoId)
{
return(BadRequest());
}
db.Entry(userVideo).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UserVideoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static void InsertUserVideo(UserVideo userVideo)
{
TeachersEntities db = new TeachersEntities();
db.UserVideos.Add(userVideo);
db.SaveChanges();
}
private UserVideoBM ConvertToBM(UserVideo model)
{
return(new UserVideoBM()
{
Id = model.Id,
UserId = model.UserId,
VideoResumeUrl = model.VideoResumeUrl,
ArtWorkYouTube1 = model.ArtWorkYouTube1,
ArtWorkYouTube2 = model.ArtWorkYouTube2,
ArtWorkYouTube3 = model.ArtWorkYouTube3,
ArtWorkYouTube4 = model.ArtWorkYouTube4,
ArtWorkYouTube5 = model.ArtWorkYouTube5,
ArtWorkUrl1 = model.ArtWorkUrl1,
ArtWorkUrl2 = model.ArtWorkUrl2,
ArtWorkUrl3 = model.ArtWorkUrl3,
CreatedBy = model.CreatedBy,
CreationDate = model.CreationDate,
ModifiedBy = model.ModifiedBy,
ModificationDate = model.ModificationDate
});
}
public static void DeleteUserVideo(long id)
{
TeachersEntities db = new TeachersEntities();
UserVideo userVideo = db.UserVideos.Find(id);
db.UserVideos.Remove(userVideo);
db.SaveChanges();
}
public IHttpActionResult GetUserVideo(long id)
{
UserVideo userVideo = db.UserVideos.Find(id);
if (userVideo == null)
{
return(NotFound());
}
return(Ok(userVideo));
}
public IHttpActionResult PostUserVideo(UserVideo userVideo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.UserVideos.Add(userVideo);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = userVideo.PKUserVideoId }, userVideo));
}
public IHttpActionResult DeleteUserVideo(long id)
{
UserVideo userVideo = db.UserVideos.Find(id);
if (userVideo == null)
{
return(NotFound());
}
db.UserVideos.Remove(userVideo);
db.SaveChanges();
return(Ok(userVideo));
}
public ActionResult EditTeacherVideo(UserVideo userVideo)
{
ViewBag.ClassId = userVideo.FKClassId;
if (!String.IsNullOrEmpty(userVideo.VideoUrl))
{
if (userVideo.VideoUrl.Contains("watch") && userVideo.VideoUrl.Contains("youtube.com"))
{
string querystring = userVideo.VideoUrl.Split('=')[1];
userVideo.VideoUrl = "https://www.youtube.com/embed/" + querystring;
}
DbHelper.UpdateUserVideo(userVideo);
return(RedirectToAction("TeacherVideos", new { id = userVideo.FKClassId }));
}
return(View(userVideo));
}
