public async Task <IActionResult> GetTrip([FromRoute] int id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
TripModel model;
try
{
var dao = new TripDao(_db);
model = await dao.getTripAsync(id);
}
catch (Exception e)
{
return(BadRequest(new { message = ErrorUtils.dbErrorMessage($"Can't get Trip with id={id}", e) }));
}
if (model == null)
{
return(NotFound());
}
return(Ok(model));
}
public async Task <IActionResult> PutTrip([FromRoute] int id, [FromBody] TripModel tripModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tripModel.tripId)
{
return(BadRequest());
}
if (!TripExists(id))
{
return(NotFound());
}
try
{
var dao = new TripDao(_db);
tripModel = await dao.saveTripAsync(tripModel);
}
catch (Exception e)
{
if (!TripExists(id))
{
return(NotFound());
}
return(BadRequest(new { message = ErrorUtils.dbErrorMessage($"Can't save Trip with id={id}", e) }));
}
return(NoContent()); // Or Ok(tripModel);
}
public async Task <IActionResult> GetAll()
{
var dao = new TripDao(_db);
var models = await dao.getTripsAsync();
return(Ok(models));
}
public UnitOfWork(IDbConnection connection)
{
_connection = connection;
AccountDao = new AccountDao(connection);
BusCoordinateDao = new BusCoordinateDao(connection);
BusDao = new BusDao(connection);
BusDriverDao = new BusDriverDao(connection);
CityDao = new CityDao(connection);
CountryDao = new CountryDao(connection);
DistanceDao = new DistanceDao(connection);
DistrictDao = new DistrictDao(connection);
DriverDao = new DriverDao(connection);
DriverContactDao = new DriverContactDao(connection);
LocationDao = new LocationDao(connection);
LookupsDao = new LookupsDao(connection);
LookupValuesDao = new LookupValuesDao(connection);
RepairSpecialistDao = new RepairSpecialistDao(connection);
RoleDao = new RoleDao(connection);
RouteDao = new RouteDao(connection);
RouteLocationDao = new RouteLocationDao(connection);
TripDao = new TripDao(connection);
TripBusDao = new TripBusDao(connection);
TripBusDriverDao = new TripBusDriverDao(connection);
UserDao = new UserDao(connection);
VehicleDao = new VehicleDao(connection);
ScheduleDao = new ScheduleDao(connection);
ScheduleLocationDao = new ScheduleLocationDao(connection);
StoredProcedureDao = new StoredProcedureDao(connection);
}
public List <Trip> GetTripsByUser(User user)
{
List <Trip> tripList = new List <Trip>();
User loggedUser = null;
bool isFriend = false;
if (HttpContext.Current.Request.IsAuthenticated)
{
loggedUser = UserDao.GetByName(
HttpContext.Current.User.Identity.Name);
}
if (loggedUser != null)
{
foreach (User friend in user.Friends)
{
if (friend.Equals(loggedUser))
{
isFriend = true;
break;
}
}
if (isFriend)
{
tripList = TripDao.FindTripsByUser(user);
}
}
else
{
throw new UserNotLoggedInException();
}
return(tripList);
}
public async Task <IActionResult> DeleteTrip([FromRoute] int id)
{
try
{
var dao = new TripDao(_db);
if (await dao.deleteTripAsync(id) == -1)
{
return(NotFound());
}
}
catch (Exception e)
{
return(BadRequest(new { message = ErrorUtils.dbErrorMessage($"Can't delete Trip", e) }));
}
return(Ok());
}
public async Task <IActionResult> PostTrip([FromBody] TripModel tripModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var dao = new TripDao(_db);
//tripModel.transTypeId = 100;
tripModel = await dao.addTripAsync(tripModel);
}
catch (Exception e)
{
return(BadRequest(new { message = ErrorUtils.dbErrorMessage($"Can't insert (add) Trip", e) }));
}
return(CreatedAtAction("GetTrip", new { id = tripModel.tripId }, tripModel));
}
