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