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)); }
public ActionResult removemodule(int Id) { string Msg = "error"; Training Training = db.Trainings.Find(Id); try { if (Training.Training_VideoL.Count > 0) { foreach (var videols in Training.Training_VideoL.ToList()) { 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.Training_Property.RemoveRange(Training.Training_Property); db.Trainings.Remove(Training); db.SaveChanges(); Msg = "success"; } catch { } return(Json(Msg)); }
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)); } }