public ActionResult ModifyVideoHandle(Video_info info)
{
if (info.AV_Number == null)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
int UserId = Convert.ToInt32(Session["UserId"].ToString());
var data = db.Video_info.Where(p => p.AV_Number == info.AV_Number && p.AuthorID == UserId).FirstOrDefault();
if (data.Title != info.Title)
{
data.Title = info.Title;
}
if (data.OccurrenceTime != info.OccurrenceTime)
{
data.OccurrenceTime = info.OccurrenceTime;
}
if (data.Address != info.Address)
{
data.Address = info.Address;
}
if (data.Synopsis != info.Synopsis)
{
data.Synopsis = info.Synopsis;
}
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
public string VideoInspectList()
{
///???
Video_info videinfo = db.Video_info.Where(p => p.ID == 6).FirstOrDefault();
var jss = new JavaScriptSerializer();
String json = jss.Serialize(videinfo).ToString();
return(json);
}
public ActionResult VideoInspect(string AV_Number)
{
Video_info videinfo = db.Video_info.Where(p => p.AV_Number == AV_Number).FirstOrDefault();
ViewBag.VideoTitle = videinfo.Title;
ViewBag.AV_Number = videinfo.AV_Number;
ViewBag.VideoUrl = ViewBag.AV_Number + ".mp4";
ViewBag.OccurrenceTime = videinfo.OccurrenceTime;
ViewBag.Synopsis = videinfo.Synopsis;
ViewBag.Address = videinfo.Address;
return(View());
}
public ActionResult VideoHandle(Video_info video)
{
try
{
Video_info videoDb = db.Video_info.Where(p => p.ID == video.ID).FirstOrDefault();
videoDb.VideoStatus = video.VideoStatus;
db.SaveChanges();
}
catch (Exception)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
return(Json(true, JsonRequestBehavior.AllowGet));;
}
public ActionResult VideoInspectHandle(Video_Inspect video)
{
if (video.AuditContents == null || video.AV_Number == null)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
try
{
Video_info videoDb = db.Video_info.Where(p => p.AV_Number == video.AV_Number).FirstOrDefault();
try
{
videoDb.VideoContent = video.AuditContents;
videoDb.AuditResultStatus = video.AuditStatus;
videoDb.AuditStatus = true;
db.SaveChanges();
}
catch (Exception ex)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
Video_Vote vote = new Video_Vote();
vote.AV_Number = video.AV_Number;
vote.Vote_F = 0;
vote.Vote_T = 0;
Video_Inspect inspect = new Video_Inspect();
inspect.AuditAdminID = Convert.ToInt32(Session["UserId"].ToString());
inspect.AuditContents = video.AuditContents;
inspect.AuditDate = DateTime.Now.ToString();
inspect.AuditStatus = video.AuditStatus;
inspect.AV_Number = video.AV_Number;
inspect.Score = video.Score;
db.Video_Inspect.Add(inspect);
db.Video_Vote.Add(vote);
db.SaveChanges();
}
catch (Exception ex)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
