Exemplo n.º 1
0
 public DatabaseStoresRepo(ConsidDBContext storesDbContext)
 {
     _storesDbContext = storesDbContext;
 }
Exemplo n.º 2
0
        internal static void Initialize(ConsidDBContext considDBContext)
        {
            considDBContext.Database.Migrate();

            if (considDBContext.Companies.Any())
            {
                return;
            }
            else
            {
                Companies companyOne = new Companies()
                {
                    Name = "Consid",
                    OrganizationNumber = 1000000000,
                    Notes = null
                };

                Companies companyTwo = new Companies()
                {
                    Name = "Ikea",
                    OrganizationNumber = 2000000000,
                    Notes = null
                };

                considDBContext.Companies.Add(companyOne);
                considDBContext.SaveChanges();

                considDBContext.Companies.Add(companyTwo);
                considDBContext.SaveChanges();

                if (considDBContext.Stores.Any())
                {
                    return;
                }
                else
                {
                    Companies firstCompany = considDBContext.Companies.FirstAsync(n => n.Name == companyOne.Name).Result;

                    Companies secondCompany = considDBContext.Companies.FirstAsync(n => n.Name == companyTwo.Name).Result;

                    Stores storeOne = new Stores()
                    {
                        CompanyId = firstCompany.Id,
                        Name      = "Consid Ljungby",
                        Address   = "Stationsgatan 2",
                        City      = "Ljungby",
                        Zip       = "34160",
                        Country   = "Sweden",
                        Longitude = "13.9333705",
                        Latitude  = "56.8322943"
                    };

                    considDBContext.Stores.Add(storeOne);
                    considDBContext.SaveChanges();

                    Stores storeTwo = new Stores()
                    {
                        CompanyId = secondCompany.Id,
                        Name      = "Ikea Älmhult",
                        Address   = "Handelsvägen 4",
                        City      = "Älmhult",
                        Zip       = "34333",
                        Country   = "Sweden",
                        Longitude = "14.1627694",
                        Latitude  = "56.5501213"
                    };

                    considDBContext.Stores.Add(storeTwo);
                    considDBContext.SaveChanges();
                }
            }
        }
Exemplo n.º 3
0
 public DatabaseCompaniesRepo(ConsidDBContext companiesDbContext)
 {
     _companiesDbContext = companiesDbContext;
 }