|
public ReadRow ( List |
||
| columns | List |
Collection to hold the columns read |
| return | bool | |
private void viewSummeryShowButton_Click(object sender, EventArgs e)
{
FileStream bStream = new FileStream(path, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(bStream);
List <string> aDailyExpenseRecord = new List <string>();
showListBox.Items.Clear();
double totalAmount = 0;
List <int> aAmount = new List <int>();
while (aReader.ReadRow(aDailyExpenseRecord))
{
string amount = aDailyExpenseRecord[0];
aAmount.Add(Convert.ToInt32(amount));
totalAmount += Convert.ToDouble(amount);
}
totalExpenceViewTextBox.Text = totalAmount.ToString();
string amount1 = Convert.ToString(aAmount.Max());
maximumExpenceViewTextBox.Text = amount1;
bStream.Close();
}
private void categorywiseExpenseShowButton_Click(object sender, EventArgs e)
{
FileStream cStream = new FileStream(path, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(cStream);
List <string> cRecord = new List <string>();
showListBox.Items.Clear();
double totalamount = 0;
while (aReader.ReadRow(cRecord))
{
if (cRecord[1] == viewCategorywiseExpenseComboBox.Text)
{
string amount = cRecord[0];
string category = cRecord[1];
string particular = cRecord[2];
showListBox.Items.Add(amount + " " + category + " " + particular);
//string viewAmount = cRecord[0];
totalamount += Convert.ToDouble(cRecord[0]);
}
showTotalTextBox.Text = totalamount.ToString();
}
cStream.Close();
}
private bool UniqueCheker(string studentReg)
{
int studentRegInt = Convert.ToInt32(studentReg);
FileStream aFileStream = new FileStream(filePath, FileMode.Open);
CsvFileReader aCsvFileReader = new CsvFileReader(aFileStream);
List <string> aStudentDataRead = new List <string>();
showStudentDataListBox.Items.Clear();
bool a = true;
while (aCsvFileReader.ReadRow(aStudentDataRead))
{
int studentRegNo = Convert.ToInt32(aStudentDataRead[0]);
if (studentRegInt == studentRegNo)
{
a = false;
break;
}
else
{
a = true;
}
}
aFileStream.Close();
return(a);
}
private void B_PREVIEW_Click(object sender, EventArgs e)
{
try
{
if (!TXT_FILENAME.Text.Equals(""))
{
using (CsvFileReader reader = new CsvFileReader(TXT_FILENAME.Text))
{
authenCodes = new List <ModelAuthenCode>();
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
//Login,Password,Uptime Limit,Used Uptime,Used Download,Used Upload
ModelAuthenCode model = new ModelAuthenCode();
model.ath_code = row[1];
model.ath_user = row[0];
model.ath_pass = row[1];
model.ath_use = "0";
model.station_id = Convert.ToInt32(lounge_site.SelectedValue);
model.createDate = DateTime.Now;
authenCodes.Add(model);
}
dataGridView1.DataSource = authenCodes;
if (authenCodes.Count > 0)
{
B_LOAD.Enabled = true;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// This function reads data from input csv
/// </summary>
/// <param name="inputFile"></param>
/// <param name="outputXMLFile"></param>
/// <returns>Policy list populated by CSV</returns>
public List <Policy> PopulatePolicyFromCSV(string inputFile)
{
List <Policy> policies = new List <Policy>();
try
{
using (var sr = new StreamReader(inputFile, Encoding.GetEncoding("gbk")))
{
var reader = new CsvFileReader(sr);
var row = new List <string>();
int rowNumber = 1;
while (reader.ReadRow(row))
{
//To avoid Header row to be added as policy record
if (rowNumber++ > 1)
{
policies.Add(new Policy(row));
}
}
}
}
catch (Exception ex)
{
Log.Error("Exception while reading input CSV", ex);
}
return(policies);
}
private void ReportBox_SelectedIndexChanged(object sender, EventArgs e)
{
//ProductTable table = new ProductTable();
//String path = (ReportBox.SelectedItem as ComboboxItem).Value.ToString();
ProductTable table = new ProductTable();
if (ReportBox.SelectedIndex == -1)
{
return;
}
String path = upcFiles[ReportBox.SelectedIndex];
using (CsvFileReader reader = new CsvFileReader(path))
{
CsvRow rowcsv = new CsvRow();
while (reader.ReadRow(rowcsv))
{
table.addRow(rowcsv[0], rowcsv[1], rowcsv[2]);
}
}
DataView view = new DataView(table);
reportGrid.DataSource = view;
reportGrid.TableStyles.Clear();
reportGrid.TableStyles.Add(table.getStyle());
}
private void ShowExpenseButton_Click(object sender, EventArgs e)
{
if (File.Exists(path))
{
FileStream aStream = new FileStream(path, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List <string> expenseRecord = new List <string>();
List <Double> salaryRecord = new List <Double>();
Double totalAmount = 0, max;
totalExpenseText.Text = String.Empty;
maxExpenseText.Text = String.Empty;
while (aReader.ReadRow(expenseRecord))
{
string amount = expenseRecord[0];
expenseRecord.Add(amount);
salaryRecord.Add(Convert.ToDouble(expenseRecord[0]));
totalAmount += Convert.ToDouble(expenseRecord[0]);
}
totalExpenseText.Text = totalAmount.ToString();
max = salaryRecord.Max();
maxExpenseText.Text = Convert.ToString(max);
aStream.Close();
}
else
{
MessageBox.Show("No record exists!");
}
}
public void Load()
{
_recordCnt = GetRecordCount();
_input = new int[_recordCnt, _inputNum];
_label = new int[_recordCnt, _labelNum];
using (CsvFileReader reader = new CsvFileReader(_filename))
{
CsvRow row = new CsvRow();
int rowNum = 0;
while (reader.ReadRow(row))
{
int rowCnt = row.Count;
for (int i = 0; i < rowCnt; i++)
{
if (i == rowCnt - 1)
{
_label[rowNum, 0] = int.Parse(row[i]);
}
else
{
_input[rowNum, i] = int.Parse(row[i]);
}
}
rowNum++;
}
}
}
private void showCategoryButton_Click(object sender, EventArgs e)
{
double total = 0, sum = 0;
FileStream aFileStream = new FileStream(path, FileMode.Open);
CsvFileReader aFileReader = new CsvFileReader(aFileStream);
List <string> categoryExpense = new List <string>();
categoryListBox.Items.Clear();
while (aFileReader.ReadRow(categoryExpense))
{
string category = categoryComboBox.Text;
foreach (string search in categoryExpense)
{
if (categoryExpense[1].ToLower().Contains(category.ToLower()))
{
total = Convert.ToDouble(categoryExpense[0]);
categoryListBox.Items.Add(total + " : " + categoryExpense[2]);
sum = total + sum;
break;
}
}
totalCategoryExpenseTextBox.Text = Convert.ToString(sum);
}
aFileStream.Close();
}
//Load the data from the csv database
public void LoadFromCSV(string fileName)
{
// Read sample data from CSV file
using (CsvFileReader reader = new CsvFileReader(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "MarvelDB", fileName)))
{
heroesByName = new ObservableCollection <SuperHero>();
List <string> tempList = new List <string>();
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
tempList.Clear();
//Load row data into list
foreach (string value in row)
{
tempList.Add(value);
}
Race tempRace = Enum.Parse <Race>(tempList[4]);
//Add the row's hero to the csv file
heroesByName.Add(new SuperHero(tempList[0], tempList[1], Convert.ToDouble(tempList[2]), Convert.ToDouble(tempList[3]), tempRace, Convert.ToBoolean(tempList[5])));
Console.WriteLine();
}
}
}
private void showCatagoryWiseExpenseButton_Click(object sender, EventArgs e)
{
showListView.Items.Clear();
int catagoryWiseTotal = 0;
FileStream aFileStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aFileStream);
List <string> aList = new List <string>();
ListViewItem item;
while (aReader.ReadRow(aList))
{
if (aList[1] == secondCatagoryComboBox2.Text)
{
item = new ListViewItem(aList[0].ToString());
item.SubItems.Add(aList[1]);
item.SubItems.Add(aList[2]);
showListView.Items.Add(item);
catagoryWiseTotal = catagoryWiseTotal + Convert.ToInt32(aList[0]);
}
}
totalCatagoryWiseExpenseTextBox.Text = Convert.ToString(catagoryWiseTotal);
aFileStream.Close();
}
public void ImportCities([FromUri] string fileName = "GeoLiteCity-Location.csv")
{
var row = new List <string>();
var batch = Redis.CreateBatch();
using (var reader = new CsvFileReader(GetLocalFile(fileName))) {
var count = 0;
while (reader.ReadRow(row))
{
if (row.Count < 4 || !char.IsDigit(row[0][0]))
{
continue;
}
var cityId = row[0];
var country = row[1];
var region = row[2];
var city = row[3];
var json = JsonConvert.SerializeObject(new { city, region, country });
batch.HashSetAsync("cityid2city:", cityId, json);
count++;
if (count % 1000 == 0)
{
batch.Execute();
}
}
batch.Execute();
}
}
public static void CsvLoadTripRoutes(string filename, bool lngFirst)
{
// load trip routes
Dictionary<string, LinkedList<Waypoint>> routes = new Dictionary<string, LinkedList<Waypoint>>();
using (CsvFileReader reader = new CsvFileReader(filename))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row, ','))
{
string routeID = row[0];
double distance = 0;
double lat = Convert.ToDouble(lngFirst ? row[2] : row[1]);
double lng = Convert.ToDouble(lngFirst ? row[1] : row[2]);
if (routes.ContainsKey(routeID))
distance = routes[routeID].First.Value.GetDistance(new Location(lat, lng, "null"));
Waypoint waypoint = new Waypoint(lat, lng, TimeSpan.Parse(row[3]), distance, row[4].Replace("\"", ""));
// Scenario #1
if (!routes.ContainsKey(routeID))
routes[routeID] = new LinkedList<Waypoint>();
routes[routeID].AddLast(waypoint);
}
}
foreach (LinkedList<Waypoint> w in routes.Values)
{
Route r = new Route(w.ToArray());
string key = Route.GetKey(r.start, r.end);
MapTools.routes.Add(key, r);
}
}
void calculateQuadPositionsTVis()
{
CsvRow row = new CsvRow();
int i = 0;
using (CsvFileReader reader = new CsvFileReader("Assets/TVis.layout"))
{
foreach (MetaDataItem mdi in this.targetMetadataParser.output)
{
float ang, dist;
reader.ReadRow(row);
//Debug.Log (row[0] + ", " + row[1] + ", " + row[2]);
Transform q = mdi.transform;
Vector3 pos = q.localPosition;
ang = float.Parse(row[0]) * Mathf.PI * 2;
dist = float.Parse(row[2]);
pos.x = Mathf.Cos(ang) * dist;
pos.y = float.Parse(row[1]);
pos.z = Mathf.Sin(ang) * dist;
q.localPosition = pos;
q.LookAt(q.localPosition * 2);
i++;
/* Only displays the first 350 quads */
if (i >= 350)
{
break;
}
}
}
}
private void showButton_Click(object sender, EventArgs e)
{
double total = 0;
FileStream aStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List <string> dailyExpense = new List <string>();
List <string> maxExpense = new List <string>();
while (aReader.ReadRow(dailyExpense))
{
amount = Convert.ToDouble(dailyExpense[0]);
double check = amount;
total += amount;
maxExpense.Add(amount.ToString());
}
double maximum = Convert.ToDouble(maxExpense.Max());
maximumExpenseTextBox.Text = maximum.ToString();
totalExpenseTextBox.Text = total.ToString();
aStream.Close();
}
private void showButton_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))
{
ListViewItem listViewItem = new ListViewItem(new string[]
{
aPeronRecord[0],
aPeronRecord[1],
aPeronRecord[2],
aPeronRecord[3],
aPeronRecord[4]
}
);
personListView.Items.Add(listViewItem);
}
aStream.Close();
}
private void UIDAfter_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Files (*.csv)|*.csv|All files (*.*)|*.*";
openFileDialog.InitialDirectory = @"Documents";
if (openFileDialog.ShowDialog() == true)
{
try
{
using (CsvFileReader csvReader = new CsvFileReader(openFileDialog.FileName))
{
NameFileExportFolder.Text = openFileDialog.FileName.Substring(0, openFileDialog.FileName.Length - openFileDialog.SafeFileName.Length - 1);
UIDAfter.Text = openFileDialog.FileName;
List <string> row = new List <string>();
List <string> dataId = new List <string>();
List <string> dataPhone = new List <string>();
while (csvReader.ReadRow(row))
{
dataId.Add(row[1]);
dataPhone.Add(row[4]);
}
dataIdAfter = dataId.Distinct().ToList();
dataPhoneAfter = dataPhone.Distinct().ToList();
}
}
catch (Exception)
{
NameFileExportFolder.Text = "";
UIDAfter.Text = "";
MessageBoxResult result = MessageBox.Show("Lỗi. Bạn đang mở file hoặc file bạn đang bị lỗi. Làm ơn check lại !!!!");
}
}
}
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();
}
private void vsShowButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(filepath, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List <string> newExpanseList = new List <string>();
List <double> expenses = new List <double>();
double totalExpense = 0;
double maxExpense;
while (aReader.ReadRow(newExpanseList))
{
// double expense = Convert.ToDouble(newExpanseList[0]);
// expenses.Add(expense);
expenses.Add(Convert.ToDouble(newExpanseList[0]));
}
foreach (double expense in expenses)
{
totalExpense += expense;
}
vsTotalTxtBox.Text = totalExpense.ToString();
aStream.Close();
maxExpense = expenses.Max();
maxTxtBox.Text = maxExpense.ToString();
aStream.Close();
}
public EventPointsReader(String filePath, Boolean skipHeader)
{
this.EventPoints = new List<EventPoint>();
CsvFileReader reader = new CsvFileReader(filePath);
Boolean headerSkipped = false;
while (true)
{
CsvRow row = new CsvRow();
if (reader.ReadRow(row))
{
if ((skipHeader && headerSkipped) ||
!skipHeader)
{
EventPoint ep = new EventPoint();
ep.LongCode = row[0];
ep.ShortCode = row[1];
ep.DateTimeFrom = DateTime.ParseExact(row[2], "yyyy-MM-dd HH:mm:ss.fff", null);
ep.DateTimeTo = DateTime.ParseExact(row[3], "yyyy-MM-dd HH:mm:ss.fff", null);
ep.RangeMax = Convert.ToDouble(row[4]);
ep.RangeMin = Convert.ToDouble(row[5]);
this.EventPoints.Add(ep);
}
headerSkipped = true;
}
else
{
break;
}
}
}
private void FileChoosing_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Files (*.csv)|*.csv|All files (*.*)|*.*";
openFileDialog.InitialDirectory = @"Documents";
if (openFileDialog.ShowDialog() == true)
{
try
{
using (CsvFileReader csvReader = new CsvFileReader(openFileDialog.FileName))
{
FileChoosing.Text = openFileDialog.FileName;
DeleteListData();
List <string> row = new List <string>();
while (csvReader.ReadRow(row))
{
DataInfo dataInfo = new DataInfo();
dataInfo.Directory = row[0];
dataInfo.NameFile = row[1];
dataListFolder.Add(dataInfo);
}
}
}
catch
{
FileChoosing.Text = "";
MessageBoxResult result = MessageBox.Show("Lỗi. Bạn đang mở file hoặc file bạn đang bị lỗi. Làm ơn check lại !!!!");
}
}
}
public void ImportIps([FromUri] string fileName = "GeoLiteCity-Blocks.csv")
{
var row = new List <string>();
using (var reader = new CsvFileReader(GetLocalFile(fileName))) {
var count = 0;
var batch = Redis.CreateBatch();
while (reader.ReadRow(row))
{
var startIp = row.Any() ? row[0] : string.Empty;
if (startIp.ToLower().Contains('i'))
{
continue;
}
long score;
if (startIp.Contains('.'))
{
score = IpToScore(startIp);
}
else if (!long.TryParse(startIp, out score))
{
continue;
}
var cityId = $"{row[2]}_{count}";
batch.SortedSetAddAsync("ip2cityid:", cityId, score);
count++;
if (count % 1000 == 0)
{
batch.Execute();
}
}
batch.Execute();
}
}
private void StopTimesReader()
{
if (File.Exists(filename))
{
// Read sample data from CSV file
using (CsvFileReader reader = new CsvFileReader(filename))
{
CsvRow Row = new CsvRow();
while (reader.ReadRow(Row))
{
foreach (string s in Row)
{
StopTimesDataList.Add(s);
}
}
}
if (StopTimesDataList.Count == 0)
{
FileError = true;
}
}
else
{
FileStream fs = new FileStream(filename, FileMode.CreateNew);
fs.Close();
FileError = true;
}
StopTimesPositions();
}
private void loadSNPSPToolStripMenuItem_Click(object sender, EventArgs e)
{
_openFileDialog.FileName = "SNPCC.csv";
_openFileDialog.Filter = "csv files (*.csv)|*.csv";
_openFileDialog.DefaultExt = "txt";
_openFileDialog.FilterIndex = 2;
_openFileDialog.AddExtension = true;
if (_openFileDialog.ShowDialog() == DialogResult.OK)
{
string fileName = _openFileDialog.FileName;
CsvFileReader csv = new CsvFileReader(fileName);
char[] _separators = new char[] { '\n', '"', ',' };
CsvRow row = new CsvRow();
bool entering = true;
while (entering == true)
{
entering = csv.ReadRow(row);
staters.Add(new Stater(row[1], row[0]));
char[] bar = row[2].ToCharArray();
string bs = Convert.ToString(bar[0]) + Convert.ToString(bar[1]) + Convert.ToString(bar[2]) + Convert.ToString(bar[3]);
staters[staters.Count - 1].Barcode = Convert.ToInt32(bs);
staters[staters.Count - 1].City = row[3];
staters[staters.Count - 1].County = row[4];
}
csv.Close();
staters.RemoveAt(staters.Count - 1);
List<Stater> testing = staters;
}
}
//public void OnItemSelected()
//{
// var details = SelectedFireDept;
// App.Current.MainPage.Navigation.PushAsync(
// new DeptListPageDetail(details.DeptName, details.FdId, details.Phone, details.County, details.Address));
//}
private async void ReadData()
{
using (var stream = await FileSystem.OpenAppPackageFileAsync("usfa-registry-ny.csv"))
{
using (CsvFileReader reader = new CsvFileReader(stream))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
FireDept myFireDept = new FireDept();
Address myAddress = new Address();
myFireDept.FdId = row[0];
myFireDept.DeptName = row[1];
myAddress.Street = row[2];
myAddress.City = row[4];
myAddress.State = row[5];
myAddress.Zip = row[6];
myFireDept.Address = myAddress;
myFireDept.Phone = row[13];
myFireDept.County = row[15];
myFireDept.DeptType = row[16];
myFireDept.Website = row[18];
FireDeptList.Add(myFireDept);
}
}
}
}
private void vceButton_Click(object sender, EventArgs e)
{
if (categoryCombo2.Text != "")
{
string selectedCategory;
string category;
double vceTotal = 0;
FileStream aStream = new FileStream(filepath, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List <string> newExpenseList = new List <string>();
selectedCategory = categoryCombo2.SelectedItem.ToString();
myListView.Items.Clear();
while (aReader.ReadRow(newExpenseList))
{
category = newExpenseList[1];
if (selectedCategory == category)
{
ListViewItem item = new ListViewItem();
item.Text = newExpenseList[0];
item.SubItems.Add(newExpenseList[1]);
item.SubItems.Add(newExpenseList[2]);
vceTotal += Convert.ToDouble(newExpenseList[0]);
myListView.Items.Add(item);
}
vceTotalTxtBox.Text = vceTotal.ToString();
}
aStream.Close();
}
}
public static string kToSqlCreateTable(string tblFileName, string csvFilePath)
{
string cmdText = string.Empty;
using (CsvFileReader reader = new CsvFileReader(csvFilePath))
{
CsvRow row = new CsvRow();
bool isHeader = true;
string tTblFile = tblFileName.Substring(0, tblFileName.IndexOf("_"));
Console.WriteLine("c o d i n g . . . t r a n s c o d i n g . . . t r a n s . . . . . ");
cmdText += string.Format("DROP TABLE IF EXISTS `{0}`;", tTblFile) + Environment.NewLine;
cmdText += string.Format("CREATE TABLE IF NOT EXISTS `{0}` (", tTblFile) + Environment.NewLine;
while (reader.ReadRow(row))
{
if (isHeader)
{
isHeader = false;
continue;
}
string tRowType = kToMySQLTypeStatement(row);
cmdText += "\t" + (tRowType.Equals(",") ? "" : tRowType) + Environment.NewLine;
}
cmdText = cmdText.Remove(cmdText.LastIndexOf(","), 1);
cmdText += ") ENGINE=InnoDB DEFAULT CHARSET=utf8;" + Environment.NewLine;
Console.WriteLine(cmdText);
Console.WriteLine("DONE !!!");
reader.Close();
}
return(cmdText);
}
/// <summary>
/// 将CSV文件的数据读取到DataTable中
/// </summary>
/// <param name="fileName">CSV文件路径</param>
/// <returns>返回读取了CSV数据的DataTable</returns>
//public static DataTable OpenCSV(string filePath)
//{
// Encoding encoding = Common.GetType(filePath); //Encoding.ASCII;//
// DataTable dt = new DataTable();
// FileStream fs = new FileStream(filePath, System.IO.FileMode.Open, System.IO.FileAccess.Read);
// //StreamReader sr = new StreamReader(fs, Encoding.UTF8);
// StreamReader sr = new StreamReader(fs, encoding);
// //string fileContent = sr.ReadToEnd();
// //encoding = sr.CurrentEncoding;
// //记录每次读取的一行记录
// string strLine = "";
// //记录每行记录中的各字段内容
// string[] aryLine = null;
// string[] tableHead = null;
// //标示列数
// int columnCount = 0;
// //标示是否是读取的第一行
// bool IsFirst = true;
// //逐行读取CSV中的数据
// while ((strLine = sr.ReadLine()) != null)
// {
// //strLine = Common.ConvertStringUTF8(strLine, encoding);
// //strLine = Common.ConvertStringUTF8(strLine);
// if (IsFirst == true)
// {
// tableHead = strLine.Split(',');
// IsFirst = false;
// columnCount = tableHead.Length;
// //创建列
// for (int i = 0; i < columnCount; i++)
// {
// DataColumn dc = new DataColumn(tableHead[i]);
// dt.Columns.Add(dc);
// }
// }
// else
// {
// aryLine = strLine.Split(',');
// DataRow dr = dt.NewRow();
// for (int j = 0; j < columnCount; j++)
// {
// dr[j] = aryLine[j];
// }
// dt.Rows.Add(dr);
// }
// }
// if (aryLine != null && aryLine.Length > 0)
// {
// dt.DefaultView.Sort = tableHead[0] + " " + "asc";
// }
// sr.Close();
// fs.Close();
// return dt;
//}
public static DataTable ReadCSV(string filePath)
{
DataTable dt = new DataTable();
int lineNumber = 0;
using (CsvFileReader reader = new CsvFileReader(filePath)) {
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
if (0 == lineNumber)
{
foreach (string s in row)
{
dt.Columns.Add(s.Replace("\"", ""));
}
}
else
{
int index = 0;
DataRow dr = dt.NewRow();
foreach (string s in row)
{
dr[index] = s.Replace("\"", "");
index++;
}
dt.Rows.Add(dr);
}
lineNumber++;
}
}
return(dt);
}
public Dictionary<string, Player> readPlayers()
{
Dictionary<string, Player> listPlayers = new Dictionary<string, Player>();
using (CsvFileReader reader = new CsvFileReader(file))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
listPlayers.Add(row[Constants.FName], new Player(row[Constants.FName], boolFromString(row[Constants.FBoolTerran]),
boolFromString(row[Constants.FBoolZerg]), boolFromString(row[Constants.FBoolProtoss]), boolFromString(row[Constants.FBoolRandom])));
Player temp = listPlayers[row[Constants.FName]];
int.TryParse(row[Constants.FVictoryTerran], out temp.Victory[Constants.Terran]);
int.TryParse(row[Constants.FVictoryZerg], out temp.Victory[Constants.Zerg]);
int.TryParse(row[Constants.FVictoryProtoss], out temp.Victory[Constants.Protoss]);
int.TryParse(row[Constants.FVictoryRandom], out temp.Victory[Constants.Random]);
int.TryParse(row[Constants.FDefeatTerran], out temp.Defeat[Constants.Terran]);
int.TryParse(row[Constants.FDefeatZerg], out temp.Defeat[Constants.Zerg]);
int.TryParse(row[Constants.FDefeatProtoss], out temp.Defeat[Constants.Protoss]);
int.TryParse(row[Constants.FDefeatRandom], out temp.Defeat[Constants.Random]);
int.TryParse(row[Constants.FEloTerran], out temp.Elo[Constants.Terran]);
int.TryParse(row[Constants.FEloZerg], out temp.Elo[Constants.Zerg]);
int.TryParse(row[Constants.FEloProtoss], out temp.Elo[Constants.Protoss]);
int.TryParse(row[Constants.FEloRandom], out temp.Elo[Constants.Random]);
}
}
return listPlayers;
}
private void showButton_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))
{
ListViewItem listViewItem = new ListViewItem(new string[]
{
aPeronRecord[0],
aPeronRecord[1],
aPeronRecord[2],
aPeronRecord[3],
aPeronRecord[4]
}
);
personListView.Items.Add(listViewItem);
}
aStream.Close();
}
private JsonObject buildInventory(String path)
{
//var messages = new JsonArray();
string messages;
var inventory = new JsonObject();
var epcs = new JsonArray();
SyncOrdenEsM OrderM = deserealizeNameFile(path);
using (CsvFileReader reader = new CsvFileReader(path))
{
CsvRow rowcsv = new CsvRow();
while (reader.ReadRow(rowcsv))
{
epcs.Add(rowcsv[0]);
}
}
messages = buildMessages(path);
//messages = buildMessages(path);
inventory.Add("user_id", 1);
inventory.Add("client_id", pclient_id);
inventory.Add("created_at", OrderM.date_time);
inventory.Add("updated_at", OrderM.date_time);
inventory.Add("warehouse_id", OrderM.warehouse_id);
inventory.Add("epcs", epcs);
inventory.Add("messages", messages);
//inventory.Add("messages", messages);
return(inventory);
}
public dynamic ReadNext()
{
if (_reader == null)
{
return(null);
}
List <string> row = new List <string>();
bool hasMore = _reader.ReadRow(row);
if (!hasMore)
{
_hasData = false;
return(null);
}
if (row.Count == 0 || row[(int)TextColumnIndex].Length >= CharactersLimit)
{
return(ReadNext());
}
dynamic document = new ExpandoObject();
document.id = row[(int)IdColumnIndex];
document.text = row[(int)TextColumnIndex];
if (TagColumnIndex != uint.MaxValue)
{
document.tag = row[(int)TagColumnIndex];
}
return(document);
}
private void Awake()
{
rows = new List <DataSetRow>();
List <string> row = new List <string>();
using (var reader = new CsvFileReader(pathDataset))
{
while (reader.ReadRow(row))
{
DateTime date = DateTime.Parse(row[0], null, System.Globalization.DateTimeStyles.RoundtripKind);
int tag = Int32.Parse(row[1]);
float x_pos = float.Parse(row[2], CultureInfo.InvariantCulture);
float y_pos = float.Parse(row[3], CultureInfo.InvariantCulture);
float heading = float.Parse(row[4], CultureInfo.InvariantCulture);
float direction = float.Parse(row[5], CultureInfo.InvariantCulture);
float energy = float.Parse(row[6], CultureInfo.InvariantCulture);
float speed = float.Parse(row[7], CultureInfo.InvariantCulture);
float total_distance = float.Parse(row[8], CultureInfo.InvariantCulture);
DataSetRow setRow = new DataSetRow(date, tag, x_pos, y_pos, heading, direction, energy, speed, total_distance);
rows.Add(setRow);
}
}
}
private void showallButton_Click(object sender, EventArgs e)
{
if (File.Exists(filePath))
{
FileStream aFileStream = new FileStream(filePath, FileMode.Open);
CsvFileReader aCsvFileReader = new CsvFileReader(aFileStream);
List <string> aStudentDataRead = new List <string>();
showalllistView.Items.Clear();
while (aCsvFileReader.ReadRow(aStudentDataRead))
{
//string name = aStudentDataRead[0];
//string email = aStudentDataRead[1];
//string homecontactno = aStudentDataRead[2];
//string personalcontactno = aStudentDataRead[3];
//string homeaddres = aStudentDataRead[4];
//showalllistView.Items.Add(name +"\n"+email+""+"\n"+homecontactno+"\n"+personalcontactno+"\n"+homeaddres);
ListViewItem myView = new ListViewItem(aStudentDataRead[0]);
for (int i = 1; i < 5; i++)
{
myView.SubItems.Add(aStudentDataRead[i]);
}
showalllistView.Items.Add(myView);
}
aFileStream.Close();
}
else
{
MessageBox.Show("The requested file does not exist.");
}
}
/// <summary> Reads the earthquakes from a csv file and adds them to a clusterer. The clusterer then groups
/// them to clusters. </summary>
/// <returns> Documentation in progress... </returns>
public static IEnumerable <Location> ReadCSVFile()
{
var filePath = AppDomain.CurrentDomain.BaseDirectory + @"wikilocations.csv";
using (var reader = new CsvFileReader(filePath, (char)0x09))
{
var row = new CsvRow();
while (reader.ReadRow(row))
{
if (row.Count < 3)
{
continue;
}
double x, y;
bool parsed = Double.TryParse(row[2], NumberStyles.Float, CultureInfo.InvariantCulture, out x);
x = parsed ? x : Double.NaN;
parsed = Double.TryParse(row[1], NumberStyles.Float, CultureInfo.InvariantCulture, out y);
y = parsed ? y : Double.NaN;
var post = new Location {
Title = row[0], Coordinate = new Point(x, y)
};
yield return(post);
}
}
}
private bool UniqueChek(string personalNo)
{
int personalNoInt = Convert.ToInt32(personalNo);
FileStream aFileStream = new FileStream(path, FileMode.Open);
CsvFileReader aCsvFileReader = new CsvFileReader(aFileStream);
List <string> aList = new List <string>();
showLlistBox.Items.Clear();
bool a = true;
while (aCsvFileReader.ReadRow(aList))
{
int personalnum = Convert.ToInt32(aList[2]);
if (personalNoInt == personalnum)
{
a = false;
break;
}
else
{
a = true;
}
}
aFileStream.Close();
return(a);
}
public static IEnumerable<Record> DeserializeRecordsCsv(string path)
{
if (!File.Exists(path))
{
throw new FileNotFoundException(
"The file at the specified path could not be found.");
}
List<Record> retList = new List<Record>();
using (CsvFileReader reader = new CsvFileReader(path))
{
CsvRow headers = new CsvRow();
reader.ReadRow(headers);
if (headers != ExpectedColumnHeaders.ToList())
{
throw new Exception("CSV file headers are invalid.");
}
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
retList.Add(new Record
{
Id = Convert.ToInt32(row[0]),
GivenName = row[1],
Surname = row[2],
StreetAddress = row[3],
City = row[4],
State = row[5],
ZipCode = row[6],
EmailAddress = row[7],
TelephoneNumber = row[8]
});
}
}
return retList;
}
public CsvToStringQueries(String fileName, String tableName)
{
this._fileName = fileName;
this._tableName = tableName;
CsvFileReader reader = new CsvFileReader(fileName);
CsvRow header = new CsvRow();
reader.ReadRow(header);
while (true)
{
if (reader.EndOfStream)
{
break;
}
CsvRow body = new CsvRow();
reader.ReadRow(body);
String query = CreateQuery(body, tableName);
this._queries.Add(query);
}
}
private void btnEntryShow_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List<string> record = new List<string>();
while (aReader.ReadRow(record))
{
string bill = record[0];
double aBill = Convert.ToDouble(bill);
aBill += aBill;
txtBoxTotalExpns.Text = aBill.ToString();
}
aStream.Close();
}
private void showButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List<string> aStudentRecord = new List<string>();
studentListBox.Items.Clear();
while (aReader.ReadRow(aStudentRecord))
{
string regNo = aStudentRecord[0];
string name = aStudentRecord[1];
studentListBox.Items.Add(regNo + " " + name);
}
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();
}
private void showAllButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List<string> addressBook = new List<string>();
while (aReader.ReadRow(addressBook))
{
string name = addressBook[0];
string email = addressBook[1];
string personalContact = addressBook[2];
string homeContact = addressBook[3];
string homeAddress = addressBook[4];
addressListBox.Items.Add(name + " " + email + " " + personalContact + " " + homeContact + " " + homeAddress);
}
aStream.Close();
}
public List<string> CreateInsertQueries(string fileName)
{
List<string> queries = new List<string>();
CsvFileReader reader = new CsvFileReader(fileName);
bool firstRowRead = false;
while (true)
{
if (reader.EndOfStream)
{
break;
}
CsvRow row = new CsvRow();
reader.ReadRow(row);
if (!firstRowRead)
{
firstRowRead = true;
continue;
}
if (row[4].CompareTo("USD") == 0)
{
continue;
}
string ticker = String.Format("USD{0} Curncy", row[4]);
string desc = String.Format("{0} / 1 usd currency", row[0]);
string queryDelete = String.Format(
"delete from product_list where ticker = '{0}'", ticker);
string queryInsert = String.Format(
"insert into product_list values ('{0}', 'USD', '{1}', 0, 0, 'Index')",
ticker, desc);
queries.Add(queryDelete);
queries.Add(queryInsert);
}
return queries;
}
/// <summary> Reads the earthquakes from a csv file and adds them to a clusterer. The clusterer then groups
/// them to clusters. </summary>
/// <returns> Documentation in progress... </returns>
public static IEnumerable<Location> ReadCSVFile()
{
var filePath = AppDomain.CurrentDomain.BaseDirectory + @"wikilocations25000.csv";
using (var reader = new CsvFileReader(filePath, (char)0x09))
{
var row = new CsvRow();
while (reader.ReadRow(row))
{
if (row.Count < 3)
continue;
double x, y;
bool parsed = Double.TryParse(row[2], NumberStyles.Float, CultureInfo.InvariantCulture, out x);
x = parsed ? x : Double.NaN;
parsed = Double.TryParse(row[1], NumberStyles.Float, CultureInfo.InvariantCulture, out y);
y = parsed ? y : Double.NaN;
var post = new Location { Title = row[0], Coordinate = new Point(x, y) };
yield return post;
}
}
}
// GET api/product/5
public IEnumerable<ProductItem> Get(int id)
{
List<ProductItem> productList = new List<ProductItem>();
int rowid = 0;
// Read sample data from CSV file
using (CsvFileReader reader = new CsvFileReader(productfilePath))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
if (rowid > 0)
{
productList.Add(new ProductItem() { ProductId = Convert.ToInt32(row[0]), Name = row[1], ImageUrl = row[2], Price = Convert.ToDouble(row[3]), Calories = Convert.ToInt32(row[4]) });
}
rowid++;
}
}
return productList.FindAll(product=>product.ProductId==id);
}
private void showButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStream);
List<string> aEmployeeRecord = new List<string>();
double total = 0;
while (aReader.ReadRow(aEmployeeRecord))
{
string employeeName = aEmployeeRecord[0];
string id = aEmployeeRecord[1];
string salaryAmount = aEmployeeRecord[2];
total += Convert.ToDouble(salaryAmount);
employeeListBox.Items.Add(employeeName + " " + id + " " + salaryAmount);
totalAmountTextBox.Text = Convert.ToString(total);
}
aStream.Close();
}
/// <summary>
/// Reads the csv file, decides what type of words are stored there and put them into Output list
/// </summary>
/// <param name="worker"></param>
public void ReadFile(BackgroundWorker worker)
{
// Initialize lines numbers
int oldProgress = 0;
LinesNumber = File.ReadLines(this.filename).Count(); // don't need to close, it closes automatically
LinesProcessed = 0;
try
{
/* Using statement will call a Disposable object on the reader object after exiting using scope
This will ensure secure resources disposal
Use this construction for reading files or any other resource-sensitive objects */
using (CsvFileReader reader = new CsvFileReader(this.filename))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
ParseRowList(row);
// Calculate and report progress in percentage
LinesProcessed++;
double progress = ((double)LinesProcessed / (double)LinesNumber) * 100;
// report only if there was was a whole change in progress, 1->2, 56->57 etc.
if ((int)progress != oldProgress)
{
worker.ReportProgress((int)progress); // Progress will be reported only 100 times
}
oldProgress = (int)progress;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
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();
}
//Upload the stater list into the program.
private void createStaterObjects()
{
staters.Clear();
string pathstring = loadStaterList();
CsvFileReader csv = new CsvFileReader(pathstring);
char[] _separators = new char[] { '\n', '"', ',' };
CsvRow row = new CsvRow();
bool entering = true;
while (entering == true)
{
entering = csv.ReadRow(row);
if (row.Count != 5)
{
label1.Size = new Size(200, 30);
label1.Location = new Point(50, 20);
label1.Text = pathstring + " invalid format;\nCorrect Format: First Name, Last Name, Barcode";
error = true;
}
staters.Add(new Stater(row[1], row[2]));
char[] bar = row[0].ToCharArray();
string bs = Convert.ToString(bar[0]) + Convert.ToString(bar[1]) + Convert.ToString(bar[2]) + Convert.ToString(bar[3]);
staters[staters.Count - 1].Barcode = Convert.ToInt32(bs);
staters[staters.Count - 1].City = row[3];
staters[staters.Count - 1].County = row[4];
if (staters.Count() > 1 && staters[staters.Count - 1].Barcode == staters[staters.Count - 2].Barcode)
{
staters.RemoveAt(staters.Count - 1);
break;
}
}
csv.Close();
SNPhasBeenLoaded = true;
}
//Method to Load SNP for City Photos
private void createSNPFromcsvToolStripMenuItem_Click(object sender, EventArgs e)
{
if (checkSwitchStatus())
{
Picture.Text = "";
listBox1.Items.Clear();
listBox1.SelectionMode = SelectionMode.None;
programRunning = "City Photos";
this.Text = programRunning;
error = false;
this.Controls.Remove(b);
this.Controls.Remove(c);
this.Controls.Remove(t);
this.Controls.Remove(band);
this.Controls.Remove(chorus);
this.Controls.Remove(talent);
this.Controls.Remove(activities);
this.Size = new Size(282, 326);
Picture.Text = "";
listBox1.Items.Clear();
Picture.Focus();
staters.Clear();
string pathstring = loadStaterList();
CsvFileReader csv = new CsvFileReader(pathstring);
char[] _separators = new char[] { '\n', '"', ',' };
CsvRow row = new CsvRow();
bool entering = true;
while (entering == true)
{
entering = csv.ReadRow(row);
if (row.Count != 5)
{
label1.Size = new Size(200, 30);
label1.Location = new Point(73, 24);
label1.Text = pathstring + " invalid format;\nCorrect Format: First Name, Last Name, Barcode";
error = true;
}
staters.Add(new Stater(row[1], row[2]));
char[] bar = row[0].ToCharArray();
string bs = Convert.ToString(bar[0]) + Convert.ToString(bar[1]) + Convert.ToString(bar[2]) + Convert.ToString(bar[3]);
staters[staters.Count - 1].Barcode = Convert.ToInt32(bs);
staters[staters.Count - 1].City = row[3];
if (staters.Count() > 1 && staters[staters.Count - 1].Barcode == staters[staters.Count - 2].Barcode)
{
staters.RemoveAt(staters.Count - 1);
break;
}
}
csv.Close();
rows();
SNPhasBeenLoaded = true;
//checkStaterList();
if (error == false)
{
label1.Size = new Size(130, 30);
label1.Location = new Point(73, 24);
label1.Text = "Stater list successfully loaded.";
Picture.Enabled = true;
button1.Enabled = true;
Picture.Focus();
}
else
{
label1.Size = new Size(130, 30);
label1.Location = new Point(73, 24);
label1.Text = "The stater list contains an error";
}
}
}
void LoadYesterdayLongRemains()
{
try
{
const string kRemainsFolder = @"remains\";
string fileName = String.Format("{0}_remains.csv", _yesterday.ToString("yyyy_MM_dd"));
string remains_path = String.Format("{0}{1}{2}", kFolder, kRemainsFolder, fileName);
logger.Info("{0} 읽기 시도", remains_path);
CsvFileReader reader = new CsvFileReader(remains_path);
Boolean header = true;
while (true)
{
CsvRow row = new CsvRow();
if (reader.ReadRow(row))
{
if (header)
{
header = false;
continue;
}
DateTime dt = DateTime.ParseExact(row[0], "yyyy-MM-dd", null);
long count = Convert.ToInt64(TextUtil.RemoveComma(row[1]));
double rate = Math.Round(Convert.ToDouble(row[2]), 5);
int price = Convert.ToInt32(TextUtil.RemoveComma(row[3]));
long notional = Convert.ToInt64(TextUtil.RemoveComma(row[4]));
KtbSpotPosition pos = new KtbSpotPosition();
pos.TradingDate = dt;
pos.Long_2_Short_1 = 2;
pos.Count = count;
pos.Rate = rate;
pos.Price = price;
pos.Notional = notional;
this.Longs.Add(pos);
}
else
{
break;
}
}
reader.Close();
logger.Info("Yesterday Long Remain Position Load complete.");
}
catch (System.Exception ex)
{
logger.Error(ex.ToString());
}
}
private static void LoadGeoRoutes()
{
Dictionary<string, LinkedList<Waypoint>> routes = new Dictionary<string, LinkedList<Waypoint>>();
using (CsvFileReader reader = new CsvFileReader(routes_Filename))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row, ','))
{
string routeID = row[0];
Waypoint waypoint = new Waypoint(Convert.ToDouble(row[1]), Convert.ToDouble(row[2]), TimeSpan.Parse(row[3]), Convert.ToDouble(row[4]), row[5]);
// Scenario #1
if (!routes.ContainsKey(routeID))
routes[routeID] = new LinkedList<Waypoint>();
routes[routeID].AddLast(waypoint);
}
}
foreach (LinkedList<Waypoint> w in routes.Values)
{
Route r = new Route(w.ToArray());
string key = Route.GetKey(r.start, r.end);
MapTools.routes.Add(key, r);
}
}
private static void LoadGeoLocationNames()
{
using (CsvFileReader reader = new CsvFileReader(locationNames_Filename))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row, ','))
locationNames.Add(row[0], row[1]);
}
}
private static void LoadGeoLocationAddress()
{
using (CsvFileReader reader = new CsvFileReader(locationAddresses_Filename))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row, ','))
locationAddresses.Add(row[0], new Pair<string, string>(row[1], row[2]));
}
}
static void Main(string[] args)
{
Console.WriteLine("This is a simple program to copy the sample data to your Windows Azure storage account. This can take some time, depending on your network speed. Make sure you have changed the data connection string to point to your storage account.");
// this could be easily re-written to use batching in the client storage api,
// but I wanted to be consistent with how we access table storage through the sample.
// And you will likely only run this once.
AzureTable<Store> _Stores;
AzureTable<ZipStore> _ZipCodes;
AppSettingsReader myAppSettings = new AppSettingsReader();
const int numberOfStores = 1000;
const int numberOfZipCodes = 42192;
var factory = new AzureStorageFactory(CloudStorageAccount.Parse((string)myAppSettings.GetValue("DataConnectionString", typeof(string))));
_Stores = (AzureTable<Store>)factory.GetTable<Store>(FBwithWA.Domain.AzureConstants.StoreTableName);
_Stores.Initialize();
_ZipCodes = (AzureTable<ZipStore>)factory.GetTable<ZipStore>(FBwithWA.Domain.AzureConstants.ZipStoreTableName);
_ZipCodes.Initialize();
Console.WriteLine("Load stores..." + DateTime.Now.ToShortTimeString());
using (CsvFileReader reader = new CsvFileReader(@"Store_List.csv"))
{
int count = 0;
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
//row headers: PartitionKey,RowKey,Name,City,State,Zip
Store aStore = new Store
{
PartitionKey = row[0],
RowKey = row[1],
Name = row[2],
City = row[3],
State = row[4],
Zip = row[5]
};
_Stores.AddOrUpdate(aStore);
Console.WriteLine(string.Format("Completed: {0} of {1} stores", count.ToString(), numberOfStores));
count++;
}
}
Console.WriteLine("Load stores done. " + DateTime.Now.ToShortTimeString());
// load zip array
Console.WriteLine("Load zip code data..." + DateTime.Now.ToShortTimeString());
using (CsvFileReader reader = new CsvFileReader(@"Zip_Map.csv"))
{
int count = 0;
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
ZipStore aZipCode = new ZipStore
{
// file format: PartitionKey,RowKey,zip,store1,store2,store3
PartitionKey = row[0],
RowKey = row[1],
store1 = row[3],
store2 = row[4],
store3 = row[5]
};
_ZipCodes.AddOrUpdate(aZipCode);
Console.WriteLine(string.Format("Completed: {0} of {1} zip codes", count.ToString(), numberOfZipCodes));
count++;
}
}
Console.WriteLine("Load zip codes done. " + DateTime.Now.ToShortTimeString());
Console.WriteLine("Prese enter to exit.");
Console.ReadLine();
}
void calculateQuadPositionsTVis()
{
CsvRow row = new CsvRow();
int i = 0;
using (CsvFileReader reader = new CsvFileReader("Assets/TVis.layout"))
{
foreach (MetaDataItem mdi in this.targetMetadataParser.output) {
float ang, dist;
reader.ReadRow(row);
//Debug.Log (row[0] + ", " + row[1] + ", " + row[2]);
Transform q = mdi.transform;
Vector3 pos = q.localPosition;
ang = float.Parse(row[0]) * Mathf.PI * 2;
dist = float.Parse(row[2]);
pos.x = Mathf.Cos (ang) * dist;
pos.y = float.Parse(row[1]);
pos.z = Mathf.Sin (ang) * dist;
q.localPosition = pos;
q.LookAt(q.localPosition * 2);
i++;
/* Only displays the first 350 quads */
if (i >= 350)
break;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog _openFileDialog = new OpenFileDialog();
_openFileDialog.FileName = "SNPCC.csv";
_openFileDialog.Filter = "csv files (*.csv)|*.csv";
_openFileDialog.DefaultExt = "csv";
_openFileDialog.FilterIndex = 2;
_openFileDialog.AddExtension = true;
if (_openFileDialog.ShowDialog() == DialogResult.OK)
{
string fileName = _openFileDialog.FileName;
CsvFileReader csv = new CsvFileReader(fileName);
char[] _separators = new char[] { '\n', '"', ',' };
CsvRow row = new CsvRow();
bool entering = true;
while (entering == true)
{
entering = csv.ReadRow(row);
staters.Add(new Stater(row[1], row[2]));
char[] bar = row[0].ToCharArray();
string bs = Convert.ToString(bar[0]) + Convert.ToString(bar[1]) + Convert.ToString(bar[2]) + Convert.ToString(bar[3]);
staters[staters.Count - 1].Barcode = Convert.ToInt32(bs);
staters[staters.Count - 1].City = row[3];
staters[staters.Count - 1].County = row[4];
}
csv.Close();
}
_openFileDialog.FileName = "MasterPhotoList.csv";
_openFileDialog.Filter = "csv files (*.csv)|*.csv";
_openFileDialog.DefaultExt = "csv";
_openFileDialog.FilterIndex = 2;
_openFileDialog.AddExtension = true;
if (_openFileDialog.ShowDialog() == DialogResult.OK)
{
string fileName = _openFileDialog.FileName;
CsvFileReader csv = new CsvFileReader(fileName);
char[] _separators = new char[] { '\n', '"', ',' };
CsvRow row = new CsvRow();
bool entering = true;
while (entering == true)
{
entering = csv.ReadRow(row);
if (entering == true)
{
photoList.Add(new Stater(row[1], row[0]));
char[] bar = row[2].ToCharArray();
string bs = Convert.ToString(bar[0]) + Convert.ToString(bar[1]) + Convert.ToString(bar[2]) + Convert.ToString(bar[3]);
photoList[photoList.Count - 1].Barcode = Convert.ToInt32(bs);
}
}
csv.Close();
}
SaveFileDialog MySaveFileDialog = new SaveFileDialog();
MySaveFileDialog.DefaultExt = "csv";
if (MySaveFileDialog.ShowDialog() == DialogResult.OK)
{
using (Stream myStream = MySaveFileDialog.OpenFile())
{
if (myStream != null)
{
List<Stater> temp = new List<Stater>();
for (int i = 0; i < photoList.Count; i++)
{
temp.Add(new Stater(photoList[i].FirstName, photoList[i].LastName));
temp[temp.Count - 1].Barcode = photoList[i].Barcode;
}
for (int i = 0; i < photoList.Count; i++)
{
for (int j = 0; j < staters.Count; j++)
{
if (photoList[i].Barcode == staters[j].Barcode)
{
staters.RemoveAt(j);
}
}
}
for (int i = 0; i < photoList.Count; i++)
{
for (int j = 0; j < staters.Count; j++)
{
if (photoList[i].Barcode == staters[j].Barcode)
{
staters.RemoveAt(j);
}
}
}
using (StreamWriter myWritter = new StreamWriter(myStream, System.Text.Encoding.ASCII))
{
for (int i = 0; i < staters.Count; i++)
{
myWritter.WriteLine(staters[i].FirstName + "," + staters[i].LastName + "," + staters[i].Barcode + "," + staters[i].City + "," + staters[i].County);
}
}
}
}
}
}
private void button2_Click(object sender, EventArgs e)
{
OpenFileDialog _openFileDialog = new OpenFileDialog();
_openFileDialog.FileName = "MasterPhotoList.csv";
_openFileDialog.Filter = "csv files (*.csv)|*.csv";
_openFileDialog.DefaultExt = "csv";
_openFileDialog.FilterIndex = 2;
_openFileDialog.AddExtension = true;
if (_openFileDialog.ShowDialog() == DialogResult.OK)
{
string fileName = _openFileDialog.FileName;
CsvFileReader csv = new CsvFileReader(fileName);
char[] _separators = new char[] { '\n', '"', ',' };
CsvRow row = new CsvRow();
bool entering = true;
while (entering == true)
{
entering = csv.ReadRow(row);
if (entering == true)
{
photoList.Add(new Stater(row[1], row[0]));
char[] bar = row[2].ToCharArray();
string bs = Convert.ToString(bar[0]) + Convert.ToString(bar[1]) + Convert.ToString(bar[2]) + Convert.ToString(bar[3]);
photoList[photoList.Count - 1].Barcode = Convert.ToInt32(bs);
}
}
csv.Close();
}
_openFileDialog.FileName = "Missing Staters.csv";
_openFileDialog.Filter = "csv files (*.csv)|*.csv";
_openFileDialog.DefaultExt = "csv";
_openFileDialog.FilterIndex = 2;
_openFileDialog.AddExtension = true;
if (_openFileDialog.ShowDialog() == DialogResult.OK)
{
string fileName = _openFileDialog.FileName;
CsvFileReader csv = new CsvFileReader(fileName);
char[] _separators = new char[] { '\n', '"', ',' };
counter = 0;
CsvRow row = new CsvRow();
bool entering = true;
while (entering == true)
{
entering = csv.ReadRow(row);
if (entering == true)
{
check.Add(new Stater(row[0], row[1]));
char[] bar = row[2].ToCharArray();
string bs = Convert.ToString(bar[1]) + Convert.ToString(bar[1]) + Convert.ToString(bar[2]) + Convert.ToString(bar[3]);
check[counter].Barcode = Convert.ToInt32(bs);
check[counter].City = row[3];
check[counter].County = row[4];
}
counter++;
}
csv.Close();
}
SaveFileDialog MySaveFileDialog = new SaveFileDialog();
MySaveFileDialog.DefaultExt = "csv";
if (MySaveFileDialog.ShowDialog() == DialogResult.OK)
{
using (Stream myStream = MySaveFileDialog.OpenFile())
{
if (myStream != null)
{
for (int i = 0; i < counter-1; i++)
{
for (int j = 0; j < photoList.Count; j++)
{
bool contains = photoList.Contains(check[i]);
if (contains==true)
{
check.RemoveAt(i);
}
}
}
using (StreamWriter myWritter = new StreamWriter(myStream, System.Text.Encoding.ASCII))
{
for (int i = 0; i < check.Count; i++)
{
myWritter.WriteLine(check[i].FirstName + "," + check[i].LastName + "," + check[i].Barcode + "," + check[i].City + "," + check[i].County);
}
}
}
}
}
}
private void ReadWords()
{
using (CsvFileReader reader = new CsvFileReader(dic + ".csv"))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
foreach (string s in row)
{
hunspell.Add(s);
}
}
reader.Dispose();
}
}
private void HarmonyToDB(string DefaultPath)
{
#region Get the directory
if (!Directory.Exists(DefaultPath)) DefaultPath = "";
var dlg1 = new Ionic.Utils.FolderBrowserDialogEx();
dlg1.Description = "Select the folder of your experiment.";
dlg1.ShowNewFolderButton = true;
dlg1.ShowEditBox = true;
if (DefaultPath != "")
dlg1.SelectedPath = DefaultPath;
//dlg1.NewStyle = false;
//dlg1.SelectedPath = txtExtractDirectory.Text;
dlg1.ShowFullPathInEditBox = true;
dlg1.RootFolder = System.Environment.SpecialFolder.Desktop;
// Show the FolderBrowserDialog.
DialogResult result = dlg1.ShowDialog();
if (result != DialogResult.OK) return;
string Path = dlg1.SelectedPath;
if (Directory.Exists(Path) == false) return;
#endregion
#region Get the different files
string[] ListFilesForPlates = null;
try
{
ListFilesForPlates = Directory.GetFiles(Path, "Objects_Population - *.txt", SearchOption.AllDirectories);
}
catch (System.Exception excep)
{
MessageBox.Show(excep.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (ListFilesForPlates.Length == 0)
{
MessageBox.Show("The selected directory do not contain any Objects_Population files !", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string[] Sep = new string[1];
Sep[0] = "\\";
Dictionary<string, string> CurrentPlateDico = new Dictionary<string, string>();
// string[] FirstListImages = Directory.GetFiles(PlateDirectories[i], TmpPlateName + "_*.C01", SearchOption.AllDirectories);
foreach (var item in ListFilesForPlates)
{
string[] Res = item.Split(Sep, StringSplitOptions.RemoveEmptyEntries);
string CurrentName = Res[Res.Length-1];
if (CurrentPlateDico.ContainsKey(CurrentName.Remove(CurrentName.Length - 4))) continue;
CurrentPlateDico.Add(CurrentName.Remove(CurrentName.Length-4), item);
}
string[] ListTypes = CurrentPlateDico.Keys.ToArray();
// plates selection GUI
FormForPlateSelection FFP = new FormForPlateSelection(ListTypes,false);
FFP.Text = "Object Types Selection";
if (FFP.ShowDialog() != System.Windows.Forms.DialogResult.OK) return;
ListFilesForPlates = FFP.GetListPlatesSelected();
#endregion
if (ListFilesForPlates.Length == 0) return;
ListFilesForPlates = Directory.GetFiles(Path, ListFilesForPlates[0] + ".txt", SearchOption.AllDirectories);
#region And now let's analyse the files adn create the CSV
CsvRow CurrentRow = new CsvRow();
bool IsHeaderWritten = false;
string OriginalHeader = "";
Sep[0] = "\\";
string[] TmpSplit = ListFilesForPlates[0].Split(Sep, StringSplitOptions.RemoveEmptyEntries);
//TmpSplit[TmpSplit.Length-1].Replace(".txt",".csv");
string TPath = Path + "\\" + TmpSplit[TmpSplit.Length - 1].Replace(".txt", ".csv");
Sep[0] = ","; // specifically for the bounding box processing
FormForProgress MyProgressBar = new FormForProgress();
MyProgressBar.progressBar.Maximum = ListFilesForPlates.Length;
MyProgressBar.Show();
for (int i = 0; i < ListFilesForPlates.Length ; i++)
{
MyProgressBar.richTextBoxForComment.AppendText(ListFilesForPlates[i]);
MyProgressBar.richTextBoxForComment.Update();
StreamWriter stream = new StreamWriter(TPath, true, Encoding.ASCII);
#region process the header
string CurrentFile = ListFilesForPlates[i];
CsvFileReader CSVReader = new CsvFileReader(CurrentFile);
CSVReader.Separator = '\t';
CSVReader.ReadRow(CurrentRow);
// let's take care of the header first
while (CurrentRow[0]!="Plate Name")
{
CSVReader.ReadRow(CurrentRow);
}
string PlateName = CurrentRow[1];
// skip the rest of the header
while (CurrentRow[0] != "[Data]")
{
CSVReader.ReadRow(CurrentRow);
}
// read the columns names
CSVReader.ReadRow(CurrentRow);
List<string> Descs = CurrentRow;
string TobeWritten = "Plate Name,";
int IdxBoundingBox = -1;
int IndexCol = -1;
int IndexRow = -1;
int IndexCompound = -1;
int IndexConcentration = -1;
int IndexCellcount = -1;
int NumDesc = Descs.Count;
for (int j = 0; j < Descs.Count; j++)
{
if (Descs[j] == "Bounding Box")
{
TobeWritten += "X_Min,Y_Min,X_Max,Y_Max,";
IdxBoundingBox = j;
// NumDesc += 3;
}
else if (Descs[j] == "Row")
{
IndexRow = j;
TobeWritten += "Well Position,";
}
else if (Descs[j] == "Column")
{
IndexCol = j;
}
else if (Descs[j] == "Compound")
{
// skipped
IndexCompound = j;
}
else if (Descs[j] == "Concentration")
{
// skipped
IndexConcentration = j;
}
else if (Descs[j] == "Cell Count")
{
// skipped
IndexCellcount = j;
}
else
TobeWritten += Descs[j] + ",";
}
TobeWritten = TobeWritten.Remove(TobeWritten.Length - 1);
if (IsHeaderWritten == false)
{
OriginalHeader = TobeWritten;
stream.WriteLine(TobeWritten);
IsHeaderWritten = true;
}
else
{
// inconsistency between the headers... skip the plate
if (TobeWritten != OriginalHeader)
{
continue;
}
}
#endregion
// now let's process the data
int IdxRow = 0;
while (!CSVReader.EndOfStream)
{
CSVReader.ReadRow(CurrentRow);
TobeWritten = PlateName+",";
for (int j = 0; j < Descs.Count; j++)
{
if ((IdxBoundingBox > -1) && (j == IdxBoundingBox))
{
// let's process the bounding box
string BB = CurrentRow[j];
BB = BB.Remove(BB.Length - 1);
BB = BB.Remove(0, 1);
string[] Splitted = BB.Split(Sep, StringSplitOptions.None);
TobeWritten += Splitted[0] + "," + Splitted[1] + "," + Splitted[2] + "," + Splitted[3] + ",";
// j += 3;
}
else if (j == IndexRow)
{
TobeWritten += ConvertPosition(int.Parse(CurrentRow[IndexCol]), int.Parse(CurrentRow[IndexRow]))+",";
}
else if ((j == IndexCol)||(j==IndexCellcount)||(j==IndexCompound)||(j==IndexConcentration))
{
// do nothing
}
else
{
if (CurrentRow[j] != "")
TobeWritten += CurrentRow[j] + ",";
else
TobeWritten += "NaN,";
}
}
TobeWritten = TobeWritten.Remove(TobeWritten.Length - 1);
stream.WriteLine(TobeWritten );
IdxRow++;
}
CSVReader.Close();
stream.Dispose();
MyProgressBar.progressBar.Value++;
MyProgressBar.progressBar.Update();
}
MyProgressBar.Close();
#endregion
#region let's build the database now
// if (CSVFeedBackWindow == null) return;
// if (CSVFeedBackWindow.ShowDialog() != System.Windows.Forms.DialogResult.OK) return;
string DBPath = Path + "\\DB";
Directory.CreateDirectory(DBPath);
cConvertCSVtoDB CCTODB = CSVtoDB(TPath, ",", DBPath);
if (CCTODB == null)
{
return;
}
else
{
// update image accessor
cGlobalInfo.OptionsWindow.radioButtonImageAccessDefined.Checked = false;
cGlobalInfo.OptionsWindow.radioButtonImageAccessHarmony35.Checked = true;
cGlobalInfo.OptionsWindow.textBoxImageAccesImagePath.Text = Path;
cGlobalInfoToBeExported GlobalInfoToBeExported = new cGlobalInfoToBeExported();
cGlobalInfo.OptionsWindow.TmpOptionPath = GlobalInfoToBeExported.Save(DBPath+"\\Options.opt");
//cGlobalInfo.OptionsWindow.sav
}
#endregion
}