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