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); } }