/// <summary> send the rout to the driver on mail
/// </summary>
public static void sendRouteToDriver(List <RegistrationDateRange> listReg, TravelDriverRange travel)
{
TravelingPassenger traveling;
List <TravelingPassenger> travelings = new List <TravelingPassenger>();
Registeration registeration;
Route route = new Route();
TravelingDriver travelingDriver = TravelingDriverDal.GetTraveling(travel.Id);
Driver driver = DriverDal.GetDriverById(travelingDriver.DriverId);
string source, destination, routeDetails;
source = travelingDriver.Source;
destination = travelingDriver.Destination;
foreach (var t in listReg)
{
registeration = RegisterationDal.GetRegisterationById(t.Id);
traveling = TravelingPassengerDal.GetTraveling(registeration.TravelingIdPassenger);
if (traveling != null)
{
travelings.Add(traveling);
}
}
route = GetRoute(travelings, source, destination);
routeDetails = GetRouteDetails(route);
try
{
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress("*****@*****.**");
mail.To.Add(driver.User.Mail);
mail.Subject = "מסלול נסיעתך ופרטי הנוסעים";
string urlDetails = "http://*****:*****@gmail.com", "group1111@");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
}
catch (Exception e)
{
throw;
}
}
public static TravelDriverRange GetTravelRange(TravelDriverRangeDTO dtoTravelDateRange)
{
TravelDriverRange travelDateRange = new TravelDriverRange()
{
Id = dtoTravelDateRange.Id,
Date = dtoTravelDateRange.Date,
NumSeatsAvailable = dtoTravelDateRange.NumSeatsAvailable,
IsActive = dtoTravelDateRange.IsActive
};
return(travelDateRange);
}
public static List <RegistrationDateRange> GetRegisterationNow(TravelDriverRange travelDriver)
{
try
{
using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities())
{
var q = ctx.RegistrationDateRanges.ToList().Where(w => w.Registeration.TravelingIdDriver == travelDriver.Id && w.DateInRange.Date == travelDriver.Date.Date).ToList();
if (q == null)
{
return(null);
}
return(q);
}
}
catch { throw; }
}
public static TravelDriverRangeDTO GetTravelRangeDTO(TravelDriverRange travelDateRange)
{
if (travelDateRange == null)
{
return(null);
}
TravelDriverRangeDTO travelDateRangeDTO = new TravelDriverRangeDTO()
{
Id = travelDateRange.Id,
Date = travelDateRange.Date,
NumSeatsAvailable = travelDateRange.NumSeatsAvailable,
IsActive = travelDateRange.IsActive
};
return(travelDateRangeDTO);
}
public static WayPoint GetListWayPointsByTravelD(int id)
{
WayPoint wayPoint = new WayPoint();
TravelDriverRange travel = TravelDriverRangeDAL.GetTravelRangeByIdentity(id);
List <RegistrationDateRange> listReg = RegistrationDateRangeDal.GetRegisterationNow(travel);
if (listReg == null)
{
return(null);
}
TravelingPassenger traveling;
List <TravelingPassenger> travelings = new List <TravelingPassenger>();
Registeration registeration;
Route route = new Route();
TravelingDriver travelingDriver = TravelingDriverDal.GetTraveling(travel.Id);
// Driver driver = DriverDal.GetDriverById(travelingDriver.DriverId);
wayPoint.LatSource = travelingDriver.LatS;
wayPoint.LatDestination = travelingDriver.LatD;
wayPoint.LngSource = travelingDriver.LngS;
wayPoint.LngDestination = travelingDriver.LngD;
wayPoint.ListPoint = new Point [listReg.Count * 2];
int i = 0;
foreach (var t in listReg)
{
registeration = RegisterationDal.GetRegisterationById(t.Id);
traveling = TravelingPassengerDal.GetTraveling(registeration.TravelingIdPassenger);
if (traveling != null)
{
wayPoint.ListPoint[i] = new Point()
{
Lat = traveling.LatS, Lng = traveling.LngS
};
i++;
wayPoint.ListPoint[i] = new Point()
{
Lat = traveling.LatD, Lng = traveling.LngD
};
i++;
}
}
return(wayPoint);
}
public static bool UpdateTravelRange(TravelDriverRange travelDateRange, int id)
{
try
{
using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities())
{
var q = ctx.TravelDriverRanges.FirstOrDefault(w => w.Id == id);
if (q == null)
{
return(false);
}
q.Id = travelDateRange.Id;
q.Date = travelDateRange.Date;
q.NumSeatsAvailable = travelDateRange.NumSeatsAvailable;
ctx.SaveChanges();
return(true);
}
}
catch { throw; }
}
public static void AddTravelRange(TravelingDriver travelingDriver)
{
int range;
TimeSpan timeSpan;
DateTime date = travelingDriver.FromDate;
try
{
using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities())
{
Driver driver = ctx.Drivers.FirstOrDefault(w => w.Id == travelingDriver.DriverId);
travelingDriver.Driver = driver;
timeSpan = travelingDriver.ToDate.Date - travelingDriver.FromDate.Date;
range = timeSpan.Days;
for (int i = 0; i < range; i++)
{
TravelDriverRange travelDateRange = new TravelDriverRange()
{
Id = travelingDriver.TravelingIdDriver,
NumSeatsAvailable = travelingDriver.Driver.NumberOfSeats,
Date = date,
IsActive = true
};
if (travelingDriver.Weekday.Contains(((int)date.DayOfWeek + 1).ToString()))
{
travelDateRange.TravelingDriver = ctx.TravelingDrivers.FirstOrDefault(w => w.TravelingIdDriver == travelDateRange.Id);
ctx.TravelDriverRanges.Add(travelDateRange);
}
ctx.SaveChanges();
date = date.Date.AddDays(1);
}
}
}
catch { throw; }
}