public List<Subcategory> GetAllSubcategories()
{
using (var context = new CraigslistCloneEntities())
{
var subcategories = from s in context.Subcategories
join c in context.Categories on s.CategoryId equals c.CategoryId
select s;
Subcategories = new List<Subcategory>();
if (subcategories.Any())
{
foreach (var sub in subcategories)
{
Subcategories.Add(sub);
}
}
return Subcategories;
}
}
public List<Category> GetAllCategories()
{
using (var context = new CraigslistCloneEntities())
{
var categories = context.Categories;
if (!categories.Any())
{
throw new ApplicationException("No records exist.");
}
else
{
Categories = new List<Category>();
foreach (var category in categories)
{
Categories.Add(category);
}
return Categories;
}
}
}
public List<State> GetAllStates()
{
using (var context = new CraigslistCloneEntities())
{
var states = context.States;
States = new List<State>();
if (states.Any())
{
foreach (var state in states)
{
States.Add(state);
}
}
return States;
}
}
public List<Country> GetAllCountries()
{
using (var context = new CraigslistCloneEntities())
{
var countries = context.Countries;
Countries = new List<Country>();
if (countries.Any())
{
foreach (var country in countries)
{
Countries.Add(country);
}
}
return Countries;
}
}
public State GetStateByCode(string stateAbbrev)
{
try
{
using (var context = new CraigslistCloneEntities())
{
var singleState = context.States.First(s => s.StateAbbrev == stateAbbrev);
return singleState;
}
}
catch (Exception e)
{
throw new ApplicationException(e.Message + " " + e.StackTrace);
}
}
public List<City> GetCitiesByState(string stateAbbrev)
{
using (var context = new CraigslistCloneEntities())
{
var cities = from c in context.Cities
join s in context.States on c.StateId equals s.StateId
where s.StateAbbrev == stateAbbrev
select c;
Cities = new List<City>();
if (cities.Any())
{
foreach (var city in cities)
{
Cities.Add(city);
}
}
return Cities;
}
}
public List<City> GetAllCities()
{
using (var context = new CraigslistCloneEntities())
{
var cities = context.Cities;
Cities = new List<City>();
foreach (var city in cities)
{
Cities.Add(city);
}
}
return Cities;
}
