public void WriteCSVFileMatched(string filename, List <GISRecord> records, CompareOperatorEnum selectedCompareSign, string description)
{
int filter;
if (int.TryParse(description, out filter))
{
if (selectedCompareSign == CompareOperatorEnum.GreaterThan)
{
_writeRecordsGreaterThanFilter(filename, records, filter);
}
if (selectedCompareSign == CompareOperatorEnum.LessOrEqual)
{
_writeRecordsLessOrEqThanFilter(filename, records, filter);
}
}
//using (StreamWriter outputFile = new StreamWriter(filename))
//{
// outputFile.WriteLine(String.Join(",", "Source", "BusNumber", "BusName", "SubstationNumber", "SubstationName", "Latitude", "Longitude", "Information"));
// foreach (var record in records)
// {
// var self = String.Join(",", record.Source, record.BusNumber, record.BusName, record.SubstationNumber, record.SubstationName, record.Location.Lat, record.Location.Lng, record.Description);
// outputFile.WriteLine(self);
// if (record.MatchingWECC.Count() > 0)
// {
// //self += ",,,matched WECC,";
// foreach (var m in record.MatchingWECC)
// {
// self += ",,distance:," + m.Item2.ToString() + "," + String.Join(",", m.Item1.Information.Values) + ",";
// }
// }
// if (record.MatchingEnergyAnalytics.Count() > 0)
// {
// self += ",,,matched Energy Analytics,";
// foreach (var m in record.MatchingEnergyAnalytics)
// {
// self += ",,distance:," + m.Item2.ToString() + "," + String.Join(",", m.Item1.Information.Values);
// }
// }
// if (record.MatchingPlatts.Count() > 0)
// {
// self += ",,,matched Platts,";
// foreach (var m in record.MatchingPlatts)
// {
// self += ",,distance:," + m.Item2.ToString() + "," + String.Join(",", m.Item1.Information.Values) + ",,,,,,";
// }
// }
// outputFile.WriteLine(self);
// }
//}
}
private void _writeMatchedRecords(CompareOperatorEnum selectedCompareSign, DistanceFilterEnum selectedDistanceFilter)
{
var descriptionAttri = selectedDistanceFilter.GetType().GetField(selectedDistanceFilter.ToString()).GetCustomAttributes(typeof(DescriptionAttribute), true).FirstOrDefault() as DescriptionAttribute;
var description = descriptionAttri.Description;
var records = _recordComparer.GetMatchedRecords(selectedCompareSign, description);
var timestamp = DateTime.Now.ToString("_yyyyMMdd_HHmmss");
var writer = new GISRecordWriter();
foreach (var p in records)
{
string filename = _exportFileLocation + "\\Matched_" + selectedCompareSign.ToString() + description + "_" + p.Key + timestamp + ".csv";
writer.WriteCSVFileMatched(filename, p.Value, selectedCompareSign, description);
}
}
public Dictionary <string, List <GISRecord> > GetMatchedRecords(CompareOperatorEnum selectedCompareSign, string description)
{
int filter;
Dictionary <string, List <GISRecord> > result = null;
if (int.TryParse(description, out filter))
{
if (selectedCompareSign == CompareOperatorEnum.GreaterThan)
{
result = _getRecordsGreaterThanFilter(filter);
}
if (selectedCompareSign == CompareOperatorEnum.LessOrEqual)
{
result = _getRecordsLessOrEqThanFilter(filter);
}
}
return(result);
}
public ColumnDefinition(int columnOrdinal, string columnName, object columnValue,
CompareOperatorEnum columnComparer) : this(columnOrdinal, columnName, columnValue)
{
this.ColumnComparer = columnComparer;
}
public void GetMatchedResults(MapViewModel mapVM, DistanceFilterEnum selectedDistanceFilter, CompareOperatorEnum selectedCompareSign)
{
int filter;
var descriptionAttri = selectedDistanceFilter.GetType().GetField(selectedDistanceFilter.ToString()).GetCustomAttributes(typeof(DescriptionAttribute), true).FirstOrDefault() as DescriptionAttribute;
var description = descriptionAttri.Description;
if (int.TryParse(description, out filter))
{
if (selectedCompareSign == CompareOperatorEnum.GreaterThan)
{
_getMarkerGreaterThanFilter(mapVM, filter);
}
if (selectedCompareSign == CompareOperatorEnum.LessOrEqual)
{
_getMarkerLessOrEqThanFilter(mapVM, filter);
}
}
}
