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