public static void addContact(Contacts contact)
{
RunnersDBContext db = new RunnersDBContext();
db.Contacts.Add(contact);
db.SaveChanges();
}
public static void addRunner(Runners runner)
{
RunnersDBContext db = new RunnersDBContext();
db.Runners.Add(runner);
db.SaveChanges();
}
public static int getLastContactId()
{
RunnersDBContext db = new RunnersDBContext();
int maxID = db.Contacts.Select(p => p.Id).DefaultIfEmpty(0).Max() + 1;
return(maxID);
}
public static void dispose()
{
RunnersDBContext db = new RunnersDBContext();
db.Dispose();
}
public static List <Runners> getRunners(int?id)
{
RunnersDBContext db = new RunnersDBContext();
return(db.Runners.Where(Runners => Runners.contactID == id).ToList());
}
public static Contacts getContact(int?id)
{
RunnersDBContext db = new RunnersDBContext();
return(db.Contacts.Find(id));
}
public static List <Runners> getAllRunners()
{
RunnersDBContext db = new RunnersDBContext();
return(db.Runners.ToList());
}
public static List <Contacts> getAllContacts()
{
RunnersDBContext db = new RunnersDBContext();
return(db.Contacts.ToList());
}
