private static LinkedList <Trip> readDb(DateTime departureTime, int type)
{
LinkedList <Trip> list = new LinkedList <Trip>();
CarpoolContext db = new CarpoolContext();
var trips = from trip in db.Trips
where
DbFunctions.DiffHours(trip.TravelDateTime, departureTime) < 6 &&
departureTime > trip.TravelDateTime &&
trip.TripInformation.Capacity >= 1 &&
((int)trip.Type == (type == 0?1:0))
select trip;
foreach (var a in trips)
{
Location from = new Location(a.From.StreetAddress, a.From.City, a.From.State, a.From.ZipCode);
Location to = new Location(a.To.StreetAddress, a.To.City, a.To.State, a.To.ZipCode);
DateTime time = a.TravelDateTime;
Trip trip = new Trip(from, to, time, a.Type, a.TripInformation);
list.AddFirst(trip);
}
return(list);
// string[] lines = System.IO.File.ReadAllLines(@"C:\Users\sgpy\Documents\GitHub\carpool-master\CarPoolDemo\db.txt");
// foreach (string line in lines)
// {
// string[] item = line.Split('\t');
// Trip trip = new Trip(item[0].Trim(), item[1].Trim(), item[2].Trim(), item[3].Trim(), item[4].Trim(), item[5].Trim());
// list.AddFirst(trip);
// }
// return list;
}
public ActionResult Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
User user = new User();
user.FirstName = model.FirstName;
user.LastName = model.LastName;
user.Email = model.Email;
user.Password = model.Password;
CarpoolContext context = new CarpoolContext();
context.Users.Add(user);
try {
context.SaveChanges();
}catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) {
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public FahrgemeinschaftController(CarpoolContext cpctx)
{
_cpctx = cpctx;
_users = cpctx.Users;
_fahrgemeinschafts = cpctx.Fahrgemeinschafts;
_fahrgemeinschaftMitglieds = cpctx.FahrgemeinschaftMitglieds;
_fahrts = _cpctx.Fahrts;
}
public TravelPlanService(CarpoolContext dbContext, ICarService carService, IEmployeeService employeeService,
ITimeProvider timeProvider)
{
_dbContext = dbContext;
_carService = carService;
_employeeService = employeeService;
_timeProvider = timeProvider;
}
protected TestWithInMemoryDatabase()
{
_connection = new SqliteConnection(InMemoryConnectionString);
_connection.Open();
var options = new DbContextOptionsBuilder <CarpoolContext>()
.UseSqlite(_connection)
.Options;
DbContext = new CarpoolContext(options);
DbContext.Database.EnsureCreated();
}
public Repository(CarpoolContext context)
{
Context = context ?? throw new ArgumentNullException(nameof(context));
}
public void AddTrip(NewPostingViewModel viewModel, User user)
{
using (Context) {
Location to = new Location();
to.StreetAddress = viewModel.StreetAddressDestination;
to.City = viewModel.CityDestination;
to.State = viewModel.StateDestination;
to.ZipCode = viewModel.ZipDestination;
Location from = new Location();
from.StreetAddress = viewModel.StreetAddressOrigin;
from.City = viewModel.CityOrigin;
from.State = viewModel.StateOrigin;
from.ZipCode = viewModel.ZipOrigin;
Trip trip = new Trip();
trip.To = to;
trip.From = from;
trip.TravelDateTime = viewModel.DateTime;
trip.Type = viewModel.TripType;
TripInformation tripInformation = new TripInformation();
tripInformation.Capacity = viewModel.TripType == TripType.LookingForPassengers ? 3 : 1;
trip.TripInformation = tripInformation;
using (CarpoolContext context = new CarpoolContext()) {
user = context.Users.Single(x => x.UserId == user.UserId);
trip.TripInformation.Owner = user;
context.Trips.Add(trip);
AddressBook addressBook = context.AddressBooks.SingleOrDefault(x => x.UserId == user.UserId);
bool isNewAddressBook = addressBook == null;
if (viewModel.AddOriginToAddressBook)
{
if (addressBook == null)
{
addressBook = new AddressBook()
{
User = user, UserId = user.UserId, Locations = new List <Location>()
};
}
addressBook.Locations.Add(from);
}
if (viewModel.AddDestinationToAddressBook)
{
if (addressBook == null)
{
addressBook = new AddressBook()
{
User = user, UserId = user.UserId, Locations = new List <Location>()
};
}
addressBook.Locations.Add(to);
}
if (viewModel.AddOriginToAddressBook || viewModel.AddDestinationToAddressBook)
{
if (isNewAddressBook)
{
context.AddressBooks.Add(addressBook);
}
else
{
context.Set <AddressBook>().Attach(addressBook);
context.Entry(addressBook).State = EntityState.Modified;
}
}
context.SaveChanges();
}
}
}
public TripInformationRepository(CarpoolContext contextIn = null) : base(contextIn)
{
}
public RideService(CarpoolContext dbContext)
: base(dbContext)
{
this.dbContext = dbContext;
}
public EmployeeService(CarpoolContext dbContext)
{
_dbContext = dbContext;
}
public GradService(CarpoolContext context, IMapper mapper) : base(context, mapper)
{
}
public LocationRepository(CarpoolContext contextIn = null) : base(contextIn)
{
}
public BaseCRUDService(CarpoolContext context, IMapper mapper) : base(context, mapper)
{
}
public UserController(CarpoolContext cpctx)
{
this._cpctx = cpctx;
this._users = cpctx.Users;
}
public UserController(UserManager <ApplicationUser> userManager, CarpoolContext context, IUserService iUserService)
{
this.IUserService = iUserService;
this.context = context;
this.userManager = userManager;
}
public EmployeeTravelPlanMappingRepository(CarpoolContext context) : base(context)
{
}
public ObavijestService(CarpoolContext context, IMapper mapper, IHttpContextAccessor httpContext) : base(context, mapper)
{
_httpContext = httpContext;
}
public TravelPlanRepository(CarpoolContext context) : base(context)
{
}
public BaseService(CarpoolContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public LocationService(CarpoolContext dbContext)
{
_dbContext = dbContext;
}
public KorisnikService(CarpoolContext context, IMapper mapper, IHttpContextAccessor httpContext)
{
_context = context;
_mapper = mapper;
_httpContext = httpContext;
}
public EmployeeRepository(CarpoolContext context) : base(context)
{
}
public RiderController(CarpoolContext context, IRiderService iRiderService)
{
this.context = context;
this.IRiderService = iRiderService;
}
public DriverService(CarpoolContext carpoolDb)
{
HelperService = new HelperService();
this.carpoolDb = carpoolDb;
}
public Repository(CarpoolContext contextIn = null)
{
this.context = contextIn ?? new CarpoolContext();
this.dbSet = context.Set <T>();
}
public UnitOfWork(CarpoolContext context)
{
this.context = context;
}
public Service(CarpoolContext dbContext) => this.dbContext = dbContext;
public UsputniGradoviService(CarpoolContext context, IMapper mapper) : base(context, mapper)
{
}
public AutomobilService(CarpoolContext context, IMapper mapper, IHttpContextAccessor httpContext) : base(context, mapper)
{
_httpContext = httpContext;
}
public CarService(CarpoolContext dbContext)
{
_dbContext = dbContext;
}
