public ActionResult Index1(string Id, string clickinfo, string sessionvalue)
{
var db = new HolidayPlanner.Models.InfoData();
var db1 = new HolidayPlanner.Models.DataClasses1DataContext();
var cname = (from c in db1.Cities
where c.CityId == Id
select c.CityName).SingleOrDefault();
ViewData["Name"] = cname;
TempData["Data"] = Id;
switch (clickinfo)
{
case "hotels":
{
List<Hotel> abc = (from hot in db.Hotels
where hot.CityId == Id
select hot).ToList();
return View("Index1",abc);
}
}
return View();
}
public PartialViewResult HotelDetail()
{
var db = new HolidayPlanner.Models.InfoData();
List<HolidayPlanner.Models.Hotel> Hdetail = (from hot in db.Hotels
select hot).ToList();
return PartialView("HotelDetailPartial", Hdetail);
}
public ActionResult ValleyViewPune()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> valy = (from hot in db.Hotels
where hot.HTypeId == "VV" && hot.CityId == "PU"
select hot).ToList();
return View(valy);
}
public ActionResult RomanticPune()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> rom = (from hot in db.Hotels
where hot.HTypeId == "RM" && hot.CityId == "PU"
select hot).ToList();
return View(rom);
}
public ActionResult AddImage1(HotelModel model)
{
foreach (string file in Request.Files)
{
var postedFile = Request.Files[file];
var hname = new List<HolidayPlanner.Models.Hotel>();
InfoData dt = new InfoData();
hname = dt.Hotels.Where(x => x.HotelId == model.HotelId).ToList();
foreach (var st in hname)
{
string vat = st.HotelName;
bool exists = System.IO.Directory.Exists(Server.MapPath("~/Images" + vat + "/"));
var extension = Path.GetExtension(postedFile.FileName);
var newName = "19001";
if (!exists)
System.IO.Directory.CreateDirectory(Server.MapPath("~/Images" + vat + "/"));
//Directory.CreateDirectory(path);
postedFile.SaveAs(Server.MapPath("~/Images" + vat + "/") + newName + extension);
}
}
return RedirectToAction("Index");
}
public ActionResult HolyPlacesBangalore()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> holy = (from hot in db.Hotels
where hot.HTypeId == "HP" && hot.CityId == "BAN"
select hot).ToList();
return View(holy);
}
public ActionResult BeachesBangalore()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> beach = (from hot in db.Hotels
where hot.HTypeId == "BC" && hot.CityId == "BAN"
select hot).ToList();
return View(beach);
}
public ActionResult PureVegBangalore()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> pveg = (from hot in db.Hotels
where hot.HTypeId == "PV" && hot.CityId == "BAN"
select hot).ToList();
return View(pveg);
}
public ActionResult AdventureBangalore()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> adv = (from hot in db.Hotels
where hot.HTypeId == "AV" && hot.CityId == "BAN"
select hot).ToList();
return View(adv);
}
public ActionResult Review1(Review rev)
{
if (ModelState.IsValid)
{
using (var db = new HolidayPlanner.Models.InfoData())
{
var newReview = db.Reviews.Create();
int lastReviewId = db.Reviews.Max(item => item.ReviewId); //added by Sandy for ID Auto-Increment
rev.ReviewId = lastReviewId + 1;
newReview.ReviewId = rev.ReviewId;
newReview.ReviewDetails = rev.ReviewDetails;
newReview.Rating = rev.Rating;
newReview.HotelId = rev.HotelId;
newReview.UserId = rev.UserId;
db.Reviews.Add(newReview);
db.SaveChanges();
ViewBag.DataExists = true;
//TempData["AlertMessage"] = "Review Successfully Send ";
return RedirectToAction("First", "Home");
}
}
else
{
ModelState.AddModelError("", "Data is not correct");
}
return View();
}
public ActionResult bookingform(FormCollection Collection)
{
Random ran= new Random();
DateTime dt1, dt2;
var db= new HolidayPlanner.Models.InfoData();
Booking buk= new Booking();
DateTime.TryParse(Collection[5], out dt1);
DateTime.TryParse(Collection[6], out dt2);
buk.BookingId="B"+ran.Next();
buk.UserId = Convert.ToInt32(Collection[1]);
buk.ClientMobileNumber = Collection[2];
buk.ClientEmailId = Collection[3];
buk.HotelId = Convert.ToInt32(Collection[4]);
buk.CheckInDate = dt1;
buk.CheckOutDate = dt2;
buk.NoOfAdults = Convert.ToInt32(Collection[7]);
buk.NoOfChildren = Convert.ToInt32(Collection[8]);
buk.Message = Collection[9];
//buk.TotalAmount = Convert.ToDecimal(Collection[10]);
db.Bookings.Add(buk);
if (ModelState.IsValid)
{
db.SaveChanges();
return RedirectToAction("Success");
}
else
{
return RedirectToAction("Failed");
}
//var newrec = from c in db.Bookings
// select c;
//buk.UserId= Collection[0];
}
public ActionResult GetId(string name)
{
var db = new HolidayPlanner.Models.InfoData();
var id = from item in db.Hotels
where item.HotelName.Equals(name)
select item;
ViewData["Id"] = id;
return RedirectToAction("First");
}
//ended by sandy
public ActionResult Info(string clickinfo, int? HId)
{
var db = new HolidayPlanner.Models.InfoData();
switch(clickinfo)
{
case "hoteldetails":
{
var Hdetail = (from p in db.Hotels
where p.HotelId == HId
select p ).SingleOrDefault();
return View("Info", Hdetail);
}
case "overview":
{
var Odetail = from p in db.Hotels
where p.HotelId == HId
select new InfoViewModel { HotelDetails = p.HotelDetails };
return View("Overview", Odetail);
}
case "room":
{
var roominfo = from r in db.Rooms
where r.HotelId == HId
select new InfoViewModel { RoomType = r.RoomType, Rate = r.Rate, RoomDetails = r.RoomDetails, RoomCapacity = r.RoomCapacity };
return View("RoomInfo", roominfo);
}
case "facility":
{
var facilityinfo = from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.HotelId == HId
select new InfoViewModel { FacilityType = f.FacilitiesType, FoodDetails = h.FoodDetails, Policies = h.HotelPolices };
return View("FacilityInfo", facilityinfo);
}
case "review":
{
var review = from r in db.Reviews
where r.HotelId == HId
select new InfoViewModel { ReviewDetails = r.ReviewDetails, Rating = r.Rating };
return View("ReviewInfo", review);
}
case "Map":
{
MapLocation ml = new MapLocation();
var query = ml.Locations.First(c => c.HotelId == HId);
return View("MapInfo", query);
}
case "Image":
{
var hname = (from p in db.Hotels
where p.HotelId == HId
select p.HotelName).SingleOrDefault();
string[] src = new string[5];
src[0] = "~/Images/" + hname + "/19011.jpeg";
src[1] = "~/Images/" + hname + "/19013.jpeg";
src[2] = "~/Images/" + hname + "/19295_t.jpeg";
src[3] = "~/Images/" + hname + "/19016.jpeg";
src[4] = "~/Images/" + hname + "/19019.jpeg";
for (int i = 0; i < 5; i++)
{
string path = Server.MapPath(src[i]);
byte[] imageByteData = System.IO.File.ReadAllBytes(path);
string imageBase64Data = Convert.ToBase64String(imageByteData);
string imageDataURL = string.Format("data:image/png;base64,{0}", imageBase64Data);
//ViewBag.ImageData[i] = imageDataURL;
src[i] = imageDataURL;
}
ViewBag.ImageData = src;
return View("ImageInfo");
}
}
return View();
}
public ActionResult Demo(string clickinfo)
{
var db = new HolidayPlanner.Models.InfoData();
var dt=TempData.Peek("Data");
switch (clickinfo)
{
case "Distance100":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Distance == 100
select hot).ToList();
return View("Index1", holy);
}
case "Distance150":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Distance == 150
select hot).ToList();
return View("Index1", holy);
}
case "Distance200":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Distance == 200
select hot).ToList();
return View("Index1", holy);
}
case "Distance300":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Distance == 300
select hot).ToList();
return View("Index1", holy);
}
case "DistanceGreater300":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Distance > 300
select hot).ToList();
return View("Index1", holy);
}
case "CheapHotel":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Budget == "Cheap"
select hot).ToList();
return View("Index1", holy);
}
case "MidRangeHotel":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Budget == "Mid Range"
select hot).ToList();
return View("Index1", holy);
}
case "PremiumHotel":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Budget == "Premium"
select hot).ToList();
return View("Index1", holy);
}
case "LuxuryHotel":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Budget == "Luxury"
select hot).ToList();
return View("Index1", holy);
}
case "SwimmingPool":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Swimming Pool" && h.CityId == dt
select h).ToList();
return View("Index1", facilityinfo);
}
case "IndoorGames":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Indoor Games" && h.CityId == dt
select h).ToList();
return View("Index1", facilityinfo);
}
case "OutdoorGames":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Outdoor Games" && h.CityId == dt
select h).ToList();
return View("Index1", facilityinfo);
}
case "Spa":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Spa" && h.CityId == dt
select h).ToList();
return View("Index1", facilityinfo);
}
case "Garden":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Garden" && h.CityId == dt
select h).ToList();
return View("Index1", facilityinfo);
}
case "PartyHall":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Party Hall" && h.CityId == dt
select h).ToList();
return View("Index1", facilityinfo);
}
case "Bar":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Bar" && h.CityId == dt
select h).ToList();
return View("Index1", facilityinfo);
}
case "Ooty":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Address == "Ooty"
select hot).ToList();
return View("Index1", holy);
}
case "Mysore":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Address == "Mysore"
select hot).ToList();
return View("Index1", holy);
}
case "Sakleshpur":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Address == "Sakleshpur"
select hot).ToList();
return View("Index1", holy);
}
case "Coorg":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Address == "Coorg"
select hot).ToList();
return View("Index1", holy);
}
case "Coonoor":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == dt && hot.Address == "Coonoor"
select hot).ToList();
return View("Index1", holy);
}
case "Luxury":
{
List<Hotel> abc = (from hot in db.Hotels
where hot.HTypeId == "LU" && hot.CityId == dt
select hot).ToList();
return View("Index1", abc);
}
case "BeachFacing":
{
List<Hotel> bfac = (from hot in db.Hotels
where hot.HTypeId == "BF" && hot.CityId == dt
select hot).ToList();
return View("Index1", bfac);
}
case "Romantic":
{
List<Hotel> rom = (from hot in db.Hotels
where hot.HTypeId == "RM" && hot.CityId == dt
select hot).ToList();
return View("Index1", rom);
}
case "ValleyView":
{
List<Hotel> valy = (from hot in db.Hotels
where hot.HTypeId == "VV" && hot.CityId == dt
select hot).ToList();
return View("Index1", valy);
}
case "Adventure":
{
List<Hotel> adv = (from hot in db.Hotels
where hot.HTypeId == "AV" && hot.CityId == dt
select hot).ToList();
return View("Index1", adv);
}
case "RiverSide":
{
List<Hotel> rside = (from hot in db.Hotels
where hot.HTypeId == "RS" && hot.CityId == dt
select hot).ToList();
return View("Index1", rside);
}
case "PureVeg":
{
List<Hotel> pveg = (from hot in db.Hotels
where hot.HTypeId == "PV" && hot.CityId == dt
select hot).ToList();
return View("Index1", pveg);
}
case "PetFriendly":
{
List<Hotel> pet = (from hot in db.Hotels
where hot.HTypeId == "PF" && hot.CityId == dt
select hot).ToList();
return View("Index1", pet);
}
case "Beaches":
{
List<Hotel> beach = (from hot in db.Hotels
where hot.HTypeId == "BC" && hot.CityId == dt
select hot).ToList();
return View("Index1", beach);
}
case "HillStations":
{
List<Hotel> hill = (from hot in db.Hotels
where hot.HTypeId == "HS" && hot.CityId == dt
select hot).ToList();
return View("Index1", hill);
}
case "Farms":
{
List<Hotel> far = (from hot in db.Hotels
where hot.HTypeId == "FA" && hot.CityId == dt
select hot).ToList();
return View("Index1", far);
}
case "HolyPlaces":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.HTypeId == "HP" && hot.CityId == dt
select hot).ToList();
return View("Index1", holy);
}
}
return View();
}
public ActionResult HillStationsPune()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> hill = (from hot in db.Hotels
where hot.HTypeId == "HS" && hot.CityId == "PU"
select hot).ToList();
return View(hill);
}
public ActionResult LuxuryBangalore()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> abc = (from hot in db.Hotels
where hot.HTypeId == "LU" && hot.CityId == "BAN"
select hot).ToList();
return View(abc);
}
public ActionResult DistanceGreater300()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "MU" && hot.Distance > 300
select hot).ToList();
return View(holy);
}
public ActionResult RiverSideBangalore()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> rside = (from hot in db.Hotels
where hot.HTypeId == "RS" && hot.CityId == "BAN"
select hot).ToList();
return View(rside);
}
public ActionResult Karjet()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "MU" && hot.Address == "Karjet"
select hot).ToList();
return View(holy);
}
public ActionResult PetFriendlyBangalore()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> pet = (from hot in db.Hotels
where hot.HTypeId == "PF" && hot.CityId == "BAN"
select hot).ToList();
return View(pet);
}
public ActionResult LuxuryHotel()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "MU" && hot.Budget == "Luxury"
select hot).ToList();
return View(holy);
}
public ActionResult FarmsBangalore()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> far = (from hot in db.Hotels
where hot.HTypeId == "FA" && hot.CityId == "BAN"
select hot).ToList();
return View(far);
}
public ActionResult Bar()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Bar" && h.CityId == "MU"
select h).ToList();
return View(facilityinfo);
}
public ActionResult FirstBangalore(string clickinfo)
{
var db = new HolidayPlanner.Models.InfoData();
switch (clickinfo)
{
case "Distance100":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Distance == 100
select hot).ToList();
return View("FirstBangalore", holy);
}
case "Distance150":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Distance == 150
select hot).ToList();
return View("FirstBangalore", holy);
}
case "Distance200":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Distance == 200
select hot).ToList();
return View("FirstBangalore", holy);
}
case "Distance300":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Distance == 300
select hot).ToList();
return View("FirstBangalore", holy);
}
case "DistanceGreater300":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Distance > 300
select hot).ToList();
return View("FirstBangalore", holy);
}
case "CheapHotel":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Budget == "Cheap"
select hot).ToList();
return View("FirstBangalore", holy);
}
case "MidRangeHotel":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Budget == "Mid Range"
select hot).ToList();
return View("FirstBangalore", holy);
}
case "PremiumHotel":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Budget == "Premium"
select hot).ToList();
return View("FirstBangalore", holy);
}
case "LuxuryHotel":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Budget == "Luxury"
select hot).ToList();
return View("FirstBangalore", holy);
}
case "SwimmingPool":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Swimming Pool" && h.CityId == "BAN"
select h).ToList();
return View("FirstBangalore", facilityinfo);
}
case "IndoorGames":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Indoor Games" && h.CityId == "BAN"
select h).ToList();
return View("FirstBangalore", facilityinfo);
}
case "OutdoorGames":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Outdoor Games" && h.CityId == "BAN"
select h).ToList();
return View("FirstBangalore", facilityinfo);
}
case "Spa":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Spa" && h.CityId == "BAN"
select h).ToList();
return View("FirstBangalore", facilityinfo);
}
case "Garden":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Garden" && h.CityId == "BAN"
select h).ToList();
return View("FirstBangalore", facilityinfo);
}
case "PartyHall":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Party Hall" && h.CityId == "BAN"
select h).ToList();
return View("FirstBangalore", facilityinfo);
}
case "Bar":
{
List<Hotel> facilityinfo = (from f in db.Facilities
join h in db.Hotels
on f.HotelId equals h.HotelId
where f.FacilitiesType == "Bar" && h.CityId == "BAN"
select h).ToList();
return View("FirstBangalore", facilityinfo);
}
case "Ooty":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Address == "Ooty"
select hot).ToList();
return View("FirstBangalore", holy);
}
case "Mysore":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Address == "Mysore"
select hot).ToList();
return View("FirstBangalore", holy);
}
case "Sakleshpur":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Address == "Sakleshpur"
select hot).ToList();
return View("FirstBangalore", holy);
}
case "Coorg":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Address == "Coorg"
select hot).ToList();
return View("FirstBangalore", holy);
}
case "Coonoor":
{
List<Hotel> holy = (from hot in db.Hotels
where hot.CityId == "BAN" && hot.Address == "Coonoor"
select hot).ToList();
return View("FirstBangalore", holy);
}
}
return View();
}
public ActionResult BeachFacingPune()
{
var db = new HolidayPlanner.Models.InfoData();
List<Hotel> bfac = (from hot in db.Hotels
where hot.HTypeId == "BF" && hot.CityId == "PU"
select hot).ToList();
return View(bfac);
}