/// <summary>
/// Adds the message to the db and returns it if it succeeds in adding it
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public Message AddMessage(Message m)
{
using (SportsChatQueries query = new SportsChatQueries(new SportsChatEntities()))
{
query.AddMessage(m);
Message addedMessage = query.GetMessageByUserAndDate(m.UserId, m.DateCreated);
return (addedMessage != null) ? addedMessage : null;
}
}
public void UpdateMessage(Message m)
{
ctx.Entry(m).State = System.Data.Entity.EntityState.Modified;
try
{
ctx.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void RemoveMessage(Message m)
{
ctx.Messages.Remove(m);
try
{
ctx.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public bool DeleteMessage(Message m)
{
using (SportsChatQueries query = new SportsChatQueries(new SportsChatEntities()))
{
Message messageToDelete = query.GetMessageById(m.Id);
if (messageToDelete != null)
{
query.RemoveMessage(messageToDelete);
return true;
}
}
return false;
}