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);
}
