public ActionResult Index()
{
if (Session["User_id"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
AP_Menu menu = new AP_Menu();
var Menulist = db.user_rights(Convert.ToInt32(Session["User_id"]));
List <AP_Menu> menudisplay = menu.Menutree(Menulist, null);
Attendance_data count_user = db.Get_all_users();
ViewBag.allusers = count_user.att_id;
Attendance_data courses = db.Get_Valid_Course();
ViewBag.allcourses = courses.att_id;
Attendance_data helpers = db.Get_Expired_Course();
ViewBag.allhelper = helpers.att_id;
Attendance_data attendance = db.Get_all_attendance();
ViewBag.attendance = attendance.att_id;
List <Batch_header> bh_hd = db.Incomplete_course();
ViewBag.incom_cour = bh_hd;
return(View(menudisplay));
}
}
public ActionResult Index(DateTime?From_Date, DateTime?To_Date, string Batch_Name, string stud_id, string status)
{
if (Batch_Name == "0")
{
ViewBag.att_report_batch_name = "ALL";
ViewBag.att_report_ed_date = "ALL";
}
else
{
Attendance_data Att_header = db.Get_report_header(Batch_Name);
ViewBag.att_report_batch_name = Att_header.Batch_name;
//ViewBag.att_report_ed_date = Att_header.Bh_end_date;
}
if (From_Date == null)
{
From_Date = DateTime.Now.Date;
}
if (To_Date == null)
{
To_Date = DateTime.Now.Date;
}
if (Batch_Name == "0")
{
Batch_Name = "%";
}
if (stud_id == "0")
{
stud_id = "%";
}
ViewBag.From_date = From_Date;
ViewBag.to_date = To_Date;
ViewBag.Batch_Name = Batch_Name;
ViewBag.stud_id = stud_id;
ViewBag.status = status;
List <Att_Report> Att_report = db.report_att_present(Batch_Name, From_Date, To_Date, stud_id, status);
ViewBag.att_report = Att_report;
return(View());
}
public ActionResult Index(Attendance_data ad)
{
bool status = false;
var att_valid = db.attendance_valid(ad.BH_id);
if (att_valid.att_id == 1)
{
foreach (var i in ad.Attendance_dtl)
{
db.attuserupdate(ad.BH_id, i.Att_status, i.stud_id);
}
status = true;
}
else
{
List <Batch_header> Course_dropdown = db.get_Course_dropdown();
ViewBag.course = Course_dropdown;
var att_id = db.AutoGenerate_attendance_id();
ad.att_id = att_id.att_id;
db.Insert_attendance(ad);
foreach (var s in ad.Attendance_dtl)
{
s.bh_id = ad.BH_id;
s.att_id = att_id.att_id;
db.Insert_attendance_details(s);
}
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
