private void BindApplicationData()
{
ApplicationData app = new ApplicationData();
app.LoadByPrimaryKey(CurrentApp);
Course course = new Course();
CourseLangauge lang = new CourseLangauge();
if (!app.IsColumnNull("SelectedCourseID"))
course.LoadByPrimaryKey(app.SelectedCourseID);
if (course.RowCount > 0 && !course.IsColumnNull("CourseLangaugeID"))
lang.LoadByPrimaryKey(course.CourseLangaugeID);
uiImageMain.ImageUrl = ".." + app.RecentPhotoPath;
uiLabelName.Text = app.FirstName + " " + app.FamilyName;
uiLabelMail.Text = app.Email;
if (course.RowCount > 0)
uiLabelCourse.Text = course.CourseName;
else
uiLabelCourse.Text = "not selected";
if(lang.RowCount > 0)
uiLabelLang.Text = lang.Langauge;
else
uiLabelLang.Text = "not selected";
ApplicationStatusHistory history = new ApplicationStatusHistory();
history.GetApplicationStatusHistorybyApplicationDataID(CurrentApp);
if (history.RowCount > 0 && (history.ApplicationStatusID == 4 || history.ApplicationStatusID == 5)) // Tuition Fees - missing docs - refusal reasons
{
uiPanelFees.Visible = true;
uiPanelMissingDocs.Visible = true;
uiPanelRefusalReasons.Visible = true;
}
else
{
uiPanelFees.Visible = false;
uiPanelMissingDocs.Visible = false;
uiPanelRefusalReasons.Visible = false;
}
BindHistory();
ApplicationStatus status = new ApplicationStatus();
status.GetNextApplicationStatusApplicationDataID(CurrentApp);
if(status.RowCount > 0)
uiDropDownListStatus.DataSource = status.DefaultView;
else if(history.RowCount > 0)
{
ApplicationStatus next = new ApplicationStatus();
status.LoadByPrimaryKey(history.ApplicationStatusID);
next.Where.ParentStatusID.Value = status.ParentStatusID;
next.Where.ParentStatusID.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal;
next.Query.Load();
uiDropDownListStatus.DataSource = next.DefaultView;
}
uiDropDownListStatus.DataTextField = ApplicationStatus.ColumnNames.Status;
uiDropDownListStatus.DataValueField = ApplicationStatus.ColumnNames.ApplicationStatusID;
uiDropDownListStatus.DataBind();
uiDropDownListStatus.Items.Insert(0, new ListItem("select new status ... ", "0"));
}
private void BindFields()
{
Student student = (Student)Session["CurrentUser"];
ApplicationData app = new ApplicationData();
app.GetApplicationByStudentID(student.StudentID);
if (app.RowCount > 0 && app.IsSubmit == false)
{
uiTextBoxFamilyName.Text = app.FamilyName;
uiTextBoxFirstName.Text = app.FirstName;
uiTextBoxMiddleName.Text = app.MiddleName;
if(!(app.IsColumnNull("DateOfBirth")))
uiTextBoxDOB.Text = app.DateOfBirth.ToString("dd/MM/yyyy");
if (!app.IsColumnNull("CountryOfBirthID"))
uiDropDownListPOB.SelectedValue = app.CountryOfBirthID.ToString();
uiTextBoxHeight.Text = app.Hieght.ToString();
uiTextBoxWeight.Text = app.Weight.ToString();
uiRadioButtonListGender.SelectedValue = app.GenderID.ToString();
if (!(app.IsColumnNull("CitizenShipID")))
uiDropDownListCountry.SelectedValue = app.CitizenShipID.ToString();
uiTextBoxPassNo.Text = app.PassportNo ;
if(!app.IsColumnNull("PassportExpiryDate"))
uiTextBoxPassExp.Text = app.PassportExpiryDate.ToString("dd/MM/yyyy");
if (!app.IsColumnNull("CountryOfIssueID"))
uiDropDownListCOI.SelectedValue = app.CountryOfIssueID.ToString();
if (!app.IsColumnNull("HairColor"))
uiDropDownListHairColor.SelectedValue = app.HairColor;
if (!app.IsColumnNull("EyeColor"))
uiDropDownListEyeColor.SelectedValue = app.EyeColor;
uiTextBoxFaFamilyName.Text = app.FatherFamilyName;
uiTextBoxFaFirstName.Text = app.FatherFirstName;
uiTextBoxFaOccupation.Text = app.FatherOccupation;
uiTextBoxFaHomePhone.Text = app.FatherHomePhone;
uiTextBoxFaBusPhone.Text = app.FatherBusinessPhone;
uiTextBoxFaMobile.Text = app.FatherCellPhone;
uiTextBoxMoFamilyName.Text = app.MotherFamilyName;
uiTextBoxMoFirstName.Text = app.MotherFirstName;
uiTextBoxMoOccupation.Text = app.MotherOccupation;
uiTextBoxStreetAddress.Text = app.StreetAddress;
if (!app.IsColumnNull("CountryID"))
uiDropDownListAddressCountry.SelectedValue = app.CountryID.ToString();
uiTextBoxCity.Text = app.City;
uiTextBoxAddTele.Text = app.TelephoneNumber;
uiTextBoxAddFax.Text = app.FaxNumber;
uiTextBoxEmail.Text = app.Email;
uiTextBoxCellphone.Text = app.CellPhone;
uiTextBoxResAddress.Text = app.ResidentAddress;
if (!string.IsNullOrEmpty(app.RecentPhotoPath))
{
uiHiddenFieldRecentPhoto.Value = app.RecentPhotoPath;
}
else
{
uiHiddenFieldRecentPhoto.Value = "";
}
uiTextBoxMDS.Text = app.MasterDegree;
uiTextBoxMDUniversity.Text = app.University;
if(!app.IsColumnNull("DateOfGraduation"))
uiTextBoxMDDate.Text = app.DateOfGraduation.ToString("dd/MM/yyyy");
uiTextBoxBach.Text = app.BachelorDegree;
uiTextBoxBachUni.Text = app.BachelorUniversity;
if (!app.IsColumnNull("BachelorGraduationDate"))
uiTextBoxBachDate.Text = app.BachelorGraduationDate.ToString("dd/MM/yyyy");
uiTextBoxHighSchool.Text = app.HighScool;
uiTextBoxHighCollege.Text = app.HighSchoolCollege;
if (!app.IsColumnNull("HighSchoolGradDate"))
uiTextBoxHighDate.Text = app.HighSchoolGradDate.ToString("dd/MM/yyyy");
uiTextBoxDS.Text = app.DegreeSpecialization;
uiTextBoxKOD.Text = app.KindOfDegree;
uiTextBoxCS.Text = app.College;
if (!app.IsColumnNull("DegreeDateOfGraduation"))
uiTextBoxDDOG.Text = app.DegreeDateOfGraduation.ToString("dd/MM/yyyy");
if (!app.IsColumnNull("SelectedCourseID"))
{
Course course = new Course();
course.LoadByPrimaryKey(app.SelectedCourseID);
uiDropDownListLanguage.SelectedValue = course.CourseLangaugeID.ToString();
Course courses = new Course();
courses.GetCourseByLanguageID(Convert.ToInt32(uiDropDownListLanguage.SelectedValue));
if (courses.RowCount > 0)
uiDropDownListCourses.DataSource = courses.DefaultView;
else
uiDropDownListCourses.DataSource = null;
uiDropDownListCourses.DataTextField = "DisplayName";
uiDropDownListCourses.DataValueField = Course.ColumnNames.CourseID;
uiDropDownListCourses.DataBind();
uiDropDownListCourses.SelectedValue = app.SelectedCourseID.ToString();
}
ApplicationAttachment attachments = new ApplicationAttachment();
attachments.GetAttachmentsForNotSubmittedApplication(app.ApplicationDataID);
uiPanelAttachments.Visible = (attachments.RowCount > 0);
uiGridViewAttachments.DataSource = attachments.DefaultView;
uiGridViewAttachments.DataBind();
}
}
