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));
}