private void MakeJsonSjabloon(object obj)
        {
            //Console.WriteLine(SelectedSuplier.Name);

            ProductQuotation tmpQuotation = new ProductQuotation()
            {
                EAN_Product   = "",
                ProductTitle  = "",
                ExtraInfo     = "",
                DateQuatation = DateTime.Now,
            };

            string json = JsonConvert.SerializeObject(tmpQuotation, Formatting.Indented);

            string path         = PATH_SJABLONS + "/";
            string bestandsnaam = string.Format("{0:yy-MM-dd_HH-mm-ss}", DateTime.Now) + "_" + SelectedSuplier.Id.ToString("D4") + ".json";

            try
            {
                File.WriteAllText(path + bestandsnaam, json);
            }
            catch (Exception ex)
            {
                MessageBox.Show("er is een fout opgetreden bij schrijven van het bestand\n" +
                                "raadpleeg de leverancier als deze fout zich blijft voordoen\n\n" +
                                ex.Message);
                return;
            }

            if (MessageBoxResult.Yes ==
                MessageBox.Show("sjabloon met succes aangemaakt, wil je de de map openen?", "ok", MessageBoxButton.YesNo, MessageBoxImage.Question))
            {
                Process.Start(Directory.GetCurrentDirectory() + "/" + PATH_SJABLONS);
            }
        }
Example #2
0
        public IActionResult Post([FromBody] ProductQuotation productQuotation)
        {
            _repository.Add(productQuotation);
            _repository.SaveAll();

            return(Ok());
        }
Example #3
0
        public void Put(Guid id, [FromBody] ProductQuotation value)
        {
            ProductQuotation productQuotation = _repository.Find(id);

            if (productQuotation != null)
            {
                productQuotation.Copy(value);
                _repository.Update(productQuotation);
                _repository.SaveAll();
            }
        }
 public EditionQuotation(ProductQuotation productQuotation, int copyCount)
 {
     ProductQuotation   = productQuotation;
     CopyCount          = copyCount;
     PlateCost          = new QuantityCost();
     StartupCost        = new QuantityCost();
     PrintCost          = new QuantityCost();
     InkCost            = new QuantityCost();
     PaperCost          = new QuantityCost();
     PlasticizationCost = new ExplicitCost();
     UVPaintingCost     = new ExplicitCost();
     CreasingDieCost    = new ExplicitCost();
     ConfTaglioCost     = new ExplicitCost();
     ConfPMCost         = new ExplicitCost();
     ConfBrossuraCost   = new ExplicitCost();
     TransportCost      = new ExplicitCost();
     PackagingCost      = new ExplicitCost();
     VariousCost        = new ExplicitCost();
 }
 public EditionQuotation(ProductQuotation productQuotation, int copyCount)
 {
     ProductQuotation = productQuotation;
     CopyCount = copyCount;
     PlateCost = new QuantityCost();
     StartupCost = new QuantityCost();
     PrintCost = new QuantityCost();
     InkCost = new QuantityCost();
     PaperCost = new QuantityCost();
     PlasticizationCost = new ExplicitCost();
     UVPaintingCost = new ExplicitCost();
     CreasingDieCost = new ExplicitCost();
     ConfTaglioCost = new ExplicitCost();
     ConfPMCost = new ExplicitCost();
     ConfBrossuraCost = new ExplicitCost();
     TransportCost = new ExplicitCost();
     PackagingCost = new ExplicitCost();
     VariousCost = new ExplicitCost();
 }
        private void LoadPendingJsonFiles()
        {
            List <string> EANs = new List <string>();

            ObservableCollection <ProductQuotation> terug = new ObservableCollection <ProductQuotation>();

            foreach (string bestandsnaam in Directory.EnumerateFiles(Directory.GetCurrentDirectory() + "/" + PATH_PENDING, "*.json"))
            {
                //string contents = File.ReadAllText(file);
                //Console.WriteLine("\n------------------" + bestandsnaam);
                ProductQuotation discoveredJson = JsonConvert.DeserializeObject <ProductQuotation>(File.ReadAllText(bestandsnaam));

                //string bestandsnaamZonderExtentie = Path.GetFileName(bestandsnaam);
                string bestandsnaamZonderExtentie = Path.GetFileNameWithoutExtension(bestandsnaam);
                int    idLeverancier = Convert.ToInt32(bestandsnaamZonderExtentie.Split('_')[2].Substring(0, 4));
                //Console.WriteLine("11111111111111111     " + idLeverancier);

                //string json = JsonConvert.SerializeObject(discoveredJson, Formatting.Indented);

                //Console.WriteLine(json);

                discoveredJson.Supplier     = SuppliersAll.FirstOrDefault(X => X.Id == idLeverancier);
                discoveredJson.bestandsPath = bestandsnaam;

                terug.Add(discoveredJson);
                EANs.Add(discoveredJson.EAN_Product);
            }

            EANs = EANs.Distinct().ToList();
            EANs = _appDbRespository.Product.GetExistingEANsFromEanList(EANs);

            this.ExistingEANsInDB = EANs;


            QuatationsAll = terug;
            //return terug;
        }
