//this procedure inserts a new subject information
public void InsertSubjectInformation(CommonExchange.SysAccess userInfo, CommonExchange.SubjectInformation subjectInfo)
{
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
remClient.InsertSubjectInformation(userInfo, ref subjectInfo, _requisiteTable);
}
if (_subjectTable != null)
{
DataRow newRow = _subjectTable.NewRow();
newRow["sysid_subject"] = subjectInfo.SubjectSysId;
newRow["course_group_id"] = subjectInfo.CourseGroupInfo.CourseGroupId;
newRow["department_id"] = subjectInfo.DepartmentInfo.DepartmentId;
newRow["subject_code"] = subjectInfo.SubjectCode;
newRow["descriptive_title"] = subjectInfo.DescriptiveTitle;
newRow["lecture_units"] = subjectInfo.LectureUnits;
newRow["lab_units"] = subjectInfo.LabUnits;
newRow["no_hours"] = subjectInfo.NoHours;
newRow["other_information"] = subjectInfo.OtherInformation;
newRow["is_semestral"] = subjectInfo.CourseGroupInfo.IsSemestral;
newRow["group_no"] = this.GetCourseGroupNo(subjectInfo.CourseGroupInfo.CourseGroupId);
newRow["department_name"] = subjectInfo.DepartmentInfo.DepartmentName;
newRow["is_non_academic"] = subjectInfo.IsNonAcademic;
_subjectTable.Rows.Add(newRow);
_subjectTable.AcceptChanges();
_requisiteTable.AcceptChanges();
}
} //-------------------------------------
} //-------------------------------------
//this function returns a searched course information
public DataTable GetSearchedCourseInformation(CommonExchange.SysAccess userInfo, String queryString, Boolean isNewQuery)
{
if (isNewQuery)
{
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
_courseTable = remClient.SelectCourseInformation(userInfo, queryString);
}
}
DataTable newTable = new DataTable("CourseInformationSearchTable");
newTable.Columns.Add("course_id", System.Type.GetType("System.String"));
newTable.Columns.Add("course_title", System.Type.GetType("System.String"));
newTable.Columns.Add("course_acronym", System.Type.GetType("System.String"));
if (_courseTable != null)
{
foreach (DataRow courseRow in _courseTable.Rows)
{
DataRow newRow = newTable.NewRow();
newRow["course_id"] = courseRow["course_id"].ToString();
newRow["course_title"] = courseRow["course_title"].ToString();
newRow["course_acronym"] = courseRow["course_acronym"].ToString();
newTable.Rows.Add(newRow);
}
}
newTable.AcceptChanges();
return(newTable);
} //--------------------------
} //--------------------------
//this function is used to get the subject prerequisite by subject id
public DataTable GetBySubjectIdSubjectPrerequisiteTable(CommonExchange.SysAccess userInfo, String subjectSysId)
{
DataTable dbTable;
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
dbTable = remClient.SelectBySubjectIDSubjectPrerequisite(userInfo, subjectSysId);
}
_requisiteTable.Clear();
foreach (DataRow preRow in dbTable.Rows)
{
DataRow newRow = _requisiteTable.NewRow();
newRow["prerequisite_id"] = preRow["prerequisite_id"];
newRow["prerequisite_subject"] = preRow["prerequisite_subject"];
newRow["subject_code"] = preRow["subject_code"];
newRow["descriptive_title_no_freeze"] = preRow["descriptive_title"];
newRow["department_name"] = preRow["department_name"];
newRow["lecture_units"] = preRow["lecture_units"];
newRow["lab_units"] = preRow["lab_units"];
newRow["no_hours"] = preRow["no_hours"];
_requisiteTable.Rows.Add(newRow);
}
_requisiteTable.AcceptChanges();
DataTable newTable = new DataTable("SubjectPrerequisiteTempTable");
newTable.Columns.Add("prerequisite_id", System.Type.GetType("System.Int64"));
newTable.Columns.Add("subject_code", System.Type.GetType("System.String"));
newTable.Columns.Add("descriptive_title_no_freeze", System.Type.GetType("System.String"));
newTable.Columns.Add("department_name", System.Type.GetType("System.String"));
newTable.Columns.Add("lecture_units", System.Type.GetType("System.Byte"));
newTable.Columns.Add("lab_units", System.Type.GetType("System.Byte"));
newTable.Columns.Add("no_hours", System.Type.GetType("System.String"));
DataRow[] selectRow = _requisiteTable.Select("", "subject_code ASC");
foreach (DataRow preRow in selectRow)
{
DataRow tempRow = newTable.NewRow();
tempRow["prerequisite_id"] = preRow["prerequisite_id"];
tempRow["subject_code"] = preRow["subject_code"];
tempRow["descriptive_title_no_freeze"] = preRow["descriptive_title_no_freeze"];
tempRow["department_name"] = preRow["department_name"];
tempRow["lecture_units"] = preRow["lecture_units"];
tempRow["lab_units"] = preRow["lab_units"];
tempRow["no_hours"] = preRow["no_hours"];
newTable.Rows.Add(tempRow);
}
newTable.AcceptChanges();
return(newTable);
}//---------------------------------
} //----------------------------
//this procedure updates a classroom information
public void UpdateClassroomInformation(CommonExchange.SysAccess userInfo, CommonExchange.ClassroomInformation roomInfo)
{
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
remClient.UpdateClassroomInformation(userInfo, roomInfo);
}
if (_classroomTable != null)
{
Int32 index = 0;
foreach (DataRow roomRow in _classroomTable.Rows)
{
if (String.Equals(roomInfo.ClassroomSysId, roomRow["sysid_classroom"].ToString()))
{
DataRow editRow = _classroomTable.Rows[index];
editRow.BeginEdit();
editRow["classroom_code"] = roomInfo.ClassroomCode;
editRow["classroom_description"] = roomInfo.Description;
editRow["maximum_capacity"] = roomInfo.MaximumCapacity;
editRow["other_information"] = roomInfo.OtherInformation;
editRow.EndEdit();
break;
}
index++;
}
_classroomTable.AcceptChanges();
}
} //-----------------------------------
} //--------------------------------
//this function determines if the course title and acronym exist
public Boolean IsExistTitleAcronymCourseInformation(CommonExchange.SysAccess userInfo, CommonExchange.CourseInformation courseInfo)
{
Boolean isExist = false;
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
isExist = remClient.IsExistTitleAcronymCourseInformation(userInfo, courseInfo);
}
return(isExist);
} //--------------------------------
} //----------------------------------
//this function determines if the subject code and descriptive title exist
public Boolean IsExistCodeDescriptionSubjectInformation(CommonExchange.SysAccess userInfo, CommonExchange.SubjectInformation subjectInfo)
{
Boolean isExist = false;
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
isExist = remClient.IsExistCodeDescriptionSubjectInformation(userInfo, subjectInfo);
}
return(isExist);
} //--------------------------------
}//---------------------------------
//this function determines if the classroom code exist
public Boolean IsExistCodeClassroomInformation(CommonExchange.SysAccess userInfo, String roomCode, String roomSysId)
{
Boolean isExist = false;
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
isExist = remClient.IsExistCodeClassroomInformation(userInfo, roomCode, roomSysId);
}
return(isExist);
} //----------------------------------
} //--------------------------------
//this procedure initializes the class
private void InitializeClass(CommonExchange.SysAccess userInfo)
{
//gets the server date and time
using (RemoteClient.RemCntBaseManager remClient = new RemoteClient.RemCntBaseManager())
{
_serverDateTime = remClient.GetServerDateTime(userInfo);
} //----------------------
//gets the dataset for the course manager
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
_classDataSet = remClient.GetDataSetForClassroomSubject(userInfo);
} //-----------------------
} //-----------------------
} //---------------------------
//this function returns a searched subject information
public DataTable GetSearchedSubjectInformation(CommonExchange.SysAccess userInfo, String queryString, String departmentId, Boolean isNewQuery)
{
if (isNewQuery)
{
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
_subjectTable = remClient.SelectSubjectInformation(userInfo, queryString);
}
}
DataTable subjectTable = new DataTable("SubjectConcatCodeTitleTable");
subjectTable.Columns.Add("sysid_subject", System.Type.GetType("System.String"));
subjectTable.Columns.Add("subject_code_title", System.Type.GetType("System.String"));
subjectTable.Columns.Add("department_name", System.Type.GetType("System.String"));
subjectTable.Columns.Add("lecture_units", System.Type.GetType("System.Byte"));
subjectTable.Columns.Add("lab_units", System.Type.GetType("System.Byte"));
subjectTable.Columns.Add("no_hours", System.Type.GetType("System.String"));
if (_subjectTable != null)
{
String strFilter = "department_id = '" + departmentId + "'";
DataRow[] selectRow = _subjectTable.Select(strFilter);
foreach (DataRow subjectRow in selectRow)
{
DataRow newRow = subjectTable.NewRow();
newRow["sysid_subject"] = RemoteServerLib.ProcStatic.DataRowConvert(subjectRow, "sysid_subject", String.Empty);
newRow["subject_code_title"] = RemoteServerLib.ProcStatic.DataRowConvert(subjectRow, "subject_code", String.Empty) + " - " +
RemoteServerLib.ProcStatic.DataRowConvert(subjectRow, "descriptive_title", String.Empty);
newRow["department_name"] = RemoteServerLib.ProcStatic.DataRowConvert(subjectRow, "department_name", String.Empty);
newRow["lecture_units"] = RemoteServerLib.ProcStatic.DataRowConvert(subjectRow, "lecture_units", Byte.Parse("0"));
newRow["lab_units"] = RemoteServerLib.ProcStatic.DataRowConvert(subjectRow, "lab_units", Byte.Parse("0"));
newRow["no_hours"] = RemoteServerLib.ProcStatic.DataRowConvert(subjectRow, "no_hours", String.Empty);
subjectTable.Rows.Add(newRow);
}
}
subjectTable.AcceptChanges();
return(subjectTable);
} //---------------------------
} //-------------------------------------
//this procedure updates a subject information
public void UpdateSubjectInformation(CommonExchange.SysAccess userInfo, CommonExchange.SubjectInformation subjectInfo)
{
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
remClient.UpdateSubjectInformation(userInfo, subjectInfo, _requisiteTable);
}
if (_subjectTable != null)
{
Int32 index = 0;
foreach (DataRow subjectRow in _subjectTable.Rows)
{
if (String.Equals(subjectInfo.SubjectSysId, subjectRow["sysid_subject"].ToString()))
{
DataRow editRow = _subjectTable.Rows[index];
editRow.BeginEdit();
editRow["course_group_id"] = subjectInfo.CourseGroupInfo.CourseGroupId;
editRow["department_id"] = subjectInfo.DepartmentInfo.DepartmentId;
editRow["subject_code"] = subjectInfo.SubjectCode;
editRow["descriptive_title"] = subjectInfo.DescriptiveTitle;
editRow["lecture_units"] = subjectInfo.LectureUnits;
editRow["lab_units"] = subjectInfo.LabUnits;
editRow["no_hours"] = subjectInfo.NoHours;
editRow["other_information"] = subjectInfo.OtherInformation;
editRow["is_semestral"] = subjectInfo.CourseGroupInfo.IsSemestral;
editRow["group_no"] = subjectInfo.CourseGroupInfo.GroupNo;
editRow["department_name"] = subjectInfo.DepartmentInfo.DepartmentName;
editRow["is_non_academic"] = subjectInfo.IsNonAcademic;
editRow.EndEdit();
break;
}
index++;
}
_subjectTable.AcceptChanges();
_requisiteTable.AcceptChanges();
}
} //--------------------------------
} //--------------------------------
//this procedure inserts a new classroom information
public void InsertClassroomInformation(CommonExchange.SysAccess userInfo, CommonExchange.ClassroomInformation roomInfo)
{
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
remClient.InsertClassroomInformation(userInfo, ref roomInfo);
}
if (_classroomTable != null)
{
DataRow newRow = _classroomTable.NewRow();
newRow["sysid_classroom"] = roomInfo.ClassroomSysId;
newRow["classroom_code"] = roomInfo.ClassroomCode;
newRow["classroom_description"] = roomInfo.Description;
newRow["maximum_capacity"] = roomInfo.MaximumCapacity;
newRow["other_information"] = roomInfo.OtherInformation;
_classroomTable.Rows.Add(newRow);
_classroomTable.AcceptChanges();
}
} //----------------------------
} //--------------------------------------
//this function returns a searched classroom information
public DataTable GetSearchedClassroomInformation(CommonExchange.SysAccess userInfo, String queryString, Boolean isNewQuery)
{
if (isNewQuery)
{
using (RemoteClient.RemCntCourseManager remClient = new RemoteClient.RemCntCourseManager())
{
_classroomTable = remClient.SelectClassroomInformation(userInfo, queryString);
}
}
DataTable newTable = new DataTable("ClassroomInformationSearchTable");
newTable.Columns.Add("sysid_classroom", System.Type.GetType("System.String"));
newTable.Columns.Add("classroom_code", System.Type.GetType("System.String"));
newTable.Columns.Add("classroom_description", System.Type.GetType("System.String"));
newTable.Columns.Add("maximum_capacity", System.Type.GetType("System.Byte"));
if (_classroomTable != null)
{
foreach (DataRow roomRow in _classroomTable.Rows)
{
DataRow newRow = newTable.NewRow();
newRow["sysid_classroom"] = roomRow["sysid_classroom"].ToString();
newRow["classroom_code"] = roomRow["classroom_code"].ToString();
newRow["classroom_description"] = roomRow["classroom_description"].ToString();
newRow["maximum_capacity"] = roomRow["maximum_capacity"].ToString();
newTable.Rows.Add(newRow);
}
}
newTable.AcceptChanges();
return(newTable);
} //---------------------------
