public bool Add(Task task) { using (TasksDatabaseEntities context = new TasksDatabaseEntities()) { 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 (TasksDatabaseEntities context = new TasksDatabaseEntities()) { 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 (TasksDatabaseEntities context = new TasksDatabaseEntities()) { 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 (TasksDatabaseEntities context = new TasksDatabaseEntities()) { return JsonConvert.SerializeObject(context.Task.Where(t => t.UserId == userId).Select(x => MappingTask(x))); } } catch (Exception) { return null; } }
public bool Put(Task task) { using (TasksDatabaseEntities context = new TasksDatabaseEntities()) { 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; } } } }