// POST api/login
public HttpResponseMessage Post(User user)
{
if (ModelState.IsValid && user != null) {
if (user.Name == null) user.Name = "null";
if (user.Password == null) user.Password = "******";
DataConnection connection = new DataConnection("localhost", "user", "root", "testing");
connection.PerformNonQuery("INSERT INTO `users` (`id`,`name`,`password`) VALUES (NULL, \"" + user.Name + "\", \"" + user.Password + "\")");
return new HttpResponseMessage(HttpStatusCode.OK);
}
else {
return new HttpResponseMessage(HttpStatusCode.BadRequest);
}
}
// GET api/login/5
public string Get(string name, string password)
{
DataConnection connection = new DataConnection("localhost", "user", "root", "testing");
MySqlDataReader dr = connection.GetAll("users");
while (dr.Read()) {
if ((string)dr["name"] == name && (string)dr["password"] == password) {
connection.Close();
return "Successful login";
}
}
connection.Close();
return "Wrong name or password";
}
// GET api/login
public IEnumerable<User> Get()
{
List<User> list = new List<User>();
DataConnection connection = new DataConnection("localhost", "user", "root", "testing");
MySqlDataReader dr = connection.GetAll("users");
while (dr.Read()) {
User p = new User();
p.Name = dr["name"].ToString();
p.Password = "******";
list.Add(p);
}
connection.Close();
return list.ToArray();
}
// GET api/patient
public IEnumerable<Patient> Get()
{
List<Patient> list = new List<Patient>();
DataConnection connection = new DataConnection("localhost", "health", "root", "testing");
MySqlDataReader dr = connection.GetAll("patients");
while (dr.Read()) {
Patient p = new Patient();
p.id = int.Parse(dr["id"].ToString());
p.name = dr["name"].ToString();
p.surname = dr["surname"].ToString();
p.telephonenumber = dr["telephonenumber"].ToString();
list.Add(p);
}
connection.Close();
return list.ToArray();
}
