///<summary> send reminder on mail to the passengers
///</summary>
public static void sendMailReminderToP(Object state)
{
List <RegistrationDateRangeDTO> registrationNow = RegistrationDateRangeConverters.GetListDateRangeDTO(RegistrationDateRangeDal.GetTravelingsNow());
foreach (var r in registrationNow)
{
sendMailReminder(RegisterationConverters.GetRegisterationDTO(RegisterationDal.GetRegisterationById(r.Id)));
}
}
/// <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 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);
}
/// <summary> delete registeration of driver from the db
/// </summary>
public static void DeleteRegisterationDriver(TravelingDriverDTO traveling)
{
///delete from TravelingDriver
TravelingDriverDTO travelingDriver = TravelingDriverConverters.GetTravelingDTO(TravelingDriverDal.GetTraveling(traveling.TravelingIdDriver));
travelingDriver.FromDate = traveling.FromDate;
travelingDriver.ToDate = traveling.FromDate;
TravelingDriverBL.DeleteTraveling(travelingDriver);
///delete from Registeration
List <RegisterationDTO> registerationInRange = RegisterationConverters.GetListRegisterationDTO(RegisterationDal.GetRegByIdDInRange(traveling.TravelingIdDriver, traveling.FromDate, traveling.ToDate));
foreach (var reg in registerationInRange)
{
try
{
Mail.sendMailCancelToP(reg, traveling.FromDate, traveling.ToDate);
}
catch
{
throw;
}
try
{
PaymentBL.PayToPassengerCancel(reg, traveling.FromDate, traveling.ToDate);
}
catch
{
throw;
}
}
List <RegisterationDTO> registerations = GetRegisterationByDriverId(traveling.TravelingIdDriver);
DeleteRangeRegDriver(registerations, traveling.FromDate.Date, traveling.ToDate);
}
/// <summary> delete range registeration of passenger from the db
/// </summary>
public static int DeleteRangeRegPassenger(int id, DateTime fromDate, DateTime toDate)
{
///delete from TravelingPassenger
RegisterationDTO registeration = RegisterationConverters.GetRegisterationDTO(RegisterationDal.GetRegisterationById(id));
TravelingPassengerDTO travelingPassenger = TravelingPassengerConverters.GetTravelingDTO(TravelingPassengerDal.GetTraveling(registeration.travelingIdPassenger));
travelingPassenger.FromDate = fromDate;
travelingPassenger.ToDate = toDate;
TravelingPassengerBL.DeleteTraveling(travelingPassenger);
bool isPay = BL.RegistrationDateRangeBL.isTravelToday(id, fromDate, toDate);
///delete from Registeration
int datesDelete = BL.RegistrationDateRangeBL.DeleteRangeP(id, fromDate, toDate);
if (datesDelete > 0 && isPay)
{
PaymentBL.PayToDriverCancel(id, fromDate, toDate);
}
return(datesDelete);
}
/// <summary> add a new registeration in the db
/// </summary>
public static void Add(RegisterationDTO registeration)
{
RegisterationDal.AddRegisteration(RegisterationConverters.GetRegisteration(registeration));
}
private static List <RegisterationDTO> GetAllRegOfTravel(int travelingIdDriver, DateTime dateInRange)
{
List <RegisterationDTO> allReg = RegisterationConverters.GetListRegisterationDTO(RegisterationDal.GetRegByIdInDate(travelingIdDriver, dateInRange));
return(allReg);
}
/// <summary> pay to passenger about the traveling
/// </summary>
public static void PayToDriver(object state)
{
List <Registeration> registerations = RegisterationDal.GetTravelingsToPay();
PaymentDal.AddPayments(registerations);
}
