private void FillGrid()
{
table = ReqStudents.RefreshOneStudent(ProvNum);
gridMain.BeginUpdate();
gridMain.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableReqStudentOne", "Course"), 100);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableReqStudentOne", "Requirement"), 200);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableReqStudentOne", "Done"), 40);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableReqStudentOne", "Patient"), 140);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableReqStudentOne", "Appointment"), 190);
gridMain.Columns.Add(col);
gridMain.Rows.Clear();
ODGridRow row;
for (int i = 0; i < table.Rows.Count; i++)
{
row = new ODGridRow();
row.Cells.Add(table.Rows[i]["course"].ToString());
row.Cells.Add(table.Rows[i]["requirement"].ToString());
row.Cells.Add(table.Rows[i]["done"].ToString());
row.Cells.Add(table.Rows[i]["patient"].ToString());
row.Cells.Add(table.Rows[i]["appointment"].ToString());
gridMain.Rows.Add(row);
}
gridMain.EndUpdate();
}
private void FillGrid()
{
if (comboClass.SelectedIndex == -1 || comboCourse.SelectedIndex == -1)
{
return;
}
long schoolClass = _listSchoolClasses[comboClass.SelectedIndex].SchoolClassNum;
long schoolCourse = _listSchoolCourses[comboCourse.SelectedIndex].SchoolCourseNum;
table = ReqStudents.RefreshManyStudents(schoolClass, schoolCourse);
gridMain.BeginUpdate();
gridMain.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableReqStudentMany", "Last"), 100);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableReqStudentMany", "First"), 100);
gridMain.Columns.Add(col);
//col=new ODGridColumn(Lan.g("TableReqStudentMany","Total"),50);
//gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableReqStudentMany", "Done"), 50);
gridMain.Columns.Add(col);
gridMain.Rows.Clear();
ODGridRow row;
for (int i = 0; i < table.Rows.Count; i++)
{
row = new ODGridRow();
row.Cells.Add(table.Rows[i]["LName"].ToString());
row.Cells.Add(table.Rows[i]["FName"].ToString());
//row.Cells.Add(table.Rows[i]["totalreq"].ToString());
row.Cells.Add(table.Rows[i]["donereq"].ToString());
gridMain.Rows.Add(row);
}
gridMain.EndUpdate();
}
private void FillStudents()
{
if (comboClass.SelectedIndex == -1)
{
return;
}
long schoolClass = _listSchoolClasses[comboClass.SelectedIndex].SchoolClassNum;
//int schoolCourse=SchoolCourses.List[comboCourse.SelectedIndex].SchoolCourseNum;
StudentList = ReqStudents.GetStudents(schoolClass);
gridStudents.BeginUpdate();
gridStudents.ListGridColumns.Clear();
GridColumn col = new GridColumn("", 100);
gridStudents.ListGridColumns.Add(col);
gridStudents.ListGridRows.Clear();
GridRow row;
for (int i = 0; i < StudentList.Count; i++)
{
row = new GridRow();
row.Cells.Add(StudentList[i].LName + ", " + StudentList[i].FName);
gridStudents.ListGridRows.Add(row);
}
gridStudents.EndUpdate();
}
private void butDelete_Click(object sender, System.EventArgs e)
{
if (IsNew)
{
DialogResult = DialogResult.Cancel;
}
else
{
string inuseby = ReqStudents.InUseBy(ReqCur.ReqNeededNum);
if (inuseby != "")
{
MsgBoxCopyPaste msgBox = new MsgBoxCopyPaste(Lan.g(this, "Requirement is already in use by student(s) with grade point(s) attached."
+ "\r\n" + Lan.g(this, "Delete anyway? Student grades will not be affected."))
+ "\r\n" + inuseby);
msgBox.ShowDialog();
if (msgBox.DialogResult != DialogResult.OK)
{
return;
}
}
if (!MsgBox.Show(this, true, "Delete this Requirement?"))
{
return;
}
}
ReqCur = null;
DialogResult = DialogResult.OK;
}
private void FillReqs()
{
int schoolCourse = 0;
if (comboCourse.SelectedIndex != -1)
{
schoolCourse = SchoolCourses.List[comboCourse.SelectedIndex].SchoolCourseNum;
}
gridReqs.BeginUpdate();
gridReqs.Columns.Clear();
ODGridColumn col = new ODGridColumn("", 100);
gridReqs.Columns.Add(col);
gridReqs.Rows.Clear();
if (gridStudents.GetSelectedIndex() == -1)
{
gridReqs.EndUpdate();
return;
}
ReqTable = ReqStudents.GetForStudent(StudentList[gridStudents.GetSelectedIndex()].ProvNum, schoolCourse);
ODGridRow row;
for (int i = 0; i < ReqTable.Rows.Count; i++)
{
row = new ODGridRow();
row.Cells.Add(ReqTable.Rows[i]["Descript"].ToString());
gridReqs.Rows.Add(row);
}
gridReqs.EndUpdate();
}
private void butDelete_Click(object sender, System.EventArgs e)
{
if (IsNew)
{
DialogResult = DialogResult.Cancel;
}
else
{
string inuseby = ReqStudents.InUseBy(ReqCur.ReqNeededNum);
if (inuseby != "")
{
if (MessageBox.Show(Lan.g(this, "Requirement is already in use by student(s) with grade point(s) attached:")
+ "\r\n" + inuseby + Lan.g(this, "Delete anyway? Student grades will not be affected."), "", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
}
if (!MsgBox.Show(this, true, "Delete this Requirement?"))
{
return;
}
try{
ReqNeededs.Delete(ReqCur.ReqNeededNum);
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
return;
}
}
DialogResult = DialogResult.OK;
}
private void butOK_Click(object sender, EventArgs e)
{
List <int> reqNums = new List <int>();
for (int i = 0; i < TableAttached.Rows.Count; i++)
{
reqNums.Add(PIn.PInt(TableAttached.Rows[i]["ReqStudentNum"].ToString()));
}
ReqStudents.SynchApt(AptNum, reqNums);
DialogResult = DialogResult.OK;
}
private void butDelete_Click(object sender, System.EventArgs e)
{
//if(!MsgBox.Show(this,true,"Delete this student requirement? This is typically handled by using the synch feature from requirements needed.")){
// return;
//}
try{
ReqStudents.Delete(ReqCur.ReqStudentNum); //disallows deleting req that exists in reqNeeded.
DialogResult = DialogResult.OK;
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void gridAttached_CellDoubleClick(object sender, ODGridClickEventArgs e)
{
if (hasChanged)
{
MsgBox.Show(this, "Not allowed to edit individual requirements immediately after adding or removing.");
return;
}
FormReqStudentEdit FormRSE = new FormReqStudentEdit();
FormRSE.ReqCur = reqsAttached[e.Row];
FormRSE.ShowDialog();
if (FormRSE.DialogResult != DialogResult.OK)
{
return;
}
reqsAttached = ReqStudents.GetForAppt(AptNum);
FillAttached();
}
private void butOK_Click(object sender, System.EventArgs e)
{
if (textDateCompleted.Text != "")
{
try{
DateTime.Parse(textDateCompleted.Text);
}
catch {
MsgBox.Show(this, "Date is invalid.");
return;
}
}
//ReqNeededNum-not editable
//Descript-not editable
//SchoolCourseNum-not editable
//ProvNum-Student not editable
//AptNum-handled earlier
//PatNum-handled earlier
//InstructorNum
if (comboInstructor.SelectedIndex == 0)
{
ReqCur.InstructorNum = 0;
}
else
{
ReqCur.InstructorNum = ProviderC.ListShort[comboInstructor.SelectedIndex - 1].ProvNum;
}
//DateCompleted
ReqCur.DateCompleted = PIn.Date(textDateCompleted.Text);
try{
//if(IsNew){//inserting is always done as part of reqneededs.synch
// LabCases.Insert(CaseCur);
//}
//else{
ReqStudents.Update(ReqCur);
//}
}
catch (ApplicationException ex) {
MessageBox.Show(ex.Message);
return;
}
DialogResult = DialogResult.OK;
}
private void FormReqAppt_Load(object sender, EventArgs e)
{
_listSchoolClasses = SchoolClasses.GetDeepCopy();
_listSchoolCourses = SchoolCourses.GetDeepCopy();
for (int i = 0; i < _listSchoolClasses.Count; i++)
{
comboClass.Items.Add(SchoolClasses.GetDescript(_listSchoolClasses[i]));
}
if (comboClass.Items.Count > 0)
{
comboClass.SelectedIndex = 0;
}
for (int i = 0; i < _listSchoolCourses.Count; i++)
{
comboCourse.Items.Add(SchoolCourses.GetDescript(_listSchoolCourses[i]));
}
if (comboCourse.Items.Count > 0)
{
comboCourse.SelectedIndex = 0;
}
comboInstructor.Items.Add(Lan.g(this, "None"));
comboInstructor.SelectedIndex = 0;
_listProviders = Providers.GetDeepCopy(true);
for (int i = 0; i < _listProviders.Count; i++)
{
comboInstructor.Items.Add(_listProviders[i].GetLongDesc());
//if(ProviderC.List[i].ProvNum==ReqCur.InstructorNum) {
// comboInstructor.SelectedIndex=i+1;
//}
}
FillStudents();
FillReqs();
reqsAttached = ReqStudents.GetForAppt(AptNum);
if (reqsAttached.Count > 0)
{
comboInstructor.SelectedIndex = Providers.GetIndex(reqsAttached[0].ProvNum) + 1; //this will turn a -1 into a 0.
}
FillAttached();
}
///<summary></summary>
public static void Synch(int schoolClassNum, int schoolCourseNum)
{
//get list of all reqneededs for the given class and course.
DataTable table = Refresh(schoolClassNum, schoolCourseNum);
string command;
int reqNeededNum;
DataTable tStudent;
string descript;
ReqStudent req;
//1. Delete any reqstudents that do not have gradepoint
command = "DELETE FROM reqstudent "
+ "WHERE NOT EXISTS(SELECT * FROM reqneeded WHERE reqstudent.ReqNeededNum=reqneeded.ReqNeededNum) "
+ "AND reqstudent.DateCompleted < " + POut.PDate(new DateTime(1880, 1, 1));
General.NonQ(command);
for (int i = 0; i < table.Rows.Count; i++)
{
reqNeededNum = PIn.PInt(table.Rows[i]["ReqNeededNum"].ToString());
descript = PIn.PString(table.Rows[i]["Descript"].ToString());
//2. Update. Update the description for all students using this requirement.
command = "UPDATE reqstudent SET Descript='" + POut.PString(descript) + "' "
+ "WHERE ReqNeededNum=" + POut.PInt(reqNeededNum);
General.NonQ(command);
//3. Insert. Get list of students that do not have this req. For each student, insert.
command = "SELECT ProvNum FROM provider WHERE SchoolClassNum=" + POut.PInt(schoolClassNum)
+ " AND NOT EXISTS(SELECT * FROM reqstudent WHERE reqstudent.ProvNum=provider.ProvNum"
+ " AND ReqNeededNum=" + POut.PInt(reqNeededNum) + ")";
tStudent = General.GetTable(command);
for (int s = 0; s < tStudent.Rows.Count; s++)
{
req = new ReqStudent();
req.Descript = descript;
req.ProvNum = PIn.PInt(tStudent.Rows[s]["ProvNum"].ToString());
req.ReqNeededNum = reqNeededNum;
req.SchoolCourseNum = PIn.PInt(table.Rows[i]["SchoolCourseNum"].ToString());
ReqStudents.Insert(req);
}
}
}
private void gridMain_CellDoubleClick(object sender, ODGridClickEventArgs e)
{
//if(IsSelectionMode){
// if(table.Rows[e.Row]["appointment"].ToString()!=""){
// MsgBox.Show(this,"Already attached to an appointment.");
// return;
// }
// SelectedReqStudentNum=PIn.PInt(table.Rows[e.Row]["ReqStudentNum"].ToString());
// DialogResult=DialogResult.OK;
//}
//else{
FormReqStudentEdit FormRSE = new FormReqStudentEdit();
FormRSE.ReqCur = ReqStudents.GetOne(PIn.Long(table.Rows[e.Row]["ReqStudentNum"].ToString()));
FormRSE.ShowDialog();
if (FormRSE.DialogResult != DialogResult.OK)
{
return;
}
FillGrid();
//}
}
private void FormReqAppt_Load(object sender, EventArgs e)
{
for (int i = 0; i < SchoolClasses.List.Length; i++)
{
comboClass.Items.Add(SchoolClasses.GetDescript(SchoolClasses.List[i]));
}
if (comboClass.Items.Count > 0)
{
comboClass.SelectedIndex = 0;
}
for (int i = 0; i < SchoolCourses.List.Length; i++)
{
comboCourse.Items.Add(SchoolCourses.GetDescript(SchoolCourses.List[i]));
}
if (comboCourse.Items.Count > 0)
{
comboCourse.SelectedIndex = 0;
}
FillStudents();
FillReqs();
TableAttached = ReqStudents.GetForAppt(AptNum);
FillAttached();
}
private void FillReqs()
{
long schoolCourse = 0;
if (comboCourse.SelectedIndex != -1)
{
schoolCourse = _listSchoolCourses[comboCourse.SelectedIndex].SchoolCourseNum;
}
long schoolClass = 0;
if (comboClass.SelectedIndex != -1)
{
schoolClass = _listSchoolClasses[comboClass.SelectedIndex].SchoolClassNum;
}
gridReqs.BeginUpdate();
gridReqs.Columns.Clear();
ODGridColumn col = new ODGridColumn("", 100);
gridReqs.Columns.Add(col);
gridReqs.Rows.Clear();
if (gridStudents.GetSelectedIndex() == -1)
{
gridReqs.EndUpdate();
return;
}
ReqTable = ReqStudents.GetForCourseClass(schoolCourse, schoolClass);
ODGridRow row;
for (int i = 0; i < ReqTable.Rows.Count; i++)
{
row = new ODGridRow();
row.Cells.Add(ReqTable.Rows[i]["Descript"].ToString());
gridReqs.Rows.Add(row);
}
gridReqs.EndUpdate();
}
private void butOK_Click(object sender, EventArgs e)
{
ReqStudents.SynchApt(reqsAttached, _listReqsRemoved, AptNum);
DialogResult = DialogResult.OK;
}
