public void ParseSubjects()
{
TextAsset[] subjects = Resources.LoadAll <TextAsset>("Subjects");
for (int i = 0; i < subjects.Length; i++)
{
JsonData data = JsonMapper.ToObject(subjects[i].text);
SubjectInfo sb = new SubjectInfo();
sb.id = (uint)data["id"];
sb.title = (string)data["title"];
sb.msg = (string)data["msg"];
sb.type = (string)data["type"];
sb.descript = (string)data["descript"];
for (int j = 0; j < data["body"].Count; j++)
{
JsonData qes = data["body"][j];
QuestionInfo qesInfo = new QuestionInfo();
qesInfo.question = (string)qes["question"];
for (int k = 0; k < qes["options"].Count; k++)
{
qesInfo.options.Add((string)qes["options"][k]);
}
for (int k = 0; k < qes["scores"].Count; k++)
{
qesInfo.scores.Add((int)qes["scores"][k]);
}
sb.questionInfos.Add(qesInfo);
}
JsonData r = data["result"];
for (int j = 0; j < r.Count; j++)
{
JsonData result = r[j];
SubjectResult sr = new SubjectResult();
sr.id = (int)result["id"];
sr.name = (string)result["name"];
for (int k = 0; k < result["level"].Count; k++)
{
SubjectLevelInfo levelInfo = new SubjectLevelInfo();
var level = result["level"][k];
levelInfo.condition = (int)level["condition"];
levelInfo.mark = (string)level["mark"];
levelInfo.comment = (string)level["comment"];
levelInfo.advice = (string)level["advice"];
sr.levelInfoLists.Add(levelInfo);
}
try {
sr.ids.Clear();
JsonData ids = result["idx"];
for (int k = 0; k < ids.Count; k++)
{
sr.ids.Add((uint)ids[k]);
}
} catch {
sr.ids = new List <uint>();
}
sb.questionResults.Add(sr);
}
subjectDict.Add(sb.id, sb);
}
}
public ActionResult UpdtSubjectsResult(int sid, int rid)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
//List<Sub_Results> sub_results = new Cateloge().SelectAllSubResults();
List <SubjectResults> allsubjectsresult = new Cateloge().SelectAllSubjectsResult(sid, rid);
AllClasses Data = new AllClasses();
Data.SubjectResult_s = new List <SubjectResult>();
if (allsubjectsresult == null)
{
ViewBag.StatusMessage = " No Any Subject Founded ! ";
}
else
{
foreach (var gdfc in allsubjectsresult)
{
SubjectResult dbr = new SubjectResult();
dbr.Id = gdfc.Id;
dbr.Obtn_marks = gdfc.Obtn_marks;
dbr.Sub_r_id = Convert.ToString(rid);
dbr.Subject_name = gdfc.Subject_name.Name;
dbr.Student_id = Convert.ToString(sid);
dbr.Status = gdfc.Status;
Data.SubjectResult_s.Add(dbr);
}
Data.SubjectResult_s.TrimExcess();
}
return(PartialView("_SubjectResultForm_", Data));
}
}
public ActionResult AddSubjectResult(int sid, int cid, int rid)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
//List<Sub_Results> sub_results = new Cateloge().SelectAllSubResults();
List <SubjectsTotalMarks> subjects = new Cateloge().SelectAllSubjectsTotalMarksWithIds(cid, rid);
AllClasses Data = new AllClasses();
Data.SubjectResult_s = new List <SubjectResult>();
if (subjects == null)
{
ViewBag.StatusMessage = " No Any Subject Founded ! ";
}
else
{
Data.SubjectsTotalMark_s = new List <SubjectTotalMark>();
foreach (var gdfc in subjects)
{
SubjectResult dbr = new SubjectResult();
dbr.Subject_id = gdfc.Subject_id;
dbr.Sub_r_id = Convert.ToString(rid);
dbr.Student_id = Convert.ToString(sid);
dbr.Subject_name = gdfc.Subject_name.Name;
Data.SubjectResult_s.Add(dbr);
}
Data.SubjectResult_s.TrimExcess();
}
return(PartialView("_SubjectResultForm", Data));
}
}
public ActionResult ViewResult(int sid, int rid)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
Sub_Results allsubjectsresulttitle = new Cateloge().SelectAllSubjectsResultTitle(rid);
List <SubjectResults> allsubjectsresult = new Cateloge().SelectAllSubjectsResult(sid, rid);
ResultsPositions SelectResultPosition = new Cateloge().SelectResultPositionByRidSid(sid, rid);
AllClasses Data = new AllClasses();
Data.SubjectResult_s = new List <SubjectResult>();
if (allsubjectsresulttitle == null && allsubjectsresult == null)
{
}
else
{
foreach (var gdfc in allsubjectsresult)
{
SubjectResult dbr = new SubjectResult();
dbr.Id = gdfc.Id;
dbr.Student_id = gdfc.Student_id;
dbr.Subject_name = gdfc.Subject_name.Name;
dbr.Total_marks = gdfc.Total_marks.Total_marks;
dbr.Obtn_marks = gdfc.Obtn_marks;
dbr.Status = gdfc.Status;
Data.SubjectResult_s.Add(dbr);
}
Data.Sub_Result = new Sub_Result
{
name = allsubjectsresulttitle.name
};
TempData["Fail"] = "Fail";
TempData["Pass"] = "******";
if (SelectResultPosition == null)
{
}
else
{
Data.Result_Position = new ResultPosition
{
Id = SelectResultPosition.Id,
Student_id = SelectResultPosition.Student_id,
Class_Section = SelectResultPosition.Class_Section,
Obtn_Pstn = SelectResultPosition.Obtn_Pstn
};
}
return(PartialView("_ViewResult", Data));
}
return(View());
}
}
public void SubmitSubject(ref Subject sSubject)
{
kService.PingLease(lease.Token);
//kSession = kService.BeginTransaction(lease.Token, TransactionExceptionHandling.Discard);
SubjectResult resultSubj = kService.SubmitSubject(kSession, sSubject);
if (resultSubj.SubmitResult.Status == SubmitStatus.ProcessedOk)
{
lblEndTime.Text = resultSubj.SubmitResult.Status.ToString();
}
//kSession = kService.CompleteTransaction(kSession);
}
public Subject CreateSubject()
{
//Creating Subject result for TPI ctegory using category's sybjectId
SubjectResult subResult = kService.CreateSubject(kSession, "1-1021");
Subject tempSubject = subResult.Subject;
List <Field> subjectFieldList = new List <Field>();
//List<ValueField> subjectFieldList = new List<ValueField>();
//Creating Value fields
////getting next project id
objBLL = new MetisBLL();
DataTable dt = new DataTable();
dt = objBLL.getNextProjectID();
string prj_id = dt.Rows[0]["ProjectID"].ToString();
subjectFieldList.Add(CreateValField("Project Name", ProjectName.Text));
subjectFieldList.Add(CreateValField("Project_ID", prj_id));
// subjectFieldList.Add(CreateValField("ContactName", ""));
////Creating Reference fields
//// get the subject id from the drop down
// subjectFieldList.Add(CreateRefField(ProjectType.SelectedValue.ToString(), "Project Type")); // Item Status (Active)
//subjectFieldList.Add(CreateRefField("", "Customer")); //Daymon Represented Flag
//subjectFieldList.Add(CreateRefField("", "PracticeDetail")); //Organic
////Creating AutoGeneratedFields
//subjectFieldList.Add(CreateAutoGeneratedValField("TradingPartnerMDMId")); //Kalido Generated ID
//Assigning fields to subject
tempSubject.Fields = subjectFieldList.ToArray();
return(tempSubject);
}
/// <summary>
///
/// </summary>
/// <param name="weixinId"></param>
/// <param name="libId"></param>
/// <param name="msgId"></param>
/// <param name="style">browse/full</param>
/// <returns></returns>
public SubjectResult GetSubject(string weixinId,
string group,
string libId,
string selSubject,
string param)
{
SubjectResult result = new SubjectResult();
string strError = "";
// 获取栏目
List <SubjectItem> list = null;
int nRet = dp2WeiXinService.Instance.GetSubject(libId, group,
out list, out strError);
if (nRet == -1)
{
result.errorCode = -1;
result.errorInfo = strError;
}
if (param.Contains("list") == true)
{
result.list = list;
}
if (param.Contains("html") == true)
{
string html = dp2WeiXinService.Instance.GetSubjectHtml(libId,
group,
selSubject,
true,
list);
result.html = html;
}
result.errorCode = nRet;
result.errorInfo = strError;
return(result);
}
public ActionResult ViewSub(int?id, int?zid)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
AllClasses Data = new AllClasses();
if (!id.HasValue)
{
return(RedirectToAction("Index"));
}
else
{
Sub_Results ResultForPanel = new Cateloge().SelectSubResult(id);
if (ResultForPanel == null)
{
return(RedirectToAction("Index"));
}
else
{
Data.Sub_Result = new Sub_Result
{
id = ResultForPanel.id,
name = ResultForPanel.name
};
if (!zid.HasValue)
{
TempData["Message"] = "Please Enter A Valid Registration Number Of Student !";
}
else
{
Students SelectforPanel = new Cateloge().SelectStudentForPanel(Convert.ToInt32(zid));
if (SelectforPanel == null)
{
TempData["Message"] = "No Any Student Founded Against This Regsitration Number !";
}
else
{
List <SubjectResults> SelectSubjectsResultForWeb = new Cateloge().SelectAllSubjectsResultForWeb(Convert.ToInt32(SelectforPanel.db_Id), id);
ResultsPositions SelectResultPosition = new Cateloge().SelectResultPositionByRidSid(Convert.ToInt32(SelectforPanel.db_Id), id);
Data.Student = new Student
{
Aplicnt_Id = SelectforPanel.Aplicnt_Id,
Aplicnt_name = SelectforPanel.Aplicnt_name,
Aplicnt_f_name = SelectforPanel.Aplicnt_f_name,
ClassName = SelectforPanel.ClassName.Name
};
if (SelectSubjectsResultForWeb == null)
{
TempData["Message"] = "No Any Result Founded Against This Regsitration Number !";
}
else
{
Data.SubjectResult_s = new List <SubjectResult>();
Data.SubjectResult_s_ = new List <SubjectResult>();
foreach (var gdfc in SelectSubjectsResultForWeb)
{
SubjectResult dbr = new SubjectResult();
dbr.Subject_name = gdfc.Subject_name.Name;
dbr.Total_marks = gdfc.Total_marks.Total_marks;
dbr.Obtn_marks = gdfc.Obtn_marks;
dbr.Status = gdfc.Status;
Data.SubjectResult_s.Add(dbr);
}
if (SelectResultPosition == null)
{
//TempData["Message"] = "The Student Position By Section Of This Result Not Posted Yet !";
}
else
{
Data.Result_Position = new ResultPosition
{
Id = SelectResultPosition.Id,
Class_Section = SelectResultPosition.Class_Section,
Obtn_Pstn = SelectResultPosition.Obtn_Pstn
};
}
List <Sub_Results> SelectAllSubResults = new Cateloge().SelectSubResultsWithDetail(Convert.ToInt32(ResultForPanel.S_id.db_Id), Convert.ToInt32(SelectforPanel.db_Id));
//List<Sub_Results> SelectAllSubResults = new Cateloge().SelectSubResultsWithDetail(Convert.ToInt32(1), Convert.ToInt32(1));
if (SelectAllSubResults == null)
{
TempData["Message"] = " Overall Report Is Empty !";
}
else
{
Data.Sub_Result_s = new List <Sub_Result>();
Data.SubjectResult_s_ = new List <SubjectResult>();
//Data.Sub_Result_s = new List<Sub_Result>();
foreach (var gdfc in SelectAllSubResults)
{
Sub_Result dbr = new Sub_Result();
dbr.id = gdfc.id;
dbr.name = gdfc.name;
dbr.Percentage = gdfc.Percentage;
if (gdfc.S_r == null)
{
ViewBag.StatusMessage = " No Any Result Founded ! ";
}
else
{
foreach (var llgdfc in gdfc.S_r.Where(a => a.Sub_r_id.Equals(dbr.id)))
{
}
foreach (var lgdfc in gdfc.S_r)
{
//SubjectResult ldbr = new SubjectResult();
//ldbr.Id = lgdfc.Id;
//ldbr.Obtn_marks = lgdfc.Obtn_marks;
//ldbr.Total_marks = lgdfc.Total_marks;
//ldbr.Status = lgdfc.Status;
//Data.SubjectResult_s_.Add(ldbr);
//dbr.S_r.Add(ldbr);
SubjectResult ldbr = new SubjectResult();
ldbr.Sub_r_id = lgdfc.Sub_r_id;
ldbr.Obtn_marks = lgdfc.Obtn_marks;
//ldbr.Total_marks = lgdfc.Total_marks;
Data.SubjectResult_s_.Add(ldbr);
}
}
Data.Sub_Result_s.Add(dbr);
}
}
}
}
}
}
return(View(Data));
}
}
}
public ActionResult ViewResult(int?id, int?zid)
{
WebAllClass Data = new WebAllClass();
if (!id.HasValue)
{
return(RedirectToAction("Index"));
}
else
{
Sub_Results ResultForWeb = new Cateloge().SelectAllSubResultForWeb(id);
if (ResultForWeb == null)
{
return(RedirectToAction("Index"));
}
else
{
Data.Sub_Result = new Sub_Result
{
id = ResultForWeb.id,
name = ResultForWeb.name
};
if (!zid.HasValue)
{
TempData["Message"] = "Please Enter A Valid Registration Number Of Student !";
}
else
{
Students SelectforWeb = new Cateloge().SelectAllStudentForWeb(Convert.ToInt32(zid));
if (SelectforWeb == null)
{
TempData["Message"] = "No Any Student Founded Against This Regsitration Number !";
}
else
{
List <SubjectResults> SelectSubjectsResultForWeb = new Cateloge().SelectAllSubjectsResultForWeb(Convert.ToInt32(SelectforWeb.db_Id), id);
Data.Student = new Student
{
Aplicnt_Id = SelectforWeb.Aplicnt_Id,
Aplicnt_name = SelectforWeb.Aplicnt_name,
Aplicnt_f_name = SelectforWeb.Aplicnt_f_name,
ClassName = SelectforWeb.ClassName.Name
};
if (SelectSubjectsResultForWeb == null)
{
TempData["Message"] = "No Any Result Founded Against This Regsitration Number !";
}
else
{
Data.SubjectResult_s = new List <SubjectResult>();
foreach (var gdfc in SelectSubjectsResultForWeb)
{
SubjectResult dbr = new SubjectResult();
dbr.Subject_name = gdfc.Subject_name.Name;
dbr.Total_marks = gdfc.Total_marks.Total_marks;
dbr.Obtn_marks = gdfc.Obtn_marks;
dbr.Status = gdfc.Status;
Data.SubjectResult_s.Add(dbr);
}
List <Sub_Results> SelectAllSubResultsForWeb = new Cateloge().SelectSubResultsWithDetailForWeb(Convert.ToInt32(ResultForWeb.S_id.db_Id), Convert.ToInt32(SelectforWeb.db_Id));
if (SelectAllSubResultsForWeb == null)
{
TempData["Message"] = " Overall Report Is Empty !";
}
else
{
Data.Sub_Result_s = new List <Sub_Result>();
Data.SubjectResult_s_ = new List <SubjectResult>();
foreach (var gdfc in SelectAllSubResultsForWeb)
{
Sub_Result dbr = new Sub_Result();
dbr.id = gdfc.id;
dbr.name = gdfc.name;
dbr.Percentage = gdfc.Percentage;
if (gdfc.S_r == null)
{
}
else
{
foreach (var lgdfc in gdfc.S_r)
{
SubjectResult ldbr = new SubjectResult();
ldbr.Sub_r_id = lgdfc.Sub_r_id;
ldbr.Obtn_marks = lgdfc.Obtn_marks;
//ldbr.Total_marks = lgdfc.Total_marks;
Data.SubjectResult_s_.Add(ldbr);
}
}
Data.Sub_Result_s.Add(dbr);
}
}
}
}
}
}
return(View(Data));
}
}
public bool Process(string outputFolder = null, string outputType = null)
{
foreach (var group in _Groups)
{
List <string> subjects = new List <string>();
foreach (var std in group.Students)
{
//calculate weighted average for each student in each group
std.WeightedAverage = CalculateStudentWeightedAverage(std);
//need to fill in list of subjects I assume that each group can have different subjects,
//if at least one person have subject in group then subject is relevant for group
foreach (var subject in std.Subjects)
{
if (!subjects.Contains(subject.Name))
{
subjects.Add(subject.Name);
}
}
}
//now when I know all the subjects relevant for group, can start calculation
foreach (var subj in subjects)
{
//get all values for this subject in group
var values = group.Students.Select(p => p.Subjects.Where(x => x.Name == subj).DefaultIfEmpty(new Subject()
{
Name = subj, SucessRate = 0
}).First().SucessRate).ToArray();
SubjectResult result = new SubjectResult();
result.Name = subj;
result.Average = StatFunctions.CalculateAverage(values);
result.Median = StatFunctions.CalculateMedian(values);
result.Modus = StatFunctions.CalculateModeValue(values);
group.SubjectResults.Add(result);
}
}
//now calculate overall results
//first build of list of relevant subjects
List <string> subjectsOverall = new List <string>();
foreach (var grp in _Groups)
{
foreach (var item in grp.SubjectResults)
{
if (!subjectsOverall.Contains(item.Name))
{
subjectsOverall.Add(item.Name);
}
}
}
//now start calculation
foreach (var subj in subjectsOverall)
{
List <int> totalvalues = new List <int>();
var valuesInGroups = _Groups.Select(u => u.Students.Select(p => p.Subjects.Where(x => x.Name == subj).DefaultIfEmpty(new Subject()
{
Name = subj, SucessRate = 0
}).First().SucessRate).ToList());
foreach (var item in valuesInGroups)
{
totalvalues.AddRange(item);
}
int[] totalValuesArray = totalvalues.ToArray();
SubjectResult newResult = new SubjectResult();
newResult.Name = subj;
newResult.Average = StatFunctions.CalculateAverage(totalValuesArray);
newResult.Median = StatFunctions.CalculateMedian(totalValuesArray);
newResult.Modus = StatFunctions.CalculateModeValue(totalValuesArray);
_TotalResults.Add(newResult);
}
//everything calculated at this point
return(true);
}
public ActionResult View(int id)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
Students Student_s = new Cateloge().SelectStudent(id);
List <Sub_Results> subresultstitle = new Cateloge().SelectSubResultsTitles();
List <SubjectResults> subjectresults = new Cateloge().SelectStudentResultById(id);
if (Student_s == null)
{
ViewBag.StatusMessage = " No Any Result Founded ! ";
}
else
{
AllClasses Data = new AllClasses();
Data.Sub_Result_s = new List <Sub_Result>();
Data.SubjectResult_s = new List <SubjectResult>();
if (subresultstitle == null)
{
TempData["NoData"] = " No Any Result Founded ! ";
}
else
{
foreach (var gdfc in subresultstitle)
{
Sub_Result dbr = new Sub_Result();
dbr.id = gdfc.id;
dbr.name = gdfc.name;
//if (subjectresults.Where(a => a.Sub_r_id.Equals(gdfc.id)).Count() > 0)
// {
// TempData["msg_"] = "Not Null";
// }
// else
// {
// TempData["msg_"] = null;
//}
Data.Sub_Result_s.Add(dbr);
}
}
if (subjectresults == null)
{
TempData["NoData"] = " No Any Result Founded ! ";
}
else
{
foreach (var gdfc in subjectresults)
{
SubjectResult dbr = new SubjectResult();
dbr.Sub_r_id = gdfc.Sub_r_id;
Data.SubjectResult_s.Add(dbr);
}
}
Data.Student = new Student
{
db_Id = Student_s.db_Id,
Aplicnt_Id = Student_s.Aplicnt_Id,
Aplicnt_name = Student_s.Aplicnt_name,
Aplicnt_nnlty = Student_s.Aplicnt_nnlty,
Aplicnt_c_grade = Student_s.Aplicnt_c_grade,
Aplicnt_dob = Student_s.Aplicnt_dob,
Aplicnt_pob = Student_s.Aplicnt_pob,
Aplicnt_gender = Student_s.Aplicnt_gender,
Aplicnt_c_addr = Student_s.Aplicnt_c_addr,
Aplicnt_p_addr = Student_s.Aplicnt_p_addr,
Aplicnt_h_phone = Student_s.Aplicnt_h_phone,
Aplicnt_pp_photo = Student_s.Aplicnt_pp_photo,
Aplicnt_emrgncy_p_name = Student_s.Aplicnt_emrgncy_p_name,
Aplicnt_emrgncy_p_rltn = Student_s.Aplicnt_emrgncy_p_rltn,
Aplicnt_emrgncy_p_cell = Student_s.Aplicnt_emrgncy_p_cell,
Aplicnt_emrgncy_p_ldln = Student_s.Aplicnt_emrgncy_p_ldln,
Aplicnt_emrgncy_p_addr = Student_s.Aplicnt_emrgncy_p_addr,
Aplicnt_emrgncy_p_email = Student_s.Aplicnt_emrgncy_p_email,
Aplicnt_f_name = Student_s.Aplicnt_f_name,
Aplicnt_f_ocptn = Student_s.Aplicnt_f_ocptn,
Aplicnt_f_title = Student_s.Aplicnt_f_title,
Aplicnt_f_cell = Student_s.Aplicnt_f_cell,
Aplicnt_f_bsns_name = Student_s.Aplicnt_f_bsns_name,
Aplicnt_f_bsns_addr = Student_s.Aplicnt_f_bsns_addr,
Aplicnt_f_email = Student_s.Aplicnt_f_email,
Aplicnt_f_phone = Student_s.Aplicnt_f_phone,
Aplicnt_m_name = Student_s.Aplicnt_m_name,
Aplicnt_m_cell = Student_s.Aplicnt_m_cell,
Aplicnt_m_ldln = Student_s.Aplicnt_m_ldln,
Aplicnt_b_one_name = Student_s.Aplicnt_b_one_name,
Aplicnt_b_one_grade = Student_s.Aplicnt_b_one_grade,
Aplicnt_b_two_name = Student_s.Aplicnt_b_two_name,
Aplicnt_b_two_grade = Student_s.Aplicnt_b_two_grade,
Aplicnt_b_thr_name = Student_s.Aplicnt_b_thr_name,
Aplicnt_b_thr_grade = Student_s.Aplicnt_b_thr_grade,
Aplicnt_b_fou_name = Student_s.Aplicnt_b_fou_name,
Aplicnt_b_fou_grade = Student_s.Aplicnt_b_fou_grade,
Aplicnt_b_prsnt_schl = Student_s.Aplicnt_b_prsnt_schl,
Aplicnt_b_date_atdnc = Student_s.Aplicnt_b_date_atdnc,
Aplicnt_b_lng_ins = Student_s.Aplicnt_b_lng_ins,
Aplicnt_p_schl_name_o = Student_s.Aplicnt_p_schl_name_o,
Aplicnt_p_schl_strt_date_o = Student_s.Aplicnt_p_schl_strt_date_o,
Aplicnt_p_schl_end_date_o = Student_s.Aplicnt_p_schl_end_date_o,
Aplicnt_p_schl_name_t = Student_s.Aplicnt_p_schl_name_t,
Aplicnt_p_schl_strt_date_t = Student_s.Aplicnt_p_schl_strt_date_t,
Aplicnt_p_schl_end_date_t = Student_s.Aplicnt_p_schl_end_date_t,
Aplicnt_phycl_emo_cndtn_ackwlg = Student_s.Aplicnt_phycl_emo_cndtn_ackwlg,
Aplicnt_spcl_intrst_hobby = Student_s.Aplicnt_spcl_intrst_hobby,
Source_of_acknwlge_abt_da = Student_s.Source_of_acknwlge_abt_da,
Publish_result = Student_s.Publish_result,
ClassName = (Student_s.ClassName != null) ? Student_s.ClassName.Name : null
};
return(View(Data));
}
return(RedirectToAction("Index"));
}
}
