public HttpResponseMessage Post()
{
try
{
foreach (var q in Common.Data.BankRequestList)
{
foreach (var q2 in HttpHelper.GetRequest <ExchangeRateModels>(q.Url).ResultSet.Result)
{
MainExchangeRate mer = new MainExchangeRate();
mer.BankCode = q2.V1;
mer.Bank = q2.V2;
mer.Currency = q.Currey;
DateTime dt = new DateTime();
double v4 = default(double);
double v5 = default(double);
double v6 = default(double);
double v7 = default(double);
DateTime.TryParse(q2.V3, out dt);
Double.TryParse(q2.V4, out v4);
Double.TryParse(q2.V5, out v5);
Double.TryParse(q2.V6, out v6);
Double.TryParse(q2.V7, out v7);
mer.Date = dt;
mer.SpotExchangeRateBuys = v4;
mer.SpotExchangeRateSells = v5;
mer.CashExchangeRateBuys = v6;
mer.CashExchangeRateSells = v7;
DapperHelper.InsertSQL <MainExchangeRate>
(connectionString, TableName, mer);
}
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
public HttpResponseMessage Delete([FromBody] MainExchangeRate value)
{
var response = DapperHelper.DeleteSQL(connectionString, TableName, value.SeqNo);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
