public ActionResult DeleteConfirmed(int id)
        {
            Studying studying = db.Studyings.Find(id);

            db.Studyings.Remove(studying);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "Id,StudentId,ClassId")] Studying studying)
 {
     if (ModelState.IsValid)
     {
         db.Entry(studying).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.ClassId   = new SelectList(db.Classes, "Id", "Name", studying.ClassId);
     ViewBag.StudentId = new SelectList(db.Students, "Id", "Name", studying.StudentId);
     return(View(studying));
 }
        // GET: Studyings/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Studying studying = db.Studyings.Find(id);

            if (studying == null)
            {
                return(HttpNotFound());
            }
            return(View(studying));
        }
 public CompetenceActivitiesRoute()
 {
     PDFNAME        = "CompetenceActivities";
     RouteName      = "Competence Activities";
     PrimaryColor   = Color.Green;
     SecondaryColor = Color.Yellow;
     StartLevel.addSection(new ResourcePDF("Competence Activity Booklet", 0));
     StartLevel.addSection(Goals.asLevelContent());
     StartLevel.addSection(Needs.asLevelContent());
     StartLevel.addSection(Homework.asLevelContent());
     StartLevel.addSection(Studying.asLevelContent());
     StartLevel.addSection(Career.asLevelContent());
     StartLevel.addSection(College.asLevelContent());
 }
        // GET: Studyings/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Studying studying = db.Studyings.Find(id);

            if (studying == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ClassId   = new SelectList(db.Classes, "Id", "Name", studying.ClassId);
            ViewBag.StudentId = new SelectList(db.Students, "Id", "Name", studying.StudentId);
            return(View(studying));
        }
        private void FormPlanFromTest()
        {
            if (TestTasks.Count > 0)
            {
                int nfalse = 0;
                int ntopic = 0;

                nfalse = TestTasks.Where(t => t.IsDone == false).Count();
                ntopic = db.Topic.Count();

                double ndays = (ExamDate - StartDate).TotalDays;

                double x = ndays / (2 * nfalse + (ntopic - nfalse));

                DateTime currentDateTime = StartDate;

                foreach (Topic topic in db.Topic.ToList())
                {
                    var      studyings = db.Studying.ToList().Where(st => st.StudentId == CurrentStudent.StudentId && st.TopicId == topic.TopicId);
                    Studying studying;

                    if (studyings.Count() > 0)
                    {
                        studying = studyings.Last();
                        db.Studying.Remove(studying);
                    }
                    else
                    {
                        studying = new Studying();
                    }

                    studying.ComplationDate = currentDateTime;
                    studying.StudentId      = CurrentStudent.StudentId;
                    studying.TopicId        = topic.TopicId;

                    studyings = db.Studying.ToList();

                    if (studyings.Count() > 0)
                    {
                        studying.StudyingId = studyings.Last().StudyingId + 1;
                    }
                    else
                    {
                        studying.StudyingId = 1;
                    }


                    TaskModel taskModel = TestTasks.Where(t => t.TopicId == topic.TopicId).Last();
                    if (taskModel != null)
                    {
                        if (taskModel.IsDone == false)
                        {
                            studying.ComplationDate = currentDateTime.AddDays(x * 2);
                            currentDateTime         = studying.ComplationDate.Value;
                        }
                        else
                        {
                            studying.ComplationDate = currentDateTime.AddDays(x);
                            currentDateTime         = studying.ComplationDate.Value;
                        }
                    }
                    else
                    {
                        studying.ComplationDate = currentDateTime.AddDays(x);
                        currentDateTime         = studying.ComplationDate.Value;
                    }

                    if (studying.ComplationDate > ExamDate)
                    {
                        studying.ComplationDate = ExamDate;
                    }

                    db.Studying.Add(studying);
                    db.SaveChanges();
                }
            }
        }