public SearchController(CemeteryContext context)
{
db = context;
}
public UnitOfWork(CemeteryContext context)
{
_context = context;
DeathRecords = new DeathRecordRepository(_context);
}
public DeathRecordRepository(CemeteryContext context)
: base(context)
{
}
public CemeteriesController(CemeteryContext context)
{
db = context;
}
public PlacesController(CemeteryContext context)
{
db = context;
}
public SectorsController(CemeteryContext context)
{
db = context;
}
public static void Initialize(CemeteryContext context)
{
if (context.Roles.Any())
{
return;
}
var role = new AspNetRole
{
Name = "admin"
};
context.Roles.Add(role);
context.SaveChanges();
var user = new AspNetUser
{
UserName = "******",
PasswordHash = "demo",
Role = role
};
context.Users.Add(user);
context.SaveChanges();
var cem = new Cemetery
{
Address = "Воронино посёлок, 1",
Name = "Кладбище Воронино",
CreateDate = DateTime.Now,
ChangeDate = DateTime.Now,
imgs = new string[] { "assets/images/img.jpg", "assets/images/img1.jpg", "assets/images/img2.jpg" }
};
context.Cemeteries.Add(cem);
context.SaveChanges();
var sector = new Sector
{
SectorName = "35",
CreateDate = DateTime.Now,
ChangeDate = DateTime.Now,
Cemetery = cem,
Imgs = new string[] { "assets/images/img.jpg", "assets/images/img1.jpg", "assets/images/img2.jpg" }
};
context.Sectors.Add(sector);
context.SaveChanges();
for (int i = 1; i <= 224; i++)
{
var place = new Place
{
CreateDate = DateTime.Now,
ChangeDate = DateTime.Now,
Sector = sector,
Number = i,
Status = "вменяемое",
PlaceType = "хозяйственное",
SoilType = "глина твёрдая",
Imgs = new string[] { "assets/images/img.jpg", "assets/images/img1.jpg", "assets/images/img2.jpg" }
};
context.Places.Add(place);
}
context.SaveChanges();
var textData = File.ReadAllLines(@"cemetery_data.txt");
foreach (var line in textData)
{
var data = line.Split(" ");
// deathdate
var ddstr = data[5].Split(".");
DateTime dd = new DateTime(
int.Parse(ddstr[2]),
int.Parse(ddstr[1]),
int.Parse(ddstr[0])
);
// birthdate
var bdstr = data[4].Split(".");
DateTime bd = new DateTime(
int.Parse(bdstr[2]),
int.Parse(bdstr[1]),
int.Parse(bdstr[0])
);
var burial = new Burial
{
// FullName = data[1] + " " + data[2] + " " + data[3],
Surname = data[1],
Name = data[2],
Patronymic = data[3],
DeathDate = dd,
BirthDate = bd,
BurialDate = bd,
CreateDate = DateTime.Now,
FuneralUrn = "нет",
Place = context.Places.FirstOrDefault(p => p.Number == int.Parse(data[0])),
imgs = new string[] { "assets/images/img.jpg", "assets/images/img1.jpg", "assets/images/img2.jpg" }
};
context.Burials.Add(burial);
var other = new Other()
{
PersonKey = burial.Id,
GraveDepth = 2.123,
DateOfReference = bd,
RegistrationAddress = "Томский ЗАГС",
SoilType = "хорошее",
CertificateNumber = "СВ-123456",
ArchivedNumber = (new Random()).Next(10000),
};
context.Others.Add(other);
var relat = new Relative()
{
RelativeFullName = "Chelpa", Address = "Baker st., 7", Contacts = "89002281488", PersonKey = burial.Id
};
context.Relatives.Add(relat);
}
context.SaveChanges();
}
public IReadOnlyCollection <Corpses> Get()
{
using (var context = new CemeteryContext())
return(context.Corpses.ToList());
}
public BurialsController(CemeteryContext context)
{
db = context;
}
