/// <summary>
/// this function calculates the interest of all the accounts in one go. If account typ is Saving then interest rate is 0.6%per month
/// and 0.4 for fixed accounts. This can be done only on monthly basis
/// After calculating interest task done information is stored in Adminwork table
/// </summary>
/// <param name="adminID">maintain which admin has performed this task</param>
/// <returns>Function returns the confirmation that intrest has been calculated for all accounts</returns>
public Adminwork CalculateInterest(string adminId)
{
decimal interestRate = 100;
decimal interestamount = 0;
IEnumerable <Account> accounts = database.Accounts.ToList();
foreach (Account account in accounts)
{
if (account.AccountType == "Savings")
{
interestRate = Convert.ToDecimal(0.6); //0.6% permonth on savings account
}
else if (account.AccountType == "Fixed")
{
interestRate = Convert.ToDecimal(0.4); //0.4% permonth on fixed account
}
interestamount = (decimal)(account.InterestAmount + (interestRate / 100) * account.AvailableBalance);
account.InterestAmount = interestamount;
database.SaveChanges();
}
//storing task info in adminwork table and returing it
Adminwork work = new Adminwork();
work.WorkType = "InterestCalculation";
work.WorkTime = DateTime.Now;
work.ID = adminId;
database.Adminworks.Add(work);
database.SaveChanges();
return(work);
}
public async Task <IActionResult> CalculateInterest(string ID)
{
try
{
using (var client = new HttpClient())
{
Adminwork work = new Adminwork();
client.BaseAddress = new Uri("http://localhost:10293/api/Interest");
HttpResponseMessage response = await client.GetAsync("Interest/CalculateInterest/" + ID);
var result = response.Content.ReadAsStringAsync().Result;
if (response.IsSuccessStatusCode)
{
work = JsonConvert.DeserializeObject <Adminwork>(result);
return(View(work));
}
else
{
var content = JsonConvert.DeserializeObject <Response>(result);
ViewData["error"] = content.Message;
return(View("error"));
}
}
}
catch (Exception e)
{
ViewData["error"] = e.Message;
return(View("~/Views/Shared/ExceptionError.cshtml"));
}
}
//returns the last date when the interest was calculated
public DateTime lastInterestCalculation()
{
DateTime date = new DateTime(1000, 01, 01, 12, 00, 00);
int count = (from x in database.Adminworks select x).Count();
Adminwork res = null;
if (count >= 1)
{
res = (from record in database.Adminworks orderby record.WorkId where record.WorkType == "InterestCalculation" select record).Last();
}
//var res = from work in database.Adminworks
// where work.WorkType == "InterestCalculation"
// select work.WorkTime;
if (res != null)
{
date = Convert.ToDateTime(res.WorkTime);
}
return(date);
}
