private void UpDateGroupsListBox()
{
GroupList gr = new GroupList("");
GroupListBox.Items.Clear();
PupilPeriodList ppl = new PupilPeriodList();
string struser = Context.User.Identity.Name;
//struser = @"challoners\cc";
Utility u = new Utility();
string s = "";
//Guid personID = u.GetPersonID(struser,out s);
Guid personID = u.GetPersonIdfromRequest(Request);
s = u.GetsStaffCodefromRequest(Request);
if (personID != Guid.Empty)
{
struser = s;
}
//struser = "******";
Cerval_Configuration c = new Cerval_Configuration("StaffIntranet_Predicted_Grade_Type");
s = c.Value;
if (!c.valid)//try revert to config file
{
System.Configuration.AppSettingsReader ar = new System.Configuration.AppSettingsReader();
s = ar.GetValue("Predicted Grade Type", typeof(string)).ToString();
}
//if s =SL then do the lockdown mode for SL
//if s = staff then do sets for staff
//if s = ""... ignore...
if (s == "SL")
{
this.Label1.Text = "Select Set. Only Subject Leaders can now change values.";
//this code to list sets of a subject...
if ((struser.Trim() == "CC") || (struser.Trim() == "DCO"))
{
struser = ""; //allow all sets
}
GroupList_SL grsl = new GroupList_SL(struser);
foreach (Group g in grsl._groups)
{
if ((g._StartDate < DateTime.Now) && (g._EndDate > DateTime.Now) && (g._GroupCode.StartsWith("13")))
{
ListItem Item = new ListItem(g._GroupCode, g._GroupID.ToString());
GroupListBox.Items.Add(Item);
}
}
}
if (s == "STAFF")
{
this.Label1.Text = "Select Set ";
//this code lists sets the user is timetabled to teach....
ppl.LoadList("StaffCode", struser, false, DateTime.Now);
bool add = false;
foreach (Group g in gr._groups)
{
add = false;
if ((g._StartDate < DateTime.Now) && (g._EndDate > DateTime.Now))
{
foreach (ScheduledPeriod p in ppl.m_pupilTTlist)
{
if ((p.m_groupcode == g._GroupCode) && (g._GroupCode.StartsWith("13")))
{
add = true;
}
}
if (add)
{
ListItem Item = new ListItem(g._GroupCode, g._GroupID.ToString());
GroupListBox.Items.Add(Item);
}
}
}
}
GroupListBox.SelectedIndex = 0;
}
void GridView1_RowCommand(Object sender, GridViewCommandEventArgs e)
{
//calls here for any command - including a sort
if (e.CommandName == "Edit_Grade")
{
Cerval_Configuration c = new Cerval_Configuration("StaffIntranet_Forecast_Grade_Edit");
string s1 = c.Value;
if (!c.valid)//try revert to config file
{
System.Configuration.AppSettingsReader ar = new AppSettingsReader();
s1 = ar.GetValue("Exam Entries Forecast Grade Edit", s1.GetType()).ToString();
}
if (s1 == "none")
{
visibility(4);
{
ListBox_PredictedGrades.Visible = false;
Button_Save_Prediction.Visible = false;
Label_Title_for_Edit.Text = "Predicted grades can't be edited at present";
return;
}
}
int row = Convert.ToInt32(e.CommandArgument);
GridViewRow row1 = GridView1.Rows[row];
string s = Server.HtmlDecode(row1.Cells[0].Text);//is id
Exam_Entry ex1 = new Exam_Entry(); ex1.Load(s);
SimplePupil p1 = new SimplePupil(); p1.Load(ex1.m_StudentID.ToString());
ExamOption exo1 = new ExamOption(); exo1.Load(ex1.m_OptionID);
Utility u = new Utility();
bool valid = false;
PupilPeriodList PPLlist1 = new PupilPeriodList();
PPLlist1.LoadList("StudentID", ex1.m_StudentID.ToString(), true, DateTime.Now);
//now I'd like to find the cse... but we dont know these
CourseList cselist1 = new CourseList(ex1.m_OptionID);
GroupList_SL grplist1 = new GroupList_SL(Label_staffCode.Text.Trim());
foreach (Course c1 in cselist1._courses)
{
foreach (ScheduledPeriod scp in PPLlist1.m_pupilTTlist)
{
if (scp.m_groupcode.Substring(2, 2).ToUpper().Trim() == c1.CourseCode.ToUpper().Trim())
{
if (scp.m_staffcode.Trim().ToUpper() == Label_staffCode.Text.Trim().ToUpper())
{
if (s1 == "staff")
{
valid = true;
}
}
foreach (Group g1 in grplist1._groups)
{
if (g1._GroupCode == scp.m_groupcode)
{
valid = true; //is SL
}
}
}
}
}
if (s1 == "all")
{
valid = true;
}
visibility(4);
if (!valid)
{
ListBox_PredictedGrades.Visible = false;
Button_Save_Prediction.Visible = false;
Label_Title_for_Edit.Text = "Can't edit this grade as you don't teach the student";
return;
}
Label_Title_for_Edit.Text = "Predicted Grade for " + p1.m_GivenName + " " + p1.m_Surname + " for " + exo1.m_OptionCode + ": " + exo1.m_OptionTitle;
Label_EntryID_for_edit.Text = s;
ListBox_PredictedGrades.Items.Clear();
if (exo1.m_OptionQualification == "GCE")
{
ListBox_PredictedGrades.Items.Add("A*");
ListBox_PredictedGrades.Items.Add("A");
ListBox_PredictedGrades.Items.Add("B");
ListBox_PredictedGrades.Items.Add("C");
ListBox_PredictedGrades.Items.Add("D");
ListBox_PredictedGrades.Items.Add("E");
ListBox_PredictedGrades.Items.Add("U");
}
if (exo1.m_OptionQualification == "GCSE")
{
ListBox_PredictedGrades.Items.Add("A*");
ListBox_PredictedGrades.Items.Add("A");
ListBox_PredictedGrades.Items.Add("B");
ListBox_PredictedGrades.Items.Add("C");
ListBox_PredictedGrades.Items.Add("D");
ListBox_PredictedGrades.Items.Add("E");
ListBox_PredictedGrades.Items.Add("");
}
if (ListBox_PredictedGrades.Items.FindByText(Server.HtmlDecode(row1.Cells[7].Text)) != null)
{
ListBox_PredictedGrades.Items.FindByText(Server.HtmlDecode(row1.Cells[7].Text)).Selected = true;
Button_Save_Prediction.Visible = true;
}
else
{
//ListBox_PredictedGrades.Visible = false;
//Button_Save_Prediction.Visible = false;
//Label_Title_for_Edit.Text = "Can't edit this grade";
}
Button_Save_Prediction.Visible = true;
}
if (e.CommandName == "Edit_Button")
{
int row = Convert.ToInt32(e.CommandArgument);
GridViewRow row1 = GridView1.Rows[row];
string s = Server.HtmlDecode(row1.Cells[0].Text);//is id
Exam_Entry ex1 = new Exam_Entry(); ex1.Load(s);
ExamsEntries_sql.UpdateCommand = "UPDATE dbo.tbl_Exams_Entries SET PredictedGrade = '?' WHERE ExamEntryID ='" + s + "' ";
}
if (e.CommandName == "Delete_Button")
{
int row = Convert.ToInt32(e.CommandArgument);
GridViewRow row1 = GridView1.Rows[row];
string s = Server.HtmlDecode(row1.Cells[0].Text);
//do delete...
}
}
