예제 #1
0
    private void initPage()
    {
        lblTitle.Text = "Student's Application History";

        USTTI.Data.USTTIDataAccess data = new USTTI.Data.USTTIDataAccess();

        USTTI.Base.Student StudentInfo = data.GetStudentInfo(StudentID);
        student_info_header.SetObjectValue(StudentInfo.FirstName, StudentInfo.LastName, StudentInfo.DOB.ToString(), StudentInfo.CountryName);

        string sql = "SELECT a.*,s.firstname,s.lastname,c.countryname,o.date_from " +
                     "FROM application a,student s,country c,orientation o WHERE s.studentid=a.studentid AND c.countryid=s.countryid " +
                     "AND o.orientid=a.orientid AND a.studentid='" + StudentID + "' ORDER BY a.applicdate DESC";

        DataTable dt = data.Fill(sql);

        dgApplication.DataSource = dt;
        dgApplication.DataBind();

        if (dt.DefaultView.Count.Equals(0))
        {
            lblMessNull.Text    = "No Application History for This Student";
            lblMessNull.Visible = true;
        }
        else
        {
            lblMessNull.Visible = false;
        }
    }
예제 #2
0
    private void initPage()
    {
        txtSID.Text = Convert.ToString(StudentID);

        application_date.GenerateDateList(2006, 2020);
        SetDefaultApplicationDate();
        arrival_date.GenerateDateList(2006, 2020);
        departure_date.GenerateDateList(2006, 2020);
        checkout_date.GenerateDateList(2006, 2020);
        RequiredFieldValidator1.Enabled = false;
        RequiredFieldValidator2.Enabled = false;
        application_date.setValidatorOff();
        arrival_date.setValidatorOff();
        departure_date.setValidatorOff();
        checkout_date.setValidatorOff();
        RequiredFieldValidator3.Enabled = false;

        USTTI.Data.USTTIDataAccess data        = new USTTI.Data.USTTIDataAccess();
        USTTI.Base.Student         StudentInfo = data.GetStudentInfo(StudentID);

        if (lblStartDate.Text.Length.Equals(0))
        {
            btnBrowseOID.Visible = true;
        }
        else
        {
            btnBrowseOID.Visible = false;
        }

        lblStudentName.Text = StudentInfo.FirstName + " " + StudentInfo.LastName;
    }
예제 #3
0
 private void initPage()
 {
     USTTI.Data.USTTIDataAccess data        = new USTTI.Data.USTTIDataAccess();
     USTTI.Base.Student         StudentInfo = data.GetStudentInfo(StudentID);
     student_header_info.SetObjectValue(StudentInfo.FirstName, StudentInfo.LastName, StudentInfo.DOB.ToString(), StudentInfo.CountryName);
     ViewCourseLoadDetail();
     tblSubPageEntryDetail.Visible = false;
 }