Example #7
0
        public static void LoadTestData(AppRepository <KfsContext> appRespository)
        {
            //als deze gebruiker bestaat, returnen, data moet niet opnieuw opgeslagen worden
            EmployeeRepository.EmployeeLoggedInDTO tmpTest = appRespository.Employee.LogIn("Tom_0123", "Tom_0123");
            if (tmpTest != null)
            {
                return;
            }



            #region =============================== MIN APPLICATIE VEREISTE ====================================


            #region ------------------------------------------- Add Departments------------------------------

            EmpDepartment newDep_admin = new EmpDepartment()
            {
                DefaultPermissions = 0b0111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111,
                DescriptionNL      = "Administrator",
                DescriptionEN      = "Administrator"
            };
            appRespository.EmpDepartment.Add(newDep_admin);

            EmpDepartment newDep_Sales = new EmpDepartment()
            {
                DefaultPermissions = 0b0000_0000_0000_0000_0000_0000_0000_0000_0000_0000_0000_1111_1111_1111_1111_1111,
                DescriptionEN      = "Sales",
                DescriptionNL      = "Verkoop"
            };
            appRespository.EmpDepartment.Add(newDep_Sales);


            EmpDepartment newDep_Warehouse = new EmpDepartment()
            {
                DefaultPermissions = 0b0000_0000_0000_0000_1111_1111_1111_1111_1111_1111_0000_0000_0000_0000_0000_0000,
                DescriptionEN      = "Ware House",
                DescriptionNL      = "Magazijn"
            };
            appRespository.EmpDepartment.Add(newDep_Warehouse);

            #endregion --------------------------------------------------------------------------------------


            #region ------------------------------------------- Add Contract types---------------------------
            EmpContractType newContrType_onbDuur = new EmpContractType()
            {
                DescriptionEN = "Indefinitely",
                DescriptionNL = "Onbepaalde duur"
            };
            appRespository.EmpContractType.Add(newContrType_onbDuur);

            EmpContractType newContrType_jobstudent = new EmpContractType()
            {
                DescriptionEN = "Student job",
                DescriptionNL = "Jobstudent"
            };
            appRespository.EmpContractType.Add(newContrType_jobstudent);

            EmpContractType newContrType_interim = new EmpContractType()
            {
                DescriptionEN = "Interim",
                DescriptionNL = "Interim"
            };
            appRespository.EmpContractType.Add(newContrType_interim);

            #endregion --------------------------------------------------------------------------------------


            #region ------------------------------------------- Add EmpContractStatuutType-------------------
            EmpContractStatuutType empContrStatuutType_arbeider = new EmpContractStatuutType
            {
                DescriptionEN = "Worker",
                DescriptionNL = "Arbeider"
            };
            appRespository.EmpContractStatuutType.Add(empContrStatuutType_arbeider);

            EmpContractStatuutType empContrStatuutType_bediende = new EmpContractStatuutType
            {
                DescriptionEN = "Servant",
                DescriptionNL = "Bediende"
            };
            appRespository.EmpContractStatuutType.Add(empContrStatuutType_bediende);

            EmpContractStatuutType empContrStatuutType_Ambtenaar = new EmpContractStatuutType
            {
                DescriptionEN = "Civil servant",
                DescriptionNL = "Ambtenaar"
            };
            appRespository.EmpContractStatuutType.Add(empContrStatuutType_Ambtenaar);


            #endregion --------------------------------------------------------------------------------------



            #region ------------------------------------------- Add ProductType------------------------------
            ProductType productType_Dranken = new ProductType()
            {
                DescriptionNL = "Dranken",
                DescriptionEN = "Drinks"
            };
            appRespository.ProductType.Add(productType_Dranken);
            ProductType productType_Speelgoed = new ProductType()
            {
                DescriptionNL = "Speelgoed",
                DescriptionEN = "Toys"
            };
            appRespository.ProductType.Add(productType_Speelgoed);
            ProductType productType_Voedingswaren = new ProductType()
            {
                DescriptionNL = "Voedingswaren",
                DescriptionEN = "Foodstuffs"
            };
            appRespository.ProductType.Add(productType_Voedingswaren);
            ProductType productType_AutoOnderdelen = new ProductType()
            {
                DescriptionNL = "Auto onderdelen",
                DescriptionEN = "Car parts"
            };
            appRespository.ProductType.Add(productType_AutoOnderdelen);
            #endregion --------------------------------------------------------------------------------------



            #region employee_TomDilen amdin met alle rechten

            Employee employee_TomDilen = new Employee()
            {
                //-------------------personMin---------
                FirstName = "Tom",
                //NameAddition = "niet vereist",
                LastName     = "Dilen",
                Email        = "*****@*****.**",
                MobileNumber = "0123 11 22 33",
                //PhoneNumber = "niet vereist",

                //navprops


                //-------------------Person------------
                DateOfBirth = new DateTime(1981, 04, 22),
                IsMale      = true,
                //nav props
                EmpAddress = new EmpAddress()
                {
                    Street      = "Duivenstraat",
                    HouseNumber = 55,
                    //HouseNumberAddition = "nvt",
                    Zipcode = "2300",
                    City    = "Turnhout",
                    Country = "Belgium"
                },

                //-------------------Employee----------
                PassPortID = "0122222111",
                IBAN       = "12220132145545",
                JobInfo    = "waarken lak een biest",
                ExtraInfo  = "zag er ne toffe gast uit bij de sollicitatie",

                //navProps
                //id voor departement is genoeg :-)
                Id_EmpDepartment = 1, //1=Administrator, 2=Verkoop, 3=Magazijn

                EmpContract = new EmpContract()
                {
                    MonthSalary = 2222.22f,
                    DateOfStart = new DateTime(2020, 12, 2),
                    Id_EmpContractStatuutType = 1, // 1=Arbeider, 2=Bediende, 3=Ambtenaar
                    Id_EmpContractType        = 1  // 1=Onbepaalde duur, 2=Jobstudent, 3=Interim
                },

                EmpAppAccount = new EmpAppAccount
                {
                    //AppPermissions = 0b0100_0000_0000_0000_0000_0000_0000_0000_0000_0000_0000_1111_1111_1111_1111_1111,
                    AppPermissions    = 0b0111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111_1111,
                    Password          = "******",
                    UserName          = "******",
                    IsPaswordResseted = true,
                    LastResetted      = DateTime.Now,
                    IsBlocked         = false,
                    InlogAttempts     = 0,
                }
            };
            appRespository.Employee.Add(employee_TomDilen);



            //inloggen
            EmployeeRepository.EmployeeLoggedInDTO IngelogdGebruiker = appRespository.Employee.LogIn("Tom_0123", "Tom_0123");
            if (IngelogdGebruiker == null)
            {
                System.Windows.Forms.MessageBox.Show("null");
            }
            else
            {
                System.Windows.Forms.MessageBox.Show("joepi, ingelogd");
            }

            #endregion


            #endregion ==================================================================================================



            #region ------------------------------------------- Add Employees  ------------------------------



            #region employee_MaggieDeBlock

            Employee employee_MaggieDeBlock = new Employee()
            {
                //-------------------personMin---------
                FirstName    = "Maggie",
                NameAddition = "De",
                LastName     = "Block",
                Email        = "*****@*****.**",
                MobileNumber = "0123 45 67 89",
                PhoneNumber  = "23 23 23 23 23",

                //navprops


                //-------------------Person------------
                DateOfBirth = new DateTime(1981, 04, 22),
                IsMale      = true,
                //nav props
                EmpAddress = new EmpAddress()
                {
                    Street      = "vetstraat",
                    HouseNumber = 55,
                    //HouseNumberAddition = "nvt",
                    Zipcode = "1000",
                    City    = "Brussel",
                    Country = "Belgium"
                },

                //-------------------Employee----------
                PassPortID = "01222244444",
                IBAN       = "12220132148888",
                JobInfo    = "mondmaskers verbranden",
                ExtraInfo  = "toffe griet yoh",

                //navProps
                //id voor departement is genoeg :-)
                Id_EmpDepartment = 3,     //1=Administrator, 2=Verkoop, 3=Magazijn

                EmpContract = new EmpContract()
                {
                    MonthSalary = 1400.22f,
                    DateOfStart = new DateTime(1950, 11, 22),
                    Id_EmpContractStatuutType = 2, // 1=Arbeider, 2=Bediende, 3=Ambtenaar
                    Id_EmpContractType        = 2  // 1=Onbepaalde duur, 2=Jobstudent, 3=Interim
                },

                //EmpAppAccount = new EmpAppAccount
                //{
                //    AppPermissions = Int64.MaxValue,
                //    Password = "******",
                //    UserName = "******",
                //    IsPaswordResseted = true,
                //    LastResetted = DateTime.Now,
                //    IsBlocked = false,
                //    InlogAttempts = 0,
                //}
            };
            appRespository.Employee.Add(employee_MaggieDeBlock);

            #endregion


            #region employee_AlexanderDeCroo

            Employee employee_AlexanderDeCroo = new Employee()
            {
                //-------------------personMin---------
                FirstName    = "Alexander",
                NameAddition = "De",
                LastName     = "Kraai",
                Email        = "*****@*****.**",
                MobileNumber = "0123 45 67 40",
                PhoneNumber  = "23 23 23 23 98",

                //navprops


                //-------------------Person------------
                DateOfBirth = new DateTime(1982, 04, 1),
                IsMale      = true,
                //nav props
                EmpAddress = new EmpAddress()
                {
                    Street      = "wetstraat",
                    HouseNumber = 55,
                    //HouseNumberAddition = "nvt",
                    Zipcode = "1040",
                    City    = "Vettigem",
                    Country = "Duitsland"
                },

                //-------------------Employee----------
                PassPortID = "5555555555",
                IBAN       = "121212121212",
                JobInfo    = "Graaien in de vetpot",
                ExtraInfo  = "nen echte fille de papa",

                //navProps
                //id voor departement is genoeg :-)
                Id_EmpDepartment = 2,     //1=Administrator, 2=Verkoop, 3=Magazijn

                EmpContract = new EmpContract()
                {
                    MonthSalary = 1200.22f,
                    DateOfStart = new DateTime(1970, 11, 22),
                    Id_EmpContractStatuutType = 3, // 1=Arbeider, 2=Bediende, 3=Ambtenaar
                    Id_EmpContractType        = 3  // 1=Onbepaalde duur, 2=Jobstudent, 3=Interim
                },

                EmpAppAccount = new EmpAppAccount
                {
                    AppPermissions    = Int64.MaxValue,
                    Password          = "******",
                    UserName          = "******",
                    IsPaswordResseted = true,
                    LastResetted      = DateTime.Now,
                    IsBlocked         = false,
                    InlogAttempts     = 0,
                }
            };
            appRespository.Employee.Add(employee_AlexanderDeCroo);

            #endregion



            #endregion --------------------------------------------------------------------------------------



            #region ------------------------------------------- Add Suppliers--------------------------------
            Supplier supPConderdelen = new Supplier()
            {
                CmpManagers = new List <CmpManager>()
                {
                    new CmpManager()
                    {
                        FirstName = "TomsupPConderdelen",
                        //NameAddition = "van",
                        LastName     = "ManagersupPConderdelen",
                        Email        = "*****@*****.**",
                        MobileNumber = "0114",
                        PhoneNumber  = "222222244522"
                    }
                },

                CompanyNumber = "551555555",
                Name          = "supPConderdelen Turnhout",
                Website       = "supPConderdelenTurnhout.be",
                BtwNumber     = "BE 4555555",
                Email         = "*****@*****.**",
                ExtraInfo     = "dit is extrainfo over supPConderdelen turnhout",



                CmpIBANs = new List <CmpIBAN>()
                {
                    new CmpIBAN {
                        Number = "222-22222-22-222", IsDefault = true
                    }
                },
                CmpSites = new List <CmpSite>()
                {
                    new CmpSite()
                    {
                        IsDefault      = true,
                        CmpSiteAddress = new CmpSiteAddress()
                        {
                            Street              = "gasthuissstraat",
                            HouseNumber         = 55,
                            HouseNumberAddition = "22",
                            Country             = "Belgie",
                            Zipcode             = "2000",
                            City = "Antwerpen"
                        },
                        Fax                   = "222222222",
                        PhoneNumber           = "012345678",
                        PhoneNumber_2         = "555220",
                        MobileNumber          = "014556699",
                        Email                 = "*****@*****.**",
                        ExtraInfo             = "extra info over hoofdsite van supPConderdelen Turnhout",
                        CmpSiteContactPersons = new List <CmpSiteContactPerson>()
                        {
                            new CmpSiteContactPerson()
                            {
                                FirstName = "TomsupPConderdelenContact",
                                //NameAddition = "van",
                                LastName     = "DilenContact",
                                Email        = "*****@*****.**",
                                MobileNumber = "0111111111121",
                                PhoneNumber  = "2222222222",

                                IsDefault = true,
                                ExtraInfo = "geen extra info over dez contactpersoon van supPConderdelen"
                            }
                        },
                    },
                },
            };
            appRespository.Supplier.Add(supPConderdelen);



            Supplier supCocaCola = new Supplier()
            {
                CmpManagers = new List <CmpManager>()
                {
                    new CmpManager()
                    {
                        FirstName = "TomCocaCola",
                        //NameAddition = "van",
                        LastName     = "DilenManager",
                        Email        = "*****@*****.**",
                        MobileNumber = "011111111111",
                        PhoneNumber  = "222222222"
                    }
                },

                CompanyNumber = "55555555",
                Name          = "Cocacola Turnhout",
                Website       = "CocColaTurnhout.be",
                BtwNumber     = "BE 444444444",
                Email         = "*****@*****.**",
                ExtraInfo     = "dit is extrainfo over coca cola turnhout",



                CmpIBANs = new List <CmpIBAN>()
                {
                    new CmpIBAN {
                        Number = "222-22222-22-222", IsDefault = true
                    }
                },
                CmpSites = new List <CmpSite>()
                {
                    new CmpSite()
                    {
                        IsDefault      = true,
                        CmpSiteAddress = new CmpSiteAddress()
                        {
                            Street              = "druivenstraat",
                            HouseNumber         = 55,
                            HouseNumberAddition = "22",
                            Country             = "Belgie",
                            Zipcode             = "2300",
                            City = "Turnhout"
                        },
                        Fax                   = "1111111111",
                        PhoneNumber           = "4444444444",
                        PhoneNumber_2         = "2222222222",
                        MobileNumber          = "55555555",
                        Email                 = "*****@*****.**",
                        ExtraInfo             = "extra info over hoofdsite van cococola Turnhout",
                        CmpSiteContactPersons = new List <CmpSiteContactPerson>()
                        {
                            new CmpSiteContactPerson()
                            {
                                FirstName = "TomCocaColaContact",
                                //NameAddition = "van",
                                LastName     = "DilenContact",
                                Email        = "*****@*****.**",
                                MobileNumber = "011111111111",
                                PhoneNumber  = "222222222",

                                IsDefault = true,
                                ExtraInfo = "geen extra info over dez contactpersoon"
                            }
                        },
                    },
                },
            };
            appRespository.Supplier.Add(supCocaCola);


            //========================================================================================

            Supplier supKenField = new Supplier()
            {
                CmpManagers = new List <CmpManager>()
                {
                    new CmpManager()
                    {
                        FirstName = "Ken",
                        //NameAddition = "van",
                        LastName     = "Field",
                        Email        = "*****@*****.**",
                        MobileNumber = "0478670924",
                        //PhoneNumber = "222222244522"
                    }
                },

                CompanyNumber = "000111222",
                Name          = "KenFieldSupplier",
                Website       = "KenFieldSupplier.be",
                BtwNumber     = "BE 4555588",
                Email         = "*****@*****.**",
                ExtraInfo     = "Teacher .Net developper at Multimedi",



                CmpIBANs = new List <CmpIBAN>()
                {
                    new CmpIBAN {
                        Number = "2222222222", IsDefault = true
                    }
                },
                CmpSites = new List <CmpSite>()
                {
                    new CmpSite()
                    {
                        IsDefault      = true,
                        CmpSiteAddress = new CmpSiteAddress()
                        {
                            Street      = "Avenue de Kenfield",
                            HouseNumber = 55,
                            //HouseNumberAddition = "22",
                            Country = "KenLand",
                            Zipcode = "9999",
                            City    = "Fieldegem"
                        },
                        Fax         = "222222222",
                        PhoneNumber = "0478670924",
                    },
                },
            };
            appRespository.Supplier.Add(supKenField);


            #endregion --------------------------------------------------------------------------------------



            #region ------------------------------------------- Add Clients ---------------------------------

            Client client_TimAudenaarde = new Client
            {
                IsActive          = true,
                CltWebCredentials = new CltWebCredentials()
                {
                    Password          = "******",
                    UserName          = "******",
                    InlogAttempts     = 0,
                    IsBlocked         = false,
                    IsPaswordResseted = false,
                    LastResetted      = DateTime.Now,
                },
                FirstName = "Tim",
                //NameAddition ,

                LastName     = "Audenaarde",
                Email        = "*****@*****.**",
                MobileNumber = "0123456",
                PhoneNumber  = "",
                DateOfBirth  = new DateTime(1980, 04, 01),
                IsMale       = true,

                CltAddresss = new List <CltAddress>()
                {
                    new CltAddress()
                    {
                        Street              = "TimseSteenweg",
                        HouseNumber         = 33,
                        HouseNumberAddition = "b3",
                        Country             = "Belgie",
                        Zipcode             = "1000",
                        City = "Bornem"
                    }
                },
            };
            appRespository.Client.Add(client_TimAudenaarde);


            //==================================================================================


            Client client_KennyBruwier = new Client
            {
                IsActive          = true,
                CltWebCredentials = new CltWebCredentials()
                {
                    Password          = "******",
                    UserName          = "******",
                    InlogAttempts     = 0,
                    IsBlocked         = false,
                    IsPaswordResseted = false,
                    LastResetted      = DateTime.Now,
                },
                FirstName = "Kenny",
                //NameAddition ,

                LastName     = "Bruwier",
                Email        = "kweetnognie",
                MobileNumber = "2222222",
                PhoneNumber  = "014555555",
                DateOfBirth  = new DateTime(1975, 04, 01),
                IsMale       = true,

                CltAddresss = new List <CltAddress>()
                {
                    new CltAddress()
                    {
                        Street      = "Avenue le Kennedy",
                        HouseNumber = 66,
                        //HouseNumberAddition = "b3",
                        Country = "Belgie",
                        Zipcode = "1000",
                        City    = "RupelMonde"
                    }
                },
            };
            appRespository.Client.Add(client_KennyBruwier);



            #endregion --------------------------------------------------------------------------------------



            #region ------------------------------------------- Add Products---------------------------------
            Product product_Spaghetti = new Product()
            {
                //---------   id = EAN (geen oplopend nummer)
                EAN = "1111111111",

                ProductTitle = "Spaghetti Bolognaise",
                //ExtraInfo = "",

                SellingPriceRecommended = 5.22f,
                CountInStock            = 0,
                MinCountInStock         = 100,
                MaxCountInStock         = 500,
                WareHouseLocation       = "H44,01",
                BTWpercentage           = 6,
                Id_ProductType          = 2, //producType 1=Speelgoed, 2=Voedingswaren 3=Autoonderdelen
                //Image
            };
            appRespository.Product.Add(product_Spaghetti);


            Product product_Ballenbad = new Product()
            {
                //---------   id = EAN (geen oplopend nummer)
                EAN = "222222222",

                ProductTitle = "Ballen bad",
                //ExtraInfo = "",

                SellingPriceRecommended = 105.22f,
                CountInStock            = 0,
                MinCountInStock         = 5,
                MaxCountInStock         = 10,
                WareHouseLocation       = "H44,02",
                BTWpercentage           = 21,
                Id_ProductType          = 1, //producType 1=Speelgoed, 2=Voedingswaren 3=Autoonderdelen
                //Image
            };
            appRespository.Product.Add(product_Ballenbad);


            Product product_DoosLego = new Product()
            {
                //---------   id = EAN (geen oplopend nummer)
                EAN = "33333333",

                ProductTitle = "Lego StormMinds",
                //ExtraInfo = "",

                SellingPriceRecommended = 205.22f,
                CountInStock            = 0,
                MinCountInStock         = 6,
                MaxCountInStock         = 20,
                WareHouseLocation       = "H20,01",
                BTWpercentage           = 21,
                Id_ProductType          = 1, //producType 1=Speelgoed, 2=Voedingswaren 3=Autoonderdelen
                //Image
                Supplier_Product_Prices = new List <Supplier_Product_Price>()
                {
                    new Supplier_Product_Price()
                    {
                        UnitPrice   = 44.44f,
                        Id_Supplier = 1,
                        EAN_Product = "222222222"
                    }
                }
            };
            appRespository.Product.Add(product_DoosLego);


            Product product_NummerPlatenAuto = new Product()
            {
                //---------   id = EAN (geen oplopend nummer)
                EAN = "444444444",

                ProductTitle = "Nummerplaat",
                //ExtraInfo = "",

                SellingPriceRecommended = 15.99f,
                CountInStock            = 0,
                MinCountInStock         = 20,
                MaxCountInStock         = 80,
                WareHouseLocation       = "H47,02",
                BTWpercentage           = 21,
                Id_ProductType          = 3, //producType 1=Speelgoed, 2=Voedingswaren 3=Autoonderdelen
                //Image
            };
            appRespository.Product.Add(product_NummerPlatenAuto);


            #endregion --------------------------------------------------------------------------------------



            #region ------------------------------------------- Add OrdersIn --------------------------------

            OrderIn bestellengOut_1 = new OrderIn()
            {
                Id_OrderedBy = 1,
                Id_Supplier  = 1,
                OrderedAt    = DateTime.Now,
                OrderLineIns = new List <OrderLineIn>()
                {
                    new OrderLineIn()
                    {
                        EAN_Product = "222222222", UnitPrice = 22.2f, NumberOfProducts = 5
                    },
                    new OrderLineIn()
                    {
                        EAN_Product = "444444444", UnitPrice = 33.2f, NumberOfProducts = 5
                    }
                }
            };
            appRespository.OrderIn.Add(bestellengOut_1);
            #endregion --------------------------------------------------------------------------------------



            #region ------------------------------------------- Add OrdersOut--------------------------------
            OrderOut bestelling_In1 = new OrderOut()
            {
                Id_Client     = 1,
                OrderLineOuts = new List <OrderLineOut>()
                {
                    new OrderLineOut()
                    {
                        EAN_Product = "222222222", UnitPrice = 22.33f, NumberOfProducts = 4
                    },
                    new OrderLineOut()
                    {
                        EAN_Product = "444444444", UnitPrice = 22.33f, NumberOfProducts = 4
                    }
                }
            };
            appRespository.OrderOut.Add(bestelling_In1);


            #endregion --------------------------------------------------------------------------------------



            #region ------------------------------------------- Add Quatations-------------------------------
            ProductQuotation quotation1 = new ProductQuotation()
            {
                UnitPrice     = 10.20f,
                DateQuatation = DateTime.Now,
                ExtraInfo     = "goei materiaal",
                EAN_Product   = "8888888",
                Id_Supplier   = 1
            };
            appRespository.ProductQuotation.Add(quotation1);

            //ProductQuotation quotation2 = new ProductQuotation()
            //{
            //    UnitPrice = 10.20f,
            //    DateQuatation = DateTime.Now,
            //    //DateRegistered =
            //    ExtraInfo = "",
            //    Id_Product = 2

            //};
            //appRespository.ProductQuotation.Add(quotation2);

            #endregion --------------------------------------------------------------------------------------



            #region ------------------------------------------- Add Departments------------------------------
            #endregion --------------------------------------------------------------------------------------
            #region ------------------------------------------- Add Departments------------------------------
            #endregion --------------------------------------------------------------------------------------
            #region ------------------------------------------- Add Departments------------------------------
            #endregion --------------------------------------------------------------------------------------
            #region ------------------------------------------- Add Departments------------------------------
            #endregion --------------------------------------------------------------------------------------
            #region ------------------------------------------- Add Departments------------------------------
            #endregion --------------------------------------------------------------------------------------
            #region ------------------------------------------- Add Departments------------------------------
            #endregion --------------------------------------------------------------------------------------
            #region ------------------------------------------- Add Departments------------------------------
            #endregion --------------------------------------------------------------------------------------


            //}
            //catch (Exception ex)
            //{
            //    System.Windows.Forms.MessageBox.Show(ex.Message);
            //}
        }
    }
}