public ActionResult attendance_sheet(int class_id, int section_id, int month_no, string session)
{
repAttendance_sheetMain attendance = new repAttendance_sheetMain();
attendance.pdfAttendanceSheet(class_id, section_id, month_no, session);
DDsession_name();
//DDclass_name();
return(View());
}
public async Task mark_attendance(List <attendance_register> attendance, int user_id)
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
mst_sessionMain sess = new mst_sessionMain();
string session_name = sess.findFinal_Session();
int class_id = 0;
int section_id = 0;
int month_no = 0;
DateTime att_date = DateTime.Now.Date;
if (sess.checkSessionNotExpired())
{
string query = @"INSERT INTO attendance_register
(`session`,
`user_id`,
`att_date`,
`sr_num`,
`attendance`)
VALUES
(@session,
@user_id,
@att_date,
@sr_num,
@attendance)";
foreach (attendance_register att in attendance)
{
att.session = session_name;
att.user_id = user_id;
att.att_date = System.DateTime.Now.AddMinutes(dateTimeOffSet);
await con.ExecuteAsync(query,
new
{
att.session,
att.user_id,
att.att_date,
att.sr_num,
att.attendance
});
class_id = att.class_id;
section_id = att.section_id;
month_no = att.att_date.Month;
att_date = att.att_date.Date;
}
repAttendance_sheetMain sendAttSheet = new repAttendance_sheetMain();
query = @"select c.Email from mst_attendance a,emp_profile b,emp_profile c
where
a.user_id = b.user_id
and
a.class_id = @class_id
and
a.user_id = @user_id
and
a.section_id = @section_id
and
a.finalizer = c.user_id";
string email_id = con.Query <string>(query, new { class_id = class_id, user_id = user_id, section_id = section_id }).SingleOrDefault();
sendAttSheet.MailAttendanceSheet(section_id, month_no, session_name, email_id, att_date);
}
}
}
