public static void WriteToFile(List <InteractionDiagramItem> items, string filePath)
{
var engine = new FileHelperEngine <InteractionDiagramItem>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(filePath, items);
}
private static void WriteOutputFiles()
{
const string filePath = @"C:\Users\vince\Downloads\Power BI\Data\";
string outFileNamePmt = $"{filePath}Loan Payments v07.csv";
string outFileNameLoan = $"{filePath}Loan Loans v07.csv";
string outFileNameStrat = $"{filePath}Loan Strategies v07.csv";
string outFileNameMonth = $"{filePath}Loan Months v07.csv";
//payments
var outEnginePmt = new FileHelperEngine <Payment>();
outEnginePmt.HeaderText = outEnginePmt.GetFileHeader();
outEnginePmt.WriteFile(outFileNamePmt, Payments);
//loans
IEnumerable <LoanOutput> loanOutputs = Mapper.Map <IEnumerable <Loan>, IEnumerable <LoanOutput> >(Loans);
var outEngineLoan = new FileHelperEngine <LoanOutput>();
outEngineLoan.HeaderText = outEngineLoan.GetFileHeader();
outEngineLoan.WriteFile(outFileNameLoan, loanOutputs);
//strategies
var outEngineStrat = new FileHelperEngine <Strategy>();
outEngineStrat.HeaderText = outEngineStrat.GetFileHeader();
outEngineStrat.WriteFile(outFileNameStrat, Strategies);
//months
var outEngineMonth = new FileHelperEngine <Month>();
outEngineMonth.HeaderText = outEngineMonth.GetFileHeader();
outEngineMonth.WriteFile(outFileNameMonth, Months);
}
public void SaveSalesData(DataMapSalesCashflow[] salesData, string path)
{
var engine = new FileHelperEngine <DataMapSalesCashflow>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(path, salesData);
}
public void SaveLoanData(DataMapLoanCashflow[] loanData, string path)
{
var engine = new FileHelperEngine <DataMapLoanCashflow>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(path, loanData);
}
public void SavePayrollData(DataMapPayrollCashflow[] payrollData, string path)
{
var engine = new FileHelperEngine <DataMapPayrollCashflow>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(path, payrollData);
}
public static int Write(this List<ProcessedQuote> stock, string path)
{
var fileEngine = new FileHelperEngine<ProcessedQuote>();
fileEngine.HeaderText = fileEngine.GetFileHeader();
fileEngine.WriteFile(path, stock);
return stock.Count();
}
public static void WriteRecords <T>(string fileName, IEnumerable <T> records) where T : class
{
var fileWriter = new FileHelperEngine <T>();
fileWriter.HeaderText = fileWriter.GetFileHeader();
fileWriter.WriteFile(fileName, records);
}
static void ProcessFile(string pathName, string sourceSide, string targetSide)
{
// create engine
var engine = new FileHelperEngine <PathSegmentBE>();
// 1. process left file: LeftTurn_v3_left.csv
// build source filename
string sourceFileName = $"{PATH_NAME}_{sourceSide}.csv";
string sourceFilePathName = System.IO.Path.Combine(FOLDER_PATH, sourceFileName);
// read orginal file
var segments = engine.ReadFile(sourceFilePathName);
// loop thru and adjust values
foreach (var segment in segments)
{
segment.x = segment.x * 12.0M;
segment.y = segment.y * 12.0M;
segment.position = segment.position * 12.0M;
}
// write out file with header LeftTurn_v3.left.pf1.csv
string targetFileName = $"{PATH_NAME}.{targetSide}.pf1.csv";
string targetFilePathName = System.IO.Path.Combine(FOLDER_PATH, targetFileName);
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(targetFilePathName, segments);
}
public void SaveLongInvestmentData(DataMapLongInvestmentCashflow[] investmentData, string path)
{
var engine = new FileHelperEngine <DataMapLongInvestmentCashflow>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(path, investmentData);
}
public void SaveAutoCashCalculation(DataMapAutoCashCalculation[] autoCashCalculationTable, string autoCashCalculationFilePath)
{
var engine = new FileHelperEngine <DataMapAutoCashCalculation>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(autoCashCalculationFilePath, autoCashCalculationTable);
}
public void GetFileHeaderWithFieldCaption()
{
var engine = new FileHelperEngine <CustomersVerticalBarWithFieldCaption>();
var records = engine.ReadFile(FileTest.Good.CustomersVerticalBarDemo.Path);
Check.That(engine.GetFileHeader())
.IsEqualTo("Customer ID|Company Name|Contact Name|Contact Title|Address|City|Country");
}
public void GetFileHeader()
{
var engine = new FileHelperEngine<CustomersVerticalBar>();
var records = engine.ReadFile(FileTest.Good.CustomersVerticalBarDemo.Path);
Check.That(engine.GetFileHeader())
.IsEqualTo("CustomerID|CompanyName|ContactName|ContactTitle|Address|City|Country");
}
/// <summary>
/// Create an export of the sessions in this providers type
/// This may throw an exception if there are File I/O issues
/// </summary>
/// <param name="sessionList">The list of sessions to store</param>
/// <param name="fileName">The file name to store the backup in </param>
/// <returns>Count of exported sessions</returns>
public int saveSessionsToFile(List <Session> sessionList, string fileName)
{
FileHelperEngine <CsvRecord> engine = new FileHelperEngine <CsvRecord>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(fileName, createCsvRecords(sessionList));
return(engine.TotalRecords);
}
public static void Save <T>(string file, List <T> items)
where T : GlossaryItem
{
var engine = new FileHelperEngine <T>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(file, items);
}
public static List <T> Load <T>(string file)
where T : GlossaryItem
{
var engine = new FileHelperEngine <T>();
engine.HeaderText = engine.GetFileHeader();
return(engine.ReadFile(file).ToList());
}
public DataCovidExport(string filename)
{
this.filename = filename;
this.engine = new FileHelperEngine <DataCovidSp>();
this.engine.HeaderText = engine.GetFileHeader();
LoadCsvFile(this.filename);
}
static void Main(string[] args)
{
Console.WriteLine("Welcome to the Loan Portfilio Application");
//get incoming loan objects
const string inFileName = @"C:\Users\vince\Downloads\Bills Google Sheet - Loan Portfolio.csv";
const string outFileName = @"C:\Users\vince\Downloads\Loan Payments.csv";
Console.WriteLine($"Using {inFileName}");
//convert to complete loan with all details
var inEngine = new FileHelperEngine <LoanInput>();
var result = inEngine.ReadFile(inFileName);
//if this is an enumerable, it's a QUERY
//changes made within the foreach loop don't stay saved
var loansList = result.Select(il => new Loan(il)).ToList();
var loansToPayByRate = loansList.OrderByDescending(l => l.InterestRate).ToList();
decimal extraMoney = 100;
var scenarioName = "$100";
do
{
foreach (var l in loansToPayByRate)
{
var amountToPay = l.MinPmtAmount;
var loanPriority = loansToPayByRate.IndexOf(l);
if (loanPriority == 0)
{
amountToPay += extraMoney;
}
var amountPaid = l.MakePayment(amountToPay, scenarioName);
}
loansToPayByRate = loansToPayByRate.Where(l => l.CheckCompletion(scenarioName) == false).ToList();
} while (loansToPayByRate.Count > 0);
//show results
IList <PaymentOutput> paymentOutput = new List <PaymentOutput>();
foreach (var l in loansList)
{
foreach (var kvp in l.PaymentScenarios)
{
foreach (var p in kvp.Value)
{
paymentOutput.Add(new PaymentOutput(l, kvp, p));
}
}
}
var outEngine = new FileHelperEngine <PaymentOutput>();
outEngine.HeaderText = outEngine.GetFileHeader();
outEngine.WriteFile(outFileName, paymentOutput);
}
public void WriteRecords(List <TRecordType> records, bool ignoreFirstList)
{
var engine = new FileHelperEngine <TRecordType>();
if (ignoreFirstList)
{
engine.HeaderText = engine.GetFileHeader();
}
engine.WriteFile(_csvFileName, records);
}
public static void ToCSV(this List <Review> reviews, string targetFilePath)
{
// turn reviews into CSV
var engine = new FileHelperEngine <Review>(System.Text.Encoding.UTF8);
engine.HeaderText = engine.GetFileHeader();
// Save to disk
engine.WriteFile(targetFilePath, reviews);
}
public static void WriteUsersFile(string path, List <User> users)
{
var temp = new List <UserEngine>();
foreach (var item in users)
{
temp.Add(new UserEngine(item.ID, item.FirstName, item.LastName, item.Email, item.Gender, item.Country, item.City, item.Street, item.PhoneNumber));
}
_userEngine.HeaderText = _userEngine.GetFileHeader();
_userEngine.WriteFile(path, temp);
}
public void CheckItWritesToFile()
{
var engine = new FileHelperEngine<CustomersVerticalBar>();
var records = engine.ReadFile(FileTest.Good.CustomersVerticalBarDemo.Path);
engine.HeaderText = engine.GetFileHeader();
var result = engine.WriteString(records);
Check.That(result).StartsWith("CustomerID|CompanyName|ContactName|ContactTitle|Address|City|Country");
Check.That(result.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Length)
.IsEqualTo(records.Length + 1);
}
public void CheckItWritesToFileWithCaption()
{
var engine = new FileHelperEngine <CustomersVerticalBarWithFieldCaption>();
var records = engine.ReadFile(FileTest.Good.CustomersVerticalBarDemo.Path);
engine.HeaderText = engine.GetFileHeader();
var result = engine.WriteString(records);
Check.That(result).StartsWith("Customer ID|Company Name|Contact Name|Contact Title|Address|City|Country");
Check.That(result.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Length)
.IsEqualTo(records.Length + 1);
}
//
// Export checkins to CSV
//
private void ExportCSV_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog dialog = new SaveFileDialog();
dialog.Filter = "CSV file (*.csv)|*.csv|Text file (*.txt)|*.txt";
List <CheckinRecord> export = DatabaseUtility.SelectDownloadedCheckins();
if (dialog.ShowDialog() == true)
{
FileHelperEngine <CheckinRecord> engine = new FileHelperEngine <CheckinRecord>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(dialog.FileName, export);
}
}
public static void WriteToFile(QStep[] qSteps, string fileName)
{
var engine = new FileHelperEngine <QStep>();
string workingDirectory = Environment.CurrentDirectory;
string projectDirectory = Directory.GetParent(workingDirectory).Parent.Parent.FullName;
var fullPath = Path.Combine(new string[] { projectDirectory, "Data", fileName });
if (File.Exists(fullPath))
{
File.Delete(fullPath);
}
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(fullPath, qSteps);
}
private void WriteToFile(ValueQ[] valueQs, string fileName)
{
var engine = new FileHelperEngine <ValueQ>();
string workingDirectory = Environment.CurrentDirectory;
string projectDirectory = Directory.GetParent(workingDirectory).Parent.Parent.FullName;
var fullPath = Path.Combine(new string[] { projectDirectory, "Data", fileName });
if (File.Exists(fullPath))
{
File.Delete(fullPath);
}
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(fullPath, valueQs);
}
public static void SampleToFile(string path, Triangle sample)
{
var engine = new FileHelperEngine(typeof(Triangle));
if (File.Exists(path))
{
engine.AppendToFile(path, sample);
}
else
{
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(path, new List <Triangle>()
{
sample
});
}
}
public void ImportDependenciesFromCsvFile(string csvFile)
{
try
{
this.RaiseDependenciesModelAboutToChange();
var engine = new FileHelperEngine <CsvDependency>();
var records = engine.ReadFile(csvFile);
if (engine.GetFileHeader() != engine.HeaderText.Trim())
{
throw new Exception(string.Format("[CSV] Column headers: '{0}' from file '{1}' do not match the expected ones: '{2}'", engine.HeaderText.Trim(), csvFile, engine.GetFileHeader()));
}
var theModel = new Dictionary <int, DependencyItem>();
DependencyItem tempItem;
foreach (var csvDependency in records)
{
tempItem = new DependencyItem(
csvDependency.Id,
csvDependency.Title,
csvDependency.Comment,
csvDependency.SuccessorIds ?? new List <int>(),
csvDependency.Tags ?? new List <string>());
tempItem.State = csvDependency.Status;
theModel.Add(csvDependency.Id, tempItem);
this.Logger.Debug(string.Format(@"[CSV] Got: {0}", tempItem.ToString()));
}
this.DependenciesModel = theModel;
this.RaiseDependenciesModelChanged();
}
catch (Exception ex)
{
this.Logger.Error(string.Format(@"{0}{1}{2}", ex.Message, Environment.NewLine, ex.StackTrace));
this.RaiseDependenciesModelCouldNotBeChanged();
throw;
}
}
public async Task <IActionResult> GetAsCsv()
{
var engine = new FileHelperEngine <NPCToInsiderThreatCsv>();
engine.HeaderText = engine.GetFileHeader();
var list = await _mongo.FindAsync(x => true);
var finalList = NPCToInsiderThreatCsv.ConvertToCsv(list.ToList());
var stream = new MemoryStream();
TextWriter streamWriter = new StreamWriter(stream);
engine.WriteStream(streamWriter, finalList);
await streamWriter.FlushAsync();
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "text/csv", $"insider_threat_{Guid.NewGuid()}.csv"));
}
static void StartTransform()
{
var engine = new FileHelperEngine <CsvLine>();
engine.HeaderText = engine.GetFileHeader();
List <CsvLine> lines = new List <CsvLine>();
foreach (string path in Directory.GetFiles("work", "*.html"))
{
var html = File.ReadAllText(path);
var csvLines = Transform(html);
lines.AddRange(csvLines);
Console.WriteLine("{0} titles in {1}", csvLines.Count, path);
}
CreateDirectory("output");
engine.WriteFile(string.Format("output\\{0:yyyy-MM-dd HH.mm.ss}.csv", DateTime.Now), lines);
}
public static void SampleToFile(string path, Simplex3D sample)
{
var engine = new FileHelperEngine(typeof(Simplex3D));
var samples = new List <Simplex3D>()
{
sample
};
if (File.Exists(path))
{
engine.AppendToFile(path, sample);
}
else
{
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(path, new List <Simplex3D>()
{
sample
});
}
}
public static void SampleToFile(string path, ShearTriangle2D sample)
{
var engine = new FileHelperEngine(typeof(ShearTriangle2D));
var samples = new List <ShearTriangle2D>()
{
sample
};
if (File.Exists(path))
{
engine.AppendToFile(path, sample);
}
else
{
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile("C:\\Users\\bergerd\\simplices.csv", new List <ShearTriangle2D>()
{
sample
});
}
}
internal static string GetListofColumnHeaders(Guid?LocationTypeKey)
{
Guid LocTypeKey;
if (LocationTypeKey == null)
{
LocTypeKey = Constants.DefaultLocationTypeKey;
}
else
{
LocTypeKey = (Guid)LocationTypeKey;
}
// Dynamic class definition
string dynamicClassDef = DynamicLocationFlat.GetDynamicClass(LocTypeKey);
Type t = ClassBuilder.ClassFromString(dynamicClassDef);
// Using http://filehelpers.sourceforge.net/ to deal with dynamic model
FileHelperEngine fhEngine = new FileHelperEngine(t);
return(fhEngine.GetFileHeader());
}
/// <summary>
/// Loads all not-yet-loaded user data and exports it to CSV
/// </summary>
/// <returns></returns>
public async Task ExportResultsToCSVAsync()
{
if (model.SearchResults.Count == 0)
{
model.StatusMessage = "There are no results to export";
return;
}
model.StatusMessage = "Fetching all results data from GitHub.. Please wait, it may take a few minutes";
await this.LoadAllUserDataAsync();
model.StatusMessage = "Data loadded";
Microsoft.Win32.SaveFileDialog dlg = new Microsoft.Win32.SaveFileDialog();
dlg.DefaultExt = ".csv";
dlg.Filter = "(*.csv)|*.csv";
if (true == dlg.ShowDialog())
{
string filename = dlg.FileName;
try
{
model.StatusMessage = "Persisting user data in: " + filename;
var engine = new FileHelperEngine<SerializableUser>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(filename, model.SerializableResults);
model.StatusMessage = "Data persisted in: " + filename;
}
catch
{
model.StatusMessage = "Error persisting data in " + filename;
}
}
}
static void Main(string[] args)
{
var filePaths = args?.ToList();
if (filePaths == null || filePaths.Count == 0)
{
Common.PrintUsage(Name);
return;
}
Console.WriteLine($"{Name}:");
Console.WriteLine();
var results = new List <ExportRecord>();
var parser = new Parser();
foreach (var filePath in filePaths)
{
Console.WriteLine($"Path: {filePath}");
using (var stream = File.Open(filePath, FileMode.Open))
{
Console.WriteLine($"Length: {stream.Length}");
var configFile = parser.ParseConfigFile(filePath, stream);
var nodes = configFile.RootNode.Descendants();
var partNodes = nodes.Where(x => x.Type == NodeType.Part).ToList();
Console.WriteLine(
$"Part nodes: {partNodes.Count}"
);
var partsWithAntennas = partNodes
.Where(x => x.Nodes
.Any(n =>
n.Type == NodeType.Module &&
n.AttributeDefinitions.Any(ad =>
ad.Name == "name" &&
ad.Value == "ModuleDataTransmitter"
)
)
)
;
Console.WriteLine(
$"Part nodes with antennas: {partsWithAntennas.Count()}"
);
results.AddRange(ConvertNodesToExportRecords(
filePath,
partsWithAntennas
));
}
Console.WriteLine($"Finished {filePath}");
Console.WriteLine();
}
Console.WriteLine($"Writing {Name}.csv");
var engine = new FileHelperEngine <ExportRecord>();
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile($"{Name}.csv", results);
Console.WriteLine("Completed.");
Console.WriteLine();
}
