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