public void GetAmortization(LoanValue value) { LoanRepository db = new LoanRepository(); value.Amortization = (value.Amount + value.Amount * value.Interest * value.Duration / 100) / (value.Duration * 1); value.Amortization = Math.Round(value.Amortization, 2); if (Double.IsNaN(value.Amortization)) { value.Amortization = 0; } db.LoanValues.Add(value); db.SaveChanges(); //bool isAmount = context.LoanValues // .Select(c => c.Amount).Contains(value.Amount); //bool isDuration = context.LoanValues // .Select(c => c.Duration).Contains(value.Duration); //bool isInterest= context.LoanValues // .Select(c => c.Interest).Contains(value.Interest); //if (isAmount & isDuration & isInterest) //{ // var data = (from l in context.LoanValues select l.Amount); // value.Amount = Convert.ToDouble(data); // data = (from l in context.LoanValues select l.Duration); // value.Duration = Convert.ToDouble(data); // data = (from l in context.LoanValues select l.Interest); // value.Duration = Convert.ToDouble(data); // var t = db.Database.ExecuteSqlCommand("SELECT * FROM [LoanValues] WHERE Amount =" + value.Amount.ToString() + "AND Duration =" + value.Duration.ToString() + "AND Interest =" + value.Interest.ToString()); // var n = db.Database.ExecuteSqlCommand("SELECT * FROM [LoanValues] WHERE NOT EXISTS (SELECT* FROM [LoanValues] WHERE Amount =" + value.Amount.ToString() + "AND Duration =" + value.Duration.ToString() + "AND Interest =" + value.Interest.ToString() + ")"); }
public void CreateEntry([FromBody] LoanValue value) { loanBL.GetAmortization(value); }