public IQueryable <Person> Get([FromServices] myDbContext dbContext)
{
return(dbContext.Person.Select(p => new Person()
{
--other props go here--,
prescDoc = p.prescDoc.Id == 0 ? null: p.prescDoc
}
// GET: Account
public ActionResult Index()
{
using (myDbContext db = new myDbContext())
{
return(View(db.userAccount.ToList()));
}
}
public static Teacher InputTeacher(myDbContext context)
{
Console.Write("CourseID teaching: ");
string courseid = Console.ReadLine();
Course course = context.Courses.Where(b => b.courseId == courseid).Single();
Console.Write("Name: ");
string TName = Console.ReadLine();
Console.Write("AuID: ");
string AUid = Console.ReadLine();
Teacher Teacher = new Teacher()
{
TeacherName = TName,
TeacherAUid = AUid,
};
if (course != null)
{
Teacher.Course = course;
}
else
{
Console.WriteLine("Course does not exist, create a course first");
return(null);
}
return(Teacher);
}
public static RequestHelpAssignments InputRequestHelpAssignments(myDbContext context)
{
Console.Write("Assignment to StudentID: ");
string StudID = Console.ReadLine();
Student student = context.Students.Where(a => a.StudentAUid == StudID).Single();
Console.Write("Assignment number: ");
string Anum = Console.ReadLine();
Console.Write("Assignment lecture: ");
string Alec = Console.ReadLine();
Assignment assignment = context.Assignments.Where(b => b.number == Anum && b.lecture == Alec).Single();
RequestHelpAssignments requestHelpAssignments = new RequestHelpAssignments()
{
Isactive = true
};
if (student != null && assignment != null)
{
requestHelpAssignments.Assignment = assignment;
requestHelpAssignments.Student = student;
}
else
{
Console.WriteLine("Student or Assignment number/lecture does not exist");
return(null);
}
return(requestHelpAssignments);
}
public ActionResult Edit(int id)
{
using (myDbContext db = new myDbContext())
{
userAccount u = db.userAccount.FirstOrDefault(x => x.UserID == id);
ViewData.Model = u;
return(View());
}
}
public ActionResult Edit(userAccount u)
{
using (myDbContext db = new myDbContext())
{
db.userAccount.Attach(u);
db.Entry(u).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Delete(int id)
{
using (myDbContext db = new myDbContext())
{
userAccount u = db.userAccount.Single(x => x.UserID == id);
db.userAccount.Remove(u);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Register(userAccount user)
{
if (ModelState.IsValid)
{
using (myDbContext db = new myDbContext())
{
db.userAccount.Add(user);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.msg = user.FirstName + " Register successful";
}
return(View());
}
public static Exercise InputExercise(myDbContext context)
{
Console.Write("Assignment to CourseID: ");
string courseid = Console.ReadLine();
Course course = context.Courses.Where(b => b.courseId == courseid).Single();
Console.Write("Assignment to TeacherID: ");
string teachID = Console.ReadLine();
Teacher teacher = context.Teachers.Where(a => a.TeacherAUid == teachID).Single();
Console.Write("Assignment to StudentID: ");
string StudID = Console.ReadLine();
Student student = context.Students.Where(a => a.StudentAUid == StudID).Single();
Console.Write("Number: ");
string Enum = Console.ReadLine();
Console.Write("Lecture: ");
string ELec = Console.ReadLine();
Console.Write("Help where: ");
string Ewhere = Console.ReadLine();
Exercise exercise = new Exercise()
{
number = Enum,
lecture = ELec,
helpwhere = Ewhere
};
if (courseid != null && teachID != null && StudID != null)
{
exercise.Course = course;
exercise.Teacher = teacher;
exercise.student = student;
}
else
{
Console.WriteLine("Course, teacher or student does not exist");
return(null);
}
return(exercise);
}
public ProductController(myDbContext context)
{
_context = context;
if (_context.Products.Count() == 0)
{
_context.Products.Add(new Product()
{
name = "San Pham 1",
price = 1000
});
_context.Products.Add(new Product()
{
name = "San Pham 2",
price = 2000
});
_context.SaveChanges();
}
}
public ActionResult Login(userAccount user)
{
using (myDbContext db = new myDbContext())
{
var u = db.userAccount.FirstOrDefault(x => x.UserName == user.UserName);
if (u == null || u.Password != user.Password)
{
//ViewBag.msg = "Wrong UserName or Password!";
ModelState.AddModelError("", "Wrong UserName or Password!");
}
else
{
Session["UserId"] = user.UserName;
Session["UserName"] = user.UserName;
return(Redirect(Url.Action("Index", "Home")));
}
}
return(View());
}
public async Task <Rental> RentMovie(myDbContext _context)
{
// check if studio has rented movie already
var currentRentals = await _context.Rentals
.Where(x => x.MovieId == MovieId)
.Where(x => x.StudioId == StudioId).FirstOrDefaultAsync();
if (currentRentals != null)
{
// not allowed to rent same film more than once
return(null);
}
// check availablility
var movie = await _context.Movies
.Where(movieToRent => movieToRent.Id == this.MovieId).FirstOrDefaultAsync();
// return movie if available
return(movie.IsAvailable() ? this : null);
}
public static Assignment InputAssignment(myDbContext context)
{
Console.Write("Assignment to CourseID: ");
string courseid = Console.ReadLine();
Course course = context.Courses.Where(b => b.courseId == courseid).Single();
Console.Write("Assignment to TeacherID: ");
string teachID = Console.ReadLine();
Teacher teacher = context.Teachers.Where(a => a.TeacherAUid == teachID).Single();
Console.Write("Number: ");
string Anum = Console.ReadLine();
Console.Write("Lecture: ");
string ALec = Console.ReadLine();
Console.Write("Help where: ");
string Awhere = Console.ReadLine();
Assignment assignment = new Assignment()
{
number = Anum,
lecture = ALec,
helpwhere = Awhere,
};
if (courseid != null && teachID != null)
{
assignment.Course = course;
assignment.Teacher = teacher;
}
else
{
Console.WriteLine("Course or teacher does not exist");
return(null);
}
return(assignment);
}
public OrderRepository(myDbContext _db, IDispute disputeRepository)
{
db = _db;
this.disputeRepository = disputeRepository;
}
public UserRepository(myDbContext _db, IUserClaims userClaimsRepository, UserManager <ApplicationUser> _userManager)
{
db = _db;
this.userClaimsRepository = userClaimsRepository;
this._userManager = _userManager;
}
public ServiceRequestedRepository(myDbContext _db)
{
db = _db;
}
public CommentController()
{
db = new myDbContext();
manager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db));
}
public AdminController()
{
context = new myDbContext();
}
public UserInterfaceController()
{
context = new myDbContext();
}
public UserClaimsRepository(myDbContext _db)
{
db = _db;
}
public ServiceRepository(myDbContext _db, IOrder orderRepository)
{
db = _db;
this.orderRepository = orderRepository;
}
public UnitOfWork(myDbContext context)
{
_context = context;
}
public FeatureController(myDbContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public CategoryRepository(myDbContext _db, ISprovider sProviderRepository)
{
db = _db;
this.sProviderRepository = sProviderRepository;
}
public ProductController()
{
context = new myDbContext();
}
public CategoryController()
{
context = new myDbContext();
}
public EfRepository(myDbContext context)
{
_context = context;
}
public CustomerController()
{
context = new myDbContext();
}
public SproviderRepository(myDbContext _db, IService serviceRepository, IUser userRepository)
{
db = _db;
this.serviceRepository = serviceRepository;
this.userRepository = userRepository;
}
static void Main(string[] args)
{
Console.WriteLine("Hello DAB Assignment");
//Dummy data for Students
IList <Student> newStudents = new List <Student>()
{
new Student()
{
StudentName = "Karl", StudentAUid = "au123456"
},
new Student()
{
StudentName = "Frans", StudentAUid = "au666666"
},
new Student()
{
StudentName = "Hans", StudentAUid = "au676767"
},
new Student()
{
StudentName = "Bubber", StudentAUid = "au678678"
},
new Student()
{
StudentName = "Tobias", StudentAUid = "au696969"
},
new Student()
{
StudentName = "Hank", StudentAUid = "au890890"
},
new Student()
{
StudentName = "Frank", StudentAUid = "au999999"
}
};
//Dummy data for Courses
IList <Course> newCourses = new List <Course>()
{
new Course()
{
CourseName = "DAB", courseId = "101"
},
new Course()
{
CourseName = "NGK", courseId = "102"
},
new Course()
{
CourseName = "SWD", courseId = "103"
}
};
//Dummy data for which Courses Students Attends
IList <Attends> newAttendses = new List <Attends>()
{
new Attends()
{
Semester = "4. Semester", Student = newStudents[0], Course = newCourses[0]
}, //Karl attends DAB
new Attends()
{
Semester = "4. Semester", Student = newStudents[1], Course = newCourses[0]
}, //Frans attends DAB
new Attends()
{
Semester = "4. Semester", Student = newStudents[0], Course = newCourses[1]
}, //Karl attends NGK
new Attends()
{
Semester = "4. Semester", Student = newStudents[1], Course = newCourses[2]
}, //Frans attends SWD
new Attends()
{
Semester = "4. Semester", Student = newStudents[2], Course = newCourses[2]
}, //Hans attends SWD
new Attends()
{
Semester = "4. Semester", Student = newStudents[0], Course = newCourses[2]
}, //Karl attends SWD
new Attends()
{
Semester = "4. Semester", Student = newStudents[3], Course = newCourses[0]
} //Bubber attends DAB
};
//Dummy data for Teachers
IList <Teacher> newTeachers = new List <Teacher>()
{
new Teacher()
{
TeacherName = "Henrik Kirk", TeacherAUid = "au700001", Course = newCourses[0]
}, //Henrik teaches DAB
new Teacher()
{
TeacherName = "Michael Alrøe", TeacherAUid = "au700002", Course = newCourses[1]
}, //Alrøe teachers NGK
new Teacher()
{
TeacherName = "Michael Loft", TeacherAUid = "au700003", Course = newCourses[2]
} //Loft teaches SWD
};
IList <Exercise> newExercises = new List <Exercise>()
{
new Exercise()
{
number = "1", lecture = "EfCore Advanced", helpwhere = "Shannon 03B", Course = newCourses[0], Teacher = newTeachers[0], student = newStudents[0]
}, //Karl skal have hjælp til opgave 1 i DAB
new Exercise()
{
number = "2", lecture = "EfCore Intro", helpwhere = "Shannon 03B", Course = newCourses[0], Teacher = newTeachers[0], student = newStudents[0]
}, //Karl skal have hjælp til opgave 2 i DAB
new Exercise()
{
number = "1", lecture = "UDP", helpwhere = "Edison 114", Course = newCourses[1], Teacher = newTeachers[1], student = newStudents[0]
}, //Karl skal have hjælp til opgave 1 i NGK
new Exercise()
{
number = "2", lecture = "TCP", helpwhere = "Shannon 03B", Course = newCourses[1], Teacher = newTeachers[1], student = newStudents[2]
}, //Hans skal have hjælp til opgave 2 i NGK
new Exercise()
{
number = "3", lecture = "TCP", helpwhere = "Edison 114", Course = newCourses[1], Teacher = newTeachers[1], student = newStudents[0]
}, //Karl skal have hjælp til opgave 3 i NGK
new Exercise()
{
number = "1", lecture = "SOLID", helpwhere = "Shannon 03B", Course = newCourses[2], Teacher = newTeachers[2], student = newStudents[1]
} //Frans skal have hjælp til opgave 1 i SWD
};
//Dummy data for Assignments
IList <Assignment> newAssignments = new List <Assignment>()
{
new Assignment()
{
number = "1", lecture = "EfCore Advanced", helpwhere = "Shannon 03B", Teacher = newTeachers[0], Course = newCourses[0]
}, // Aflevering 1 til DAB
new Assignment()
{
number = "1", lecture = "TCP", helpwhere = "Shannon 03B", Teacher = newTeachers[1], Course = newCourses[1]
}, // Aflevering 1 til NGK
new Assignment()
{
number = "1", lecture = "SOLID", helpwhere = "Edison 114", Teacher = newTeachers[2], Course = newCourses[2]
}, // Aflevering 1 til SWD
};
IList <RequestHelpAssignments> newHelpAssignmentses = new List <RequestHelpAssignments>()
{
new RequestHelpAssignments()
{
Student = newStudents[0], Assignment = newAssignments[0], Isactive = true
}, // Karl arbejeder på Aflevering 1 til DAB
new RequestHelpAssignments()
{
Student = newStudents[1], Assignment = newAssignments[0], Isactive = true
}, // Frans arbejeder på Aflevering 1 til DAB
new RequestHelpAssignments()
{
Student = newStudents[2], Assignment = newAssignments[0], Isactive = true
}, // Hans arbejeder på Aflevering 1 til DAB
new RequestHelpAssignments()
{
Student = newStudents[1], Assignment = newAssignments[1], Isactive = true
}, // Frans arbejeder på Aflevering 1 til NGK
new RequestHelpAssignments()
{
Student = newStudents[2], Assignment = newAssignments[1], Isactive = true
}, // Hans arbejeder på Aflevering 1 til NGK
new RequestHelpAssignments()
{
Student = newStudents[3], Assignment = newAssignments[1], Isactive = true
}, // Bubber arbejeder på Aflevering 1 til NGK
new RequestHelpAssignments()
{
Student = newStudents[1], Assignment = newAssignments[2], Isactive = false
}, // Frans arbejeder på Aflevering 1 til SWD
new RequestHelpAssignments()
{
Student = newStudents[2], Assignment = newAssignments[2], Isactive = true
}, // Hans arbejeder på Aflevering 1 til SWD
new RequestHelpAssignments()
{
Student = newStudents[3], Assignment = newAssignments[2], Isactive = true
}, // Bubber arbejeder på Aflevering 1 til SWD
};
//Main program
using (var context = new myDbContext())
{
Console.WriteLine("");
Console.WriteLine("Press: a(Adds all dummy data), b(add courses)");
Console.WriteLine("Press: s(Delete all dummy data)");
Console.WriteLine("Press: l(list of StudentNames), k(list of courses), j(List of all teachers), g(see which course a student attends)");
Console.WriteLine("Press: p(To search a specific student), o(To search open help requests for assignments for a student");
Console.WriteLine("Press: i(To search either which open help request is connected to a teacher or a course)");
Console.WriteLine("Press: u(To see statistics for a specific course)");
Console.WriteLine("Creation: m(Student), n(Course), v(Teacher), c(Assignment), q(Exercise) & y(Help request)");
Console.WriteLine("Press: h(See the help list again)");
Console.WriteLine("Exit: x");
while (true)
{
Console.Write("Type Command:");
string line = Console.ReadLine();
switch (line)
{
case "a": //Case a will implement all the dummy data.
context.Students.AddRange(newStudents);
context.Teachers.AddRange(newTeachers);
context.Attends.AddRange(newAttendses);
context.Exercises.AddRange(newExercises);
context.Assignments.AddRange(newAssignments);
context.Courses.AddRange(newCourses);
context.RequestHelpAssignments.AddRange(newHelpAssignmentses);
context.SaveChanges();
break;
case "b": //What are you?
break;
case "s": //Case s will delete all the dummy data
context.Courses.RemoveRange(newCourses);
context.Students.RemoveRange(newStudents);
context.Teachers.RemoveRange(newTeachers);
context.Exercises.RemoveRange(newExercises);
context.Assignments.RemoveRange(newAssignments);
context.Attends.RemoveRange(newAttendses);
context.RequestHelpAssignments.RemoveRange(newHelpAssignmentses);
context.SaveChanges();
break;
case "l": //All students
foreach (var student in context.Students)
{
Console.WriteLine(student.StudentName + " " + student.StudentAUid);
}
break;
case "k": //All Courses
foreach (var course in context.Courses)
{
Console.WriteLine(course.CourseName + " " + course.courseId);
}
break;
case "j": //All Teachers
foreach (var teacher in context.Teachers)
{
Console.WriteLine(teacher.TeacherName + " " + teacher.TeacherAUid + " " + teacher.courseId);
}
break;
case "g": //Which course a student attends
foreach (var attends in context.Attends)
{
Console.WriteLine(attends.StudentId + " attends " + attends.CourseId + " during " + attends.Semester);
}
break;
case "p": //Specific student by AUID
Console.WriteLine("Enter the auID of the specific student: ");
string IDinput = Console.ReadLine();
var user = context.Students.Find(IDinput);
Console.WriteLine(user.StudentName + " " + user.StudentAUid + " " + user.StudentExercises);
break;
case "o": //Specific help request for a student by AUID
Console.WriteLine("Enter the auID of the specific student: ");
string IDinput1 = Console.ReadLine();
List <RequestHelpAssignments> user1 = context.RequestHelpAssignments
.Where(a => a.StudentId == IDinput1 && a.Isactive == true)
.Include(b => b.Student)
.Include(c => c.Assignment)
.ToList();
foreach (var s in user1)
{
Console.WriteLine("Student " + s.Student.StudentName + " needs help with assignment " + s.Assignment.lecture + " in building " + s.Assignment.helpwhere);
}
break;
case "i": //See all help request for a given Teacher or Course
Console.WriteLine("Enter teacherID or courseID: ");
string NewInput = Console.ReadLine();
List <RequestHelpAssignments> user2 = context.RequestHelpAssignments
.Where(a => a.Assignment.Teacher.TeacherAUid == NewInput && a.Isactive == true ||
a.Assignment.Course.courseId == NewInput && a.Isactive == true)
.Include(a => a.Assignment)
.ThenInclude(b => b.Teacher)
.Include(a => a.Assignment)
.ThenInclude(b => b.Course)
.Include(a => a.Student)
.ToList();
foreach (var b in user2)
{
Console.WriteLine("Student " + b.Student.StudentName + " needs help with assignment " + b.Assignment.lecture + " in building " + b.Assignment.helpwhere);
}
break;
case "u": //Statistics of requests for a course
Console.WriteLine("Enter courseID: ");
string CourseStats = Console.ReadLine();
List <RequestHelpAssignments> OpenReq = context.RequestHelpAssignments
.Where(a => a.Assignment.Course.courseId == CourseStats && a.Isactive == true)
.Include(a => a.Assignment)
.ThenInclude(b => b.Course)
.ToList();
List <RequestHelpAssignments> ClosedReq = context.RequestHelpAssignments
.Where(a => a.Assignment.Course.courseId == CourseStats && a.Isactive == false)
.Include(a => a.Assignment)
.ThenInclude(b => b.Course)
.ToList();
var CourseName = context.Courses.Find(CourseStats);
Console.WriteLine("For the course: " + CourseName.CourseName);
Console.WriteLine("The amount of open request: " + OpenReq.Count + " and closed request: " + ClosedReq.Count);
int Total = OpenReq.Count + ClosedReq.Count;
Console.WriteLine("Total amount request: " + Total);
break;
case "m": //Create student
Student newstudent = InputStudent();
context.Students.Add(newstudent);
context.SaveChanges();
break;
case "n": //Create Course
Course newCourse = InputCourse();
context.Courses.Add(newCourse);
context.SaveChanges();
break;
case "v": //Create Teacher
Teacher newTeacher = InputTeacher(context);
context.Teachers.Add(newTeacher);
context.SaveChanges();
break;
case "c": //Create Assignment
Assignment newAssignment = InputAssignment(context);
context.Assignments.Add(newAssignment);
context.SaveChanges();
break;
case "q": //Create Exercise
Exercise newExercise = InputExercise(context);
context.Exercises.Add(newExercise);
context.SaveChanges();
break;
case "y": //Create RequestHelpAssignments
RequestHelpAssignments newreRequestHelpAssignments = InputRequestHelpAssignments(context);
context.RequestHelpAssignments.Add(newreRequestHelpAssignments);
context.SaveChanges();
break;
case "h": //Console inputs
Console.WriteLine("");
Console.WriteLine("Press: a(Adds all dummy data), b(add courses)");
Console.WriteLine("Press: s(Delete all dummy data)");
Console.WriteLine("Press: l(list of StudentNames), k(list of courses), j(List of all teachers), g(see which course a student attends)");
Console.WriteLine("Press: p(To search a specific student), o(To search open help requests for assignments for a student");
Console.WriteLine("Press: i(To search either which open help request is connected to a teacher or a course)");
Console.WriteLine("Press: u(To see statistics for a specific course)");
Console.WriteLine("Creation: m(Student), n(Course), v(Teacher), c(Assignment), q(Exercise) & y(Help request)");
Console.WriteLine("Press: h(See the help list again)");
Console.WriteLine("Exit: x");
break;
case "x": //Case x will exit the while loop and close the program
Console.WriteLine("Exiting..");
return;
default: //In case a case which is not implemented is used
Console.WriteLine("Unknown command");
break;
}
}
}
}