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()));
}
