public async Task <ActionResult> finalize_class_attendance_sheet(List <attendance_register> attendance, bool send_sms) { attendance_registerMain attendanceMain = new attendance_registerMain(); await attendanceMain.finalize_attendance(attendance, send_sms); return(View("success")); }
public async Task <ActionResult> attendance_class_student_list(List <attendance_register> attendance) { attendance_registerMain attendanceMain = new attendance_registerMain(); await attendanceMain.mark_attendance(attendance, Int32.Parse(Request.Cookies["loginUserId"].Value.ToString())); return(RedirectToAction("attendance_class_list")); }
public ActionResult finalize_class_attendance_sheet(int section_id, DateTime att_date, string session) { attendance_registerMain attendanceMain = new attendance_registerMain(); IEnumerable <attendance_register> att = attendanceMain.find_attendance_sheet_for_finalize(section_id, att_date, session); if (att.Count() > 0) { return(View(att)); } else { return(View("nodatafound")); } }
public ActionResult attendance_class_student_list(int class_id, int section_id) { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { mst_sessionMain session = new mst_sessionMain(); string sess = session.findFinal_Session(); string query = @"SELECT COUNT(*) FROM sr_register a, mst_section b, mst_std_section c, mst_std_class d WHERE c.section_id = b.section_id AND d.class_id = b.class_id AND a.std_active = 'Y' AND b.session = @session AND b.session = c.session AND c.session = d.session AND a.sr_number = c.sr_num AND c.sr_num = d.sr_num AND d.class_id = @class_id AND b.section_id = @section_id AND a.sr_number NOT IN (SELECT sr_num FROM mst_rollnumber WHERE session = @session)"; int count = con.Query <int>(query, new { class_id = class_id, section_id = section_id, session = sess }).SingleOrDefault(); if (count == 0) { attendance_registerMain attendanceMain = new attendance_registerMain(); return(View(attendanceMain.student_list_for_attendance(class_id, section_id))); } else { return(View("updateRollNo")); } } }