public void addSTFApplication(STFApplication app)
{
string _queryString = "INSERT INTO STFApplication () VALUES('" +
app.ApplicantName + "'" + "," + "'" + app.ApplicantContactNumber + "'" + "," + "'" + app.ApplicantEmailAddress + "'" + "," + "'" + app.ApplicationDate + "'" +
"," + "'" + app.ApplicationStatus + "'" + "," + "'" + app.EventName + "'" + "," + "'" + app.DateOfEvent + "'" + "," + "'" + app.DateOfEvent + "'" + "," + "'" + app.EndDate +
"'" + "," + "'" + app.Venue + "'" + "," + "'" + app.City + "'" + "," + "'" + app.Country + "'" + "," + "'" + app.Chairperson + "'" + "," + "'" + app.Secretery + "'" + "," + "'" +
app.Society + "'" + "," + "'" + app.TravelCost + "'" + "," + "'" + app.LocalTravelCosts + "'" + "," + "'" + app.DailySubsistence + "'" + "," + "'" +
app.RegistrationFees + "'" + "," + "'" + app.FundingAllocated1 + "'" + "," + "'" + app.FundingAllocated2 + "'" + "," + "'" + app.FundingAllocated3 + "'" + "," + "'" +
app.FundingAwaiting1 + "'" + "," + "'" + app.FundingAwaiting2 + "'" + "," + "'" + app.FundingAwaiting3 + "'" + "," + "'" + app.FundingRequested + "'" + "," + "'" + app.InvitationFile + "'" + "," + "'" +
app.MotivationFile + "'" + "," + "'" + app.OtherSocietySupportFile + "'" + "," + "'" + app.ProgrammesplannedFile + "'" + "," + "'" + app.QuotesFile + "'" + "," + "'" +
app.StudentsAttendingFile + "')";
SqlConnection sqlConn = new SqlConnection(conn);
sqlConn.Open();
SqlCommand cmd = new SqlCommand(_queryString, sqlConn);
cmd.ExecuteScalar();
sqlConn.Close();
}
public STFApplication getSTFApplication(string applicantName)
{
var _stfApplication = new STFApplication();
return _stfApplication;
}
