public bool ChangeSetting(ChangeSettingRequest request)
{
var conn = GetConnection(ConnectionNames.CSPSqlDatabase);
var commandWrapper = GetStoredProcCommand("dbo.Update_Settings", conn);
AddInParameter(commandWrapper, "@SettingId", DbType.Int16, request.Setting.Id);
AddInParameter(commandWrapper, "@IncludeInCalculation", DbType.String, request.Setting.IncludeInCalculation);
AddInParameter(commandWrapper, "@Amount", DbType.String, request.Setting.Amount);
AddInParameter(commandWrapper, "@ERROR", DbType.String, 1000);
AddInParameter(commandWrapper, "@ERROR_CODE", DbType.String, 4);
try
{
conn.Open();
int results = commandWrapper.ExecuteNonQuery();
var isProcedureSucced = Convert.ToBoolean(results);
MakeDboLog(request.ToString(), isProcedureSucced.ToString(), "dbo.Update_Settings");
var errorObject = GetParameterValue(commandWrapper, "@ERROR");
var errorCodeObject = GetParameterValue(commandWrapper, "@ERROR_CODE");
return(Convert.ToBoolean(results));
}
finally
{
commandWrapper.Dispose();
conn.Close();
}
}
