public Tareas GetTareaById(String id)
{
Tareas tarea = (from t in ctx.Tareas
where t.Id_Tarea.ToString().Equals(id)
select t).FirstOrDefault <Tareas>();
return(tarea);
}
public int InsertarNuevaTarea(Tareas newTask)
{
try
{
newTask.Id_Tarea = Guid.NewGuid();
ctx.Tareas.InsertOnSubmit(newTask);
ctx.SubmitChanges();
}
catch (Exception)
{
return(1);
}
return(0);
}
public int DeleteTarea(String id)
{
try
{
Tareas tareaBD = this.GetTareaById(id);
ctx.Tareas.DeleteOnSubmit(tareaBD);
ctx.SubmitChanges();
}
catch (Exception)
{
return(1);
}
return(0);
}
public int ModificarTarea(Tareas modifyTask)
{
try
{
Tareas tareaBD = this.GetTareaById(modifyTask.Id_Tarea.ToString());
tareaBD.Fk_Usuario = modifyTask.Fk_Usuario;
tareaBD.NombreTarea = modifyTask.NombreTarea;
tareaBD.DescripcionTarea = modifyTask.DescripcionTarea;
tareaBD.PrioridadTarea = modifyTask.PrioridadTarea;
ctx.SubmitChanges();
}
catch (Exception)
{
return(1);
}
return(0);
}
public List <Tareas> GetTareas(String userId)
{
List <Tareas> tareas = new List <Tareas>();
var results = (from t in ctx.Tareas
where t.Fk_Usuario.ToString().Equals(userId)
select new { ID_USUARIO = t.Fk_Usuario,
TAREA = t.NombreTarea,
DESCRIPCION = t.DescripcionTarea,
ID_TAREA = t.Id_Tarea,
PRIORIDAD = t.PrioridadTarea }).ToList();
foreach (var aux in results)
{
Tareas currentTask = new Tareas();
currentTask.Fk_Usuario = aux.ID_USUARIO;
currentTask.Id_Tarea = aux.ID_TAREA;
currentTask.NombreTarea = aux.TAREA;
currentTask.DescripcionTarea = aux.DESCRIPCION;
currentTask.PrioridadTarea = aux.PRIORIDAD;
tareas.Add(currentTask);
}
return(tareas);
}
private void detach_Tareas(Tareas entity)
{
this.SendPropertyChanging();
entity.Usuarios = null;
}
private void attach_Tareas(Tareas entity)
{
this.SendPropertyChanging();
entity.Usuarios = this;
}
partial void DeleteTareas(Tareas instance);
partial void UpdateTareas(Tareas instance);
partial void InsertTareas(Tareas instance);
