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));
}
