public string InsertMembership(membership mem)
{
wvac.memberships.Add(mem);
wvac.SaveChanges();
return("Your Member ID is " + mem.ID +
"\nYour next payment schedule is on: " + mem.SchedDate +
"\nAmount due: PHP" + mem.MonthlyDue);
}
public void UpdateMembership(int id, double payment)
{
int months;
membership m = wvac.memberships.Find(id);
var selectMonths = (from c in wvac.memberships where c.ID == id select new { c.MonthsToPay });
DateTime schedDate = Convert.ToDateTime(m.SchedDate);
int monthsToPay = Convert.ToInt32(selectMonths.First().MonthsToPay);
months = Convert.ToInt32(m.MonthsToPay);
if (months == 36)
{
m.SchedDate = schedDate.AddMonths(1);
}
else if (months == 9)
{
m.SchedDate = schedDate.AddMonths(4);
}
else if (months == 3)
{
m.SchedDate = schedDate.AddYears(1);
}
double balance = Convert.ToDouble(m.Balance);
int monthspaid = Convert.ToInt32(m.MonthsPaid);
m.Balance = (double)(Math.Round(balance - payment));
m.MonthsPaid = monthspaid + 1;
if (m.Balance == 0)
{
m.status = "APPROVED";
m.SchedDate = null;
}
wvac.SaveChanges();
}