public void renewMembership(member memForRenew, DateTime tday)
{
// http://www.dotnetcurry.com/entityframework/619/add-update-delete-objects-entity-framework
long id = memForRenew.Id;
using (var db = new MembersListEntities())
{
DateTime newExpire;
bool exp;
// If the membership is expired, we add one month to today
// If the membership is not expired, add one month to their current exp. date
member m = db.members.First(i => i.Id == id);
newExpire = DateTime.ParseExact(m.membershipEndDate, "MM/dd/yyyy", null);
exp = _isMembershipExpired(newExpire);
if (exp == true)
{
newExpire = tday.AddMonths(1);
}
else
{
newExpire = newExpire.AddMonths(1);
}
m.membershipEndDate = newExpire.ToString("MM/dd/yyyy");
db.SaveChanges();
}
}
public void deleteMember(long id)
{
// https://visualstudiomagazine.com/blogs/tool-tracker/2015/12/entity-framework-database-deletes.aspx
using (var db = new MembersListEntities())
{
member m = db.members.First(i => i.Id == id);
db.members.Attach(m);
db.members.Remove(m);
db.SaveChanges();
}
}
public void addToDatabase(string fname, string lname, string sDate, string eDate)
{
using (var db = new MembersListEntities())
{
member newMember = new member
{
// ID of every new object is one more than the ID of the last object in the table
Id = generateID(),
firstName = fname,
lastName = lname,
membershipStartDate = sDate,
membershipEndDate = eDate
};
db.members.Add(newMember);
db.SaveChanges();
db.Dispose(); // I believe the "using" statement renders this redundant but hey, YouTube said so
}
}