internal static List <IndexViewModel> GetSpecificDrivesFromDB(TrinityContext context, string searchStart, string searchDestination)
{
if (searchStart != null && searchDestination != null)
{
var dataDrives = context.Drives
.Where(d => d.Date >= DateTime.Now && d.Passengers > 0 && searchStart == d.StartingPoint && searchDestination == d.Destination).ToList();
if (dataDrives != null)
{
List <IndexViewModel> drivesList = new List <IndexViewModel>();
foreach (var d in dataDrives)
{
drivesList.Add(new IndexViewModel()
{
ID = d.ID, StartingPoint = d.StartingPoint, Destination = d.Destination, Date = d.Date, Driver = d.Driver, Passengers = d.Passengers
});
}
return(drivesList);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
internal static AddPassengerViewModel AddConnectionInPTD(TrinityContext context, AddPassengerViewModel drive, string ssn)
{
var person = context.Persons
.Where(p => p.SSN == ssn)
.FirstOrDefault();
context.PTD.Add(new PTD()
{
PID = person.ID, DID = drive.ID
});
context.SaveChanges();
var update = context.Drives.
Where(s => s.ID == drive.ID).First();
update.Passengers--;
context.SaveChanges();
AddPassengerViewModel updatedDrive = new AddPassengerViewModel()
{
ID = update.ID, Date = update.Date, StartingPoint = update.StartingPoint, Destination = update.Destination, Driver = update.Driver, Passengers = update.Passengers
};
return(updatedDrive);
}
internal static void AddPerson(TrinityContext context, JoinViewModel person)
{
context.Persons.Add(new Persons()
{
FirstName = person.FirstName, LastName = person.LastName, SSN = person.SSN
});
context.SaveChanges();
}
internal static AddPassengerViewModel FindDrive(TrinityContext context, int id)
{
var d = context.Drives.Where(x => x.ID == id).FirstOrDefault();
AddPassengerViewModel drive = new AddPassengerViewModel()
{
ID = d.ID, Date = d.Date, StartingPoint = d.StartingPoint, Destination = d.Destination, Driver = d.Driver, Passengers = d.Passengers
};
return(drive);
}
internal static AddPassengerViewModel ReturnDrive(TrinityContext context, AddPassengerViewModel drive)
{
var ride = context.Drives.Where(r => r.ID == drive.ID).FirstOrDefault();
AddPassengerViewModel currentDrive = new AddPassengerViewModel()
{
ID = ride.ID, Date = ride.Date, StartingPoint = ride.StartingPoint, Destination = ride.Destination, Driver = ride.Driver, Passengers = ride.Passengers
};
return(currentDrive);
}
internal static bool SSNInDB(TrinityContext context, string ssn)
{
var passengerSSN = context.Persons.Where(p => p.SSN == ssn).FirstOrDefault();
if (passengerSSN != null)
{
return(true);
}
else
{
return(false);
}
}
internal static int AddDrive(TrinityContext context, AddDriveViewModel drive)
{
Drives newDrive = new Drives()
{
StartingPoint = drive.StartingPoint, Destination = drive.Destination, Date = drive.Date, Driver = true, Passengers = drive.Passengers
};
context.Drives.Add(newDrive);
context.SaveChanges();
int did = newDrive.ID;
return(did);
}
internal static List <ShowPassengersViewModel> ListPassengers(TrinityContext context, int id)
{
List <ShowPassengersViewModel> passenger = new List <ShowPassengersViewModel>();
var personID = context.PTD.Where(x => x.DID == id).Select(x => x.PID);
foreach (var i in personID)
{
var person = context.Persons.Where(x => x.ID == i).FirstOrDefault();
passenger.Add(new ShowPassengersViewModel()
{
ID = person.ID, FirstName = person.FirstName, LastName = person.LastName, SSN = person.SSN
});
}
return(passenger);
}
internal static bool passengerAlreadyInRide(TrinityContext context, string ssn, AddPassengerViewModel drive)
{
var passenger = context.Persons.Where(p => p.SSN == ssn).FirstOrDefault();
int pid = passenger.ID;
var passengerNotInRide = context.PTD.Where(r => r.PID == pid && r.DID == drive.ID).FirstOrDefault();
if (passengerNotInRide == null)
{
return(true);
}
else
{
return(false);
}
}
internal static bool IsNotAMember(TrinityContext context, JoinViewModel person)
{
var personSSN = context.Persons
.Where(p => p.SSN == person.SSN)
.FirstOrDefault();
if (personSSN == null)
{
AddPerson(context, person);
return(true);
}
else
{
return(false);
}
}
internal static List <MyDrivesViewModel> GetPersonsDrives(TrinityContext context, string ssn)
{
var pid = context.Persons
.Where(p => p.SSN == ssn)
.Select(p => p.ID)
.FirstOrDefault();
if (pid != 0)
{
var did = context.PTD
.Where(i => i.PID == pid)
.Select(i => i.DID)
.ToList();
if (did != null)
{
var myDrives = context.Drives
.Where(d => did.Contains(d.ID))
.ToList();
var person = context.Persons
.Where(p => p.SSN == ssn)
.FirstOrDefault();
List <MyDrivesViewModel> drives = new List <MyDrivesViewModel>();
foreach (var d in myDrives)
{
drives.Add(new MyDrivesViewModel()
{
StartingPoint = d.StartingPoint, Destination = d.Destination, Date = d.Date, Passengers = d.Passengers, ID = d.ID, SSN = ssn, FirstName = person.FirstName, LastName = person.LastName
});
}
return(drives);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
internal static List <IndexViewModel> GetDrivesListFromDataBase(TrinityContext context)
{
var dataDrives = context.Drives.Where(d => d.Date >= DateTime.Now && d.Passengers > 0).ToList();
if (dataDrives != null)
{
List <IndexViewModel> drivesList = new List <IndexViewModel>();
foreach (var d in dataDrives)
{
drivesList.Add(new IndexViewModel()
{
ID = d.ID, StartingPoint = d.StartingPoint, Destination = d.Destination, Date = d.Date, Driver = d.Driver, Passengers = d.Passengers
});
}
return(drivesList);
}
else
{
return(null);
}
}
internal static void RemoveTraveller(MyDrivesViewModel drive, TrinityContext context)
{
var person = context.Persons
.Where(p => p.SSN == drive.SSN)
.First();
var travellers = context.PTD
.Where(t => t.DID == drive.ID)
.ToList();
if (travellers[0].PID == person.ID)
{
foreach (var item in travellers)
{
context.Remove(item);
context.SaveChanges();
}
var _drive = context.Drives
.Where(d => d.ID == drive.ID)
.FirstOrDefault();
context.Remove(_drive);
context.SaveChanges();
}
else
{
var updatePassengers = context.Drives
.Where(p => p.ID == drive.ID)
.FirstOrDefault();
updatePassengers.Passengers++;
context.SaveChanges();
var traveller = travellers
.Where(p => p.PID == person.ID)
.FirstOrDefault();
context.Remove(traveller);
context.SaveChanges();
}
}
internal static bool SSNInDB(TrinityContext context, AddDriveViewModel drive)
{
var driveSSN = context.Persons
.Where(p => p.SSN == drive.SSN)
.FirstOrDefault();
if (driveSSN != null)
{
int did = AddDrive(context, drive);
var person = context.Persons.Where(p => p.SSN == drive.SSN).FirstOrDefault();
context.PTD.Add(new PTD()
{
PID = person.ID, DID = did
});
context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public Repository(TrinityContext db)
{
Db = db;
Set = Db.Set <T>();
}
public MusicRepository(TrinityContext db) : base(db)
{
}
public ExpertsController(Repository <Employee> employeeRepository, Repository <Meeting> meetingRepository, TrinityContext context)
{
_employeeRepository = employeeRepository;
_meetingRepositry = meetingRepository;
_context = context;
}
public AlbumRepository(TrinityContext db) : base(db)
{
}
public BandRepository(TrinityContext db) : base(db)
{
}
public DrivesController(TrinityContext context)
{
this.context = context;
}
