public int Insert(GLDailyRateModel model)
{
string sql =
@"INSERT INTO gl_daily_rates
(from_currency
,to_currency
,conversion_date
,conversion_type
,conversion_rate
,status_code
,last_update_date
,last_updated_by
,creation_date
,created_by)
VALUES
(@from_currency
,@to_currency
,@conversion_date
,@conversion_type
,@conversion_rate
,@status_code
,@last_update_date
,@last_updated_by
,@creation_date
,@created_by)";
return(db.Insert(sql, Take(model)));
}
private object[] Take(GLDailyRateModel model)
{
return(new object[]
{
"@rate_trans_id", model.RateTransId,
"@from_currency", model.FromCurrency,
"@to_currency", model.ToCurrency,
"@conversion_date", model.ConversionDate,
"@conversion_rate", model.ConversionRate,
"@conversion_type", model.ConversionType,
"@status_code", model.StatusCode,
"@last_update_date", model.LastUpdateDate,
"@last_updated_by", model.LastUpdatedBy,
"@creation_date", model.CreationDate,
"@created_by", model.CreatedBy
});
}
