public void Generate()
{
foreach (IAdj adj in _adjs)
{
SortedList<DateTime, AdjRateDatum> adjRateData = CreateAdjRateData(adj);
//String dir = Directory.GetCurrentDirectory();
//String path = dir + "\\" + _excelAdjResultFileName;
CsvFileWriter writer = new CsvFileWriter(String.Format("{0}_result.csv", adj.ToString()));
WriteHeader(writer);
foreach (KeyValuePair<DateTime, AdjRateDatum> datum in adjRateData)
{
CsvRow row = new CsvRow();
row.Add(datum.Key.ToString("yyyy-MM-dd"));
row.Add(datum.Value.KospiRate.ToString("n5"));
row.Add(datum.Value.KtbRate.ToString("n5"));
row.Add(datum.Value.DollarRate.ToString("n5"));
writer.WriteRow(row);
}
writer.Close();
}
}
static void Main(string[] args)
{
Process[] BandwidthMonitor = Process.GetProcessesByName("BandwidthMonitor");
if (BandwidthMonitor.Count() > 1)
{
}
else
{
try
{
csvFileWiter = new CsvFileWriter();
CsvRow row = CheckBandwidthUsage(System.DateTime.Now);
Dictionary<String, object> objArgument = new Dictionary<string, object>();
objArgument.Add("DefragArguements", row);
networkUsage.WorkerSupportsCancellation = true;
networkUsage.DoWork += new DoWorkEventHandler(networkUsage_DoWork);
networkUsage.RunWorkerCompleted += new RunWorkerCompletedEventHandler(networkUsage_RunWorkerCompleted);
networkUsage.RunWorkerAsync((object)objArgument);
Console.ReadLine();
}
catch (Exception Ex)
{
WriteLog("Log Path :: " + Ex);
}
}
}
public static void WriteToCsvFile(this DataTable dataTable, string filePath)
{
CsvFileWriter writer = new CsvFileWriter(filePath);
StringBuilder fileContent = new StringBuilder();
CsvRow row = new CsvRow();
foreach (var col in dataTable.Columns)
row.Add(col.ToString());
writer.WriteRow(row);
foreach (DataRow dr in dataTable.Rows)
{
row = new CsvRow();
foreach (var column in dr.ItemArray)
{
row.Add(column.ToString());
}
writer.WriteRow(row);
}
writer.Close();
dataTable = null;
System.Console.WriteLine(string.Format("Done writing to {0}.", filePath));
}
private void saveButton_Click(object sender, EventArgs e)
{
FileStream aStreamForReading = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStreamForReading);
List<string> aRecord = new List<string>();
while (aReader.ReadRow(aRecord))
{
string regNo = aRecord[0];
if (regNoTextBox.Text == regNo)
{
MessageBox.Show(@"Reg no already exists");
aStreamForReading.Close();
return;
}
}
aStreamForReading.Close();
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> aStudentRecord = new List<string>();
aStudentRecord.Add(regNoTextBox.Text);
aStudentRecord.Add(nameTextBox.Text);
aWriter.WriteRow(aStudentRecord);
aStream.Close();
}
void WriteHeader(CsvFileWriter writer)
{
CsvRow row = new CsvRow();
row.Add("Date");
row.Add("KospiRate");
row.Add("KtbRate");
row.Add("DollarRate");
writer.WriteRow(row);
}
void WriteHeader(CsvFileWriter writer)
{
CsvRow row = new CsvRow();
row.Add("DateTime");
row.Add("EventPoint");
foreach (String key in _indicators.GetKeys())
{
row.Add(key);
}
writer.WriteRow(row);
}
void WriteHeader(CsvFileWriter writer)
{
CsvRow row = new CsvRow();
row.Add("LongCode");
row.Add("ShortCode");
row.Add("From");
row.Add("To");
row.Add("RangeMax");
row.Add("RangeMin");
writer.WriteRow(row);
}
public void WriteTo(String fileOutPath, PeriodicMarketDataCollection spot,
PeriodicMarketDataCollection future, TradingDirection spotDirection)
{
EventPointsFinder target = new EventPointsFinder();
List<EventPoint> eventPoints = target.GetEventPoints(spot, future, spotDirection);
CsvFileWriter writer = new CsvFileWriter(fileOutPath);
WriteHeader(writer);
WriteBody(writer, eventPoints);
logger.Info("Write {0} complete...", fileOutPath);
writer.Close();
}
public void WriteToFile(String path)
{
CsvFileWriter writer = new CsvFileWriter(path);
try
{
WriteHeader(writer);
WriteBody(writer);
}
catch (System.Exception ex)
{
logger.Error(ex.ToString());
}
writer.Close();
}
private void saveButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> aEmployeeRecord = new List<string>();
aEmployeeRecord.Add(employeeNameTextBox.Text);
aEmployeeRecord.Add(idTextBox.Text);
aEmployeeRecord.Add(salaryAmountTextBox.Text);
aWriter.WriteRow(aEmployeeRecord);
aStream.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
FileStream aFileStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aCsvFileWriter = new CsvFileWriter(aFileStream);
List<string> aRecordList = new List<string>();
GetValue(aRecordList);
MessageBox.Show("Saved");
aCsvFileWriter.WriteRow(aRecordList);
aFileStream.Close();
}
private void button1_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> aStudentRecord = new List<string>();
aStudentRecord.Add(regNoTextBox.Text);
aStudentRecord.Add(nameTextBox.Text);
aWriter.WriteRow(aStudentRecord);
aStream.Close();
}
public void ToCsv()
{
const String kHeader = "CreditPolicyWithMA";
String fileName = String.Format("{0}_{1}.csv", kHeader, DateTime.Now.ToString("yyyy_MM_dd HHmmssfff"));
CsvFileWriter writer = new CsvFileWriter(fileName);
WriteHeader(writer);
foreach (LogRow log in _logs)
{
CsvRow row = new CsvRow();
row.Add(log.CurDate.ToString("yyyy-MM-dd"));
row.Add(log.KospiWeight.ToString());
writer.WriteRow(row);
}
writer.Close();
}
void WriteBody(CsvFileWriter writer, List<EventPoint> eventPoints)
{
foreach (EventPoint ep in eventPoints)
{
CsvRow row = new CsvRow();
row.Add(ep.LongCode);
row.Add(ep.ShortCode);
row.Add(ep.DateTimeFrom.ToString("yyyy-MM-dd HH:mm:ss.fff"));
row.Add(ep.DateTimeTo.ToString("yyyy-MM-dd HH:mm:ss.fff"));
row.Add(ep.RangeMax.ToString("n1"));
row.Add(ep.RangeMin.ToString("n1"));
writer.WriteRow(row);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> addressBook = new List<string>();
addressBook.Add(nameTextBox.Text);
addressBook.Add(emailTextBox.Text);
addressBook.Add(personalContactTextBox.Text);
addressBook.Add(homeContactTextBox.Text);
addressBook.Add(homeAddressTextBox.Text);
aWriter.WriteRow(addressBook);
aStream.Close();
}
private void saveButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.OpenOrCreate);
CsvFileReader aReader = new CsvFileReader(aStream);
List<string> aPeronRecord = new List<string>();
//personListView.Items.Clear();
while (aReader.ReadRow(aPeronRecord))
{
if (aPeronRecord[2] == personalCnTextBox.Text)
{
MessageBox.Show("conflict");
aStream.Close();
return;
}
}
aStream.Close();
FileStream aStream2 = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream2);
List<string> aPersonRecod = new List<string>();
aPersonRecod.Add(nameTextBox.Text);
aPersonRecod.Add(emailTextBox.Text);
aPersonRecod.Add(personalCnTextBox.Text);
aPersonRecod.Add(homeCnTextBox.Text);
aPersonRecod.Add(homeAddressTextBox.Text);
aWriter.WriteRow(aPersonRecod);
aStream2.Close();
}
public void writePlayers(List<Player> listPlayers)
{
using (CsvFileWriter writer = new CsvFileWriter(file))
{
foreach (var item in listPlayers)
{
CsvRow row = new CsvRow();
row.Add(item.Name);
for (int i = 0; i < Constants.RaceNumber; i++)
{
row.Add(item.Races[i].ToString());
row.Add(item.Victory[i].ToString());
row.Add(item.Defeat[i].ToString());
row.Add(item.Elo[i].ToString());
}
writer.WriteRow(row);
}
}
}
void WriteBody(CsvFileWriter writer)
{
List<EventPoint> eps = _eventPoints.EventPoints;
Dictionary<String, List<DateTimeDoublePair>> indicators = _indicators.GetIndicators(_targetDate);
for (int i = 0; i < eps.Count; i = i + 2)
{
EventPoint ep = eps[i];
CsvRow row = new CsvRow();
row.Add(ep.DateTimeFrom.ToString("yyyy-MM-dd HH:mm:ss.fff"));
row.Add(ep.RangeMax.ToString("n"));
foreach (List<DateTimeDoublePair> pair in indicators.Values.ToList())
{
row.Add(pair[i].DoubleValue.ToString("n"));
Trace.Assert(pair[i].DateTimeValue == ep.DateTimeFrom);
}
writer.WriteRow(row);
}
}
/// <inheritdoc />
protected override void Write(CsvFileWriter writer, NewsMessage data, IMarketDataMetaInfo metaInfo)
{
writer.WriteRow(new[]
{
data.ServerTime.WriteTimeMls(),
data.ServerTime.ToString("zzz"),
data.Headline,
data.Source,
data.Url,
data.Id,
data.BoardCode,
data.SecurityId?.SecurityCode,
data.Priority?.To <string>(),
data.Language,
data.SecurityId?.BoardCode,
data.ExpiryDate?.ToString(_expiryFormat),
data.SeqNum.DefaultAsNull().ToString(),
});
metaInfo.LastTime = data.ServerTime.UtcDateTime;
}
/// <summary>
/// This method will help to create the Csv file
/// </summary>
/// <param name="fileParameter"></param>
/// <returns></returns>
public async Task <bool> CreateCsvFile(FileParameterModel fileParameter)
{
//Check and create Directory If It Not Exist
var filePath = await Task.Run(() => $"{FileHelper.CreateDirectory(fileParameter.FolderUrl)}//{fileParameter.FileName}");
using (var writer = new CsvFileWriter(filePath))
{
//Config to get 100000 from App Setting
for (int i = 0; i < fileParameter.TotalRows; i++)
{
var row = new CsvRowModel
{
$"{ Guid.NewGuid()}{fileParameter.Delimiter}{RandomString(fileParameter.MinContentLength , fileParameter.MaxContentLength, fileParameter.Pattern)}"
};
await Task.Run(() => writer.WriteRow(row));
}
}
return(await Task.FromResult(true));
}
//Save the data to the csv database
public void SaveToCSV(string fileName)
{
// Write sample data to CSV file
using (CsvFileWriter writer = new CsvFileWriter(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "MarvelDB", fileName))) //CHECK IF THIS IS MEANT TO BE THE FULL PATH!!!!
{
foreach (SuperHero heroValue in heroesByName)
{
CsvRow row = new CsvRow();
row.Add(heroValue.HeroName);
row.Add(heroValue.RealName);
row.Add(heroValue.Weight.ToString());
row.Add(heroValue.Height.ToString());
row.Add(heroValue.Race.ToString());
row.Add(heroValue.InMovie.ToString());
writer.WriteRow(row);
}
}
}
/// <inheritdoc />
protected override void Write(CsvFileWriter writer, TCandleMessage data, IMarketDataMetaInfo metaInfo)
{
if (data.State == CandleStates.Active)
{
throw new ArgumentException(LocalizedStrings.CandleActiveNotSupport.Put(data), nameof(data));
}
writer.WriteRow(new[]
{
data.OpenTime.WriteTimeMls(),
data.OpenTime.ToString("zzz"),
data.OpenPrice.ToString(),
data.HighPrice.ToString(),
data.LowPrice.ToString(),
data.ClosePrice.ToString(),
data.TotalVolume.ToString()
}.Concat(data.BuildFrom.ToCsv()).Concat(new[]
{
data.SeqNum.DefaultAsNull().ToString(),
}));
}
/// <summary>
/// Report all parameters on the given <see cref="Iteration" />.
/// </summary>
public void ParametersToCsv()
{
var engineeringModelShortName = (this.sessionService.Iteration.Container as EngineeringModel)?.EngineeringModelSetup.ShortName;
var csvPath = engineeringModelShortName + "_parameters_report.csv";
try
{
Console.WriteLine($"Report on parameter ({csvPath}) building in progress");
using var csvFileWriter = new CsvFileWriter(csvPath);
csvFileWriter.WriteRow(this.headers);
foreach (var elementDefinition in this.sessionService.Iteration.Element.OrderBy(x => x.ShortName))
{
this.WriteElementDefinition(csvFileWriter, engineeringModelShortName, elementDefinition);
foreach (var parameter in elementDefinition.Parameter.OrderBy(x => x.ParameterType.ShortName))
{
foreach (var parameterValueSet in parameter.ValueSet)
{
this.WriteParameterRow(csvFileWriter, engineeringModelShortName, parameterValueSet);
foreach (var parameterSubscription in parameter.ParameterSubscription.OrderBy(x => x.Owner.ShortName))
{
foreach (var parameterSubscriptionValueSet in parameterSubscription.ValueSet)
{
this.WriteParameterRow(csvFileWriter, engineeringModelShortName, parameterSubscriptionValueSet);
}
}
}
}
}
Console.WriteLine($"Done building the report located at: {Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)}");
}
catch (IOException ex)
{
Console.WriteLine(ex.Message);
}
}
private void MakeSpectrumFile()
{
Ground.I.Logger.Info("MakeSpectrumFile.1");
WaveData wavDat = new WaveData(this.MasterWavFile);
Ground.I.Logger.Info("MakeSpectrumFile.2");
using (CsvFileWriter writer = new CsvFileWriter(this.SpectrumFile))
//using (CsvFileWriter writer_L = new CsvFileWriter(this.SpectrumFile_L)) // 不使用
//using (CsvFileWriter writer_R = new CsvFileWriter(this.SpectrumFile_R)) // 不使用
{
for (int frame = 0; ; frame++)
{
int wavPartPos = (int)((frame * 1.0 / Consts.FPS + Consts.AUDIO_DELAY_SEC) * wavDat.WavHz);
if (wavDat.Length <= wavPartPos)
{
break;
}
if (frame % 200 == 0)
{
Ground.I.Logger.Info("MSF_frame: " + frame);
this.CheckCancel();
}
wavDat.SetWavPart(wavPartPos);
SpectrumGraph graph = new SpectrumGraph(hz => wavDat.GetSpectrum(hz));
//SpectrumGraph graph_L = new SpectrumGraph(hz => wavDat.GetSpectrum_L(hz)); // 不使用
//SpectrumGraph graph_R = new SpectrumGraph(hz => wavDat.GetSpectrum_R(hz)); // 不使用
CsvUtils.WriteRow(writer, graph);
//CsvUtils.WriteRow(writer_L, graph_L); // 不使用
//CsvUtils.WriteRow(writer_R, graph_R); // 不使用
}
}
Ground.I.Logger.Info("MakeSpectrumFile.3");
}
//For test speed
private int runAlgorithms()
{
controller.mAlgorithm = Algorithm.MidPoint_Line;
CsvFileReader reader = new CsvFileReader("Testcase_Line.csv");
CsvFileWriter writer = new CsvFileWriter("Midpoint_Line_Runtime.csv");
CsvRow row = new CsvRow();
Random rnd = new Random();
int count = 0;
while (reader.ReadRow(row))
{
if (row.Count == 4)
{
int x1 = Int32.Parse(row[0]);
int y1 = Int32.Parse(row[1]);
int x2 = Int32.Parse(row[2]);
int y2 = Int32.Parse(row[3]);
controller.mShape = new Line(new Point(x1, y1), new Point(x2, y2));
Color color = Color.FromArgb(rnd.Next(256), rnd.Next(256), rnd.Next(256));
try
{
Int64 runtime = this.DrawShape();
row.Add(String.Format(runtime.ToString()));
writer.WriteRow(row);
count++;
}
catch (Exception e)
{
Debug.WriteLine("failed at " + count.ToString());
}
}
else
{
break;
}
}
reader.Close();
writer.Close();
return(count);
}
private void saveButton_Click(object sender, EventArgs e)
{
int validFile = 1;
if (File.Exists(fileLocation))
{
FileStream aStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List <string> aList = new List <string>();
while (aReader.ReadRow(aList))
{
string contactNumber = aList[2];
if (contactNumber == contactNumberTextBox.Text)
{
validFile = 0;
break;
}
}
aStream.Close();
}
if (validFile == 0)
{
MessageBox.Show("Same Contact Number");
}
else if (validFile == 1)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List <string> aList = new List <string>();
aList.Add(nameInputTextBox.Text);
aList.Add(emailInputTextBox.Text);
aList.Add(contactNumberTextBox.Text);
aList.Add(homeContactTextBox.Text);
aList.Add(addressTextBox.Text);
aWriter.WriteRow(aList);
aStream.Close();
MessageBox.Show("Saved in file");
}
}
private void saveButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.OpenOrCreate);
CsvFileReader aReader = new CsvFileReader(aStream);
List <string> aPeronRecord = new List <string>();
//personListView.Items.Clear();
while (aReader.ReadRow(aPeronRecord))
{
if (aPeronRecord[2] == personalCnTextBox.Text)
{
MessageBox.Show("conflict");
aStream.Close();
return;
}
}
aStream.Close();
FileStream aStream2 = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream2);
List <string> aPersonRecod = new List <string>();
aPersonRecod.Add(nameTextBox.Text);
aPersonRecod.Add(emailTextBox.Text);
aPersonRecod.Add(personalCnTextBox.Text);
aPersonRecod.Add(homeCnTextBox.Text);
aPersonRecod.Add(homeAddressTextBox.Text);
aWriter.WriteRow(aPersonRecod);
aStream2.Close();
}
public bool GET()
{
var request = new RestRequest("sync_data", Method.POST);
JsonObject json = new JsonObject();
request.RequestFormat = DataFormat.Json;
json.Add("pclient_id", pclient_id.ToString());
request.AddBody(json);
IRestResponse <GetObject> response = client.Execute <GetObject>(request);
GetObject data = response.Data;
if (!requestError(response.StatusCode.ToString()))
{
return(false);
}
Directory.CreateDirectory(pathFolderName);
using (CsvFileWriter writer = new CsvFileWriter(pathFolderName + "products.csv"))
{
foreach (SyncProduct item in data.products)
{
CsvRow row = new CsvRow();
row.Add(item.upc);
row.Add(item.name);
try { row.Add(item.warehouse_id.ToString()); }
catch (Exception exc) { }
writer.WriteRow(row);
}
}
using (CsvFileWriter writer = new CsvFileWriter(pathFolderName + "warehouses.csv"))
{
foreach (SyncWarehouse item in data.warehouses)
{
CsvRow row = new CsvRow();
row.Add(item.id.ToString());
row.Add(item.name);
writer.WriteRow(row);
}
}
return(true);
}
private void saveButton_Click(object sender, EventArgs e)
{
int isvalid = 1;
if (File.Exists(filelocation))
{
FileStream aStream = new FileStream(filelocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List <string> aStudentRec = new List <string>();
while (aReader.ReadRow(aStudentRec))
{
string regNo = aStudentRec[0];
if (regNo == regTextBox1.Text)
{
isvalid = 0;
break;
}
}
aStream.Close();
}
if (isvalid == 0)
{
MessageBox.Show("Warning,Duplicate reg.no");
}
else if (isvalid == 1)
{
FileStream aFileStream = new FileStream(filelocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aFileStream);
List <string> aStudentrec = new List <string>();
aStudentrec.Add(regTextBox1.Text);
aStudentrec.Add(nameTextBox2.Text);
aWriter.WriteRow(aStudentrec);
MessageBox.Show("A student has been added");
aFileStream.Close();
}
}
private void UIWindow_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.F5)
{
ProcessStartInfo startInfo = new ProcessStartInfo(Application.ResourceAssembly.Location);
startInfo.Arguments = string.Format("-u {0} -mode {1}", App.User.Hash, (int)this.Mode);
System.Diagnostics.Process.Start(startInfo);
Application.Current.Shutdown();
}
else if (e.Key == Key.F12)
{
using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_CSV_COMMAND, FileMode.Append), Encoding.UTF8))
{
foreach (CsvRow r in App.Rows)
{
LogCSV.WriteRow(r);
}
App.Rows.Clear();
}
using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_Send_COMMAND, FileMode.Append), Encoding.UTF8))
{
foreach (CsvRow r in App.RowsSend)
{
LogCSV.WriteRow(r);
}
App.RowsSend.Clear();
}
}
if (Keyboard.Modifiers == ModifierKeys.Control)
{
if (e.Key == Key.L)
{
this.LockAllAlarm(null, null);
}
else if (e.Key == Key.U)
{
this.UnLockAllAlarm(null, null);
}
}
}
/// <summary>
/// Write data to the specified writer.
/// </summary>
/// <param name="writer">CSV writer.</param>
/// <param name="data">Data.</param>
/// <param name="metaInfo">Meta-information on data for one day.</param>
protected override void Write(CsvFileWriter writer, ExecutionMessage data, IMarketDataMetaInfo metaInfo)
{
writer.WriteRow(new[]
{
data.ServerTime.WriteTimeMls(),
data.ServerTime.ToString("zzz"),
data.TransactionId.ToString(),
data.OrderId.ToString(),
data.OrderPrice.ToString(),
data.OrderVolume.ToString(),
data.Side.ToString(),
data.OrderState.ToString(),
data.TimeInForce.ToString(),
data.TradeId.ToString(),
data.TradePrice.ToString(),
data.PortfolioName,
data.IsSystem.ToString()
});
metaInfo.LastTime = data.ServerTime.UtcDateTime;
metaInfo.LastId = data.TransactionId;
}
public void SetArticlePlacedRow(CsvFileWriter csvError)
{
articleRow = new CsvRow();
articleRow.Add(_reference.Article_Key);
articleRow.Add(_reference.Article_Hinge);
articleRow.Add(_reference.Article_Width.ToString());
articleRow.Add(_reference.Article_Depth.ToString());
articleRow.Add(_reference.Article_Height.ToString());
if (_sceneInfo.GenerateSceneInformations())
{
articleRow.AddRange(_sceneInfo.ArticleRow());
}
else
{
this.SetErrorRow(csvError, _reference.Article_Key);
csvError.Flush();
}
_csvFile.WriteRow(articleRow);
}
public void Dump(string dumpFilename)
{
using (CsvFileWriter writer = new CsvFileWriter(dumpFilename))
{
for (int i = 0; i < _recordCnt; i++)
{
CsvRow row = new CsvRow();
for (int j = 0; j < _inputNum + _labelNum; j++)
{
if (j < _inputNum)
{
row.Add(_input[i, j].ToString());
}
else
{
row.Add(_label[i, j - _inputNum].ToString());
}
}
writer.WriteRow(row);
}
}
}
public async Task WriteDataTableHandleIssuesAsync()
{
using (var dataTable = new DataTable {
TableName = "DataTable", Locale = CultureInfo.InvariantCulture
})
{
dataTable.Columns.Add("ID", typeof(int));
dataTable.Columns.Add("Text", typeof(string));
for (var i = 0; i < 100; i++)
{
var row = dataTable.NewRow();
row["ID"] = i;
row["Text"] = "Text" + i.ToString(CultureInfo.CurrentCulture);
dataTable.Rows.Add(row);
}
var writeFile = new CsvFile {
ID = "Test.txt", FileName = UnitTestInitializeCsv.GetTestPath("Test.txt"), SqlStatement = "Hello"
};
writeFile.ColumnCollection.Add(new Column("Text", DataType.Integer));
writeFile.Header = "##This is a header for {FileName}";
writeFile.Footer = "##This is a Footer\r\n{Records} in file";
var count = 0;
using (var processDisplay = new CustomProcessDisplay(UnitTestInitializeCsv.Token))
{
var writer = new CsvFileWriter(writeFile, processDisplay);
writer.Warning += (sender, e) => { count++; };
using (var reader = new DataTableWrapper(dataTable))
{
// await reader.OpenAsync(processDisplay.CancellationToken);
Assert.AreEqual(100, await writer.WriteAsync(reader, processDisplay.CancellationToken), "Records");
}
Assert.AreEqual(100, count, "Warnings");
}
Assert.IsTrue(File.Exists(writeFile.FileName));
}
}
public void StopsWriter()
{
{
// Write sample data to CSV file
using (CsvFileWriter writer = new CsvFileWriter("stops.txt"))
{
/*
* //----------------------------------------------- WORKING EXAMPLE
* CsvRow AgencyRow = new CsvRow();
*
* foreach (string s in AgencyDataList)
* {
* AgencyRow.Add(s);
* }
*
*
* writer.WriteRow(AgencyRow);
* //---------------------------------------------- WORKING EXAMPLE
*/
CsvRow StopsRowValues = new CsvRow();
for (int i = 0; i < 12; i++)
{
StopsRowValues.Add(StopsDataList[i]);
}
writer.WriteRow(StopsRowValues);
CsvRow StopsRowData = new CsvRow();
for (int i = 12; i < StopsDataList.Count; i++)
{
StopsRowData.Add(StopsDataList[i]);
}
writer.WriteRow(StopsRowData);
}
}
}
public void WriteCsvFile()
{
var cacheData = new[]
{
new ProcessedCacheData(
new CacheData("GC7WP8Y", new LatLng(43.550767, 16.51405), -23.896, 905.656),
new LatLng(43.558220, 16.509510)
)
};
var csvWriter = new CsvFileWriter();
using (var writer = new StringWriter())
{
csvWriter.Write(cacheData, writer);
var csvString = writer.ToString();
var expected = "GC7WP8Y,43.55822,16.50951" + Environment.NewLine;
csvString.Should().Be(expected);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
double amount = Convert.ToDouble(amountTextBox.Text);
string category = categoryLeftComboBox.Text;
string particular = particularTextBox.Text;
FileStream aFileStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aCsvFileWriter = new CsvFileWriter(aFileStream);
List <string> expenseinfo = new List <string>();
expenseinfo.Add(amount.ToString());
expenseinfo.Add(category);
expenseinfo.Add(particular);
aCsvFileWriter.WriteRow(expenseinfo);
MessageBox.Show("Information Saved Successfully");
amountTextBox.Text = "";
categoryLeftComboBox.Text = "";
particularTextBox.Text = "";
aFileStream.Close();
}
public void DataSave()
/*
* 현재 List에 저장된 데이터들을 .csv 파일에 저장
* columns에 각 행의 내용들을 add하고 writer.WriteRow()를 사용해 행을 저장
*/
{
var writer = new CsvFileWriter(Application.dataPath + "/Resources/abilities.csv");
List <string> columns = new List <string>();
// 첫 행은 data_header
foreach (dataHeader h in System.Enum.GetValues(typeof(dataHeader)))
{
string temp = h.ToString();
columns.Add(temp);
}
writer.WriteRow(columns);
columns.Clear();
// 이후 행들은 실제 데이터 삽입
for (int i = 0; i < abilities.Count; i++)
{
columns.Clear();
foreach (dataHeader h in System.Enum.GetValues(typeof(dataHeader)))
{
string header = h.ToString();
string temp = abilities[i][header].ToString();
columns.Add(temp);
}
writer.WriteRow(columns);
columns.Clear();
}
writer.Dispose();
Debug.Log("data saved");
}
public void WriteFileLocked()
{
var dataTable = new DataTable
{
TableName = "DataTable",
Locale = CultureInfo.InvariantCulture
};
dataTable.Columns.Add("ID", typeof(int));
dataTable.Columns.Add("Text", typeof(string));
for (int i = 0; i < 5; i++)
{
var row = dataTable.NewRow();
row["ID"] = i;
row["Text"] = i.ToString(CultureInfo.InvariantCulture);
dataTable.Rows.Add(row);
}
var writeFile = new CsvFile
{
ID = "Test.txt",
FileName = Path.Combine(m_ApplicationDirectory, "WriteFileLocked.txt"),
InOverview = false
};
FileSystemUtils.FileDelete(writeFile.FileName);
using (System.IO.StreamWriter file =
new System.IO.StreamWriter(writeFile.FileName))
{
file.WriteLine("Hello");
var writer = new CsvFileWriter(writeFile, CancellationToken.None);
writer.WriteDataTable(dataTable);
Assert.IsTrue(!string.IsNullOrEmpty(writer.ErrorMessage));
file.WriteLine("World");
}
FileSystemUtils.FileDelete(writeFile.FileName);
}
private void btnExport_Click(object sender, EventArgs e)
{
int iTerm = cbTerm.SelectedIndex;
if (iTerm != -1 && svdSave.ShowDialog() == DialogResult.OK)
{
//1 = excel file
if (svdSave.FilterIndex == 1)
{
//balance sheet export
if (tcMain.SelectedIndex == 0)
writeFinancialStatement(lvBalance, svdSave.FileName);
//income statement export
else if (tcMain.SelectedIndex == 1)
writeFinancialStatement(lvIncome, svdSave.FileName);
//cash flow statement export
else
writeFinancialStatement(lvCash, svdSave.FileName);
}
//2 = csv file
else if (svdSave.FilterIndex == 2)
{
using (CsvFileWriter writer = new CsvFileWriter(svdSave.FileName))
{
//balance sheet export
if (tcMain.SelectedIndex == 0)
writeFinancialStatement(lvBalance, writer);
//income statement export
else if (tcMain.SelectedIndex == 1)
writeFinancialStatement(lvIncome, writer);
//cash flow statement export
else
writeFinancialStatement(lvCash, writer);
if (Properties.Settings.Default.playSounds)
Sound.Success.Play();
}
}
}
}
public void ShearWallCalculatesPMMDiagramMaxIteration()
{
double f_c_prime = 6;
double f_c_prime_psi = f_c_prime * 1000;
IRebarMaterial LongitudinalRebarMaterial = new RebarMaterialGeneral(60000);
double l_w = 20 * 12;
double h = 12;
FlexuralCompressionFiberPosition p = FlexuralCompressionFiberPosition.Top;
ConcreteMaterial Concrete = new ConcreteMaterial(f_c_prime_psi, ConcreteTypeByWeight.Normalweight, null);
ConfinementReinforcementType ConfinementReinforcementType = KodestructAci.ConfinementReinforcementType.Ties;
CrossSectionRectangularShape shape = new CrossSectionRectangularShape(Concrete, null, h, l_w);
List <RebarPoint> LongitudinalBars = GetLongitudinalBarsFromCoordinates(LongitudinalRebarMaterial);
KodestructAci.IConcreteFlexuralMember fs = new KodestructAci14.ConcreteSectionFlexure(shape, LongitudinalBars, null, ConfinementReinforcementType);
IConcreteSectionWithLongitudinalRebar Section = fs as IConcreteSectionWithLongitudinalRebar;
ConcreteSectionCompression column = new ConcreteSectionCompression(Section, ConfinementReinforcementType, null);
//Convert axial force to pounds
List <PMPair> Pairs = column.GetPMPairs(p, 50, true);
var PairsAdjusted = Pairs.Select(pair => new PMPair(pair.P / 1000.0, pair.M / 1000.0 / 12.0));
string Filename = Path.Combine(Path.GetTempPath(), "PMInteractionShearWallMaxIteration.csv");
using (CsvFileWriter writer = new CsvFileWriter(Filename))
{
foreach (var pair in PairsAdjusted)
{
CsvRow row = new CsvRow();
row.Add(pair.M.ToString());
row.Add(pair.P.ToString());
writer.WriteRow(row);
}
}
}
public void AgencyWriter()//(CsvRow row)
{
// Write sample data to CSV file
using (CsvFileWriter writer = new CsvFileWriter("agency.txt"))
{
/*
* //----------------------------------------------- WORKING
* CsvRow AgencyRow = new CsvRow();
*
* foreach (string s in AgencyDataList)
* {
* AgencyRow.Add(s);
* }
*
*
* writer.WriteRow(AgencyRow);
* //---------------------------------------------- WORKING
*/
CsvRow AgencyRowValues = new CsvRow();
for (int i = 0; i < 8; i++)
{
AgencyRowValues.Add(AgencyDataList[i]);
}
writer.WriteRow(AgencyRowValues);
CsvRow AgencyRowData = new CsvRow();
for (int i = 8; i < AgencyDataList.Count; i++)
{
AgencyRowData.Add(AgencyDataList[i]);
}
writer.WriteRow(AgencyRowData);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
int valid = 1;
if (File.Exists(fileLocation))
{
FileStream aStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List <string> studentRecord = new List <string>();
while (aReader.ReadRow(studentRecord))
{
string regNo = studentRecord[0];
if (regNo == regNoTextBox.Text)
{
valid = 0;
break;
}
}
aStream.Close();
}
if (valid == 0)
{
MessageBox.Show("Same Reg No");
}
else if (valid == 1)
{
FileStream fileStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(fileStream);
List <string> record = new List <string>();
record.Add(regNoTextBox.Text);
record.Add(nameInputTextBox.Text);
aWriter.WriteRow(record);
fileStream.Close();
MessageBox.Show("Saved.");
}
}
public static void Main(string[] args)
{
// Everything starts with initializing Host, which manages connection to the
// Tobii Engine and provides all the Tobii Core SDK functionality.
// NOTE: Make sure that Tobii.EyeX.exe is running
var host = new Host();
// 2. Create stream.
var gazePointDataStream = host.Streams.CreateGazePointDataStream();
gazePointDataStream.GazePoint((gazePointX, gazePointY, _) => Console.WriteLine("X: {0} Y:{1}", gazePointX, gazePointY));
// Console.ReadKey();
// 3. Get the gaze data!
using (CsvFileWriter writer = new CsvFileWriter("TobiiData.csv"))
{
//gazePointDataStream.GazePoint((x, y, ts) =>
//{
// CsvRow row = new CsvRow();
// row.Add(String.Format("{0},{1},{2}", ts, x, y));
// writer.WriteRow(row);
// Console.WriteLine("inside the writer function");
//});
Console.WriteLine("Before picking up gaze");
Console.WriteLine(gazePointDataStream.GazePoint((gazePointX, gazePointY, _) => Console.WriteLine("X: {0} Y:{1}", gazePointX, gazePointY)));
Console.WriteLine("Writing Tobii data to CSV...");
Console.WriteLine("press any key when this window is focused to end");
Console.Read();
// we will close the coonection to the Tobii Engine before exit.
host.DisableConnection();
}
}
private void Application_Exit(object sender, ExitEventArgs e)
{
if (Timethread != null)
{
Timethread.Abort();
}
if (checkFile != null)
{
this.checkFile.Abort();
}
Alarms.Write(_FILE_Alarm_Data, DataAlarm);
Users.write(_FILE_User_Data, DataUser);
Cameras.Write(_FILE_Camera_Data, DataCamera);
// Map.Write(_FILE_Map_Data, Map);
Presets.Write(_FILE_PRESET_DATA, DataPreset);
// Config.Write(_FILE_Config, setting);
if (m_bInitSDK == true)
{
CHCNetSDK.NET_DVR_Cleanup();
}
using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_CSV_COMMAND, FileMode.Append), Encoding.UTF8))
{
for (int i = 0; i < Rows.Count; i++)
{
LogCSV.WriteRow(Rows[i]);
}
}
using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_Send_COMMAND, FileMode.Append), Encoding.UTF8))
{
for (int i = 0; i < RowsSend.Count; i++)
{
LogCSV.WriteRow(RowsSend[i]);
}
}
//VlcContext.CloseAll();
}
private void saveButton_Click(object sender, EventArgs e)
{
string amount = amountTextBox.Text;
string particular = particularTextBox.Text;
string categoryEntry = categoryForEntryComboBox.Text;
FileStream aFileStream = new FileStream(path, FileMode.Append);
CsvFileWriter aStreamWriter = new CsvFileWriter(aFileStream);
List <string> dailyExpense = new List <string>();
dailyExpense.Add(amount);
dailyExpense.Add(categoryEntry);
dailyExpense.Add(particular);
aStreamWriter.WriteRow(dailyExpense);
aFileStream.Close();
//aStreamWriter.Write(amount + "," + categoryEntry + "," + particular);
//aStreamWriter.WriteLine();
//aStreamWriter.Close();
//aFileStream.Close();
MessageBox.Show("Saved");
particularTextBox.Text = "";
amountTextBox.Text = "";
categoryForEntryComboBox.Text = "";
}
/// <summary>
/// Save data into stream.
/// </summary>
/// <param name="stream">Data stream.</param>
/// <param name="data">Data.</param>
/// <param name="metaInfo">Meta-information on data for one day.</param>
public override void Serialize(Stream stream, IEnumerable <TCandleMessage> data, IMarketDataMetaInfo metaInfo)
{
var candleMetaInfo = (CandleCsvMetaInfo)metaInfo;
var toWrite = candleMetaInfo.Process(data);
CultureInfo.InvariantCulture.DoInCulture(() =>
{
var writer = new CsvFileWriter(stream, Encoding);
try
{
foreach (var item in toWrite)
{
Write(writer, item, candleMetaInfo);
}
}
finally
{
writer.Writer.Flush();
}
});
}
private void Write(IEnumerable <T> items, bool append, bool clear)
{
using (var stream = new FileStream(_fileName, FileMode.OpenOrCreate))
{
if (clear)
{
stream.SetLength(0);
}
if (append)
{
stream.Position = stream.Length;
}
using (var writer = new CsvFileWriter(stream, _encoding))
{
foreach (var item in items)
{
Write(writer, item);
}
}
}
}
public void WriteValues()
{
using (var writer = new CsvFileWriter("D://2.csv"))
{
writer.WriteRow(new List <string> {
"Id", "Age", "啦啦啦"
});
// Write each row of data
for (int row = 0; row < 100; row++)
{
// TODO: Populate column values for this row
List <string> columns = new List <string>()
{
row.ToString(),
(20 + row).ToString(),
"啦啦啦" + row
};
writer.WriteRow(columns);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
FileStream aFileStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aFileStream);
List<string> aRecordList = new List<string>();
while (aReader.ReadRow(aRecordList))
{
string number = aRecordList[0];
if(number == txtPhoneNumber.Text)
{
MessageBox.Show("Wrong Entry");
aFileStream.Close();
return;
}
}
aFileStream.Close();
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> addressRecord = new List<string>();
addressRecord.Add(txtPhoneNumber.Text);
addressRecord.Add(txtName.Text);
addressRecord.Add(txtEmail.Text);
addressRecord.Add(txtAddress.Text);
addressRecord.Add(txtHomePhone.Text);
aWriter.WriteRow(addressRecord);
aStream.Close();
}
void WriteDoneFileOutHeader(CsvFileWriter writer)
{
CsvRow row = new CsvRow();
row.Add("LongShort");
row.Add("Count");
row.Add("Rate");
row.Add("Price");
row.Add("Notional");
row.Add("LongDate");
row.Add("LongPrice");
writer.WriteRow(row);
}
//Add a stater to the stater list.
private void addStaterToStaterListToolStripMenuItem_Click(object sender, EventArgs e)
{
createStaterObjects();
Form3 form3 = new Form3();
if (form3.ShowDialog() == DialogResult.OK)
{
staters.Add(new Stater(form3.firstName, form3.lastName));
staters[staters.Count - 1].Barcode = form3.pin;
staters[staters.Count - 1].City = form3.city;
staters[staters.Count - 1].County = form3.county;
string filePath = loadStaterList();
using (CsvFileWriter writer = new CsvFileWriter(filePath))
{
foreach (Stater s in staters)
{
CsvRow row = new CsvRow() { s.Barcode.ToString(), s.FirstName, s.LastName, s.City, s.County };
writer.WriteRow(row);
}
}
createStaterObjects();
if (programRunning != "")
{
Picture.Text += form3.pin + "\n";
Picture.Focus();
Picture.SelectionStart = Picture.Text.Length + 1;
SendKeys.Send("{ENTER}");
}
}
}
void WriteHeader(CsvFileWriter writer)
{
CsvRow row = new CsvRow();
row.Add("CurDate");
row.Add("KospiWeight");
writer.WriteRow(row);
}
void Write_PbTLog_FileOut_Header(CsvFileWriter writer)
{
CsvRow row = new CsvRow();
//row.Add("Date");
//row.Add("Count");
//row.Add("Rate");
//row.Add("Price");
//row.Add("Notional");
//TODO
writer.WriteRow(row);
}
void WriteRemainLongFileOutHeader(CsvFileWriter writer)
{
CsvRow row = new CsvRow();
row.Add("Date");
row.Add("Count");
row.Add("Rate");
row.Add("Price");
row.Add("Notional");
writer.WriteRow(row);
}
void WriteRemainLongBody(KtbSpotPosition longPos, CsvFileWriter writer)
{
CsvRow row = new CsvRow();
row.Add(longPos.TradingDate.ToString("yyyy-MM-dd"));
row.Add("" + longPos.Count);
row.Add(longPos.Rate.ToString("n5"));
row.Add("" + longPos.Price);
row.Add("" + longPos.Notional);
writer.WriteRow(row);
}
void WriteDoneBody(KtbSpotDonePosition done, CsvFileWriter writer)
{
CsvRow row = new CsvRow();
row.Add("" + done.ShortPosition.Long_2_Short_1);
row.Add("" + done.ShortPosition.Count);
row.Add(done.ShortPosition.Rate.ToString("n5"));
row.Add("" + done.ShortPosition.Price);
row.Add("" + done.ShortPosition.Notional);
row.Add("" + done.LongPosition.TradingDate.ToString("yyyyMMdd"));
row.Add("" + done.LongPosition.Price);
writer.WriteRow(row);
}
void RemainLong_FileOut()
{
const string kSubFolder = @"remains\";
string fileName = String.Format("{0}_remains.csv", _today.ToString("yyyy_MM_dd"));
string remains_path = String.Format("{0}{1}{2}", kFolder, kSubFolder, fileName);
CsvFileWriter writer = new CsvFileWriter(remains_path);
WriteRemainLongFileOutHeader(writer);
foreach (KtbSpotPosition longPos in this.RemainLongs)
{
WriteRemainLongBody(longPos, writer);
}
writer.Flush();
writer.Close();
}
void PbTLog_FileOut()
{
const string kSubFolder = @"pb_tlog\";
string fileName = String.Format("{0}_pb_tlog.csv", _today.ToString("yyyy_MM_dd"));
string path = String.Format("{0}{1}{2}", kFolder, kSubFolder, fileName);
CsvFileWriter writer = new CsvFileWriter(path);
//TODO
writer.Flush();
writer.Close();
}
void Done_FileOut()
{
const string kSubFolder = @"dones\";
string fileName = String.Format("{0}_dones.csv", _today.ToString("yyyy_MM_dd"));
string path = String.Format("{0}{1}{2}", kFolder, kSubFolder, fileName);
CsvFileWriter writer = new CsvFileWriter(path);
WriteDoneFileOutHeader(writer);
foreach (KtbSpotDonePosition done in this.Dones)
{
WriteDoneBody(done, writer);
}
writer.Flush();
writer.Close();
}
