protected void btnSaveFE_Click(object sender, EventArgs e)
{
Forex_Rate_Model forex_Rate_Model = new Forex_Rate_Model
{
Amount = Convert.ToDecimal(txtForexRate.Text),
Currency_Code = ddlCurrency.SelectedValue.ToString(),
DateChange = DateTime.Now
};
Forex_Rate.Save(oCon, forex_Rate_Model);
ClearAdj();
GetForexRates();
}
public static bool Save(SqlConnection connection, Forex_Rate_Model model)
{
bool returnValue = true;
StringBuilder sQuery = new StringBuilder();
try
{
sQuery.Append(@"INSERT INTO a_Forex_Rate
(Currency_Codes
,Amount
,DateChange)
VALUES
(@Currency_Code
,@Amount
,@DateChange)" );
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
SqlParameter parm2 = new SqlParameter
{
ParameterName = "@Currency_Code",
SqlDbType = SqlDbType.NVarChar,
Value = model.Currency_Code
};
cmd.Parameters.Add(parm2);
SqlParameter parm3 = new SqlParameter
{
ParameterName = "@Amount",
SqlDbType = SqlDbType.Decimal,
Value = model.Amount
};
cmd.Parameters.Add(parm3);
SqlParameter parm4 = new SqlParameter
{
ParameterName = "@DateChange",
SqlDbType = SqlDbType.DateTime,
Value = model.DateChange
};
cmd.Parameters.Add(parm4);
if (cmd.ExecuteNonQuery() >= 1)
{
returnValue = true;
}
cmd.Dispose();
cmd.Parameters.Clear();
}
connection.Close();
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
return(returnValue);
}
