public async Task <IEnumerable <Currency> > GetAllAsync()
{
using (var connection = context.CreateConnection())
{
return(await connection.QueryAsync <Currency>(CurrencyQuery.All()));
}
}
public async Task <IEnumerable <CurrencyDto> > Query()
{
var currenyQuery = new CurrencyQuery();
var currencies = await dispatcher.Query <CurrencyQuery, IEnumerable <CurrencyModule.Aggregate.Currency> >(currenyQuery);
return(Mapper.Map(currencies).ToANew <IEnumerable <CurrencyDto> >());
}
private EnterEquipmentQuote GetEquipmentQuote_Model(string QuoteRef)
{
if (string.IsNullOrEmpty(QuoteRef))
{
return(null);
}
else
{
EWS.Domain.Data.DataModel.Quote quote = GetExistingQuote(QuoteRef);
if (quote != null)
{
return(GetEquipmentQuote_Model(quote));
}
else
{
Domain.Model.SourceQuote sourcequote = GetSourceQuote(QuoteRef);
if (sourcequote == null)
{
return(null);
}
else
{
EnterEquipmentQuote model = new EnterEquipmentQuote();
model.QuoteRef = QuoteRef;
DeviceQuery query = new Domain.Data.Queries.DeviceQuery()
{
DeviceID = sourcequote.DeviceID
};
model.Device = _queryProcessor.Execute(query);
model.TenderNumber = sourcequote.TenderNumber;
model.VAT = sourcequote.VAT;
model.SellingPriceExclVAT = sourcequote.SellingPriceInclVAT / Convert.ToDecimal(1 + sourcequote.VAT / 100);
model.SellingPriceInclVAT = sourcequote.SellingPriceInclVAT;
model.ContractCalculations = GetNewEquipmentContractCalculationModels(model.SellingPriceExclVAT);
if (quote == null) // fill in from source quote:
{
// Exchange Rate
CurrencyQuery cquery = new CurrencyQuery()
{
ID = "USD"
};
Domain.Data.DataModel.Currency usd = _queryProcessor.Execute(cquery);
model.ExchangeRate = new ExchangeRate()
{
Rate = Convert.ToDecimal(usd.DefaultRateOfExchange),
Date = DateTime.Today
};
}
return(model);
}
}
}
} //GetEquipmentQuote_Model
public async Task DeleteAsync(Guid id)
{
using (var connection = context.CreateConnection())
{
await connection.ExecuteAsync(CurrencyQuery.Delete(id));
}
}
public static async void Search(CustomSearchControl SearchControl)
{
var client = Helper.getServiceClient();
CurrencyQuery query = new CurrencyQuery();
if (SearchControl.OptionOne.IsChecked == true)
{
query = new CurrencyQuery()
{
CurrencyCode = SearchControl.SearchTextBox.Text
};
}
else if (SearchControl.OptionTwo.IsChecked == true)
{
query = new CurrencyQuery()
{
CurrencyName = SearchControl.SearchTextBox.Text
};
}
SearchControl.Search = Search;
int pagesize = SearchControl.PageSize;
int pagePosition = SearchControl.PagePosition;
var response = await client.QueryCurrencyAsync(query, pagesize, pagePosition);
if (response == null)
{
MessageBox.Show("Service isn't responding, please try again later", "Message", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
SearchControl.ResultCount = response.TotalResultCount;
//Fill the datagrid with the results
SearchControl.ResultsGrid.ItemsSource = new ObservableCollection <FIN_Currency>(response.Result.ToList <FIN_Currency>());;
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
Currency mock = CreateMockInstance(tm);
bool result = DataRepository.CurrencyProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
CurrencyQuery query = new CurrencyQuery();
query.AppendEquals(CurrencyColumn.Id, mock.Id.ToString());
if (mock.Description != null)
{
query.AppendEquals(CurrencyColumn.Description, mock.Description.ToString());
}
if (mock.Exchange != null)
{
query.AppendEquals(CurrencyColumn.Exchange, mock.Exchange.ToString());
}
if (mock.Status != null)
{
query.AppendEquals(CurrencyColumn.Status, mock.Status.ToString());
}
TList <Currency> results = DataRepository.CurrencyProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
public async Task <CurrencyDto> Query(Guid id)
{
var currenyQuery = new CurrencyQuery {
Id = id
};
var currency = await dispatcher.Query <CurrencyQuery, CurrencyModule.Aggregate.Currency>(currenyQuery);
return(Mapper.Map(currency).ToANew <CurrencyDto>());
}
public async Task <Currency> GetByIdAsync(Guid id)
{
using (var connection = context.CreateConnection())
{
var query = await connection.QueryAsync <Currency>(CurrencyQuery.ById(id));
return(query.SingleOrDefault());
}
}
public async Task <Currency> UpdateAsync(Currency currency)
{
using (var connection = context.CreateConnection())
{
await connection.ExecuteAsync(CurrencyQuery.Update(currency));
return(currency);
}
}
public AddressesController(UserManager <ApplicationUser> userManager, AddressQuery addressQuery, CurrencyQuery currencyQuery,
ExchangeQuery exchangeQuery, BlockQuery blockQuery, UserQuery userQuery, TransactionQuery transactionQuery)
{
_userManager = userManager;
_addressQuery = addressQuery;
_currencyQuery = currencyQuery;
_exchangeQuery = exchangeQuery;
_blockQuery = blockQuery;
_userQuery = userQuery;
_transactionQuery = transactionQuery;
}
public Currency Create(Currency currency)
{
if (currency.Id == Guid.Empty)
{
currency.Id = Guid.NewGuid();
}
using (var connection = context.CreateConnection())
{
connection.Execute(CurrencyQuery.Insert(currency));
return(currency);
}
}
public async Task <Currency> CreateAsync(Currency currency)
{
if (currency.Id == Guid.Empty)
{
currency.Id = Guid.NewGuid();
}
using (var connection = context.CreateConnection())
{
await connection.ExecuteAsync(CurrencyQuery.Insert(currency));
return(currency);
}
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
Currency mock = CreateMockInstance(tm);
bool result = DataRepository.CurrencyProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
CurrencyQuery query = new CurrencyQuery();
query.AppendEquals(CurrencyColumn.CurrencyCode, mock.CurrencyCode.ToString());
query.AppendEquals(CurrencyColumn.Name, mock.Name.ToString());
query.AppendEquals(CurrencyColumn.ModifiedDate, mock.ModifiedDate.ToString());
TList <Currency> results = DataRepository.CurrencyProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
public async Task <IEnumerable <Currency> > Query(CurrencyQuery query)
{
return(await mainDbContext.Currency.ToListAsync());
}
public CurrencyQueryTest()
{
TestEnvironment.Init();
query = new CurrencyQuery();
}
