/// <summary>
/// Inserta un AccionTareas
/// </summary>
internal int Insert(Models.AccionTareas oAccionTareas)
{
try
{
SqlParameter[] dbparams = new SqlParameter[2] {
Param(enumDBFields.t332_idtarea, oAccionTareas.t332_idtarea),
Param(enumDBFields.t383_idaccion, oAccionTareas.t383_idaccion)
};
return((int)cDblib.Execute("SUP_ACCIONTAREAS_I_SNE", dbparams));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Obtiene todos los AccionTareas
/// </summary>
internal List <Models.AccionTareas> Catalogo(Int32 t383_idaccion)
{
Models.AccionTareas oAccionTareas = null;
List <Models.AccionTareas> lst = new List <Models.AccionTareas>();
IDataReader dr = null;
try
{
SqlParameter[] dbparams = new SqlParameter[1] {
Param(enumDBFields.t383_idaccion, t383_idaccion)
};
dr = cDblib.DataReader("SUP_ACCIONTAREAS_SByT383_idaccion", dbparams);
while (dr.Read())
{
oAccionTareas = new Models.AccionTareas();
oAccionTareas.t332_idtarea = Convert.ToInt32(dr["t332_idtarea"]);
oAccionTareas.t332_destarea = Convert.ToString(dr["t332_destarea"]);
oAccionTareas.t332_orden = Convert.ToInt32(dr["t332_orden"]);
oAccionTareas.t332_etpl = Convert.ToDouble(dr["t332_etpl"]);
if (!Convert.IsDBNull(dr["t332_fipl"]))
{
oAccionTareas.t332_fipl = Convert.ToDateTime(dr["t332_fipl"]);
}
if (!Convert.IsDBNull(dr["t332_ffpl"]))
{
oAccionTareas.t332_ffpl = Convert.ToDateTime(dr["t332_ffpl"]);
}
oAccionTareas.t332_etpr = Convert.ToDouble(dr["t332_etpr"]);
if (!Convert.IsDBNull(dr["t332_ffpr"]))
{
oAccionTareas.t332_ffpr = Convert.ToDateTime(dr["t332_ffpr"]);
}
oAccionTareas.Consumo = Convert.ToDouble(dr["Consumo"]);
oAccionTareas.t332_avanceauto = Convert.ToBoolean(dr["t332_avanceauto"]);
if (!Convert.IsDBNull(dr["t332_avance"]))
{
oAccionTareas.t332_avance = Convert.ToDouble(dr["t332_avance"]);
}
if (!Convert.IsDBNull(dr["Estado"]))
{
oAccionTareas.Estado = Convert.ToString(dr["Estado"]);
}
oAccionTareas.num_proyecto = Convert.ToInt32(dr["num_proyecto"]);
oAccionTareas.nom_proyecto = Convert.ToString(dr["nom_proyecto"]);
oAccionTareas.t331_idpt = Convert.ToInt32(dr["t331_idpt"]);
oAccionTareas.t331_despt = Convert.ToString(dr["t331_despt"]);
oAccionTareas.t334_idfase = Convert.ToInt32(dr["t334_idfase"]);
oAccionTareas.t334_desfase = Convert.ToString(dr["t334_desfase"]);
oAccionTareas.t335_idactividad = Convert.ToInt32(dr["t335_idactividad"]);
oAccionTareas.t335_desactividad = Convert.ToString(dr["t335_desactividad"]);
lst.Add(oAccionTareas);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
if (!dr.IsClosed)
{
dr.Close();
}
dr.Dispose();
}
}
}
