public void SaveOrUpdatePaidDocument(PaidDocument paidDocument)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
if (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 SaveOrUpdateFreeVideo(FreeVideo freeVideo)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
if (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 dynamic GetUserBoughtItems(string name)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_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 ManageClassRoom(Classroom classRoomModel)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_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 PaidDocument GetPaidDocumentById(int?mediaId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._paidDocumentRepository.GetById((int)mediaId));
}
}
public FreeVideo[] GetFreeVideos(string role)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._freeVideoRepository.GetAll().Where(p => p.RoleName.ToLower().Equals(role.ToLower())).ToArray());
}
}
public Subject GetSubjectById(int subjectId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._subjectRepository.GetById((int)subjectId));
}
}
public Subject GetSubjectByName(string subjectName)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._subjectRepository.GetAll().FirstOrDefault(p => p.SubjectName.ToLower().Equals(subjectName.ToLower())));
}
}
public Student GetStudentByName(string emailAddress)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._studentRepository.GetAll().FirstOrDefault(p => p.EmailAddress == emailAddress));
}
}
public Teacher GetTeacherByName(string name)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._teacherRepository.GetAll().FirstOrDefault(p => p.EmailAddress == name));
}
}
public BookingTime GetBookingById(int bookingTimeId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._bookingTimeRepository.GetById(bookingTimeId));
}
}
public Teacher GetTeacherById(int?teacherId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._teacherRepository.GetById((int)teacherId));
}
}
public Classroom[] GetClassrooms()
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._classroomRepository.GetAll().ToArray());
}
}
public Classroom GetClassroomById(int?classroomId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._classroomRepository.GetById((int)classroomId));
}
}
public List <SHOP_PRODS> GetShoppingProdsList()
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._freeVideoRepository.DbContextTeachersAssistant.ShopProducts.ToList());
}
}
public IList <SHOP_PRODS> GetProductsList()
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork.TeachersAssistantDbContext.ShopProducts.ToList());
}
}
public FreeVideo GetFreeVideoById(int?mediaId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._freeVideoRepository.GetById((int)mediaId));
}
}
public CalendarBooking GetTeacherCalendarByBookingId(int?bookingId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._calendarBookingRepository.GetById(((int)bookingId)));
}
}
public SHOP_PRODS GetProductById(int productId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork.TeachersAssistantDbContext.ShopProducts.SingleOrDefault(p => p.prodId == productId));
}
}
public PaidVideo[] GetPaidVideos()
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._paidVideoRepository.GetAll());
}
}
public Subject[] GetSubjectList()
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
return(_unitOfWork._subjectRepository.GetAll().ToArray());
}
}
public CalendarBooking[] GetTeacherCalendar()
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
var teacherCalendar = _unitOfWork._calendarBookingRepository.GetAll();
return(teacherCalendar.ToArray());
}
}
public void DeleteBooking(int bookingTimeId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
var bookingToDelete = _unitOfWork._bookingTimeRepository.GetById(bookingTimeId);
_unitOfWork._bookingTimeRepository.Delete(bookingToDelete);
_unitOfWork.SaveChanges();
}
}
public void DeletePaidVideoById(int?mediaId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext); _unitOfWork._paidVideoRepository.Delete(new PaidVideo {
PaidVideoId = (int)mediaId
});
_unitOfWork.SaveChanges();
}
}
public CalendarBooking GetTeacherCalendarByBookingId(int teacherId, int bookingId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
CalendarBooking calendarBooking = null;
calendarBooking = _unitOfWork._calendarBookingRepository.GetAll().SingleOrDefault(p => p.TeacherId == teacherId && p.BookingTimeId == bookingId);
return(calendarBooking);
}
}
public void DeleteFreeDocumentById(int?mediaId)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
_unitOfWork._freeDocumentRepository.Delete(new FreeDocument {
FreeDocumentId = (int)mediaId
});
_unitOfWork.SaveChanges();
}
}
public void DeleteTeacher(Teacher teacherModel)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
if (teacherModel.TeacherId != null)
{
var teacher = _unitOfWork._teacherRepository.GetById((int)(int)teacherModel.TeacherId);
_unitOfWork._teacherRepository.Delete(teacher);
_unitOfWork.SaveChanges();
}
}
}
public void DeleteProduct(SHOP_PRODS shopProd)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
var product = _unitOfWork._bookingTimeRepository.DbContextTeachersAssistant.ShopProducts.SingleOrDefault(p => p.prodId == shopProd.prodId);
if (product != null)
{
_unitOfWork._bookingTimeRepository.DbContextTeachersAssistant.ShopProducts.Remove(product);
_unitOfWork.SaveChanges();
}
}
}
public void DeleteClassroom(Classroom classRoomModel)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
if (classRoomModel.ClassroomId != null)
{
var classroom = _unitOfWork._classroomRepository.GetById((int)classRoomModel.ClassroomId);
_unitOfWork._classroomRepository.Delete(classroom);
_unitOfWork.SaveChanges();
}
}
}
public void DeleteTeacherCalendarByBooking(CalendarBooking teacherCalendar)
{
using (var dbContext = new DataAccess.TeachersAssistant())
{
_unitOfWork.InitializeDbContext(dbContext);
if (teacherCalendar.CalendarBookingId != null)
{
var booking = _unitOfWork._calendarBookingRepository.GetById((int)teacherCalendar.CalendarBookingId);
_unitOfWork._calendarBookingRepository.Delete(booking);
_unitOfWork.SaveChanges();
}
}
}
