public List <Models.MOTIVOOCFA> Catalogo(Models.MOTIVOOCFA oMOTIVOOCFAFilter)
{
OpenDbConn();
DAL.MOTIVOOCFA cMOTIVOOCFA = new DAL.MOTIVOOCFA(cDblib);
return(cMOTIVOOCFA.Catalogo(oMOTIVOOCFAFilter));
}
/// <summary>
/// Inserta un MOTIVOOCFA
/// </summary>
internal int Insert(Models.MOTIVOOCFA oMOTIVOOCFA)
{
try
{
SqlParameter[] dbparams = new SqlParameter[2] {
Param(enumDBFields.t820_tipo, oMOTIVOOCFA.t820_tipo),
Param(enumDBFields.t840_descripcion, oMOTIVOOCFA.t840_descripcion)
};
return((int)cDblib.Execute("SUP_MOTIVOOCFA_INS", dbparams));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Obtiene todos los MOTIVOOCFA
/// </summary>
internal List <Models.MOTIVOOCFA> Catalogo(Models.MOTIVOOCFA oMOTIVOOCFAFilter)
{
Models.MOTIVOOCFA oMOTIVOOCFA = null;
List <Models.MOTIVOOCFA> lst = new List <Models.MOTIVOOCFA>();
IDataReader dr = null;
try
{
SqlParameter[] dbparams = new SqlParameter[1] {
Param(enumDBFields.t820_tipo, oMOTIVOOCFAFilter.t820_tipo)
};
dr = cDblib.DataReader("SUP_MOTIVOOCFA_CAT", dbparams);
while (dr.Read())
{
oMOTIVOOCFA = new Models.MOTIVOOCFA();
oMOTIVOOCFA.t840_idmotivo = Convert.ToInt32(dr["t840_idmotivo"]);
oMOTIVOOCFA.t820_tipo = Convert.ToString(dr["t820_tipo"]);
oMOTIVOOCFA.t840_descripcion = Convert.ToString(dr["t840_descripcion"]);
oMOTIVOOCFA.desTipo = Convert.ToString(dr["desTipo"]);
lst.Add(oMOTIVOOCFA);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
if (!dr.IsClosed)
{
dr.Close();
}
dr.Dispose();
}
}
}
/// <summary>
/// Obtiene un MOTIVOOCFA a partir del id
/// </summary>
internal Models.MOTIVOOCFA Select(Int32 t840_idmotivo)
{
Models.MOTIVOOCFA oMOTIVOOCFA = null;
IDataReader dr = null;
try
{
SqlParameter[] dbparams = new SqlParameter[1] {
Param(enumDBFields.t840_idmotivo, t840_idmotivo)
};
dr = cDblib.DataReader("SUP_MOTIVOOCFA_SEL", dbparams);
if (dr.Read())
{
oMOTIVOOCFA = new Models.MOTIVOOCFA();
oMOTIVOOCFA.t840_idmotivo = Convert.ToInt32(dr["t840_idmotivo"]);
oMOTIVOOCFA.t820_tipo = Convert.ToString(dr["t820_tipo"]);
oMOTIVOOCFA.t840_descripcion = Convert.ToString(dr["t840_descripcion"]);
}
return(oMOTIVOOCFA);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
if (!dr.IsClosed)
{
dr.Close();
}
dr.Dispose();
}
}
}
public int Update(Models.MOTIVOOCFA oMOTIVOOCFA)
{
Guid methodOwnerID = new Guid("c04ee672-fb30-4243-b204-a8a7d2139680");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.MOTIVOOCFA cMOTIVOOCFA = new DAL.MOTIVOOCFA(cDblib);
int result = cMOTIVOOCFA.Update(oMOTIVOOCFA);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(result);
}
catch (Exception ex)
{
//rollback
//if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.rollbackTransaction(methodOwnerID);
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
public int Insert(Models.MOTIVOOCFA oMOTIVOOCFA)
{
Guid methodOwnerID = new Guid("b70fc40f-b61f-408b-94d1-fa4a138331dc");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.MOTIVOOCFA cMOTIVOOCFA = new DAL.MOTIVOOCFA(cDblib);
int idMOTIVOOCFA = cMOTIVOOCFA.Insert(oMOTIVOOCFA);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(idMOTIVOOCFA);
}
catch (Exception ex)
{
//rollback
//if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.rollbackTransaction(methodOwnerID);
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
