public ActionResult Delete(string id) { var subjectRepository = new SubjectRepository(_context); subjectRepository.Delete(new Guid(id)); _context.Save(_loggedUser); return(new HttpStatusCodeResult(HttpStatusCode.OK)); }
public int DeleteSubject(int id) { SqlObject.CommandText = StoredProcedures.Subjects.DeleteSubject; SqlObject.Parameters = new object[] { id }; int result = _repository.Delete(id); return(result); }
public void DeleteSubjectTest() { SubjectRepository rep = new SubjectRepository(); rep.Delete(16); Subject plan = rep.Read(16); Assert.IsNull(plan); }
public void DeleteByNullValue() { // Arrange SubjectRepository subjectRepository = new SubjectRepository(dbContext); // Act // Assert Assert.ThrowsException <ArgumentNullException>(() => subjectRepository.Delete(entityToDelete: null)); }
public void DeleteByNullKey_Exception() { // Arrange SubjectRepository subjectRepository = new SubjectRepository(dbContext); object wrongId = null; // Act // Assert Assert.ThrowsException <ArgumentNullException>(() => subjectRepository.Delete(wrongId)); }
public void DeleteByWrongKey_Exception() { // Arrange SubjectRepository subjectRepository = new SubjectRepository(dbContext); Guid wrongId = default(Guid); // Act // Assert Assert.ThrowsException <InvalidOperationException>(() => subjectRepository.Delete(wrongId)); }
public ActionResult Delete(SubjectViewModel subjectViewModel) { SubjectRepository repository = new SubjectRepository(); if (subjectViewModel.Id.ToString() != String.Empty) { repository.Delete(subjectViewModel.Id); } return(RedirectToAction("Index")); }
public async Task <IActionResult> Delete(int id) { var user = await subjectRepository.Get(id); if (user == null) { return(NotFound(new { status = ResultStatus.STATUS_NOT_FOUND, message = "Không tìm thấy môn học" })); } await subjectRepository.Delete(id); return(Ok(new { status = ResultStatus.STATUS_OK, message = "Xóa thành công!" })); }
public ActionResult Delete(int id) { try { _subjectRepository.Delete(id); return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { result = e.Message }, JsonRequestBehavior.AllowGet)); } }
public IHttpActionResult DeleteSubject(int id) { var subject = subjectRepo.GetById(id); if (subject == null) { return(Content(HttpStatusCode.NotFound, "Item does not exist")); } subjectRepo.Delete(id); return(Ok()); }
public void DeleteByValue() { // Arrange SubjectRepository subjectRepository = new SubjectRepository(dbContext); Subject subjectToDelete = dbContext.Subjects.First(s => s.Name == "Subject 1"); // Act // This subject has messages that must have "subject: null" when one will be deleted. subjectRepository.Delete(subjectToDelete); dbContext.SaveChanges(); // Assert CollectionAssert.DoesNotContain(dbContext.Subjects.ToArray(), subjectToDelete); // Checks if all subject's messages are null. Assert.IsTrue(dbContext.Messages.AsEnumerable().Any(m => m.Subject == null || m.Subject.Id != subjectToDelete.Id)); }
public void DeleteByChangedValue() { // Arrange SubjectRepository subjectRepository = new SubjectRepository(dbContext); Subject changedSubjectToDelete = dbContext.Subjects.First(s => s.Name == "Subject 1"); changedSubjectToDelete.Name += "Changed it"; // Act subjectRepository.Delete(entityToDelete: changedSubjectToDelete); dbContext.SaveChanges(); // Assert CollectionAssert.DoesNotContain(dbContext.Subjects.ToArray(), changedSubjectToDelete); // Checks if all subject's messages are null. Assert.IsTrue(dbContext.Messages.AsEnumerable().Any(m => m.Subject == null || m.Subject.Id != changedSubjectToDelete.Id)); }
public ActionResult DeleteSubject(SubjectDeleteSubjectVM model) { SubjectRepository subjectRepo = new SubjectRepository(); Subject subject = subjectRepo.GetByID(model.SubjectID); if (subject.CourseSubject.Count() > 0) { ModelState.AddModelError("Error", "Subject contains teacher or course"); model.SubjectID = subject.ID; model.SubjectName = subject.Name; return View(model); } subjectRepo.Delete(subject); return RedirectToAction("ListSubjects", "Subject"); }
public void Delete(SubjectDM domain) { try { _SubjectRepo.Delete(domain); } catch (Exception ex) { //Errors in this scope indicates system error (not validation errors) //If error not handled, log it and add system error if (!_GlobalErrors.ErrorHandled) { _Logger.Error(ex, "Database Error: Cannot Delete Subject!"); _GlobalErrors.AddSystemError("Database Error: Cannot Delete Subject!"); _GlobalErrors.ErrorHandled = true; } throw; } }
public JsonResult DeleteSubject(int id) { bool subjectInUse = false; CourseSubjectRepository courseSubjectRepository = new CourseSubjectRepository(); List <Course> courseList = new List <Course>(); courseList = courseSubjectRepository.GetAll(filter: cs => cs.Subject.Id == id).Select(c => c.Course).ToList(); if (courseList.Count > 0) { subjectInUse = true; } else { SubjectRepository subjectRepository = new SubjectRepository(); Subject subject = new Subject(); subject = subjectRepository.GetById(id); subjectRepository.Delete(subject); } return(Json(subjectInUse, JsonRequestBehavior.AllowGet)); }
public IHttpActionResult Delete(int tid, int sid) { List <Subject> subList = techRepo.GetSubjectByTeacher(tid); Subject subject = subRepo.GetById(sid); bool check = false; foreach (var item in subList) { if (item.SubjectId == subject.SubjectId) { check = true; } } if (check == false) { return(StatusCode(HttpStatusCode.Unauthorized)); } subRepo.Delete(sid); return(StatusCode(HttpStatusCode.NoContent)); }
public void testDelete() { // Arrange repo.Add(entity); repo.SaveChanges(); int count = repo.All().Count(); Guid id = repo.GetByName(n).Id; // Act repo.Delete(entity); repo.SaveChanges(); // Assert Assert.Null(repo.GetByName(n)); Assert.True(repo.All().Count() == count - 1); Assert.True(repo.GetById(id).IsDeleted); this.repo.HardDelete(entity); this.repo.SaveChanges(); //TODO add all remaining methods }
public void Delete(int id) { var marks = _markRepository.GetAllBy(i => i.StudentId == id).ToList(); //var mark = _markRepository.GetFirstValue(markObj.Id); foreach (var mark in marks) { var result = _markRepository.Delete(mark); } var subjects = _subjectRepository.GetAllBy(i => i.StudentId == id).ToList(); foreach (var subject in subjects) { //var subject = _subjectRepository.GetFirstValue(subjectObj.Id); _subjectRepository.Delete(subject); } var students = _studentRepository.GetAllBy(i => i.Id == id).ToList(); //var student = _studentRepository.GetFirstValue(studentObj.Id); foreach (var student in students) { _studentRepository.Delete(student); } }
// DELETE api/values/5 public IHttpActionResult Delete(int id) { var updatedRowsCount = repo.Delete(id); return(new ResponseClass(JsonConvert.SerializeObject(updatedRowsCount), Request)); }
public JsonResult DeleteSubject(int id) { bool subjectInUse = false; CourseSubjectRepository courseSubjectRepository = new CourseSubjectRepository(); List<Course> courseList = new List<Course>(); courseList = courseSubjectRepository.GetAll(filter: cs => cs.Subject.Id == id).Select(c => c.Course).ToList(); if (courseList.Count > 0) { subjectInUse = true; } else { SubjectRepository subjectRepository = new SubjectRepository(); Subject subject = new Subject(); subject = subjectRepository.GetById(id); subjectRepository.Delete(subject); } return Json(subjectInUse, JsonRequestBehavior.AllowGet); }
public async Task <MessageResult> Delete(int SubjectID) { var repository = new SubjectRepository(); return(await repository.Delete(SubjectID)); }
public void Delete(int id) { subjectRepository.Delete(id); }
static void Main(string[] args) { int counter = 1; IStudentRepository studentRepository = new StudentRepository(); ISubjectRepository subjectRepository = new SubjectRepository(); while (true) { Console.WriteLine("Enter 1 to add new student\n" + "Enter 2 to view students list\n" + "Enter 3 to exit\n" + "Enter 4 to edit list\n" + "Enter 5 to add subjects for student\n" + "Enter 6 to edit subjects\n" + "Enter 7 to delete subject\n" + "Enter 8 to view details"); int switcher = int.Parse(Console.ReadLine()); switch (switcher) { case 1: Student student = new Student(); student.Id = counter; Console.Write("Enter name: "); student.Name = Console.ReadLine(); Console.Write("Enter surname: "); student.Surname = Console.ReadLine(); studentRepository.Create(student); counter++; Console.WriteLine($"{student.Name} {student.Surname} has been added"); break; case 2: if (studentRepository.Count() != 0) { foreach (var st in studentRepository.Get()) { Console.Write(st.Id); Console.WriteLine($". {st.Name} {st.Surname} {st.Rating}"); } } else { Console.WriteLine("List is empty"); } break; case 4: Console.Write("Enter ID of a student, who you want to edit: "); int editId = int.Parse(Console.ReadLine()); Console.Write("Write new name: "); var name = Console.ReadLine(); Console.Write("Write new surname: "); var surname = Console.ReadLine(); Console.WriteLine("Student has been successfully edited"); studentRepository.Update(editId, name, surname); break; case 3: return; case 5: Console.WriteLine("Enter ID of a student, whom you want to add subject: "); Subject subject = new Subject(); int addId = int.Parse(Console.ReadLine()); Console.Write("Write name of Subject: "); subject.SubjectName = Console.ReadLine(); Console.Write("Write mark of subject: "); subject.Mark = int.Parse(Console.ReadLine()); subjectRepository.Create(addId, subject); break; case 6: Console.WriteLine("Enter ID of a student, whose subject you want to edit: "); int editSubId = int.Parse(Console.ReadLine()); Console.Write("Write name of subject, which you want to edit"); string editName = Console.ReadLine(); Console.Write("Enter new mark: "); var mark = int.Parse(Console.ReadLine()); subjectRepository.Update(editSubId, editName, mark); Console.WriteLine("Subject was successfully edited"); break; case 7: Console.WriteLine("Enter ID of a student, whose subject you want to delete: "); int deleteId = int.Parse(Console.ReadLine()); Console.Write("Write name of subject, which you want to delete"); string deleteName = Console.ReadLine(); subjectRepository.Delete(deleteId, deleteName); break; case 8: Console.WriteLine("Enter ID of a student, who you want to see details: "); int viewId = int.Parse(Console.ReadLine()); var st1 = studentRepository.Get(viewId); Console.WriteLine($"ID: {st1.Id}"); Console.WriteLine($"Name: {st1.Name}"); Console.WriteLine($"Surname: {st1.Surname}"); Console.WriteLine($"Rating: {st1.Rating}"); Console.WriteLine("Subjects:"); foreach (var sub in st1.Subjects) { Console.WriteLine($"\t{sub.SubjectName} {sub.Mark}"); } break; default: throw new Exception("Wrong numb"); } } }
//[AdminAuthorization] public IHttpActionResult Deletesubject([FromUri] int id, [FromUri] int id2) { subrepo.Delete(id2); return(StatusCode(HttpStatusCode.NoContent)); }