public static async Task <bool> QueueAdd(QueueModel queue)
{
Uri route = new Uri("/queue", UriKind.Relative);
var jsonString = JsonConvert.SerializeObject(queue);
using (StringContent content = new StringContent(jsonString, Encoding.UTF8, "application/json"))
using (HttpResponseMessage response = await QueueClient.PutAsync(route, content).ConfigureAwait(true))
{
if (!response.IsSuccessStatusCode)
{
var message = response.ReasonPhrase + ": " + response.Content.ReadAsStringAsync().Result;
throw new HttpRequestException(message);
}
return(true);
}
}
public static int QueueInsert(QueueModel queueitem)
{
if (queueitem != null)
{
var result = qConnection.Execute("" +
"INSERT INTO Queue(" +
"IDU, " +
" oid, account_year, forex_type, forex_oid, foreign_amount, exchange_rate, national_amount, journal_date_time, userID, isPOStransaction" +
") SELECT " +
"@IDU, " +
"@oid, " +
"@account_year, " +
"@forex_type, " +
"@forex_oid, " +
"@foreign_amount, " +
"@exchange_rate, " +
"@national_amount, " +
"@journal_date_time, " +
"IFNULL(@userId,'n/a'), " +
"@isPOStransaction " +
" WHERE NOT EXISTS(SELECT 1 FROM Queue WHERE oid = @oid AND IDU=@IDU)"
, new
{
queueitem.IDU,
queueitem.Transaction.oid,
queueitem.Transaction.account_year,
queueitem.Transaction.forex_type,
queueitem.Transaction.forex_oid,
queueitem.Transaction.foreign_amount,
queueitem.Transaction.exchange_rate,
queueitem.Transaction.national_amount,
queueitem.Transaction.journal_date_time,
queueitem.Transaction.userID,
queueitem.Transaction.isPOStransaction
});
return(result);
}
else
{
return(0);
}
}