private void startSimJob()
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
Detail detail = new Detail()
{
CarId = 1,
Speed = 50,
Rpm = 1500,
EngineLoad = 50,
Voltage = 14,
Lat = 54.387059,
Lon = 18.591215,
CreateDate = DateTime.Now
};
while (true)
{
if (simulatorCancellationToken.IsCancellationRequested)
{
return;
}
detail.Lat += 0.0002;
detail.Lon -= 0.0002;
detail.CreateDate = DateTime.Now;
db.Details.Add(detail);
db.SaveChanges();
Thread.Sleep(10 * 1000);
}
}
public ActionResult SpecificTrip(string id)
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
Session["currentMethod"] = "SpecificTrip";
Session["currentController"] = "FindTrip";
User u = (User)Session["User"];
int i = Convert.ToInt32(id);
var result = from m in db.Trip
where m.TripID == i
select m;
Trip t = result.First();
t.numberOfSeats = t.numberOfSeats - 1;
List<string> passengerList = Listconversion.ConvertToList(t.Passengers);
passengerList.Add(u.UserID.ToString());
string passengers = Listconversion.Converttostring(passengerList);
t.Passengers = passengers;
u.Trip.Add(t);
db.Trip.AddOrUpdate(t);
db.User.AddOrUpdate(u);
db.SaveChanges();
Session["driverID"] = t.UserID;
return RedirectToAction("SpecificTrip", "FindTrip", t);
}
public ActionResult PlanTrip(Trip trip)
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
Session["currentMethod"] = "PlanTrip";
Session["currentController"] = "PlanTrip";
Trip result = trip;
User u = (User)Session["User"];
result.UserID = u.UserID;
u.Trip.Add(result);
if (ModelState.IsValid)
{
db.Trip.Add(result);
db.User.AddOrUpdate(u);
db.SaveChanges();
return(RedirectToAction("SpecificTrip", result));
}
else
{
return(View("PlanTrip"));
}
}
public ActionResult CreateAccount(User user)
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
User local = user;
local.isDriver = true;
db.User.Add(user);
db.SaveChanges();
Session["User"] = local;
return(RedirectToAction("AccountDetails"));
}
public string GetDriverNameOfTrip(int TripId)
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
var result = from m in db.Trip
where m.TripID == TripId
select m;
Trip t = result.First();
var r = from m in db.User
where m.UserID == t.UserID
select m;
string name = r.First().firstname + " " + r.First().lastName;
return(name);
}
// GET: Account
//TODO:make POST
public ActionResult EditAccountInfo(string newFirstname, string newLastname, string newPassword, string repeatPassword, string newEmail)
{
if (string.IsNullOrWhiteSpace(newFirstname) && string.IsNullOrWhiteSpace(newLastname) && string.IsNullOrWhiteSpace(newPassword) && string.IsNullOrWhiteSpace(newEmail))
{
return(RedirectToAction("AccountDetails", "Account"));
}
try
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
if (!string.IsNullOrWhiteSpace(newFirstname))
{
((User)Session["user"]).firstname = newFirstname;
db.User.AddOrUpdate((User)Session["user"]);
db.SaveChanges();
return(RedirectToAction("AccountDetails", "Account"));
}
if (!string.IsNullOrWhiteSpace(newLastname))
{
((User)Session["user"]).firstname = newLastname;
db.User.AddOrUpdate((User)Session["user"]);
db.SaveChanges();
return(RedirectToAction("AccountDetails", "Account"));
}
if (!string.IsNullOrWhiteSpace(newPassword) && newPassword.Equals(repeatPassword))
{
((User)Session["user"]).password = newPassword;
db.User.AddOrUpdate((User)Session["user"]);
db.SaveChanges();
return(RedirectToAction("AccountDetails", "Account"));
}
if (!string.IsNullOrWhiteSpace(newEmail))
{
((User)Session["user"]).email = newEmail;
db.User.AddOrUpdate((User)Session["user"]);
db.SaveChanges();
return(RedirectToAction("AccountDetails", "Account"));
}
return(View("Error"));
}
catch (Exception e)
{
Console.WriteLine(e);
return(View("Error"));
}
}
public ActionResult SpecificTrip(int tripID)
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
var result = from m in db.Trip
where m.TripID == tripID
select m;
Trip t = result.First();
Session["currentMethod"] = "SpecificTrip";
Session["currentController"] = "FindTrip";
Session["driverID"] = t.UserID;
//Instance of soap file
//Soap soap = new Soap();
//string drivername = soap.GetDriverNameOfTrip(tripID);
return View(t);
}
// GET: LoginScript
public ActionResult LoginScript(string usernameLogIn, string passwordLogIn)
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
User use1 = new User();
var user = from m in db.User
where m.userName == usernameLogIn
select m;
use1 = user.First();
if (use1.password == passwordLogIn)
{
Session["User"] = use1;
Session["LoggedIn"] = true;
return(RedirectToAction("Index", "Home"));
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult EditAccount()
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
List <Trip> DriverTrips = new List <Trip>();
List <Trip> PassengerTrips = new List <Trip>();
User usr = ((User)Session["user"]);
var triplistDriver = from m in db.Trip
where m.UserID == usr.UserID
select m;
var triplistPass = from m in db.Trip
where m.Passengers.Contains(usr.UserID.ToString())
select m;
DriverTrips = triplistDriver.ToList();
PassengerTrips = triplistPass.ToList();
ViewBag.DriverTrips = DriverTrips;
ViewBag.PassengerTrips = PassengerTrips;
return(View());
}
public ActionResult LoginAccount(string Username, string Password)
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
User use1 = new User();
var user = from m in db.User
where m.userName == Username
select m;
use1 = user.First();
if (use1.password == Password)
{
Session["User"] = use1;
Session["LoggedIn"] = true;
return(RedirectToAction("Index", "Home"));
}
return(Login());
}
public ActionResult cancelTrip(string id)
{
CarDatabaseEntities1 db = new CarDatabaseEntities1();
Session["currentMethod"] = "CancelTrip";
Session["currentController"] = "FindTrip";
User u = (User)Session["User"];
int i = Convert.ToInt32(id);
var result = from m in db.Trip
where m.TripID == i
select m;
Trip t = result.First();
u.Trip.Remove(t);
db.Trip.Remove(t);
db.SaveChanges();
return RedirectToAction("Index", "Home");
}
public ActionResult TripList(string saddress, string szip, string scity, string daddress, string dzip, string dcity, DateTime time)
{
List<Trip> tlist = new List<Trip>();
Session["currentMethod"] = "TripList";
Session["currentController"] = "FindTrip";
CarDatabaseEntities1 db = new CarDatabaseEntities1();
if (!saddress.IsNullOrWhiteSpace())
{
var result = from m in db.Trip
where m.startingAddress == saddress && m.numberOfSeats > 0
select m;
foreach (var trip in result)
{
if (!tlist.Contains(trip))
{
tlist.Add(trip);
}
}
}
if (!szip.IsNullOrWhiteSpace())
{
var result = from m in db.Trip
where m.startingZip == szip && m.numberOfSeats > 0
select m;
foreach (var trip in result)
{
if (!tlist.Contains(trip))
{
tlist.Add(trip);
}
}
}
if (!scity.IsNullOrWhiteSpace())
{
var result = from m in db.Trip
where m.startingCity == scity && m.numberOfSeats > 0
select m;
foreach (var trip in result)
{
if (!tlist.Contains(trip))
{
tlist.Add(trip);
}
}
}
if (!daddress.IsNullOrWhiteSpace())
{
var result = from m in db.Trip
where m.destinationAddress == daddress && m.numberOfSeats > 0
select m;
foreach (var trip in result)
{
if (!tlist.Contains(trip))
{
tlist.Add(trip);
}
}
}
if (!dzip.IsNullOrWhiteSpace())
{
var result = from m in db.Trip
where m.destinationZip == dzip && m.numberOfSeats > 0
select m;
foreach (var trip in result)
{
if (!tlist.Contains(trip))
{
tlist.Add(trip);
}
}
}
if (!dcity.IsNullOrWhiteSpace())
{
var result = from m in db.Trip
where m.destinationCity == dcity && m.numberOfSeats > 0
select m;
foreach (var trip in result)
{
if (!tlist.Contains(trip))
{
tlist.Add(trip);
}
}
}
var date = from m in db.Trip
where m.time == time && m.numberOfSeats > 0
select m;
foreach (var trip in date)
{
if (!tlist.Contains(trip))
{
tlist.Add(trip);
}
}
return View(tlist);
}
