public async Task <IActionResult> GetPictures(int id)
{
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (Request.Query.ContainsKey("id"))
{
id = Convert.ToInt32((Request.Query.FirstOrDefault(p => p.Key == "id").Value));
}
var pictures_ = (from pictures in db.Set <Pictures>()
join picture_writer in db.Set <Picture_writer>()
on pictures.Id_picture equals picture_writer.Id_picture
where picture_writer.Id_writer.Equals(id)
select new
{
Id_picture = pictures.Id_picture,
Picture_name = pictures.Picture_name,
Picture_link = pictures.Picture_link,
Picture_type = pictures.Picture_type,
}).ToList();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (pictures_ == null)
{
return(NotFound());
}
return(Ok(pictures_));
}
}
public async Task <IActionResult> GetUser(string log = " ", string pass = "******")
{
Users user = new Users();
if (Request.Query.ContainsKey("log") && Request.Query.ContainsKey("pass"))
{
log = (Request.Query.FirstOrDefault(p => p.Key == "log").Value);
pass = (Request.Query.FirstOrDefault(p => p.Key == "pass").Value);
}
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user1 = (from users in db.Set <Users>()
where users.Login == log &&
users.Password == pass
select users).ToList();
if (user1 == null)
{
return(NotFound());
}
return(Ok(user1));
}
}
public async Task <IActionResult> GetWorks(string work_name = "", string name = "")
{
Works _works = new Works();
if (Request.Query.ContainsKey("work_name"))
{
work_name = (Request.Query.FirstOrDefault(p => p.Key == "work_name").Value);
}
if (Request.Query.ContainsKey("name"))
{
name = (Request.Query.FirstOrDefault(p => p.Key == "name").Value);
}
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var works_ = (from works in db.Set <Works>()
join genre_of_literature in db.Set <Genres_of_literature>()
on works.Id_genre equals genre_of_literature.Id_genre
join writers in db.Set <Writers>()
on works.Id_writer equals writers.Id_writer
where writers.Full_name.Contains(name) &&
works.Work_name.Contains(work_name)
select new
{
Id_work = works.Id_work,
Id_writer = works.Id_writer,
Id_genre = works.Id_genre,
Work_name = works.Work_name,
Work_link = works.Work_link,
Work_description = works.Work_description,
Work_rating = works.Work_rating,
genre_name = genre_of_literature.Genre_name,
Id_Writer = writers.Id_writer,
Full_name = writers.Full_name,
Date_of_birth = writers.Date_of_birth,
Date_of_death = writers.Date_of_death,
Place_of_birth = writers.Place_of_birth,
Place_of_death = writers.Place_of_death,
Biography = writers.Biography
}).ToList();
if (works_ == null)
{
return(NotFound());
}
return(Ok(works_));
}
}
public async Task <IActionResult> GetRoutes(string route_name = "", string name = "", string nick = "")
{
Movies _movies = new Movies();
if (Request.Query.ContainsKey("route_name"))
{
route_name = (Request.Query.FirstOrDefault(p => p.Key == "route_name").Value);
}
if (Request.Query.ContainsKey("name"))
{
name = (Request.Query.FirstOrDefault(p => p.Key == "name").Value);
}
if (Request.Query.ContainsKey("nick"))
{
nick = (Request.Query.FirstOrDefault(p => p.Key == "nick").Value);
}
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var routes_ = (from routes in db.Set <Routes>()
join users in db.Set <Users>()
on routes.Id_user equals users.Id_user
join writers in db.Set <Writers>()
on routes.Id_writer equals writers.Id_writer
where writers.Full_name.Contains(name) &&
routes.Route_name.Contains(route_name) &&
users.Nick.Contains(nick)
select new
{
Id_route = routes.Id_route,
Route_name = routes.Route_name,
Id_user = routes.Id_user,
Id_writer = routes.Id_writer,
Date = routes.Date,
Route_description = routes.Route_description,
Route_rating = routes.Route_rating,
Full_name = writers.Full_name,
Nick = users.Nick
}).ToList();
if (routes_ == null)
{
return(NotFound());
}
return(Ok(routes_));
}
}
public async Task <IActionResult> GetMovies(string movie_title = "", string name = "")
{
Movies _movies = new Movies();
if (Request.Query.ContainsKey("movie_title"))
{
movie_title = (Request.Query.FirstOrDefault(p => p.Key == "movie_title").Value);
}
if (Request.Query.ContainsKey("name"))
{
name = (Request.Query.FirstOrDefault(p => p.Key == "name").Value);
}
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var movies_ = (from movies in db.Set <Movies>()
join movie_writer in db.Set <Movie_writer>()
on movies.Id_movie equals movie_writer.Id_movie
join writers in db.Set <Writers>()
on movie_writer.Id_writer equals writers.Id_writer
where writers.Full_name.Contains(name) &&
movies.Movie_title.Contains(movie_title)
select new
{
Id_movie = movies.Id_movie,
Movie_title = movies.Movie_title,
Movie_link = movies.Movie_link,
Year_of_issue = movies.Year_of_issue,
Movie_description = movies.Movie_description,
Movie_rating = movies.Movie_rating,
Id_writer = writers.Id_writer,
Full_name = writers.Full_name,
Date_of_birth = writers.Date_of_birth,
Date_of_death = writers.Date_of_death,
Place_of_birth = writers.Place_of_birth,
Place_of_death = writers.Place_of_death,
Biography = writers.Biography
}).ToList();
if (movies_ == null)
{
return(NotFound());
}
return(Ok(movies_));
}
}
public async Task <IActionResult> PostUser([FromBody] Users user)
{
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Users.Add(user);
await db.SaveChangesAsync();
return(CreatedAtAction(nameof(GetUser), new { log = user.Login, pass = user.Password }, user));
}
}
public async Task <IActionResult> PostRoute([FromBody] Routes route)
{
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Routes.Add(route);
await db.SaveChangesAsync();
return(CreatedAtAction(nameof(GetRoutes), new { route_name = route.Route_name }, route));
}
}
public async Task <IActionResult> GetRouteSpectacle(int id)
{
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (Request.Query.ContainsKey("id"))
{
id = Convert.ToInt32((Request.Query.FirstOrDefault(p => p.Key == "id").Value));
}
var spectacles_ = (from spectacles in db.Set <Spectacles>()
join route_spectacle in db.Set <Route_spectacle>()
on spectacles.Id_spectacle equals route_spectacle.Id_spectacle
join theaters in db.Set <Theaters>()
on spectacles.Id_theater equals theaters.Id_theater
where route_spectacle.Id_route.Equals(id)
select new
{
Id_spectacle = spectacles.Id_spectacle,
Id_theater = spectacles.Id_theater,
Spectacle_title = spectacles.Spectacle_title,
Director = spectacles.Director,
Spectacle_type = spectacles.Spectacle_type,
Spectacle_link = spectacles.Spectacle_link,
Spectacle_description = spectacles.Spectacle_description,
Spectacle_rating = spectacles.Spectacle_rating,
Id_Theater = theaters.Id_theater,
Theater_name = theaters.Theater_name,
Theater_site = theaters.Theater_site,
Theater_description = theaters.Theater_description,
Theater_address = theaters.Theater_address,
Latitude = theaters.Latitude,
Longitude = theaters.Longitude
}).ToList();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (spectacles_ == null)
{
return(NotFound());
}
return(Ok(spectacles_));
}
}
public async Task <IActionResult> GetRouteMuseum(int id)
{
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (Request.Query.ContainsKey("id"))
{
id = Convert.ToInt32((Request.Query.FirstOrDefault(p => p.Key == "id").Value));
}
var museums_ = (from museums in db.Set <Museums>()
join route_museum in db.Set <Route_museum>()
on museums.Id_museum equals route_museum.Id_museum
where route_museum.Id_route.Equals(id)
select new
{
Id_museum = museums.Id_museum,
Museum_name = museums.Museum_name,
Museum_site = museums.Museum_site,
Museum_description = museums.Museum_description,
Museum_rating = museums.Museum_rating,
Museum_address = museums.Museum_address,
Latitude = museums.Latitude,
Longitude = museums.Longitude
}).ToList();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (museums_ == null)
{
return(NotFound());
}
return(Ok(museums_));
}
}
public async Task <IActionResult> GetRoutePlace(int id)
{
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (Request.Query.ContainsKey("id"))
{
id = Convert.ToInt32((Request.Query.FirstOrDefault(p => p.Key == "id").Value));
}
var places_ = (from places in db.Set <Places>()
join route_place in db.Set <Route_place>()
on places.Id_place equals route_place.Id_place
where route_place.Id_route.Equals(id)
select new
{
Id_place = places.Id_place,
Place_name = places.Place_name,
Place_description = places.Place_description,
Place_rating = places.Place_rating,
Place_address = places.Place_address,
Latitude = places.Latitude,
Longitude = places.Longitude
}).ToList();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (places_ == null)
{
return(NotFound());
}
return(Ok(places_));
}
}
public CommentSpectacleController(LiteraryTourismContext context)
{
_context = context;
}
public async Task <IActionResult> GetSpectacles(string theater_name = "", string spectacle_title = "", string writer_name = "")
{
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if ((Request.Query.ContainsKey("theater_name")))
{
theater_name = (Request.Query.FirstOrDefault(p => p.Key == "theater_name").Value);
}
if ((Request.Query.ContainsKey("spectacle_title")))
{
spectacle_title = (Request.Query.FirstOrDefault(p => p.Key == "spectacle_title").Value);
}
if ((Request.Query.ContainsKey("writer_name")))
{
writer_name = (Request.Query.FirstOrDefault(p => p.Key == "writer_name").Value);
var spectacles_ = (from spectacles in db.Set <Spectacles>()
join theaters in db.Set <Theaters>()
on spectacles.Id_theater equals theaters.Id_theater
join spectacle_writer in db.Set <Spectacle_writer>()
on spectacles.Id_spectacle equals spectacle_writer.Id_spectacle
join writers in db.Set <Writers>()
on spectacle_writer.Id_writer equals writers.Id_writer
where theaters.Theater_name.Contains(theater_name) &&
spectacles.Spectacle_title.Contains(spectacle_title) &&
writers.Full_name.Contains(writer_name)
select new
{
Id_spectacle = spectacles.Id_spectacle,
Id_theater = spectacles.Id_theater,
Spectacle_title = spectacles.Spectacle_title,
Director = spectacles.Director,
Spectacle_type = spectacles.Spectacle_type,
Spectacle_link = spectacles.Spectacle_link,
Spectacle_description = spectacles.Spectacle_description,
Spectacle_rating = spectacles.Spectacle_rating,
Id_Theater = theaters.Id_theater,
Theater_name = theaters.Theater_name,
Theater_site = theaters.Theater_site,
Theater_description = theaters.Theater_description,
Theater_address = theaters.Theater_address,
Latitude = theaters.Latitude,
Longitude = theaters.Longitude,
}).Distinct().ToList();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (spectacles_ == null)
{
return(NotFound());
}
return(Ok(spectacles_));
}
else
{
var spectacles_ = (from spectacles in db.Set <Spectacles>()
join theaters in db.Set <Theaters>()
on spectacles.Id_theater equals theaters.Id_theater
where theaters.Theater_name.Contains(theater_name) &&
spectacles.Spectacle_title.Contains(spectacle_title)
select new
{
Id_spectacle = spectacles.Id_spectacle,
Id_theater = spectacles.Id_theater,
Spectacle_title = spectacles.Spectacle_title,
Director = spectacles.Director,
Spectacle_type = spectacles.Spectacle_type,
Spectacle_link = spectacles.Spectacle_link,
Spectacle_description = spectacles.Spectacle_description,
Spectacle_rating = spectacles.Spectacle_rating,
Id_Theater = theaters.Id_theater,
Theater_name = theaters.Theater_name,
Theater_site = theaters.Theater_site,
Theater_description = theaters.Theater_description,
Theater_address = theaters.Theater_address,
Latitude = theaters.Latitude,
Longitude = theaters.Longitude,
}).Distinct().ToList();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (spectacles_ == null)
{
return(NotFound());
}
return(Ok(spectacles_));
}
}
}
public SpectaclesController(LiteraryTourismContext context)
{
_context = context;
}
public PictureWriterController(LiteraryTourismContext context)
{
_context = context;
}
