public InspectionFileViewModel()
{
using(DatabaseContext databaseContext = new DatabaseContext())
{
IEnumerable<InspectionFileVM> inspectionFiles = databaseContext.InspectionFiles.ToList().Select(inspectionFile => new InspectionFileVM(inspectionFile));
InspectionFiles = new ObservableCollection<InspectionFileVM>(inspectionFiles);
IEnumerable<AccountVM> inspectors = databaseContext.Accounts.ToList().Select(inspector => new AccountVM(inspector));
Inspectors = new ObservableCollection<AccountVM>(inspectors);
IEnumerable<RepresenterVM> representers = databaseContext.Representers.ToList().Select(representer => new RepresenterVM(representer));
Representers = new ObservableCollection<RepresenterVM>(representers);
IEnumerable<TaskVM> tasks = databaseContext.Tasks.ToList().Select(task => new TaskVM(task));
Tasks = new ObservableCollection<TaskVM>(tasks);
IEnumerable<string> questionLists = databaseContext.QuestionLists.ToList().Select(questionList => questionList.Id.ToString());
QuestionLists = new ObservableCollection<string>(questionLists);
IEnumerable<InspectionTypeVM> inspectionTypes = databaseContext.InspectionTypes.ToList().Select(inspectionType => new InspectionTypeVM(inspectionType));
InspectionTypes = new ObservableCollection<InspectionTypeVM>(inspectionTypes);
// Select the first inspection file from the observable collection. Nothing found, a new instance will be created
SelectedInspectionFile = InspectionFiles.FirstOrDefault() != null ? InspectionFiles.FirstOrDefault() : new InspectionFileVM();
IEnumerable<TaskVM> inspectionFileTasks = SelectedInspectionFile.Tasks.Select(task => new TaskVM(task));
InspectionFileTasks = new ObservableCollection<TaskVM>(inspectionFileTasks);
IEnumerable<QuestionListVM> inspectionFileQuestionLists = SelectedInspectionFile.QuestionLists.Select(questionList => new QuestionListVM(questionList));
InspectionFileQuestionLists = new ObservableCollection<QuestionListVM>(inspectionFileQuestionLists);
}
}
public LoginWindowViewModel()
{
_databaseContext = new DatabaseContext();
IEnumerable<AccountVM> accounts = _databaseContext.Accounts.ToList().Select(account => new AccountVM(account));
Accounts = new ObservableCollection<AccountVM>(accounts);
DoLogIn = new RelayCommand(LogIn, CanLogIn);
}
public CreateCustomerViewModel()
{
using (DatabaseContext databaseContext = new DatabaseContext())
{
IEnumerable<RegionVM> regions = databaseContext.Regions.ToList().Select(Regio => new RegionVM(Regio));
Regions = new ObservableCollection<RegionVM>(regions);
}
}
public QuestionListTemplateAddWindowViewModel()
{
_databaseContext = new DatabaseContext();
IEnumerable<InspectionTypeVM> inspectionTypes = _databaseContext.InspectionTypes.ToList().Select(inspectiontype => new InspectionTypeVM(inspectiontype));
InspectionTypes = new ObservableCollection<InspectionTypeVM>(inspectionTypes);
DoAddTemplateToDB = new RelayCommand(AddTemplateToDB, CanAddTemplateToDb);
}
public QuestionListViewModel()
{
_databaseContext = new DatabaseContext();
IEnumerable<QuestionListVM> questionlists = _databaseContext.QuestionLists.ToList().Select(questionList => new QuestionListVM(questionList));
QuestionLists = new ObservableCollection<QuestionListVM>(questionlists);
IEnumerable<QuestionVM> questions = _databaseContext.Questions.ToList().Select(question => new QuestionVM(question));
Questions = new ObservableCollection<QuestionVM>(questions);
}
public QuestionListAddViewModel()
{
_databaseContext = new DatabaseContext();
IEnumerable<QuestionTypeVM> questionTypes = _databaseContext.QuestionTypes.ToList().Select(questionType => new QuestionTypeVM(questionType));
IEnumerable<QuestionVM> questions = _databaseContext.Questions.ToList().Select(question => new QuestionVM(question));
QuestionTypes = new ObservableCollection<QuestionTypeVM>(questionTypes);
Questions = new ObservableCollection<QuestionVM>(questions);
DoaddQuestion = new RelayCommand(addQuestion);
}
public InspectedOrganisationViewModel()
{
_myContext = new DatabaseContext();
IEnumerable<InspectedOrganisationVM> organisations = _myContext.InspectedOrganisations.ToList().Select(InspectedOrganisation => new InspectedOrganisationVM(InspectedOrganisation));
InspectedOrganisations = new ObservableCollection<InspectedOrganisationVM>(organisations);
SelectedOrganisations = new List<InspectedOrganisationVM>();
Addresses = new ObservableCollection<AddressVM>();
RemoveInspectedOrganisations = new RelayCommand(RemoveSelectedOrganisation, CanRemoveSelectedOrganisation);
RemoveAddresses = new RelayCommand(RemoveSelectedAddress, CanRemoveSelectedAddress);
}
public MainViewModel()
{
_myContext = new DatabaseContext();
IEnumerable<InspectedOrganisationVM> inspectedOrganisations = _myContext.InspectedOrganisations.ToList().Select(inspectedOrganisation => new InspectedOrganisationVM(inspectedOrganisation));
InspectedOrganisations = new ObservableCollection<InspectedOrganisationVM>(inspectedOrganisations);
IEnumerable<InspectionTypeVM> inspectionTypes = _myContext.InspectionTypes.ToList().Select(inspectionType => new InspectionTypeVM(inspectionType));
InspectionTypes = new ObservableCollection<InspectionTypeVM>(inspectionTypes);
IEnumerable<RegionVM> regions = _myContext.Regions.ToList().Select(region => new RegionVM(region));
Regions = new ObservableCollection<RegionVM>(regions);
}
public UserAccountOverViewWindowViewModel()
{
_myContext = new DatabaseContext();
IEnumerable<AccountVM> accounts = _myContext.Accounts.ToList().Select(account => new AccountVM(account));
Accounts = new ObservableCollection<AccountVM>(accounts);
FirstDetails = new ObservableCollection<AccountVM>();
EditAccount = new RelayCommand(EditSelectedAccount, CanEdit);
RemoveAccount = new RelayCommand(RemoveSelectedAccount, CanRemove);
AddUser = new RelayCommand(AddNewUser);
RemoveAccountByDetails = new RelayCommand(RemoveSelectedAccountByDetails, CanRemoveByDetails);
}
public CustomerLinkRepresenterViewModel()
{
using (DatabaseContext databaseContext = new DatabaseContext())
{
IEnumerable<RepresenterVM> allRepresenters = databaseContext.Representers
.ToList()
.Select((cr) => new RepresenterVM(cr));
AllRepresenters = new ObservableCollection<RepresenterVM>(allRepresenters);
// Just get the ones we need from the fetched list of all representers
IEnumerable<RepresenterVM> customerRepresenters = AllRepresenters.Where((r) => r.Customers.Any((c) => c.Id.Equals(CustomerVM.Id)));
CustomerRepresenters = new ObservableCollection<RepresenterVM>(customerRepresenters);
}
}
private void AddTemplateToDB()
{
using (DatabaseContext databaseContext = new DatabaseContext())
{
QuestionListTemplateVM q = new QuestionListTemplateVM();
q.toQuestionListTemplate().InspectionTypeId = SelectedInspectionType.Id;
databaseContext.QuestionListTemplates.Add(q.toQuestionListTemplate());
databaseContext.SaveChanges();
MessageBox.Show("Template toegevoegd!", "Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
CloseWindow();
return;
}
}
public QuestionListTemplatesViewModel()
{
_databaseContext = new DatabaseContext();
IEnumerable<QuestionListTemplate> questionListTemplates = _databaseContext.QuestionListTemplates.ToList();
IEnumerable<QuestionListTemplateVM> questionListTemplatesVM = questionListTemplates.Select(questionListTemplate => new QuestionListTemplateVM(questionListTemplate));
IEnumerable<InspectionTypeVM> inspectionTypes = _databaseContext.InspectionTypes.ToList().Select(inspectionType => new InspectionTypeVM(inspectionType));
QuestionListTemplates = new ObservableCollection<QuestionListTemplateVM>(questionListTemplatesVM);
InspectionTypes = new ObservableCollection<InspectionTypeVM>(inspectionTypes);
DoAddTemplate = new RelayCommand(AddTemplate);
foreach (QuestionListTemplate questionListTemplate in questionListTemplates)
{
_databaseContext.Entry(questionListTemplate).Reference(qLT => qLT.InspectionType).Load();
}
}
public CustomerViewModel()
{
using (DatabaseContext databaseContext = new DatabaseContext())
{
IEnumerable<Customer> customers = databaseContext.Customers.ToList();
IEnumerable<CustomerVM> customersVM = customers.Select(c => new CustomerVM(c));
Customers = new ObservableCollection<CustomerVM>(customersVM);
IEnumerable<RegionVM> regionsVM = databaseContext.Regions.ToList().Select(c => new RegionVM(c));
Regions = new ObservableCollection<RegionVM>(regionsVM);
foreach (Customer customer in customers)
{
databaseContext.Entry(customer).Reference(c => c.Region).Load();
}
}
}
public StatisticsViewModel()
{
_myContext = new DatabaseContext();
string[] months = { "Januari", "Februari", "Maart", "April", "Mei", "Juni", "Juli","Augustus","September","Oktober","November","December" };
Months = new ObservableCollection<string>(months);
List<int> yearValues = new List<int>();
for (int i = DateTime.UtcNow.Year; i > 1949; i--)
{
yearValues.Add(i);
}
Years = new ObservableCollection<int>(yearValues);
IEnumerable<RegionVM> regions = _myContext.Regions.ToList().Select(region => new RegionVM(region));
Regions = new ObservableCollection<RegionVM>(regions);
IEnumerable<InspectionTypeVM> inspectionTypes = _myContext.InspectionTypes.ToList().Select(inspectionType => new InspectionTypeVM(inspectionType));
InspectionTypes = new ObservableCollection<InspectionTypeVM>(inspectionTypes);
}
public void SaveInspectionFile()
{
using (DatabaseContext databaseContext = new DatabaseContext())
{
SelectedInspectionFile.Account = SelectedInspector.ToAccount;
SelectedInspectionFile.InspectionType = SelectedInspectionType.ToInspectionType;
SelectedInspectionFile.Representer = SelectedRepresenter.Representer;
databaseContext.InspectionFiles.Add(SelectedInspectionFile.ToInspectionFile);
databaseContext.SaveChanges();
}
}
public void Add()
{
using (DatabaseContext databaseContext = new DatabaseContext())
{
databaseContext.InspectionFiles.Add(SelectedInspectionFile.ToInspectionFile);
databaseContext.SaveChanges();
InspectionFiles.Add(SelectedInspectionFile);
}
}
private void AddTemplate()
{
QuestionListTemplateVM qlt = new QuestionListTemplateVM();
QuestionListTemplates.Add(qlt);
using (DatabaseContext dbc = new DatabaseContext())
{
dbc.QuestionListTemplates.Add(qlt.toQuestionListTemplate());
dbc.SaveChanges();
}
}