//insert membership
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);
}
//create member lumpsum
public membership CreateMemberLump(int userId, int shares, string modeofP)
{
membership member = new membership();
member.UserID = userId;
member.Shares = shares;
member.ModeOfPayment = modeofP;
member.TotalAmount = shares * 1000;
member.Balance = 0;
member.status = "APPROVED";
member.BeginDate = DateTime.Today;
return(member);
}
//create member installment
public membership CreateMemberInstallment(int uID, int shares, string mode, int months,
double bal, double monthlyDue, string typeIns)
{
membership member = new membership();
member.UserID = uID;
member.Shares = shares;
member.ModeOfPayment = mode;
member.MonthsToPay = months;
member.TotalAmount = shares * 1000;
member.Balance = bal;
member.BeginDate = DateTime.Today;
member.MonthlyDue = (double)Math.Round((monthlyDue) * 100) / 100;
DateTime b = Convert.ToDateTime(member.BeginDate);
DateTime s = b.AddMonths(setSched(typeIns));
member.SchedDate = s;
member.status = "Pending";
return(member);
}
//update membership
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();
}