public IActionResult AfterEdit(Visitor edited) { Visitor visitor = ( from v in _newContext.Visitors where v.RegistrationNumber == edited.RegistrationNumber select v ).SingleOrDefault(); visitor.Name = edited.Name; visitor.Last = edited.Last; visitor.Occupation = edited.Occupation; visitor.Company = edited.Company; _newContext.SaveChanges(); return(View("CheckInForm", visitor)); }
public RedirectToActionResult RemoveDuplicateStaff() { IEnumerable <StaffNames> Staff = _textFileOperations.RemoveDuplicateStaff(); _context.StaffNames.AddRange(Staff); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); }
public void UploadStaffFile() { //--------------Get the data from the Text file -------------- string[] lines = { }; //Gets or sets the absolute path to the directory that contains the web-servable application content files. string webRootPath = _environment.WebRootPath; FileInfo filePath = new FileInfo(Path.Combine(webRootPath, "Staff.txt")); lines = System.IO.File.ReadAllLines(filePath.ToString()); //holds all the staff names Dictionary <string, StaffNames> StaffnamesDict = new Dictionary <string, StaffNames>(); List <StaffNames> AllStaffNames = new List <StaffNames>(); foreach (var name in lines) { StaffNames staffnames = new StaffNames(); string[] data = name.Split(','); staffnames.Name = data[0]; staffnames.Department = data[1]; //if the name isn't there, add it in if (!StaffnamesDict.ContainsKey(staffnames.Name)) { StaffnamesDict.Add(staffnames.Name, staffnames); AllStaffNames.Add(staffnames); } } //--------------Get the data from the Database -------------- //add in the ones from the db AllStaffNames.AddRange(RemoveDuplicateStaff()); //sort the new data and pull out only uniques IOrderedEnumerable <StaffNames> orderedStaffNames = AllStaffNames.Distinct().OrderBy( i => i.Department).ThenBy(i => i.Name); _context.AddRange(orderedStaffNames); _context.SaveChanges(); }