// GET: ReportsRencentCars
public ActionResult Index()
{
//using LINQ
CustomersRevervationsDataContext crdc = new CustomersRevervationsDataContext();
var recentCars = (from reservations in crdc.Reservations
where reservations.StartDate.Date >= DateTime.Now.AddDays(-6).Date&& reservations.ReservStatsID == 1
orderby reservations.StartDate descending
select new Models.DTO.Reservation {
carPlate = reservations.CarPlate, costumerID = reservations.CostumerID, startDate = reservations.StartDate, endDate = reservations.EndDate, location = reservations.Location, couponCode = reservations.CouponCode
}).ToList();
recent = recentCars;
return(View(recent));
}
// GET: ReportsCars
public ActionResult Index(string startDate, string endDate, string condition)
{
//using LINQ
CustomersRevervationsDataContext crdc = new CustomersRevervationsDataContext();
ReservationValidationsService reservationValidations = ReservationValidationsService.Instance;
if (!String.IsNullOrEmpty(condition) && !String.IsNullOrEmpty(startDate) && !String.IsNullOrEmpty(endDate))
{
List <NrCarReserv> mostRentedCars = (from reservations in crdc.Reservations
group reservations by reservations.CarPlate into g
join cars in crdc.Cars on g.FirstOrDefault().CarPlate equals cars.Plate
orderby g.Count() descending
select new NrCarReserv {
plate = cars.Plate, manufacturer = cars.Manufacturer, model = cars.Model, price = cars.PricePerDay, location = cars.Location, reservNr = g.Count(r => r.StartDate.Date >= DateTime.Parse(startDate).Date&& r.EndDate.Date <= DateTime.Parse(endDate).Date)
}).Take(5).ToList();
List <NrCarReserv> lessRentedCars = (from reservations in crdc.Reservations
group reservations by reservations.CarPlate into g
join cars in crdc.Cars on g.FirstOrDefault().CarPlate equals cars.Plate
orderby g.Count() ascending
select new NrCarReserv {
plate = cars.Plate, manufacturer = cars.Manufacturer, model = cars.Model, price = cars.PricePerDay, location = cars.Location, reservNr = g.Count(r => r.StartDate.Date >= DateTime.Parse(startDate).Date&& r.EndDate.Date <= DateTime.Parse(endDate).Date)
}).Take(5).ToList();
if (!reservationValidations.validateDate(DateTime.Parse(startDate), DateTime.Parse(endDate)))
{
ViewBag.Message = "End Date should be equal or higher than Start Date";
}
else
{
if (condition == "MOST")
{
carsNr = mostRentedCars;
return(View(carsNr));
}
else
{
carsNr = lessRentedCars;
return(View(carsNr));
}
}
}
else
{
ViewBag.Message = "All field inputs are mandatory for returning the report";
}
return(View(carsNr));
}
// GET: Reports
public ActionResult Index()
{
//using LINQ
CustomersRevervationsDataContext crdc = new CustomersRevervationsDataContext();
var goldCustomers = (from reservations in crdc.Reservations
group reservations by reservations.CostumerID into g
join customers in crdc.Customers on g.FirstOrDefault().CostumerID equals customers.CostumerID
where g.FirstOrDefault().StartDate.Date >= DateTime.Now.AddDays(-30).Date&& (g.Count() >= 3)
orderby g.Count() descending
select new GoldSilverCustomers {
name = customers.Name, reservationsNr = (g.Count())
}).ToList();
customers = goldCustomers;
return(View(goldCustomers));
}
// GET: Car
public ActionResult Index(string plate, string model, string city, string sortOrder, string startDate, string EndDate)
{
CustomersRevervationsDataContext crdc = new CustomersRevervationsDataContext();
ViewBag.IdSortParam = String.IsNullOrEmpty(sortOrder) ? "Car ID_desc" : "";
ViewBag.PlateSortParam = sortOrder == "Car Plate" ? "Car Plate_desc" : "Car Plate";
ViewBag.ManufacturerSortParam = sortOrder == "Manufacturer" ? "Manufacturer_desc" : "Manufacturer";
ViewBag.ModelSortParam = sortOrder == "Model" ? "Model_desc" : "Model";
ViewBag.PriceSortParam = sortOrder == "Price" ? "Price_desc" : "Price";
ViewBag.LocationSortParam = sortOrder == "Location" ? "Location_desc" : "Location";
//USING LINQ
allCars = from c in crdc.Cars select c;
switch (sortOrder)
{
case "Car ID_desc":
allCars = allCars.OrderByDescending(c => c.CarID);
break;
case "Car Plate":
allCars = allCars.OrderBy(c => c.Plate);
break;
case "Car Plate_desc":
allCars = allCars.OrderByDescending(c => c.Plate);
break;
case "Manufacturer":
allCars = allCars.OrderBy(c => c.Manufacturer);
break;
case "Manufacturer_desc":
allCars = allCars.OrderByDescending(c => c.Manufacturer);
break;
case "Model":
allCars = allCars.OrderBy(c => c.Model);
break;
case "Model_desc":
allCars = allCars.OrderByDescending(c => c.Model);
break;
case "Price":
allCars = allCars.OrderBy(c => c.PricePerDay);
break;
case "Price_desc":
allCars = allCars.OrderByDescending(c => c.PricePerDay);
break;
case "Location":
allCars = allCars.OrderBy(c => c.Location);
break;
case "Location_desc":
allCars = allCars.OrderByDescending(c => c.Location);
break;
default:
allCars = allCars.OrderBy(c => c.CarID);
break;
}
//this reservation is just for testing, for not having a null one when the INSERT condtion is not met because the reservation status is <> 1 (when searching db records)
Reservation r = new Reservation(0, "", 0, 1, DateTime.Now, DateTime.Now, "", "");
if (!String.IsNullOrEmpty(model) && String.IsNullOrEmpty(plate) && String.IsNullOrEmpty(city))
{
if (!carValidations.validateCarModel(model.Trim()))
{
ViewBag.Message = "This model does not exist, please enter another model";
}
else
{
allCars = allCars.Where(c => c.Model.ToLower().Equals(model.Trim().ToLower()));
return(View(allCars));
}
}
else if (String.IsNullOrEmpty(model) && String.IsNullOrEmpty(plate) && !String.IsNullOrEmpty(city))
{
if (!carValidations.validateCity(city.Trim()))
{
ViewBag.Message = "This location does not exist, please enter another location";
}
else
{
allCars = allCars.Where(c => c.Location.ToLower().Equals(city.Trim().ToLower()));
return(View(allCars));
}
}
else if (String.IsNullOrEmpty(model) && !String.IsNullOrEmpty(plate) && String.IsNullOrEmpty(city) && String.IsNullOrEmpty(startDate) && String.IsNullOrEmpty(EndDate))
{
if (!carValidations.validateCarPlate(plate.Trim()))
{
if (!Regex.IsMatch(plate, "[A-Z]{2} [0-9]{2} [A-Z]{3}"))
{
ViewBag.Message = "Invalid input type, the car plate format should be: ZZ 00 ZZZ";
}
else
{
ViewBag.Message = "This car plate does not exist, please enter another plate";
}
}
else
{
allCars = allCars.Where(c => c.Plate.ToLower().Equals(plate.Trim().ToLower()));
return(View(allCars));
}
}
else if (String.IsNullOrEmpty(model) && !String.IsNullOrEmpty(plate) && String.IsNullOrEmpty(city) && !String.IsNullOrEmpty(startDate) && !String.IsNullOrEmpty(EndDate))
{
if (!carValidations.validateCarPlate(plate.Trim().ToLower()))
{
if (!Regex.IsMatch(plate.Trim(), "[A-Z]{2} [0-9]{2} [A-Z]{3}"))
{
ViewBag.Message = "Invalid input type, the car plate format should be: ZZ 00 ZZZ";
}
else
{
ViewBag.Message = "This car plate does not exist, please enter another plate";
}
}
else
{
allCars = allCars.Where(c => c.Plate.ToLower().Equals(plate.Trim().ToLower()));
if (!reservationValidations.validateDate(DateTime.Parse(startDate), DateTime.Parse(EndDate)))
{
ViewBag.Message = "End Date should be equal or higher than Start Date";
}
else if (!reservationValidations.validateRentPeriod(allCars.FirstOrDefault().Plate, DateTime.Parse(startDate), DateTime.Parse(EndDate), "INSERT", r))
{
ViewBag.Message = "The selected car was already rented in this period";
}
else
{
return(View(allCars));
}
}
}
else if (String.IsNullOrEmpty(model) && String.IsNullOrEmpty(plate) && String.IsNullOrEmpty(city) && String.IsNullOrEmpty(startDate) && String.IsNullOrEmpty(EndDate))
{
return(View(allCars));
}
else
{
ViewBag.Message = (" Each search field is independent, and ONLY the Car Plate is linked to the Start/End Dates;\n" +
" You can search only by a single criteria, or by Car Plate and Start/End Dates, or leave all criterias blank for returning all cars;\n");
}
return(View(allCars));
}
