public async Task <ActionResult <Bagage> > PostBagage(Bagage bagage) { _context.Bagages.Add(bagage); await _context.SaveChangesAsync(); return(CreatedAtAction("GetBagage", new { id = bagage.BagageId }, bagage)); }
public async Task <IActionResult> PutBagage(int id, Bagage bagage) { if (id != bagage.BagageId) { return(BadRequest()); } _context.Entry(bagage).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BagageExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
protected BagagePageModel(MyAirportContext context) { _context = context; Bagage = new Bagage() { Vol = null }; }
public void HandleBag(Bagage bag) { // Generates and tags a bag with a unique tag bag.BagTag = Tagger.GenTag(); // notify server NotifyServer(bag, 2); // sendes videre til sorting Sendtosort(bag); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Bagage = await _context.Bagages.FirstOrDefaultAsync(m => m.BagageID == id); if (Bagage == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Bagage = await _context.Bagages .Include(b => b.Vol).FirstOrDefaultAsync(m => m.ID_BAGAGE == id); if (Bagage == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Bagage = await _context.Bagages .Include(b => b.Vol).FirstOrDefaultAsync(m => m.ID_BAGAGE == id); if (Bagage == null) { return(NotFound()); } ViewData["ID_VOL"] = BagagesHelper.ListVolInfo(_context); return(Page()); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Bagage = await _context.Bagages.FindAsync(id); if (Bagage != null) { _context.Bagages.Remove(Bagage); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Bagage = await _context.Bagages .Include(b => b.Vol).FirstOrDefaultAsync(m => m.BagageId == id); if (Bagage == null) { return(NotFound()); } ViewData["VolId"] = SelectListVols; return(Page()); }
public async Task<IActionResult> OnGetAsync(int? id) { if (id == null) { return NotFound(); } Bagage = await _context.Bagages.FirstOrDefaultAsync(m => m.BagageID == id); if (Bagage == null) { return NotFound(); } ViewData["VolId"] = BagagesHelper.ListVolInfo(_context); return Page(); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Bagage = await _context.Bagages .Include(b => b.Vol).FirstOrDefaultAsync(m => m.BagageId == id); if (Bagage == null) { return(NotFound()); } //ViewData["VolId"] = new SelectList(_context.Vols, "VolId", "Cie"); ViewData["VolId"] = BagageHelper.ListVolInfos(_context); return(Page()); }
/// <summary> /// Recieving bags from Desk /// </summary> /// <param name="bag"></param> internal void RecieveFromDesk(Bagage bag) { }
static void Main(string[] args) { Console.WriteLine("Hello World!"); System.Console.WriteLine("MyAirport project bonjour!!"); using (var db = new BNASNWEE.MyAirport.EF.MyAirportContext()) { // Create Console.WriteLine("Création du vol LH1232"); Vol v1 = new Vol { Cie = "LH", Des = "BKK", Dhc = Convert.ToDateTime("14/01/2020 16:45"), Imm = "RZ62", Lig = "1232", Pkg = "R52", Pax = 238 }; db.Add(v1); Console.WriteLine("Creation vol SQ333"); Vol v2 = new Vol { Cie = "SK", Des = "CDG", Dhc = Convert.ToDateTime("14/01/2020 18:20"), Imm = "TG43", Lig = "333", Pkg = "R51", Pax = 423 }; db.Add(v2); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { Classe = "Y", CodeIata = "012387364501", DateCreation = Convert.ToDateTime("14/01/2020 12:52"), Destination = "BEG" }; db.Add(b1); db.SaveChanges(); Console.ReadLine(); // Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols .OrderBy(v => v.Cie); foreach (var v in vol) { Console.WriteLine($"Le vol {v.Cie}{v.Lig} N° {v.VolId} a destination de {v.Des} part à {v.Dhc} heure"); } Console.ReadLine(); // Update Console.WriteLine($"Le bagage {b1.BagageId} est modifié pour être rattaché au vol {v1.VolId} => {v1.Cie}{v1.Lig}"); b1.VolId = v1.VolId; db.SaveChanges(); Console.ReadLine(); // Delete vol et bagages du vol Console.WriteLine($"Suppression du vol {v1.VolId} => {v1.Cie}{v1.Lig}"); db.Remove(v1); db.SaveChanges(); Console.ReadLine(); } }
/// <summary> /// Called when the bagage has been sorted /// </summary> /// <param name="bagage"></param> static void SortingOutgoingMessage(Bagage bagage) { CentralManager.Instance.FileLogger.Append($"[{bagage.Brand}] [{DateTime.Now}] sorted and going to gate: [{bagage.Sticker.GateId}]\n"); }
internal void CreateBag(Bagage bag, int status) { Console.WriteLine($"I have added bag number: {bag.BagTag}. Destination: {bag.Destination}"); }
static void Main(string[] args) { var connectionString = ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString; var optionsBuilder = new DbContextOptionsBuilder <MyAirportContext>(); optionsBuilder .UseSqlServer(connectionString) .UseLoggerFactory(MyLoggerFactory); ILogger logger = MyLoggerFactory.CreateLogger <Program>(); System.Console.WriteLine("MyAirport project bonjour!!"); using (var db = new MyAirportContext(optionsBuilder.Options)) { // Create Console.WriteLine("Création du vol LH1232"); Vol v1 = new Vol { Cie = "LH", Des = "BKK", Dhc = Convert.ToDateTime("14 January 2020 4:45:00 PM"), Imm = "RZ62", Lig = "1232", Pkg = "R52", Pax = 238 }; db.Add(v1); Console.WriteLine("Creation vol SQ333"); Vol v2 = new Vol { Cie = "SK", Des = "CDG", Dhc = Convert.ToDateTime("14 January 2020 6:45:00 PM"), Imm = "TG43", Lig = "333", Pkg = "R51", Pax = 423 }; db.Add(v2); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { Classe = "Y", CodeIata = "012387364501", DateCreation = Convert.ToDateTime("14 January 2020 5:45:00 PM"), Destination = "BEG" }; db.Add(b1); db.SaveChanges(); Console.ReadLine(); // Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols.OrderBy(v => v.Cie); foreach (var v in vol) { Console.WriteLine($"Le vol {v.Cie}{v.Lig} N° {v.VolId} a destination de {v.Des} part à {v.Dhc} heure"); } Console.ReadLine(); // Update Console.WriteLine($"Le bagage {b1.BagageId} est modifié pour être rattaché au vol {v1.VolId} => {v1.Cie}{v1.Lig}"); b1.VolId = v1.VolId; db.SaveChanges(); Console.ReadLine(); // Delete vol et bagages du vol Console.WriteLine($"Suppression du vol {v1.VolId} => {v1.Cie}{v1.Lig}"); db.Remove(v1); db.SaveChanges(); Console.ReadLine(); } }
static void Main(string[] args) { dbContextOptionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["MyAirportDB"].ConnectionString); dbContextOptionsBuilder.UseLoggerFactory(MyAirportLoggerFactory); DbContextOptions <MyAirportContext> dbContextOptions = (DbContextOptions <MyAirportContext>)dbContextOptionsBuilder.Options; System.Console.WriteLine("MyAirport project bonjour!!"); using (var db = new MyAirportContext(dbContextOptions)) { // Create Console.WriteLine("Création du vol LH1232"); Vol v1 = new Vol { Cie = "LH", Des = "BKK", Dhc = Convert.ToDateTime("14/01/2020 16:45"), Imm = "RZ62", Lig = "1232", Pkg = "R52", Pax = 238 }; db.Add(v1); Console.WriteLine("Creation vol SQ333"); Vol v2 = new Vol { Cie = "SK", Des = "CDG", Dhc = Convert.ToDateTime("14/01/2020 18:20"), Imm = "TG43", Lig = "333", Pkg = "R51", Pax = 423 }; db.Add(v2); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { Classe = "Y", CodeIata = "012387364501", DateCreation = Convert.ToDateTime("14/01/2020 12:52"), Destination = "BEG" }; db.Add(b1); db.Database.EnsureCreated(); db.SaveChanges(); Console.ReadLine(); // Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols .OrderBy(v => v.Cie); foreach (var v in vol) { Console.WriteLine($"Le vol {v.Cie}{v.Lig} N° {v.VoldID} a destination de {v.Des} part à {v.Dhc} heure"); } Console.ReadLine(); // Update Console.WriteLine($"Le bagage {b1.BagageID} est modifié pour être rattaché au vol {v1.VoldID} => {v1.Cie}{v1.Lig}"); b1.VolID = v1.VoldID; db.Database.EnsureCreated(); db.SaveChanges(); Console.ReadLine(); // Delete vol et bagages du vol /*Console.WriteLine($"Suppression du vol {v1.VoldID} => {v1.Cie}{v1.Lig}"); * db.Remove(v1); * db.Database.EnsureCreated(); * db.SaveChanges(); * Console.ReadLine();*/ } }
static void Main(string[] args) { /*** * Replace OnConfigure */ DbContextOptionsBuilder optionsBuilder = new DbContextOptionsBuilder <MyAirportContext>(); optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["MyAirportDatabase"].ConnectionString); optionsBuilder.UseLoggerFactory(MyAirportLoggerFactory); DbContextOptions <MyAirportContext> optionDbContext = (DbContextOptions <MyAirportContext>)optionsBuilder.Options; using (var db = new MyAirportContext(optionDbContext)) { // Create Console.WriteLine("Création du vol LH1232"); Vol v1 = new Vol { cie = "LH", des = "BKK", dhc = Convert.ToDateTime("14/01/2020 16:45"), imm = "RZ62", lig = "1232", pkg = "R52", pax = 238 }; db.Add(v1); Console.WriteLine("Creation vol SQ333"); Vol v2 = new Vol { cie = "SK", des = "CDG", dhc = Convert.ToDateTime("14/01/2020 18:20"), imm = "TG43", lig = "333", pkg = "R51", pax = 423 }; db.Add(v2); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { // VolId = v1.Vol, classe = "Y", code_iata = "012387364501", date_creation = Convert.ToDateTime("14/01/2020 12:52"), destination = "BEG" }; db.Add(b1); db.SaveChanges(); Console.ReadLine(); // Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols.OrderBy(v => v.cie); foreach (var v in vol) { Console.WriteLine($"Le vol {v.cie}{v.lig} N° {v.VolId} a destination de {v.des} part à {v.dhc} heure"); } Console.ReadLine(); //// Update Console.WriteLine($"Le bagage {b1.BagageId} est modifié pour être rattaché au vol {v1.VolId} => {v1.cie}{v1.lig}"); b1.VolId = v1.VolId; db.SaveChanges(); Console.ReadLine(); //// Delete vol et bagages du vol // Console.WriteLine($"Suppression du vol {v1.VolId} => {v1.cie}{v1.lig}"); // db.Remove(v1); // db.SaveChanges(); // Console.ReadLine(); } }
private void NotifyServer(Bagage bag, int status) { // Notifies the server of a new bag wich is being send to sorting CentralServer.Instance.CreateBag(bag, status); }
static void Main(string[] args) { ILogger logger = MyLoggerFactoy.CreateLogger <Program>(); logger.LogInformation("Logger initialized"); var connectionString = ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString; var optionsBuilder = new DbContextOptionsBuilder <MyAirportContext>() .UseSqlServer(connectionString) .UseLoggerFactory(MyLoggerFactoy); Console.WriteLine("MyAirport project bonjour!!"); using (var db = new MyAirportContext(optionsBuilder.Options)) { // Create Console.WriteLine("Création du vol LH1232"); Vol v1 = new Vol { Cie = "LH", Des = "BKK", Dhc = Convert.ToDateTime("01/14/2020 16:45"), Imm = "RZ62", Lig = "1232", Pkg = "R52", Pax = 238 }; db.Add(v1); Console.WriteLine("Creation vol SQ333"); Vol v2 = new Vol { Cie = "SK", Des = "CDG", Dhc = Convert.ToDateTime("01/14/2020 18:20"), Imm = "TG43", Lig = "333", Pkg = "R51", Pax = 423 }; db.Add(v2); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { Classe = "Y", CodeIata = "012387364501", DateCreation = Convert.ToDateTime("01/14/2020 12:52"), Destination = "BEG" }; db.Add(b1); db.SaveChanges(); Console.ReadLine(); // Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols .OrderBy(v => v.Cie); foreach (var v in vol) { Console.WriteLine($"Le vol {v.Cie}{v.Lig} N° {v.VolID} a destination de {v.Des} part à {v.Dhc} heure"); } Console.ReadLine(); // Update Console.WriteLine($"Le bagage {b1.BagageID} est modifié pour être rattaché au vol {v1.VolID} => {v1.Cie}{v1.Lig}"); b1.Vol = v1; db.SaveChanges(); v1.Bagages.ToList().ForEach(b => { Console.WriteLine($"Le bagage {b.BagageID} est associé au vol {b.Vol.VolID}."); }); Vol vod = v1; Console.WriteLine("#####################################################"); Console.WriteLine(vod.VolID); vod.Bagages.ToList().ForEach(bag => Console.WriteLine(bag.BagageID)); Console.WriteLine("#####################################################"); Console.ReadLine(); // Delete vol et bagages du vol Console.WriteLine($"Suppression du vol {v1.VolID} => {v1.Cie}{v1.Lig}"); //db.Remove(v1); db.SaveChanges(); Console.ReadLine(); } }
static void Main(string[] args) { var optionsBuilder = new DbContextOptionsBuilder <MyAirportContext>(); optionsBuilder.UseLoggerFactory(MyAirportLoggerFactory); optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["MyAirportDatabase"].ConnectionString); System.Console.WriteLine("MyAirport project bonjour!!"); using (var db = new MyAirportContext(optionsBuilder.Options) //var db = new MyAirportContext() ) { //Clear db to begin var bag = db.Bagages; foreach (var b in bag) { db.Remove(b); } var vol = db.Vols; foreach (var v in vol) { db.Remove(v); } db.SaveChanges(); // Create Console.WriteLine("Création du vol LH1232"); Vol v1 = new Vol { Cie = "LH", Des = "BKK", Dhc = Convert.ToDateTime("14/01/2020 16:45"), Imm = "RZ62", Lig = "1232", Pkg = "R52", Pax = 238 }; db.Add(v1); Console.WriteLine("Creation vol SQ333"); Vol v2 = new Vol { Cie = "SK", Des = "CDG", Dhc = Convert.ToDateTime("14/01/2020 18:20"), Imm = "TG43", Lig = "333", Pkg = "R51", Pax = 423 }; db.Add(v2); Console.WriteLine("Creation vol BKK238"); db.Add(new Vol("LH", "1234", Convert.ToDateTime("18/03/2020 16:45")) { Des = "BKK", Imm = "RB22", Pkg = "R52", Pax = 238 } ); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { Classe = "Y", CodeIata = "012387364501", DateCreation = Convert.ToDateTime("14/01/2020 12:52"), Destination = "BEG" }; db.Add(b1); Console.WriteLine("creation du bagage 987654321"); Bagage b2 = new Bagage { Classe = "Y", CodeIata = "987654321", DateCreation = Convert.ToDateTime("12/04/2020 17:18"), Destination = "BEG" }; db.Add(b2); Console.WriteLine("creation du bagage 0123456789"); db.Add(new Bagage("0123456789", Convert.ToDateTime("17/03/2020 14:09")) { Classe = "Y", Destination = "BEG" }); db.SaveChanges(); Console.ReadLine(); // ReadBagages_Vols_VolI Console.WriteLine("Voici la liste des vols disponibles"); var vols = db.Vols .OrderBy(v => v.Cie); foreach (var v in vols) { Console.WriteLine($"Le vol {v.Cie}{v.Lig} N° {v.VolId} a destination de {v.Des} part à {v.Dhc} heure"); } Console.ReadLine(); // Update Console.WriteLine($"Le bagage {b1.BagageId} est modifié pour être rattaché au vol {v1.VolId} => {v1.Cie}{v1.Lig}"); b1.VolId = v1.VolId; db.SaveChanges(); v1.Bagages.ToList().ForEach(b => Console.WriteLine($"VOLID: {v1.VolId} -> bagage {b.BagageId}")); Console.ReadLine(); // Update Console.WriteLine($"Le bagage {b1.BagageId} est modifié pour être rattaché au vol {v2.VolId} => {v2.Cie}{v2.Lig}"); b2.VolId = v2.VolId; db.SaveChanges(); v1.Bagages.ToList().ForEach(b => Console.WriteLine($"VOLID: {v2.VolId} -> bagage {b.BagageId}")); Console.ReadLine(); // Delete vol et mise a null du volId dans bagage Console.WriteLine($"Suppression du vol {v1.VolId} => {v1.Cie}{v1.Lig}"); db.Remove(v1); db.SaveChanges(); Console.ReadLine(); // Delete vol et delete des bagages attribués à ce vol Console.WriteLine($"Suppression du vol {v2.VolId} => {v2.Cie}{v2.Lig} induisant suppression du bagage {b2.BagageId} "); var bagages = db.Bagages.Where(b => b.VolId == v2.VolId); foreach (var b in bagages) { db.Remove(b); } db.Remove(v2); db.SaveChanges(); Console.ReadLine(); } }
static void Main(string[] args) { var optionsBuilder = new DbContextOptionsBuilder <MyAirportContext>(); optionsBuilder.UseLoggerFactory(MyAirportLoggerFactory); optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["MyAirportContext"].ConnectionString); System.Console.WriteLine("MyAirport project bonjour!!"); using (var db = new MyAirportContext(optionsBuilder.Options)) //using (var db = new MyAirportContext()) { // Create Console.WriteLine("Création du vol LH1232"); Vol v1 = new Vol("LH", "1232", Convert.ToDateTime("14/01/2020 16:45")) { Des = "BKK", Imm = "RZ62", Pkg = "R52", Pax = 238 }; db.Add(v1); db.SaveChanges(); Console.WriteLine("Creation vol SQ333"); Vol v2 = new Vol("SK", "333", Convert.ToDateTime("14/01/2020 18:20")) { Des = "CDG", Imm = "TG43", Pkg = "R51", Pax = 423 }; db.Add(v2); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage("012387364501", Convert.ToDateTime("14/01/2020 12:52")) { Classe = "Y", Destination = "BEG", }; db.Add(b1); db.SaveChanges(); Console.ReadLine(); // Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols .OrderBy(v => v.Cie); foreach (var v in vol) { Console.WriteLine($"Le vol {v.Cie}{v.Lig} N° {v.VolId} a destination de {v.Des} part à {v.Dhc} heure"); } Console.ReadLine(); // Update Console.WriteLine($"Le bagage {b1.BagageId} est modifié pour être rattaché au vol {v1.VolId} => {v1.Cie}{v1.Lig}"); b1.VolId = v1.VolId; db.SaveChanges(); Console.ReadLine(); Console.WriteLine($"Il y a {v1.Bagages.Count()} bagages sur le vol {v1.VolId}"); // Delete vol et bagages du vol Console.WriteLine($"Suppression du vol {v1.VolId} => {v1.Cie}{v1.Lig}"); db.Remove(v1); db.SaveChanges(); Console.ReadLine(); } }
static void Main(string[] args) { System.Console.WriteLine("Hello!"); DbContextOptionsBuilder optionsBuilder = new DbContextOptionsBuilder <MyAirportContext>(); optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["MyAirport"].ConnectionString); ///On utilise la factory pour gérer les logs optionsBuilder.UseLoggerFactory(MyLoggerFactory); System.Console.WriteLine("MyAirport project bonjour!!"); DbContextOptions <MyAirportContext> myOptions = (DbContextOptions <MyAirportContext>)optionsBuilder.Options; using (var db = new MyAirportContext(myOptions)) { //// Create //System.Console.WriteLine("Création du vol LH1232"); //Vol v1 = new Vol //{ // CIE = 1, // DES = "BKK", // DHC = Convert.ToDateTime("14/01/2020 16:45"), // IMM = "eer", // LIG = "1232", // PKG = "r", // PAX = 238 //}; //db.Add(v1); //System.Console.WriteLine("Creation vol SQ333"); //Vol v2 = new Vol //{ // CIE = 1, // DES = "CDG", // DHC = Convert.ToDateTime("14/01/2020 18:20"), // IMM = "TG43", // LIG = "333", // PKG = "R51", // PAX = 423 //}; //db.Add(v2); System.Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { CLASSE = "Y", CODE_IATA = "012387364501", DATA_CREATION = Convert.ToDateTime("14/01/2020 12:52"), DESTINATION = "BEG", VolID = 1 }; db.Add(b1); db.SaveChanges(); System.Console.ReadLine(); System.Console.WriteLine("Voici la liste des bagages disponibles"); var bags = db.Bagage .OrderBy(b => b.CODE_IATA); foreach (var b in bags) { System.Console.WriteLine($"Le bagage {b.DATA_CREATION} heure"); } System.Console.ReadLine(); // Read System.Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vol .OrderBy(v => v.CIE); foreach (var v in vol) { System.Console.WriteLine($"Le vol {v.DHC} ");//{v.CIE}{v.LIG} N° {v.VolID} a destination de {v.DES} part à {v.DHC} heure"); } System.Console.ReadLine(); //// Update //System.Console.WriteLine($"Le bagage {b1.BagageID} est modifié pour être rattaché au vol {v1.VolID} => {v1.CIE}{v1.LIG}"); //b1.VolID = v1.VolID; //db.SaveChanges(); //System.Console.ReadLine(); //// Delete vol et bagages du vol //System.Console.WriteLine($"Suppression du vol {v1.VolID} => {v1.CIE}{v1.LIG}"); //db.Remove(v1); //db.SaveChanges(); //System.Console.ReadLine(); } }
static void Main(string[] args) { System.Console.WriteLine("MyAirport project bonjour!!"); var optionsBuilder = new DbContextOptionsBuilder <MyAirportContext>(); //optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=Airport;Integrated Security=True"); optionsBuilder.UseLoggerFactory(MyAirportLoggerFactory); using (var db = new MyAirportContext(optionsBuilder.Options)) { // Create Console.WriteLine("Création du vol LH1232"); Vol v1 = new Vol { CIE = @"LH", DES = @"BKK", DHC = Convert.ToDateTime("14/01/2020 16:45"), IMM = "RZ62", LIG = "1232", PKG = "R52", PAX = 238 }; db.Add(v1); Console.WriteLine("Creation vol SQ333"); Vol v2 = new Vol { CIE = "SK", DES = "CDG", DHC = Convert.ToDateTime("14/01/2020 18:20"), IMM = "TG43", LIG = "333", PKG = "R51", PAX = 423 }; db.Add(v2); db.SaveChanges(); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { //VolID = v2.VolId, Classe = "Y", CodeIata = "012387364501", DateCreation = Convert.ToDateTime("14/01/2020 12:52"), Destination = "BEG" }; db.Add(b1); db.SaveChanges(); Console.ReadLine(); // Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols .OrderBy(v => v.CIE); foreach (var v in vol) { Console.WriteLine($"Le vol {v.CIE}{v.LIG} N° {v.VolId} a destination de {v.DES} part à {v.DHC} heure"); } Console.ReadLine(); // Update //Console.WriteLine($"Le bagage {b1.BagageID} est modifié pour être rattaché au vol {v1.VolId} => {v1.CIE}{v1.LIG}"); Console.WriteLine($"Le bagage {b1.BagageID} est modifié pour être rattaché au vol {v2.VolId} => {v2.CIE}{v2.LIG}"); b1.VolID = v2.VolId; db.SaveChanges(); Console.ReadLine(); // Delete vol et bagages du vol Console.WriteLine($"Suppression du vol {v1.VolId} => {v1.CIE}{v1.LIG}"); db.Remove(v1); db.SaveChanges(); Console.ReadLine(); } }
static void Main(string[] args) { var optionsBuilder = new DbContextOptionsBuilder <AirportContext>(); optionsBuilder.UseLoggerFactory(MyLoggerFactory); optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["AirportDB"].ConnectionString); using (var db = new AirportContext(optionsBuilder.Options)) { //CREATE var vol = new Vol { CIE = "vol", LIG = "air" }; db.Vols.Add(vol); db.SaveChanges(); // Read var vol1 = db.Vols .First(); var baggage = new Bagage { ID_VOL = vol1.ID_VOL, CODE_IATA = "QSDSQD", DATE_CREATION = new DateTime(2012, 12, 25, 10, 30, 50) }; db.Bagages.Add(baggage); db.SaveChanges(); var baggage2 = new Bagage { ID_VOL = vol1.ID_VOL, CODE_IATA = "FDSFZ", DATE_CREATION = new DateTime(2012, 12, 25, 10, 30, 50) }; db.Bagages.Add(baggage2); db.SaveChanges(); // Read var bag = db.Bagages .First(); // Update bag.CODE_IATA = "FSDFA"; bag.SSUR = "SDFDSS"; db.SaveChanges(); // Delete db.Remove(bag); // Read var voll = db.Vols .First(); Console.WriteLine(voll.Bagages.Count); db.SaveChanges(); } }
/// <summary> /// Called when the counter registers a bagage /// </summary> /// <param name="bagage"></param> /// <param name="desk"></param> static void CounterMessage(Bagage bagage, CounterDesk desk) { CentralManager.Instance.FileLogger.Append($"[{bagage.Brand}] [{DateTime.Now}] [{desk.GateId}] Checked In\n"); }
static void Main(string[] args) { Console.WriteLine("Hello World!"); DbContextOptionsBuilder optionsBuilder = new DbContextOptionsBuilder <MyAirportContext>(); optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["MyAirport"].ConnectionString); optionsBuilder.UseLoggerFactory(MyAirportLoggerFactory); DbContextOptions <MyAirportContext> dbContextOptions = (DbContextOptions <MyAirportContext>)optionsBuilder.Options; using (var db = new MyAirportContext(dbContextOptions)) { // Create Console.WriteLine("Création du vol TUNISIE123"); Vol v1 = new Vol() { CIE = "TUNISIE", DES = "PARIS", DHC = Convert.ToDateTime("14/01/2020 16:45"), IMM = "RZ62", LIG = "123", PKG = "R52", PAX = 238 }; db.Vols.Add(v1); db.SaveChanges(); Console.WriteLine(v1.CIE); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { //VOLID = 14, CLASSE = "Y", CODE_IATA = "012387364501", DATA_CREATION = Convert.ToDateTime("14/01/2020 12:52"), DESTINATION = "BEG" }; db.Bagages.Add(b1); db.SaveChanges(); Console.ReadLine(); // Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols .OrderBy(v => v.CIE); foreach (var v in vol) { Console.WriteLine($"Le vol {v.CIE}{v.LIG} N° {v.VOLID} a destination de {v.DES} part à {v.DHC} heure"); } Console.ReadLine(); // Update // b1.CODE_IATA = "TREZA"; //b1.SSUR = "AZE"; Console.WriteLine($"Le bagage {b1.BAGAGEID} est modifié pour être rattaché au vol {v1.VOLID} => {v1.CIE}{v1.LIG}"); b1.VOLID = v1.VOLID; db.SaveChanges(); // Delete vol et bagages du vol Console.WriteLine($"Suppression du vol {v1.VOLID} => {v1.CIE}{v1.LIG}"); db.Remove(v1); db.SaveChanges(); Console.ReadLine(); } }
/// <summary> /// Called when a bagage is about to be sorted /// </summary> /// <param name="bagage"></param> static void SortingIngoingMessage(Bagage bagage) { CentralManager.Instance.FileLogger.Append($"[{bagage.Brand}] [{DateTime.Now}] about to be sorted\n"); }
static void Main(string[] args) { var logger = MyAirportContext.loggerFactory.CreateLogger <Program>(); System.Console.WriteLine("MyAirport project bonjour!!"); using (var db = new MyAirportContext()) { // Create Console.WriteLine("Création du vol LH1232"); Vol v1 = new Vol { Cie = "LH", Destination = "BKK", Dhc = Convert.ToDateTime("14/01/2020 16:45"), Immatriculation = "RZ62", Lig = "1232", Parking = "R52", NbPassagers = 238 }; db.Add(v1); Console.WriteLine("Creation vol SQ333"); Vol v2 = new Vol { Cie = "SK", Destination = "CDG", Dhc = Convert.ToDateTime("14/01/2020 18:20"), Immatriculation = "TG43", Lig = "333", Parking = "R51", NbPassagers = 423 }; db.Add(v2); Console.WriteLine("creation du bagage 012387364501"); Bagage b1 = new Bagage { Classe = "Y", CodeIata = "012387364501", DateCreation = DateTime.Now, Destination = "BEG", Escale = "Paris", SSUR = "SSUR", Sta = "Sta", Prioritaire = 1 }; db.Add(b1); db.SaveChanges(); Console.ReadLine(); logger.LogInformation("Example log message create"); //Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols .OrderBy(v => v.Cie); foreach (var v in vol) { Console.WriteLine($"Le vol {v.Cie}{v.Lig} N° {v.VolId} a destination de {v.Destination} part à {v.Dhc} heure"); } Console.ReadLine(); //Update Console.WriteLine($"Le bagage {b1.BagageId} est modifié pour être rattaché au "); b1.VolId = v1.VolId; db.SaveChanges(); Console.ReadLine(); //Delete vol et bagages du vol Console.WriteLine($"Suppression du vol {v1.VolId} => {v1.Cie}{v1.Lig}"); db.Remove(v1); db.SaveChanges(); Console.ReadLine(); } }
static void Main(string[] args) { var optionsBuilder = new DbContextOptionsBuilder <MyAirportContext>(); optionsBuilder.UseLoggerFactory(MyLoggerFactory); optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["Airport"].ConnectionString); using (var db = new MyAirportContext(optionsBuilder.Options)) // using (var db = new MyAirportContext()) { // Create Console.WriteLine("Création du vol LH1232"); /*Vol v1 = new Vol * { * Cie = "LH", * Des = "BKK", * Dhc = Convert.ToDateTime("14/01/2020 16:45"), * Imm = "RZ62", * Lig = "1232", * Pkg = "R52", * Pax = 238 * };*/ Vol v1 = new Vol("LH", "1232", DateTime.Now) { Des = "BKK" }; db.Add(v1); Console.WriteLine("creation du bagage 012387364501"); /*Bagage b1 = new Bagage * { * Classe = "Y", * CodeIata = "012387364501", * DateCreation = Convert.ToDateTime("14/01/2020 12:52"), * Destination = "BEG" * }; */ Bagage b1 = new Bagage("012387364501", DateTime.Now) { Destination = "BKK" }; db.Add(b1); db.SaveChanges(); Console.ReadLine(); // Read Console.WriteLine("Voici la liste des vols disponibles"); var vol = db.Vols .OrderBy(v => v.Cie); foreach (var v in vol) { Console.WriteLine($"Le vol {v.Cie}{v.Lig} N° {v.VolId} a destination de {v.Des} part à {v.Dhc} heure"); } Console.ReadLine(); // Update Console.WriteLine($"Le bagage {b1.BagageId} est modifié pour être rattaché au vol {v1.VolId} => {v1.Cie}{v1.Lig}"); //b1.VolId = v1.VolId; db.SaveChanges(); Console.ReadLine(); // Delete vol et bagages du vol Console.WriteLine($"Suppression du vol {v1.VolId} => {v1.Cie}{v1.Lig}"); db.Remove(v1); db.SaveChanges(); Console.ReadLine(); } Console.WriteLine("Hello World!"); }