private static StreetCollection ParseStreets(string path)
{
StreamReader streamReader = new StreamReader(path);
XmlSerializer serializer = new XmlSerializer(typeof(StreetCollection));
GovDataReader govDataReader = new GovDataReader(streamReader, serializer);
StreetCollection streetCollection = govDataReader.ParseStreets();
return(streetCollection);
}
private void addStreet_Click(object sender, RoutedEventArgs e)
{
AddStreet addStreet = new AddStreet(streets);
addStreet.Owner = this.Owner;
if (addStreet.ShowDialog() == true)
{
streets = addStreet.streets;
Owner.streets = streets;
}
}
private void open_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "*.xml|*.xml";
if (ofd.ShowDialog() == true)
{
FileStream fs = new FileStream(ofd.FileName, FileMode.Open);
XmlSerializer xs = new XmlSerializer(streets.GetType());
this.streets = (StreetCollection)xs.Deserialize(fs);
fs.Close();
path = ofd.FileName;
saved = true;
street.ItemsSource = streets;
Owner.streets = streets;
}
}
private static void Main(string[] args)
{
Console.WriteLine("Please make your choice: ");
Console.WriteLine("1. Streets");
Console.WriteLine("2. Boulevards");
string userChoice = Console.ReadLine();
int.TryParse(userChoice, out int userOption);
FailureTrackerDbContext context = InitializeContext();
switch (userOption)
{
case 1:
StreetCollection streetCollection = ParseStreets("artere_1.xml");
foreach (var street in streetCollection.Streets)
{
context.Streets.Add(street);
}
break;
case 2:
BoulevardCollection boulevardCollection = ParseBoulevards("artere_2.xml");
foreach (var boulevard in boulevardCollection.Boulevards)
{
context.Boulevards.Add(boulevard);
}
break;
default:
throw new ArgumentException("Please choose a number from the list!");
}
context.SaveChanges();
Console.WriteLine("Data imported successfully!");
}
private static async Task Main(string[] args)
{
LogProvider.SetCurrentLogProvider(new ConsoleLogProvider());
NormalizerConfig normalizerConfig = new NormalizerConfig
{
StreetTypesAbbreviations = new List <string>
{
"Bd.", "Str.", "Al.", "Cal.", "Şos."
}
};
Console.WriteLine("Please make your choice: ");
Console.WriteLine("1. Streets");
Console.WriteLine("2. Boulevards");
string userChoice = Console.ReadLine();
int.TryParse(userChoice, out int userOption);
FailureTrackerDbContext context = InitializeContext();
switch (userOption)
{
case 1:
StreetCollection streetCollection = ParseStreets("artere_1.xml");
foreach (var street in streetCollection.Streets)
{
context.Streets.Add(street);
}
break;
case 2:
BoulevardCollection boulevardCollection = ParseBoulevards("artere_2.xml");
foreach (var boulevard in boulevardCollection.Boulevards)
{
context.Boulevards.Add(boulevard);
}
break;
default:
throw new ArgumentException("Please choose a number from the list!");
}
context.SaveChanges();
Console.WriteLine("Data imported successfully!");
//var json = @$"{GlobalConfig.Path}\result.json";
//var fileContent = File.ReadAllText(json);
//var deserialization = JsonConvert.DeserializeObject<List<Table>>(fileContent);
//var dataNormalizer = new DataNormalizer(normalizerConfig);
//IEnumerable<Failure> failures = dataNormalizer.DoWork(deserialization);
//foreach(var failure in failures)
//{
// Console.WriteLine(failure.Address);
//}
//var scheduler = new Scheduler(new StdSchedulerFactory());
//await scheduler.Schedule();
//await Task.Delay(TimeSpan.FromSeconds(30));
}
public void Open(string guid, string kladr)
{
connection.ConnectionString = ConnectionString;
connection.Open();
CustomReloadCollection(RegionCollection, FiasSql.RegionSql, null);
var searchResult = new Dictionary <string, string>();
using (var transaction = connection.BeginTransaction())
{
using (var query = new DbQuery(connection, transaction))
{
query.SqlText = "select ID_REGION, ID_AUTO, ID_AREA, ID_CITY, ID_CTAR, ID_PLACE, ID_STREET, ID_HOUSE from PR_FIAS_EXTRACT(@ID_GUID, @ID_KLADR)";
query.Parameters.Add(query.GetNewParameter("ID_GUID", guid == string.Empty ? null : guid));
query.Parameters.Add(query.GetNewParameter("ID_KLADR", kladr == string.Empty ? null : kladr));
query.ExecuteDataReader();
if (query.DataReader.Read())
{
for (var i = 0; i < query.DataReader.FieldCount; i++)
{
searchResult.Add(query.DataReader.GetName(i), query.DataReader[i].ToString());
}
}
}
}
if (searchResult.Count == 0)
{
return;
}
if (searchResult["ID_REGION"] != string.Empty)
{
SelectedRegion = RegionCollection.FirstOrDefault(a => a.Id == searchResult["ID_REGION"]);
}
if (searchResult["ID_AUTO"] != string.Empty)
{
SelectedAuto = AutoCollection.FirstOrDefault(a => a.Id == searchResult["ID_AUTO"]);
}
if (searchResult["ID_AREA"] != string.Empty)
{
SelectedArea = AreaCollection.FirstOrDefault(a => a.Id == searchResult["ID_AREA"]);
}
if (searchResult["ID_CITY"] != string.Empty)
{
SelectedCity = CityCollection.FirstOrDefault(a => a.Id == searchResult["ID_CITY"]);
}
if (searchResult["ID_CTAR"] != string.Empty)
{
SelectedCtar = CtarCollection.FirstOrDefault(a => a.Id == searchResult["ID_CTAR"]);
}
if (searchResult["ID_PLACE"] != string.Empty)
{
SelectedPlace = PlaceCollection.FirstOrDefault(a => a.Id == searchResult["ID_PLACE"]);
}
if (searchResult["ID_STREET"] != string.Empty)
{
SelectedStreet = StreetCollection.FirstOrDefault(a => a.Id == searchResult["ID_STREET"]);
}
if (searchResult["ID_HOUSE"] != string.Empty)
{
SelectedHouse = HouseCollection.FirstOrDefault(a => a.Id == searchResult["ID_HOUSE"]);
}
}
