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