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();
}
}
