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