public ActionResult AddStudent(Student s) { AdmissionRecord rec = new AdmissionRecord { AdmissionDate = DateTime.Today, PreviousSchool = "", RollNumber = s.RollNumber, Status = true }; try { db.Students.Add(s); db.AdmissionRecords.Add(rec); db.SaveChanges(); }catch (Exception e) { if (db.AdmissionRecords.Find(rec.RecordID) != null) { db.AdmissionRecords.Remove(db.AdmissionRecords.Find(rec.RecordID)); } ViewBag.ErrorMessage = "Student couldn't be added\n" + e.Data; return(View("Error")); } return(RedirectToAction("ViewStudent", new { RollNumber = s.RollNumber })); }
//[HttpPost] public string SaveAttendance(DateTime date, bool sms, int classID, bool[] statuslist, string[] RollNumbers) { for (int i = 0; i < statuslist.Length; i++) { Attendance at = new Attendance() { Status = statuslist[i], RollNumber = RollNumbers[i], Date = date }; if ((db.Attendances.Where(m => m.RollNumber == at.RollNumber && m.Date == date)).FirstOrDefault() != null) { (db.Attendances.Where(m => m.RollNumber == at.RollNumber && m.Date == date)).FirstOrDefault().Status = statuslist[i]; } else { db.Attendances.Add(at); } } db.SaveChanges(); return("Saved Attendance"); }