protected void ViewStudentData(Decimal intSID)
{
//define connection string
string strConn = ConfigurationManager.ConnectionStrings["usttiConnectionString"].ConnectionString;
//open connection with database
SqlConnection objConn = new SqlConnection(strConn);
objConn.Open();
//create query command
string strQueryStudent = "SELECT s.*,c.countryname as countryname," +
"p.countryname as passcountryname FROM student s,country c,country p WHERE (c.countryid=s.countryid" +
" AND p.countryid=s.passportcountryid) AND s.studentid=" + intSID;
SqlCommand objComm = new SqlCommand(strQueryStudent, objConn);
SqlDataReader objReader;
objReader = objComm.ExecuteReader();
while (objReader.Read())
{
DropDownListHonorific.Text = Convert.ToString(objReader["honorific"]).Trim();
txtFirstName.Text = Convert.ToString(objReader["firstname"]).Trim();
txtMiddleName.Text = Convert.ToString(objReader["middlename"]).Trim();
txtLastName.Text = Convert.ToString(objReader["lastname"]).Trim();
txtSuffix.Text = Convert.ToString(objReader["suffix"]).Trim();
dob_selector.fillControl(Convert.ToString(objReader["dob"]));
DropDownListSex.Text = Convert.ToString(objReader["sex"]).Trim();
txtOrg1.Text = Convert.ToString(objReader["org"]).Trim();
txtTitle.Text = Convert.ToString(objReader["title"]).Trim();
txtAddress1.Text = Convert.ToString(objReader["address1"]).Trim();
txtCity.Text = Convert.ToString(objReader["city"]).Trim();
txtZipCode.Text = Convert.ToString(objReader["zipcode"]).Trim();
string strBusPhone = Convert.ToString(objReader["busphone"]).Trim();
if (IsPhoneNumberFormatRight(strBusPhone))
{
ViewState["oldbusphnbrformat"] = false;
busphonenumbernewformat.Visible = true;
busphonenumberoldformat.Visible = false;
objBusPhoneNumber.setPhoneNumber(strBusPhone.Trim(), txtBusCountryCode, txtBusAreaCode, txtBusPhoneNumber);
}
else
{
ViewState["oldbusphnbrformat"] = true;
busphonenumbernewformat.Visible = false;
busphonenumberoldformat.Visible = true;
txtBusPhoneNumberOld.Text = strBusPhone.Trim();
}
string strHomePhone = Convert.ToString(objReader["homephone"]).Trim();
if (IsPhoneNumberFormatRight(strHomePhone))
{
ViewState["oldhomephnbrformat"] = false;
homephonenumbernewformat.Visible = true;
homephonenumberoldformat.Visible = false;
objHomePhoneNumber.setPhoneNumber(strHomePhone, txtHomeCountryCode, txtHomeAreaCode, txtHomePhoneNumber);
}
else
{
ViewState["oldhomephnbrformat"] = true;
homephonenumbernewformat.Visible = false;
homephonenumberoldformat.Visible = true;
txthomephonenumberoldformat.Text = strHomePhone.Trim();
}
string strFax = Convert.ToString(objReader["fax"]).Trim();
if (IsPhoneNumberFormatRight(strFax))
{
ViewState["oldfaxphnbrformat"] = false;
faxnumbernewformat.Visible = true;
faxnumberoldformat.Visible = false;
objFaxPhoneNumber.setPhoneNumber(strFax, txtFaxCountryCode, txtFaxAreaCode, txtFaxPhoneNumber);
}
else
{
ViewState["oldfaxphnbrformat"] = true;
faxnumbernewformat.Visible = false;
faxnumberoldformat.Visible = true;
txtfaxnumberoldformat.Text = strFax.Trim();
}
txtCellPhone.Text = Convert.ToString(objReader["cellphone"]).Trim();
txtBusEmail.Text = Convert.ToString(objReader["busemail"]).Trim();
txtPerEmail.Text = Convert.ToString(objReader["homeemail"]).Trim();
txtSpvrName.Text = Convert.ToString(objReader["supername"]).Trim();
txtSpvrTitle.Text = Convert.ToString(objReader["supertitle"]).Trim();
txtSupvrEmail.Text = Convert.ToString(objReader["superemail"]).Trim();
PNGRadioButton.SelectedValue = Convert.ToString(objReader["png"]).Trim();
txtMemo.Text = Convert.ToString(objReader["memo"]).Trim();
txtHomeAddress1.Text = Convert.ToString(objReader["homeaddress1"]).Trim();
txtHomeCity.Text = Convert.ToString(objReader["city"]).Trim();
txtHomeZipCode.Text = Convert.ToString(objReader["homezipcode"]).Trim();
CountryDropDownList.SelectedValue = Convert.ToString(objReader["countryid"]);
txtPassportNum.Text = Convert.ToString(objReader["passportnum"]).Trim();
PassCountryDataList.SelectedValue = Convert.ToString(objReader["passportcountryid"]);
pass_exp_date_selector.fillControl(Convert.ToString(objReader["passexpdate"]));
ReadingSkill.SelectedValue = Convert.ToString(objReader["readingskill"]).Trim();
WritingSkill.SelectedValue = Convert.ToString(objReader["writingskill"]).Trim();
SpeakingSkill.SelectedValue = Convert.ToString(objReader["speakingskill"]).Trim();
Comprehension.SelectedValue = Convert.ToString(objReader["comprehensionskill"]).Trim();
Session.Add("firstname", txtFirstName.Text.Trim());
Session.Add("lastname", txtFirstName.Text.Trim());
Session.Add("dob", dob_selector.GetDate());
Session.Add("countryname", Convert.ToString(objReader["countryid"]).ToString().Trim());
}
objReader.Close();
objConn.Close();
}
