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 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 object GenerateStaff(out Guid id, string surname, Guid?employeeId = null, string forename = null)
{
return(new
{
ID = id = Guid.NewGuid(),
LegalForename = forename,
LegalSurname = surname,
LegalMiddleNames = "Middle Names",
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
});
}
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 AddBasicLearner(this DataPackage dataPackage, Guid learnerId, string surname, string forename, DateTime dateOfBirth, DateTime dateOfAdmission, string genderCode = "1", string enrolStatus = "C", Guid?uniqueLearnerEnrolmentId = null, int?tenantId = null, string salutation = null, string addressee = null, Guid?yearGroupId = null, Guid?schoolNCYearId = null)
{
tenantId = tenantId ?? Environment.Settings.TenantId;
string sql = String.Format(
"UPDATE School SET LastAdmissionNumber='B05000' " +
"WHERE TenantID='" + tenantId + "' " +
"AND IsRegistered=1 " +
"AND (LastAdmissionNumber IS NULL " +
"OR CAST(SUBSTRING(LastAdmissionNumber,2,10) AS INT) < 5000)");
DataAccessHelpers.Execute(sql);
Guid learnerEnrolmentId;
var yearGroup = Queries.GetFirstYearGroup();
dataPackage.AddData("Learner", new
{
Id = learnerId,
School = CoreQueries.GetSchoolId(),
Gender = CoreQueries.GetLookupItem("Gender", code: genderCode),
LegalForename = forename,
LegalSurname = surname,
DateOfBirth = dateOfBirth,
TenantID = tenantId,
ParentalSalutation = salutation,
ParentalAddressee = addressee,
PolicyAclId = CoreQueries.GetPolicyAclId("Learner")
});
dataPackage.AddData("LearnerEnrolment", new
{
Id = learnerEnrolmentId = uniqueLearnerEnrolmentId ?? Guid.NewGuid(),
School = CoreQueries.GetSchoolId(),
Learner = learnerId,
DOA = dateOfAdmission,
TenantID = tenantId
});
dataPackage.AddData("LearnerEnrolmentStatus", new
{
Id = Guid.NewGuid(),
LearnerEnrolment = learnerEnrolmentId,
StartDate = dateOfAdmission,
EnrolmentStatus = CoreQueries.GetLookupItem("EnrolmentStatus", code: enrolStatus),
TenantID = tenantId
});
dataPackage.AddData("LearnerYearGroupMembership", new
{
Id = Guid.NewGuid(),
Learner = learnerId,
YearGroup = yearGroupId ?? yearGroup.ID,
StartDate = dateOfAdmission,
TenantID = tenantId
});
dataPackage.AddData("LearnerNCYearMembership", new
{
Id = Guid.NewGuid(),
Learner = learnerId,
SchoolNCYear = schoolNCYearId ?? yearGroup.SchoolNCYear,
StartDate = dateOfAdmission,
TenantID = tenantId
});
return(dataPackage);
}
public static DataPackage AddBasicLearner(
this DataPackage dataPackage,
Guid learnerId,
string surname,
string forename,
DateTime dateOfBirth,
DateTime dateOfAdmission,
string genderCode = "1",
string enrolStatus = "C",
Guid?uniqueLearnerEnrolmentId = null,
int?tenantId = null,
string salutation = null,
string addressee = null,
Guid?yearGroupId = null,
Guid?schoolNCYearId = null
)
{
tenantId = tenantId ?? SeSugar.Environment.Settings.TenantId;
Guid learnerEnrolmentId;
var yearGroup = Queries.GetFirstYearGroup();
dataPackage
.AddData("Learner", new
{
Id = learnerId,
School = CoreQueries.GetSchoolId(),
Gender = CoreQueries.GetLookupItem("Gender", code: genderCode),
LegalForename = forename,
LegalSurname = surname,
DateOfBirth = dateOfBirth,
TenantID = tenantId,
ParentalSalutation = salutation,
ParentalAddressee = addressee,
PolicyAclId = CoreQueries.GetPolicyAclId("Learner")
})
.AddData("LearnerEnrolment", new
{
Id = learnerEnrolmentId = uniqueLearnerEnrolmentId ?? Guid.NewGuid(),
School = CoreQueries.GetSchoolId(),
Learner = learnerId,
DOA = dateOfAdmission,
TenantID = tenantId
})
.AddData("LearnerEnrolmentStatus", new
{
Id = Guid.NewGuid(),
LearnerEnrolment = learnerEnrolmentId,
StartDate = dateOfAdmission,
EnrolmentStatus = CoreQueries.GetLookupItem("EnrolmentStatus", code: enrolStatus),
TenantID = tenantId
})
.AddData("LearnerYearGroupMembership", new
{
Id = Guid.NewGuid(),
Learner = learnerId,
YearGroup = yearGroupId ?? yearGroup.ID,
StartDate = dateOfAdmission,
TenantID = tenantId
})
.AddData("LearnerNCYearMembership", new
{
Id = Guid.NewGuid(),
Learner = learnerId,
SchoolNCYear = schoolNCYearId ?? yearGroup.SchoolNCYear,
StartDate = dateOfAdmission,
TenantID = tenantId
});
return(dataPackage);
}