internal int Insert(Models.TipoDocumento oTipoDocumento)
{
Guid methodOwnerID = new Guid("d5c7e134-54e7-45dc-8725-5f9030f61108");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try{
DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib);
int idTipoDocumento = cTipoDocumento.Insert(oTipoDocumento);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(idTipoDocumento);
}
catch (Exception ex) {
//rollback
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
internal int Update(Models.TipoDocumento oTipoDocumento)
{
Guid methodOwnerID = new Guid("dc9a160a-65f5-43c2-a854-95d38b1d7606");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try{
DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib);
int result = cTipoDocumento.Update(oTipoDocumento);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(result);
}
catch (Exception ex) {
//rollback
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
internal List <Models.TipoDocumento> Catalogo(Models.TipoDocumento oTipoDocumentoFilter)
{
OpenDbConn();
DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib);
return(cTipoDocumento.Catalogo(oTipoDocumentoFilter));
}
internal Models.TipoDocumento Select(Byte ta211_idtipodocumento)
{
OpenDbConn();
DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib);
return(cTipoDocumento.Select(ta211_idtipodocumento));
}
internal int Delete(Byte ta211_idtipodocumento)
{
Guid methodOwnerID = new Guid("2d46cbc9-b60d-458d-8373-6389a539a70c");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try{
DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib);
int result = cTipoDocumento.Delete(ta211_idtipodocumento);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(result);
}
catch (Exception ex) {
//rollback
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
public List <Models.TipoDocumento> Catalogo()
{
OpenDbConn();
DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib);
return(cTipoDocumento.Catalogo());
}
internal List <Models.TipoDocumento> GrabarListaTiposDocumento(List <Models.TipoDocumento> lstTiposDocumento)
{
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 dtTipoDocumentos = new DataTable();
dtTipoDocumentos.Columns.Add(new DataColumn("ta211_idtipodocumento", typeof(int)));
dtTipoDocumentos.Columns.Add(new DataColumn("ta211_denominacion", typeof(string)));
dtTipoDocumentos.Columns.Add(new DataColumn("ta211_orden", typeof(int)));
dtTipoDocumentos.Columns.Add(new DataColumn("ta211_activo", typeof(bool)));
foreach (Models.TipoDocumento oTipoDocumento in lstTiposDocumento)
{
DataRow rowAccion = dtTipoDocumentos.NewRow();
rowAccion["ta211_idtipodocumento"] = oTipoDocumento.ta211_idtipodocumento;
rowAccion["ta211_denominacion"] = oTipoDocumento.ta211_denominacion;
rowAccion["ta211_orden"] = oTipoDocumento.ta211_orden;
rowAccion["ta211_activo"] = oTipoDocumento.ta211_estadoactiva;
dtTipoDocumentos.Rows.Add(rowAccion);
}
DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib);
List <Models.TipoDocumento> lstTipoDocumento = cTipoDocumento.GrabarDocumentos(dtTipoDocumentos);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(lstTiposDocumento);
}
catch (Exception ex)
{
//rollback
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