예제 #4
0
    private void SaveRecord()
    {
        USTTIDataAccess data = new USTTIDataAccess();

        USTTI.Base.Student objStudentTbl = new USTTI.Base.Student();

        //UsttiDataObject.student objStudentTbl = new UsttiDataObject.student();
        UsttiDataObject.PhoneNumber objBusPhoneNumber  = new UsttiDataObject.PhoneNumber();
        UsttiDataObject.PhoneNumber objHomePhoneNumber = new UsttiDataObject.PhoneNumber();
        UsttiDataObject.PhoneNumber objFaxPhoneNumber  = new UsttiDataObject.PhoneNumber();
        StudentID = data.GetNextStudentID();

        objStudentTbl.StudentID          = StudentID;
        objStudentTbl.Honorific          = DropDownListHonorific.SelectedItem.Text;
        objStudentTbl.FirstName          = UtilManager.RemoveSpecialCharacters(txtFirstName.Text.ToString());
        objStudentTbl.MiddleName         = UtilManager.RemoveSpecialCharacters(txtMiddleName.Text.ToString());
        objStudentTbl.LastName           = UtilManager.RemoveSpecialCharacters(txtLastName.Text.ToString());
        objStudentTbl.Suffix             = UtilManager.RemoveSpecialCharacters(txtSuffix.Text.ToString());
        objStudentTbl.DOB                = Convert.ToDateTime(dob_selector.GetDate().ToString());
        objStudentTbl.Sex                = DropDownListSex.SelectedItem.Text;
        objStudentTbl.Org1               = UtilManager.RemoveSpecialCharacters(txtOrg1.Text.ToString());
        objStudentTbl.Title              = txtTitle.Text;
        objStudentTbl.Addr1              = UtilManager.RemoveSpecialCharacters(txtAddress1.Text.ToString());
        objStudentTbl.City               = UtilManager.RemoveSpecialCharacters(txtCity.Text.ToString());
        objStudentTbl.ZipCode            = txtZipCode.Text;
        objStudentTbl.BusPhone           = objBusPhoneNumber.getNumber(txtBusCountryCode, txtBusAreaCode, txtBusPhoneNumber);
        objStudentTbl.HomePhone          = objHomePhoneNumber.getNumber(txtHomeCountryCode, txtHomeAreaCode, txtHomePhoneNumber);
        objStudentTbl.Fax                = objFaxPhoneNumber.getNumber(txtFaxCountryCode, txtFaxAreaCode, txtFaxPhoneNumber);
        objStudentTbl.CellPhone          = txtCellPhone.Text;
        objStudentTbl.BusEmail           = UtilManager.RemoveSpecialCharacters(txtBusEmail.Text.ToString());
        objStudentTbl.PerEmail           = UtilManager.RemoveSpecialCharacters(txtPerEmail.Text.ToString());
        objStudentTbl.SpvrName           = UtilManager.RemoveSpecialCharacters(txtSpvrName.Text.ToString());
        objStudentTbl.SpvrTitle          = UtilManager.RemoveSpecialCharacters(txtSpvrTitle.Text.ToString());
        objStudentTbl.SpvrEmail          = UtilManager.RemoveSpecialCharacters(txtSupvrEmail.Text.ToString());
        objStudentTbl.Memo               = UtilManager.RemoveSpecialCharacters(txtMemo.Text.ToString());
        objStudentTbl.PNG                = PNGRadioButton.SelectedValue;
        objStudentTbl.HomeAddr1          = UtilManager.RemoveSpecialCharacters(txtHomeAddress1.Text.ToString());
        objStudentTbl.HomeCity           = UtilManager.RemoveSpecialCharacters(txtHomeCity.Text.ToString());
        objStudentTbl.HomeZipCode        = txtHomeZipCode.Text;
        objStudentTbl.CountryID          = Convert.ToInt32(CountryDropDownList.SelectedValue);
        objStudentTbl.PassNum            = txtPassportNum.Text;
        objStudentTbl.PassExpDate        = Convert.ToDateTime(pass_exp_date_selector.GetDate());
        objStudentTbl.PassCountry        = Convert.ToInt32(PassCountryDataList.SelectedValue);
        objStudentTbl.LastUpdateTime     = DateTime.Now;
        objStudentTbl.ReadingSkill       = ReadingSkill.SelectedValue;
        objStudentTbl.WritingSkill       = WritingSkill.SelectedValue;
        objStudentTbl.SpeakingSkill      = SpeakingSkill.SelectedValue;
        objStudentTbl.ComprehensionSkill = Comprehension.SelectedValue;

        data.InsertStudentRecord(objStudentTbl);
    }
    private void initPage()
    {
        InitiateFunderList();
        InitiateFundTypeList();
        start_date.GenerateDateList(2006, 2020);
        end_date.GenerateDateList(2006, 2020);

        USTTI.Data.USTTIDataAccess data        = new USTTI.Data.USTTIDataAccess();
        USTTI.Base.Student         StudentInfo = data.GetStudentInfo(StudentID);

        student_info_header.SetObjectValue(StudentInfo.FirstName, StudentInfo.FirstName, StudentInfo.DOB.ToString(), StudentInfo.CountryName);
        ViewFundingListDetail();
        tblSubPageEntryDetail.Visible = false;
    }
