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);