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