public EngineersEditorViewModel()
{
db = new MGDBModelContainer();
db.EngineerSet.Load();
EngineersList = db.EngineerSet.Local;
AddEngineerCommand = new Command(OnAddEngineerCommandExecute);
EditEngineerCommand = new Command(OnEditEngineerCommandExecute);
ClearTextCommand = new Command(OnClearTextCommandExecute);
}
public RegistrationJournalViewModel()
{
db = new MGDBModelContainer();
CustomersList = db.CustomerSet.Select(x => x.Name).ToList();
db.ResearchSet.Load();
JournalData = db.ResearchSet.Local;
//JournalData = (ObservableCollection < Research > )db.ResearchSet.Select(x=> new { x.Number, x.Date, x.Customer, x.MVZ, x.Description, x.NumberOfSamples});
//using (MGDBModelContainer db = new MGDBModelContainer())
//{
//JournalData = new ObservableCollection<MainJournal>();
//foreach (var item in db.MainJournalSet.ToList())
//{
// JournalData.Add(item);
//}
//Engineer engineer = new Engineer();
//engineer.Name = "Ефременко А.В.";
//engineer.Password = "******";
//db.EngineerSet.Add(engineer);
//Customer customer = new Customer();
//customer.Name = "ТЛЦ";
//customer.MVZList.Add(new MVZ { Text = "000-0091" });
//customer.MVZList.Add(new MVZ { Text = "000-9091" });
//customer.MVZList.Add(new MVZ { Text = "009-9091" });
//db.CustomerSet.Add(customer);
//TypeOfResearch typeOfRes = new TypeOfResearch();
//typeOfRes.Type = "Поломки";
//db.TypeOfResearchSet.Add(typeOfRes);
//TypeOfResearch typeOfRes2 = new TypeOfResearch();
//typeOfRes2.Type = "Дефекты металлопродукции";
//db.TypeOfResearchSet.Add(typeOfRes2);
//db.SaveChanges();
//Research rec = new Research();
//rec.Date = DateTime.Now;
//rec.Number = "18-001";
//rec.Customer = db.CustomerSet.FirstOrDefault(x => x.Name == "ТЛЦ");
//rec.Engineer = db.EngineerSet.FirstOrDefault(x => x.Name == "Ефременко А.В.");
//rec.MVZ = db.MVZSet.FirstOrDefault(x => x.Text == "009-9091");
//rec.Type = db.TypeOfResearchSet.FirstOrDefault(x => x.Type == "Дефекты металлопродукции");
//rec.Description = "Металлографическое исследование пробы от листа";
//rec.Notation = "Проба от листа";
//rec.Status = StatusEnum.IsInWork;
//rec.FinishDate = DateTime.Now;
//ResearchData dataJ = new ResearchData();
//rec.ResearchData = dataJ;
//db.ResearchSet.Add(rec);
//db.SaveChanges();
//MainJournal rec1 = new MainJournal();
//rec1.
//JournalData = db.ResearchSet.Local;
//}
}
public CustomersEditorViewModel()
{
db = new MGDBModelContainer();
db.CustomerSet.Load();
db.MVZSet.Load();
CustomersList = db.CustomerSet.Local;
MVZList = new ObservableCollection <MVZ>();
AddMVZCommand = new Command(OnAddMVZCommandExecute);
EditMVZCommand = new Command(OnEditMVZCommandExecute);
AddCustomerCommand = new Command(OnAddCustomerCommandExecute);
EditCustomerCommand = new Command(OnEditCustomerCommandExecute);
}