// POST public void Add(Employee NewEmployee) { // define function for generating a random number const string chars = "0123456789"; Random random = new Random(); string RandomString(int length) { return(new string(Enumerable.Repeat(chars, length) .Select(s => s[random.Next(s.Length)]).ToArray())); } bool noMatch = true; // Fetch all emplyee numbers var employeeNumbers = _context.Employees.Select(employee => employee.EmployeeNumber).ToList(); while (noMatch) { // If random number doesnt exist in database, bind it and persist newEmployee string randomNumber = RandomString(5); if (!employeeNumbers.Contains(randomNumber)) { NewEmployee.EmployeeNumber = randomNumber; noMatch = false; } } _context.Add(NewEmployee); _context.SaveChanges(); }
public ActionResult Create(Pilot model) { if (!User.IsManager()) { return(RedirectToAction("Restricted", "Error", new { message = "Restricted to your own club" })); } // Create the pilot on the managers club if not it is invalid if (!User.IsAdministrator() && model.ClubId != User.Pilot().ClubId) { return(RedirectToAction("Restricted", "Error", new { message = "Trying to create pilot in club where you are not a manager... " })); } // Resolve club information manually to avoid conflict with club route //model.Club = db.Clubs.Find(model.ClubId); if (Request.IsClub()) { // There is a bug where the club from the request is bound into the resolving of the club on the pilot modelstate validation, we force this through // HACK: This probably means there is an evil bug hidden when we are going to save more information on club level. ModelState.Remove("Club"); } if (ModelState.IsValid) { db.Pilots.Add(model); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClubId = new SelectList(db.Clubs, "ClubId", "Name", model.ClubId); return(View(model)); }
public IActionResult Add(FlightViewModel model, string returnUrtl = null) { var flight = new Flight { Id = model.Id, Airplane = _dbContext.Airplanes.Find(model.AirplaneId), AviaCompany = _dbContext.AviaCompanies.Find(model.AviaCompanyId), HomeAirport = _dbContext.Airports.Find(model.HomeAirportId), DestinationAirport = _dbContext.Airports.Find(model.DestinationAirportId), Departure = model.Departure, Arrival = model.Arrival }; var curFlights = _dbContext.Flights.ToList().OrderByDescending(item => item.Id); if (curFlights == null) { flight.Id = 1; } else { flight.Id = curFlights.First().Id + 1; } _dbContext.Flights.Add(flight); _dbContext.SaveChanges(); return(RedirectToAction("Index")); }
// POST public void Add(Plane newPlane) { // define function for generating a random identifier const string LetterPool = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; const string NumberPool = "1234567890"; Random random = new Random(); string RandomString(int Length) { string part1 = new string(Enumerable.Repeat(NumberPool, Length / 2) .Select(s => s[random.Next(s.Length)]).ToArray()); string part2 = new string(Enumerable.Repeat(LetterPool, Length / 2) .Select(s => s[random.Next(s.Length)]).ToArray()); return(part1 + part2); } bool NoMatch = true; // Fetch all identifiers var Identifiers = _context.Planes.Select(plane => plane.Identifier).ToList(); while (NoMatch) { // If random identifier doesnt exist in database, bind it and persist newPlane string RandomIndentifier = RandomString(6); if (!Identifiers.Contains(RandomIndentifier)) { newPlane.Identifier = RandomIndentifier; NoMatch = false; } } _context.Add(newPlane); _context.SaveChanges(); }
public ActionResult Create([Bind(Include = "IdFlight,IdDepartureAirport,IdDestinationAirport,FlightTime")] Flight flight) { if (ModelState.IsValid) { db.Flights.Add(flight); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(flight)); }
public ActionResult Create(Club club) { if (ModelState.IsValid) { db.Clubs.Add(club); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(club)); }
public ActionResult Create(Club club) { if (ModelState.IsValid) { db.Clubs.Add(club); db.SaveChanges(); return(RedirectToAction("Index")); } this.ViewBag.LocationId = new SelectList(this.db.Locations.OrderBy(p => p.Name), "LocationId", "Name", (club == null) ? (object)null : club.LocationId); return(View(club)); }
public ActionResult Create([Bind(Include = "ID,Description,TakeOff,Weather,Duration")] Flight flight) { if (ModelState.IsValid) { db.Flights.Add(flight); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(flight)); }
public ActionResult Create(StartType starttype) { if (ModelState.IsValid) { db.StartTypes.Add(starttype); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClubId = new SelectList(db.Clubs, "ClubId", "ShortName", starttype.ClubId); return(View(starttype)); }
public int AddFlight(Flight flight) { try { contextDb.Flights.Add(flight); contextDb.SaveChanges(); return(flight.FlightId); } catch (Exception e) { return(-1); } }
public ActionResult Create(Plane plane) { plane.CreatedTimestamp = DateTime.Now; plane.CreatedBy = User.Pilot().ToString(); plane.LastUpdatedTimestamp = DateTime.Now; plane.LastUpdatedBy = User.Pilot().ToString(); if (ModelState.IsValid) { db.Planes.Add(plane); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StartTypeId = new SelectList(db.StartTypes, "StartTypeId", "ShortName", plane.StartTypeId); return(View(plane)); }
public ActionResult flight(/*[Bind(Include ="Email")]*/ Flight f) { if (ModelState.IsValid) { using (Fdb) { Fdb.Flights.Add(f); Fdb.SaveChanges(); } ModelState.Clear(); } //Customer ct = new Customer(); //ViewBag.Message = ct.Name ; //return View(); return(RedirectToAction("ListOfBookings")); }
public async Task AddSchedules(string scheduleFromDate, string scheduleToDate) { TimeSpan timeAccessory = new TimeSpan(0, 0, 0); DateTime fromDate = Convert.ToDateTime(scheduleFromDate + " " + timeAccessory); DateTime toDate = Convert.ToDateTime(scheduleToDate + " " + timeAccessory); AirCraft airCraft = new AirCraft(); for (var dt = fromDate; dt <= toDate; dt = dt.AddDays(1)) { //var dt = DateTime.Now; foreach (var r in _context.Routes) { for (var i = 0; i < 4; i++) { DateTime tempDepartDateTime = Convert.ToDateTime(dt.Date.ToString("d") + " " + GenerateDepartTime()); DateTime tempArriveDateTime = tempDepartDateTime.Add(r.AveDuration); int ramID = GenerateAirCraftID(); airCraft = _context.AirCrafts.Where(a => a.AirCraftID == ramID).FirstOrDefault(); //随机选取一个飞机 await _context.Flight_Schedules.AddAsync(new Flight_Schedule { RouteID = r.RouteID, DepartDateTime = tempDepartDateTime, ArriveDateTime = tempArriveDateTime, AirlineCode = RandomString(2) + RandomInt(3), AirCraftID = airCraft.AirCraftID, NetFaire = r.BasicFare, Economy = airCraft.EconomyCap, Business = airCraft.BusinessCap, PremEconomy = airCraft.PremEconomyCap, First = airCraft.FirstCap }); } //_context.SaveChanges(); } } _context.SaveChanges(); }
public void UpdateFlight(Flight flight) { using (FlightContext dbContext = new FlightContext()) { dbContext.Update <Flight>(flight); dbContext.SaveChanges(); } }
public void FlightAdd(Flight flight) { using (FlightContext db = new FlightContext()) { db.Flights.Add(flight); db.SaveChanges(); } }
public void PassEdit(Passenger passenger) { using (FlightContext db = new FlightContext()) { db.Entry(passenger).State = EntityState.Modified; db.SaveChanges(); } }
public void PassAdd(Passenger passenger) { using (FlightContext db = new FlightContext()) { db.Passengers.Add(passenger); db.SaveChanges(); } }
public void FlightUpdate(Flight flight) { using (FlightContext db = new FlightContext()) { db.Entry(flight).State = EntityState.Modified; db.SaveChanges(); } }
public void PassDelete(Passenger passenger) { using (FlightContext db = new FlightContext()) { db.Passengers.Attach(passenger); db.Entry(passenger).State = EntityState.Deleted; db.SaveChanges(); } }
public void Delete(Flight flight) { using (FlightContext dbContext = new FlightContext()) { flight.IsValid = false; flight.UpdateTime = DateTime.Now; dbContext.Update <Flight>(flight); dbContext.SaveChanges(); } }
public void FlightDelete(Flight flight) { using (FlightContext db = new FlightContext()) { db.Flights.Attach(flight); db.Passengers.RemoveRange(flight.Passengers); db.Entry(flight).State = EntityState.Deleted; db.SaveChanges(); } }
public ActionResult RemoveFlight(Flight flight) { using (flightContext = new FlightContext()) { Flight toRemove = flightContext.Flights.Find(flight.Id); flightContext.Flights.Remove(toRemove); flightContext.SaveChanges(); return(View("~/Views/Admin/Home.cshtml")); } }
/// <summary> /// Method that reads from file all airports and saves in appropriate table. /// </summary> /// <param name="FlightContext">EntityFramework Flights Context</param> public static void SeedAirports(FlightContext context, ILogger logger) { if (!context.Airports.Any()) { var airportData = System.IO.File.ReadAllText("Migrations/SeedData/airports.json"); var airports = JsonConvert.DeserializeObject <IList <Airport> >(airportData); context.AddRange(airports); context.SaveChanges(); } }
public ActionResult Create(Location location) { location.CreatedTimestamp = DateTime.Now; location.CreatedBy = User.Pilot().ToString(); location.LastUpdatedTimestamp = DateTime.Now; location.LastUpdatedBy = User.Pilot().ToString(); if (!location.ICAO.IsNullOrWhiteSpace()) { location.ICAO = location.ICAO.ToUpperInvariant(); } if (ModelState.IsValid) { db.Locations.Add(location); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(location)); }
public IActionResult Create(Flight flight) { if (ModelState.IsValid) { db.Flights.Add(flight); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(flight)); }
public void BookFlight(int flightId, [FromBody] IEnumerable <Traveler> travelers) { using (var flightContext = new FlightContext()) { var flight = flightContext.Flights.FirstOrDefault(f => f.FlightId == flightId); if (flight != null) { flight.Travelers = travelers.ToList(); flightContext.SaveChanges(); } } }
public async Task <IActionResult> RetrieveAndSave([FromBody] Search searchInfo) { searchInfo.Return_date = (searchInfo.Return_date != null) ? searchInfo.Return_date.Substring(0, 10) : ""; searchInfo.Departure_date = searchInfo.Departure_date.Substring(0, 10); var dbService = new DbService(db); var flightsInfoOld = dbService.getSearchData(searchInfo); if (flightsInfoOld.Count() != 0) { return(Ok(flightsInfoOld)); } var queryUrl = String.Format("{0}?apikey={1}&origin={2}&destination={3}&departure_date={4}&adults={5}¤cy={6}", ServiceUrl, ApiKey, searchInfo.Origin, searchInfo.Destination, searchInfo.Departure_date, searchInfo.Adults, searchInfo.Currency); if (searchInfo.Return_date != "") { queryUrl += "&return_date=" + searchInfo.Return_date; } HttpClient client = new HttpClient(); client.BaseAddress = new Uri(ServiceUrl); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = await client.GetAsync(queryUrl); response.EnsureSuccessStatusCode(); var contents = await response.Content.ReadAsStringAsync(); RootObject r = JsonConvert.DeserializeObject <RootObject>(contents); searchInfo.RootObject = r; db.Search.Add(searchInfo); db.SaveChanges(); var flightsInfoNew = dbService.getSearchData(searchInfo); return(Ok(flightsInfoNew)); }
public void AddEntriesToFlightEmployees(List <Employee> Employees, int FlightId) { for (int i = 0; i < Employees.Count(); i++) { FlightEmployee NewFlightEmployee = new FlightEmployee { FlightId = FlightId, EmployeeId = Employees[i].Id }; _context.Add(NewFlightEmployee); _context.SaveChanges(); } }
public bool AddUser(RegisterModel model) { using (FlightContext db = new FlightContext()) { db.Managers.Add(new Manager { Email = model.Name, Password = model.Password, Role = model.Role }); db.SaveChanges(); Manager user = db.Managers.FirstOrDefault(u => u.Email == model.Name); if (user != null) { FormsAuthentication.SetAuthCookie(model.Name, true); return(true); } else { return(false); } } }
public ActionResult AddFlight(Flight flightModel) { using (flightContext = new FlightContext()) { if (flightModel.FromLocation == null || flightModel.ToLocation == null || flightModel.DepartureTime == null || flightModel.ArrivalTime == null || flightModel.AirplaneType == null || flightModel.AirplaneId == null || flightModel.PilotName == null || flightModel.UnusedPlacesBusiness <= 0 || flightModel.UnusedPlacesEconomy <= 0 || flightModel.DepartureTime > flightModel.ArrivalTime) { ViewBag.FailedAddMessage = "You must fill in all of the spaces and the data should be correct!"; return(View("AddFlight", new Flight())); } else { flightContext.Flights.Add(flightModel); flightContext.SaveChanges(); } } ModelState.Clear(); ViewBag.SuccessMessage = "Flight was successfully added!"; return(View("~/Views/Admin/Home.cshtml")); }