public static DataPackage AddExceptionalCircumstance(this DataPackage datapackage, Guid id, Guid learnerid, string forename, string surname, Guid exceptionId, string description, string startdate, string enddate, string code) { var ExceptionalCircumstanceTypeid = Queries.GetExceptionalCircumstanceTypeID(code); var startsessionid = Queries.GetStartSessionid(); var endsessionid = Queries.GetEndSessionid(); var schoolattendancecodeid = Queries.GetSchoolAttendanceCode(); datapackage.AddData("exceptionalcircumstance", new { ID = exceptionId, School = CoreQueries.GetSchoolId(), TenantID = tenantId, Description = description, StartDate = startdate, EndDate = enddate, ExceptionalCircumstanceType = ExceptionalCircumstanceTypeid, StartSession = startsessionid, EndSession = endsessionid, SchoolAttendanceCode = schoolattendancecodeid, }); datapackage.AddData("learnerexceptionalcircumstance", new { ID = id = Guid.NewGuid(), TenantID = tenantId, ExceptionalCircumstance = exceptionId, Learner = learnerid, }); return(datapackage); }
public static DataPackage GetStaffRecord(this DataPackage dataPackage, Guid staffId, string forename, string surname) { //return this.BuildDataPackage() dataPackage.AddData("Staff", new { Id = staffId, LegalForename = forename, LegalSurname = surname, LegalMiddleNames = "Middle", PreferredForename = forename, PreferredSurname = surname, DateOfBirth = new DateTime(2000, 1, 1), Gender = CoreQueries.GetLookupItem("Gender", description: "Female"), PolicyACLID = CoreQueries.GetPolicyAclId("Staff"), School = CoreQueries.GetSchoolId(), TenantID = tenantId }) .AddData("StaffServiceRecord", new { Id = Guid.NewGuid(), DOA = DateTime.Today.AddDays(-1), ContinuousServiceStartDate = DateTime.Today.AddDays(-1), LocalAuthorityStartDate = DateTime.Today.AddDays(-1), Staff = staffId, TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddPupilContact(this DataPackage dataPackage, Guid pupilContactId, string surname, string forename, string salutation = null, string addressee = null, string jobTitle = null, string titleCode = "Mr", string genderCode = "1", string occupation = "ACC", int?tenantId = null ) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData(Constants.Tables.LearnerContact, new { ID = pupilContactId, Surname = surname, Forename = forename, School = CoreQueries.GetSchoolId(), Gender = CoreQueries.GetLookupItem(Constants.Tables.Gender, code: genderCode), Title = CoreQueries.GetLookupItem(Constants.Tables.Title, code: titleCode), Salutation = salutation, JobTitle = jobTitle, Addressee = addressee, Occupation = CoreQueries.GetLookupItem(Constants.Tables.Occupation, code: occupation), TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddBasicLearnerContactAddress(this DataPackage dataPackage, Guid learnerId, Guid learnerContactId, Guid addressId, Guid learnerContactAddressId, Guid learnerAddressId, DateTime startDate, int?tenantId = null, string postCode = null, string addressType = "H") { tenantId = tenantId ?? SeSugar.Environment.Settings.TenantId; dataPackage.AddData(Constants.Tables.Address, new { ID = addressId, TenantID = tenantId, }) .AddData(Constants.Tables.LearnerAddress, new { ID = learnerAddressId, StartDate = startDate, Learner = learnerId, Address = addressId, AddressType = CoreQueries.GetLookupItem(Constants.Tables.AddressType, code: addressType), TenantID = tenantId }) .AddData(Constants.Tables.LearnerContactAddress, new { ID = learnerContactAddressId, StartDate = startDate, LearnerContact = learnerContactId, Address = addressId, AddressType = CoreQueries.GetLookupItem(Constants.Tables.AddressType, code: addressType), TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddUDFDefinition( this DataPackage dataPackage, Guid udfDomainDefinitionID, Guid udfFieldTypeID, string description, Guid?id = null, bool isVisible = true, bool useResourceProvider = true, int?tenantId = null ) { tenantId = tenantId ?? SeSugar.Environment.Settings.TenantId; dataPackage .AddData("app.UDFDefinition", new { Id = id ?? Guid.NewGuid(), Description = string.Format(Prefix, description), DisplayOrder = 20, IsVisible = isVisible, TenantId = tenantId, UDFDomainDefinition = udfDomainDefinitionID, UDFFieldType = udfFieldTypeID, ResourceProvider = useResourceProvider ? TestSettings.TestDefaults.Default.SchoolID : null }); return(dataPackage); }
public static DataPackage AddPupilContactRelationship(this DataPackage dataPackage, Guid pupilContactRelationshipId, Guid learnerId, Guid pupilContactId, string relationshipType = "PAR", int priority = 1, bool hasParentalResponsibility = false, bool receivesCorrespondance = false, bool hasSchoolReport = false, bool hasCourtOrder = false, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData(Constants.Tables.LearnerContactRelationship, new { ID = pupilContactRelationshipId, Priority = priority, Learner = learnerId, LearnerContact = pupilContactId, LearnerContactRelationshipType = CoreQueries.GetLookupItem(Constants.Tables.LearnerContactRelationshipType, relationshipType), HasParentalResponsibility = hasParentalResponsibility, ReceivesCorrespondance = receivesCorrespondance, HasCourtOrder = hasCourtOrder, ReceivesSchoolReport = hasSchoolReport, TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddUDFEntity( this DataPackage dataPackage, Guid?id = null, string code = null, string description = null, string entity = null, int?tenantId = null ) { tenantId = tenantId ?? SeSugar.Environment.Settings.TenantId; dataPackage .AddData("app.UDFEntity", new { Id = id ?? Guid.NewGuid(), Code = string.Format(Prefix, code ?? "Entity:Code"), Description = string.Format(Prefix, description ?? "Entity:Desc"), Entity = string.Format(Prefix, entity ?? "Entity:Ent"), //Schema = string.Format(Prefix, "Schema"), DisplayOrder = 20, IsVisible = 1, TenantId = tenantId }); return(dataPackage); }
public static DataPackage AddUDFDomainDefinition( this DataPackage dataPackage, Guid entityID, Guid?id = null, string code = null, string description = null, string informationDomain = null, string securityDomain = null, int?tenantId = null ) { tenantId = tenantId ?? SeSugar.Environment.Settings.TenantId; dataPackage .AddData("app.UDFDomainDefinition", new { Id = id ?? Guid.NewGuid(), Code = string.Format(Prefix, code ?? "DD:Code"), Description = string.Format(Prefix, description ?? "DD:Desc"), InformationDomain = string.Format(Prefix, informationDomain ?? "DD:InfoDomain"), SecurityDomain = string.Format(Prefix, securityDomain ?? "DD:SecurityDomain"), UDFEntity = entityID, DisplayOrder = 20, IsVisible = 1, TenantId = tenantId }); return(dataPackage); }
public static DataPackage AddBasicApplicant(this DataPackage dataPackage, Guid applicationId, Guid learnerId, Guid learnerEnrolmentId, Guid admissionGroupId, DateTime dateOfApplication, string applicationStatus = "Applied", string proposedEnrolStatus = "C", int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; Guid applicationStatusId; Guid applicationStatusLogId = Guid.NewGuid(); dataPackage.AddData(Constants.Tables.Application, new { ID = applicationId, Learner = learnerId, LearnerEnrolment = learnerEnrolmentId, CurrentApplicationStatus = applicationStatusId = CoreQueries.GetLookupItem(Constants.Tables.ApplicationStatus, code: applicationStatus), ProposedEnrolmentStatus = CoreQueries.GetLookupItem(Constants.Tables.EnrolmentStatus, code: proposedEnrolStatus), DateOfApplication = dateOfApplication, AdmissionGroup = admissionGroupId, TenantID = tenantId }) .AddData(Constants.Tables.ApplicationStatusLog, new { ID = applicationStatusLogId, Application = applicationId, TenantID = tenantId, ApplicationStatus = applicationStatusId }); return(dataPackage); }
public static DataPackage AddSuspensionWithMeeting(this DataPackage dataPackage, Guid learnerId, Guid suspensionId, DateTime startDate, DateTime endDate, int days, Guid exclusionType, Guid exclusionReason, string tenantId = null) { tenantId = tenantId ?? TestDefaults.Default.TenantId.ToString(); dataPackage.AddData("LearnerExclusion", new { Id = suspensionId, Learner = learnerId, StartTime = "09:00", EndTime = "16:00", StartDate = startDate, EndDate = endDate, ExclusionType = exclusionType, ExclusionReason = exclusionReason, NumberOfSchoolDays = days, SessionsMissed = days, TenantID = tenantId }) .AddData("ExclusionMeeting", new { Id = Guid.NewGuid(), LearnerExclusion = suspensionId, StartDate = startDate, EndDate = endDate, StartTime = "09:00", EndTime = "16:00", ExclusionMeetingType = CoreQueries.GetLookupItem("ExclusionMeetingType", description: "Discipline Committee"), TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddBasicStaff(this DataPackage dataPackage, Guid staffId, string forename, string surname) { return(dataPackage .AddData("Staff", new { Id = staffId, LegalForename = forename, LegalSurname = surname, LegalMiddleNames = "Middle", PreferredForename = forename, PreferredSurname = surname, DateOfBirth = new DateTime(2000, 1, 1), Gender = CoreQueries.GetLookupItem("Gender", description: "Male"), PolicyACLID = CoreQueries.GetPolicyAclId("Staff"), School = CoreQueries.GetSchoolId(), TenantID = SeSugar.Environment.Settings.TenantId, Title = CoreQueries.GetLookupItem("Title", description: "Mr"), }) .AddData("StaffServiceRecord", new { Id = Guid.NewGuid(), DOA = DateTime.Today.AddDays(-1), ContinuousServiceStartDate = DateTime.Today.AddDays(-1), LocalAuthorityStartDate = DateTime.Today.AddDays(-1), Staff = staffId, TenantID = SeSugar.Environment.Settings.TenantId })); }
public static DataPackage AddLeaver(this DataPackage dataPackage, Guid learnerId, string surname, string forename, DateTime dateOfBirth, DateTime dateOfAdmission, DateTime dateOfLeaving, string genderCode = "1", string enrolStatus = "C", string reasonForLeaving = "OT", string tenantId = null) { Guid learnerEnrolmentId; var yearGroup = Queries.GetFirstYearGroup(); tenantId = tenantId ?? TestDefaults.Default.TenantId.ToString(); dataPackage.AddData("Learner", new { Id = learnerId, School = CoreQueries.GetSchoolId(), Gender = CoreQueries.GetLookupItem("Gender", code: genderCode), LegalForename = forename, LegalSurname = surname, DateOfBirth = dateOfBirth, PolicyAclId = CoreQueries.GetPolicyAclId("Learner"), TenantID = tenantId }) .AddData("LearnerEnrolment", new { Id = learnerEnrolmentId = Guid.NewGuid(), School = CoreQueries.GetSchoolId(), Learner = learnerId, DOA = dateOfAdmission, DOL = dateOfLeaving, ReasonForLeaving = CoreQueries.GetLookupItem("ReasonForLeaving", code: reasonForLeaving), TenantID = tenantId }) .AddData("LearnerEnrolmentStatus", new { Id = Guid.NewGuid(), LearnerEnrolment = learnerEnrolmentId, StartDate = dateOfAdmission, EndDate = dateOfLeaving, EnrolmentStatus = CoreQueries.GetLookupItem("EnrolmentStatus", code: enrolStatus), TenantID = tenantId }) .AddData("LearnerYearGroupMembership", new { Id = Guid.NewGuid(), Learner = learnerId, YearGroup = yearGroup.ID, StartDate = dateOfAdmission, EndDate = dateOfLeaving, TenantID = tenantId }) .AddData("LearnerNCYearMembership", new { Id = Guid.NewGuid(), Learner = learnerId, SchoolNCYear = yearGroup.SchoolNCYear, StartDate = dateOfAdmission, EndDate = dateOfLeaving, TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddEmployee(this DataPackage dataPackage, Guid employeeId, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData(Constants.Tables.Employee, new { ID = employeeId, TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddReportCardTarget(this DataPackage dataPackage, Guid reportCardId, int?tenantId = null) { tenantId = tenantId ?? SeSugar.Environment.Settings.TenantId; dataPackage.AddData("ConductReportCardTarget", new { Id = Guid.NewGuid(), TenantID = tenantId, ReportCard = reportCardId, }); return(dataPackage); }
public static DataPackage AddPupilDateOfLeaving(this DataPackage datapackage, Guid learnerEnrolmentId, Guid learnerId, string leavingdate) { datapackage.AddData("LearnerEnrolment", new { ID = learnerEnrolmentId, Learner = learnerId, School = CoreQueries.GetSchoolId(), TenantID = tenantId, DOL = leavingdate, }); return(datapackage); }
public static DataPackage AddSENSStagetoLearner(this DataPackage dataPackage, Guid learnerId, string senStage = "1", int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData("LearnerSENStatus", new { Id = Guid.NewGuid(), StartDate = new DateTime(2015, 05, 05), Learner = learnerId, SENStatus = CoreQueries.GetLookupItem("SENStatus", code: senStage), TenantID = tenantId }); return(dataPackage); }
public static DataPackage GenerateClass(this DataPackage datapackage, Guid classid, string classname, string shortname) { datapackage.AddData("PrimaryClass", new { ID = classid = Guid.NewGuid(), FullName = classname, ShortName = shortname, Active = "1", School = CoreQueries.GetSchoolId(), TenantID = SeSugar.Environment.Settings.TenantId, }); return(datapackage); }
public static DataPackage AddLearnerAttendanceMode(this DataPackage dataPackage, Guid learnerId, DateTime startDate) { int tenantId = Environment.Settings.TenantId; var attendanceMode = Queries.GetFirstAttendanceMode(); dataPackage.AddData("LearnerAttendanceMode", new { Learner = learnerId, TenantID = tenantId, StartDate = startDate, AttendanceMode = attendanceMode.Id }); return(dataPackage); }
public static DataPackage AddClasses(this DataPackage dataPackage, Guid classId, string shortName, string fullName, int displayOrder, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData(Constants.Tables.PrimaryClass, new { ID = classId, TenantID = tenantId, ShortName = shortName, FullName = fullName, School = CoreQueries.GetSchoolId(), DisplayOrder = displayOrder }); return(dataPackage); }
public static DataPackage AddPupilPremiumEligibitity(this DataPackage dataPackage, Guid learnerId) { int tenantId = Environment.Settings.TenantId; dataPackage.AddData("LearnerPupilPremiumEligibility", new { Id = Guid.NewGuid(), Learner = learnerId, StartDate = DateTime.Now.Add(TimeSpan.FromDays(60)), TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddServiceRecord(this DataPackage dataPackage, Guid serviceRecordId, Guid staffId, DateTime staffStartDate, DateTime?dol = null, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData(Constants.Tables.StaffServiceRecord, new { ID = serviceRecordId, DOA = staffStartDate, DOL = dol, ContinuousServiceStartDate = staffStartDate, LocalAuthorityStartDate = staffStartDate, Staff = staffId, TenantID = tenantId }); return(dataPackage); }
public static DataPackage GenerateEarlyYearProvision(this DataPackage datapackage, Guid provisionId, string provisionname, string provisionshortname, string startdate, string starttime, string endtime) { datapackage.AddData("EarlyYearsSessionType", new { ID = provisionId, School = CoreQueries.GetSchoolId(), TenantID = tenantId, ProvisionName = provisionname, ShortName = provisionshortname, StartDate = startdate, //EndDate = enddate, StartTime = starttime, EndTime = endtime, }); return(datapackage); }
public static DataPackage AddReportCard(this DataPackage dataPackage, Guid learnerId, string reportName, DateTime startDate, DateTime endDate, string reason = null, string comments = null, int?tenantId = null, Guid?reportCardId = null) { tenantId = tenantId ?? SeSugar.Environment.Settings.TenantId; dataPackage.AddData("ConductReportCard", new { Id = reportCardId ?? Guid.NewGuid(), Name = reportName, StartDate = startDate, EndDate = endDate, Reason = reason ?? "Test Reason for Report Card Creation", comments = comments ?? "Test Comment for Report Card Events", Learner = learnerId, TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddStandardPupilLogNote(this DataPackage dataPackage, Guid learnerId, string title, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData("PupilLogNoteStandard", new { Id = Guid.NewGuid(), Learner = learnerId, PupilLogNoteCategory = CoreQueries.GetLookupItem("PupilLogNoteCategory", code: "GENNA"), Title = title, NoteText = Utilities.GenerateRandomString(20, "Selenium"), Pinned = false, CreatedOn = new DateTime(2015, 01, 10), TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddSchoolNCYearLookup(this DataPackage dataPackage, Guid schoolNCYearId, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; string sql = string.Format("SELECT TOP 1 ID FROM dbo.NCYear where TenantID ='{0}'", tenantId); Guid nCYearID = DataAccessHelpers.GetValue <Guid>(sql); dataPackage.AddData(Constants.Tables.SchoolNCYear, new { ID = schoolNCYearId, TenantID = tenantId, School = CoreQueries.GetSchoolId(), NCYear = nCYearID }); return(dataPackage); }
public static DataPackage AddPupilPremiumGrant(this DataPackage dataPackage, Guid learnerId) { int tenantId = Environment.Settings.TenantId; dataPackage.AddData("LearnerPupilPremiumGrant", new { Id = Guid.NewGuid(), Learner = learnerId, StartDate = DateTime.Now.Add(TimeSpan.FromDays(60)), TenantID = tenantId, Amount = 1235.00, ServicePupil = 1, EarlyYears = 1 }); return(dataPackage); }
public static DataPackage AddBasicSuspension(this DataPackage dataPackage, Guid learnerId, DateTime startDate, DateTime endDate, int days, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData("LearnerExclusion", new { Id = Guid.NewGuid(), Learner = learnerId, StartTime = "09:00", EndTime = "16:00", StartDate = startDate, EndDate = endDate, ExclusionType = (Queries.GetFirstExclusionType()).ID, ExclusionReason = (Queries.GetFirstExclusionReason()).ID, NumberOfSchoolDays = days, TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddCalendar(this DataPackage dataPackage, Guid calendarId, string calendarName, string calendarDescription, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; string sql = string.Format("SELECT TOP 1 ID FROM dbo.CalendarGroup where TenantID ='{0}'", tenantId); Guid calendarGroupId = DataAccessHelpers.GetValue <Guid>(sql); dataPackage.AddData(Constants.Tables.Calendar, new { ID = calendarId, TenantID = tenantId, Name = calendarName, Description = calendarDescription, IsVisible = true, CalendarGroup = calendarGroupId }); return(dataPackage); }
public static DataPackage AddStaff(this DataPackage dataPackage, Guid staffId, Guid employeeId, string surname, string forename, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData(Constants.Tables.Staff, new { ID = staffId, LegalForename = forename, LegalSurname = surname, PreferredForename = forename, PreferredSurname = surname, DateOfBirth = new DateTime(2000, 1, 1), Gender = CoreQueries.GetLookupItem("Gender", description: "Male"), PolicyACLID = CoreQueries.GetPolicyAclId("Staff"), Employee = employeeId, School = CoreQueries.GetSchoolId(), TenantID = tenantId }); return(dataPackage); }
public static DataPackage AddYearGroupLookup(this DataPackage dataPackage, Guid yearGroupId, Guid schoolNCYearId, string shortName, string fullName, int displayOrder, int?tenantId = null) { tenantId = tenantId ?? Environment.Settings.TenantId; dataPackage.AddData(Constants.Tables.YearGroup, new { ID = yearGroupId, TenantID = tenantId, ShortName = shortName, FullName = fullName, School = CoreQueries.GetSchoolId(), SchoolNCYear = schoolNCYearId }) .Add(Constants.Tables.YearGroupSetMembership, new { ID = Guid.NewGuid(), YearGroup = yearGroupId, TenantID = tenantId, StartDate = new DateTime(2015, 01, 01) }); return(dataPackage); }