public string GetApplicationID(string StudentID)
{
USTTIDataAccess data = new USTTIDataAccess();
string ApplicationID = Convert.ToString(data.GetApplicationID(StudentID));
return(ApplicationID);
}
private DataTable GetResultsData()
{
USTTISessionCollection SessionList = SessionManager.getSessionList();
String sql = "select * from ad_hoc_status ";
sql = sql + " where 1 = 1 ";
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Last"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("First"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Applicant ID"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Country"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Course Num"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Title"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Year"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Gender"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Participat"));
sql = sql + UtilManager.addMultipleStmtToWhereClause(SessionList.Get("Years"));
sql = sql + GetSortExpression();
USTTIDataAccess data = new USTTIDataAccess();
DataTable dt = data.Fill(sql);
return(dt);
}
private void FillGrid()
{
USTTIDataAccess data = new USTTIDataAccess();
DataTable dt = data.GetStudentInfo(Request["First"], Request["Last"], Request["DOB"]);
dgStudent.DataSource = dt;
dgStudent.DataBind();
}
protected void SaveUserInputEdit(Decimal FunderID)
{
USTTIDataAccess data = new USTTIDataAccess();
Funder funder = new Funder();
funder.FunderID = FunderID;
funder.FunderTypeID = Convert.ToInt32(FunderTypeList.SelectedValue);
funder.Description = txtFunderName.Text.Trim();
data.UpdateFunderRecord(funder);
Response.Redirect("funder_edit_record.aspx?funderid=" + FunderID);
}
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);
}
protected void btnContinue_Click(object sender, EventArgs e)
{
USTTIDataAccess data = new USTTIDataAccess();
DataTable dt = data.GetStudentInfo(txtFirstName.Text, txtLastName.Text, dob_selector.GetDate());
if (dt.DefaultView.Count > 0)
{
Response.Redirect("potential_student_matches.aspx?First=" + txtFirstName.Text + "&Last=" + txtLastName.Text + "&DOB=" + dob_selector.GetDate());
}
else
{
Response.Redirect("student_add_record.aspx?First=" + txtFirstName.Text + "&Last=" + txtLastName.Text + "&DOB=" + dob_selector.GetDate());
}
}
protected void SaveUserInput(Decimal CourseID)
{
USTTIDataAccess data = new USTTIDataAccess();
Course course = new Course();
course.CourseID = CourseID;
course.Title = txtTitle.Text;
course.Location = txtLocation.Text;
course.Coordinator = txtCoordinator.Text;
course.StartDate = start_date.GetDate();
course.EndDate = end_date.GetDate();
course.Comments = txtComment.Text;
course.Slots = txtSlot.Text;
course.SID = SponsorList.SelectedValue;
course.MoreSponsor = MoreSponsorRadioButtonList.SelectedValue;
course.Year = YearList.Text;
data.UpdateCourseRecord(course);
}
protected void SaveUserInputEdit(Decimal SponsorID)
{
USTTIDataAccess data = new USTTIDataAccess();
Sponsor sp = new Sponsor();
sp.SponsorID = SponsorID;
sp.SponsorName = txtSponsorName.Text.Trim();
sp.SponsorAbbr = txtAbbr.Text.Trim();
sp.Contact = txtContactPerson.Text.Trim();
sp.Address = txtAddress.Text.Trim();
sp.City = txtCity.Text.Trim();
sp.State = txtState.Text.Trim();
sp.Phone1 = txtPhoneNbr1.Text.Trim();
sp.Phone2 = txtPhoneNbr2.Text.Trim();
sp.Fax = txtFax.Text.Trim();
sp.Email = txtEmail.Text.Trim();
sp.Comment = txtComment.Text.Trim();
data.UpdateSponsorRecord(sp);
Response.Redirect("sponsor_edit_record.aspx?SponsorID=" + SponsorID);
}
private DataTable GetResultsData()
{
USTTISessionCollection SessionList = SessionManager.getSessionList();
String sql = "select * from ad_hoc_sponsors ";
sql = sql + " where 1 = 1 ";
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Course"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Course Num"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Sponsor"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Year"));
sql = sql + UtilManager.addMultipleStmtToWhereClause(SessionList.Get("Years"));
sql = sql + GetSortExpression();
USTTIDataAccess data = new USTTIDataAccess();
DataTable dt = data.Fill(sql);
return(dt);
}
private DataTable GetResultsData()
{
USTTISessionCollection SessionList = SessionManager.getSessionList();
String sql = "select * from ad_hoc_funders ";
sql = sql + " where 1 = 1 ";
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Title"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Name"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Type"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("First"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Last"));
sql = sql + GetSortExpression();
USTTIDataAccess data = new USTTIDataAccess();
DataTable dt = data.Fill(sql);
return(dt);
}
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);
}
