/// <summary> /// Finds Truck driver for order /// </summary> /// <param name="currentOrder"> /// Takes in TruckInOrder entity, which will be added. /// </param> /// <returns> /// Returns Truck Id /// </returns> public int IsFree(TruckInOrder currentOrder) { using (var db = new TrackPlaceDbContext()) { //ˇget driver who hasent make a single ride yet var truck = from b in db.Trucks where !db.TruckInOrders.Any(id => id.TruckId == b.TruckId) where currentOrder.Order.ProductCubage <= b.TrailerCubage where b.WeigthCapacity >= currentOrder.Order.ProductWeight && currentOrder.TypeOfTrucks == b.TypeOfTrucks select b; if (truck.Any()) { return(truck.First().TruckId); } // search form all drivers var datetime = DateTime.Now.AddHours(3); var truckId = from b in db.Trucks where currentOrder.Order.ProductCubage <= b.TrailerCubage && b.WeigthCapacity >= currentOrder.Order.ProductWeight && currentOrder.TypeOfTrucks == b.TypeOfTrucks select b.TruckId; if (truckId.Any()) { return(truckId.First()); } return(0); } }
/// <summary> /// Finds user In database /// </summary> /// <param name="password"></param> /// <param name="username"></param> /// <returns></returns> public int find(string password, string username) { using (TrackPlaceDbContext db = new TrackPlaceDbContext()) { var user = from p in db.UserAcconts where p.Password.PasswordName == password && p.Password.PasswordId == p.UserAccontId where p.Person.EMailAddress == username && p.Person.PersonId == p.UserAccontId select p.UserAccontId; return(user.First()); } }
/// <summary> /// Checks if user exsists already in database /// </summary> /// <param name="user"></param> /// <returns></returns> public bool IfExsists(UserAccont user) { using (TrackPlaceDbContext db = new TrackPlaceDbContext()) { var accont = from p in db.UserAcconts where user.Person.FirstName == p.Person.FirstName where user.Person.LastName == p.Person.LastName where user.Person.EMailAddress == p.Person.EMailAddress select p; if (accont.Any()) { return(true); } return(false); } }