public JsonResult ShowTrainerDetails(string keyword)
{
List <TrainerSkills> list = new List <TrainerSkills>();
using (TrainerDemoEntities db = new TrainerDemoEntities())
{
list = db.Database.SqlQuery <TrainerSkills>("select trainerpersonaldetails.firstname,trainerpersonaldetails.lastname,trainerworkdetails.designation from trainermaster,trainerpersonaldetails,trainerworkdetails where trainermaster.trainerid=trainerpersonaldetails.trainerid and trainermaster.trainerid=trainerworkdetails.trainerid ").ToList();
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTrainer(string keyword)
{
List <TrainerMaster> list = new List <TrainerMaster>();
using (TrainerDemoEntities db = new TrainerDemoEntities())
{
if (string.IsNullOrEmpty(keyword))
{
list = db.TrainerMasters.ToList();
}
else
{
//list = db.TrainerMasters.Where(p => p.TrainerEmail.StartsWith(keyword)).ToList();
}
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetUser(string keyword)
{
TrainerMaster tm = new TrainerMaster();
using (TrainerDemoEntities db = new TrainerDemoEntities())
{
if (string.IsNullOrEmpty(keyword))
{
//list = db.TrainerMasters.ToList();
}
else
{
tm = db.TrainerMasters.Where(p => p.TrainerEmail.StartsWith(keyword)).FirstOrDefault();
}
}
return(Json(tm, JsonRequestBehavior.AllowGet));
}
