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); }