public IActionResult UpdateQuestionCountAll()
{
var siteId = HomeController._centerdata.SiteId;
var subjects = repoForApprove.ListInActiveSubject(siteId);
return(View(subjects));
}
public SubjectList ListSubject()
{
var siteId = HomeController._centerdata.SiteId;
//ListActivedSubject
var _activateds = repoForApprove.ListInActiveSubject(siteId);
var _occupationGroups = repoForApprove.ListOccupationGroup(siteId);
//var _allExamSuites = repoQ.GetAllQuestionSuiteBySubjectIds(_activateds.Select(allEs => allEs._id));
var subjectGroupsBack = _occupationGroups?.SelectMany(occ => occ.SubjectGroups);
var subjectGroupsFront = _occupationGroups?.SelectMany(occ => occ.SubjectGroups?.Select(sg => new SubjectGroup
{
id = sg._id,
Name = sg.Name,
OccupationId = occ._id,
}));
var subjectList = new SubjectList()
{
SubjList = _activateds?.Select(iSub =>
{
//var _examSuites = _allExamSuites.Where(allEs => allEs.SubjectId == iSub._id);
return(new SubjectDetail
{
id = iSub._id,
SubjectCode = iSub.SubjectCode,
SubjectName = iSub.SubjectName,
ContentLanguage = iSub.ContentLanguage,
//ExamSuiteCount = _examSuites?.Count() ?? 0,
//QuestionCount = _examSuites?.Sum(es => es.Questions?.Count() ?? 0) ?? 0,
ExamSuiteCount = iSub.ExamSuiteCount,
QuestionCount = iSub.QuestionCount,
ExamSuiteAcceptCount = iSub.ExamSuiteAcceptCount,
ExamSuiteRejectCount = iSub.ExamSuiteRejectCount,
Version = string.Empty,
IsDisabled = false,
SubjectGroupId = subjectGroupsBack?.FirstOrDefault(sg => sg.SubjectCodes?.Any(scode => scode == iSub.SubjectCode) ?? false)?._id,
});
}),
Occupations = _occupationGroups?.Select(occ => new Occupation
{
id = occ._id,
Name = occ.Name,
}),
SubjectGroups = subjectGroupsFront,
};
return(subjectList);
//ConvertTo SubjectList
//string conString = "User Id=c##dsd;Password=1q2w3e4r;" +
// "Data Source=localhost:1521/db;";
//DataTable dt = new DataTable();
//DataSet ds = new DataSet();
//OracleCommand cmd = new OracleCommand();
//using (OracleConnection objConn = new OracleConnection(conString))
//{
// OracleDataAdapter da = new OracleDataAdapter();
// cmd.Connection = objConn;
// cmd.InitialLONGFetchSize = 1000;
// cmd.CommandText = "spGetSubjectList";
// cmd.CommandType = CommandType.StoredProcedure;
// OracleParameter oraP = new OracleParameter();
// oraP.OracleDbType = OracleDbType.RefCursor;
// oraP.Direction = System.Data.ParameterDirection.Output;
// cmd.Parameters.Add(oraP);
// da.SelectCommand = cmd;
// da.Fill(ds);
// dt = ds.Tables[0];
// int i = 0;
// var subjectList = new SubjectList()
// {
// SubjList = _activateds?.Select(iSub =>
// {
// i++;
// var _examSuites = _allExamSuites.Where(allEs => allEs.SubjectId == iSub._id);
// return new SubjectDetail
// {
// id = iSub._id,
// SubjectCode = iSub.SubjectCode,
// SubjectName = iSub.SubjectName,
// ContentLanguage = iSub.ContentLanguage,
// //ExamSuiteCount = _examSuites?.Count() ?? 0,
// //QuestionCount = _examSuites?.Sum(es => es.Questions?.Count() ?? 0) ?? 0,
// ExamSuiteCount = iSub.ExamSuiteCount,
// QuestionCount = iSub.QuestionCount,
// ExamSuiteAcceptCount = iSub.ExamSuiteAcceptCount,
// ExamSuiteRejectCount = iSub.ExamSuiteRejectCount,
// Version = string.Empty,
// IsDisabled = false,
// SubjectGroupId = subjectGroupsBack?.FirstOrDefault(sg => sg.SubjectCodes?.Any(scode => scode == iSub.SubjectCode) ?? false)?._id,
// id = iSub._id,
// SubjectCode = dt.Rows[i]["licensetype"].ToString(),
// SubjectName = dt.Rows[i]["name"].ToString(),
// ContentLanguage = dt.Rows[i]["language"].ToString(),
// ExamSuiteCount = Int32.Parse(dt.Rows[i]["quantity"].ToString()),
// QuestionCount = Int32.Parse(dt.Rows[i]["questioncount"].ToString()),
// };
// }),
// Occupations = _occupationGroups?.Select(occ => new Occupation
// {
// id = occ._id,
// Name = occ.Name,
// }),
// SubjectGroups = subjectGroupsFront,
// };
// return subjectList;
//}
}