public List <Employee> CreateEmployee(Employee employee)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(employee);
_context.SaveChanges();
return(_context.Employees.Where(x => x.EmployeeId == _context.Employees.Max(x => x.EmployeeId)).ToList());
}
public List <Student> CreateStudent(Student student)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(student);
_context.SaveChanges();
return(_context.Students.Where(x => x.StudentId == _context.Students.Max(x => x.StudentId)).ToList());
}
public List <ReservationForm> CreateReservationForm(ReservationForm reservationForm)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(reservationForm);
_context.SaveChanges();
return(_context.ReservationForms.Where(x => x.ReservationFormId == _context.ReservationForms.Max(x => x.ReservationFormId)).ToList());
}
public List <PartUsage> CreatePartUsage(PartUsage partUsage)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(partUsage);
_context.SaveChanges();
return(_context.PartUsages.Where(x => x.PartUsageId == _context.PartUsages.Max(x => x.PartUsageId)).ToList());
}
public List <ProfessorContract> CreateProfessorContract(ProfessorContract professorContract)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(professorContract);
_context.SaveChanges();
return(_context.ProfessorContracts.Where(x => x.ProfessorContractId == _context.ProfessorContracts.Max(x => x.ProfessorContractId)).ToList());
}
public List <Professorship> CreateProfessorship(Professorship vehicle)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(vehicle);
_context.SaveChanges();
return(_context.Professorships.Where(x => x.ProfessorShipId == _context.Professorships.Max(x => x.ProfessorShipId)).ToList());
}
public List <Maintenance> CreateMaintenance(Maintenance maintenance)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(maintenance);
_context.SaveChanges();
return(_context.Maintenances.Where(x => x.MaintenanceId == _context.Maintenances.Max(x => x.MaintenanceId)).ToList());
}
public List <School> CreateSchool(School school)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(school);
_context.SaveChanges();
return(_context.Schools.Where(x => x.SchoolId == _context.Schools.Max(x => x.SchoolId)).ToList());
}
public List <Tenure> CreateTenure(Tenure tenure)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(tenure);
_context.SaveChanges();
return(_context.Tenures.Where(x => x.TenureId == _context.Tenures.Max(x => x.TenureId)).ToList());
}
public List <Report> CreateReport(Report report)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(report);
_context.SaveChanges();
return(_context.Reports.Where(x => x.ReportId == _context.Reports.Max(x => x.ReportId)).ToList());
}
public List <Enrollment> CreateEnrollment(Enrollment enrollment)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(enrollment);
_context.SaveChanges();
return(_context.Enrollments.Where(x => x.EnrollmentId == _context.Enrollments.Max(x => x.EnrollmentId)).ToList());
}
public List <Course> CreateCourse(Course course)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(course);
_context.SaveChanges();
return(_context.Courses.Where(x => x.CourseId == _context.Courses.Max(x => x.CourseId)).ToList());
}
public List <Advisory> CreateAdvisory(Advisory advisory)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(advisory);
_context.SaveChanges();
return(_context.Advisories.Where(x => x.AdvisoryId == _context.Advisories.Max(x => x.AdvisoryId)).ToList());
}
public List <Vehicle> CreateVehicle(Vehicle vehicle)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(vehicle);
_context.SaveChanges();
return(_context.Vehicles.Where(x => x.VehicleId == _context.Vehicles.Max(x => x.VehicleId)).ToList());
}
public List <Department> CreateDepartment(Department department)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(department);
_context.SaveChanges();
return(_context.Departments.Where(x => x.DepartmentId == _context.Departments.Max(x => x.DepartmentId)).ToList());
}
public List <Section> CreateSection(Section section)
{
using TinyCollegeContext _context = new TinyCollegeContext(_builder.Options);
_context.Add(section);
_context.SaveChanges();
return(_context.Sections.Where(x => x.SectionId == _context.Sections.Max(x => x.SectionId)).ToList());
}
