public ActionResult Create([Bind(Include = "Id,Name,Level,Code,Descriptin,ParentId")] Machine machine) { if (ModelState.IsValid) { db.Machines.Add(machine); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ParentId = new SelectList(db.Machines, "Id", "Name", machine.ParentId); return(View(machine)); }
public void PostDernierChoix(Choix_utilisateurs dernierChoix) { var result = _machineContext.Choix_utilisateurs.Where(u => u.Num_Badge == dernierChoix.Num_Badge); if (result != null) { _machineContext.Remove(result.FirstOrDefault()); _machineContext.SaveChanges(); } _machineContext.Add(dernierChoix); _machineContext.SaveChanges(); }
public ActionResult EditMachine(MachineViewModel machineViewModel) { using (var machineContext = new MachineContext()) { var machine = machineContext.Machines.SingleOrDefault(m => m.MachineId == machineViewModel.MachineId); if (machine != null) { machine.MachineNum = machineViewModel.MachineNum.Value; machine.MachineMake = machineViewModel.MachineMake; machine.MachineModel = machineViewModel.MachineModel; machine.TypeId = machineViewModel.TypeId; machine.Hours = machineViewModel.Hours.Value; machine.Notes = machineViewModel.Notes; machine.Status = machineViewModel.Status; machine.Photo = machineViewModel.Photo; machineContext.SaveChanges(); return(RedirectToAction("Index")); } return(new HttpNotFoundResult()); } }
static void SeedOperatingSystemTable() { using (var context = new MachineContext()) { var os = new OperatingSys { Name = "Windows XP", StillSupported = false }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows 7", StillSupported = true }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows 8", StillSupported = false }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows 8.1", StillSupported = true }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows 10", StillSupported = true }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows Server 2000", StillSupported = false }; context.OperatingSys.Add(os); //os = new OperatingSys { Name = "Windows Server 2003 R2", StillSupported = false }; //context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows Server 2008", StillSupported = true }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows Server 2008 R2", StillSupported = true }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows Server 2012", StillSupported = true }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows Server 2012 R2", StillSupported = true }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Windows Server 2016", StillSupported = true }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Ubuntu Server 16.14.2 LTS", StillSupported = true }; context.OperatingSys.Add(os); os = new OperatingSys { Name = "Ubuntu Server 17.04", StillSupported = true }; context.OperatingSys.Add(os); context.SaveChanges(); } }
private void CloseTicket(int ticketId) { Console.WriteLine("Closing ticket..."); using (MachineContext context = new MachineContext()) { SupportTicket sTicket = context.SupportTicket.Where(x => x.SupportTicketId == ticketId).FirstOrDefault(); sTicket.DateResolved = DateTime.Now; context.Update(sTicket); context.SaveChanges(); Console.WriteLine("Ticket is closed"); } }
static void DeleteAllUnsupportedOperatingSystems() { using (var context = new MachineContext()) { var os = (from o in context.OperatingSys where o.StillSupported == false select o); Console.WriteLine("\r\nDeleting all Unsupported Operating Systems..."); context.OperatingSys.RemoveRange(os); int i = context.SaveChanges(); Console.WriteLine($"We have deleted {i} records"); Console.WriteLine("Hit any key to continue..."); Console.ReadKey(); } }
private void UpdateMachine() { try { var toUpdate = db.Machines.Where(m => m.Id == SelectedMachine.Id).Single(); if (toUpdate == null) { InfoText = "Entry not found!"; return; } toUpdate.Name = SelectedMachine.Name; toUpdate.Description = SelectedMachine.Description; db.SaveChanges(); ResetFields(); } catch (Exception) { InfoText = "Entry not found!"; return; } }
public ActionResult DeleteMachine(MachineViewModel machineViewModel) { using (var machineContext = new MachineContext()) { var machine = machineContext.Machines.SingleOrDefault(p => p.Id == machineViewModel.Id); if (machine != null) { machineContext.Machines.Remove(machine); machineContext.SaveChanges(); return(RedirectToAction("Index")); } } return(new HttpNotFoundResult()); }
static void DeleteOperatingSystem(int id) { OperatingSys os = GetOperatingSystemById(id); if (os != null) { Console.WriteLine($"\r\nAre you sure you want to delete {os.Name}? [y or n]"); Console.ForegroundColor = ConsoleColor.White; ConsoleKeyInfo cki; string result; bool cont; do { cki = Console.ReadKey(true); result = cki.KeyChar.ToString(); cont = ValidateYorN(result); } while (!cont); if ("y" == result.ToLower()) { Console.WriteLine("\r\nDeleting record"); Console.ForegroundColor = ConsoleColor.White; using (var context = new MachineContext()) { context.Remove(os); context.SaveChanges(); } Console.WriteLine("Record Deleted"); Console.ForegroundColor = ConsoleColor.White; Console.ReadKey(); } else { Console.WriteLine("Delete Aborted\r\nHit any key to continue..."); Console.ForegroundColor = ConsoleColor.White; Console.ReadKey(); } } else { Console.WriteLine("\r\nOperating System Not Found!"); Console.ForegroundColor = ConsoleColor.White; Console.ReadKey(); SelectOperatingSystem("Delete"); } }
public ActionResult AddMachine(MachineViewModel machineViewModel) { using (var machineContext = new MachineContext()) { var machine = new Machine { Num = machineViewModel.Num, Make = machineViewModel.Make, Model = machineViewModel.Model, Hours = machineViewModel.Hours }; machineContext.Machines.Add(machine); machineContext.SaveChanges(); } return(RedirectToAction("Index")); }
public bool CreateComment(Comment comment) { ModelInput input = new ModelInput() { SentimentText = comment.Text }; var result = ConsumeModel.Predict(input); bool sentimentresult = result.Prediction == "1" ? true : false; comment.Toxic = sentimentresult; comment.PostedDate = DateTime.Now; _context.Comments.Add(comment); _context.SaveChanges(); return(sentimentresult); }
public ActionResult AddMachine(MachineViewModel machineViewModel) { using (var machineContext = new MachineContext()) { var machine = new Mach { MachineNum = machineViewModel.MachineNum.Value, MachineMake = machineViewModel.MachineMake, MachineModel = machineViewModel.MachineModel, TypeId = machineViewModel.TypeId, Hours = machineViewModel.Hours.Value, Notes = machineViewModel.Notes, Status = machineViewModel.Status, Photo = machineViewModel.Photo }; machineContext.Machines.Add(machine); machineContext.SaveChanges(); } return(RedirectToAction("Index")); }
private void AddSupportLogEntry(string entry, bool close, int ticketId) { bool modelIsValid = false; ModelValidation mv = new ModelValidation(); Console.WriteLine("Saving new log entry"); using (MachineContext context = new MachineContext()) { SupportLog sLogEntry = new SupportLog() { SupportTicketId = ticketId, SupportLogEntry = entry, SupportLogUpdatedBy = Environment.UserName, SupportLogEntryDate = DateTime.Now //DateTime.Now.AddSeconds(-2000) }; modelIsValid = mv.ValidateSupportLog(sLogEntry, "save"); if (modelIsValid) { context.SupportLog.Add(sLogEntry); int res = context.SaveChanges(); Console.WriteLine($"{res} record saved"); } } if (modelIsValid) { if (close) { CloseTicket(ticketId); } } else { Console.WriteLine("There is a problem with your Entry"); foreach (var error in mv.errorList) { Console.WriteLine($"{error.FieldName} {error.Error}"); } } }
static void ModifyOperatingSystem(int id) { OperatingSys os = GetOperatingSystemById(id); Console.Clear(); char operation = '0'; bool cont = false; ConsoleKeyInfo cki; WriteHeader("Update Operating System"); if (os != null) { Console.WriteLine($"\r\nOS Name: {os.Name} Still Supported: {os.StillSupported}"); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine("To modify the name press 1\r\nTo modify if the OS is Still Supported press 2"); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine("Hit Esc to exit this menu"); Console.ForegroundColor = ConsoleColor.White; do { cki = Console.ReadKey(true); if (cki.Key == ConsoleKey.Escape) { cont = true; } else { if (char.IsNumber(cki.KeyChar)) { if (cki.KeyChar == '1') { Console.WriteLine("Updated Operating System Name: "); Console.ForegroundColor = ConsoleColor.White; operation = '1'; cont = true; } else if (cki.KeyChar == '2') { Console.WriteLine("Update if the OS is Still Supported [y or n]: "); Console.ForegroundColor = ConsoleColor.White; operation = '2'; cont = true; } } } } while (!cont); } if (operation == '1') { string osName; cont = false; do { osName = Console.ReadLine(); if (osName.Length >= 4) { cont = true; } else { Console.WriteLine("Please enter a vaild OS name of at least 4 characters.\r\nPress and key to continue..."); Console.ForegroundColor = ConsoleColor.White; Console.ReadKey(); } } while (!cont); os.Name = osName; } else if (operation == '2') { string k; do { cki = Console.ReadKey(true); k = cki.KeyChar.ToString(); cont = ValidateYorN(k); } while (!cont); if (k == "y") { os.StillSupported = true; } else { os.StillSupported = false; } } using (var context = new MachineContext()) { var o = context.OperatingSys.FirstOrDefault(i => i.OperatingSysId == os.OperatingSysId); if (o != null) { // just making sure o.Name = os.Name; o.StillSupported = os.StillSupported; Console.WriteLine("\r\nUpdating the database..."); Console.ForegroundColor = ConsoleColor.White; context.SaveChanges(); Console.WriteLine("Done!\r\nHit any key to continue..."); Console.ForegroundColor = ConsoleColor.White; } } Console.ReadKey(); }
static void AddOperatingSystem() { Console.Clear(); ConsoleKeyInfo cki; string result; bool cont = false; OperatingSys os = new OperatingSys(); string osName = ""; do { WriteHeader("Add New Operating System"); Console.WriteLine("Enter the Name of the Operating System and hit Enter"); Console.ForegroundColor = ConsoleColor.White; osName = Console.ReadLine(); if (osName.Length >= 4) { cont = true; } else { Console.WriteLine("Please enter a vaild OS name of at least 4 characters.\r\nPress and key to continue..."); Console.ForegroundColor = ConsoleColor.White; Console.ReadKey(); } } while (!cont); cont = false; os.Name = osName; Console.WriteLine("Is the Operating System still supported? [y or n]"); Console.ForegroundColor = ConsoleColor.White; do { cki = Console.ReadKey(); result = cki.KeyChar.ToString(); cont = ValidateYorN(result); } while (!cont); if (result.ToLower() == "y") { os.StillSupported = true; } else { os.StillSupported = false; } cont = false; do { Console.Clear(); Console.WriteLine($"You entered {os.Name} as the Operating System Name\r\nIs the OS still supported, you entered {os.StillSupported}.\r\nDo you wish to continue? [y or n]"); Console.ForegroundColor = ConsoleColor.White; cki = Console.ReadKey(); result = cki.KeyChar.ToString(); cont = ValidateYorN(result); } while (!cont); if (result.ToLower() == "y") { bool exists = CheckForExistingOS(os.Name); if (exists) { Console.WriteLine("\r\nOperating System already exists in the database\r\nPress any key to continue..."); Console.ForegroundColor = ConsoleColor.White; Console.ReadKey(); } else { using (var context = new MachineContext()) { Console.WriteLine("\r\nAttempting to save changes..."); Console.ForegroundColor = ConsoleColor.White; context.OperatingSys.Add(os); int i = context.SaveChanges(); if (i == 1) { Console.WriteLine("Contents Saved\r\nPress any key to continue..."); Console.ForegroundColor = ConsoleColor.White; Console.ReadKey(); } } } } }