public List <Hotel> GetHotelsByName(string Name)
{
List <Hotel> HotelsListByName = new List <Hotel>();
using (dbcon = new TourismWebsiteDBEntities())
{
HotelsListByName = dbcon.Hotels.Where(x => (string)x.HotelName == Name).ToList();
}
return(HotelsListByName);
}
public ActionResult Signup(User model)
{
using (var context = new TourismWebsiteDBEntities())
{
context.Users.Add(model);
context.SaveChanges();
}
ModelState.Clear();
ViewBag.SuccessMethod = "Registration Successfull";
return(RedirectToAction("Login"));
}
public List <TouristPlace> GetPlacesByName(string Name)
{
List <TouristPlace> PlacesListbyName = new List <TouristPlace>();
using (dbcon = new TourismWebsiteDBEntities())
{
PlacesListbyName = dbcon.TouristPlaces.Where(x => (string)x.PlaceName == Name).ToList();
}
return(PlacesListbyName);
}
public Flight GetFlightName(int F_Id)
{
Flight F_Name = new Flight();
using (dbcon = new TourismWebsiteDBEntities())
{
F_Name = (Flight)dbcon.Flights.Where(x => x.F_Id == F_Id).First();
}
return(F_Name);
}
public List <Flight> GetAllFlights()
{
List <Flight> Flightlist = new List <Flight>();
using (dbcon = new TourismWebsiteDBEntities())
{
Flightlist = dbcon.Flights.ToList();
}
return(Flightlist);
}
public Hotel GetHotelPrice(int id)
{
Hotel HotelPrice = null;
using (dbcon = new TourismWebsiteDBEntities())
{
HotelPrice = (Hotel)dbcon.Hotels.Where(x => x.Id == id).First();
}
return(HotelPrice);
}
public List <Hotel> GetHotelsByLocation(int Locationid)
{
List <Hotel> HotelList = new List <Hotel>();
using (dbcon = new TourismWebsiteDBEntities())
{
HotelList = dbcon.Hotels.Where(x => (int)x.LocationId == Locationid).ToList();
}
return(HotelList);
}
public List <BlogSpace> GetBlogs(string title)
{
List <BlogSpace> BlogList = new List <BlogSpace>();
using (dbcon = new TourismWebsiteDBEntities())
{
BlogList = dbcon.BlogSpaces.Where(x => x.Title == title).ToList();
}
return(BlogList);
}
/* public List<double> GetCoordinates(string location)
* {
* List<double> coords = new List<double>();
* using (dbcon = new TourismWebsiteDBEntities())
* {
* var req = dbcon.Locations.Where(x => x.LocationName == location).FirstOrDefault();
* coords.Add(req.Latitude);
* coords.Add(req.Longitude);
*
* }
* return coords;
* }
*
*/
public Location GetCoordinates(string location)
{
Location coords = new Location();
using (dbcon = new TourismWebsiteDBEntities())
{
coords = dbcon.Locations.Where(x => x.LocationName == location).FirstOrDefault();
}
return(coords);
}
public List <TouristPlace> GetAllPlace()
{
List <TouristPlace> TPlaceList = new List <TouristPlace>();
using (dbcon = new TourismWebsiteDBEntities())
{
TPlaceList = dbcon.TouristPlaces.ToList();
}
return(TPlaceList);
}
public List <User> GetAllUsers()
{
List <User> UserList = new List <User>();
using (dbcon = new TourismWebsiteDBEntities())
{
UserList = dbcon.Users.ToList();
}
return(UserList);
}
public List <Hotel> GetAllHotel()
{
List <Hotel> Hotellist = new List <Hotel>();
using (dbcon = new TourismWebsiteDBEntities())
{
Hotellist = dbcon.Hotels.ToList();
}
return(Hotellist);
}
public List <Location> GetAllLocations()
{
List <Location> LocList = new List <Location>();
using (dbcon = new TourismWebsiteDBEntities())
{
LocList = dbcon.Locations.ToList();
}
return(LocList);
}
public List <BlogSpace> GetAllBlogs()
{
List <BlogSpace> Bloglist = new List <BlogSpace>();
using (dbcon = new TourismWebsiteDBEntities())
{
Bloglist = dbcon.BlogSpaces.ToList();
}
return(Bloglist);
}
public Flight GetFlightName(string F_Name)
{
Flight flight = null;
using (dbcon = new TourismWebsiteDBEntities())
{
flight = (Flight)dbcon.Flights.Where(x => x.F_Name == F_Name).First();
}
return(flight);
}
public List <Flight> GetFlightbyTime(string Departure_Time)
{
List <Flight> FlightList = new List <Flight>();
using (dbcon = new TourismWebsiteDBEntities())
{
FlightList = dbcon.Flights.Where(x => x.Departure_Time == Departure_Time).ToList();
}
return(FlightList);
}
public List <TouristPlace> GetPlacesByRating(int Rating)
{
List <TouristPlace> PlacesByRating = new List <TouristPlace>();
using (dbcon = new TourismWebsiteDBEntities())
{
PlacesByRating = dbcon.TouristPlaces.Where(x => x.Ratings == Rating).ToList();
}
return(PlacesByRating);
}
public List <TouristPlace> GetPlacesByLocation(int Locationid)
{
List <TouristPlace> PlacesListbyLocation = new List <TouristPlace>();
using (dbcon = new TourismWebsiteDBEntities())
{
PlacesListbyLocation = dbcon.TouristPlaces.Where(x => (int)x.LocationId == Locationid).ToList();
}
return(PlacesListbyLocation);
}
public List <Flight> GetFlightsbyLocation(int LocationId)
{
List <Flight> FlightList = new List <Flight>();
using (dbcon = new TourismWebsiteDBEntities())
{
FlightList = dbcon.Flights.Where(x => (int)x.LocationId == LocationId).ToList();
}
return(FlightList);
}
public Hotel GetHotel(int id)
{
Hotel hotel = new Hotel();
using (dbcon = new TourismWebsiteDBEntities())
{
hotel = dbcon.Hotels.Find(id);
}
return(hotel);
}
public Hotel DeleteHotel(int id)
{
//bool status = false;
Hotel hotel = new Hotel();
using (dbcon = new TourismWebsiteDBEntities())
{
hotel = dbcon.Hotels.Find(id);
dbcon.Hotels.Remove(hotel);
int change = dbcon.SaveChanges();
}
return(hotel);
}
public bool InsertFlight(Flight obj)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
dbcon.Flights.Add(obj);
int changes = dbcon.SaveChanges();
if (changes > 0)
{
status = true;
}
}
return(status);
}
public bool DeleteBlog(int id)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
var Todel = dbcon.BlogSpaces.Find(id);
dbcon.BlogSpaces.Remove(Todel);
int change = dbcon.SaveChanges();
if (change > 0)
{
status = true;
}
}
return(status);
}
public bool UpdateLocation(Location obj)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
dbcon.Locations.Add(obj);
int changes = dbcon.SaveChanges();
if (changes > 0)
{
status = true;
}
}
return(status);
}
public bool UpdateBlog(BlogSpace obj)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
dbcon.BlogSpaces.Add(obj);
int changes = dbcon.SaveChanges();
if (changes > 0)
{
status = true;
}
}
return(status);
}
public bool RatingAPlace(UserReview Review)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
dbcon.UserReviews.Add(Review);
int changes = dbcon.SaveChanges();
if (changes > 0)
{
status = true;
}
}
return(status);
}
public bool CreateUser(User obj)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
dbcon.Users.Add(obj);
int changes = dbcon.SaveChanges();
if (changes > 0)
{
status = true;
}
}
return(status);
}
public async Task <bool> InsertLocation(Location obj)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
dbcon.Locations.Add(obj);
int changes = await dbcon.SaveChangesAsync();
if (changes > 0)
{
status = true;
}
}
return(status);
}
public bool UpdateUser(User obj)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
var uobj = dbcon.Users.Where(x => x.UserId == obj.UserId).First();
uobj.UserName = obj.UserName;
uobj.Isactive = obj.Isactive;
uobj.ContactNumber = obj.ContactNumber;
int changes = dbcon.SaveChanges();
if (changes > 0)
{
status = true;
}
}
return(status);
}
public bool UpdatePlace(TouristPlace obj)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
var uobj = dbcon.TouristPlaces.Where(x => x.Id == obj.Id).First();
uobj.PlaceName = obj.PlaceName;
uobj.Ratings = obj.Ratings;
int changes = dbcon.SaveChanges();
if (changes > 0)
{
status = true;
}
}
return(status);
}
