public static List <Funcionalidad> GetByRole(Rol role, SqlTransaction transaction) { //Obtengo todas las funcionalidades asociadas a determinado rol (transaccionado) var param = new List <SPParameter> { new SPParameter("ID_Rol", role.ID) }; var sp = new StoreProcedure(DataBaseConst.Funcionalidad.SPGetAllFuncionalidadByRol, param, transaction); //Retorno una lista de Funcionalidad a partir de un ExecuteReader transaccionado return(sp.ExecuteReaderTransactioned <Funcionalidad>(transaction)); }
public static FormaPago GetById(int idPaymentMethod, SqlTransaction transaction) { var param = new List <SPParameter> { new SPParameter("ID_Forma_Pago", idPaymentMethod) }; var sp = new StoreProcedure(DataBaseConst.FormaPago.SPGetAllFormaPagoById, param, transaction); var statusPublication = sp.ExecuteReaderTransactioned <FormaPago>(transaction); if (statusPublication == null || statusPublication.Count == 0) { return(null); } return(statusPublication[0]); }
public static Cliente GetByPhone(string phone, SqlTransaction transaction) { var param = new List <SPParameter> { new SPParameter("Telefono", phone) }; var sp = new StoreProcedure(DataBaseConst.Cliente.SPGetClientByPhone, param, transaction); var users = sp.ExecuteReaderTransactioned <Cliente>(transaction); if (users == null || users.Count == 0) { return(null); } return(users[0]); }
public static Empresa GetByCUIT(string cuit, SqlTransaction transaction) { var param = new List <SPParameter> { new SPParameter("CUIT", cuit) }; var sp = new StoreProcedure(DataBaseConst.Empresa.SPGetCompanyByCUIT, param, transaction); var users = sp.ExecuteReaderTransactioned <Empresa>(transaction); if (users == null || users.Count == 0) { return(null); } return(users[0]); }
public static Empresa GetByBusinessName(string businessName, SqlTransaction transaction) { var param = new List <SPParameter> { new SPParameter("Razon_Social", businessName) }; var sp = new StoreProcedure(DataBaseConst.Empresa.SPGetCompanyByBusinessName, param, transaction); var users = sp.ExecuteReaderTransactioned <Empresa>(transaction); if (users == null || users.Count == 0) { return(null); } return(users[0]); }
public static Oferta GetLastOfertaByPublication(int idPublicacion, SqlTransaction transaction) { var param = new List <SPParameter> { new SPParameter("idPublicacion", idPublicacion) }; var sp = new StoreProcedure(DataBaseConst.Oferta.SPGetLastOfertaByPublication, param, transaction); var offers = (transaction == null) ? sp.ExecuteReader <Oferta>() : sp.ExecuteReaderTransactioned <Oferta>(transaction); if (offers == null || offers.Count == 0) { return(null); } return(offers[0]); }
public static Cliente GetByDocument(int tipoDocumento, int nroDocumento, SqlTransaction transaction) { var param = new List <SPParameter> { new SPParameter("Tipo_documento", tipoDocumento), new SPParameter("Nro_documento", nroDocumento) }; var sp = new StoreProcedure(DataBaseConst.Cliente.SPGetClientByDocument, param, transaction); var users = sp.ExecuteReaderTransactioned <Cliente>(transaction); if (users == null || users.Count == 0) { return(null); } return(users[0]); }
public static List <TipoDocumento> GetAll(SqlTransaction transaction) { var sp = new StoreProcedure(DataBaseConst.TipoDocumento.SPGetAllTipoDocumento, null, transaction); return(sp.ExecuteReaderTransactioned <TipoDocumento>(transaction)); }