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