public void CreateVehicleTypes(BusinessTripsContext context)
{
VehicleType motorcycle = new VehicleType()
{
Name = "Motocykl",
Rate = 0.2302m
};
VehicleType motorower = new VehicleType()
{
Name = "Motorower",
Rate = 0.1382m
};
VehicleType samDo900 = new VehicleType()
{
Name = "Samochód do 900 cm3",
Rate = 0.5214m
};
VehicleType samPow900 = new VehicleType()
{
Name = "Samochód pow. 900 cm3",
Rate = 0.8358m
};
context.VehicleTypes.AddOrUpdate(vt => vt.Name, motorcycle);
context.VehicleTypes.AddOrUpdate(vt => vt.Name, motorower);
context.VehicleTypes.AddOrUpdate(vt => vt.Name, samDo900);
context.VehicleTypes.AddOrUpdate(vt => vt.Name, samPow900);
}
public void SeedContext(BusinessTripsContext context)
{
CreateUsers(context);
CreateCountries(context);
CreateVehicleTypes(context);
CreateExpenseTypes(context);
CreateExpenseDocumentTypes(context);
}
public Repositories()
{
context = new BusinessTripsContext();
this.Users = new UsersRepository(context);
this.Dictionaries = new DictionariesRepository(context);
this.BusinessTrips = new BusinessTripsRepository(context);
this.Expenses = new ExpensesRepository(context);
this.Subsistences = new SubsistencesRepository(context);
this.SubsistenceDays = new SubsistenceDaysRespository(context);
this.MileageAllowances = new MileageAllowancesRepository(context);
this.Currencies = new CurrenciesRepository(context);
}
public void CreateExpenseDocumentTypes(BusinessTripsContext context)
{
ExpenseDocumentType type1 = new ExpenseDocumentType()
{
Id = 1,
Name = "Faktura"
};
ExpenseDocumentType type2 = new ExpenseDocumentType()
{
Id = 2,
Name = "Paragon"
};
ExpenseDocumentType type3 = new ExpenseDocumentType()
{
Id = 3,
Name = "Brak dok."
};
context.ExpenseDocumentTypes.AddOrUpdate(et => et.Name, type1);
context.ExpenseDocumentTypes.AddOrUpdate(et => et.Name, type2);
context.ExpenseDocumentTypes.AddOrUpdate(et => et.Name, type3);
}
public MileageAllowancesRepository(BusinessTripsContext _context)
{
this.context = _context;
}
public SubsistenceDaysRespository(BusinessTripsContext _context)
{
this.context = _context;
}
public SubsistencesRepository(BusinessTripsContext _context)
{
this.context = _context;
}
public CurrenciesRepository(BusinessTripsContext _context)
{
this.context = _context;
}
public ExpensesRepository(BusinessTripsContext _context)
{
this.context = _context;
}
public BusinessTripsRepository(BusinessTripsContext _context)
{
this.context = _context;
}
public void CreateUsers(BusinessTripsContext context)
{
//Roles
Role basicUser = new Role();
basicUser.Name = "BasicUser";
User maciej = new User()
{
UserName = "******",
Email = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = "AM+qVffwovJO6ncY4wFxZ12RBOlGQ23Z9yyNF95SI6Ij+cW7F0QzPI090Y6FYbimtQ==", //P@ssword1
SecurityStamp = "ef0ce398-45dd-41a7-ad99-0f39a28c0f32",
PhoneNumber = null,
PhoneNumberConfirmed = false,
TwoFactorEnabled = false,
LockoutEndDateUtc = null,
LockoutEnabled = false,
AccessFailedCount = 0
};
UserRole maciejBasic = new UserRole()
{
Role = basicUser, User = maciej
};
User karol = new User()
{
UserName = "******",
Email = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = "AM+qVffwovJO6ncY4wFxZ12RBOlGQ23Z9yyNF95SI6Ij+cW7F0QzPI090Y6FYbimtQ==", //P@ssword1
SecurityStamp = "ef0ce398-45dd-41a7-ad99-0f39a28c0f32",
PhoneNumber = null,
PhoneNumberConfirmed = false,
TwoFactorEnabled = false,
LockoutEndDateUtc = null,
LockoutEnabled = false,
AccessFailedCount = 0
};
UserRole karolBasic = new UserRole()
{
Role = basicUser, User = karol
};
User basia = new User()
{
UserName = "******",
Email = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = "AM+qVffwovJO6ncY4wFxZ12RBOlGQ23Z9yyNF95SI6Ij+cW7F0QzPI090Y6FYbimtQ==", //P@ssword1
SecurityStamp = "ef0ce398-45dd-41a7-ad99-0f39a28c0f32",
PhoneNumber = null,
PhoneNumberConfirmed = false,
TwoFactorEnabled = false,
LockoutEndDateUtc = null,
LockoutEnabled = false,
AccessFailedCount = 0
};
UserRole basiaBasic = new UserRole()
{
Role = basicUser, User = basia
};
maciej.Roles.Add(maciejBasic);
karol.Roles.Add(karolBasic);
basia.Roles.Add(basiaBasic);
context.Roles.AddOrUpdate(r => new { r.Name }, basicUser);
context.Users.AddOrUpdate(u => new { u.UserName }, maciej);
context.Users.AddOrUpdate(u => new { u.UserName }, karol);
context.Users.AddOrUpdate(u => new { u.UserName }, basia);
}
public void CreateVehicleTypes(BusinessTripsContext context)
{
VehicleType motorcycle = new VehicleType()
{
Name = "Motocykl",
Rate = 0.2302m
};
VehicleType motorower = new VehicleType()
{
Name = "Motorower",
Rate = 0.1382m
};
VehicleType samDo900 = new VehicleType()
{
Name = "Samochód do 900 cm3",
Rate = 0.5214m
};
VehicleType samPow900 = new VehicleType()
{
Name = "Samochód pow. 900 cm3",
Rate = 0.8358m
};
context.VehicleTypes.AddOrUpdate(vt => vt.Name, motorcycle);
context.VehicleTypes.AddOrUpdate(vt => vt.Name, motorower);
context.VehicleTypes.AddOrUpdate(vt => vt.Name, samDo900);
context.VehicleTypes.AddOrUpdate(vt => vt.Name, samPow900);
}
public void CreateUsers(BusinessTripsContext context)
{
//Roles
Role basicUser = new Role();
basicUser.Name = "BasicUser";
User maciej = new User()
{
UserName = "******",
Email = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = "AM+qVffwovJO6ncY4wFxZ12RBOlGQ23Z9yyNF95SI6Ij+cW7F0QzPI090Y6FYbimtQ==", //P@ssword1
SecurityStamp = "ef0ce398-45dd-41a7-ad99-0f39a28c0f32",
PhoneNumber = null,
PhoneNumberConfirmed = false,
TwoFactorEnabled = false,
LockoutEndDateUtc = null,
LockoutEnabled = false,
AccessFailedCount = 0
};
UserRole maciejBasic = new UserRole() { Role = basicUser, User = maciej };
User karol = new User()
{
UserName = "******",
Email = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = "AM+qVffwovJO6ncY4wFxZ12RBOlGQ23Z9yyNF95SI6Ij+cW7F0QzPI090Y6FYbimtQ==", //P@ssword1
SecurityStamp = "ef0ce398-45dd-41a7-ad99-0f39a28c0f32",
PhoneNumber = null,
PhoneNumberConfirmed = false,
TwoFactorEnabled = false,
LockoutEndDateUtc = null,
LockoutEnabled = false,
AccessFailedCount = 0
};
UserRole karolBasic = new UserRole() { Role = basicUser, User = karol };
User basia = new User()
{
UserName = "******",
Email = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = "AM+qVffwovJO6ncY4wFxZ12RBOlGQ23Z9yyNF95SI6Ij+cW7F0QzPI090Y6FYbimtQ==", //P@ssword1
SecurityStamp = "ef0ce398-45dd-41a7-ad99-0f39a28c0f32",
PhoneNumber = null,
PhoneNumberConfirmed = false,
TwoFactorEnabled = false,
LockoutEndDateUtc = null,
LockoutEnabled = false,
AccessFailedCount = 0
};
UserRole basiaBasic = new UserRole() { Role = basicUser, User = basia };
maciej.Roles.Add(maciejBasic);
karol.Roles.Add(karolBasic);
basia.Roles.Add(basiaBasic);
context.Roles.AddOrUpdate(r => new { r.Name }, basicUser);
context.Users.AddOrUpdate(u => new { u.UserName }, maciej);
context.Users.AddOrUpdate(u => new { u.UserName }, karol);
context.Users.AddOrUpdate(u => new { u.UserName }, basia);
}
public void CreateExpenseTypes(BusinessTripsContext context)
{
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 1, Name = "Artykuły biurowe" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 2, Name = "Autostrady" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 3, Name = "Bilet lotniczy" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 4, Name = "Katering" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 5, Name = "Hotel" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 6, Name = "Komunikacja publiczna" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 7, Name = "Konferencja-opłata za udział" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 8, Name = "Marketing" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 9, Name = "Napiwek" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 10, Name = "Opłaty notarialne" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 11, Name = "Opłaty za telefon" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 12, Name = "Paliwo" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 13, Name = "Parking" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 14, Name = "Posiłek z klientem" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 15, Name = "Prezent dla klienta" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 16, Name = "Prezent dla pracownika" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 17, Name = "Przesyłki kurierskie" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 18, Name = "Przesyłki pocztowe" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 19, Name = "Różnica kursu walut" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 20, Name = "Rozrywka-klient" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 21, Name = "Rozrywka-pracownik" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 22, Name = "Taxi" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 23, Name = "Trening-opłata za udział" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 24, Name = "Utrzymanie/naprawy samochodu" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 25, Name = "Wydatek za osoby trzecie" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 26, Name = "Wynajem samochodu" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 27, Name = "Wyposażenie biura" });
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType() { Id = 28, Name = "Wyżywienie" });
}
public void CreateCountries(BusinessTripsContext context)
{
context.Countries.RemoveRange(context.Countries.ToList());
context.SaveChanges();
Currency USD = new Currency() { Code = "USD", Name = "dolar amerykański" };
Currency EUR = new Currency() { Code = "EUR", Name = "euro" };
Currency AFN = new Currency() { Code = "AFN", Name = "afgani" }; Country Afganistan = new Country() { Name = "Afganistan", SubsistenceAllowance = 47, AccomodationLimit = 140, Currency = AFN, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Afganistan);
Currency ALL = new Currency() { Code = "ALL", Name = "lek" }; Country Albania = new Country() { Name = "Albania", SubsistenceAllowance = 41, AccomodationLimit = 120, Currency = ALL, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Albania);
Currency DZD = new Currency() { Code = "DZD", Name = "dinar" }; Country Algieria = new Country() { Name = "Algieria", SubsistenceAllowance = 50, AccomodationLimit = 200, Currency = DZD, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Algieria);
Country Andora = new Country() { Name = "Andora", SubsistenceAllowance = 50, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Andora);
Currency AOA = new Currency() { Code = "AOA", Name = "kwanza" }; Country Angola = new Country() { Name = "Angola", SubsistenceAllowance = 61, AccomodationLimit = 180, Currency = AOA, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Angola);
Currency SAR = new Currency() { Code = "SAR", Name = "rial" }; Country ArabiaSaudyjska = new Country() { Name = "Arabia Saudyjska", SubsistenceAllowance = 45, AccomodationLimit = 180, Currency = SAR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, ArabiaSaudyjska);
Currency ARS = new Currency() { Code = "ARS", Name = "peso" }; Country Argentyna = new Country() { Name = "Argentyna", SubsistenceAllowance = 50, AccomodationLimit = 150, Currency = ARS, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Argentyna);
Currency AMD = new Currency() { Code = "AMD", Name = "dram" }; Country Armenia = new Country() { Name = "Armenia", SubsistenceAllowance = 42, AccomodationLimit = 145, Currency = AMD, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Armenia);
Currency AUD = new Currency() { Code = "AUD", Name = "dolar australijski" }; Country Australia = new Country() { Name = "Australia", SubsistenceAllowance = 88, AccomodationLimit = 250, Currency = AUD, LimitCurrency = AUD }; context.Countries.AddOrUpdate(vt => vt.Name, Australia);
Country Austria = new Country() { Name = "Austria", SubsistenceAllowance = 52, AccomodationLimit = 130, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Austria);
Currency AZN = new Currency() { Code = "AZN", Name = "manat" }; Country Azerbejdżan = new Country() { Name = "Azerbejdżan", SubsistenceAllowance = 43, AccomodationLimit = 150, Currency = AZN, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Azerbejdżan);
Currency BDT = new Currency() { Code = "BDT", Name = "taka" }; Country Bangladesz = new Country() { Name = "Bangladesz", SubsistenceAllowance = 50, AccomodationLimit = 120, Currency = BDT, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Bangladesz);
Country Belgia = new Country() { Name = "Belgia", SubsistenceAllowance = 48, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Belgia);
Currency BYR = new Currency() { Code = "BYR", Name = "rubel białoruski" }; Country Białoruś = new Country() { Name = "Białoruś", SubsistenceAllowance = 42, AccomodationLimit = 130, Currency = BYR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Białoruś);
Currency BAM = new Currency() { Code = "BAM", Name = "marka" }; Country BośniaiHercegowina = new Country() { Name = "Bośnia i Hercegowina", SubsistenceAllowance = 41, AccomodationLimit = 100, Currency = BAM, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, BośniaiHercegowina);
Currency BRL = new Currency() { Code = "BRL", Name = "real" }; Country Brazylia = new Country() { Name = "Brazylia", SubsistenceAllowance = 43, AccomodationLimit = 120, Currency = BRL, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Brazylia);
Currency BGN = new Currency() { Code = "BGN", Name = "lew bułgarski" }; Country Bułgaria = new Country() { Name = "Bułgaria", SubsistenceAllowance = 40, AccomodationLimit = 120, Currency = BGN, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Bułgaria);
Currency CLP = new Currency() { Code = "CLP", Name = "peso" }; Country Chile = new Country() { Name = "Chile", SubsistenceAllowance = 60, AccomodationLimit = 120, Currency = CLP, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Chile);
Currency CNY = new Currency() { Code = "CNY", Name = "juan(renminbi)" }; Country Chiny = new Country() { Name = "Chiny", SubsistenceAllowance = 55, AccomodationLimit = 170, Currency = CNY, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Chiny);
Currency HRK = new Currency() { Code = "HRK", Name = "kuna chorwacka" }; Country Chorwacja = new Country() { Name = "Chorwacja", SubsistenceAllowance = 42, AccomodationLimit = 125, Currency = HRK, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Chorwacja);
Country Cypr = new Country() { Name = "Cypr", SubsistenceAllowance = 43, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Cypr);
Currency CZK = new Currency() { Code = "CZK", Name = "korona czeska" }; Country Czechy = new Country() { Name = "Czechy", SubsistenceAllowance = 41, AccomodationLimit = 120, Currency = CZK, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Czechy);
Currency DKK = new Currency() { Code = "DKK", Name = "korona duńska" }; Country Dania = new Country() { Name = "Dania", SubsistenceAllowance = 406, AccomodationLimit = 1300, Currency = DKK, LimitCurrency = DKK }; context.Countries.AddOrUpdate(vt => vt.Name, Dania);
Currency EGP = new Currency() { Code = "EGP", Name = "funt egipski" }; Country Egipt = new Country() { Name = "Egipt", SubsistenceAllowance = 55, AccomodationLimit = 150, Currency = EGP, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Egipt);
Country Ekwador = new Country() { Name = "Ekwador", SubsistenceAllowance = 44, AccomodationLimit = 110, Currency = USD, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Ekwador);
Country Estonia = new Country() { Name = "Estonia", SubsistenceAllowance = 41, AccomodationLimit = 100, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Estonia);
Currency ETB = new Currency() { Code = "ETB", Name = "birr" }; Country Etiopia = new Country() { Name = "Etiopia", SubsistenceAllowance = 55, AccomodationLimit = 300, Currency = ETB, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Etiopia);
Country Finlandia = new Country() { Name = "Finlandia", SubsistenceAllowance = 48, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Finlandia);
Country Francja = new Country() { Name = "Francja", SubsistenceAllowance = 50, AccomodationLimit = 180, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Francja);
Country Grecja = new Country() { Name = "Grecja", SubsistenceAllowance = 48, AccomodationLimit = 140, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Grecja);
Currency GEL = new Currency() { Code = "GEL", Name = "lari" }; Country Gruzja = new Country() { Name = "Gruzja", SubsistenceAllowance = 43, AccomodationLimit = 140, Currency = GEL, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Gruzja);
Country Hiszpania = new Country() { Name = "Hiszpania", SubsistenceAllowance = 50, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Hiszpania);
Currency INR = new Currency() { Code = "INR", Name = "rupia" }; Country Indie = new Country() { Name = "Indie", SubsistenceAllowance = 38, AccomodationLimit = 190, Currency = INR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Indie);
Currency IDR = new Currency() { Code = "IDR", Name = "rupia" }; Country Indonezja = new Country() { Name = "Indonezja", SubsistenceAllowance = 41, AccomodationLimit = 110, Currency = IDR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Indonezja);
Currency InneCurrency = new Currency() { Code = "Inne", Name = "Inne" }; Country InneCountry = new Country() { Name = "Inne", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = InneCurrency, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, InneCountry);
Currency IQD = new Currency() { Code = "IQD", Name = "dinar" }; Country Irak = new Country() { Name = "Irak", SubsistenceAllowance = 60, AccomodationLimit = 120, Currency = IQD, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Irak);
Currency IRR = new Currency() { Code = "IRR", Name = "rial" }; Country Iran = new Country() { Name = "Iran", SubsistenceAllowance = 41, AccomodationLimit = 95, Currency = IRR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Iran);
Country Irlandia = new Country() { Name = "Irlandia", SubsistenceAllowance = 52, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Irlandia);
Currency ISK = new Currency() { Code = "ISK", Name = "korona" }; Country Islandia = new Country() { Name = "Islandia", SubsistenceAllowance = 56, AccomodationLimit = 160, Currency = ISK, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Islandia);
Currency ILS = new Currency() { Code = "ILS", Name = "nowy szekel" }; Country Izrael = new Country() { Name = "Izrael", SubsistenceAllowance = 50, AccomodationLimit = 150, Currency = ILS, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Izrael);
Currency JPY = new Currency() { Code = "JPY", Name = "jen japoński" }; Country Japonia = new Country() { Name = "Japonia", SubsistenceAllowance = 7532, AccomodationLimit = 22000, Currency = JPY, LimitCurrency = JPY }; context.Countries.AddOrUpdate(vt => vt.Name, Japonia);
Currency YER = new Currency() { Code = "YER", Name = "rial" }; Country Jemen = new Country() { Name = "Jemen", SubsistenceAllowance = 48, AccomodationLimit = 160, Currency = YER, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Jemen);
Currency JOD = new Currency() { Code = "JOD", Name = "dinar" }; Country Jordania = new Country() { Name = "Jordania", SubsistenceAllowance = 40, AccomodationLimit = 95, Currency = JOD, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Jordania);
Currency KHR = new Currency() { Code = "KHR", Name = "riel" }; Country Kambodża = new Country() { Name = "Kambodża", SubsistenceAllowance = 45, AccomodationLimit = 100, Currency = KHR, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Kambodża);
Currency CAD = new Currency() { Code = "CAD", Name = "dolar kanadyjski" }; Country Kanada = new Country() { Name = "Kanada", SubsistenceAllowance = 71, AccomodationLimit = 190, Currency = CAD, LimitCurrency = CAD }; context.Countries.AddOrUpdate(vt => vt.Name, Kanada);
Currency QAR = new Currency() { Code = "QAR", Name = "rial" }; Country Katar = new Country() { Name = "Katar", SubsistenceAllowance = 41, AccomodationLimit = 200, Currency = QAR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Katar);
Currency KZT = new Currency() { Code = "KZT", Name = "tenge" }; Country Kazachstan = new Country() { Name = "Kazachstan", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = KZT, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Kazachstan);
Currency KES = new Currency() { Code = "KES", Name = "szyling" }; Country Kenia = new Country() { Name = "Kenia", SubsistenceAllowance = 41, AccomodationLimit = 150, Currency = KES, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Kenia);
Currency KGS = new Currency() { Code = "KGS", Name = "som" }; Country Kirgistan = new Country() { Name = "Kirgistan", SubsistenceAllowance = 41, AccomodationLimit = 150, Currency = KGS, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Kirgistan);
Currency COP = new Currency() { Code = "COP", Name = "peso" }; Country Kolumbia = new Country() { Name = "Kolumbia", SubsistenceAllowance = 49, AccomodationLimit = 120, Currency = COP, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Kolumbia);
Currency XAF = new Currency() { Code = "XAF", Name = "frank CFA" }; Country Kongo = new Country() { Name = "Kongo", SubsistenceAllowance = 66, AccomodationLimit = 220, Currency = XAF, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Kongo);
Currency KRW = new Currency() { Code = "KRW", Name = "won" }; Country KoreaPołudniowa = new Country() { Name = "Korea Południowa", SubsistenceAllowance = 46, AccomodationLimit = 170, Currency = KRW, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, KoreaPołudniowa);
Currency CRC = new Currency() { Code = "CRC", Name = "colon" }; Country Kostaryka = new Country() { Name = "Kostaryka", SubsistenceAllowance = 50, AccomodationLimit = 140, Currency = CRC, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Kostaryka);
Currency KWD = new Currency() { Code = "KWD", Name = "dinar" }; Country Kuwejt = new Country() { Name = "Kuwejt", SubsistenceAllowance = 39, AccomodationLimit = 200, Currency = KWD, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Kuwejt);
Currency LAK = new Currency() { Code = "LAK", Name = "kip" }; Country Laos = new Country() { Name = "Laos", SubsistenceAllowance = 54, AccomodationLimit = 100, Currency = LAK, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Laos);
Currency LBP = new Currency() { Code = "LBP", Name = "funt" }; Country Liban = new Country() { Name = "Liban", SubsistenceAllowance = 57, AccomodationLimit = 150, Currency = LBP, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Liban);
Currency LYD = new Currency() { Code = "LYD", Name = "dinar" }; Country Libia = new Country() { Name = "Libia", SubsistenceAllowance = 52, AccomodationLimit = 100, Currency = LYD, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Libia);
Currency CHF = new Currency() { Code = "CHF", Name = "frank szwajcarski" }; Country Liechtenstein = new Country() { Name = "Liechtenstein", SubsistenceAllowance = 88, AccomodationLimit = 200, Currency = CHF, LimitCurrency = CHF }; context.Countries.AddOrUpdate(vt => vt.Name, Liechtenstein);
Country Litwa = new Country() { Name = "Litwa", SubsistenceAllowance = 39, AccomodationLimit = 130, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Litwa);
Country Luksemburg = new Country() { Name = "Luksemburg", SubsistenceAllowance = 48, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Luksemburg);
Country Łotwa = new Country() { Name = "Łotwa", SubsistenceAllowance = 57, AccomodationLimit = 132, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Łotwa);
Currency MKD = new Currency() { Code = "MKD", Name = "denar" }; Country Macedonia = new Country() { Name = "Macedonia", SubsistenceAllowance = 39, AccomodationLimit = 125, Currency = MKD, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Macedonia);
Currency MYR = new Currency() { Code = "MYR", Name = "ringgit" }; Country Malezja = new Country() { Name = "Malezja", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = MYR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Malezja);
Country Malta = new Country() { Name = "Malta", SubsistenceAllowance = 43, AccomodationLimit = 180, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Malta);
Currency MAD = new Currency() { Code = "MAD", Name = "dirham" }; Country Maroko = new Country() { Name = "Maroko", SubsistenceAllowance = 41, AccomodationLimit = 130, Currency = MAD, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Maroko);
Currency MXN = new Currency() { Code = "MXN", Name = "peso" }; Country Meksyk = new Country() { Name = "Meksyk", SubsistenceAllowance = 53, AccomodationLimit = 140, Currency = MXN, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Meksyk);
Currency MDL = new Currency() { Code = "MDL", Name = "lej" }; Country Mołdawia = new Country() { Name = "Mołdawia", SubsistenceAllowance = 41, AccomodationLimit = 85, Currency = MDL, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Mołdawia);
Country Monako = new Country() { Name = "Monako", SubsistenceAllowance = 50, AccomodationLimit = 180, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Monako);
Currency MNT = new Currency() { Code = "MNT", Name = "tugrik" }; Country Mongolia = new Country() { Name = "Mongolia", SubsistenceAllowance = 45, AccomodationLimit = 140, Currency = MNT, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Mongolia);
Country Holandia = new Country() { Name = "Holandia", SubsistenceAllowance = 50, AccomodationLimit = 130, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Holandia);
Country Niemcy = new Country() { Name = "Niemcy", SubsistenceAllowance = 49, AccomodationLimit = 150, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Niemcy);
Currency NGN = new Currency() { Code = "NGN", Name = "naira" }; Country Nigeria = new Country() { Name = "Nigeria", SubsistenceAllowance = 46, AccomodationLimit = 240, Currency = NGN, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Nigeria);
Currency NOK = new Currency() { Code = "NOK", Name = "korona norweska" }; Country Norwegia = new Country() { Name = "Norwegia", SubsistenceAllowance = 451, AccomodationLimit = 1500, Currency = NOK, LimitCurrency = NOK }; context.Countries.AddOrUpdate(vt => vt.Name, Norwegia);
Currency NZD = new Currency() { Code = "NZD", Name = "dolar" }; Country NowaZelandia = new Country() { Name = "Nowa Zelandia", SubsistenceAllowance = 58, AccomodationLimit = 180, Currency = NZD, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, NowaZelandia);
Currency OMR = new Currency() { Code = "OMR", Name = "rial" }; Country Oman = new Country() { Name = "Oman", SubsistenceAllowance = 40, AccomodationLimit = 240, Currency = OMR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Oman);
Currency PKR = new Currency() { Code = "PKR", Name = "rupia" }; Country Pakistan = new Country() { Name = "Pakistan", SubsistenceAllowance = 38, AccomodationLimit = 200, Currency = PKR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Pakistan);
Currency PAB = new Currency() { Code = "PAB", Name = "balboa" }; Country Panama = new Country() { Name = "Panama", SubsistenceAllowance = 52, AccomodationLimit = 140, Currency = PAB, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Panama);
Currency PEN = new Currency() { Code = "PEN", Name = "nowy sol" }; Country Peru = new Country() { Name = "Peru", SubsistenceAllowance = 50, AccomodationLimit = 150, Currency = PEN, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Peru);
Currency PLN = new Currency() { Code = "PLN", Name = "złoty" }; Country Polska = new Country() { Name = "Polska", SubsistenceAllowance = 30, AccomodationLimit = 45, Currency = PLN, LimitCurrency = PLN }; context.Countries.AddOrUpdate(vt => vt.Name, Polska);
Country Portugalia = new Country() { Name = "Portugalia", SubsistenceAllowance = 49, AccomodationLimit = 120, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Portugalia);
Currency ZAR = new Currency() { Code = "ZAR", Name = "rand" }; Country RepublikaPołudniowejAfryki = new Country() { Name = "Republika Południowej Afryki", SubsistenceAllowance = 52, AccomodationLimit = 275, Currency = ZAR, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, RepublikaPołudniowejAfryki);
Currency RUB = new Currency() { Code = "RUB", Name = "rubel rosyjski" }; Country Rosja = new Country() { Name = "Rosja", SubsistenceAllowance = 48, AccomodationLimit = 200, Currency = RUB, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Rosja);
Currency RON = new Currency() { Code = "RON", Name = "lej rumuński" }; Country Rumunia = new Country() { Name = "Rumunia", SubsistenceAllowance = 38, AccomodationLimit = 100, Currency = RON, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Rumunia);
Country SanMarino = new Country() { Name = "San Marino", SubsistenceAllowance = 48, AccomodationLimit = 174, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, SanMarino);
Currency XOF = new Currency() { Code = "XOF", Name = "frank CFA" }; Country Senegal = new Country() { Name = "Senegal", SubsistenceAllowance = 44, AccomodationLimit = 120, Currency = XOF, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Senegal);
Currency SGD = new Currency() { Code = "SGD", Name = "dolar" }; Country Singapur = new Country() { Name = "Singapur", SubsistenceAllowance = 56, AccomodationLimit = 230, Currency = SGD, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Singapur);
Country Słowacja = new Country() { Name = "Słowacja", SubsistenceAllowance = 43, AccomodationLimit = 120, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Słowacja);
Country Słowenia = new Country() { Name = "Słowenia", SubsistenceAllowance = 41, AccomodationLimit = 130, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Słowenia);
Currency SYP = new Currency() { Code = "SYP", Name = "funt" }; Country Syria = new Country() { Name = "Syria", SubsistenceAllowance = 50, AccomodationLimit = 150, Currency = SYP, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Syria);
Country Szwajcaria = new Country() { Name = "Szwajcaria", SubsistenceAllowance = 88, AccomodationLimit = 200, Currency = CHF, LimitCurrency = CHF }; context.Countries.AddOrUpdate(vt => vt.Name, Szwajcaria);
Currency SEK = new Currency() { Code = "SEK", Name = "korona szwedzka" }; Country Szwecja = new Country() { Name = "Szwecja", SubsistenceAllowance = 459, AccomodationLimit = 1800, Currency = SEK, LimitCurrency = SEK }; context.Countries.AddOrUpdate(vt => vt.Name, Szwecja);
Currency TJS = new Currency() { Code = "TJS", Name = "somoni" }; Country Tadżykistan = new Country() { Name = "Tadżykistan", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = TJS, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Tadżykistan);
Currency THB = new Currency() { Code = "THB", Name = "bat" }; Country Tajlandia = new Country() { Name = "Tajlandia", SubsistenceAllowance = 42, AccomodationLimit = 110, Currency = THB, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Tajlandia);
Currency TZS = new Currency() { Code = "TZS", Name = "szyling" }; Country Tanzania = new Country() { Name = "Tanzania", SubsistenceAllowance = 53, AccomodationLimit = 150, Currency = TZS, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Tanzania);
Currency TND = new Currency() { Code = "TND", Name = "dinar" }; Country Tunezja = new Country() { Name = "Tunezja", SubsistenceAllowance = 37, AccomodationLimit = 100, Currency = TND, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Tunezja);
Currency TRY = new Currency() { Code = "TRY", Name = "lira turecka" }; Country Turcja = new Country() { Name = "Turcja", SubsistenceAllowance = 53, AccomodationLimit = 173, Currency = TRY, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Turcja);
Currency UAH = new Currency() { Code = "UAH", Name = "hrywna ukraińska" }; Country Ukraina = new Country() { Name = "Ukraina", SubsistenceAllowance = 41, AccomodationLimit = 180, Currency = UAH, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Ukraina);
Currency UYU = new Currency() { Code = "UYU", Name = "peso" }; Country Urugwaj = new Country() { Name = "Urugwaj", SubsistenceAllowance = 50, AccomodationLimit = 80, Currency = UYU, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Urugwaj);
Country USA = new Country() { Name = "USA", SubsistenceAllowance = 59, AccomodationLimit = 200, Currency = USD, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, USA);
Country USANowyJork = new Country() { Name = "USA – Nowy Jork", SubsistenceAllowance = 59, AccomodationLimit = 350, Currency = USD, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, USANowyJork);
Country USAWaszyngton = new Country() { Name = "USA – Waszyngton", SubsistenceAllowance = 59, AccomodationLimit = 200, Currency = USD, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, USAWaszyngton);
Currency UZS = new Currency() { Code = "UZS", Name = "som" }; Country Uzbekistan = new Country() { Name = "Uzbekistan", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = UZS, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Uzbekistan);
Currency VEF = new Currency() { Code = "VEF", Name = "boliwar" }; Country Wenezuela = new Country() { Name = "Wenezuela", SubsistenceAllowance = 60, AccomodationLimit = 220, Currency = VEF, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Wenezuela);
Currency HUF = new Currency() { Code = "HUF", Name = "forint węgierski" }; Country Węgry = new Country() { Name = "Węgry", SubsistenceAllowance = 44, AccomodationLimit = 130, Currency = HUF, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Węgry);
Currency GBP = new Currency() { Code = "GBP", Name = "funt brytyjski" }; Country WielkaBrytania = new Country() { Name = "Wielka Brytania", SubsistenceAllowance = 35, AccomodationLimit = 200, Currency = GBP, LimitCurrency = GBP }; context.Countries.AddOrUpdate(vt => vt.Name, WielkaBrytania);
Currency VND = new Currency() { Code = "VND", Name = "dong" }; Country Wietnam = new Country() { Name = "Wietnam", SubsistenceAllowance = 53, AccomodationLimit = 160, Currency = VND, LimitCurrency = USD }; context.Countries.AddOrUpdate(vt => vt.Name, Wietnam);
Country Włochy = new Country() { Name = "Włochy", SubsistenceAllowance = 48, AccomodationLimit = 174, Currency = EUR, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Włochy);
Country WybrzeżeKościSłoniowej = new Country() { Name = "Wybrzeże Kości Słoniowej", SubsistenceAllowance = 33, AccomodationLimit = 100, Currency = XOF, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, WybrzeżeKościSłoniowej);
Currency ZWD = new Currency() { Code = "ZWD", Name = "dolar" }; Country Zimbabwe = new Country() { Name = "Zimbabwe", SubsistenceAllowance = 39, AccomodationLimit = 90, Currency = ZWD, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, Zimbabwe);
Currency AED = new Currency() { Code = "AED", Name = "dirham" }; Country ZjednoczoneEmiratyArabskie = new Country() { Name = "Zjednoczone Emiraty Arabskie", SubsistenceAllowance = 39, AccomodationLimit = 200, Currency = AED, LimitCurrency = EUR }; context.Countries.AddOrUpdate(vt => vt.Name, ZjednoczoneEmiratyArabskie);
}
public void CreateExpenseDocumentTypes(BusinessTripsContext context)
{
ExpenseDocumentType type1 = new ExpenseDocumentType()
{
Id = 1,
Name = "Faktura"
};
ExpenseDocumentType type2 = new ExpenseDocumentType()
{
Id = 2,
Name = "Paragon"
};
ExpenseDocumentType type3 = new ExpenseDocumentType()
{
Id = 3,
Name = "Brak dok."
};
context.ExpenseDocumentTypes.AddOrUpdate(et => et.Name, type1);
context.ExpenseDocumentTypes.AddOrUpdate(et => et.Name, type2);
context.ExpenseDocumentTypes.AddOrUpdate(et => et.Name, type3);
}
public UsersRepository(BusinessTripsContext _context)
{
this.context = _context;
}
public void CreateExpenseTypes(BusinessTripsContext context)
{
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 1, Name = "Artykuły biurowe"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 2, Name = "Autostrady"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 3, Name = "Bilet lotniczy"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 4, Name = "Katering"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 5, Name = "Hotel"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 6, Name = "Komunikacja publiczna"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 7, Name = "Konferencja-opłata za udział"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 8, Name = "Marketing"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 9, Name = "Napiwek"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 10, Name = "Opłaty notarialne"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 11, Name = "Opłaty za telefon"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 12, Name = "Paliwo"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 13, Name = "Parking"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 14, Name = "Posiłek z klientem"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 15, Name = "Prezent dla klienta"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 16, Name = "Prezent dla pracownika"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 17, Name = "Przesyłki kurierskie"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 18, Name = "Przesyłki pocztowe"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 19, Name = "Różnica kursu walut"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 20, Name = "Rozrywka-klient"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 21, Name = "Rozrywka-pracownik"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 22, Name = "Taxi"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 23, Name = "Trening-opłata za udział"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 24, Name = "Utrzymanie/naprawy samochodu"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 25, Name = "Wydatek za osoby trzecie"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 26, Name = "Wynajem samochodu"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 27, Name = "Wyposażenie biura"
});
context.ExpenseTypes.AddOrUpdate(et => et.Name, new ExpenseType()
{
Id = 28, Name = "Wyżywienie"
});
}
public MileageAllowancesRepository(BusinessTripsContext _context)
{
this.context = _context;
}
public DictionariesRepository(BusinessTripsContext _context)
{
this.context = _context;
}
public void SeedContext(BusinessTripsContext context)
{
CreateUsers(context);
CreateCountries(context);
CreateVehicleTypes(context);
CreateExpenseTypes(context);
CreateExpenseDocumentTypes(context);
}
public CurrenciesRepository(BusinessTripsContext _context)
{
this.context = _context;
}
public void CreateCountries(BusinessTripsContext context)
{
context.Countries.RemoveRange(context.Countries.ToList());
context.SaveChanges();
Currency USD = new Currency()
{
Code = "USD", Name = "dolar amerykański"
};
Currency EUR = new Currency()
{
Code = "EUR", Name = "euro"
};
Currency AFN = new Currency()
{
Code = "AFN", Name = "afgani"
}; Country Afganistan = new Country()
{
Name = "Afganistan", SubsistenceAllowance = 47, AccomodationLimit = 140, Currency = AFN, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Afganistan);
Currency ALL = new Currency()
{
Code = "ALL", Name = "lek"
}; Country Albania = new Country()
{
Name = "Albania", SubsistenceAllowance = 41, AccomodationLimit = 120, Currency = ALL, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Albania);
Currency DZD = new Currency()
{
Code = "DZD", Name = "dinar"
}; Country Algieria = new Country()
{
Name = "Algieria", SubsistenceAllowance = 50, AccomodationLimit = 200, Currency = DZD, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Algieria);
Country Andora = new Country()
{
Name = "Andora", SubsistenceAllowance = 50, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Andora);
Currency AOA = new Currency()
{
Code = "AOA", Name = "kwanza"
}; Country Angola = new Country()
{
Name = "Angola", SubsistenceAllowance = 61, AccomodationLimit = 180, Currency = AOA, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Angola);
Currency SAR = new Currency()
{
Code = "SAR", Name = "rial"
}; Country ArabiaSaudyjska = new Country()
{
Name = "Arabia Saudyjska", SubsistenceAllowance = 45, AccomodationLimit = 180, Currency = SAR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, ArabiaSaudyjska);
Currency ARS = new Currency()
{
Code = "ARS", Name = "peso"
}; Country Argentyna = new Country()
{
Name = "Argentyna", SubsistenceAllowance = 50, AccomodationLimit = 150, Currency = ARS, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Argentyna);
Currency AMD = new Currency()
{
Code = "AMD", Name = "dram"
}; Country Armenia = new Country()
{
Name = "Armenia", SubsistenceAllowance = 42, AccomodationLimit = 145, Currency = AMD, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Armenia);
Currency AUD = new Currency()
{
Code = "AUD", Name = "dolar australijski"
}; Country Australia = new Country()
{
Name = "Australia", SubsistenceAllowance = 88, AccomodationLimit = 250, Currency = AUD, LimitCurrency = AUD
}; context.Countries.AddOrUpdate(vt => vt.Name, Australia);
Country Austria = new Country()
{
Name = "Austria", SubsistenceAllowance = 52, AccomodationLimit = 130, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Austria);
Currency AZN = new Currency()
{
Code = "AZN", Name = "manat"
}; Country Azerbejdżan = new Country()
{
Name = "Azerbejdżan", SubsistenceAllowance = 43, AccomodationLimit = 150, Currency = AZN, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Azerbejdżan);
Currency BDT = new Currency()
{
Code = "BDT", Name = "taka"
}; Country Bangladesz = new Country()
{
Name = "Bangladesz", SubsistenceAllowance = 50, AccomodationLimit = 120, Currency = BDT, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Bangladesz);
Country Belgia = new Country()
{
Name = "Belgia", SubsistenceAllowance = 48, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Belgia);
Currency BYR = new Currency()
{
Code = "BYR", Name = "rubel białoruski"
}; Country Białoruś = new Country()
{
Name = "Białoruś", SubsistenceAllowance = 42, AccomodationLimit = 130, Currency = BYR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Białoruś);
Currency BAM = new Currency()
{
Code = "BAM", Name = "marka"
}; Country BośniaiHercegowina = new Country()
{
Name = "Bośnia i Hercegowina", SubsistenceAllowance = 41, AccomodationLimit = 100, Currency = BAM, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, BośniaiHercegowina);
Currency BRL = new Currency()
{
Code = "BRL", Name = "real"
}; Country Brazylia = new Country()
{
Name = "Brazylia", SubsistenceAllowance = 43, AccomodationLimit = 120, Currency = BRL, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Brazylia);
Currency BGN = new Currency()
{
Code = "BGN", Name = "lew bułgarski"
}; Country Bułgaria = new Country()
{
Name = "Bułgaria", SubsistenceAllowance = 40, AccomodationLimit = 120, Currency = BGN, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Bułgaria);
Currency CLP = new Currency()
{
Code = "CLP", Name = "peso"
}; Country Chile = new Country()
{
Name = "Chile", SubsistenceAllowance = 60, AccomodationLimit = 120, Currency = CLP, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Chile);
Currency CNY = new Currency()
{
Code = "CNY", Name = "juan(renminbi)"
}; Country Chiny = new Country()
{
Name = "Chiny", SubsistenceAllowance = 55, AccomodationLimit = 170, Currency = CNY, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Chiny);
Currency HRK = new Currency()
{
Code = "HRK", Name = "kuna chorwacka"
}; Country Chorwacja = new Country()
{
Name = "Chorwacja", SubsistenceAllowance = 42, AccomodationLimit = 125, Currency = HRK, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Chorwacja);
Country Cypr = new Country()
{
Name = "Cypr", SubsistenceAllowance = 43, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Cypr);
Currency CZK = new Currency()
{
Code = "CZK", Name = "korona czeska"
}; Country Czechy = new Country()
{
Name = "Czechy", SubsistenceAllowance = 41, AccomodationLimit = 120, Currency = CZK, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Czechy);
Currency DKK = new Currency()
{
Code = "DKK", Name = "korona duńska"
}; Country Dania = new Country()
{
Name = "Dania", SubsistenceAllowance = 406, AccomodationLimit = 1300, Currency = DKK, LimitCurrency = DKK
}; context.Countries.AddOrUpdate(vt => vt.Name, Dania);
Currency EGP = new Currency()
{
Code = "EGP", Name = "funt egipski"
}; Country Egipt = new Country()
{
Name = "Egipt", SubsistenceAllowance = 55, AccomodationLimit = 150, Currency = EGP, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Egipt);
Country Ekwador = new Country()
{
Name = "Ekwador", SubsistenceAllowance = 44, AccomodationLimit = 110, Currency = USD, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Ekwador);
Country Estonia = new Country()
{
Name = "Estonia", SubsistenceAllowance = 41, AccomodationLimit = 100, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Estonia);
Currency ETB = new Currency()
{
Code = "ETB", Name = "birr"
}; Country Etiopia = new Country()
{
Name = "Etiopia", SubsistenceAllowance = 55, AccomodationLimit = 300, Currency = ETB, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Etiopia);
Country Finlandia = new Country()
{
Name = "Finlandia", SubsistenceAllowance = 48, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Finlandia);
Country Francja = new Country()
{
Name = "Francja", SubsistenceAllowance = 50, AccomodationLimit = 180, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Francja);
Country Grecja = new Country()
{
Name = "Grecja", SubsistenceAllowance = 48, AccomodationLimit = 140, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Grecja);
Currency GEL = new Currency()
{
Code = "GEL", Name = "lari"
}; Country Gruzja = new Country()
{
Name = "Gruzja", SubsistenceAllowance = 43, AccomodationLimit = 140, Currency = GEL, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Gruzja);
Country Hiszpania = new Country()
{
Name = "Hiszpania", SubsistenceAllowance = 50, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Hiszpania);
Currency INR = new Currency()
{
Code = "INR", Name = "rupia"
}; Country Indie = new Country()
{
Name = "Indie", SubsistenceAllowance = 38, AccomodationLimit = 190, Currency = INR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Indie);
Currency IDR = new Currency()
{
Code = "IDR", Name = "rupia"
}; Country Indonezja = new Country()
{
Name = "Indonezja", SubsistenceAllowance = 41, AccomodationLimit = 110, Currency = IDR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Indonezja);
Currency InneCurrency = new Currency()
{
Code = "Inne", Name = "Inne"
}; Country InneCountry = new Country()
{
Name = "Inne", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = InneCurrency, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, InneCountry);
Currency IQD = new Currency()
{
Code = "IQD", Name = "dinar"
}; Country Irak = new Country()
{
Name = "Irak", SubsistenceAllowance = 60, AccomodationLimit = 120, Currency = IQD, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Irak);
Currency IRR = new Currency()
{
Code = "IRR", Name = "rial"
}; Country Iran = new Country()
{
Name = "Iran", SubsistenceAllowance = 41, AccomodationLimit = 95, Currency = IRR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Iran);
Country Irlandia = new Country()
{
Name = "Irlandia", SubsistenceAllowance = 52, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Irlandia);
Currency ISK = new Currency()
{
Code = "ISK", Name = "korona"
}; Country Islandia = new Country()
{
Name = "Islandia", SubsistenceAllowance = 56, AccomodationLimit = 160, Currency = ISK, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Islandia);
Currency ILS = new Currency()
{
Code = "ILS", Name = "nowy szekel"
}; Country Izrael = new Country()
{
Name = "Izrael", SubsistenceAllowance = 50, AccomodationLimit = 150, Currency = ILS, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Izrael);
Currency JPY = new Currency()
{
Code = "JPY", Name = "jen japoński"
}; Country Japonia = new Country()
{
Name = "Japonia", SubsistenceAllowance = 7532, AccomodationLimit = 22000, Currency = JPY, LimitCurrency = JPY
}; context.Countries.AddOrUpdate(vt => vt.Name, Japonia);
Currency YER = new Currency()
{
Code = "YER", Name = "rial"
}; Country Jemen = new Country()
{
Name = "Jemen", SubsistenceAllowance = 48, AccomodationLimit = 160, Currency = YER, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Jemen);
Currency JOD = new Currency()
{
Code = "JOD", Name = "dinar"
}; Country Jordania = new Country()
{
Name = "Jordania", SubsistenceAllowance = 40, AccomodationLimit = 95, Currency = JOD, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Jordania);
Currency KHR = new Currency()
{
Code = "KHR", Name = "riel"
}; Country Kambodża = new Country()
{
Name = "Kambodża", SubsistenceAllowance = 45, AccomodationLimit = 100, Currency = KHR, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Kambodża);
Currency CAD = new Currency()
{
Code = "CAD", Name = "dolar kanadyjski"
}; Country Kanada = new Country()
{
Name = "Kanada", SubsistenceAllowance = 71, AccomodationLimit = 190, Currency = CAD, LimitCurrency = CAD
}; context.Countries.AddOrUpdate(vt => vt.Name, Kanada);
Currency QAR = new Currency()
{
Code = "QAR", Name = "rial"
}; Country Katar = new Country()
{
Name = "Katar", SubsistenceAllowance = 41, AccomodationLimit = 200, Currency = QAR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Katar);
Currency KZT = new Currency()
{
Code = "KZT", Name = "tenge"
}; Country Kazachstan = new Country()
{
Name = "Kazachstan", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = KZT, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Kazachstan);
Currency KES = new Currency()
{
Code = "KES", Name = "szyling"
}; Country Kenia = new Country()
{
Name = "Kenia", SubsistenceAllowance = 41, AccomodationLimit = 150, Currency = KES, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Kenia);
Currency KGS = new Currency()
{
Code = "KGS", Name = "som"
}; Country Kirgistan = new Country()
{
Name = "Kirgistan", SubsistenceAllowance = 41, AccomodationLimit = 150, Currency = KGS, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Kirgistan);
Currency COP = new Currency()
{
Code = "COP", Name = "peso"
}; Country Kolumbia = new Country()
{
Name = "Kolumbia", SubsistenceAllowance = 49, AccomodationLimit = 120, Currency = COP, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Kolumbia);
Currency XAF = new Currency()
{
Code = "XAF", Name = "frank CFA"
}; Country Kongo = new Country()
{
Name = "Kongo", SubsistenceAllowance = 66, AccomodationLimit = 220, Currency = XAF, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Kongo);
Currency KRW = new Currency()
{
Code = "KRW", Name = "won"
}; Country KoreaPołudniowa = new Country()
{
Name = "Korea Południowa", SubsistenceAllowance = 46, AccomodationLimit = 170, Currency = KRW, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, KoreaPołudniowa);
Currency CRC = new Currency()
{
Code = "CRC", Name = "colon"
}; Country Kostaryka = new Country()
{
Name = "Kostaryka", SubsistenceAllowance = 50, AccomodationLimit = 140, Currency = CRC, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Kostaryka);
Currency KWD = new Currency()
{
Code = "KWD", Name = "dinar"
}; Country Kuwejt = new Country()
{
Name = "Kuwejt", SubsistenceAllowance = 39, AccomodationLimit = 200, Currency = KWD, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Kuwejt);
Currency LAK = new Currency()
{
Code = "LAK", Name = "kip"
}; Country Laos = new Country()
{
Name = "Laos", SubsistenceAllowance = 54, AccomodationLimit = 100, Currency = LAK, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Laos);
Currency LBP = new Currency()
{
Code = "LBP", Name = "funt"
}; Country Liban = new Country()
{
Name = "Liban", SubsistenceAllowance = 57, AccomodationLimit = 150, Currency = LBP, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Liban);
Currency LYD = new Currency()
{
Code = "LYD", Name = "dinar"
}; Country Libia = new Country()
{
Name = "Libia", SubsistenceAllowance = 52, AccomodationLimit = 100, Currency = LYD, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Libia);
Currency CHF = new Currency()
{
Code = "CHF", Name = "frank szwajcarski"
}; Country Liechtenstein = new Country()
{
Name = "Liechtenstein", SubsistenceAllowance = 88, AccomodationLimit = 200, Currency = CHF, LimitCurrency = CHF
}; context.Countries.AddOrUpdate(vt => vt.Name, Liechtenstein);
Country Litwa = new Country()
{
Name = "Litwa", SubsistenceAllowance = 39, AccomodationLimit = 130, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Litwa);
Country Luksemburg = new Country()
{
Name = "Luksemburg", SubsistenceAllowance = 48, AccomodationLimit = 160, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Luksemburg);
Country Łotwa = new Country()
{
Name = "Łotwa", SubsistenceAllowance = 57, AccomodationLimit = 132, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Łotwa);
Currency MKD = new Currency()
{
Code = "MKD", Name = "denar"
}; Country Macedonia = new Country()
{
Name = "Macedonia", SubsistenceAllowance = 39, AccomodationLimit = 125, Currency = MKD, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Macedonia);
Currency MYR = new Currency()
{
Code = "MYR", Name = "ringgit"
}; Country Malezja = new Country()
{
Name = "Malezja", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = MYR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Malezja);
Country Malta = new Country()
{
Name = "Malta", SubsistenceAllowance = 43, AccomodationLimit = 180, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Malta);
Currency MAD = new Currency()
{
Code = "MAD", Name = "dirham"
}; Country Maroko = new Country()
{
Name = "Maroko", SubsistenceAllowance = 41, AccomodationLimit = 130, Currency = MAD, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Maroko);
Currency MXN = new Currency()
{
Code = "MXN", Name = "peso"
}; Country Meksyk = new Country()
{
Name = "Meksyk", SubsistenceAllowance = 53, AccomodationLimit = 140, Currency = MXN, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Meksyk);
Currency MDL = new Currency()
{
Code = "MDL", Name = "lej"
}; Country Mołdawia = new Country()
{
Name = "Mołdawia", SubsistenceAllowance = 41, AccomodationLimit = 85, Currency = MDL, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Mołdawia);
Country Monako = new Country()
{
Name = "Monako", SubsistenceAllowance = 50, AccomodationLimit = 180, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Monako);
Currency MNT = new Currency()
{
Code = "MNT", Name = "tugrik"
}; Country Mongolia = new Country()
{
Name = "Mongolia", SubsistenceAllowance = 45, AccomodationLimit = 140, Currency = MNT, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Mongolia);
Country Holandia = new Country()
{
Name = "Holandia", SubsistenceAllowance = 50, AccomodationLimit = 130, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Holandia);
Country Niemcy = new Country()
{
Name = "Niemcy", SubsistenceAllowance = 49, AccomodationLimit = 150, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Niemcy);
Currency NGN = new Currency()
{
Code = "NGN", Name = "naira"
}; Country Nigeria = new Country()
{
Name = "Nigeria", SubsistenceAllowance = 46, AccomodationLimit = 240, Currency = NGN, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Nigeria);
Currency NOK = new Currency()
{
Code = "NOK", Name = "korona norweska"
}; Country Norwegia = new Country()
{
Name = "Norwegia", SubsistenceAllowance = 451, AccomodationLimit = 1500, Currency = NOK, LimitCurrency = NOK
}; context.Countries.AddOrUpdate(vt => vt.Name, Norwegia);
Currency NZD = new Currency()
{
Code = "NZD", Name = "dolar"
}; Country NowaZelandia = new Country()
{
Name = "Nowa Zelandia", SubsistenceAllowance = 58, AccomodationLimit = 180, Currency = NZD, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, NowaZelandia);
Currency OMR = new Currency()
{
Code = "OMR", Name = "rial"
}; Country Oman = new Country()
{
Name = "Oman", SubsistenceAllowance = 40, AccomodationLimit = 240, Currency = OMR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Oman);
Currency PKR = new Currency()
{
Code = "PKR", Name = "rupia"
}; Country Pakistan = new Country()
{
Name = "Pakistan", SubsistenceAllowance = 38, AccomodationLimit = 200, Currency = PKR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Pakistan);
Currency PAB = new Currency()
{
Code = "PAB", Name = "balboa"
}; Country Panama = new Country()
{
Name = "Panama", SubsistenceAllowance = 52, AccomodationLimit = 140, Currency = PAB, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Panama);
Currency PEN = new Currency()
{
Code = "PEN", Name = "nowy sol"
}; Country Peru = new Country()
{
Name = "Peru", SubsistenceAllowance = 50, AccomodationLimit = 150, Currency = PEN, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Peru);
Currency PLN = new Currency()
{
Code = "PLN", Name = "złoty"
}; Country Polska = new Country()
{
Name = "Polska", SubsistenceAllowance = 30, AccomodationLimit = 45, Currency = PLN, LimitCurrency = PLN
}; context.Countries.AddOrUpdate(vt => vt.Name, Polska);
Country Portugalia = new Country()
{
Name = "Portugalia", SubsistenceAllowance = 49, AccomodationLimit = 120, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Portugalia);
Currency ZAR = new Currency()
{
Code = "ZAR", Name = "rand"
}; Country RepublikaPołudniowejAfryki = new Country()
{
Name = "Republika Południowej Afryki", SubsistenceAllowance = 52, AccomodationLimit = 275, Currency = ZAR, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, RepublikaPołudniowejAfryki);
Currency RUB = new Currency()
{
Code = "RUB", Name = "rubel rosyjski"
}; Country Rosja = new Country()
{
Name = "Rosja", SubsistenceAllowance = 48, AccomodationLimit = 200, Currency = RUB, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Rosja);
Currency RON = new Currency()
{
Code = "RON", Name = "lej rumuński"
}; Country Rumunia = new Country()
{
Name = "Rumunia", SubsistenceAllowance = 38, AccomodationLimit = 100, Currency = RON, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Rumunia);
Country SanMarino = new Country()
{
Name = "San Marino", SubsistenceAllowance = 48, AccomodationLimit = 174, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, SanMarino);
Currency XOF = new Currency()
{
Code = "XOF", Name = "frank CFA"
}; Country Senegal = new Country()
{
Name = "Senegal", SubsistenceAllowance = 44, AccomodationLimit = 120, Currency = XOF, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Senegal);
Currency SGD = new Currency()
{
Code = "SGD", Name = "dolar"
}; Country Singapur = new Country()
{
Name = "Singapur", SubsistenceAllowance = 56, AccomodationLimit = 230, Currency = SGD, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Singapur);
Country Słowacja = new Country()
{
Name = "Słowacja", SubsistenceAllowance = 43, AccomodationLimit = 120, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Słowacja);
Country Słowenia = new Country()
{
Name = "Słowenia", SubsistenceAllowance = 41, AccomodationLimit = 130, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Słowenia);
Currency SYP = new Currency()
{
Code = "SYP", Name = "funt"
}; Country Syria = new Country()
{
Name = "Syria", SubsistenceAllowance = 50, AccomodationLimit = 150, Currency = SYP, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Syria);
Country Szwajcaria = new Country()
{
Name = "Szwajcaria", SubsistenceAllowance = 88, AccomodationLimit = 200, Currency = CHF, LimitCurrency = CHF
}; context.Countries.AddOrUpdate(vt => vt.Name, Szwajcaria);
Currency SEK = new Currency()
{
Code = "SEK", Name = "korona szwedzka"
}; Country Szwecja = new Country()
{
Name = "Szwecja", SubsistenceAllowance = 459, AccomodationLimit = 1800, Currency = SEK, LimitCurrency = SEK
}; context.Countries.AddOrUpdate(vt => vt.Name, Szwecja);
Currency TJS = new Currency()
{
Code = "TJS", Name = "somoni"
}; Country Tadżykistan = new Country()
{
Name = "Tadżykistan", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = TJS, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Tadżykistan);
Currency THB = new Currency()
{
Code = "THB", Name = "bat"
}; Country Tajlandia = new Country()
{
Name = "Tajlandia", SubsistenceAllowance = 42, AccomodationLimit = 110, Currency = THB, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Tajlandia);
Currency TZS = new Currency()
{
Code = "TZS", Name = "szyling"
}; Country Tanzania = new Country()
{
Name = "Tanzania", SubsistenceAllowance = 53, AccomodationLimit = 150, Currency = TZS, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Tanzania);
Currency TND = new Currency()
{
Code = "TND", Name = "dinar"
}; Country Tunezja = new Country()
{
Name = "Tunezja", SubsistenceAllowance = 37, AccomodationLimit = 100, Currency = TND, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Tunezja);
Currency TRY = new Currency()
{
Code = "TRY", Name = "lira turecka"
}; Country Turcja = new Country()
{
Name = "Turcja", SubsistenceAllowance = 53, AccomodationLimit = 173, Currency = TRY, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Turcja);
Currency UAH = new Currency()
{
Code = "UAH", Name = "hrywna ukraińska"
}; Country Ukraina = new Country()
{
Name = "Ukraina", SubsistenceAllowance = 41, AccomodationLimit = 180, Currency = UAH, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Ukraina);
Currency UYU = new Currency()
{
Code = "UYU", Name = "peso"
}; Country Urugwaj = new Country()
{
Name = "Urugwaj", SubsistenceAllowance = 50, AccomodationLimit = 80, Currency = UYU, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Urugwaj);
Country USA = new Country()
{
Name = "USA", SubsistenceAllowance = 59, AccomodationLimit = 200, Currency = USD, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, USA);
Country USANowyJork = new Country()
{
Name = "USA – Nowy Jork", SubsistenceAllowance = 59, AccomodationLimit = 350, Currency = USD, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, USANowyJork);
Country USAWaszyngton = new Country()
{
Name = "USA – Waszyngton", SubsistenceAllowance = 59, AccomodationLimit = 200, Currency = USD, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, USAWaszyngton);
Currency UZS = new Currency()
{
Code = "UZS", Name = "som"
}; Country Uzbekistan = new Country()
{
Name = "Uzbekistan", SubsistenceAllowance = 41, AccomodationLimit = 140, Currency = UZS, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Uzbekistan);
Currency VEF = new Currency()
{
Code = "VEF", Name = "boliwar"
}; Country Wenezuela = new Country()
{
Name = "Wenezuela", SubsistenceAllowance = 60, AccomodationLimit = 220, Currency = VEF, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Wenezuela);
Currency HUF = new Currency()
{
Code = "HUF", Name = "forint węgierski"
}; Country Węgry = new Country()
{
Name = "Węgry", SubsistenceAllowance = 44, AccomodationLimit = 130, Currency = HUF, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Węgry);
Currency GBP = new Currency()
{
Code = "GBP", Name = "funt brytyjski"
}; Country WielkaBrytania = new Country()
{
Name = "Wielka Brytania", SubsistenceAllowance = 35, AccomodationLimit = 200, Currency = GBP, LimitCurrency = GBP
}; context.Countries.AddOrUpdate(vt => vt.Name, WielkaBrytania);
Currency VND = new Currency()
{
Code = "VND", Name = "dong"
}; Country Wietnam = new Country()
{
Name = "Wietnam", SubsistenceAllowance = 53, AccomodationLimit = 160, Currency = VND, LimitCurrency = USD
}; context.Countries.AddOrUpdate(vt => vt.Name, Wietnam);
Country Włochy = new Country()
{
Name = "Włochy", SubsistenceAllowance = 48, AccomodationLimit = 174, Currency = EUR, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Włochy);
Country WybrzeżeKościSłoniowej = new Country()
{
Name = "Wybrzeże Kości Słoniowej", SubsistenceAllowance = 33, AccomodationLimit = 100, Currency = XOF, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, WybrzeżeKościSłoniowej);
Currency ZWD = new Currency()
{
Code = "ZWD", Name = "dolar"
}; Country Zimbabwe = new Country()
{
Name = "Zimbabwe", SubsistenceAllowance = 39, AccomodationLimit = 90, Currency = ZWD, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, Zimbabwe);
Currency AED = new Currency()
{
Code = "AED", Name = "dirham"
}; Country ZjednoczoneEmiratyArabskie = new Country()
{
Name = "Zjednoczone Emiraty Arabskie", SubsistenceAllowance = 39, AccomodationLimit = 200, Currency = AED, LimitCurrency = EUR
}; context.Countries.AddOrUpdate(vt => vt.Name, ZjednoczoneEmiratyArabskie);
}
public DictionariesRepository(BusinessTripsContext _context)
{
this.context = _context;
}
