public ActionResult DeleteConfirmed(string id)
{
Attendance_tbl attendance_tbl = db.Attendance_tbl.Find(id);
db.Attendance_tbl.Remove(attendance_tbl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult GetAttendance_tbl(string id)
{
Attendance_tbl attendance_tbl = db.Attendance_tbl.Find(id);
if (attendance_tbl == null)
{
return(NotFound());
}
return(Ok(attendance_tbl));
}
public static string AddAttendance(string[] student, string[] attendance, string courseid)
{
DBFunctions db = new DBFunctions();
var studenattendance = student.Zip(attendance, (s, a) => new { student = s, attendance = a });
foreach(var sa in studenattendance)
{
Attendance_tbl stad = new Attendance_tbl { CourseID = int.Parse(courseid), StudentID = int.Parse(sa.student), Attendance = sa.attendance,Date=DateTime.Now};
db.addattendance(stad);
}
return "done";
}
public static string AddAttendance(string[] student, string[] attendance, string courseid)
{
DBFunctions db = new DBFunctions();
var studenattendance = student.Zip(attendance, (s, a) => new { student = s, attendance = a });
foreach (var sa in studenattendance)
{
Attendance_tbl stad = new Attendance_tbl {
CourseID = int.Parse(courseid), StudentID = int.Parse(sa.student), Attendance = sa.attendance, Date = DateTime.Now
};
db.addattendance(stad);
}
return("done");
}
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Attendance_tbl attendance_tbl = db.Attendance_tbl.Find(id);
if (attendance_tbl == null)
{
return(HttpNotFound());
}
return(View(attendance_tbl));
}
public void addattendance(Attendance_tbl attendance)
{
db = new CollegeERPDBEntities();
DateTime date = DateTime.Now.Date;
var check = db.Attendance_tbl.Where(x => x.Date == date && x.StudentID == attendance.StudentID&&x.CourseID==attendance.CourseID).FirstOrDefault();
if(check==null)
{
db.Attendance_tbl.Add(attendance);
db.SaveChanges();
}
}
