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