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(); } }