예제 #6
0
    protected void SaveUserInputinEdit(Decimal strStudentID)
    {
        USTTIDataAccess data = new USTTIDataAccess();

        USTTI.Base.Student objStudentTbl = new USTTI.Base.Student();

        objStudentTbl.StudentID  = strStudentID;
        objStudentTbl.Honorific  = DropDownListHonorific.SelectedItem.Text;
        objStudentTbl.FirstName  = txtFirstName.Text;
        objStudentTbl.MiddleName = txtMiddleName.Text;
        objStudentTbl.LastName   = txtLastName.Text;
        objStudentTbl.Suffix     = txtSuffix.Text;
        objStudentTbl.DOB        = Convert.ToDateTime(dob_selector.GetDate());
        objStudentTbl.Sex        = DropDownListSex.SelectedItem.Text;
        objStudentTbl.Org1       = txtOrg1.Text;
        objStudentTbl.Title      = txtTitle.Text;
        objStudentTbl.Addr1      = txtAddress1.Text;
        objStudentTbl.City       = txtCity.Text;
        objStudentTbl.ZipCode    = txtZipCode.Text;

        if (ViewState["oldbusphnbrformat"].Equals(true))
        {
            objStudentTbl.BusPhone = txtBusPhoneNumberOld.Text.Trim();
        }
        else
        {
            objStudentTbl.BusPhone = Regex.Replace(objBusPhoneNumber.getNumber(txtBusCountryCode, txtBusAreaCode, txtBusPhoneNumber), "\\s+", "");
        }
        if (ViewState["oldhomephnbrformat"].Equals(true))
        {
            objStudentTbl.HomePhone = txthomephonenumberoldformat.Text.Trim();
        }
        else
        {
            objStudentTbl.HomePhone = Regex.Replace(objHomePhoneNumber.getNumber(txtHomeCountryCode, txtHomeAreaCode, txtHomePhoneNumber), "\\s+", "");
        }
        if (ViewState["oldfaxphnbrformat"].Equals(true))
        {
            objStudentTbl.Fax = txtfaxnumberoldformat.Text.Trim();
        }
        else
        {
            objStudentTbl.Fax = Regex.Replace(objFaxPhoneNumber.getNumber(txtFaxCountryCode, txtFaxAreaCode, txtFaxPhoneNumber), "\\s+", "");
        }
        objStudentTbl.CellPhone          = txtCellPhone.Text;
        objStudentTbl.BusEmail           = txtBusEmail.Text;
        objStudentTbl.PerEmail           = txtPerEmail.Text;
        objStudentTbl.SpvrName           = txtSpvrName.Text;
        objStudentTbl.SpvrTitle          = txtSpvrTitle.Text;
        objStudentTbl.SpvrEmail          = txtSupvrEmail.Text;
        objStudentTbl.PNG                = PNGRadioButton.SelectedValue;
        objStudentTbl.Memo               = txtMemo.Text;
        objStudentTbl.HomeAddr1          = txtHomeAddress1.Text;
        objStudentTbl.HomeCity           = txtHomeCity.Text;
        objStudentTbl.HomeZipCode        = txtHomeZipCode.Text;
        objStudentTbl.CountryID          = Convert.ToInt32(CountryDropDownList.SelectedValue);
        objStudentTbl.PassNum            = txtPassportNum.Text;
        objStudentTbl.PassExpDate        = Convert.ToDateTime(pass_exp_date_selector.GetDate());
        objStudentTbl.PassCountry        = Convert.ToInt32(PassCountryDataList.SelectedValue);
        objStudentTbl.ReadingSkill       = ReadingSkill.SelectedValue.Trim();
        objStudentTbl.WritingSkill       = WritingSkill.SelectedValue.Trim();
        objStudentTbl.SpeakingSkill      = SpeakingSkill.SelectedValue.Trim();
        objStudentTbl.ComprehensionSkill = Comprehension.SelectedValue.Trim();

        data.UpdateStudentRecord(objStudentTbl);
    }