public async Task <JsonResult> Addeye(int id)
{
string result = "error";
try
{
string UserName = GetUserName();
Training_VideoL videols = await db.Training_VideoL.FindAsync(id);
Training_VideoLEM videoLEM = await db.Training_VideoLEM.FirstOrDefaultAsync(e => e.VideoXId == videols.XId);
UserInfo userinfo = await db.UserInfoes.FirstOrDefaultAsync(e => e.UserName == UserName);
Training_EyeV eye = userinfo.Training_EyeV.Where(e => e.VideoXId == videols.XId).FirstOrDefault();
if (eye == null)
{
videoLEM.Eye += 1;
Training_EyeV eyenew = new Training_EyeV();
eyenew.UserId = userinfo.Id;
eyenew.VideoXId = videols.XId;
db.Training_EyeV.Add(eyenew);
await db.SaveChangesAsync();
}
result = "success";
}
catch { }
return(Json(result));
}
public async Task <JsonResult> like(int id, int tf)
{
try
{
string UserName = GetUserName();
Training_VideoL videols = await db.Training_VideoL.FindAsync(id);
Training_VideoLEM videoLEM = await db.Training_VideoLEM.FirstOrDefaultAsync(e => e.VideoXId == videols.XId);
UserInfo userinfo = await db.UserInfoes.FirstOrDefaultAsync(e => e.UserName == UserName);
if (tf == 1)
{
videoLEM.Likes += 1;
Training_LikeV lkv = new Training_LikeV();
lkv.UserId = userinfo.Id;
lkv.VideoXId = videols.XId;
db.Training_LikeV.Add(lkv);
}
else
{
videoLEM.Likes -= 1;
Training_LikeV lkv = userinfo.Training_LikeV.Where(e => e.VideoXId == videols.XId).FirstOrDefault();
db.Training_LikeV.Remove(lkv);
}
await db.SaveChangesAsync();
}
catch { }
return(Json(""));
}
public ActionResult removevlessons(int Id)
{
string Msg = "error";
Training_VideoL videols = db.Training_VideoL.Find(Id);
try
{
if (videols != null)
{
if (videols.language == "ru")
{
Training_VideoXL VideoXl = db.Training_VideoXL.Find(videols.XId);
if (VideoXl.Training_VideoL.Where(e => e.language != "ru").Count() == 0)
{
db.Training_VideoL.Remove(videols);
Training_VideoLEM VideoLEMObj = db.Training_VideoLEM.Where(e => e.VideoXId == videols.XId).First();
db.Training_VideoLEM.Remove(VideoLEMObj);
Training_VideoXL VideoXLObj = db.Training_VideoXL.Where(e => e.XId == videols.XId).First();
db.Training_VideoXL.Remove(VideoXLObj);
db.SaveChanges();
Msg = "success";
}
}
else
{
db.Training_VideoL.Remove(videols);
db.SaveChanges();
Msg = "success";
}
}
}
catch { }
return(Json(Msg));
}
//: EDITVLESSONS -------------------------------------------------------------------------
public ActionResult editvlessons(int Id, string language)
{
Training_VideoL videols = db.Training_VideoL.Find(Id);
if (videols != null)
{
if (language == null)
{
language = "ru";
}
ViewBag.language = language;
var Modules = db.Training_Property.Where(e => e.lang == "ru").OrderBy(e => e.Training.XId).ToList();
ViewBag.Modules = Modules;
return(View(videols));
}
return(RedirectToAction("VideoLessons", new { language = language }));
}
public async Task <IHttpActionResult> Post([FromBody] VideoStaticsCs data)
{
try
{
string UserName = User.Identity.Name;
Training_VideoL videols = await db.Training_VideoL.FindAsync(data.videoId);
if (videols != null)
{
Training_VideoLEM videolem = videols.Training_VideoXL.Training_VideoLEM.FirstOrDefault();
UserInfo userinfo = await db.UserInfoes.FirstOrDefaultAsync(e => e.UserName == UserName);
if (data.like == true)
{
Training_LikeV lkv = userinfo.Training_LikeV.FirstOrDefault(e => e.VideoXId == videols.XId);
if (lkv == null)
{
videolem.Likes += 1;
Training_LikeV newlkv = new Training_LikeV();
newlkv.UserId = userinfo.Id;
newlkv.VideoXId = videols.XId;
db.Training_LikeV.Add(newlkv);
}
}
else if (data.like == false)
{
videolem.Likes -= 1;
Training_LikeV lkv = userinfo.Training_LikeV.FirstOrDefault(e => e.VideoXId == videols.XId);
if (lkv != null)
{
db.Training_LikeV.Remove(lkv);
}
}
if (data.viewing == true)
{
Training_EyeV eye = userinfo.Training_EyeV.FirstOrDefault(e => e.VideoXId == videols.XId);
if (eye == null)
{
videolem.Eye += 1;
Training_EyeV eyenew = new Training_EyeV();
eyenew.UserId = userinfo.Id;
eyenew.VideoXId = videols.XId;
db.Training_EyeV.Add(eyenew);
}
}
//if (data.chosen == true)
//{
// Isbranni izb = userinfo.Isbrannis.FirstOrDefault(e => e.VideoLXId == videols.XId);
// if (izb == null)
// {
// Isbranni newizb = new Isbranni();
// newizb.UserId = userinfo.Id;
// newizb.VideoLXId = videols.XId;
// db.Isbrannis.Add(newizb);
// }
//}
//else if (data.chosen == false)
//{
// Isbranni izb = userinfo.Isbrannis.FirstOrDefault(e => e.VideoLXId == videols.XId);
// if (izb != null)
// {
// db.Isbrannis.Remove(izb);
// }
//}
await db.SaveChangesAsync();
return(Ok());
}
return(BadRequest("Такого видео-урока нет"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
// GET: VIDEOLESSON----------------------------------------------------------------
public async Task <ActionResult> Videolesson(int Id, string language)
{
try
{
string UserName = GetUserName();
if (language == null)
{
language = "ru";
}
UserInfo userinfo = await db.UserInfoes.FirstOrDefaultAsync(e => e.UserName == UserName);
UserProgress UserProgress = await UserGet.Progress(UserName, userinfo.LevelId, language);
Training_VideoL videols = await db.Training_VideoL.FindAsync(Id);
if (videols != null && videols.Training_VideoXL.Enable == true)
{
Training_LikeV lkv = userinfo.Training_LikeV.Where(e => e.VideoXId == videols.XId).FirstOrDefault();
if (lkv != null)
{
ViewBag.lkv = 1;
}
Training_VideoL vl = db.Training_VideoL.Where(e => e.XId < videols.XId && e.language == language).OrderByDescending(e => e.XId).FirstOrDefault();
Training_VideoL vn = db.Training_VideoL.Where(e => e.XId > videols.XId && e.language == language).FirstOrDefault();
int?vlId = null;
int?vnId = null;
if (vl != null)
{
vlId = vl.Id;
}
if (vn != null)
{
vnId = vn.Id;
}
ViewBag.LastVId = vlId;
ViewBag.NextVId = vnId;
ViewBag.OUK = UserProgress.OUK;
ViewBag.TBB = UserProgress.TBB;
ViewBag.language = language;
return(View(videols));
}
return(RedirectToAction("Noaccess", "Error"));
}
catch { }
string ActionName = "Videolesson";
return(RedirectToAction("ErrorLogOff", "Account", new { language = language, ActionName = ActionName }));
}
public ActionResult editvlessons(Training_VideoL videols, int minute, string language, bool?publish)
{
string Msg = "error";
Training_VideoL oldVideoL = db.Training_VideoL.Find(videols.Id);
try
{
if (language == null)
{
language = "ru";
}
if (publish == null)
{
publish = false;
}
HttpPostedFileBase file1 = Request.Files["img1"];
if (file1.FileName != "" && file1 != null)
{
string fullPath = Request.MapPath(oldVideoL.Iconimg);
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
string ImageName = file1.FileName;
oldVideoL.Iconimg = "~/Images/Training/" + language + "/" + DateTime.Now.Date.Year + DateTime.Now.Date.Month + DateTime.Now.Date.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "_" + ImageName.Replace(" ", "_");
file1.SaveAs(HttpContext.Server.MapPath(oldVideoL.Iconimg));
}
HttpPostedFileBase file2 = Request.Files["img2"];
if (file2.FileName != "" && file2 != null)
{
string fullPath = Request.MapPath(oldVideoL.Iconimg2);
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
string ImageName = file2.FileName;
oldVideoL.Iconimg2 = "~/Images/Training/" + language + "/" + DateTime.Now.Date.Year + DateTime.Now.Date.Month + DateTime.Now.Date.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "_" + ImageName.Replace(" ", "_");
file2.SaveAs(HttpContext.Server.MapPath(oldVideoL.Iconimg2));
}
oldVideoL.Link = videols.Link;
oldVideoL.Name = videols.Name;
oldVideoL.Training_VideoXL.Enable = (bool)publish;
Training_VideoLEM videolem = oldVideoL.Training_VideoXL.Training_VideoLEM.FirstOrDefault();
videolem.minute = minute;
db.SaveChanges();
Msg = "success";
}
catch { }
var Training = db.Training_Property.Where(e => e.lang == "ru").ToList();
ViewBag.Modules = Training;
ViewBag.Message = Msg;
return(View(oldVideoL));
}
public ActionResult createvlessons(Training_VideoL videols, int minute, string language, string XId, bool?publish)
{
if (language == null)
{
language = "ru";
}
ViewBag.language = language;
if (publish == null)
{
publish = false;
}
string Msg = "error";
try
{
videols.XId = Convert.ToDouble(XId.Replace(",", "."));
}
catch
{
Msg = "warning02";
}
HttpPostedFileBase file1 = Request.Files["img1"];
HttpPostedFileBase file2 = Request.Files["img2"];
Training_VideoL video = db.Training_VideoL.Where(e => e.language == language && e.XId == videols.XId).FirstOrDefault();
if (video == null)
{
try
{
if (file1.FileName != "" && file1 != null)
{
string ImageName = file1.FileName;
videols.Iconimg = "~/Images/Training/" + language + "/" + DateTime.Now.Date.Year + DateTime.Now.Date.Month + DateTime.Now.Date.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "_" + ImageName.Replace(" ", "_");
file1.SaveAs(HttpContext.Server.MapPath(videols.Iconimg));
}
if (file2.FileName != "" && file2 != null)
{
string ImageName = file2.FileName;
videols.Iconimg2 = "~/Images/Training/" + language + "/" + DateTime.Now.Date.Year + DateTime.Now.Date.Month + DateTime.Now.Date.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "_" + ImageName.Replace(" ", "_");
file2.SaveAs(HttpContext.Server.MapPath(videols.Iconimg2));
}
Training_VideoXL videoXL = db.Training_VideoXL.Where(e => e.XId == videols.XId).FirstOrDefault();
if (videoXL == null)
{
Training_VideoXL newVideoXL = new Training_VideoXL();
newVideoXL.XId = videols.XId;
newVideoXL.TrId = videols.TrId;
newVideoXL.Enable = (bool)publish;
db.Training_VideoXL.Add(newVideoXL);
Training_VideoLEM newVideLem = new Training_VideoLEM();
newVideLem.Eye = 0;
newVideLem.Likes = 0;
newVideLem.minute = minute;
newVideLem.VideoXId = videols.XId;
db.Training_VideoLEM.Add(newVideLem);
}
videols.Date = DateTime.Now.AddHours(5);
db.Training_VideoL.Add(videols);
db.SaveChanges();
Msg = "success";
}
catch
{
}
}
else if (video != null)
{
Msg = "warning01";
}
if (Msg != "success")
{
if (file1.FileName != "" && file1 != null)
{
string fullPath = Request.MapPath(videols.Iconimg);
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
}
if (file2.FileName != "" && file2 != null)
{
string fullPath = Request.MapPath(videols.Iconimg2);
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
}
}
var VideoLessons = db.Training_VideoL.Where(e => e.language == "ru").ToList();
var Modules = db.Training_Property.Where(e => e.lang == "ru").ToList();
ViewBag.VideoLessons = VideoLessons;
ViewBag.AddVideoMsg = Msg;
return(View(Modules));
}
// POST: api/Default
public async Task <IHttpActionResult> Post([FromBody] Training_VideoLessonCs data)
{
ResponseUTraining_VideoL response = new ResponseUTraining_VideoL();
UTraining_VideoLesson Training_VideoLesson = new UTraining_VideoLesson();
try
{
string UserName = User.Identity.Name;
UserInfo userinfo = await db.UserInfoes.FirstOrDefaultAsync(e => e.UserName == UserName);
if (data == null)
{
return(BadRequest("data null"));
}
if (data.Id == null)
{
return(BadRequest("data id null"));
}
Training_VideoL VideoL = await db.Training_VideoL.FindAsync(data.Id);
if (VideoL == null)
{
return(BadRequest("VideoL null"));
}
if (VideoL.Training.Enable != true)
{
return(BadRequest("VideoL Training Disable"));
}
if (VideoL.Training_VideoXL.Enable != true)
{
return(BadRequest("VideoL Disable"));
}
int Like = 0;
int View = 0;
Training_VideoLEM videLem = VideoL.Training_VideoXL.Training_VideoLEM.FirstOrDefault();
if (videLem != null)
{
Like = videLem.Likes;
View = videLem.Eye;
}
bool liked = false;
bool viewed = false;
Training_EyeV eye = userinfo.Training_EyeV.FirstOrDefault(e => e.VideoXId == VideoL.XId);
if (eye != null)
{
viewed = true;
}
Training_LikeV like = userinfo.Training_LikeV.FirstOrDefault(e => e.VideoXId == VideoL.XId);
if (like != null)
{
liked = true;
}
Training_VideoXL vlXID = await db.Training_VideoXL.Where(e => e.XId < VideoL.XId).OrderByDescending(e => e.XId).FirstOrDefaultAsync();
Training_VideoXL vnXID = await db.Training_VideoXL.Where(e => e.XId > VideoL.XId).OrderBy(e => e.XId).FirstOrDefaultAsync();
Training_VideoL vl = null;
Training_VideoL vn = null;
if (vlXID != null)
{
vl = await db.Training_VideoL.FirstOrDefaultAsync(e => e.XId == vlXID.XId && e.language == VideoL.language);
if (vl != null)
{
Training_VideoLesson.previousId = vl.Id;
}
}
if (vnXID != null)
{
vn = await db.Training_VideoL.FirstOrDefaultAsync(e => e.XId == vnXID.XId && e.language == VideoL.language);
if (vn != null)
{
Training_VideoLesson.nextId = vn.Id;
}
}
Training_VideoLesson.Id = VideoL.Id;
Training_VideoLesson.lang = VideoL.language;
Training_VideoLesson.Name = VideoL.Name;
Training_VideoLesson.Link = VideoL.Link;
Training_VideoLesson.Like = Like;
Training_VideoLesson.View = View;
Training_VideoLesson.Liked = liked;
Training_VideoLesson.Viewed = viewed;
response.status = "ok";
response.Training_VideoLesson = Training_VideoLesson;
return(Json(response));
}
catch (Exception ex) {
return(BadRequest(ex.Message));
}
}
