public static List <Model.City> GetCitiesByState(int stateId)
{
List <Model.City> cities;
using (var context = new MedingenioContext())
{
cities = context.Cities.Where(c => c.StateId == stateId).ToList();
}
return(cities);
}
public static List <Model.State> GetStates()
{
List <Model.State> states;
using (var context = new MedingenioContext())
{
states = context.States.ToList();
}
return(states);
}
public void CityPost()
{
_medingenioContext = new MedingenioContext();
var city = new City {
Name = "Test State", StateId = 1
};
_medingenioContext.Cities.Add(city);
_medingenioContext.SaveChanges();
}
public void StatePost()
{
_medingenioContext = new MedingenioContext();
var state = new State {
Name = "Test State"
};
_medingenioContext.States.Add(state);
_medingenioContext.SaveChanges();
}
public static List <Model.Menu> GetByCompany(int companyId)
{
List <Model.Menu> menus;
using (var context = new MedingenioContext())
{
menus = context.Menus.Where(m => m.Companies.Any(c => c.Id == companyId)).ToList();
}
return(menus);
}
public static Model.Company Get(int companyId)
{
Model.Company company;
using (var context = new MedingenioContext())
{
company = context.Companies.FirstOrDefault(c => c.Id == companyId);
}
return(company);
}
