protected void ButtonDeleteLeavers_Click(object sender, EventArgs e)
{
ISAMS_Set_List SL1 = new ISAMS_Set_List();
foreach (ISAMS_Set s1 in SL1.m_list)
{
if (s1.Year == 12)
{
string s = "";
s = s1.SetCode;
ISAMS_Student_List stu1 = new ISAMS_Student_List(s1.Id);
foreach (ISAMS_Student s2 in stu1.m_list)
{
s = s2.ISAMS_SchoolId + "," + s1.SetCode + "," + s2.Adno.ToString() + "," + s2.Surname + "," + s2.FirstName;
}
}
}
//process leavers
int n = 0;
StudentsOnRoleNotInRegGroup nr = new StudentsOnRoleNotInRegGroup();
foreach (SimplePupil p in nr._studentlist)
{
StudentLeavingDetails s1 = new StudentLeavingDetails();
s1.LeavingDate = new DateTime(2017, 9, 6);
s1.Adno = p.m_adno;
s1.valid = true;
s1.SaveOffRole();
n++;
}
n = n;
}
protected void Button_synClick(object sender, EventArgs e)
{
//sync iSAMSGroups
//first going to mark all current student_group memberships as version 10
//then will be able to end all those not found in iSAMS
//ResetAllStudentGroupVersion(10); //reset all current sgms to ver 10
DateTime EndDate = new DateTime();
EndDate = System.Convert.ToDateTime(TextBox_EndDate.Text);
int year = System.Convert.ToInt32(TextBox_Year.Text);
Utility u = new Utility();
string errors = ""; bool found = false;
ISAMS_Set_List Isetl1 = new ISAMS_Set_List();
foreach (ISAMS_Set Is in Isetl1.m_list)
{
//for each set...
if (Is.Year == year)
{
ISAMS_Student_List Isl1 = new ISAMS_Student_List(Is.Id);
StudentGroupMembershipList sgml1 = new StudentGroupMembershipList();
Group g1 = new Group();
g1.Load(Is.SetCode, DateTime.Now);
if (!g1._valid)
{
//ought to try to make the group
errors += "Group not found in Cerval" + Is.SetCode + Environment.NewLine;
}
else
{
sgml1.LoadList_Group(g1._GroupID, DateTime.Now);
foreach (ISAMS_Student iSS1 in Isl1.m_list)
{
found = false;
foreach (StudentGroupMembership sgm1 in sgml1.m_list)
{
string iSAMSPupilId = u.GetStudentIsamsID("StudentId", sgm1.m_Studentid.ToString());
if (iSAMSPupilId == "")
{
errors += "Student not found " + sgm1.m_Studentid.ToString() + Environment.NewLine;
}
if (iSS1.ISAMS_SchoolId == iSAMSPupilId)
{
found = true;
sgm1.ResetVersion(3);// it is OK
break;
}
}
if (!found)
{
//need to add to sgml
StudentGroupMembership sgm2 = new StudentGroupMembership();
//need to find ID for this student for the iSAMSId
Guid g2 = u.GetStudentIDfromiSAMS(iSS1.ISAMS_SchoolId);
if (g2 == Guid.Empty)
{
errors += " Student not found in Cerval for iSAMSID " + iSS1.ISAMS_SchoolId + Environment.NewLine;
}
else
{
sgm2.m_ValidFrom = DateTime.Now.AddHours(-10);
sgm2.m_ValidTo = EndDate;
sgm2.m_Studentid = g2;
sgm2.m_Groupid = g1._GroupID;
//version=4
sgm2.Save();
}
}
errors += "Cmpleted set " + Is.SetCode + " at " + DateTime.Now.ToLongTimeString() + Environment.NewLine;
}
//so that iSAMS set is done....
}
errors += "Cmpleted set " + Is.SetCode + " at " + DateTime.Now.ToLongTimeString() + Environment.NewLine;
}
}
//done iSAMS sets...
// so those at version 10 need closing down......
TextBox_Out.Text = errors;
Encode en = new Encode();
string d = " CONVERT(DATETIME, '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', 102) ";
string s = " UPDATE dbo.tbl_Core_Student_Groups SET MemberUntil = " + d + " WHERE Version ='10' ";
//en.ExecuteSQL(s);
}