public ActionResult EditStudentResult(string EditEveluation, string EditClassId, string EditGradeId, string EditSubjectId)
{
try {
SchoolId = USession.School_Id;
List <GDgetSchoolGrade_Result> Gradelist = GetGradeDropdown();
ViewBag.EditGradeId = new SelectList(Gradelist, "GradeId", "GradeName");
long EveluationNo = Convert.ToInt64(EditEveluation);
int Subject = Convert.ToInt32(EditSubjectId);
var SubjectResult = Connection.GDgetSubjectsResult(SchoolId, EditGradeId, Subject, EveluationNo, "Y");
List <GDgetSubjectsResult_Result> SubjectResultlist = SubjectResult.ToList();
StudentReportModel tcm = new StudentReportModel();
List <StudentReportModel> tcmlist = SubjectResultlist.Select(x => new StudentReportModel
{
Seq = x.EveluationResultSeqNo,
StudentId = x.StudentId,
StudentName = x.studentName,
Mark = x.Mark
}).ToList();
return(View("EditStudentResults", tcmlist));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult StudantReport(string Activity, string GradeId, string ClassId)
{
try
{
if (GradeId == "All")
{
GradeId = "%";
}
if (ClassId == "All")
{
ClassId = "%";
}
SchoolId = USession.School_Id;
var student = Connection.GDgetExtraCurriculerAllStudentReport(SchoolId, Activity, GradeId, ClassId, "Y");
List <GDgetExtraCurriculerAllStudentReport_Result> studentlist = student.ToList();
StudentReportModel tcm = new StudentReportModel();
List <StudentReportModel> tcmlist = studentlist.Select(x => new StudentReportModel
{
StudentName = x.studentName,
GradeName = x.GradeName,
ClassName = x.ClassName
}).ToList();
return(PartialView("StudantReports", tcmlist));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult Delete(int ResultId)
{
try
{
StudentReportModel TModel = new StudentReportModel();
TModel.Seq = ResultId;
return(PartialView("DeleteView", TModel));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult ShowResult(string Eveluation, string ClassId, string GradeId)
{
try
{
SchoolId = USession.School_Id;
var Subject = Connection.GDgetEveluationSubject(SchoolId, GradeId);
List <GDgetEveluationSubject_Result> Subjectlist = Subject.ToList();
OptionalSubjectModel tcm = new OptionalSubjectModel();
List <OptionalSubjectModel> tcmlist = Subjectlist.Select(x => new OptionalSubjectModel
{
SubjectId = x.SubjectId.ToString(),
SubjectName = x.SubjectName
}).ToList();
ViewBag.Subject = tcmlist;
var Student = Connection.GDgetStudentInClass(SchoolId, GradeId, ClassId, "Y");
List <GDgetStudentInClass_Result> Studentlist = Student.ToList();
StudentModel Sm = new StudentModel();
List <StudentModel> Smlist = Studentlist.Select(x => new StudentModel
{
StudentName = x.studentName,
StudentId = x.StudentId
}).ToList();
ViewBag.StudentList = Smlist;
long eveluationseq = Convert.ToInt64(Eveluation);
var Result = Connection.GDgetEveluationResult(SchoolId, GradeId, eveluationseq);
List <GDgetEveluationResult_Result> Resultlist = Result.ToList();
StudentReportModel Rm = new StudentReportModel();
List <StudentReportModel> Rmlist = Resultlist.Select(x => new StudentReportModel
{
Mark = x.Mark,
SubjectId = x.SubjectId,
StudentId = x.StudentId
}).ToList();
ViewBag.ResultList = Rmlist;
return(PartialView("ShowResults"));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult Edit(StudentReportModel Model)
{
try
{
UserId = SchoolId = USession.User_Id;
Connection.GDModifyStudentEveluationResult(Model.Seq, Model.Mark, UserId);
Connection.SaveChanges();
ViewBag.UrlDetail = Model;
return(Json(ViewBag.UrlDetail, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult Delete(StudentReportModel Model)
{
try
{
UserId = USession.User_Id;
Connection.GDdeleteStudentEveluationResult(Model.Seq, UserId, "N");
Connection.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
//return RedirectToAction("Index");
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult Edit(string StudentId, string ResultId, string Mark, string GradeId, string ClassId, string SubjectId, string Eveluation)
{
try
{
StudentReportModel TModel = new StudentReportModel();
SchoolId = SchoolId = USession.School_Id;
TModel.Mark = Convert.ToDecimal(Mark);
tblStudent stu = Connection.tblStudents.SingleOrDefault(x => x.StudentId == StudentId && x.SchoolId == SchoolId);
TModel.StudentId = StudentId;
TModel.Seq = Convert.ToInt64(ResultId);
TModel.StudentName = stu.studentName;
TModel.GradeId = GradeId;
TModel.ClassId = ClassId;
TModel.SubjectId = Convert.ToInt32(SubjectId);
TModel.Eveluation = Eveluation;
return(PartialView("EditView", TModel));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult StudantReport(string EveluationId, string AccYear, string studentId)
{
try
{
long EvealuationType = Convert.ToInt64(EveluationId);
var student = Connection.GdgetStudentAttentionRequiredSubjects(AccYear, studentId, EvealuationType);
List <GdgetStudentAttentionRequiredSubjects_Result> studentlist = student.ToList();
StudentReportModel tcm = new StudentReportModel();
List <StudentReportModel> tcmlist = studentlist.Select(x => new StudentReportModel
{
Mark = x.Mark,
SubjectName = x.SubjectName
}).ToList();
return(PartialView("StudantReports", tcmlist));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
/// <summary>
/// Embed a new report image
/// </summary>
/// <param name="data"></param>
/// <returns>Avatar Passed In</returns>
public StudentReportModel Create(StudentReportModel data)
{
reportList.Add(data);
return(data);
}
/// <summary>
/// Embed a new report
/// </summary>
/// <param name="data"></param>
/// <returns>Avatar Passed In</returns>
public StudentReportModel Create(StudentReportModel data)
{
DataSource.Create(data);
return(data);
}
