public void AddMember(Member m)
{
using (var ctx = new MemberContext())
{
Member member = m;
ctx.Members.Add(member);
ctx.SaveChanges();
}
}
public void PopulateMembers(List <MemberModel> m)
{
MemberContext db = new MemberContext();
db.Database.ExecuteSqlCommand("TRUNCATE TABLE Members");
using (db)
{
db.Members.AddRange(m);
db.SaveChanges();
}
}
public void SaveVideo(string url, string description, string title)
{
MemberContext db = new MemberContext();
using (db)
{
db.Videos.Add(new TutorialModel {
URL = url, Description = description, VideoName = title
});
db.SaveChanges();
}
}
public void PopulateWarPlan(string memberName, string warPlan)
{
MemberContext db = new MemberContext();
using (db)
{
db.WarPlans.Add(new WarPlanModel {
MemberName = memberName, Plan = warPlan
});
db.SaveChanges();
}
}
public void CreateAdmin()
{
MemberContext db = new MemberContext();
using (db)
{
db.Admins.Add(new AdminModel {
UserName = "******", Password = "******"
});
db.SaveChanges();
}
}
public void SubmitSuggestion(string suggestion)
{
MemberContext db = new MemberContext();
using (db)
{
db.Suggestions.Add(new Suggestion {
Feedback = suggestion
});
db.SaveChanges();
}
}
public void ReserveTarget(string memberName, int target)
{
MemberContext db = new MemberContext();
using (db)
{
db.Reservations.Add(new TargetReservationModel {
MemberName = memberName, Target = target
});
db.SaveChanges();
}
}
