public ActionResult DeleteAttendance(int id) { AttendanceStudent attendanceStudent = db.AttendanceStudents.Find(id); db.AttendanceStudents.Remove(attendanceStudent); db.SaveChanges(); return(RedirectToAction("Index")); }
// DeleteAttendance // GET: Progresses/Delete/5 public ActionResult DeleteAttendance(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AttendanceStudent attendanceStudent = db.AttendanceStudents.Find(id); return(View(attendanceStudent)); }
public ActionResult CreateAttendanceStudent([Bind(Include = "IDAttendanceStudent,Status,IdStudent,IdAttendance")] AttendanceStudent attendanceStudent) { if (ModelState.IsValid) { db.AttendanceStudents.Add(attendanceStudent); db.SaveChanges(); } // отправляем email try { ViewBag.IdStudent = new SelectList(db.Students, "IdStudent", "FullNameStudent", attendanceStudent.IdStudent); // ваборка почты var mail = (from m in db.Students where m.IdStudent == attendanceStudent.IdStudent select m.Mail).FirstOrDefault(); // выборка имени var student = (from m in db.Students where m.IdStudent == attendanceStudent.IdStudent select m.FullNameStudent).FirstOrDefault(); // выборка даты var date = (from m in db.AttendanceStudents where m.IdStudent == attendanceStudent.IdStudent select m.IdAttendance).FirstOrDefault(); var Achievement = attendanceStudent.Status; // отправка письма FeedBack feedback = new FeedBack(); feedback.Subkject = "Посещаемость"; feedback.text = String.Format($@"Ученик: {student} " + $"<br/>Дата: {date}" + $"<br/>Статус: {Achievement}"); Emailer.Send(mail.ToString(), feedback.Subkject, feedback.text); return(RedirectToAction("CreateAttendanceStudent")); } catch (Exception) { return(RedirectToAction("CreateAttendanceStudent")); } }