static List <image> GetImagesForCategory(tourcategory cat)
{
TourContext db = new TourContext();
List <image> result = (from image in db.images where image.IdTourCategory == cat.IdTourCategory select image).ToList <image>();
return(result);
}
public TourCategoryInfo(int idCategory)
{
tourcategory t = db.tourcategories.Find(idCategory);
IdTourCategory = idCategory;
Name = t.Name;
Images = ImageInfo.GetImagesForElem("category", IdTourCategory);
}
public void EditTourCategory(int id, [FromBody] tourcategory tourCategory)
{
if (id == tourCategory.IdTourCategory)
{
db.Entry(tourCategory).State = EntityState.Modified;
db.SaveChanges();
}
}
public void DeleteTourCategory(int id)
{
tourcategory tourCategory = db.tourcategories.Find(id);
if (tourCategory != null)
{
db.tourcategories.Remove(tourCategory);
db.SaveChanges();
}
}
public static List <TourInfo> GetListTourByCategory(int idCategory)
{
TourContext db = new TourContext();
List <TourInfo> result = new List <TourInfo>();
tourcategory tourCategory = db.tourcategories.Find(idCategory);
List <tour> tours = tourCategory.tours.ToList <tour>();
foreach (tour t in tours)
{
TourInfo nTourInfo = new TourInfo(t.IdTour);
result.Add(nTourInfo);
}
return(result);
}
public static List <ImageInfo> GetImagesForElem(string typeElem, int idElem)
{
TourContext db = new TourContext();
List <ImageInfo> result = new List <ImageInfo>();
List <image> images = new List <image>();
switch (typeElem)
{
case "category":
{
tourcategory cat = db.tourcategories.Find(idElem);
images = GetImagesForCategory(cat);
break;
}
case "tour":
{
tour t = db.tours.SingleOrDefault <tour>(m => m.IdTour == idElem);
images = GetImagesForTour(t);
break;
}
case "city":
{
city c = db.cities.SingleOrDefault <city>(m => m.IdCity == idElem);
images = GetImagesForCity(c);
break;
}
}
foreach (image im in images)
{
ImageInfo nImageInfo = new ImageInfo(im);
result.Add(nImageInfo);
}
return(result);
}
public void CreateTourCategory([FromBody] tourcategory tourCategory)
{
db.tourcategories.Add(tourCategory);
db.SaveChanges();
}
