//public string GetCompetencies_withDefHeader(int GroupID, int compHeaderID) //{ // var compList = new List<Competency>(); // var jsonSerialiser = new JavaScriptSerializer(); // using (var db = new SSITrainingEntities()) // { // var query = from x in db.Competencies // join s in db.tblCACompetency_Status on x.CompetencyStatusID equals s.CompetencyStatusID // join t in db.CompetencyTypes on x.CompetencyTypeID equals t.CompetencyTypeID // join d in db.CompetencyDefDetails on x.CompetencyID equals d.CompetencyID into leftjoin // from dd in leftjoin.Where(f => f.CompDefHeaderID == compHeaderID && f.Active == true).DefaultIfEmpty() // where x.CompetencyGroupID == GroupID && s.ObjectStatusCode == "Active" // select new // { // CompetencyID = x.CompetencyID, // CompetencyGroupID = x.CompetencyGroupID, // CompetencyStatusID = x.CompetencyStatusID, // Question = x.Question, // Answer = x.Answer, // CompetencyTypeID = x.CompetencyTypeID, // LevelID = x.LevelID, // CompetencyTypeName = t.CompetencyTypeName // , // CompDefHeaderID = (dd.CompDefHeaderID == null) ? 0 : dd.CompDefHeaderID // }; // try // { // compList = query.ToList().Select(x => new Competency // { // CompetencyID = x.CompetencyID, // CompetencyGroupID = x.CompetencyGroupID, // CompetencyStatusID = x.CompetencyStatusID, // Question = x.Question, // Answer = x.Answer, // CompetencyTypeID = x.CompetencyTypeID, // LevelID = x.LevelID, // CompetencyTypeName = x.CompetencyTypeName // , // CompDefHeaderID = x.CompDefHeaderID // }).ToList(); // } // catch (Exception ex) // { // } // } // var json = jsonSerialiser.Serialize(compList); // return json; //} //public string GetCompDefDetails(int compHeaderID) //{ // var compList = new List<Competency>(); // var jsonSerialiser = new JavaScriptSerializer(); // using (var db = new SSITrainingEntities()) // { // var query = from x in db.Competencies // join d in db.CompetencyDefDetails on x.CompetencyID equals d.CompetencyID // join s in db.tblCACompetency_Status on x.CompetencyStatusID equals s.CompetencyStatusID // join t in db.CompetencyTypes on x.CompetencyTypeID equals t.CompetencyTypeID // where d.CompDefHeaderID == compHeaderID && s.ObjectStatusCode == "Active" && d.Active == true // select new // { // CompetencyID = x.CompetencyID, // CompetencyGroupID = x.CompetencyGroupID, // CompetencyStatusID = x.CompetencyStatusID, // Question = x.Question, // Answer = x.Answer, // CompetencyTypeID = x.CompetencyTypeID, // LevelID = x.LevelID, // CompetencyTypeName = t.CompetencyTypeName // }; // compList = query.ToList().Select(x => new Competency // { // CompetencyID = x.CompetencyID, // CompetencyGroupID = x.CompetencyGroupID, // CompetencyStatusID = x.CompetencyStatusID, // Question = x.Question, // Answer = x.Answer, // CompetencyTypeID = x.CompetencyTypeID, // LevelID = x.LevelID, // CompetencyTypeName = x.CompetencyTypeName // }).ToList(); // } // var json = jsonSerialiser.Serialize(compList); // return json; //} public string GetCompHeaderDetails(int compHeaderID) { //CompetencyDefHeader CompDefHeader = new CompetencyDefHeader(); var jsonSerialiser = new JavaScriptSerializer(); using (var db = new SSITrainingEntities()) { var compDefHeader = db.sp_CACompetency_GetCompetencyHeaderDetails(compHeaderID).Single(); var json = jsonSerialiser.Serialize(compDefHeader); return(json); } }