public IHttpActionResult getData(string commandStr) { if (commandStr == null || commandStr == "") { return(Ok("error")); } List <testPersonDTO> list = new List <testPersonDTO>(); using (SqlConnection con = new SqlConnection("Data Source=tcp:rezija2roj.database.windows.net,1433;Initial Catalog=test;User ID=demo;Password=zaq1@WSX;")) { con.Open(); using (SqlCommand com = new SqlCommand(commandStr, con)) { using (SqlDataReader reader = com.ExecuteReader()) { while (reader.Read()) { testPersonDTO tmp = new testPersonDTO(); tmp.ID = reader.GetInt32(0); tmp.login = reader.GetString(1); tmp.email = reader.GetString(2); tmp.password = reader.GetString(3); list.Add(tmp); } } } con.Close(); } return(Ok(list)); }
public IHttpActionResult PutData(testPersonDTO person) { using (SqlConnection con = new SqlConnection("Data Source=tcp:rezija2roj.database.windows.net,1433;Initial Catalog=test;User ID=demo;Password=zaq1@WSX;")) { con.Open(); using (SqlCommand com = new SqlCommand("insert into TestPersons (Login,email,Password) " + " values('" + person.login + "','" + person.email + "','" + person.password + "' );", con)) { com.ExecuteNonQuery(); } con.Close(); } return(Ok("Inserted")); }