public static Task GetTasksByUserId(int userId,Guid taskId)
{
using (var context = new ToDoEntities())
{
return context.Tasks.FirstOrDefault(x => x.UserId == userId && x.TaskId == taskId);
}
}
public static List<Task> GetTasksByUserId(int userId)
{
using (var context = new ToDoEntities())
{
return context.Tasks.Where(x=>x.UserId==userId).ToList();
}
}
public static bool Edit(Task editedTask, Guid taskIdTobeEdited)
{
using (var context = new ToDoEntities())
{
var selectedtask = context.Tasks.FirstOrDefault(x => x.TaskId == taskIdTobeEdited);
if (selectedtask != null)
{
selectedtask.Reminder = editedTask.Reminder;
selectedtask.Attachments = editedTask.Attachments;
selectedtask.Detail = editedTask.Detail;
selectedtask.DueDate = editedTask.DueDate;
selectedtask.TaskAndSub = editedTask.TaskAndSub;
selectedtask.Title = editedTask.Title;
selectedtask.UserId = editedTask.UserId;
context.SaveChanges();
}
}
return false;
}
public static bool Add(ToDo.Models.Task task, out Guid newTaskId)
{
using (var context = new ToDoEntities())
{
newTaskId = Guid.Empty;
try
{
newTaskId = Guid.NewGuid();
task.TaskId = newTaskId;
context.Tasks.Add(task);
context.SaveChanges();
return true;
}
catch
{
return false;
}
}
}
