public LoggerService(PhysicalPersonsContext db)
{
_db = db;
}
public static void Initialize(IServiceProvider serviceProvider)
{
try
{
using (var context = new PhysicalPersonsContext(serviceProvider.GetRequiredService <DbContextOptions <PhysicalPersonsContext> >()))
{
if (context.Genders.Any())
{
return;
}
context.Genders.AddRange
(
new Gender {
Id = (int)_Gender.Male, GenderName = RsStrings.Male
},
new Gender {
Id = (int)_Gender.Female, GenderName = RsStrings.Female
}
);
context.PhoneTypes.AddRange
(
new PhoneType {
Id = (int)_PhoneType.Mobile, PhoneTypeName = RsStrings.Mobile
},
new PhoneType {
Id = (int)_PhoneType.Office, PhoneTypeName = RsStrings.Office
},
new PhoneType {
Id = (int)_PhoneType.Home, PhoneTypeName = RsStrings.Home
}
);
context.RelationTypes.AddRange
(
new RelationType {
Id = (int)_RelationType.Colleague, RelationTypeName = RsStrings.Colleague
},
new RelationType {
Id = (int)_RelationType.Familiar, RelationTypeName = RsStrings.Familiar
},
new RelationType {
Id = (int)_RelationType.Relative, RelationTypeName = RsStrings.Relative
},
new RelationType {
Id = (int)_RelationType.Other, RelationTypeName = RsStrings.Other
}
);
context.Citys.AddRange
(
new City {
CityName = RsStrings.Tbilisi
},
new City {
CityName = RsStrings.Batumi
},
new City {
CityName = RsStrings.Kutaisi
},
new City {
CityName = RsStrings.Rustavi
},
new City {
CityName = RsStrings.Gori
},
new City {
CityName = RsStrings.Zugdidi
},
new City {
CityName = RsStrings.Poti
},
new City {
CityName = RsStrings.Sighnaghi
}
);
context.SaveChanges();
context.Persons.AddRange(
new Person
{
Fname = "ხვიჩა",
Lname = "ჭელიძე",
PersonalNumber = "12345678911",
BirthDate = DateTime.Now.AddYears(-50),
GenderId = (int)_Gender.Male,
CityId = context.Citys.Where(t => t.CityName == RsStrings.Tbilisi).Select(t => t.Id).FirstOrDefault(),
PersonPhones = new List <PersonPhone>()
{
new PersonPhone {
PhoneNumber = "598504343", PhoneTypeId = (int)_PhoneType.Mobile
},
new PersonPhone {
PhoneNumber = "0322252525", PhoneTypeId = (int)_PhoneType.Home
}
}
},
new Person
{
Fname = "გოჩა",
Lname = "ბანძელაძე",
PersonalNumber = "12345678922",
BirthDate = DateTime.Now.AddYears(-55),
GenderId = (int)_Gender.Male,
CityId = context.Citys.Where(t => t.CityName == RsStrings.Tbilisi).Select(t => t.Id).FirstOrDefault(),
PersonPhones = new List <PersonPhone>()
{
new PersonPhone {
PhoneNumber = "598505343", PhoneTypeId = (int)_PhoneType.Mobile
},
new PersonPhone {
PhoneNumber = "0322404040", PhoneTypeId = (int)_PhoneType.Office
}
}
},
new Person
{
Fname = "ნათია",
Lname = "მელაძე",
PersonalNumber = "12345678933",
BirthDate = DateTime.Now.AddYears(-59),
GenderId = (int)_Gender.Male,
CityId = context.Citys.Where(t => t.CityName == RsStrings.Batumi).Select(t => t.Id).FirstOrDefault(),
PersonPhones = new List <PersonPhone>()
{
new PersonPhone {
PhoneNumber = "598555343", PhoneTypeId = (int)_PhoneType.Mobile
}
}
},
new Person
{
Fname = "ქეთი",
Lname = "მაღლაკელიძე",
PersonalNumber = "12345678944",
BirthDate = DateTime.Now.AddYears(-59),
GenderId = (int)_Gender.Male,
CityId = context.Citys.Where(t => t.CityName == RsStrings.Kutaisi).Select(t => t.Id).FirstOrDefault(),
PersonPhones = new List <PersonPhone>()
{
new PersonPhone {
PhoneNumber = "598565343", PhoneTypeId = (int)_PhoneType.Mobile
},
new PersonPhone {
PhoneNumber = "0322888888", PhoneTypeId = (int)_PhoneType.Office
},
new PersonPhone {
PhoneNumber = "0322555555", PhoneTypeId = (int)_PhoneType.Home
}
}
});
context.SaveChanges();
context.RelatedPersons.AddRange
(
new RelatedPerson
{
PersonId = context.Persons.Where(t => t.Fname == "ხვიჩა").Select(t => t.Id).FirstOrDefault(),
RelatedPersonId = context.Persons.Where(t => t.Fname == "გოჩა").Select(t => t.Id).FirstOrDefault(),
RelationTypeId = (int)_RelationType.Familiar
},
new RelatedPerson
{
PersonId = context.Persons.Where(t => t.Fname == "ხვიჩა").Select(t => t.Id).FirstOrDefault(),
RelatedPersonId = context.Persons.Where(t => t.Fname == "ნათია").Select(t => t.Id).FirstOrDefault(),
RelationTypeId = (int)_RelationType.Colleague
},
new RelatedPerson
{
PersonId = context.Persons.Where(t => t.Fname == "ხვიჩა").Select(t => t.Id).FirstOrDefault(),
RelatedPersonId = context.Persons.Where(t => t.Fname == "ქეთი").Select(t => t.Id).FirstOrDefault(),
RelationTypeId = (int)_RelationType.Relative
},
new RelatedPerson
{
PersonId = context.Persons.Where(t => t.Fname == "გოჩა").Select(t => t.Id).FirstOrDefault(),
RelatedPersonId = context.Persons.Where(t => t.Fname == "ქეთი").Select(t => t.Id).FirstOrDefault(),
RelationTypeId = (int)_RelationType.Colleague
}
);
context.SaveChanges();
}
}
catch (Exception ex)
{
}
}
public LoggerManager(PhysicalPersonsContext db)
{
_db = db;
}
public PersonService(PhysicalPersonsContext db, IConfiguration configuration)
{
_db = db;
Configuration = configuration;
}
