// POST api/Usuario public void Post([FromBody] string value) { Models.User user = JsonConvert.DeserializeObject <Models.User>(value); Models.ToastDataContext dc = new Models.ToastDataContext(); //dc.Usuarios.InsertOnSubmit( // new Models.Usuario { Nome = user.Nome, Url = user.Url }); // Verifica se usuário existe var listUser = from f in dc.Usuarios where string.Equals(f.Nome, user.Nome) select f; if (listUser.Count() == 0) { dc.Usuarios.InsertOnSubmit( new Models.Usuario { Nome = user.Nome, Uri = user.Uri }); } else { Models.Usuario x = listUser.FirstOrDefault(); x.Uri = user.Uri; } dc.SubmitChanges(); }
// DELETE api/Usuario/5 public void Delete(int id) { Models.ToastDataContext dc = new Models.ToastDataContext(); var x = (from f in dc.Usuarios where f.Id == id select f).Single(); dc.Usuarios.DeleteOnSubmit(x); dc.SubmitChanges(); }
// GET api/usuario public IEnumerable <Models.User> Get() { Models.ToastDataContext dc = new Models.ToastDataContext(); var r = from f in dc.Usuarios select new Models.User { Id = f.Id, Nome = f.Nome, Uri = f.Uri }; return(r.ToList()); }
// PUT api/Usuario/5 public void Put(int id, [FromBody] string value) { Models.User user = JsonConvert.DeserializeObject <Models.User>(value); Models.ToastDataContext dc = new Models.ToastDataContext(); var x = (from f in dc.Usuarios where f.Id == id select f).Single(); x.Nome = user.Nome; x.Uri = user.Uri; dc.SubmitChanges(); }