private static void AdaugaJudete(AnabiContext context)
{
var judete = new CountyDb[]
{
new CountyDb()
{
Abreviation = "B", Name = "Bucuresti"
},
new CountyDb()
{
Abreviation = "AB", Name = "Alba Iulia"
},
new CountyDb()
{
Abreviation = "CT", Name = "Constanta"
},
new CountyDb()
{
Abreviation = "BV", Name = "Brasov"
},
new CountyDb()
{
Abreviation = "SB", Name = "Sibiu"
}
};
context.Judete.AddRange(judete);
context.SaveChanges();
}
public static void AddStages(AnabiContext context)
{
var etape = new[]
{
new StageDb {
Name = "Confiscare", IsFinal = false, StageCategory = Common.Enums.StageCategory.Confiscation, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new StageDb {
Name = "Valorificare anticipata", IsFinal = true, StageCategory = Common.Enums.StageCategory.Recovery, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new StageDb {
Name = "Sechestru", IsFinal = false, StageCategory = Common.Enums.StageCategory.Sequester, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new StageDb {
Name = "Valorificare standard", IsFinal = true, StageCategory = Common.Enums.StageCategory.Recovery, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new StageDb {
Name = "Ridicare sechestru", IsFinal = false, StageCategory = Common.Enums.StageCategory.LiftingSeizure, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new StageDb {
Name = "Reutilizare sociala", IsFinal = false, StageCategory = Common.Enums.StageCategory.SocialReuse, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new StageDb {
Name = "Administrare simpla", IsFinal = false, StageCategory = Common.Enums.StageCategory.SimpleAdministration, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
};
context.Stages.AddRange(etape);
context.SaveChanges();
}
public static void Initialize(AnabiContext context)
{
context.Database.EnsureCreated();
if (context.Judete.Any())
{
return; // DB has been seeded
}
AdaugaJudete(context);
AdaugaCategorii(context);
AdaugaEtape(context);
AdaugareDecizii(context);
AdaugaEtapePentruDecizii(context);
AdaugaUtilizatori(context);
AdaugaAdrese(context);
AdaugaInstitutii(context);
AdaugaPersoane(context);
AdaugaDosareSiNumere(context);
AdaugaInculpatiDosare(context);
AdaugaBun(context);
AdaugaEtapeIstorice(context);
AdaugaBunuriDosare(context);
AdaugaSpatiiStocare(context);
AdaugaBunuriSpatiiStocare(context);
}
private static void AdaugaEtapePentruDecizii(AnabiContext context)
{
var etapePtDecizie = new StagesForDecisionDb[]
{
new StagesForDecisionDb()
{
DecisionId = 1, StageId = 1
},
new StagesForDecisionDb()
{
DecisionId = 1, StageId = 2
},
new StagesForDecisionDb()
{
DecisionId = 1, StageId = 3
},
new StagesForDecisionDb()
{
DecisionId = 2, StageId = 1
},
new StagesForDecisionDb()
{
DecisionId = 2, StageId = 2
},
new StagesForDecisionDb()
{
DecisionId = 2, StageId = 3
}
};
context.EtapePentruDecizii.AddRange(etapePtDecizie);
context.SaveChanges();
}
private static void AdaugaCategorii(AnabiContext context)
{
var categorii = new CategoryDb[]
{
new CategoryDb()
{
ForEntity = "bun", Code = "Bunuri Mobile", Description = "Bunuri care pot fi ridicate"
},
new CategoryDb()
{
ForEntity = "bun", Code = "Bunuri Imobile", Description = "Bunuri care nu pot fi ridicate"
},
new CategoryDb()
{
ForEntity = "bun", Code = "Bani", Description = "Bani"
},
new CategoryDb()
{
ForEntity = "institutie", Code = "Instanta", Description = ""
},
new CategoryDb()
{
ForEntity = "institutie", Code = "Parchet"
}
};
context.Categorii.AddRange(categorii);
context.SaveChanges();
}
public static void AddUsers(AnabiContext context)
{
var utilizatori = new[]
{
new UserDb
{
UserCode = "pop",
Email = "*****@*****.**",
Name = "Pop Mihai",
Role = "Admin",
Password = "******",
Salt = "sarea",
IsActive = true
},
new UserDb()
{
UserCode = "admin",
IsActive = true,
Email = "*****@*****.**",
Name = "Admin",
Password = "******",
Role = "admin",
Salt = "salt"
}
};
context.Users.AddRange(utilizatori);
context.SaveChanges();
}
private static void AdaugaEtapeIstorice(AnabiContext context)
{
var etapeIstorice = new HistoricalStageDb[]
{
new HistoricalStageDb()
{
AssetId = 1, StageId = 1, DecizieId = 1, InstitutionId = 1,
EstimatedAmount = 132000,
EstimatedAmountCurrency = "EUR",
UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 2, 3),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 5),
LegalBasis = "Temei serios",
DecisionNumber = "12312AA",
DecisionDate = new DateTime(2017, 2, 5)
},
new HistoricalStageDb()
{
AssetId = 2, StageId = 2, DecizieId = 2, InstitutionId = 1,
EstimatedAmount = 176000,
EstimatedAmountCurrency = "USD",
UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 2, 3),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 5),
LegalBasis = "Temei serios 2",
DecisionNumber = "12877HH",
DecisionDate = new DateTime(2017, 4, 6)
}
};
context.EtapeIstorice.AddRange(etapeIstorice);
context.SaveChanges();
}
private static void AdaugaBun(AnabiContext context)
{
var bunuri = new AssetDb[]
{
new AssetDb()
{
AddressId = 1,
CategoryId = 1,
CurrentStageId = 1,
DecisionId = 1,
IsDeleted = false,
UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 2, 3),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 5)
},
new AssetDb()
{
AddressId = 2,
CategoryId = 2,
CurrentStageId = 1,
DecisionId = 1,
IsDeleted = false,
UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 3, 5),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 15)
}
};
context.Bunuri.AddRange(bunuri);
context.SaveChanges();
}
private static void AdaugaBunuriDosare(AnabiContext context)
{
var bunuriDosare = new AssetsFileDb[]
{
new AssetsFileDb()
{
AssetId = 1,
FileId = 1,
UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 2, 3),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 5)
},
new AssetsFileDb()
{
AssetId = 2,
FileId = 2,
UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 4, 3),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 25)
}
};
context.BunuriDosare.AddRange(bunuriDosare);
context.SaveChanges();
}
private static void AdaugaUtilizatori(AnabiContext context)
{
var utilizatori = new UserDb[] {
new UserDb()
{
UserCode = "pop",
Email = "*****@*****.**",
Name = "Pop Mihai",
Role = "Admin",
Password = "******",
Salt = "sarea",
IsActive = true
},
new UserDb()
{
UserCode = "maria",
Email = "*****@*****.**",
Name = "Maria Ionescu",
Password = "******",
Salt = "sarea",
Role = "SuperUser",
IsActive = true
}
};
context.Utilizatori.AddRange(utilizatori);
context.SaveChanges();
}
private static void AdaugaBunuriSpatiiStocare(AnabiContext context)
{
var bunurispatiiStocare = new AssetStorageSpaceDb[]
{
new AssetStorageSpaceDb()
{
AssetId = 1,
StorageSpaceId = 1,
EntryDate = new DateTime(2017, 1, 3),
UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 1, 6)
},
new AssetStorageSpaceDb()
{
AssetId = 2,
StorageSpaceId = 2,
EntryDate = new DateTime(2017, 2, 4),
UserCodeAdd = "maria",
AddedDate = new DateTime(2017, 2, 8)
}
};
context.BunuriSpatiiStocare.AddRange(bunurispatiiStocare);
context.SaveChanges();
}
private static void AddInstitutions(AnabiContext context)
{
var result = InstitutionImporter.Deserialize();
var institutions = result.Select(i => new InstitutionDb
{
BusinessId = i.Id,
Name = i.Name,
AddedDate = DateTime.Now,
UserCodeAdd = "admin"
}).ToList();
context.Institutions.AddRange(institutions);
context.SaveChanges();
}
public static void InitializeFullDb(AnabiContext context)
{
if (context.Counties.Any())
{
return; // DB has been seeded
}
AddCounties(context);
AddCategories(context);
AddStages(context);
AddDecisions(context);
AddUsers(context);
AddRecoveryBeneficiaries(context);
AddCrimeTypes(context);
AddInstitutions(context);
AddIdentifiers(context);
}
private static void AdaugareDecizii(AnabiContext context)
{
var decizii = new DecisionDb[]
{
new DecisionDb()
{
Name = "Hotarare"
},
new DecisionDb()
{
Name = "Ordonanta"
}
};
context.Decizii.AddRange(decizii);
context.SaveChanges();
}
private static void AdaugaInstitutii(AnabiContext context)
{
var institutii = new InstitutionDb[]
{
new InstitutionDb()
{
AddressId = 1, CategoryId = 4, UserCodeAdd = "pop", AddedDate = new DateTime(2017, 1, 2), Name = "Parchetul din Iasi"
},
new InstitutionDb()
{
AddressId = 2, CategoryId = 5, UserCodeAdd = "pop", AddedDate = new DateTime(2017, 2, 3), Name = "Instanta din Craiova"
}
};
context.Institutii.AddRange(institutii);
context.SaveChanges();
}
private static void AdaugaPersoane(AnabiContext context)
{
var persoane = new PersonDb[]
{
new PersonDb()
{
Name = "Popescu Gigi", IsPerson = true, Identification = "11122336658", AddressId = 1, UserCodeAdd = "pop", AddedDate = new DateTime(2017, 1, 1), IdNumber = "122345", IdSerie = "RR"
},
new PersonDb()
{
Name = "SC Alfa si Omega SRL", IsPerson = false, Identification = "1231123", AddressId = 2, UserCodeAdd = "pop", AddedDate = new DateTime(2017, 1, 1)
}
};
context.Persoane.AddRange(persoane);
context.SaveChanges();
}
public static void AddDecisions(AnabiContext context)
{
var decizii = new[]
{
new DecisionDb {
Name = "Hotarare", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new DecisionDb {
Name = "Ordonanta", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new DecisionDb {
Name = "Adresa", UserCodeAdd = "admin", AddedDate = DateTime.Now
}
};
context.Decisions.AddRange(decizii);
context.SaveChanges();
}
public static void AddIdentifiers(AnabiContext context)
{
var identifiers = new[]
{
new IdentifierDb {
IdentifierType = "Pasaport", IsForPerson = true, AddedDate = DateTime.Now, UserCodeAdd = "admin"
},
new IdentifierDb {
IdentifierType = "CI", IsForPerson = true, AddedDate = DateTime.Now, UserCodeAdd = "admin"
},
new IdentifierDb {
IdentifierType = "CUI", IsForPerson = false, AddedDate = DateTime.Now, UserCodeAdd = "admin"
},
};
context.Identifiers.AddRange(identifiers);
context.SaveChanges();
}
private static void AddInstitutions(AnabiContext context)
{
var categoryForInstitutionId = context.Categories.Where(c => c.ForEntity == "institutie" && c.Code == "Instanta").FirstOrDefault()?.Id;
var insitutions = new []
{
new InstitutionDb
{
Name = "Curtea de Apel Alba Iulia",
ContactData = "Some contact here",
AddedDate = DateTime.Now,
UserCodeAdd = "admin",
}
};
context.Institutions.AddRange(insitutions);
context.SaveChanges();
}
private static void AdaugaSpatiiStocare(AnabiContext context)
{
var spatiiStocare = new StorageSpaceDb[]
{
new StorageSpaceDb()
{
AddressId = 1,
Name = "Spatiul de stocare 1"
},
new StorageSpaceDb()
{
AddressId = 2,
Name = "Spatiul de stocare 2"
}
};
context.SpatiiStocare.AddRange(spatiiStocare);
context.SaveChanges();
}
public static void AddCrimeTypes(AnabiContext context)
{
var infractiuni = new[]
{
new CrimeTypeDb {
CrimeName = "Furt calificat", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CrimeTypeDb {
CrimeName = "Spalare bani", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CrimeTypeDb {
CrimeName = "Coruptie", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CrimeTypeDb {
CrimeName = "Altele", UserCodeAdd = "admin", AddedDate = DateTime.Now
}
};
context.CrimeTypes.AddRange(infractiuni);
context.SaveChanges();
}
private static void AdaugaEtape(AnabiContext context)
{
var etape = new StageDb[]
{
new StageDb()
{
Name = "Confiscare", IsFinal = false
},
new StageDb()
{
Name = "Valorificare", IsFinal = true
},
new StageDb()
{
Name = "Sechestru", IsFinal = false
}
};
context.Etape.AddRange(etape);
context.SaveChanges();
}
private static void AdaugaAdrese(AnabiContext context)
{
var adrese = new AddressDb[]
{
new AddressDb()
{
Street = "Pantelimon nr 23", Building = "Bloc 1", CountyId = 1, City = "Bucuresti"
},
new AddressDb()
{
Street = "Iancului 22", Building = "Blco 102S", CountyId = 1, City = "Bucuresti"
},
new AddressDb()
{
Street = "O strada 22", Building = "Bloc 13", CountyId = 3, City = "Constanta"
}
};
context.Adrese.AddRange(adrese);
context.SaveChanges();
}
private static void AdaugaInculpatiDosare(AnabiContext context)
{
var inculpatiDosar = new DefendantsFileDb[]
{
new DefendantsFileDb()
{
PersonId = 1, FileId = 1, UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 2, 3),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 5)
},
new DefendantsFileDb()
{
PersonId = 2, FileId = 2, UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 2, 3),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 5)
}
};
context.InculpatiDosar.AddRange(inculpatiDosar);
context.SaveChanges();
}
public static void AddRecoveryBeneficiaries(AnabiContext context)
{
var beneficiari = new[]
{
new RecoveryBeneficiaryDb {
Name = "Ministerul Educaţiei Naţionale şi Cercetării Ştiinţifice", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new RecoveryBeneficiaryDb {
Name = "Ministerul Sănătăţii", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new RecoveryBeneficiaryDb {
Name = "Ministerul Afacerilor Interne", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new RecoveryBeneficiaryDb {
Name = "Ministerul Public", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new RecoveryBeneficiaryDb {
Name = "Ministerul Justiţiei", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
};
context.RecoveryBeneficiaries.AddRange(beneficiari);
context.SaveChanges();
}
public static void AddCounties(AnabiContext context)
{
var judete = new[]
{
new CountyDb {
Abreviation = "AB", Name = "ALBA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "AR", Name = "ARAD", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "AG", Name = "ARGEȘ", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "BC", Name = "BACĂU", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "BH", Name = "BIHOR", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "BN", Name = "BISTRIȚA-NĂSĂUD", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "BT", Name = "BOTOȘANI", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "BV", Name = "BRAȘOV", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "BR", Name = "BRĂILA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "B", Name = "BUCUREȘTI", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "BZ", Name = "BUZĂU", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "CS", Name = "CARAȘ-SEVERIN", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "CL", Name = "CĂLĂRAȘI", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "CJ", Name = "CLUJ", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "CT", Name = "CONSTANȚA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "CV", Name = "COVASNA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "DB", Name = "DÂMBOVIȚA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "DJ", Name = "DOLJ", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "GL", Name = "GALAȚI", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "GR", Name = "GIURGIU", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "GJ", Name = "GORJ", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "HR", Name = "HARGHITA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "HD", Name = "HUNEDOARA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "IL", Name = "IALOMIȚA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "IS", Name = "IAȘI", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "IF", Name = "ILFOV", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "MM", Name = "MARAMUREȘ", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "MH", Name = "MEHEDINȚI", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "MS", Name = "MUREȘ", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "NT", Name = "NEAMȚ", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "OT", Name = "OLT", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "PH", Name = "PRAHOVA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "SM", Name = "SATU MARE", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "SJ", Name = "SĂLAJ", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "SB", Name = "SIBIU", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "SV", Name = "SUCEAVA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "TR", Name = "TELEORMAN", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "TM", Name = "TIMIȘ", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "TL", Name = "TULCEA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "VS", Name = "VASLUI", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "VL", Name = "VÂLCEA", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CountyDb {
Abreviation = "VN", Name = "VRANCEA", UserCodeAdd = "admin", AddedDate = DateTime.Now
}
};
context.Counties.AddRange(judete);
context.SaveChanges();
}
private static void AdaugaDosareSiNumere(AnabiContext context)
{
var dosare = new FileDb[]
{
new FileDb()
{
//NumarDosarInitialId = 1,
InitialNumber = new FileNumberDb()
{
FileNumber = "Z100000", InstitutionId = 1, NumberDate = new DateTime(2017, 2, 3), UserCodeAdd = "pop", AddedDate = new DateTime(2017, 2, 5)
},
InitialFileNumber = "Z100000",
//NumarDosarCurentId = 2,
CurrentNumber = new FileNumberDb()
{
FileNumber = "XC3450000", InstitutionId = 2, NumberDate = new DateTime(2017, 4, 5), UserCodeAdd = "pop", AddedDate = new DateTime(2017, 4, 8)
},
CurrentFileNumber = "XC3450000",
DamageAmount = 145000,
DamageCurrency = "EUR",
LegalClassification = "Spalare de bani",
CriminalField = "Frauda",
UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 2, 3),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 5)
},
new FileDb()
{
InitialFileId = 3,
InitialNumber = new FileNumberDb()
{
FileNumber = "T450000", InstitutionId = 1, NumberDate = new DateTime(2017, 2, 3), UserCodeAdd = "pop", AddedDate = new DateTime(2017, 2, 5)
},
InitialFileNumber = "T450000",
CurrentFileNumberId = 4,
CurrentNumber = new FileNumberDb()
{
FileNumber = "Y644009", InstitutionId = 2, NumberDate = new DateTime(2017, 4, 5), UserCodeAdd = "pop", AddedDate = new DateTime(2017, 4, 8)
},
CurrentFileNumber = "Y644009",
DamageAmount = 356000,
DamageCurrency = "USD",
LegalClassification = "Evaziune fiscala",
CriminalField = "Frauda",
UserCodeAdd = "pop",
AddedDate = new DateTime(2017, 2, 3),
UserCodeLastChange = "maria",
LastChangeDate = new DateTime(2017, 4, 5)
}
};
context.Dosare.AddRange(dosare);
context.SaveChanges();
}
public static void AddCategories(AnabiContext context)
{
var mobile = new CategoryDb {
ForEntity = "bun", Code = "Bunuri Mobile",
Description = "Bunuri care pot fi ridicate", UserCodeAdd = "admin", AddedDate = DateTime.Now
};
context.Categories.Add(mobile);
context.SaveChanges();
var idBunuriMobile = mobile.Id;
var imobile = new CategoryDb {
ForEntity = "bun", Code = "Bunuri Imobile",
Description = "Bunuri care nu pot fi ridicate",
UserCodeAdd = "admin",
AddedDate = DateTime.Now
};
context.Categories.Add(imobile);
context.SaveChanges();
var idBunuriImobile = imobile.Id;
var bani = new CategoryDb {
ForEntity = "bun", Code = "Bani", Description = "Bani", UserCodeAdd = "admin", AddedDate = DateTime.Now
};
context.Categories.Add(bani);
context.SaveChanges();
var idBani = bani.Id;
var categorii = new[]
{
new CategoryDb {
ForEntity = "institutie", Code = "Instanta", Description = "", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "institutie", Code = "Parchet", UserCodeAdd = "admin", AddedDate = DateTime.Now
},
//Subcategorii
new CategoryDb {
ForEntity = "bun", Code = "Autovehicule", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Autoutilitare", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Aparate de zbor", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Ambarcatiuni", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Actiuni si parti sociale", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Bunuri accizabile", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Textile", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Masa lemnoasa", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Aparatura electronica si electrocasnica", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Telefonie mobila", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Animale", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Bunuri IT", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Creante", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Aur, bijuterii si metale pretioase", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Echipamente", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Instalatii", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Droguri", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Arme si munitie", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Articole pirotehnice", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Corpuri delicte", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Alte bunuri mobile", ParentId = idBunuriMobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Apartamente", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Casa", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Casa cu teren", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Casa cu anexa", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Casa cu teren si anexa", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Teren", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Teren cu constructie", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Teren cu anexa", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Teren cu constructie si anexa", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Bloc de locuinte", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Constructie", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Cladire", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Garaj/Parcare", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Restaurant/Motel/Hotel/Pensiuni", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Spatiu comercial", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Alte bunuri imobile", ParentId = idBunuriImobile, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Conturi", ParentId = idBani, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Moneda virtuala", ParentId = idBani, UserCodeAdd = "admin", AddedDate = DateTime.Now
},
new CategoryDb {
ForEntity = "bun", Code = "Cash", ParentId = idBani, UserCodeAdd = "admin", AddedDate = DateTime.Now
}
};
context.Categories.AddRange(categorii);
context.SaveChanges();
}
