public static List<Appointment> ListAppointments(bool? active)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcListAppointments(active).ToList();
}
}
public static BasicWorkshopWaiting GetWorkshopWaiting(int workshopId, string studentId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcGetWorkshopWaiting(workshopId, studentId).FirstOrDefault();
}
}
public static List<Campus> ListCampuses(bool? active)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcListCampuses(active).ToList();
}
}
public static List<SessionType> ListSessionTypes(bool? active)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcListSessionTypes(active).ToList();
}
}
public static BasicSession GetSession(int sessionId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcGetSession(sessionId).FirstOrDefault();
}
}
public static BasicSessionBooking GetSessionBooking(int sessionId, string studentId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcGetSessionBooking(sessionId, studentId).FirstOrDefault();
}
}
public static void CancelWorkshopBooking(int workshopId, string studentId, int userId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
ctx.prcCancelWorkshopBooking(workshopId, studentId, userId);
}
}
public static List<Lecturer> ListLecturers(bool? active)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcListLecturers(active).ToList();
}
}
public static List<BasicWorkshopWaiting> GetWorkshopWaitingList(int workshopId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcGetWorkshopWaitingList(workshopId).ToList();
}
}
public static BasicWorkshopBooking GetWorkshopBooking(int workshopId, string studentId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcGetWorkshopBooking(workshopId, studentId).FirstOrDefault(x => x.archived == null);
}
}
public static Workshop GetWorkshopDetail(int workshopId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcGetWorkshopDetail(workshopId).FirstOrDefault();
}
}
public static int?[] GetProgramWorkshops(int programId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcGetProgramWorkshops(programId).ToArray();
}
}
public static void CreateWorkshopWaiting(int workshopId, string studentId, int? priority, int userId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
ctx.prcCreateWorkshopWaiting(workshopId, studentId, priority, userId);
}
}
public static Student GetStudent(string studentId)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcGetStudent(studentId).FirstOrDefault();
}
}
public static List<WorkShopSet> ListWorkShopSets(bool? active)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcListWorkShopSets(active).ToList();
}
}
public static List<SessionBooking> SearchSessionBookings(SessionBookingSearch bookingSearch)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcSearchSessionBookings(bookingSearch.StudentId, bookingSearch.StartingDtBegin, bookingSearch.StartingDtEnd,
bookingSearch.EndingDtBegin, bookingSearch.EndingDtEnd, bookingSearch.Campus,
bookingSearch.LecturerId, bookingSearch.SessionTypeId, bookingSearch.Active,
bookingSearch.Page, bookingSearch.PageSize).ToList();
}
}
public static void UpdateSessionBooking(UpdateSessionBooking update)
{
using (HELPSEntities ctx = new HELPSEntities())
{
ctx.prcUpdateSessionBooking(update.SessionId, update.StudentId, update.Cancel, update.Assistance,
update.Reason, update.Attended, update.WaitingId, update.IsGroup, update.NumPeople,
update.LecturerComment, update.LearningIssues, update.IsLocked, update.AssignType,
update.AssignTypeOther, update.Subject, update.Appointments, update.AppointmentsOther,
update.AssistanceText, update.UserId);
}
}
public static void RegisterStudent(StudentReg studentReg)
{
string gender = studentReg.Gender.HasValue ? studentReg.Gender.ToString() : null;
using (HELPSEntities ctx = new HELPSEntities())
{
ctx.prcCreateStudent(studentReg.StudentId, studentReg.DateOfBirth, gender, studentReg.Degree.ToString(),
studentReg.Status.ToString(), studentReg.FirstLanguage, studentReg.CountryOrigin,
studentReg.Background,
studentReg.HSC, studentReg.HSCMark, studentReg.IELTS, studentReg.IELTSMark,
studentReg.TOEFL, studentReg.TOEFLMark, studentReg.TAFE, studentReg.TAFEMark,
studentReg.CULT, studentReg.CULTMark, studentReg.InsearchDEEP, studentReg.InsearchDEEPMark,
studentReg.InsearchDiploma, studentReg.InsearchDiplomaMark, studentReg.FoundationCourse,
studentReg.FoundationCourseMark,
studentReg.CreatorId, studentReg.DegreeDetails, studentReg.AltContact, studentReg.PreferredName);
}
}
public static void UpdateWorkshopBooking(UpdateWorkshopBooking update)
{
using (HELPSEntities ctx = new HELPSEntities())
{
ctx.prcUpdateWorkshopBooking(update.WorkshopId, update.StudentId,
update.Canceled, update.Attended, update.UserId, update.Notes);
}
}
public static List<Workshop> SearchWorkshops(WorkshopSearch workshopSearch)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcSearchWorkshops(workshopSearch.WorkshopSetId, workshopSearch.Topic,
workshopSearch.StartingDtBegin, workshopSearch.StartingDtEnd, workshopSearch.EndingDtBegin,
workshopSearch.EndingDtEnd, workshopSearch.CampusId, workshopSearch.Active, workshopSearch.Page,
workshopSearch.PageSize).ToList();
}
}
public static List<WorkshopBooking> SearchWorkshopBookings(WorkshopBookingSearch bookingSearch)
{
using (HELPSEntities ctx = new HELPSEntities())
{
return ctx.prcSearchWorkshopBookings(bookingSearch.StudentId,
bookingSearch.StartingDtBegin, bookingSearch.StartingDtEnd,
bookingSearch.EndingDtBegin, bookingSearch.EndingDtEnd, bookingSearch.CampusId,
bookingSearch.Active, bookingSearch.Page, bookingSearch.PageSize).ToList();
}
}