private void Loadtraveler(Traveler T) { using (var sql = new SampleTravelersContext()) { var usersList = sql.Users.Where(x => x.Id == T.OwnerId); if (usersList.Any()) { this.Owner = usersList.First(); this.StartDate = T.StartDate; } else { this.Owner = User.GetCurrentUser(); this.StartDate = DateTime.Now; } var questionsQry = sql.travelers.Where(x => x.Id == T.Id); if (questionsQry.Any()) { this.Questions = new ObservableCollection <Question>(questionsQry.First().Questions); } else { this.Questions = new ObservableCollection <Question>(); } this.Product = T.Product; this.Description = T.Description; this.Name = T.Name; this.workingtraveler = T; Messenger.Default.Send <RequestClosetravelersDialog>(new RequestClosetravelersDialog()); } }
private void ReloadAllQuestions() { using (var sql = new SampleTravelersContext()) { this.AllQuestions = new ObservableCollection <Question>(sql.Questions); } }
private void ExecuteSaveCurrentQuestion() { using (var sql = new SampleTravelersContext()) { var p = new Question(); if (sql.Questions.Any(x => x.Name == Name)) { p = sql.Questions.Where(x => x.Name == this.Name).First(); } else { sql.Questions.Add(p); } foreach (var item in PrerequisiteQuestions) { var i = sql.Questions.Where(x => x.Id == item.Id).First(); p.AddPrerequisite(i); } foreach (var item in CorequisiteQuestions) { p.Corequisites.Add(sql.Questions.Where(x => x.Id == item.Id).First()); } foreach (var item in PostrequisiteQuestions) { var i = sql.Questions.Where(x => x.Id == item.Id).First(); p.AddPostrequisite(i); } p.Name = this.Name; p.Request = this.Request; p.RequiresResponse = this.IsRequired; p.Template = this.IsTemplate; p.Type = (int)this.CurrentResponseType; p.Team = (int)this.CurrentTeam; p.HelpText = this.HelpText; //p.HelpImage = this.HelpImage; var saved = true; try { sql.SaveChanges(); } catch (DbEntityValidationException e) { saved = false; System.Windows.MessageBox.Show(SampleTravelersContext.AlertUserErrors(e)); } finally { if (saved) { OnSuccessfulSave(this, null); } } } }
private void ExecuteDeleteSelectedQuestion() { using (var sql = new SampleTravelersContext()) { ExecuteCreateNewQuestion(); var s = sql.Questions.Where(x => x.Id == SelectedQuestion.Id).First(); sql.Questions.Remove(s); sql.SaveChanges(); AllQuestions = new ObservableCollection <Question>(sql.Questions); } }
private void LoadAllQuestions() { using (var sql = new SampleTravelersContext()) { var t = sql.Questions .ToList(); AllQuestions = new ObservableCollection <Question>(t); AllQuestions.CollectionChanged += AllQuestions_CollectionChanged; allQuestionsCollection = new List <Question>(t); } ReloadAllQuestions(); }
private void ExecuteDeleteSelectedTraveler() { using (var sql = new SampleTravelersContext()) { var p = sql.travelers.Where(x => x.Id == SelectedTraveler.Id); if (p.Any()) { ExecuteCreateNewTraveler(); sql.travelers.Remove(p.First()); AllTravelers.Remove(AllTravelers.Where(x => x.Id == p.First().Id).First()); sql.SaveChanges(); } } SelectedTraveler = null; Messenger.Default.Send <RequestCloseDeleteTravelerDialog>(new RequestCloseDeleteTravelerDialog()); }
private void ExecuteCopySelectedTraveler() { using (var sql = new SampleTravelersContext()) { Messenger.Default.Send <RequestCloseCopyTravelerDialog>(new RequestCloseCopyTravelerDialog()); var p = sql.travelers.Where(x => x.Id == SelectedTraveler.Id); if (p.Any()) { var T = p.First(); sql.travelers.Add(T); sql.SaveChanges(); } AllTravelers = new ObservableCollection <Traveler>(sql.travelers.ToList()); } }
private void ExecuteCopySelectedQuestion() { using (var sql = new SampleTravelersContext()) { var p = sql.Questions.Where(x => x.Id == SelectedQuestion.Id); if (p.Any()) { var Q = p.First(); sql.Questions.Add(Q); sql.SaveChanges(); } AllQuestions = new ObservableCollection <Question>(sql.Questions); ExecuteOpenSelectedQuestion(); } }
private void ExecuteSaveCurrentTraveler() { using (var sql = new SampleTravelersContext()) { var travelersQry = sql.travelers.Where(x => x.Id == this.workingtraveler.Id); if (travelersQry.Any()) { this.workingtraveler = travelersQry.First(); } else { sql.travelers.Add(workingtraveler); } foreach (var item in questions) { this.workingtraveler.Questions.Add(sql.Questions.Where(x => x.Id == item.Id).First()); } this.workingtraveler.User = sql.Users.Where(x => x.Id == this.Owner.Id).First(); this.workingtraveler.StartDate = this.StartDate; this.workingtraveler.Name = this.Name; this.workingtraveler.Product = this.Product; this.workingtraveler.Description = this.Description; var saved = true; try { sql.SaveChanges(); } catch (DbEntityValidationException e) { saved = false; System.Windows.MessageBox.Show(SampleTravelersContext.AlertUserErrors(e)); } finally { if (saved) { System.Windows.MessageBox.Show("Successfully Saved traveler."); } } } }
protected override void Seed(NWCSampleManager.SampleTravelersContext context) { using (var sql = new SampleTravelersContext()) { if (!sql.Questions.ToList().Any()) { sql.Questions.Add(new Question() { Name = "Full Basic Workup", Request = "Note the type of machine used to produce the cores from Core Box #1", RequiresResponse = true, Team = (int)Team.Administrator, Type = (int)ResponseType.TextInput, HelpText = "N/A", Template = true }); sql.Questions.Add(new Question() { Name = "Core Box #1 Machine Type", Request = "Note the type of machine used to produce the cores from Core Box #1", RequiresResponse = true, Team = (int)Team.CoreDepartment, Type = (int)ResponseType.TextInput, HelpText = "N/A", }); sql.Questions.Add(new Question() { Name = "Produce 1A Cores", Request = "Produce the required number of 1A cores from Core Box #1. Note the number produced.", RequiresResponse = true, Team = (int)Team.CoreDepartment, Type = (int)ResponseType.RealNumber, HelpText = "N/A" }); sql.Questions.Add(new Question() { Name = "1A Core Weight", Request = "During production, weigh the 1A core and record that weight here.", RequiresResponse = true, Team = (int)Team.CoreDepartment, Type = (int)ResponseType.RealNumber, HelpText = "N/A" }); sql.Questions.Add(new Question() { Name = "1A Core Photo Prep", Request = "Set aside a 1A core and contact the quality department to get a photo of the core for the Process Card. Note if this was completed.", RequiresResponse = true, Team = (int)Team.CoreDepartment, Type = (int)ResponseType.YesNo, HelpText = "N/A" }); sql.Questions.Add(new Question() { Name = "1A Core Photo", Request = "Take a Photo of the 1A Core and upload that photo here.", RequiresResponse = true, Team = (int)Team.QualityEngineering, Type = (int)ResponseType.FileUpload, HelpText = "N/A" }); sql.Questions.Add(new Question() { Name = "Cope Photo", Request = "Take a Photo of the pattern Cope and upload that file here.", RequiresResponse = true, Team = (int)Team.MoldDepartment, Type = (int)ResponseType.FileUpload, HelpText = "N/A" }); sql.Questions.Add(new Question() { Name = "Drag Photo", Request = "Take a Photo of the pattern Drag and upload that file here.", RequiresResponse = true, Team = (int)Team.MoldDepartment, Type = (int)ResponseType.FileUpload, HelpText = "N/A" }); sql.Questions.Add(new Question() { Name = "Pour Weight", Request = "Blast a complete set of gating. Weigh the gating and all casting impressions (unground castings). Record the weight.", RequiresResponse = true, Team = (int)Team.CleanDepartment, Type = (int)ResponseType.RealNumber, HelpText = "N/A" }); sql.Questions.Add(new Question() { Name = "Pour Weight Photo", Request = "Take a Photo of the gating system and castings weighed, and upload photo here.", RequiresResponse = true, Team = (int)Team.CleanDepartment, Type = (int)ResponseType.FileUpload, HelpText = "N/A" }); sql.Questions.Add(new Question() { Name = "Cast Weight", Request = "Grind 5 castings or one of each cavity, whichever is greater. Weigh each of those castings on the small scale and average those weights and record here.", RequiresResponse = true, Team = (int)Team.CleanDepartment, Type = (int)ResponseType.RealNumber, HelpText = "N/A" }); } sql.SaveChanges(); var q = sql.Questions.Where(x => x.Name == "Full Basic Workup").First(); sql.Questions.Where(x => x.Id != q.Id).ToList().ForEach(x => q.Corequisites.Add(x)); var r = sql.Questions.Where(x => x.Name == "Pour Weight").First(); r.AddPrerequisite(sql.Questions.Where(x => x.Name == "Cope Photo").First()); r.AddPrerequisite(sql.Questions.Where(x => x.Name == "Drag Photo").First()); r.AddPostrequisite(sql.Questions.Where(x => x.Name == "Pour Weight Photo").First()); var s = sql.Questions.Where(x => x.Name == "1A Core Photo Prep").First(); s.AddPostrequisite(sql.Questions.Where(x => x.Name == "1A Core Photo").First()); var n = new User(); n.TeamAffiliations.Add(new TeamAffiliation() { Team = (int)Team.Administrator }); n.First = "Adam"; n.Last = "Hoover"; n.Email = "*****@*****.**"; var t = new User(); t.TeamAffiliations.Add(new TeamAffiliation() { Team = (int)Team.Administrator }); t.First = "Tim"; t.Last = "Davis"; t.Email = "*****@*****.**"; t.WindowsName = @"GREDEW2K\tdavis"; var u = new User(); u.TeamAffiliations.Add(new TeamAffiliation() { Team = (int)Team.Administrator }); u.First = "John"; u.Last = "Mahaffey"; u.Email = "*****@*****.**"; u.WindowsName = @"GREDEW2K\jmahaffey"; if (!sql.Users.Any(x => x.Email == n.Email)) { sql.Users.Add(n); } if (!sql.Users.Any(x => x.Email == t.Email)) { sql.Users.Add(t); } if (!sql.Users.Any(x => x.Email == u.Email)) { sql.Users.Add(u); } sql.SaveChanges(); } }