public int SaveProgressComment(int ClassID, int StudentID, string Attitude1, string Attitude2, string Attitude3, string Comment, int Week, int Teacher, string Editor, int CommentID, string userName) { Comment = Comment.Trim(); if (CommentID == -1) // Create { MGTableProgressComments TeacherComment = new MGTableProgressComments(); TeacherComment.StudentID = StudentID; TeacherComment.ClassID = ClassID; TeacherComment.Week = Week; TeacherComment.TeacherID = Teacher; TeacherComment.Editor = Editor; TeacherComment.UserID = userName; // This is not right. DB table requires UserName, not UserID (Table Name is wrong) TeacherComment.CommentID = CommentID; TeacherComment.Attitude1 = Attitude1; TeacherComment.Attitude2 = Attitude2; TeacherComment.Attitude3 = Attitude3; TeacherComment.Comment = Comment; TeacherComment.CreatedDate = DateTime.Now; TeacherComment.LastModifiedDate = DateTime.Now; mCollegeDbContext.MGTableProgressComments.Add(TeacherComment); mCollegeDbContext.SaveChanges(); mCollegeDbContext.Entry(TeacherComment).GetDatabaseValues(); return(TeacherComment.CommentID); } else // Update { var modelFound = mCollegeDbContext.MGTableProgressComments.Find(CommentID); modelFound.ClassID = ClassID; modelFound.StudentID = StudentID; modelFound.Week = Week; modelFound.TeacherID = Teacher; modelFound.Comment = Comment; modelFound.Attitude1 = Attitude1; modelFound.Attitude2 = Attitude2; modelFound.Attitude3 = Attitude3; modelFound.LastModifiedDate = DateTime.Now; modelFound.Editor = Editor; modelFound.UserID = userName; mCollegeDbContext.Entry(modelFound); mCollegeDbContext.SaveChanges(); return(CommentID); } }
public async Task <IHttpActionResult> PutMajor(int id, Major major) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != major.ID) { return(BadRequest()); } db.Entry(major).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MajorExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IActionResult> PutUser([FromRoute] string id, [FromBody] User user) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != user.Id) { return(BadRequest()); } _context.Entry(user).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult Edit([Bind(Include = "ID,Name,NameAbbreviation,ViceDeanFirstName,ViceDeanLastName")] Major major) { if (ModelState.IsValid) { db.Entry(major).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(major)); }
public ActionResult Edit([Bind(Include = "ID,OIB,FirstName,LastName,DateOfBirth,Title")] Teacher teacher) { if (ModelState.IsValid) { db.Entry(teacher).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(teacher)); }
public ActionResult Edit([Bind(Include = "ID,Name,Address,FoundationYear,DeanFirstName,DeanLastName")] College college) { if (ModelState.IsValid) { db.Entry(college).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(college)); }
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,JMBAG,DateOfBirth,DateOfEnrollment,Address,Email")] Student student) { if (ModelState.IsValid) { db.Entry(student).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public async Task <bool> UpdateAsync(int id, Course course) { if (id != course.Id) { return(false); } _context.Entry(course).State = EntityState.Modified; int saved = await _context.SaveChangesAsync(); return(saved > 0); }
public async Task <ActionResult> Edit([Bind(Include = "Id,StudentId,Value")] Grade grade) { if (ModelState.IsValid) { db.Entry(grade).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(grade)); }
public async Task <bool> UpdateAsync(int id, Student student) { if (id != student.Id) { return(false); } _context.Entry(student).State = EntityState.Modified; int saved = await _context.SaveChangesAsync(); return(saved > 0); }
public async Task <bool> UpdateAsync(int id, Faculty faculty) { if (id != faculty.Id) { return(false); } _context.Entry(faculty).State = EntityState.Modified; int saved = await _context.SaveChangesAsync(); return(saved > 0); }
public ActionResult Edit([Bind(Include = "ID,Details,ISVUNumber,HoursOfLectures,HoursOfAudit,HoursOfLab,HoursOfSeminar,HoursOfConstr,HoursOfHomework,Name,NumberOfECTS,Semester,TeacherID,MajorID")] Class @class) { if (ModelState.IsValid) { db.Entry(@class).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MajorID = new SelectList(db.Majors, "ID", "Name", @class.MajorID); ViewBag.TeacherID = new SelectList(db.Teachers, "ID", "FullNameWithTitle", @class.TeacherID); return(View(@class)); }
public ActionResult Edit([Bind(Include = "ID,StudentID,ClassID,GradeInt,DateOfGrade")] Grade grade) { if (ModelState.IsValid) { grade.DateOfGrade = DateTime.Now; db.Entry(grade).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.Classes, "ID", "MajorSemesterNameEcts", grade.ClassID); ViewBag.StudentID = new SelectList(db.Students, "ID", "JMBAGAndFullName", grade.StudentID); return(View(grade)); }
public ActionResult Edit([Bind(Include = "ID,StudentID,ClassID,DateOfEnrollment")] StudentClasses studentClasses) { if (ModelState.IsValid) { studentClasses.DateOfEnrollment = DateTime.Now; db.Entry(studentClasses).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.Classes, "ID", "Details", studentClasses.ClassID); ViewBag.StudentID = new SelectList(db.Students, "ID", "FirstName", studentClasses.StudentID); return(View(studentClasses)); }
public async Task <ActionResult> Edit([Bind(Include = "CourseId,Title")] CourseViewModel courseViewModel) { var course = new Course(courseViewModel.Title) { CourseId = courseViewModel.CourseId ?? default(int) }; if (ModelState.IsValid) { db.Entry(course).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(course)); }
public async Task<ActionResult> Edit([Bind(Include = "SubjectId,Title,CourseId")] SubjectViewModel subjectViewModel) { var subject = new Subject(subjectViewModel.CourseId, subjectViewModel.Title) { SubjectId = subjectViewModel.SubjectId ?? default(int) }; if (ModelState.IsValid) { db.Entry(subject).State = EntityState.Modified; await db.SaveChangesAsync(); return RedirectToAction("Index"); } ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Title", subjectViewModel.CourseId); return View(subject); }
public async Task <ActionResult> Edit([Bind(Include = "TeacherId,Salary,Name,Birthday, SubjectId")] TeacherViewModel teacherViewModel) { var teacher = new Teacher(teacherViewModel.Name, teacherViewModel.Birthday, teacherViewModel.Salary, teacherViewModel.SubjectId) { TeacherId = teacherViewModel.TeacherId ?? default(int) }; if (ModelState.IsValid) { db.Entry(teacher).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.SubjectId = new SelectList(db.Subjects, "SubjectId", "Title", teacherViewModel.SubjectId); return(View(teacher)); }
public async Task <ActionResult> Edit([Bind(Include = "StudentId,SubjectId,RegistrationNumber,Name,Birthday")] StudentViewModel studentViewModel) { var student = new Student(studentViewModel.SubjectId, studentViewModel.RegistrationNumber, studentViewModel.Name, studentViewModel.Birthday) { StudentId = studentViewModel.StudentId ?? default(int) }; if (ModelState.IsValid) { db.Entry(student).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.SubjectId = new SelectList(db.Subjects, "SubjectId", "Title", studentViewModel.SubjectId); return(View(student)); }