public void InsertStudentRecord(USTTI.Base.Student objStudentTbl)
{
string sql = "insert into student values(" + objStudentTbl.StudentID + ",'" + objStudentTbl.Honorific + "','" + objStudentTbl.FirstName +
"','" + objStudentTbl.MiddleName + "','" + objStudentTbl.LastName + "','" + objStudentTbl.Suffix + "','" + objStudentTbl.DOB + "','" + objStudentTbl.Sex +
"','" + objStudentTbl.Org1 + "','','" + objStudentTbl.Title + "','" + objStudentTbl.Addr1 + "','','" + objStudentTbl.City + "','" + objStudentTbl.ZipCode + "','" + objStudentTbl.BusPhone +
"','" + objStudentTbl.HomePhone + "','" + objStudentTbl.Fax + "','" + objStudentTbl.CellPhone + "','" + objStudentTbl.BusEmail + "','" + objStudentTbl.PerEmail +
"','" + objStudentTbl.SpvrName + "','" + objStudentTbl.SpvrTitle + "','" + objStudentTbl.SpvrEmail + "','','" + objStudentTbl.PNG + "','" + objStudentTbl.Memo + "','" +
objStudentTbl.HomeAddr1 + "','','" + objStudentTbl.HomeCity + "'," + objStudentTbl.CountryID + ",'" + objStudentTbl.HomeZipCode + "','" + objStudentTbl.PassNum + "','" + objStudentTbl.PassExpDate +
"'," + objStudentTbl.PassCountry + ",'" + objStudentTbl.LastUpdateTime + "','" + objStudentTbl.ReadingSkill + "','" + objStudentTbl.WritingSkill + "','" + objStudentTbl.SpeakingSkill + "','" + objStudentTbl.ComprehensionSkill + "')";
ExecuteNonQuery(sql);
}
public void UpdateStudentRecord(USTTI.Base.Student objStudentTbl)
{
string sql = "UPDATE student SET honorific='" + objStudentTbl.Honorific + "',firstname='" + objStudentTbl.FirstName +
"',middlename='" + objStudentTbl.MiddleName + "',lastname='" + objStudentTbl.LastName + "',suffix='" + objStudentTbl.Suffix + "',dob='" + objStudentTbl.DOB + "',sex='" + objStudentTbl.Sex +
"',org='" + objStudentTbl.Org1 + "',title='" + objStudentTbl.Title + "',address1='" + objStudentTbl.Addr1 + "',city='" + objStudentTbl.City + "',zipcode='" + objStudentTbl.ZipCode + "',busphone='" + objStudentTbl.BusPhone +
"',homephone='" + objStudentTbl.HomePhone + "',fax='" + objStudentTbl.Fax + "',cellphone='" + objStudentTbl.CellPhone + "',busemail='" + objStudentTbl.BusEmail + "',homeemail='" + objStudentTbl.PerEmail +
"',supername='" + objStudentTbl.SpvrName + "',supertitle='" + objStudentTbl.SpvrTitle + "',superemail='" + objStudentTbl.SpvrEmail + "',invalidadd='',png='" + objStudentTbl.PNG + "',memo='" + objStudentTbl.Memo + "',homeaddress1='" + objStudentTbl.HomeAddr1 + "'," +
"homecity='" + objStudentTbl.HomeCity + "',countryid=" + objStudentTbl.CountryID + ",homezipcode='" + objStudentTbl.HomeZipCode + "',passportnum='" + objStudentTbl.PassNum + "',passexpdate='" + objStudentTbl.PassExpDate + "',passportcountryid=" +
objStudentTbl.PassCountry + ",lastupdatetime='" + DateTime.Now + "',readingskill='" + objStudentTbl.ReadingSkill + "',speakingskill='" + objStudentTbl.SpeakingSkill + "',writingskill='" + objStudentTbl.WritingSkill + "',comprehensionskill='" + objStudentTbl.ComprehensionSkill + "' " +
"WHERE studentid=" + objStudentTbl.StudentID;
ExecuteNonQuery(sql);
}
public USTTI.Base.Student GetStudentInfo(Decimal StudentID)
{
USTTI.Base.Student StudentInfo = new USTTI.Base.Student();
string sql = "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=" + StudentID;
DataTable dt = Fill(sql);
StudentInfo.Honorific = Convert.ToString(dt.Rows[0]["honorific"]).Trim();
StudentInfo.FirstName = Convert.ToString(dt.Rows[0]["firstname"]).Trim();
StudentInfo.MiddleName = Convert.ToString(dt.Rows[0]["middlename"]).Trim();
StudentInfo.LastName = Convert.ToString(dt.Rows[0]["lastname"]).Trim();
StudentInfo.Suffix = Convert.ToString(dt.Rows[0]["suffix"]).Trim();
StudentInfo.DOB = Convert.ToDateTime(dt.Rows[0]["dob"]);
StudentInfo.Sex = Convert.ToString(dt.Rows[0]["sex"]).Trim();
StudentInfo.Org1 = Convert.ToString(dt.Rows[0]["org"]).Trim();
StudentInfo.Title = Convert.ToString(dt.Rows[0]["title"]).Trim();
StudentInfo.Addr1 = Convert.ToString(dt.Rows[0]["address1"]).Trim();
StudentInfo.City = Convert.ToString(dt.Rows[0]["city"]).Trim();
StudentInfo.ZipCode = Convert.ToString(dt.Rows[0]["zipcode"]).Trim();
StudentInfo.BusPhone = Convert.ToString(dt.Rows[0]["busphone"]).Trim();
StudentInfo.HomePhone = Convert.ToString(dt.Rows[0]["homephone"]).Trim();
StudentInfo.Fax = Convert.ToString(dt.Rows[0]["fax"]).Trim();
StudentInfo.CellPhone = Convert.ToString(dt.Rows[0]["cellphone"]).Trim();
StudentInfo.BusEmail = Convert.ToString(dt.Rows[0]["busemail"]).Trim();
StudentInfo.PerEmail = Convert.ToString(dt.Rows[0]["homeemail"]).Trim();
StudentInfo.SpvrName = Convert.ToString(dt.Rows[0]["supername"]).Trim();
StudentInfo.SpvrTitle = Convert.ToString(dt.Rows[0]["supertitle"]).Trim();
StudentInfo.SpvrEmail = Convert.ToString(dt.Rows[0]["superemail"]).Trim();
StudentInfo.PNG = Convert.ToString(dt.Rows[0]["png"]).Trim();
StudentInfo.Memo = Convert.ToString(dt.Rows[0]["memo"]).Trim();
StudentInfo.Addr1 = Convert.ToString(dt.Rows[0]["homeaddress1"]).Trim();
StudentInfo.HomeCity = Convert.ToString(dt.Rows[0]["city"]).Trim();
StudentInfo.HomeZipCode = Convert.ToString(dt.Rows[0]["homezipcode"]).Trim();
StudentInfo.CountryID = Convert.ToInt32(dt.Rows[0]["countryid"]);
StudentInfo.CountryName = Convert.ToString(dt.Rows[0]["countryname"]).Trim();
StudentInfo.PassNum = Convert.ToString(dt.Rows[0]["passportnum"]).Trim();
StudentInfo.PassCountry = Convert.ToInt32(dt.Rows[0]["passportcountryid"]);
StudentInfo.PassExpDate = Convert.ToDateTime(dt.Rows[0]["passexpdate"]);
StudentInfo.ReadingSkill = Convert.ToString(dt.Rows[0]["readingskill"]);
StudentInfo.WritingSkill = Convert.ToString(dt.Rows[0]["writingskill"]).Trim();
StudentInfo.SpeakingSkill = Convert.ToString(dt.Rows[0]["speakingskill"]).Trim();
StudentInfo.ComprehensionSkill = Convert.ToString(dt.Rows[0]["comprehensionskill"]).Trim();
return(StudentInfo);
}
