public Professor AddProfessor(Professor professor)
{
_collegeDbContext.Professors.Add(professor);
_collegeDbContext.SaveChanges();
return(professor);
}
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 ActionResult Create([Bind(Include = "ID,FirstName,LastName,JMBAG,DateOfBirth,DateOfEnrollment,Address,Email")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "ID,Name,NameAbbreviation,ViceDeanFirstName,ViceDeanLastName")] Major major)
{
if (ModelState.IsValid)
{
db.Majors.Add(major);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(major));
}
public ActionResult Create([Bind(Include = "ID,OIB,FirstName,LastName,DateOfBirth,Title")] Teacher teacher)
{
if (ModelState.IsValid)
{
db.Teachers.Add(teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(teacher));
}
public ActionResult Create([Bind(Include = "ID,Name,Address,FoundationYear,DeanFirstName,DeanLastName")] College college)
{
if (ModelState.IsValid)
{
db.Colleges.Add(college);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(college));
}
public ActionResult Create([Bind(Include = "ID,Details,ISVUNumber,HoursOfLectures,HoursOfAudit,HoursOfLab,HoursOfSeminar,HoursOfConstr,HoursOfHomework,Name,NumberOfECTS,Semester,TeacherID,MajorID")] Class @class)
{
if (ModelState.IsValid)
{
db.Classes.Add(@class);
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 Create([Bind(Include = "ID,StudentID,ClassID,DateOfEnrollment")] StudentClasses studentClasses)
{
if (ModelState.IsValid)
{
studentClasses.DateOfEnrollment = DateTime.Now;
db.StudentClasses.Add(studentClasses);
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 ActionResult Create([Bind(Include = "ID,StudentID,ClassID,GradeInt,DateOfGrade")] Grade grade)
{
if (ModelState.IsValid)
{
grade.DateOfGrade = DateTime.Now;
db.Grades.Add(grade);
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 Create(College college)
{
try
{
// TODO: Add insert logic here
college.CollegeID = new Guid();
collegeDbContext.College.Add(college);
collegeDbContext.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public Professor AddProfessor(ProfessorForAddOrUpdate professor)
{
var newProfessor = new Professor
{
Name = professor.Name,
Doj = professor.Doj,
Salary = professor.Salary,
IsPhd = professor.IsPhd,
Teaches = professor.Teaches
};
_collegeDbContext.Professors.Add(newProfessor);
_collegeDbContext.SaveChanges();
return(newProfessor);
}
public int SaveAudit(int userId, string desc, AuditAction action)
{
context.Audit.Add(new Audit {
AuditTime = DateTime.Now, Action = $"{action.ToString()} : {desc}", UserId = userId
});
return(context.SaveChanges());
}
public ActionResult Register(AppUser appUser)
{
if (ModelState.IsValid)
{
db.AppUsers.Add(appUser);
db.SaveChanges();
return(RedirectToAction("Login", "Accounts"));
}
return(View(appUser));
}
public JsonResponse Create(Student student)
{
if (student == null)
{
return(new JsonResponse {
Result = "Failed",
Message = "Create requires an instance of a Student"
});
}
if (!ModelState.IsValid)
{
return(new JsonResponse {
Result = "Failed",
Message = "One of the attributes is invalid"
});
}
db.Students.Add(student);
db.SaveChanges();
return(new JsonResponse());
}
public JsonResponse Create(Major major)
{
if (major == null)
{
return(new JsonResponse {
Result = "Failed",
Message = "Create requires an instance of a Major"
});
}
if (!ModelState.IsValid)
{
return(new JsonResponse {
Result = "Failed",
Message = "One of the attributes is invalid"
});
}
db.Majors.Add(major);
db.SaveChanges();
return(new JsonResponse());
}
public Address AddAddress(Address address)
{
_logger.Log(LogLevel.Debug, "Request Received for AddressDAL::AddAddress");
_collegeDbContext.AddressBook.Add(address);
_collegeDbContext.SaveChanges();
_logger.Log(LogLevel.Debug, "Returning the results from AddressDAL::AddAddress");
return(address);
}
public Professor AddProfessor(Professor professor)
{
_logger.Log(LogLevel.Debug, "Request Received for ProfessorDAL::AddProfessor");
_collegeDbContext.Professors.Add(professor);
_collegeDbContext.SaveChanges();
_logger.Log(LogLevel.Debug, "Returning the results from ProfessorDAL::AddProfessor");
return(professor);
}
public Student AddStudent(StudentForAddOrUpdate studentForAdd)
{
var newStudent = new Student
{
Name = studentForAdd.Name,
ProfessorId = studentForAdd.ProfessorId,
RollNumber = studentForAdd.RollNumber,
Fees = studentForAdd.Fees
};
_collegeDbContext.Students.Add(newStudent);
_collegeDbContext.SaveChanges();
return(newStudent);
}
public ActionResult <IEnumerable <Professor> > Get()
{
var newProfessor = new Professor
{
ProfessorId = Guid.NewGuid()
};
var np = _collegeDbContext.Set <Professor>();
np.Add(newProfessor);
_collegeDbContext.Professors.Add(newProfessor);
_collegeDbContext.SaveChanges();
var professors = _collegeDbContext
.Professors
.AsNoTracking()
.OrderByDescending(x => x.ProfessorId)
.ToList();
return(Ok(professors));
}
public ActionResult Register(User user)
{
if (ModelState.IsValid)
{
var check = db.Users
.FirstOrDefault(x => x.Email == user.Email);
if (check == null)
{
user.Password = GetMD5(user.Password);
db.Configuration.ValidateOnSaveEnabled = false;
// default role
user.UserRole = UserRoles.Teacher;
db.Users.Add(user);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("Unable to save changes: ", ex.ToString());
}
return(RedirectToAction("Login"));
}
else
{
ViewBag.error = "Email already exists";
return(View());
}
}
ViewBag.error = "Incorrect input";
return(View());
}
public int commit()
{
return(dbContext.SaveChanges());
}
public void Insert(Subject entity)
{
_context.Subjects.Add(entity);
_context.SaveChanges();
}
public Student add(Student student)
{
_context.Students.Add(student);
_context.SaveChanges();
return(student);
}
public void add(Evaluation evaluation)
{
_context.Evaluation.Add(evaluation);
_context.SaveChanges();
}
public void Insert(Student entity)
{
_context.Students.Add(entity);
_context.SaveChanges();
}
public Author add(Author author)
{
_context.Authors.Add(author);
_context.SaveChanges();
return(author);
}
public Course add(Course course)
{
_context.Courses.Add(course);
_context.SaveChanges();
return(course);
}
