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