public TestService(ITestRepository testRepository, IUnitOfWork unitOfWork, IMapper mapper, IStoreProcedureRepository storeProcedureRepository)
{
_testRepository = testRepository;
_unitOfWork = unitOfWork;
_mapper = mapper;
_storeProcedureRepository = storeProcedureRepository;
}
public UserService(IUserRepository userRepository, IUnitOfWork unitOfWork, IMapper mapper,
IStoreProcedureRepository storeProcedure)
{
_userRepository = userRepository;
_unitOfWork = unitOfWork;
_mapper = mapper;
_storeProcedure = storeProcedure;
}
public CustomerService(ICustomerRepository customerRepository, IUnitOfWork unitOfWork, IMapper mapper,
IStoreProcedureRepository storeProcedure)
{
_customerRepository = customerRepository;
_unitOfWork = unitOfWork;
_mapper = mapper;
_storeProcedure = storeProcedure;
}
/// <summary>
///
/// </summary>
/// <param name="iunitOfWork"></param>
/// <param name="log"></param>
/// <param name="storeProcedure"></param>
/// <param name="errorManager"></param>
public RecibosService(IUnitOfWork iunitOfWork,
ILog log,
IStoreProcedureRepository storeProcedure,
IErrorManager errorManager)
{
_iunitOfWork = iunitOfWork;
_log = log;
_storeProcedure = storeProcedure;
_errorManager = errorManager;
}
/// <summary>
///
/// </summary>
/// <param name="iunitOfWork"></param>
/// <param name="log"></param>
/// <param name="storeProcedure"></param>
/// <param name="errorManager"></param>
public CajaService(IUnitOfWork iunitOfWork,
ILog log,
IStoreProcedureRepository storeProcedure,
IErrorManager errorManager)
{
_iunitOfWork = iunitOfWork;
_log = log;
_storeProcedure = storeProcedure;
_errorManager = errorManager;
_mapper = new MapperCaja();
}
public DocumentService(ISourceCodeRepository documentRepository, IUnitOfWork unitOfWork, IMapper mapper,
IResultRepository resultRepository,
IMethodRepository methodRepository,
IStoreProcedureRepository storeProcedure,
IConfiguration configuration)
{
_sourceCodeRepository = documentRepository;
_unitOfWork = unitOfWork;
_mapper = mapper;
_storeProcedure = storeProcedure;
_resultRepository = resultRepository;
_methodRepository = methodRepository;
_configuration = configuration;
}
/// <summary>
///
/// </summary>
/// <param name="unitOfWork"></param>
/// <param name="configuration"></param>
/// <param name="errorManager"></param>
/// <param name="log"></param>
/// <param name="roleManager"></param>
/// <param name="storeProcedureRespository"></param>
public MaestrosService(IUnitOfWork unitOfWork,
IConfiguration configuration,
IErrorManager errorManager,
ILog log,
RoleManager <ApplicationRoles> roleManager,
IStoreProcedureRepository storeProcedureRespository)
{
_unitOfWork = unitOfWork;
_storeProcedureRespository = storeProcedureRespository;
_configuration = configuration;
_errorManager = errorManager;
_log = log;
_roleManager = roleManager;
_mapper = new MapperMaestros();
}
/// <summary>
///
/// </summary>
/// <param name="userManager"></param>
/// <param name="iunitOfWork"></param>
/// <param name="log"></param>
/// <param name="configuration"></param>
/// <param name="signInManager"></param>
/// <param name="roleManager"></param>
/// <param name="errorManager"></param>
/// <param name="storeProcedure"></param>
/// <param name="emailService"></param>
public UserServices(UserManager <ApplicationUser> userManager,
IUnitOfWork iunitOfWork,
ILog log,
IConfiguration configuration,
SignInManager <ApplicationUser> signInManager,
RoleManager <ApplicationRoles> roleManager,
IErrorManager errorManager,
IStoreProcedureRepository storeProcedure,
IEmailService emailService)
{
_userManager = userManager;
_iunitOfWork = iunitOfWork;
_log = log;
_configuration = configuration;
_signInManager = signInManager;
_roleManager = roleManager;
_errorManager = errorManager;
_storeProcedure = storeProcedure;
_emailService = emailService;
_mapper = new MapperUser();
}
/// <summary>
/// GridData by page and rows
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public ActionResult GridData(int page, int rows)
{
try
{
_itinerarysRepository = new ItinerarysRepository();
_storeProcedureRepository = new StoreProcedureRepository();
var res = _storeProcedureRepository.GetManageItineraries(page, rows);
var pageSize = rows;
var totalRecords = res.Any() ? Convert.ToInt32(res[0].intTotalHits) : 0;
var totalPages = (int)Math.Ceiling(totalRecords / (float)pageSize);
var res2 = res.ToList();
#region
try
{
var request = ControllerContext.HttpContext.Request;
if (request["ItineraryID"] != null)
{
var iId = long.Parse(request["ItineraryID"]);
var res3 = res2.FindAll(x => x.ItineraryID == iId);
res2 = res3;
}
else if (request["Airline"] != null)
{
var res3 =
res2.FindAll(
x => x.AirlineName.Contains(request["Airline"].ToString(CultureInfo.InvariantCulture)));
res2 = res3;
}
}
catch (Exception exception)
{
ModelState.AddModelError("", exception);
}
#endregion
var jsonData = new
{
total = totalPages,
page,
records = totalRecords,
rows = (
from x in res2
let departDateTime = x.DepartDateTime
where departDateTime != null
let arrivalDateTime = x.ArrivalDateTime
where arrivalDateTime != null
select new
{
id = x.ItineraryID,
cell = new[] { "", "", "",
x.ItineraryID.ToString(CultureInfo.InvariantCulture),
departDateTime.Value.ToString(CultureInfo.InvariantCulture),
arrivalDateTime.Value.ToString(CultureInfo.InvariantCulture),
x.DepartureAirportDesignationLetters,
x.ArrivalAirportDesignationLetters,
x.FlightNumber.ToString(CultureInfo.InvariantCulture),
x.AirlineName,
x.PassengerName,
x.PassengerEmail,
x.Pingers,
x.Stops.HasValue ? x.Stops.Value.ToString(CultureInfo.InvariantCulture) : string.Empty,
x.Type,
x.IsTestItinerary == false ? "No":"Yes" }
}).ToArray()
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
catch
{
ViewBag.message = "An error was ocurred.";
return(null);
}
}
public ActionResult InsertBasic(string Stops, string TripTypeName, string PassengerName, string PassengerLastName, string PassengerEmail)
{
_airlinesRepository = new AirlinesRepository();
_airportsRepository = new AirportsRepository();
_tagsRepository = new TagsRepository();
_passengerRepository = new PassengerRepository();
_itineraryPingersRepository = new ItineraryPingersRepository();
new UserTagsRepository();
_usersRepository = new UsersRepository();
_monitoredFlightsRepository = new MonitoredFlightsRepository();
_itinerarysRepository = new ItinerarysRepository();
_flightsRepository = new FlightsRepository();
new GatewayAirlineRepository();
#region Create Itinerary
var model = new BasicItineraryModel
{
//ConnxysTagId = ConnxysTagId,
DepartureTime = _listF.First().DepartureDateTime,
ArrivalTime = _listF.Last().ArrivalDateTime,
DepartureName = _airportsRepository.Get(_listF.First().DepartureLocation).AirportDesignationLetters,
ArrivalName = _airportsRepository.Get(_listF.Last().ArrivalLocation).AirportDesignationLetters,
Stops = Convert.ToInt32(Stops),
TripTypeName = TripTypeName,
DepartDateTimeUTC = _listIti.First().DepartDateTimeUTC,
ArrivalDateTimeUTC = _listIti.Last().ArrivalDateTimeUTC
};
object jsonData;
//Get Passenger Information
var passenger = _passengerRepository.Get(PassengerEmail);
passenger.PassengerName = PassengerName;
passenger.PassengerLastName = PassengerLastName;
_passengerRepository.Update(passenger);
var itinerary = new Itinerary
{
//UserID = userInfo.userID,
UserID = 0,
Stops = model.Stops,
DepartDateTime = model.DepartureTime,
ArrivalDateTime = model.ArrivalTime,
AirlineReservationID = model.AirlineReservationId,
RetStops = model.RetStops,
TripType = (short?)int.Parse(model.TripTypeName),
From = model.DepartureName,
To = model.ArrivalName,
CreationDate = DateTime.UtcNow,
Type = "Real Flight",
PassengerID = passenger != null ? passenger.PassengerID : 0,
DepartDateTimeUTC = model.DepartDateTimeUTC,
ArrivalDateTimeUTC = model.ArrivalDateTimeUTC
};
try
{
//insert the new itinerary
_itinerarysRepository.Add(itinerary);
var itineraryId = itinerary.ItineraryID;
if (itineraryId > 0)
{
var connxysWcfRestService = new ConnxysWCFRestService();
var flightsList = new StringBuilder();
var currentFlight = 0L;
var flightInd = 0;
//insert all the flights
foreach (var flightItem in _listF)
{
flightItem.ItineraryID = itineraryId;
_flightsRepository.Add(flightItem);
if (flightInd == (_listF.Count - 1))
{
flightsList.Append(flightItem.FlightID);
}
else
{
flightsList.Append(flightItem.FlightID).Append("-");
}
if (flightInd == 0)
{
currentFlight = flightItem.FlightID;
}
var monitoredFlights = new MonitoredFlights();
{
monitoredFlights.FlightId = flightItem.FlightID;
monitoredFlights.FlightNumber = flightItem.FlightNumber;
monitoredFlights.StartDate = Convert.ToDateTime(flightItem.DepartureDateTime);
monitoredFlights.EndDate = Convert.ToDateTime(flightItem.ArrivalDateTime);
monitoredFlights.DepartureLocation = flightItem.DepartureLocation;
monitoredFlights.ArrivalLocation = flightItem.ArrivalLocation;
monitoredFlights.Status = 0;
var airline = _airlinesRepository.Get(flightItem.AirlineID);
monitoredFlights.AirlineDesignator = airline.AirlineDesignator;
monitoredFlights.AirlineName = airline.AirlineName;
}
//Insert monitoredflight in the database
_monitoredFlightsRepository.Add(monitoredFlights);
// Increase Flight index
flightInd++;
}
//insert all the bags
foreach (var bagItem in _listB)
{
var baggageInfo = new BaggageInfo {
BagIATANumber = bagItem.BagIATANumber,
ItineraryId = itineraryId,
PingerId = bagItem.ConnxysTagID,
PassengerEmail = passenger.PassengerEmail,
PassengerLastName = passenger.PassengerLastName,
PassengerName = passenger.PassengerName
};
connxysWcfRestService.UpdateBaggageInfo(baggageInfo);
var itineraryPinger = new ItineraryPingers {
ItineraryID = itinerary.ItineraryID,
ConnxysTagID = bagItem.ConnxysTagID
};
_itineraryPingersRepository.Add(itineraryPinger);
}
_listB = new List <BagTagDesignation>();
var creationDate = DateTime.Now.ToUniversalTime();
_storeProcedureRepository = new StoreProcedureRepository();
_storeProcedureRepository.CreateOutgoingMessage(itinerary.ItineraryID, null, null, null, null, Convert.ToInt64(model.TagId), "Manually", creationDate, false);
//Create notification message to sent a message to the passenger abput the itinerary creation
var notification = new NotificationMessage
{
Title = "Itinerary Information",
Message = string.Format
("Hello {0}! We’re excited to have you fly with us on flight #: {1} to {2}. We’ll notify you when your bag is checked in, when it’s been loaded aboard your flight, and where you can reclaim it in {3}. Enjoy your flight with us!", passenger.PassengerName, _listF[0].FlightNumber.ToString(), model.ArrivalName, model.ArrivalName),
TokenId = passenger.TokenId
};
foreach (var fl in _listF)
{
var airlineDesignator = _airlinesRepository.Get(fl.AirlineID);
var callUpdateFlight = new ConnxysWCFRestService();
if (fl.DepartureDateTime == null)
{
continue;
}
if (fl.ArrivalDateTime != null)
{
callUpdateFlight.UpdateSimpleFlight(
fl.FlightID.ToString(CultureInfo.InvariantCulture),
airlineDesignator.AirlineDesignator,
fl.FlightNumber.ToString(CultureInfo.InvariantCulture),
fl.DepartureDateTime.Value.ToString(CultureInfo.InvariantCulture),
fl.ArrivalDateTime.Value.ToString(CultureInfo.InvariantCulture));
}
}
_listF = new List <Flights>();
jsonData = new {
status = "Ok",
itineraryId = itinerary.ItineraryID
};
//Send push notification about itinerary creation to the passenger
connxysWcfRestService.SendPushNotification(notification);
}
else
{
//throw error the itinerary can not be created
_listF = new List <Flights>();
PopulateList();
jsonData = new
{
status = "Failed",
message = "Error: The itinerary was not added."
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
//throw error the itinerary can not be created
_listF = new List <Flights>();
jsonData = new
{
status = "Failed",
message = "Error: The itinerary was not added."
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
#endregion
}
