public async Task <ActionResult> GetChipestFaresFor(string code, string date) { if (code == null) { code = "MAD"; } if (date == null) { date = "01/04/2018"; } using (MySqlConnection connection = new MySqlConnection(connectionString)) { // Create database if not exists using (CircuitPlanificationContext contextDB = new CircuitPlanificationContext(connection, false)) { contextDB.Database.CreateIfNotExists(); } connection.Open(); List <Fare> result = new List <Fare>(); // DbConnection that is already opened using (CircuitPlanificationContext context = new CircuitPlanificationContext(connection, false)) { foreach (Routes route in context.Routes.ToList().FindAll(p => p.iataCodeDepart == code)) { result.AddRange(await CircuitPlanificator.Repositories.FaresRepository.GetChipestFaresFor(route.iataCodeArrive, route.iataCodeDepart, DateTime.ParseExact(date, "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentCulture))); } } return(Json(result, JsonRequestBehavior.AllowGet)); } return(View()); }
public ActionResult GetAirportCoords(string code) { using (MySqlConnection connection = new MySqlConnection(connectionString)) { // Create database if not exists using (CircuitPlanificationContext contextDB = new CircuitPlanificationContext(connection, false)) { contextDB.Database.CreateIfNotExists(); } connection.Open(); List <Fare> result = new List <Fare>(); // DbConnection that is already opened using (CircuitPlanificationContext context = new CircuitPlanificationContext(connection, false)) { AirportCoords aux = new AirportCoords(); aux.latitud = context.Airports.ToList().Find(a => a.iataCode == code).latitude.ToString(); aux.longitud = context.Airports.ToList().Find(a => a.iataCode == code).longitude.ToString(); return(Json(aux, JsonRequestBehavior.AllowGet)); } } }
public ActionResult Index() { // Create database if not exists //using (CircuitPlanificationContext contextDB = new CircuitPlanificationContext()) //{ // contextDB.Database.CreateIfNotExists(); //} // Create database if not exists //using (CircuitPlanificationContext contextDB = new CircuitPlanificationContext()) //{ // var x = contextDB.Cities.ToList(); //} //string connectionString = "server=localhost;port=3305;database=parking;uid=root"; using (MySqlConnection connection = new MySqlConnection(connectionString)) { // Create database if not exists using (CircuitPlanificationContext contextDB = new CircuitPlanificationContext(connection, false)) { contextDB.Database.CreateIfNotExists(); } connection.Open(); // DbConnection that is already opened using (CircuitPlanificationContext context = new CircuitPlanificationContext(connection, false)) { var x = context.Cities.ToList(); var y = context.Airports.ToList(); var z = context.Routes.ToList(); } } return(View()); }