Exemplo n.º 1
0
        public STAFApplication getSTAFApplication(string applicantName)
        {
            var _stafApplication = new STAFApplication();

            string _queryString = "SELECT * FROM Table";

            SqlConnection sqlConn = new SqlConnection(conn);
            sqlConn.Open();
            SqlCommand cmd = new SqlCommand(_queryString, sqlConn);
            SqlDataAdapter _adapter = new SqlDataAdapter();

            return _stafApplication;
        }
Exemplo n.º 2
0
        public void addSTFApplication(STAFApplication 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.AdditionalFundsApplication1 + "'" + "," + "'" + app.AdditionalFundsApplication2 + "'" + "," + "'" +
                app.AdditionalFundsApplication3 + "'" + "," + "'" + app.FundingRequest + "')";

            SqlConnection sqlConn = new SqlConnection(conn);
            sqlConn.Open();
            SqlCommand cmd = new SqlCommand(_queryString, sqlConn);
            cmd.ExecuteScalar();
            sqlConn.Close();
        }