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 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); } }