public string GetForm() { string sqlResult = ""; try { sqlResult = SQLHandler.ExecuteQuery("SELECT * FROM dbo.forms"); } catch (Exception ex) { Console.Write(ex); return("Unable to get form: " + ex); } return(sqlResult); }
public async Task <string> PostFormData() { string sqlResult = ""; using (var reader = new StreamReader(Request.Body)) { dynamic form = Newtonsoft.Json.JsonConvert.DeserializeObject(await reader.ReadToEndAsync()); string query = String.Format("INSERT INTO forms VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}');", form.project_id, form.project_title, form.deadline, form.pi_name, form.pi_email, form.sponsor_name, form.proposal_url, form.preferred_submission, form.opportunity_number, form.nsf_proposal_number, form.nsf_pin_number, form.project_start, form.project_end, form.estimated_budget, form.budget_items, form.extra_space, form.space_details, form.course_buyout, form.buyout_details, form.applicant_role, form.additional_info ); try { sqlResult = SQLHandler.ExecuteQuery(query); } catch (Exception ex) { return("Error storing form:" + ex); } } return(sqlResult); }
static void Main(string[] args) { string pword = ConfigurationManager.AppSettings["SQL_PASSWORD"]; Console.WriteLine(pword.Length); SQLHandler data = new SQLHandler(); //ParameterSQL string conn = data.GetConnectionString("ZPC_App_Dev", "Dev"); Console.WriteLine(conn); //DataSet result = data.ExecuteQuery("CFE_Kiosk", "Dev", "StatesGET", null); DataSet result = data.ExecuteQuery("StatesGET", null); if (result.Tables.Count > 0) { foreach (DataRow row in result.Tables[0].Rows) { Debug.WriteLine(row["StateName"].ToString()); } } }