public ActionResult attendance_class_list() { mst_attendanceMain att = new mst_attendanceMain(); bool flag; string role = ""; if (User.IsInRole("superadmin") || User.IsInRole("principal") || User.IsInRole("admin")) { flag = true; if (User.IsInRole("superadmin")) { role = "Super Admin"; } else if (User.IsInRole("principal")) { role = "Principal"; } else { role = "Admin"; } } else { flag = false; } return(View(att.Attendance_class_list(Int32.Parse(Request.Cookies["loginUserId"].Value.ToString()), flag, role))); //test }
public ActionResult deleteFaculty(int user_id, int class_id, int finalizer_user_id, int section_id, FormCollection ff) { mst_attendanceMain att = new mst_attendanceMain(); att.deleteFaculty(user_id, class_id, finalizer_user_id, section_id); return(RedirectToAction("list"));; }
public ActionResult deleteFaculty(int user_id, int class_id, int finalizer_user_id, int section_id) { mst_attendanceMain mst = new mst_attendanceMain(); return(View(mst.FindFaculty(user_id, class_id, finalizer_user_id, section_id)));; }
public ActionResult Assign_faculty(mst_attendance mst) { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { string query = @"SELECT COUNT(*) FROM mst_attendance WHERE class_id = @class_id AND section_id = @section_id"; int count = con.Query <int>(query, new { class_id = mst.class_id, section_id = mst.section_id }).SingleOrDefault(); if (mst.class_id == 0 || mst.section_id == 0) { ModelState.AddModelError(String.Empty, "Class and section cannot be blank."); DDFacultyList(); DDclass_name(); return(View(mst)); } if (count == 0) { mst_attendanceMain att = new mst_attendanceMain(); att.Assign_faculty(mst); return(RedirectToAction("list")); } else { ModelState.AddModelError(String.Empty, "Class already assigned to other faculty."); DDFacultyList(); DDclass_name(); return(View(mst)); } } }
public ActionResult list() { mst_attendanceMain mst = new mst_attendanceMain(); return(View(mst.assignList())); }