public ActionResult Language() { List <DSRCManagementSystem.Models.Language> objler = new List <DSRCManagementSystem.Models.Language>(); try { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.CompletedTraining objcom = new DSRCManagementSystem.Models.CompletedTraining(); var email = System.Web.HttpContext.Current.Application["UserName"].ToString(); int?userid = objdb.Users.Where(x => x.UserName == email).Select(o => o.UserID).FirstOrDefault(); int?roleid = objdb.UserRoles.Where(x => x.UserID == userid).Select(o => o.RoleID).FirstOrDefault(); int?instructorid = objdb.Trainings.Where(x => x.InstructorId == userid).Select(o => o.InstructorId).FirstOrDefault(); var language = objdb.Trainings.Where(x => x.InstructorId == instructorid).Select(o => o.TrainingName).ToList(); objler = (from p in objdb.Trainings.Where(x => x.InstructorId == instructorid) select new DSRCManagementSystem.Models.Language { language = p.TrainingName }).ToList(); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(View(objler)); }
public ActionResult Form(int id) { Session["TrainingId"] = id; DSRCManagementSystem.Models.CompletedTraining objcom = new DSRCManagementSystem.Models.CompletedTraining(); try { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); int UserId = int.Parse(Session["UserID"].ToString()); objcom = (from p in objdb.Trainings.Where(o => o.TrainingId == id) select new DSRCManagementSystem.Models.CompletedTraining { TrainingId = p.TrainingId, Name = p.TrainingName, Schedule = p.ScheduledDate }).FirstOrDefault(); DateTime d1 = Convert.ToDateTime(objcom.Schedule); string d = d1.ToShortDateString(); objcom.ScheduleDate = d; var categories = (from p in objdb.Trainings join t in objdb.TrainingNominations on p.TrainingId equals t.TrainingId where p.InstructorId == UserId && p.TrainingId == id && t.IsActive == true select new { //CategoryID = t.EmpId, CategoryID = t.UserId, CategoryName = t.EmpName }).ToList(); ViewBag.Categories = new MultiSelectList(categories, "CategoryID", "CategoryName"); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(View(objcom)); }