} //---------------------------
//this function returns a searched semester information
public DataTable GetSearchedSemesterInformation(CommonExchange.SysAccess userInfo, String queryString, Boolean isNewQuery)
{
if (isNewQuery)
{
using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager())
{
_semesterTable = remClient.SelectYearSemesterDescriptionSemesterInformationTable(userInfo, queryString, _serverDateTime);
}
}
DataTable newTable = new DataTable("SemesterInformationSearchedTable");
newTable.Columns.Add("sysid_semester", System.Type.GetType("System.String"));
newTable.Columns.Add("year_description", System.Type.GetType("System.String"));
newTable.Columns.Add("semester_description", System.Type.GetType("System.String"));
if (_semesterTable != null)
{
foreach (DataRow semRow in _semesterTable.Rows)
{
DataRow newRow = newTable.NewRow();
newRow["sysid_semester"] = semRow["sysid_semester"];
newRow["year_description"] = semRow["year_description"];
newRow["semester_description"] = semRow["semester_description"];
newTable.Rows.Add(newRow);
}
}
newTable.AcceptChanges();
return(newTable);
} //----------------------------
} //-----------------------------------
//this function returns a searched school year
public DataTable GetSearchedSchoolYearInformation(CommonExchange.SysAccess userInfo, String queryString, Boolean isNewQuery)
{
if (isNewQuery)
{
using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager())
{
_schoolYearTable = remClient.SelectByYearDescriptionSchoolYearTable(userInfo, queryString, _serverDateTime);
}
}
DataTable newTable = new DataTable("SchoolYearInformationSearchTable");
newTable.Columns.Add("year_id", System.Type.GetType("System.String"));
newTable.Columns.Add("year_description", System.Type.GetType("System.String"));
if (_schoolYearTable != null)
{
DataRow[] selectRow = _schoolYearTable.Select("", "year_id DESC");
foreach (DataRow yearRow in selectRow)
{
DataRow newRow = newTable.NewRow();
newRow["year_id"] = yearRow["year_id"].ToString();
newRow["year_description"] = yearRow["year_description"].ToString();
newTable.Rows.Add(newRow);
}
}
newTable.AcceptChanges();
return(newTable);
} //---------------------------
} //----------------------------
////this function returns a school semester id
//private Byte GetSchoolSemesterId(String yearId)
//{
// if (_semesterTable != null)
// {
// String strFilter = "year_id = '" + yearId + "'";
// DataRow[] selectRow = _semesterTable.Select(strFilter, "sysid_semester DESC");
// return (Byte)(selectRow.Length + 1);
// }
// else
// {
// return 0;
// }
//} //-----------------------------
////this function determines if the school semester has errors
//private Boolean HasErrorSemester(CommonExchange.SysAccess userInfo, String yearId)
//{
// Boolean hasError = true;
// using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager())
// {
// _semesterTable = remClient.SelectYearSemesterDescriptionSemesterInformationTable(userInfo, "*", _serverDateTime);
// }
// String strFilter = "year_id = '" + yearId + "'";
// DataRow[] selectRow = _semesterTable.Select(strFilter, "sysid_semester DESC");
// if (selectRow.Length < (Int32)CommonExchange.SchoolSemester.SecondSemester)
// {
// hasError = false;
// }
// return hasError;
//} //---------------------------
//this function gets the semester information start date
private DateTime GetSemesterInformationDateStart(CommonExchange.SysAccess userInfo)
{
DateTime maxDate;
using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager())
{
if (!DateTime.TryParse(remClient.GetMaxDateEndSemesterInformation(userInfo), out maxDate))
{
maxDate = DateTime.Parse(_stdRegistrar.SchoolYearStart.ToString() + "/01/" +
DateTime.Parse(_serverDateTime).Year.ToString() + " 12:00:00 AM");
}
}
return(DateTime.Parse(maxDate.AddMonths(1).Month.ToString() + "/01/" + maxDate.AddMonths(1).Year.ToString() + " 12:00:00 AM"));
} //-------------------------------
} //--------------------------------
//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 school year information
using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager())
{
_classDataSet = remClient.GetDataSetForSchoolYearSemeter(userInfo);
} //-----------------------
//gets the registrar standard
using (RemoteClient.RemCntBaseManager remClient = new RemoteClient.RemCntBaseManager())
{
_stdRegistrar = remClient.SelectRegistrarStandard(userInfo);
} //------------------
} //-----------------------
} //------------------------------------
//this procedure inserts a school year
public void InsertSchoolYearSummer(CommonExchange.SysAccess userInfo, CommonExchange.SchoolYear baseYearInfo, ref CommonExchange.SchoolYear yearInfo)
{
using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager())
{
remClient.InsertSchoolYearSummer(userInfo, baseYearInfo, ref yearInfo);
}
if (_schoolYearTable != null)
{
DataRow newRow = _schoolYearTable.NewRow();
newRow["year_id"] = yearInfo.YearId;
newRow["year_description"] = yearInfo.Description;
newRow["date_start"] = yearInfo.DateStart;
newRow["date_end"] = yearInfo.DateEnd;
newRow["is_summer"] = yearInfo.IsSummer;
_schoolYearTable.Rows.Add(newRow);
_schoolYearTable.AcceptChanges();
}
} //------------------------------------
} //----------------------------
//this function gets the school year start date
private DateTime GetSchoolYearDateStart(CommonExchange.SysAccess userInfo, Boolean isSummer)
{
DateTime dateStart;
using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager())
{
DateTime dateEnd;
if (!isSummer)
{
if (DateTime.TryParse(remClient.GetMaxDateEndSchoolYear(userInfo), out dateEnd))
{
dateStart = DateTime.Parse(_stdRegistrar.SchoolYearStart.ToString() + "/01/" +
dateEnd.Year.ToString() + " 12:00:00 AM");
}
else
{
dateStart = DateTime.Parse(_stdRegistrar.SchoolYearStart.ToString() + "/01/" +
DateTime.Parse(_serverDateTime).Year.ToString() + " 12:00:00 AM");
}
}
else
{
if (DateTime.TryParse(remClient.GetMaxDateEndSchoolYear(userInfo), out dateEnd))
{
dateStart = DateTime.Parse(dateEnd.AddMonths(1).Month.ToString() + "/01/" +
dateEnd.AddMonths(1).Year.ToString() + " 12:00:00 AM");
}
else
{
dateStart = DateTime.Parse(DateTime.Parse(_serverDateTime).AddMonths(1).Month.ToString() + "/01/" +
DateTime.Parse(_serverDateTime).AddMonths(1).Year.ToString() + " 12:00:00 AM");
}
}
}
return(dateStart);
} //-------------------------
//this procedure insterst a school semester information
public void InsertSemesterInformation(CommonExchange.SysAccess userInfo, CommonExchange.SemesterInformation semInfo)
{
using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager())
{
remClient.InsertSemesterInformation(userInfo, ref semInfo);
}
if (_semesterTable != null)
{
DataRow newRow = _semesterTable.NewRow();
newRow["sysid_semester"] = semInfo.SemesterSysId;
newRow["year_id"] = semInfo.SchoolYearInfo.YearId;
newRow["semester_id"] = semInfo.SemesterId;
newRow["date_start"] = semInfo.DateStart;
newRow["date_end"] = semInfo.DateEnd;
newRow["year_description"] = semInfo.SchoolYearDescription;
newRow["semester_description"] = semInfo.SchoolSemesterDescription;
_semesterTable.Rows.Add(newRow);
_semesterTable.AcceptChanges();
}
} //---------------------------------
