public IEnumerable <Credito> GetAll() { using (IDbConnection connection = new SqlConnection(ConnectionRepository.GetConnectionString())) { connection.Open(); var creditos = connection.Query <Credito>("sp_credito_listar", commandType: CommandType.StoredProcedure); return(creditos); } }
public IEnumerable <Cliente> GetClientes() { using (IDbConnection connection = new SqlConnection(ConnectionRepository.GetConnectionString())) { connection.Open(); var clientes = connection.Query <Cliente>("sp_cliente_listar", commandType: CommandType.StoredProcedure); return(clientes); } }
public Credito GetById(int id) { using (IDbConnection connection = new SqlConnection(ConnectionRepository.GetConnectionString())) { connection.Open(); var parameters = new DynamicParameters(); parameters.Add("IdCredito", id); var credito = connection.QuerySingle <Credito>("sp_credito_obtener", param: parameters, commandType: CommandType.StoredProcedure); return(credito); } }
public bool Delete(int id) { using (IDbConnection connection = new SqlConnection(ConnectionRepository.GetConnectionString())) { connection.Open(); var parameters = new DynamicParameters(); parameters.Add("IdCredito", id); var result = connection.Execute("sp_credito_eliminar", param: parameters, commandType: CommandType.StoredProcedure); return(result > 0); } }
public Cliente GetCliente(string numeroDocumento) { using (IDbConnection connection = new SqlConnection(ConnectionRepository.GetConnectionString())) { connection.Open(); var parameters = new DynamicParameters(); parameters.Add("NumeroDocumento", numeroDocumento); var cliente = connection.QuerySingle <Cliente>("sp_cliente_obtener", param: parameters, commandType: CommandType.StoredProcedure); return(cliente); } }
public Credito Update(Credito credito) { using (IDbConnection connection = new SqlConnection(ConnectionRepository.GetConnectionString())) { connection.Open(); var parameters = new DynamicParameters(); parameters.Add("IdCredito", credito.IdCredito); parameters.Add("TipoCredito", credito.TipoCredito); parameters.Add("IdCliente", credito.IdCliente); parameters.Add("Fecha", credito.Fecha); parameters.Add("Monto", credito.Monto); parameters.Add("DiaPago", credito.DiaPago); parameters.Add("Tasa", credito.Tasa); parameters.Add("Comision", credito.Comision); var result = connection.Execute("sp_credito_actualizar", param: parameters, commandType: CommandType.StoredProcedure); return(result > 0 ? credito : new Credito()); } }
public Credito Add(Credito credito) { using (IDbConnection connection = new SqlConnection(ConnectionRepository.GetConnectionString())) { connection.Open(); var parameters = new DynamicParameters(); parameters.Add("TipoCredito", credito.TipoCredito); parameters.Add("IdCliente", credito.IdCliente); parameters.Add("Fecha", credito.Fecha); parameters.Add("Monto", credito.Monto); parameters.Add("DiaPago", credito.DiaPago); parameters.Add("Tasa", credito.Tasa); parameters.Add("Comision", credito.Comision); parameters.Add("IdCredito", credito.IdCredito, DbType.Int32, ParameterDirection.Output); //va a obtener un valor autogenerado para IdCredito connection.ExecuteScalar("sp_credito_insertar", param: parameters, commandType: CommandType.StoredProcedure); var idCredito = parameters.Get <Int32>("IdCredito"); credito.IdCredito = idCredito; return(credito); } }