/// <summary>
/// Function to Add Conversion Detail to Database.
/// </summary>
/// <param name="quantity"></param>
/// <returns></returns>
public QuantityModel Add(QuantityModel quantity)
{
try
{
dBContext.Quantities.Add(quantity);
dBContext.SaveChanges();
return(quantity);
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// Method to take a value and option and convert
/// </summary>
/// <param name="quantity"></param>
/// <returns></returns>
#region Conversion
public ConversionModel Conversion(ConversionModel quantity)
{
bool isOptionValid = Enum.TryParse <ConversionOptions>(quantity.OperationType, true, out ConversionOptions option);
if (isOptionValid)
{
try
{
var param = new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@inputId",
SqlDbType = SqlDbType.Int,
Direction = System.Data.ParameterDirection.Input,
Value = (int)option
},
new SqlParameter()
{
ParameterName = "@inputValue",
SqlDbType = SqlDbType.Float,
Direction = ParameterDirection.Input,
Value = quantity.Value
}
};
ConversionModel output = dBContext.Conversions.FromSql("[dbo].[spConvert] @inputId, @inputValue", param).FirstOrDefault();
dBContext.SaveChanges();
return(output);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
else
{
return(quantity);
}
}
