public DataTable List_MetaEspecificaDeGasto(MetaEspecificoDeGasto_VO pMetaEspecificoDeGasto)
{
DataTable mDtMetaEspecificaDeGasto = new DataTable();
try
{
mDtMetaEspecificaDeGasto = new MetaEspecificoDeGasto_DAL().List_MetaEspecificaDeGasto(pMetaEspecificoDeGasto);
}
catch (Exception ex) { throw ex; }
return mDtMetaEspecificaDeGasto;
}
public bool Insert_MetaEspecificoDeGasto(MetaEspecificoDeGasto_VO pMetaEspecificoDeGasto )
{
SqlConnection sqlConection = null;
SqlTransaction TransMetaEspecifica = null;
bool b_MetaEspecifica = false;
try
{
sqlConection = new SqlConnection(BEConexion.vg_strCadenaConexion);
sqlConection.Open();
TransMetaEspecifica = sqlConection.BeginTransaction();
if (pMetaEspecificoDeGasto != null)
{
b_MetaEspecifica = new MetaEspecificoDeGasto_DAL().Insert_MetaEspecificoDeGasto(pMetaEspecificoDeGasto, TransMetaEspecifica);
}
if (b_MetaEspecifica)
{
TransMetaEspecifica.Commit();
}
else
{
TransMetaEspecifica.Rollback();
}
}
catch (Exception exception)
{
if (TransMetaEspecifica != null)
TransMetaEspecifica.Rollback();
return false;
}
finally
{
if (sqlConection != null)
{
sqlConection.Close();
}
sqlConection.Dispose();
}
return b_MetaEspecifica;
}
