public Tarea.Modelos.Tarea Eliminar(Tarea.Modelos.Tarea tarea)
{
_tareaRepo.Delete(tarea);
_uow.Commit();
return tarea;
}
public Tarea.Modelos.Tarea Agregar(Tarea.Modelos.Tarea tarea)
{
_tareaRepo.Insert(tarea);
_uow.Commit();
return tarea;
}
private static List <Tarea> consultarTarea(string proyecto)
{
gestor.GestorBaseDatos DbConnection = new gestor.bd.PostgresBaseDatos("35.239.31.249", "postgres", "5432", "E@05face", "asana_upgradedb");
List <Tarea> result = new List <Tarea>();
Object[][] tareas = DbConnection.consultar(new Consulta().Select("*").From("Tarea t")
.Where(
String.Format("id_proyecto = {0} AND \"id_tareaPadre\" IS NULL AND EXISTS ({1})", proyecto,
new Consulta().Select("*").From("tareaporseccion ts").Where("t.id_tarea = ts.id_seccion").Get()))
.OrderBy("t.nombre").Get(), 8);
for (int i = 0; i < tareas.Count(); i++)
{
String[] datosTarea = Array.ConvertAll(tareas[i], p => (p ?? String.Empty).ToString());
Tarea t = new Tarea();
Int64 id = 0;
if (Int64.TryParse(datosTarea[0], out id))
{
t.codigo = datosTarea[0];
t.tareas = consultarTareaHijas(id, proyecto, true); //RETORNA 0 SIEMPRE
}
Usuario encargado = DAOUsuario.consultarUsuario(datosTarea[1]);
if (encargado == null)
{
Console.WriteLine("tarea " + t.codigo + " no tiene encargado");
}
//TODO: Asignar Seguidores
t.encargado = encargado;
t.seguidores = asignarSeguidores(t.codigo);
string fechaprueba;
try
{
fechaprueba = datosTarea[2].Split()[0];
t.fchFinalizacion = DateTime.ParseExact(fechaprueba, "d/M/yyyy", CultureInfo.InvariantCulture);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
try
{
fechaprueba = datosTarea[3].Split()[0];
t.fchEntrega = DateTime.ParseExact(fechaprueba, "d/M/yyyy", CultureInfo.InvariantCulture);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
t.nombre = datosTarea[4];
t.notas = datosTarea[5];
consultarAvances(t);
result.Add(t);
}
return(result);
}
public ActionResult Create(Tarea tarea)
{
if (ModelState.IsValid)
{
context.Tareas.Add(tarea);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tarea));
}
public DialogoTarea(Logica logica)
{
InitializeComponent();
this.logica = logica;
modificar = false;
// Para la creación de Tareas
tarea = new Tarea();
DataContext = tarea;
}
public int InsertarTarea(Tarea obj)
{
var Respuesta = GenericHelper
.Request <int>(
Url: $"{ApiUri}/Tareas",
Method: HttpMethodEnum.PostJson,
Data: obj
);
return(Respuesta);
}
private void dgvDONE_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Tarea tareaSeleccionada = (Tarea)dgvDONE.CurrentRow.DataBoundItem;
VerEditarTAREA vistaTarea = new VerEditarTAREA();
vistaTarea.recibirDataTablero(tareaSeleccionada, userLogueado, tableroEnUso);
AddOwnedForm(vistaTarea);
this.Hide();
vistaTarea.ShowDialog();
this.Show();
}
public void Guardar(Tarea tarea)
{
if (tarea.TareaId != null)
{
new dalTarea().Modificar(tarea);
}
else
{
new dalTarea().Insertar(tarea);
}
}
public async Task <IActionResult> Create([Bind("Descripcion")] Tarea tarea)
{
if (ModelState.IsValid)
{
_context.Add(tarea);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tarea));
}
public ActionResult Completar(int id)
{
Tarea t = ctx.Tarea.SingleOrDefault(o => o.IdTarea == id);
if (t != null)
{
t.Completada = 1;
ctx.SaveChanges();
}
return(Redirect(Request.UrlReferrer.ToString()));
}
public async Task <IActionResult> OnGetAsync(int id)
{
if (id == 0)
{
return(RedirectToPage("/pagina/Productos/GetProduct"));
}
var _tarea = await _TareaService.GetTareaAsync(id : id);
this.Tarea = _tarea;
return(Page());
}
public async Task <ActionResult <Tarea> > CreateTareaAsync([FromBody] Tarea tarea)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Tarea tareaCreada = await _servicio.CreateTareaAsync(tarea);
return(Ok(tareaCreada));
}
private async void lsvTareas_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
try
{
Tarea dato = (Tarea)e.SelectedItem;
await Navigation.PushAsync(new PaginaDetalleTarea(dato));
}
catch (Exception ex)
{
}
}
public void ModificarEstado(Tarea tarea)
{
try
{
tareaDAO.CambiarEstado(tarea);
}
catch (Exception ex)
{
throw ex;
}
}
public void ModificarDatos(Tarea tarea)
{
try
{
tareaDAO.Modificar(tarea);
}
catch (Exception ex)
{
throw ex;
}
}
public void Insertar(Tarea tarea, int temaId)
{
try
{
tareaDAO.Insertar(tarea, temaId);
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult GetTarea(string id)
{
Tarea tarea = db.Tareas.Find(id);
if (tarea == null)
{
return(NotFound());
}
return(Ok(tarea));
}
public async Task <IActionResult> PutTarea(int id, Tarea tarea)
{
if (id != tarea.Id)
{
return(BadRequest());
}
_context.Entry(tarea).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(NoContent());
}
public ActionResult Edit([Bind(Include = "id_tarjetaRequerim,descripcion")] Tarea tarea)
{
if (ModelState.IsValid)
{
db.Entry(tarea).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_tarjetaRequerim = new SelectList(db.TarjetaRequerim, "id_tarjetaRequerim", "id_tarjetaRequerim", tarea.id_tarjetaRequerim);
return(View(tarea));
}
public ActionResult Edit([Bind(Include = "Id,Codigo,Nombre,Costo,TipoId")] Tarea tarea)
{
if (ModelState.IsValid)
{
db.Entry(tarea).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TipoId = new SelectList(db.TipoTareas, "Id", "Nombre", tarea.TipoId);
return(View(tarea));
}
public IActionResult DeleteDeber(int id)
{
Tarea tarea = _repo.GetById(id);
if (tarea == null)
{
return(NotFound());
}
_repo.Delete(tarea);
return(Ok());
}
public PaginaDetalleTarea(Tarea dato)
{
InitializeComponent();
ActualizarActivityIndicator(true);
this.dato = dato;
this.BindingContext = dato;
ActualizarActivityIndicator(false);
}
public Task <int> SaveTareaAsync(Tarea tarea)
{
if (tarea.Id != 0)
{
return(_database.UpdateAsync(tarea));
}
else
{
return(_database.InsertAsync(tarea));
}
}
public bool ModificarTarea(Tarea obj)
{
var Respuesta = GenericHelper
.Request <bool>(
Url: $"{ApiUri}/Tareas",
Method: HttpMethodEnum.PutJson,
Data: obj
);
return(Respuesta);
}
public IActionResult Delete(int id)
{
Tarea byId = this._repo.GetById(id);
if (byId == null)
{
return((IActionResult)((ControllerBase)this).NotFound());
}
this._repo.Delete(byId);
return((IActionResult)((ControllerBase)this).NoContent());
}
public HttpResponseMessage Guardar(Tarea.Modelos.Tarea Tarea)
{
if (ModelState.IsValid)
{
_tareaServicio.Agregar(Tarea);
return Request.CreateResponse(Tarea);
}
else
{
return Request.CreateResponse(HttpStatusCode.BadRequest, ModelState);
}
}
public void Update(Tarea myObject)
{
try
{
_repository.Update(myObject);
_unitOfWork.Commit();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Tarea EditTarea(Tarea value)
{
Tarea tareaeditar = _context.Tarea.Find(value.Id);
tareaeditar.Titulo = value.Titulo;
tareaeditar.Vencimiento = value.Vencimiento;
tareaeditar.Estimacion = value.Estimacion;
tareaeditar.ResponsableId = value.ResponsableId;
tareaeditar.Estado = value.Estado;
_context.SaveChanges();
return(value);
}
public IHttpActionResult PostTarea(Tarea tarea)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Tareas.Add(tarea);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tarea.Id }, tarea));
}
public ActionResult Create([Bind(Include = "Id,Descripcion,FechaInicio,FechaFin,HoraInicio,HoraFin,Empleado_Id")] Tarea tarea)
{
if (ModelState.IsValid)
{
db.Tarea.Add(tarea);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Empleado_Id = new SelectList(db.Empleado, "Id", "Nombre", tarea.Empleado_Id);
return(View(tarea));
}
public ActionResult Create([Bind(Include = "codigo,nombre,descripcion,codigo_proyecto")] Tarea tarea)
{
if (ModelState.IsValid)
{
db.Tarea.Add(tarea);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.codigo_proyecto = new SelectList(db.Proyecto, "codigo", "nombre", tarea.codigo_proyecto);
return(View(tarea));
}
public void EliminarTarea(int?id)
{
Tarea miTarea = ObtenerTarea(id);
var tareas = bdTareas.Tarea;
foreach (Tarea t in tareas)
{
bdTareas.Tarea.Remove(miTarea);
}
bdTareas.SaveChanges();
}
public static StringContent GetNewInvalidTareaJson()
{
var nuevaTarea = new Tarea()
{
Name = "",
IsComplete = _isComplete
};
var jsonContent = new StringContent(JsonSerializer.Serialize <Tarea>(nuevaTarea), Encoding.UTF8, "application/json");
return(jsonContent);
}
public HttpResponseMessage Eliminar(Tarea.Modelos.Tarea Tarea)
{
_tareaServicio.Eliminar(Tarea);
return Request.CreateResponse(200);
}
public ActionResult Agregar(Tarea.Modelos.Tarea tarea)
{
_tareaServicio.Agregar(tarea);
var tareas = _tareaServicio.Listar();
return RedirectToAction("Listar");
}
