Ejemplo n.º 1
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);
    }