public IHttpActionResult GetRentaCarById(int rentaCarId)
{
RentaCar rentaCar = new RentaCar();
try
{
rentaCar = objEntity.RentaCars.Find(rentaCarId);
if (rentaCar == null)
{
rentaCar = new RentaCar();
rentaCar.Status = 0;
}
else
{
rentaCar.Status = 1;
}
}
catch (Exception)
{
throw;
}
return(Ok(rentaCar));
}
public IHttpActionResult PutRentaCar(RentaCar data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
RentaCar rentaCar = new RentaCar();
rentaCar = objEntity.RentaCars.Find(data.Id);
if (rentaCar != null)
{
rentaCar.Id = data.Id;
rentaCar.Name = data.Name;
rentaCar.Address = data.Address;
rentaCar.City = data.City;
rentaCar.Description = data.Description;
rentaCar.Rate = data.Rate;
rentaCar.RatedBy = data.RatedBy;
rentaCar.CarAdminId = data.CarAdminId;
}
int i = objEntity.SaveChanges();
}
catch (Exception)
{
throw;
}
return(Ok(data));
}
public IHttpActionResult PostRentaCarRate(string rate, string userId, string rentaCarId)
{
RentaCarRate rentaCarRate = new RentaCarRate();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
rentaCarRate.Rate = Convert.ToInt32(rate);
rentaCarRate.RentaCarId = Convert.ToInt32(rentaCarId);
rentaCarRate.UserId = Convert.ToInt32(userId);
rentaCarRate.RateDate = DateTime.Now;
objEntity.RentaCarRates.Add(rentaCarRate);
RentaCar rentaCar = objEntity.RentaCars.Find(rentaCarRate.RentaCarId);
double sum = rentaCar.Rate * rentaCar.RatedBy + rentaCarRate.Rate;
rentaCar.RatedBy++;
rentaCar.Rate = Math.Round((sum / rentaCar.RatedBy), 2);
objEntity.SaveChanges();
}
catch (Exception)
{
throw;
}
return(Ok(rentaCarRate));
}
public IHttpActionResult DeleteRentaCar(int id)
{
RentaCar rentaCar = objEntity.RentaCars.Find(id);
if (rentaCar == null)
{
return(NotFound());
}
objEntity.RentaCars.Remove(rentaCar);
objEntity.SaveChanges();
return(Ok(rentaCar));
}
public IQueryable <RentaCar> GetRentaCarByLocation(string rentaCarLocation)
{
RentaCar rentaCar = new RentaCar();
string ifSmall = rentaCarLocation.First().ToString().ToUpper() +
String.Join("", rentaCarLocation.Skip(1));
try
{
return(objEntity.RentaCars.Where(c => c.City.Contains(rentaCarLocation) && c.City.Contains(ifSmall)));
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult PostRentaCar(RentaCar data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
data.Rate = 0;
data.RatedBy = 0;
objEntity.RentaCars.Add(data);
objEntity.SaveChanges();
}
catch (Exception)
{
throw;
}
return(Ok(data));
}
public bool DodajRCVozila(string grad, int idRentaCar, string[] registracije)
{
return(RentaCar.DodajRCVozila(grad, idRentaCar, registracije, idAplikacije));
}
/*:: VOZILA ::*/
public int DodajRCVozilo(string grad, int idRentaCar, string registracija)
{
return(RentaCar.DodajRCVozilo(grad, idRentaCar, registracija, idAplikacije));
}
public bool PoveziRentaCar(string grad, int idRente, string naziv, string email, string mobitel, out int idKorisnikaGO,
out int idKlasifikacije)
{
return(RentaCar.PoveziRentaCar(grad, idRente, naziv, email, mobitel, out idKorisnikaGO,
out idKlasifikacije, idAplikacije));
}
public bool ObrisiRentaCar(string grad, int idRente)
{
return(RentaCar.ObrisiRentaCar(grad, idRente, idAplikacije));
}
public bool IzmjeniRentaCar(string grad, _RentaCar renta)
{
return(RentaCar.IzmjeniRentaCar(grad, renta, idAplikacije));
}
public _RentaCar DodajRentaCar(string grad, _RentaCar renta)
{
return(RentaCar.DodajRentaCar(grad, renta, idAplikacije));
}
public List <string> RatesReport(string rentaCarId, string period)
{
RentaCar rentaCar = objEntity.RentaCars.Find(Convert.ToInt32(rentaCarId));
List <int> carsIds = new List <int>();
foreach (Car car in objEntity.Cars.Where(c => c.RentaCarId == rentaCar.Id))
{
carsIds.Add(car.Id);
}
List <string> reports = new List <string>();
IQueryable <CarRate> carRates = objEntity.CarRates.Where(carRate => carsIds.Contains(carRate.CarId));
IQueryable <RentaCarRate> rentaCarRates = objEntity.RentaCarRates.Where(rentaCarRate => rentaCarRate.RentaCarId.ToString() == rentaCarId);
IQueryable <Car> cars = objEntity.Cars.Where(car => car.RentaCarId.ToString() == rentaCarId);
DateTime yesterday = DateTime.Today.AddDays(-1);
DateTime weekAgo = DateTime.Today.AddDays(-7);
DateTime monthAgo = DateTime.Today.AddMonths(-1);
DateTime yearAgo = DateTime.Today.AddYears(-1);
switch (period)
{
case "day":
{
carRates = carRates.Where(cr => cr.RateDate >= yesterday);
rentaCarRates = rentaCarRates.Where(rcr => rcr.RateDate >= yesterday);
}
break;
case "week":
{
carRates = carRates.Where(cr => cr.RateDate >= weekAgo);
rentaCarRates = rentaCarRates.Where(rcr => rcr.RateDate >= weekAgo);
}
break;
case "month":
{
carRates = carRates.Where(cr => cr.RateDate >= monthAgo);
rentaCarRates = rentaCarRates.Where(rcr => rcr.RateDate >= monthAgo);
}
break;
case "year":
{
carRates = carRates.Where(cr => cr.RateDate >= yearAgo);
rentaCarRates = rentaCarRates.Where(rcr => rcr.RateDate >= yearAgo);
}
break;
default:
break;
}
reports.Add(" ");
reports.Add("Rent-a-car service rates: ");
reports.Add(" ");
reports.Add(" ");
foreach (RentaCarRate rcr in rentaCarRates)
{
reports.Add(UserNameLastName(rcr.UserId) + " rated with " + rcr.Rate + " on " + rcr.RateDate.ToShortDateString() + ".");
reports.Add(" ");
}
reports.Add("Average rate of this rent-a-car service is " + rentaCar.Rate);
reports.Add(" ");
reports.Add(" ");
reports.Add("Car rates: ");
reports.Add(" ");
reports.Add(" ");
foreach (CarRate cr in carRates)
{
reports.Add(UserNameLastName(cr.UserId) + " rated car " + CarName(cr.CarId) + " with " + cr.Rate + " on " + cr.RateDate.ToShortDateString() + ".");
reports.Add(" ");
}
reports.Add(" ");
reports.Add(" ");
foreach (Car c in cars)
{
reports.Add("Average rate of car " + c.Name + " is " + c.Rate);
reports.Add(" ");
}
reports.Add(" ");
reports.Add(" ");
return(reports);
}
public bool IzmjeniRCVozilo(string grad, int idVozila, string registracija)
{
return(RentaCar.IzmjeniRCVozilo(grad, idVozila, registracija, idAplikacije));
}
/*:: RENTACAR ::*/
#region RENT-A-CAR
public List <_RentaCar> DohvatiRentaCar(string grad)
{
return(RentaCar.DohvatiRentaCar(grad, idAplikacije));
}
public bool ObrisiRCVozilo(string grad, int idVozila)
{
return(RentaCar.ObrisiRCVozilo(grad, idVozila, idAplikacije));
}
public List <string> IncomeReport(string rentaCarId, string period)
{
RentaCar rentaCar = objEntity.RentaCars.Find(Convert.ToInt32(rentaCarId));
List <int> carsIds = new List <int>();
foreach (Car car in objEntity.Cars.Where(c => c.RentaCarId == rentaCar.Id))
{
carsIds.Add(car.Id);
}
IQueryable <CarReservation> reservations = objEntity.CarReservations.Where(reservation => carsIds.Contains(reservation.CarId));
DateTime yesterday = DateTime.Today.AddDays(-1);
DateTime weekAgo = DateTime.Today.AddDays(-7);
DateTime monthAgo = DateTime.Today.AddMonths(-1);
DateTime yearAgo = DateTime.Today.AddYears(-1);
switch (period)
{
case "day":
reservations = reservations.Where(reservation => reservation.DateFrom >= yesterday);
break;
case "week":
reservations = reservations.Where(reservation => reservation.DateFrom >= weekAgo);
break;
case "month":
reservations = reservations.Where(reservation => reservation.DateFrom >= monthAgo);
break;
case "year":
reservations = reservations.Where(reservation => reservation.DateFrom >= yearAgo);
break;
default:
break;
}
List <string> reports = new List <string>();
double income = 0;
reports.Add(" ");
reports.Add(" ");
reports.Add("Income report: ");
reports.Add(" ");
foreach (CarReservation reservation in reservations)
{
reports.Add("Reservation of car " + reservation.CarName + " from " + reservation.DateFrom.ToShortDateString()
+ " to " + reservation.DateTo.Date.ToShortDateString() + " cost " + reservation.Price);
income += (double)reservation.Price;
reports.Add(" ");
}
reports.Add(" ");
reports.Add(" ");
reports.Add("Total income: " + income);
return(reports);
}
