public bool Add(Task task)
{
using (ToDoManagerDatabaseEntities context = new ToDoManagerDatabaseEntities())
{
try
{
context.Task.Add(MappingToModelTask(task));
context.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}
}
public string Get(string id)
{
try
{
int contactId = Convert.ToInt32(id);
using (ToDoManagerDatabaseEntities context = new ToDoManagerDatabaseEntities())
{
Models.Task task = context.Task.SingleOrDefault(u => Convert.ToInt32(u.Id) == contactId);
if (task != null)
{
return JsonConvert.SerializeObject(new List<Task>() { MappingTask(task) });
}
return null;
}
}
catch (Exception)
{
return null;
}
}
public bool Delete(string id)
{
int contactId = Convert.ToInt32(id);
using (ToDoManagerDatabaseEntities context = new ToDoManagerDatabaseEntities())
{
Models.Task task = context.Task.First(u => Convert.ToInt32(u.Id) == contactId);
if (task != null)
{
try
{
context.Task.Remove(task);
context.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}
return false;
}
}
public string GetAll(string id)
{
try
{
int userId = Convert.ToInt32(id);
using (ToDoManagerDatabaseEntities context = new ToDoManagerDatabaseEntities())
{
return JsonConvert.SerializeObject(context.Task.Where(t => t.UserId == userId).Select(x => MappingTask(x)));
}
}
catch (Exception)
{
return null;
}
}
public bool Put(Task task)
{
using (ToDoManagerDatabaseEntities context = new ToDoManagerDatabaseEntities())
{
Models.Task oldTask =
context.Task.SingleOrDefault(u => Convert.ToInt32(u.Id) == Convert.ToInt32(task.Id));
if (oldTask == null)
{
try
{
context.Task.Add(MappingToModelTask(task));
context.SaveChanges();
return true;
}
catch
{
return false;
}
return true;
}
else
{
try
{
context.Task.Remove(oldTask);
context.SaveChanges();
context.Task.Add(MappingToModelTask(task));
context.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}
}
}
