public List <Models.TipoTareaPreventa> Catalogo()
{
OpenDbConn();
DAL.TipoTareaPreventa cTipoTareaPreventa = new DAL.TipoTareaPreventa(cDblib);
return(cTipoTareaPreventa.Catalogo());
}
internal Models.TipoTareaPreventa Select(Int16 ta219_idtipotareapreventa)
{
OpenDbConn();
DAL.TipoTareaPreventa cTipoTareaPreventa = new DAL.TipoTareaPreventa(cDblib);
return(cTipoTareaPreventa.Select(ta219_idtipotareapreventa));
}
internal List <Models.TipoTareaPreventa> GrabarListaTareas(List <Models.TipoTareaPreventa> lstTiposTareaPreventa)
{
Guid methodOwnerID = new Guid("f672bc44-f3fc-4102-8b50-2d3452b19198");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
//Datatable de tipos de tareas preventa
DataTable dtTipoTareas = new DataTable();
dtTipoTareas.Columns.Add(new DataColumn("ta219_idtipotareapreventa", typeof(int)));
dtTipoTareas.Columns.Add(new DataColumn("ta219_denominacion", typeof(string)));
dtTipoTareas.Columns.Add(new DataColumn("ta219_orden", typeof(int)));
dtTipoTareas.Columns.Add(new DataColumn("ta219_activa", typeof(bool)));
foreach (Models.TipoTareaPreventa oTipoTarea in lstTiposTareaPreventa)
{
DataRow rowAccion = dtTipoTareas.NewRow();
rowAccion["ta219_idtipotareapreventa"] = oTipoTarea.ta219_idtipotareapreventa;
rowAccion["ta219_denominacion"] = oTipoTarea.ta219_denominacion;
rowAccion["ta219_orden"] = oTipoTarea.ta219_orden;
rowAccion["ta219_activa"] = oTipoTarea.ta219_estadoactiva;
dtTipoTareas.Rows.Add(rowAccion);
}
DAL.TipoTareaPreventa cTipoTareaPreventa = new DAL.TipoTareaPreventa(cDblib);
List <Models.TipoTareaPreventa> lstTipoTareaPreventa = cTipoTareaPreventa.GrabarTareas(dtTipoTareas);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(lstTiposTareaPreventa);
}
catch (Exception ex)
{
//rollback
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
