public ActionResult Search(string searching, DateTime?Sstartdate, DateTime?Enddate, int?occupantsearch)
{
string Searching = searching.ToUpper();
var Hous = db.Houses.Include(xxx => xxx.Reservations).Include(mmn => mmn.Location).Where(x => x.Location.NameCity.Contains(Searching));// && x.Address.Contains(Address));
var res = db.Reservations.Where(c => (c.StartDate <= Sstartdate.Value) && (c.EndDate >= Sstartdate.Value));
var res2 = db.Reservations.Where(f => (f.EndDate >= Enddate.Value) && (f.StartDate <= Enddate.Value));
var res4 = db.Reservations.Where(d => (d.StartDate >= Sstartdate.Value) && (d.StartDate <= Enddate.Value));
var res3 = res.Concat(res2).Concat(res4);
if (Sstartdate == null && Enddate == null)
{
res3 = db.Reservations;
}
//return View(db.Reservations.Include(mmn => mmn.HouseRes).Where(x => x.EndDate < StartDateSearch || x.StartDate > EndDateSearch || StartDateSearch == null || EndDateSearch == null).ToList());
HousesDates to_search_mas = new HousesDates {
houses = Hous.ToList(), reservations = res3.ToList()
};
if (to_search_mas == null)
{
ViewBag.Message = "T4TripSearCh."; return(View());
}
ViewBag.Message = "T4TripSearCh.";
return(View(to_search_mas));
}
public ActionResult Index(string searching, DateTime?Sstartdate, DateTime?Enddate, int?occupantsearch)
{
var Hous = db.Houses.Include(xxx => xxx.Reservations).Include(mmn => mmn.Location).Where(x => x.Location.NameCity.Contains(searching) && x.MaxOccupancy >= occupantsearch);
var res = db.Reservations.Where(c => (c.StartDate <= Sstartdate.Value) && (c.EndDate >= Sstartdate.Value) && (c.StartDate >= Sstartdate.Value) && (c.StartDate <= Enddate.Value) && (c.EndDate >= Enddate.Value) && (c.StartDate <= Enddate.Value));
// var res2 = db.Reservations.Where(f => (f.EndDate >= Enddate.Value)&& (f.StartDate<= Enddate.Value));
// var res3 = res.Concat(res2);
if (Sstartdate == null && Enddate == null)
{
res = db.Reservations;
}
HousesDates to_search_mas = new HousesDates {
houses = Hous.ToList(), reservations = res.ToList()
};
if (to_search_mas == null)
{
return(View());
}
return(View(to_search_mas));
//return View();
}
public ActionResult Search(string searching, string Address, DateTime?Sstartdate, DateTime?Enddate)
{
var Hous = db.Houses.Include(xxx => xxx.Reservations).Include(mmn => mmn.Location).Where(x => x.Location.NameCity.Contains(searching) && x.Address.Contains(Address));
var res = db.Reservations.Where(c => (c.StartDate <= Sstartdate.Value) && (c.EndDate >= Sstartdate.Value) && (c.StartDate >= Sstartdate.Value) && (c.StartDate <= Enddate.Value) && (c.EndDate >= Enddate.Value) && (c.StartDate <= Enddate.Value));
// var res2 = db.Reservations.Where(f => (f.EndDate >= Enddate.Value)&& (f.StartDate<= Enddate.Value));
// var res3 = res.Concat(res2);
if (Sstartdate == null && Enddate == null)
{
res = db.Reservations;
}
HousesDates to_search_mas = new HousesDates {
houses = Hous.ToList(), reservations = res.ToList()
};
if (to_search_mas == null)
{
ViewBag.Message = "T4TripSearCh."; return(View());
}
ViewBag.Message = "T4TripSearCh.";
return(View(to_search_mas));
}
public ActionResult Search(string searching, DateTime?Sstartdate, DateTime?Enddate, int?occupantsearch)
{
var Hous = db.Houses.Include(xxx => xxx.Reservations).Include(mmn => mmn.Location).Where(x => x.Location.NameCity.Contains(searching)).Where(l => l.MaxOccupancy >= occupantsearch);
if (occupantsearch == null)
{
Hous = db.Houses.Include(xxx => xxx.Reservations).Include(mmn => mmn.Location).Where(x => x.Location.NameCity.Contains(searching));
}
var res = db.Reservations.Where(c => (c.StartDate <= Sstartdate.Value) && (c.EndDate >= Sstartdate.Value)).ToList();
var res2 = db.Reservations.Where(c => (c.StartDate >= Sstartdate.Value) && (c.StartDate <= Enddate.Value)).ToList();
var res3 = db.Reservations.Where(c => (c.EndDate >= Enddate.Value) && (c.StartDate <= Enddate.Value)).ToList();
var res12 = res.Concat(res2);
var res4 = res3.Concat(res12);
//var res4 = db.Reservations.Where(c => c.StartDate >= Sstartdate.Value && c.EndDate <= Enddate.Value).ToList();
// var res2 = db.Reservations.Where(f => (f.EndDate >= Enddate.Value)&& (f.StartDate<= Enddate.Value));
// var res3 = res.Concat(res2);
if (Sstartdate == null && Enddate == null)
{
res4 = db.Reservations.ToList();
}
var ImagesofHouses = db.HouseImages;
HousesDates to_search_mas = new HousesDates {
houses = Hous.ToList(), reservations = res4.Distinct().ToList(), HouseImages = ImagesofHouses.ToList()
};
if (to_search_mas == null)
{
return(View());
}
return(View(to_search_mas));
// var Hous = db.Houses.Include(xxx => xxx.Reservations).Include(mmn => mmn.Location).Where(x => x.Location.NameCity.Contains(searching) && x.Address.Contains(Address));
// var res = db.Reservations.Where(c => (c.StartDate <= Sstartdate.Value) && (c.EndDate >= Sstartdate.Value));
// var res2 = db.Reservations.Where(f => (f.EndDate >= Enddate.Value)&& (f.StartDate<= Enddate.Value));
// var res4 = db.Reservations.Where(d=>(d.StartDate >= Sstartdate.Value) && (d.StartDate <= Enddate.Value));
//var res3 = res.Concat(res2).Concat(res4);
// if (Sstartdate == null && Enddate == null) { res3 = db.Reservations; }
// HousesDates to_search_mas = new HousesDates { houses = Hous.ToList(), reservations = res3.ToList() };
// if (to_search_mas == null) { ViewBag.Message = "T4TripSearCh."; return View(); }
// ViewBag.Message = "T4TripSearCh.";
// return View(to_search_mas);
}
