public IHttpActionResult Post(MessageModel m) { if (m != null) { try { m.Id = Guid.NewGuid(); m.WasRead = false; MessageSqlDbAccess.Add(m); logger.Info($"MessageController.Post successfully added {m.Print()}"); return(Ok()); } catch (Exception ex) { logger.Info($"MessageController.Post threw error {ex.Message} trying to add {m.Print()}"); return(BadRequest()); } } else { logger.Info($"MessageController.Post failed to add {m.Print()}"); return(BadRequest()); } }
public IHttpActionResult Delete(Guid Id) { try { MessageSqlDbAccess.Delete(Id); logger.Info($"MessageController.Delete successfully deleted id {Id}"); return(Ok()); } catch (Exception ex) { logger.Info($"MessageController.Delete threw error {ex.Message} trying to delete {Id}"); return(BadRequest()); } }
public IHttpActionResult Put(Guid Id, [FromBody] MessageModel m) { if (m != null) { try { MessageModel original = MessageSqlDbAccess.GetById(Id); if (m.WasRead != null) { original.WasRead = m.WasRead; } if (m.FullName != null) { original.FullName = m.FullName; } if (m.Email != null) { original.Email = m.Email; } if (m.Message != null) { original.Message = m.Message; } MessageSqlDbAccess.Update(original); logger.Info($"MessageController.Put successfully edited {m.Print()}"); return(Ok()); } catch (Exception ex) { logger.Info($"MessageController.Put threw error {ex.Message} trying to edit {m.Print()}"); return(BadRequest()); } } else { logger.Info($"MessageController.Put failed to edit {m.Print()}"); return(BadRequest()); } }
public IHttpActionResult Put(PersonModel p) { if (p != null) { try { MessageSqlDbAccess.Update(p); logger.Info($"PersonController.Put successfully edited {p.Print()}"); return(Ok()); } catch (Exception ex) { logger.Info($"PersonController.Put threw error {ex.Message} trying to edit {p.Print()}"); return(BadRequest()); } } else { logger.Info($"PersonController.Post failed to edit {p.Print()}"); return(BadRequest()); } }
public void Test_MessageSqlDbCRUD() { Guid[] guids = new Guid[] { new Guid("F7AB131E-354C-4698-A673-BB27D0D0D64F"), new Guid("92115905-9A48-4A17-9521-E35560F74674") }; /* Create */ // DB before changes List <MessageModel> before = MessageSqlDbAccess.GetAll(); // Changes MessageSqlDbAccess.Add( new Models.ContactMe.MessageModel { Id = guids[0], WasRead = false, FullName = "Michael Corso", Email = "*****@*****.**", Message = "This is a test message." } ); // DB after changes List <MessageModel> after = MessageSqlDbAccess.GetAll(); // Assert Assert.True(after.Count - before.Count == 1); /* Update */ // DB before changes before = MessageSqlDbAccess.Search("John Corso"); foreach (MessageModel m in before) { output.WriteLine(m.Print()); } // Changes MessageSqlDbAccess.Update( new Models.ContactMe.MessageModel { Id = guids[0], WasRead = true, FullName = "John Corso", Email = "*****@*****.**", Message = "This is a test message." } ); // After changes after = MessageSqlDbAccess.Search("John Corso"); foreach (MessageModel m in after) { output.WriteLine(m.Print()); } // Assert Assert.True(after.Count - before.Count == 1); /* Delete */ // Changes PersonSqlDbAccess.Delete(guids[0]); //PersonSqlDbAccess.Delete(guids[1]); // Assert Assert.True(PersonSqlDbAccess.GetPersonById(guids[0]) == null); //Assert.True(PersonSqlDbAccess.GetPersonById(guids[1]) == null); }
public JsonResult <MessageModel> Get(Guid Id) { return(Json <MessageModel>(MessageSqlDbAccess.GetById(Id))); }
public JsonResult <IEnumerable <MessageModel> > Get() { return(Json <IEnumerable <MessageModel> >(MessageSqlDbAccess.GetAll())); }
public JsonResult <PersonModel> Get(int Id) { return(Json <PersonModel>(MessageSqlDbAccess.GetPersonById(Id))); }