public void SaveOrUpdateFreeVideo(FreeVideo freeVideo)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
if (freeVideo.FreeVideoId != null && freeVideo.FreeVideoId > 0)
{
//update
var result = _unitOfWork._freeVideoRepository.GetById((int)freeVideo.FreeVideoId);
if (result != null)
{
result.RoleName = freeVideo.RoleName;
result.FilePath = freeVideo.FilePath;
result.SubjectId = freeVideo.SubjectId;
_unitOfWork.SaveChanges();
}
}
else
{
//create
_unitOfWork._freeVideoRepository.Add(freeVideo);
_unitOfWork.SaveChanges();
}
}
}
public void InitializeDbContext(DataAccess.TeachersAssistantDbContext teachersAssistantDbContext)
{
_calendarBookingRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_classroomRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_freeDocumentRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_freeDocumentStudentRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_freeVideoRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_freeVideoStudentRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_paidDocuemtStudentRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_paidDocumentRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_paidVideoRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_paidVideoStudentRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_studentRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_studentTypeRepository.DbContextTeachersAssistant = TeachersAssistantDbContext;
_subjectRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_teacherRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_bookingTimeRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_bookingTimeRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_studentResourcesRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_qAHelpRequestRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_assignmentRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_assignmentSubmissionRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
_courseRepository.DbContextTeachersAssistant = teachersAssistantDbContext;
this.TeachersAssistantDbContext = teachersAssistantDbContext;
}
public dynamic GetUserBoughtItems(string name)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
var paidDocuments =
_unitOfWork._paidDocumentRepository.DbContextTeachersAssistant.ItemOrders.Where(
p => p.username.Equals(name) /*&& (bool)p.Order.paid_for*/);
if (paidDocuments.Any())
{
var paidDocs = from pd in paidDocuments.ToList()
join pr in _unitOfWork._paidDocumentRepository.DbContextTeachersAssistant.ShopProducts.ToList()
on pd.product_name equals pr.prodName into docs
from p in docs.ToList()
join q in _unitOfWork._paidDocumentRepository.GetAll().ToList() on p.DocumentId equals q.PaidDocumentId
select new { ProdId = p.prodId, ProdName = p.prodName, IsDocument = true, p.prodDesc, FilePath = q.FilePath };
var paidVids = from pd in paidDocuments.ToList()
join pr in _unitOfWork._paidVideoRepository.DbContextTeachersAssistant.ShopProducts.ToList()
on pd.product_name equals pr.prodName into docs
from p in docs.ToList()
join q in _unitOfWork._paidVideoRepository.GetAll().ToList() on p.DocumentId equals q.PaidVideoId
select new { ProdId = p.prodId, ProdName = p.prodName, IsDocument = false, p.prodDesc, FilePath = q.FilePath };
var result = paidDocs.ToList();
result.AddRange(paidVids.ToList());
return(result);
}
return(null);
}
}
public void SaveOrUpdateAssignment(Assignment assignment)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
var assign = _unitOfWork._assignmentRepository.GetById(assignment.AssignmentId);
if (assign == null)
{
_unitOfWork._assignmentRepository.Add(assignment);
}
else
{
assign.AssignmentName = assignment.AssignmentName;
assign.DateAssigned = assignment.DateAssigned;
assign.DateDue = assignment.DateDue;
assign.Description = assignment.Description;
assign.FilePath = assignment.FilePath;
assign.SubjectId = assignment.SubjectId;
assign.StudentId = assignment.StudentId;
assign.StudentRole = assignment.StudentRole;
}
_unitOfWork.SaveChanges();
}
}
public void SaveOrUpdatePaidDocument(PaidDocument paidDocument)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
if (paidDocument.PaidDocumentId != null && paidDocument.PaidDocumentId > 0)
{
//update
var result = _unitOfWork._paidDocumentRepository.GetById((int)paidDocument.PaidDocumentId);
if (result != null)
{
result.RoleName = paidDocument.RoleName;
result.FilePath = paidDocument.FilePath;
result.SubjectId = paidDocument.SubjectId;
_unitOfWork.SaveChanges();
}
}
else
{
//create
_unitOfWork._paidDocumentRepository.Add(paidDocument);
_unitOfWork.SaveChanges();
}
}
}
public void SaveOrUpdateAssignmentSubmissions(AssignmentSubmission actualSubmission)
{
actualSubmission.IsSubmitted = true;
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
var submission = _unitOfWork._assignmentSubmissionRepository.GetById(actualSubmission.AssignmentSubmissionId);
var assignment = _unitOfWork._assignmentRepository.GetById(actualSubmission.AssignmentId);
if (submission == null)
{
_unitOfWork._assignmentSubmissionRepository.Add(actualSubmission);
}
else
{
submission.AssignmentId = actualSubmission.AssignmentId;
submission.DateDue = actualSubmission.DateDue;
submission.DateSubmitted = actualSubmission.DateSubmitted;
submission.FilePath = actualSubmission.FilePath;
submission.StudentId = actualSubmission.StudentId;
submission.StudentRole = actualSubmission.StudentRole;
submission.AssignmentName = actualSubmission.AssignmentName;
submission.TeacherId = actualSubmission.TeacherId;
submission.SubjectId = actualSubmission.SubjectId;
submission.IsSubmitted = true;
submission.Grade = actualSubmission.Grade;
submission.GradeNumeric = actualSubmission.GradeNumeric;
submission.Notes = actualSubmission.Notes;
}
assignment.IsSubmitted = true;
_unitOfWork.SaveChanges();
}
}
public void ManageClassRoom(Classroom classRoomModel)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
var classroom = _unitOfWork._classroomRepository.GetById((int)classRoomModel.ClassroomId);
if (classroom == null)
{
_unitOfWork._classroomRepository.Add(classRoomModel);
_unitOfWork.SaveChanges();
}
else
{
if (classroom != null)
{
classroom.SubjectId = classRoomModel.SubjectId;
classroom.TeacherId = classRoomModel.TeacherId;
classroom.StudentType = classRoomModel.StudentType;
classroom.CalendarId = classRoomModel.CalendarId;
_unitOfWork.SaveChanges();
}
}
}
}
public Classroom[] GetClassrooms()
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._classroomRepository.GetAll());
}
}
public Course GetCourseById(int courseId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._courseRepository.GetById(courseId));
}
}
public CalendarBooking GetTeacherCalendarByBookingId(int?bookingId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._calendarBookingRepository.GetById(((int)bookingId)));
}
}
public IList <SHOP_PRODS> GetProductsList()
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork.TeachersAssistantDbContext.ShopProducts.ToList());
}
}
public FreeVideo GetFreeVideoById(int?mediaId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._freeVideoRepository.GetById((int)mediaId));
}
}
public AssignmentSubmission[] GetCurrentAssignmentsSubmissions(string role, int studentId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._assignmentSubmissionRepository.GetAll().Where(p => p.StudentRole.ToLower().Equals(role.ToLower()) && p.StudentId == studentId).ToArray());
}
}
public Subject GetSubjectById(int?subjectId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._subjectRepository.GetById((int)subjectId));
}
}
public Classroom GetClassroomById(int?classroomId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._classroomRepository.GetById((int)classroomId));
}
}
public List <SHOP_PRODS> GetShoppingProdsList()
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._freeVideoRepository.DbContextTeachersAssistant.ShopProducts.ToList());
}
}
public Assignment GetAssignmentById(int assignmentId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._assignmentRepository.GetById(assignmentId));
}
}
public QAHelpRequest GetQARequestId(int qaHelpRequestId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._qAHelpRequestRepository.GetById(qaHelpRequestId));
}
}
public FreeVideo[] GetFreeVideos(string role)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._freeVideoRepository.GetAll().Where(p => p.RoleName.ToLower().Equals(role.ToLower())).ToArray());
}
}
public Teacher GetTeacherById(int?teacherId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._teacherRepository.GetById((int)teacherId));
}
}
public PaidDocument GetPaidDocumentById(int?mediaId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._paidDocumentRepository.GetById((int)mediaId));
}
}
public BookingTime GetBookingById(int bookingTimeId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._bookingTimeRepository.GetById(bookingTimeId));
}
}
public SHOP_PRODS GetProductById(int productId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork.TeachersAssistantDbContext.ShopProducts.SingleOrDefault(p => p.prodId == productId));
}
}
public Teacher GetTeacherByName(string name)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._teacherRepository.GetAll().FirstOrDefault(p => p.EmailAddress == name));
}
}
public Teacher[] GetTeacherList()
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._teacherRepository.GetAll());
}
}
public Student GetStudentByName(string emailAddress)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._studentRepository.GetAll().FirstOrDefault(p => p.EmailAddress == emailAddress));
}
}
public Subject[] GetSubjectList()
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._subjectRepository.GetAll());
}
}
public Subject GetSubjectByName(string subjectName)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._subjectRepository.GetAll().FirstOrDefault(p => p.SubjectName.ToLower().Equals(subjectName.ToLower())));
}
}
public StudentResource GetStudentResourceById(int studentResourceId)
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._studentResourcesRepository.GetById(studentResourceId));
}
}
public PaidVideo[] GetPaidVideos()
{
using (var dbContext = new DataAccess.TeachersAssistantDbContext())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._paidVideoRepository.GetAll());
}
}
