public ActionResult rollno_class_student_list(List <mst_rollnumber> list)
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string query = @"SELECT
COUNT(*)
FROM
mst_rollnumber a,
mst_std_class b,
mst_std_section c
WHERE
a.session = @session
AND a.session = b.session
AND b.session = c.session
AND a.sr_num = b.sr_num
AND b.sr_num = c.sr_num
AND a.roll_number = @roll_number
AND b.class_id = @class_id
AND c.section_id = @section_id";
mst_sessionMain sess = new mst_sessionMain();
string session = sess.findActive_finalSession();
int count = 0;
foreach (var roll in list)
{
count = con.Query <int>(query, new { session = session, roll_number = roll.roll_number, class_id = roll.class_id, section_id = roll.section_id }).SingleOrDefault();
if (count > 0)
{
ModelState.AddModelError(String.Empty, "Roll number already assigned to other student.");
mst_rollnumberMain attendanceMain = new mst_rollnumberMain();
IEnumerable <mst_rollnumber> roll_no = attendanceMain.student_list_for_rollnumber(roll.class_id, roll.section_id);
int j = attendanceMain.max_roll_number(roll.class_id, roll.section_id);
foreach (var i in roll_no)
{
j = j + 1;
i.roll_number = j;
}
return(View(roll_no));
}
}
mst_rollnumberMain rollMain = new mst_rollnumberMain();
rollMain.update_roll_no(list);
return(RedirectToAction("roll_class_list"));
}
}
public ActionResult rollno_class_student_list(int class_id, int section_id)
{
mst_rollnumberMain attendanceMain = new mst_rollnumberMain();
IEnumerable <mst_rollnumber> roll = attendanceMain.student_list_for_rollnumber(class_id, section_id);
int j = attendanceMain.max_roll_number(class_id, section_id);
foreach (var i in roll)
{
j = j + 1;
i.roll_number = j;
}
return(View(roll));
}
public ActionResult roll_class_list()
{
mst_rollnumberMain att = new mst_rollnumberMain();
return(View(att.assign_class_list(Int32.Parse(Request.Cookies["loginUserId"].Value.ToString()))));
}