private void AddRegionAndCityIdZero(Guid idCompany, trustmeContext context)
{
var currentCompany = context.Companies.FirstOrDefault(c => c.Id == idCompany);
currentCompany.RegionId = 18;
currentCompany.CityId = 86;
context.SaveChanges();
}
private void AddRegionAndCityId(Guid uuidCompany, string[] address, trustmeContext context)
{
var currentCompany = context.Companies.FirstOrDefault(c => c.Id == uuidCompany);
try
{
if (address.Length < 3) // только область
{
currentCompany.RegionId = context.Regions.FirstOrDefault(r => r.Name == address[0]).Id;
currentCompany.CityId = 86;
context.SaveChanges();
}
else // область и город/район
{
if (address[1] != "Район") // область и город
{
Console.WriteLine("address[0]" + address[0]);
Console.WriteLine("address[1]" + address[address.Length - 1]);
foreach (var region in context.Regions.OrderBy(r => r.Id))
{
Console.WriteLine(region.Name);
}
currentCompany.RegionId = context.Regions.FirstOrDefault(r => r.Name == address[0]).Id;
currentCompany.CityId = FindCityId(address[1], context);
context.SaveChanges();
}
else // область и район
{
currentCompany.RegionId = context.Regions.FirstOrDefault(r => r.Name == address[0]).Id;
currentCompany.CityId = 86;
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
private void AddRegionAndCityId(Guid uuidCompany, string[] address, trustmeContext context)
{
string noRegionsFound = Directory.GetCurrentDirectory() + "\\noRegionsFound.txt";
string noCityFound = Directory.GetCurrentDirectory() + "\\noCityFound.txt";
string exc = Directory.GetCurrentDirectory() + "\\exc.txt";
var currentCompany = context.Companies.FirstOrDefault(c => c.Id == uuidCompany);
string region = null;
try
{
if (address.Length < 3) // только область
{
region = context.Regions.FirstOrDefault(r => r.Name == address[0]).Name;
if (region == null)
{
System.IO.File.AppendAllText(noRegionsFound, currentCompany.Id + "\n");
System.IO.File.AppendAllText(noRegionsFound, address[address.Length - 1] + "\n\n");
}
else
{
currentCompany.RegionId = context.Regions.FirstOrDefault(r => r.Name == address[0]).Id;
currentCompany.CityId = 86;
context.SaveChanges();
}
}
else // область и город/район
{
if (address[1] != "Район") // область и город
{
region = context.Regions.FirstOrDefault(r => r.Name == address[0]).Name;
if (region == null)
{
System.IO.File.AppendAllText(noRegionsFound, currentCompany.Id + "\n");
System.IO.File.AppendAllText(noRegionsFound, address[address.Length - 1] + "\n\n");
}
else
{
currentCompany.RegionId = context.Regions.FirstOrDefault(r => r.Name == address[0]).Id;
}
int cityId = FindCityId(address[1], context);
if (cityId == 86)
{
System.IO.File.AppendAllText(noCityFound, currentCompany.Id + "\n");
System.IO.File.AppendAllText(noCityFound, address[address.Length - 1] + "\n\n");
}
else
{
currentCompany.CityId = cityId;
context.SaveChanges();
}
}
else // область и район
{
region = context.Regions.FirstOrDefault(r => r.Name == address[0]).Name;
if (region == null)
{
System.IO.File.AppendAllText(noRegionsFound, currentCompany.Id + "\n");
System.IO.File.AppendAllText(noRegionsFound, address[address.Length - 1] + "\n\n");
}
else
{
currentCompany.RegionId = context.Regions.FirstOrDefault(r => r.Name == address[0]).Id;
}
currentCompany.CityId = 86;
context.SaveChanges();
}
}
}
catch (Exception ex)
{
System.IO.File.AppendAllText(exc, currentCompany.Id + "\n");
System.IO.File.AppendAllText(exc, ex.Message + "\n\n");
Console.WriteLine(ex);
}
}
