public ActionResult ShowStudentResultToParent(string Eveluation, string AccYear)
{
try
{
SchoolId = USession.School_Id;
UserId = USession.User_Id;;
var Eveluations = Connection.GDgetEveluation(SchoolId, "Y");
List <GDgetEveluation_Result> Eveluationlist = Eveluations.ToList();
ViewBag.Eveluation = new SelectList(Eveluationlist, "EvaluationNo", "EvaluationDescription");
tblAccadamicYear Ttable = Connection.tblAccadamicYears.SingleOrDefault(x => x.SchoolId == SchoolId);
ViewBag.AccYear = Ttable.AccadamicYear;
var Student = Connection.GDgetStudentResult(SchoolId, Eveluation, AccYear, UserId, "Y");
List <GDgetStudentResult_Result> Studentlist = Student.ToList();
StudentModel Sm = new StudentModel();
List <StudentReportModel> Smlist = Studentlist.Select(x => new StudentReportModel
{
Mark = x.Mark,
SubjectName = x.SubjectName,
ShortName = x.ShortName
}).ToList();
return(View(Smlist));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
private void Dropdownlistdata(string AcademicYear, string GradeId)
{
List <SelectListItem> Optionallist = new List <SelectListItem>();
Optionallist.Add(new SelectListItem
{
Text = "Compulsary",
Value = "N"
});
Optionallist.Add(new SelectListItem
{
Text = "Optional",
Value = "Y",
});
SchoolId = USession.School_Id;
var Grade = Connection.GDgetSchoolGrade(SchoolId, "Y");
List <GDgetSchoolGrade_Result> Gradelist = Grade.ToList();
var SubjectCategory = Connection.GDgetAllSubjectCategory("Y");
List <GDgetAllSubjectCategory_Result> SubjectCategorylist = SubjectCategory.ToList();
tblAccadamicYear acc = Connection.tblAccadamicYears.SingleOrDefault(a => a.SchoolId == SchoolId);
ViewBag.AcademicYear = ("2017");
if (AcademicYear != "")
{
ViewBag.GradeId = AcademicYear;
}
ViewBag.SubjectCategoryId = new SelectList(SubjectCategorylist, "SubjectCategoryId", "SubjectCategoryName");
ViewBag.GradeId = new SelectList(Gradelist, "GradeId", "GradeName");
ViewBag.Optional = new SelectList(Optionallist, "Value", "Text");
}
public ActionResult UpdateAccedemicYear()
{
try
{
tblAccadamicYear Ttable = Connection.tblAccadamicYears.SingleOrDefault(x => x.SchoolId == SchoolId);
ViewBag.AccYear = Ttable.AccadamicYear;
return(View());
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult Detail(string GradeId, string ClassId, string AcedamicYear)
{
try
{
SchoolId = USession.School_Id;
tblAccadamicYear Ttable = Connection.tblAccadamicYears.SingleOrDefault(x => x.SchoolId == SchoolId);
Dropdownlistdata(SchoolId);
if (GradeId == null)
{
return(RedirectToAction("Index"));
}
ViewBag.CurentYear = AcedamicYear;
tblGrade TCtable = Connection.tblGrades.SingleOrDefault(x => x.GradeId == GradeId);
ViewBag.CurentGrade = TCtable.GradeName;
tblClass classtable = Connection.tblClasses.SingleOrDefault(x => x.ClassId == ClassId && x.GradeId == GradeId && x.SchoolId == SchoolId);
ViewBag.CurentClass = classtable.ClassName;
ViewBag.ParameterAcedamicYear = Ttable.AccadamicYear;
if (Ttable.AccadamicYear != AcedamicYear)
{
ViewBag.ErrorMsg = false;
}
else
{
ViewBag.ErrorMsg = true;
}
List <StudentGradeAdvanceModel> tcmlist = getdataForTable(AcedamicYear, GradeId, ClassId);
if (tcmlist.Count == 0)
{
return(RedirectToAction("Index"));
}
return(View(tcmlist));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
//[UserFilter(Function_Id = "ScCal")]
public ActionResult Index(string AcademicYear)
{
SchooId = USession.School_Id;
try
{
if (AcademicYear == null)
{
tblAccadamicYear AccYear = Connection.tblAccadamicYears.SingleOrDefault(a => a.SchoolId == SchooId);
ViewBag.AcademicYear = AccYear.AccadamicYear;
}
else
{
ViewBag.AcademicYear = AcademicYear;
}
var Group = Connection.GDgetSchoolCalenderEvent(SchooId, AcademicYear, "Y");
List <GDgetSchoolCalenderEvent_Result> Grouplist = Group.ToList();
SchoolCalenderModel tcm = new SchoolCalenderModel();
List <SchoolCalenderModel> tcmlist = Grouplist.Select(x => new SchoolCalenderModel
{
CalenderSeqNo = x.CalenderSeqNo,
SchoolId = x.SchoolId,
AcadamicYear = x.AcadamicYear,
DateComment = x.DateComment,
IsHoliday = x.IsHoliday,
SpecialComment = x.SpecialComment,
FromDate = x.FromDate,
ToDate = x.ToDate,
StartMonth = x.FromDate.Month.ToString(),
EndMonth = x.ToDate.Month.ToString(),
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate.ToShortDateString(),
IsActive = x.IsActive
}).ToList();
return(View(tcmlist));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
public ActionResult Index()
{
try
{
SchoolId = USession.School_Id;
tblAccadamicYear TCtable = Connection.tblAccadamicYears.SingleOrDefault(x => x.SchoolId == SchoolId);
ViewBag.AcedamicYear = TCtable.AccadamicYear;
Dropdownlistdata(SchoolId);
List <StudentGradeAdvanceModel> tcmlist = getdataForTable("", "", "");
return(View(tcmlist));
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}