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