public static List <Supply> GetSupply()
{
using (var db = new SHTFListContext())
{
return(db.Supply.ToList());
}
}
public static List <Item> GetItem()
{
using (var db = new SHTFListContext())
{
return(db.Item.ToList());
}
}
public static List <Food> GetFood()
{
using (var db = new SHTFListContext())
{
return(db.Food.ToList());
}
}
public static List <Contact> GetContact()
{
using (var db = new SHTFListContext())
{
return(db.Contact.ToList());
}
}
public static List <Category> GetCategory()
{
//this sets up the db connection
using (var db = new SHTFListContext())
{
//ToList() is a built-in method, and this is putting everything in the Category table into a list
return(db.Category.ToList());
}
}
public static int Create(string catName)
{
var db = new SHTFListContext();
var category = new Category {
Name = catName
};
db.Category.Add(category);
db.SaveChanges();
return(1);
}