/// <summary> /// Calculate deposit monthly interest /// </summary> /// <param name="client"></param> /// <returns></returns> public double[] DepositInfo(int clientId, string depType, int depRate) { double[] months = new double[12]; double deposit = SqlQueries.GetDepositAmount(clientId); // simple interest if (depType == "Simple") { for (int i = 0; i < months.Length; i++) { if (i == 0) { months[i] = (((double)deposit / 100 * depRate) / 12) + deposit; Math.Round(months[i], 2); months[i] = Math.Round(months[i], 2); continue; } months[i] = (((double)deposit / 100 * depRate) / 12) + months[i - 1]; Math.Round(months[i], 2); months[i] = Math.Round(months[i], 2); } } // capitalized interest else { for (int i = 0; i < months.Length; i++) { if (i == 0) { months[i] = (((double)deposit / 100 * depRate) / 12) + deposit; Math.Round(months[i], 2); months[i] = Math.Round(months[i], 2); continue; } months[i] = ((months[i - 1] / 100 * depRate) / 12) + months[i - 1]; months[i] = Math.Round(months[i], 2); } } return(months); }
public bool HasDeposit(int clientId) { double result = SqlQueries.GetDepositAmount(clientId); return(result != 0); }