}//---------------------------------
//##################################END BUTTON btnSearchStudent EVENTS##########################################################
//##################################BUTTON btnSearchScholarship EVENTS##########################################################
//event is raised when the control is clicked
private void btnSearchScholarshipClick(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
using (StudentScholarshipSearchOnTextBoxList frmSearch = new StudentScholarshipSearchOnTextBoxList(_userInfo, _scholarshipManager))
{
frmSearch.AdoptGridSize = true;
frmSearch.ShowDialog(this);
if (frmSearch.HasSelected)
{
_scholarshipInfo = _scholarshipManager.GetDetailsScholarshipInformation(frmSearch.PrimaryId);
_studentScholarshipInfo.ScholarshipInfo = _scholarshipInfo;
this.lblCourseGroupDescription.Text = _scholarshipManager.GetCourseGroupDescription(_scholarshipInfo.CourseGroupInfo.CourseGroupId);
this.lblDepartmentDescription.Text = _scholarshipManager.GetDepartmentDescription(_scholarshipInfo.DepartmentInfo.DepartmentId);
this.lblScholarshipDescription.Text = _scholarshipInfo.ScholarshipDescription;
this.chkNonAcademic.Checked = _scholarshipInfo.IsNonAcademic;
}
}
this.Cursor = Cursors.Arrow;
}
catch (Exception ex)
{
RemoteClient.ProcStatic.ShowErrorDialog(ex.Message, "Error Loading");
}
}//-------------------------------
}//-------------------
//this procedure will update scholarship information
public void UpdateScholarshipInformation(CommonExchange.SysAccess userInfo, CommonExchange.ScholarshipInformation scholarshipInfo)
{
using (RemoteClient.RemCntScholarshipManager remClient = new RemoteClient.RemCntScholarshipManager())
{
remClient.UpdateScholarshipInformation(userInfo, scholarshipInfo);
}
Int32 index = 0;
foreach (DataRow scholarRow in _classDataSet.Tables["ScholarshipInformationTable"].Rows)
{
if (String.Equals(scholarshipInfo.ScholarshipSysId, RemoteServerLib.ProcStatic.DataRowConvert(scholarRow, "sysid_scholarship", "")))
{
DataRow editRow = _classDataSet.Tables["ScholarshipInformationTable"].Rows[index];
editRow.BeginEdit();
editRow["sysid_scholarship"] = scholarshipInfo.ScholarshipSysId;
editRow["course_group_id"] = scholarshipInfo.CourseGroupInfo.CourseGroupId;
editRow["department_id"] = scholarshipInfo.DepartmentInfo.DepartmentId;
editRow["department_name"] = scholarshipInfo.DepartmentInfo.DepartmentName;
editRow["department_acronym"] = scholarshipInfo.DepartmentInfo.Acronym;
editRow["is_non_academic"] = scholarshipInfo.IsNonAcademic;
editRow["scholarship_description"] = scholarshipInfo.ScholarshipDescription;
editRow.EndEdit();
}
index++;
}
}//----------------------
//###############################################CLASS Scholarship EVENTS##################################################
//event is raised when the class is loaded
protected virtual void ClassLoad(object sender, EventArgs e)
{
_scholarshipInfo = new CommonExchange.ScholarshipInformation();
_scholarshipManager.InitializeCourseGroupCombo(this.cboCourseGroup);
_scholarshipManager.InitializeDepartmentCombo(this.cboDepartment);
}//---------------------
//#####################################CLASS ScholarshipUpdate EVENTS########################################
//event is raised when the class is loaded
protected override void ClassLoad(object sender, EventArgs e)
{
_scholarshipManager.InitializeCourseGroupCombo(this.cboCourseGroup, _scholarshipInfo.CourseGroupInfo.CourseGroupId);
_scholarshipManager.InitializeDepartmentCombo(this.cboDepartment, _scholarshipInfo.DepartmentInfo.DepartmentId);
this.lblSystemId.Text = _scholarshipInfo.ScholarshipSysId;
this.txtScholarship.Text = _scholarshipInfo.ScholarshipDescription;
this.chkNonAcademic.Checked = _scholarshipInfo.IsNonAcademic;
_scholarshipInfoTemp = (CommonExchange.ScholarshipInformation)_scholarshipInfo.Clone();
}//----------------------
}//------------------------
//this fucntion determines if scholarship description already exist
public Boolean IsExistsScholarshipDescriptionScholarshipInformation(CommonExchange.SysAccess userInfo,
CommonExchange.ScholarshipInformation scholarshipInfo)
{
Boolean value;
using (RemoteClient.RemCntScholarshipManager remClient = new RemoteClient.RemCntScholarshipManager())
{
value = remClient.IsExistsScholarshipDescriptionScholarshipInformation(userInfo, scholarshipInfo);
}
return(value);
}//---------------------------
public ScholarshipUpdate(CommonExchange.SysAccess userInfo, CommonExchange.ScholarshipInformation scholarshipInfo,
ScholarshipLogic scholarshipManager)
: base(userInfo, scholarshipManager)
{
this.InitializeComponent();
_userInfo = userInfo;
_scholarshipManager = scholarshipManager;
_scholarshipInfo = scholarshipInfo;
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(ClassClosed);
this.btnClose.Click += new EventHandler(btnCloseClick);
this.btnEdit.Click += new EventHandler(btnEditClick);
}
//this procedure will insert scholarship information
public void InsertScholarshipInformation(CommonExchange.SysAccess userInfo, CommonExchange.ScholarshipInformation scholarshipInfo)
{
using (RemoteClient.RemCntScholarshipManager remClient = new RemoteClient.RemCntScholarshipManager())
{
remClient.InsertScholarshipInformation(userInfo, ref scholarshipInfo);
}
DataRow newRow = _classDataSet.Tables["ScholarshipInformationTable"].NewRow();
newRow["sysid_scholarship"] = scholarshipInfo.ScholarshipSysId;
newRow["course_group_id"] = scholarshipInfo.CourseGroupInfo.CourseGroupId;
newRow["group_description"] = scholarshipInfo.CourseGroupInfo.GroupDescription;
newRow["department_id"] = scholarshipInfo.DepartmentInfo.DepartmentId;
newRow["department_name"] = this.GetDepartmentDescription(scholarshipInfo.DepartmentInfo.DepartmentId);
newRow["department_acronym"] = this.GetDepartmentAcronym(scholarshipInfo.DepartmentInfo.DepartmentId);
newRow["is_non_academic"] = scholarshipInfo.IsNonAcademic;
newRow["scholarship_description"] = scholarshipInfo.ScholarshipDescription;
_classDataSet.Tables["ScholarshipInformationTable"].Rows.Add(newRow);
}//-------------------
}//-------------------------
//this fucntion get scholarship details
public CommonExchange.ScholarshipInformation GetDetailsScholarshipInformation(String sysidScolarship)
{
CommonExchange.ScholarshipInformation scholarshipInfo = new CommonExchange.ScholarshipInformation();
String strFilter = "sysid_scholarship = '" + sysidScolarship + "'";
DataRow[] selectRow = _classDataSet.Tables["ScholarshipInformationTable"].Select(strFilter);
foreach (DataRow scholarRow in selectRow)
{
scholarshipInfo.CourseGroupInfo.CourseGroupId = RemoteServerLib.ProcStatic.DataRowConvert(scholarRow, "course_group_id", "");
scholarshipInfo.DepartmentInfo.DepartmentId = RemoteServerLib.ProcStatic.DataRowConvert(scholarRow, "department_id", "");
scholarshipInfo.IsNonAcademic = RemoteServerLib.ProcStatic.DataRowConvert(scholarRow, "is_non_academic", false);
scholarshipInfo.ScholarshipDescription = RemoteServerLib.ProcStatic.DataRowConvert(scholarRow, "scholarship_description", "");
scholarshipInfo.ScholarshipSysId = RemoteServerLib.ProcStatic.DataRowConvert(scholarRow, "sysid_scholarship", "");
break;
}
return(scholarshipInfo);
}//------------------------
//####################################CLASS StudentScholarship EVENTS####################################
//event is raised when the class is loaded
protected virtual void ClassLoad(object sender, EventArgs e)
{
_studentScholarshipInfo = new CommonExchange.StudentScholarship();
_scholarshipInfo = new CommonExchange.ScholarshipInformation();
}//--------------------