public entTarea ObtenerTarea(int TareaID, int ActividadID)
{
SqlCommand cmd = null;
entTarea tarea = new entTarea();
try
{
SqlConnection cn = Conexion.Instancia.Conectar();
cmd = new SqlCommand("spObtenerTarea", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@prmintTareaID", TareaID);
cmd.Parameters.AddWithValue("@prmintactividadID", ActividadID);
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
tarea.tareaID = Convert.ToInt16(dr["TareaID"]);
tarea.Actividad.ActividadID = Convert.ToInt16(dr["ActividadID"]);
tarea.nombreTarea = dr["Nombretarea"].ToString();
tarea.duracionTarea = Convert.ToInt16(dr["Duraciontarea"]);
tarea.numeroDeOperarios = Convert.ToInt16(dr["Numerooperariostarea"]);
}
}
catch (Exception e)
{
throw e;
}
finally { cmd.Connection.Close(); }
return(tarea);
}
public Boolean EditarTarea(entTarea tarea)
{
SqlCommand cmd = null;
Boolean edita = false;
try
{
SqlConnection cn = Conexion.Instancia.Conectar();
cmd = new SqlCommand("SP_EDITARTAREA", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@prmintTareaID", tarea.TareaID);
cmd.Parameters.AddWithValue("@prmstrNombretarea", tarea.Nombretarea);
cmd.Parameters.AddWithValue("@prmintNumerooperariostarea", tarea.Numerooperariostarea);
cmd.Parameters.AddWithValue("@prmintDuraciontarea", tarea.Duraciontarea);
cn.Open();
int i = cmd.ExecuteNonQuery();
if (i >= 0)
{
edita = true;
}
}
catch (Exception e)
{
throw e;
}
finally { cmd.Connection.Close(); }
return(edita);
}
public Boolean InsertarTarea(entTarea Tarea)
{
SqlCommand cmd = null;
Boolean Inserta = false;
try
{
SqlConnection cn = Conexion.Instancia.Conectar();
cmd = new SqlCommand("spInsertarTarea", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@prmintactividadID", Tarea.Actividad.ActividadID);
cmd.Parameters.AddWithValue("@prmstrNombreTarea", Tarea.nombreTarea);
cmd.Parameters.AddWithValue("@prmintDuracionTarea", Tarea.duracionTarea);
cmd.Parameters.AddWithValue("@prmintNumerooperariostarea", Tarea.numeroDeOperarios);
cn.Open();
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Inserta = true;
}
}
catch (Exception e)
{
throw e;
}
finally { cmd.Connection.Close(); }
return(Inserta);
}
public List <entTarea> ListarTareas()
{
SqlCommand cmd = null;
List <entTarea> lista = new List <entTarea>();
try
{
SqlConnection cn = Conexion.Instancia.Conectar();
cmd = new SqlCommand("SP_LISTARTAREAS", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
entTarea tarea = new entTarea();
tarea.TareaID = Convert.ToInt16(dr["TareaID"]);
tarea.Nombretarea = dr["Nombretarea"].ToString();
tarea.Duraciontarea = Convert.ToInt16(dr["Duraciontarea"]);
tarea.Numerooperariostarea = Convert.ToInt16(dr["Numerooperariostarea"]);
lista.Add(tarea);
}
}
catch (Exception e)
{
throw e;
}
finally { cmd.Connection.Close(); }
return(lista);
}
public ActionResult EditaTarea(int TareaID)
{
entTarea Tarea = logTarea.Instancia.ObtenerTarea(TareaID);
if (Tarea == null)
{
return(HttpNotFound());
}
return(View(Tarea));
}
public Boolean EditarTarea(entTarea Tarea)
{
try
{
return(datTarea.Instancia.EditarTarea(Tarea));
}
catch (Exception e)
{
throw e;
}
}
public entTarea ObtenerTarea(int tareaID, int actividadID)
{
try
{
entTarea edita = daoTarea.Instancia.ObtenerTarea(tareaID, actividadID);
return(edita);
}
catch (Exception e)
{
throw e;
}
}
public Boolean EditaTarea(entTarea tarea)
{
try
{
Boolean edita = daoTarea.Instancia.EditaTarea(tarea);
return(edita);
}
catch (Exception e)
{
throw e;
}
}
public Boolean InsertarTarea(entTarea tarea)
{
try
{
Boolean Inserta = daoTarea.Instancia.InsertarTarea(tarea);
return(Inserta);
}
catch (Exception e)
{
throw e;
}
}
public ActionResult NuevaTarea(entTarea Tarea)
{
try
{
Boolean inserta = logTarea.Instancia.InsertarTarea(Tarea);
if (inserta)
{
return(RedirectToAction("ListaTareas"));
}
else
{
return(View(Tarea));
}
}
catch (ApplicationException ex)
{
return(RedirectToAction("ListaTareas", new { msjException = ex.Message }));
}
}
public ActionResult EditaTarea(entTarea tp)
{
try
{
Boolean edita = logTarea.Instancia.EditaTarea(tp);
if (edita)
{
return(RedirectToAction("ListaTarea"));
}
else
{
return(View());
}
}
catch (ApplicationException ex)
{
return(RedirectToAction("EditaTarea", new { msjException = ex.Message }));
}
}
public ActionResult EditaTarea(int tareaID, int actividadID)
{
entTarea a = logTarea.Instancia.ObtenerTarea(tareaID, actividadID);
return(View(a));
}
