// 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(); }