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