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 List <string> getMemberFirstName()
{
List <string> allMembersFirstName = new List <string>();
using (var db = new MembersListEntities())
{
allMembersFirstName = (from mems in db.members select mems.firstName).ToList();
db.Dispose();
}
return(allMembersFirstName);
}
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
}
}
public List <member> getFullMemberList()
{
//Master List - All Members
List <member> members;
//First Name
List <string> firstName = new List <string>();
//Last Name
List <string> lastName = new List <string>();
//Membership Start Date List
List <string> start = new List <string>();
//Membership End Date List
List <string> end = new List <string>();
//Membership Expired?
bool expired;
// Member ID (Primary Key)
List <long> id = new List <long>();
using (var db = new MembersListEntities())
{
firstName = (from mems in db.members select mems.firstName).ToList();
lastName = (from mems in db.members select mems.lastName).ToList();
start = (from mems in db.members select mems.membershipStartDate).ToList();
end = (from mems in db.members select mems.membershipEndDate).ToList();
id = (from mems in db.members select mems.Id).ToList();
}
members = new List <member>(firstName.Count());
for (int i = 0; i < firstName.Count(); i++)
{
expired = isMembershipExpired(end[i]);
//Adds a new instance of the member class with the values pulled from the individual lists above.
//Full name derived on the spot from the concat. of first and last
members.Add(new member {
firstName = firstName[i], lastName = lastName[i], fullName = firstName[i] + " " + lastName[i],
membershipStartDate = start[i], membershipEndDate = end[i], membershipExpired = expired, Id = id[i]
});
}
return(members);
}
