public ActionResult Add()
{
int school_id = SessionHandler.GetSchoolID();
ParentDetails _pd = new ParentDetails();
ClassDetails _cd = new ClassDetails();
ViewBag.parents = _pd.GetAll(school_id);
ViewBag.classes = _cd.GetAll(school_id);
return View();
}
public ActionResult ExamMarks(int class_id = 0, int subject_id = 0)
{
int school_id = SessionHandler.GetSchoolID();
var exam_types = _ed.GetAll(school_id).ToList();
if (school_id != 0 && class_id != 0 && subject_id != 0)
{
var rests = _ed.FindOnCondition(school_id,class_id, subject_id);
if (rests.ToList().Count == 0 || exam_types.Count != rests.ToList().Count)
{
foreach (var exam in exam_types)
{
if (rests.ToList().Count == 0)
{
_ed.InsertSubjectExam(school_id, subject_id, exam.exam_id, class_id, 1);
}
else {
foreach (var se in rests)
{
if (se.exam_id == exam.exam_id && se.subject_id == subject_id && class_id == se.class_id)
continue;
_ed.InsertSubjectExam(school_id, subject_id, exam.exam_id, class_id, 1);
}
}
}
}
ViewBag.class_id = class_id;
ViewBag.subject_id = subject_id;
SubjectDetails sbs = new SubjectDetails();
ClassDetails clss = new ClassDetails();
ViewBag.subjects = sbs.GetAll(school_id).ToList().ToJSON();
ViewBag.classes = clss.GetAll(school_id);
var rest = _ed.FindOnCondition(school_id, class_id, subject_id);
return View(rest);
}
else
{
SubjectDetails sbs = new SubjectDetails();
ClassDetails clss = new ClassDetails();
ViewBag.subjects = sbs.GetAll(school_id).ToList().ToJSON();
ViewBag.classes = clss.GetAll(school_id);
return View();
}
}
//
// GET: /Parent/
public ActionResult Index()
{
if (Session[Configuration.SESSION_USER_ID] == null)
{
return RedirectToAction("Index", "Login");
}
int school_id = SchoolID();
TeacherDetail _td = new TeacherDetail();
ViewBag.teachers_list = _td.GetAll(school_id);
ClassDetails _cd = new ClassDetails();
ViewBag.classes_list = _cd.GetAll(school_id);
var result = _sd.GetAll(school_id).ToList();
return View(result);
}
public ActionResult StudentFee(int class_id=0,int exam_id = 0)
{
if (Session[Configuration.SESSION_USER_ID] == null)
{
return RedirectToAction("Index", "Login");
}
int school_id = SessionHandler.GetSchoolID();
ExamDetails _ed = new ExamDetails();
ClassDetails _cd = new ClassDetails();
ViewBag.exams = _ed.GetAll(school_id).ToList();
ViewBag.classes = _cd.GetAll(school_id).ToList();
if (school_id != 0 && class_id != 0 && exam_id != 0)
{
StudentDetails _sd = new StudentDetails();
var stds = _sd.GetAll(school_id,class_id);
//if (stds.ToList().Count == 0 || exam_types.Count != rests.ToList().Count)
//{
// foreach (var exam in exam_types)
// {
// if (rests.ToList().Count == 0)
// {
// _ed.InsertSubjectExam(school_id, subject_id, exam.exam_id, class_id, 1);
// }
// else
// {
// foreach (var se in rests)
// {
// if (se.exam_id == exam.exam_id && se.subject_id == subject_id && class_id == se.class_id)
// continue;
// _ed.InsertSubjectExam(school_id, subject_id, exam.exam_id, class_id, 1);
// }
// }
// }
//}
}
return View();
}
public ActionResult Edit(int id, StudentModelView student)
{
int school_id = SessionHandler.GetUserID();
var result = _sd.FindSingle(id, school_id);
ParentDetails _pd = new ParentDetails();
ClassDetails _cd = new ClassDetails();
ViewBag.parents = _pd.GetAll(school_id);
ViewBag.classes = _cd.GetAll(school_id);
return View(result);
}
public ActionResult MarkClass(int class_id = 0, string date = "")
{
if (Session[Configuration.SESSION_USER_ID] == null)
{
return RedirectToAction("Index", "Login");
}
ClassDetails _cd = new ClassDetails();
int school_id = SessionHandler.GetSchoolID();
ViewBag.class_id = class_id;
ViewBag.date = date;
ViewBag.classes = _cd.GetAll(school_id);
ViewBag.Days = 0;
if (class_id != 0)
{
var result = _ad.GetAll(school_id, class_id).ToList();
var _sd = new StudentDetails();
var stds = _sd.GetAll(school_id, class_id);
var adResult = _ad.GetAll(school_id, class_id, date).ToList();
//int daysInMonth = this.GetDaysInMonth(date);
ViewBag.Days = 1;
var day = date.GetDayOfMonth();
List<StudentOneDay> attendance = new List<StudentOneDay>();
foreach (var std in stds)
{
StudentOneDay stdAttnd = new StudentOneDay() { student_name = std.first_name + " " + std.last_name, student_id = std.user_id, status = -1 };
attendance.Add(stdAttnd);
var isExsited = false;
foreach (var adr in adResult)
{
if (std.user_id == adr.student_id)
{
isExsited = true;
}
}
if (!isExsited)
{
Attendance atd = new Attendance() { student_id = std.user_id, school_id = SessionHandler.GetSchoolID(), status = -1, class_id = class_id, date = date, updated_by = SessionHandler.GetUserID() };
_ad.Insert(atd);
}
}
return View(attendance);
}
return View();
}
public ActionResult ViewClass(int class_id = 0, string date = "")
{
ClassDetails _cd = new ClassDetails();
int school_id = SessionHandler.GetSchoolID();
ViewBag.classes = _cd.GetAll(school_id);
ViewBag.Days = 0;
ViewBag.class_id = class_id;
ViewBag.date = date;
if (class_id != 0 && date != "")
{
string startDate = "";
string endDate = "";
date.makeDateString(ref startDate, ref endDate);
int daysInMonth = date.GetDaysInMonth();
var result = _ad.GetAll(school_id, class_id, startDate, endDate).ToList();
var _sd = new StudentDetails();
var stds = _sd.GetAll(school_id, class_id);
ViewBag.Days = daysInMonth;
List<StudentAttendance> attendance = new List<StudentAttendance>();
foreach (var std in stds)
{
StudentAttendance stdAttnd = new StudentAttendance() { student_name = std.first_name + " " + std.last_name, student_id = std.user_id };
for (int x = 1; x <= daysInMonth; x++)
{
PresentStatus _ps = new PresentStatus() { dayOfMonth = x, status = -1 };
foreach (var atnd in result)
{
int dayInAtnd = atnd.date.GetDayOfMonth();
if (atnd.student_id == std.user_id && x == dayInAtnd)
{
_ps.status = atnd.status;
break;
}
}
stdAttnd.AttendanceDays.Add(_ps);
}
attendance.Add(stdAttnd);
}
return View(attendance);
}
return View();
}
public ActionResult StudentMarks(int class_id = 0, int subject_id = 0, int exam_id = 0)
{
int school_id = SessionHandler.GetSchoolID();
int user_id = SessionHandler.GetUserID();
SubjectDetails sbs = new SubjectDetails();
ClassDetails clss = new ClassDetails();
ViewBag.subjects = sbs.GetAll(school_id).ToList().ToJSON();
ViewBag.classes = clss.GetAll(school_id);
ViewBag.exams = _ed.GetAll(school_id).ToList();
if (school_id != 0 && class_id != 0 && subject_id != 0 && exam_id != 0)
{
StudentDetails stds = new StudentDetails();
var stnds_result = stds.GetAll(school_id, class_id).ToList();
var rests = _ed.FindMarksOnCondition(school_id, class_id, subject_id, exam_id);
if (rests.ToList().Count == 0 || stnds_result.Count != rests.ToList().Count)
{
foreach (var std in stnds_result)
{
if (rests.ToList().Count == 0)
{
_ed.InsertSubjectMarks(school_id, subject_id, exam_id, class_id, std.user_id, user_id);
}
else
{
bool isExisted = false;
foreach (var se in rests)
{
if (se.exam_id == exam_id && se.subject_id == subject_id && class_id == se.class_id && se.student_id == std.user_id)
isExisted = true;
}
if (!isExisted)
{
_ed.InsertSubjectMarks(school_id, subject_id, exam_id, class_id, std.user_id, user_id);
}
}
}
}
ViewBag.class_id = class_id;
ViewBag.subject_id = subject_id;
var rest = _ed.FindMarksOnCondition(school_id, class_id, subject_id, exam_id);
return View(rest);
}
return View();
}