public void CsvDisposeReader()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
fr.Dispose();
fr.Dispose();
}
private static void LoadConversionDataIntoString(int year, bool yeartype)// yeartype true= nep, false = eng
{
int prevyear = year - 1,
nextyear = year + 1;
_conversionData.AppendLine("NepaliDate,EnglishDate,DaysInNepaliMonth");
string filepath, prevYearFilepath, nextYearFilepath;
if (yeartype)
{
prevYearFilepath = FileBox.GetBsDateFile(prevyear);
filepath = FileBox.GetBsDateFile(year);
nextYearFilepath = FileBox.GetBsDateFile(nextyear);
}
else
{
prevYearFilepath = FileBox.GetAdDateFile(prevyear);
filepath = FileBox.GetAdDateFile(year);
nextYearFilepath = FileBox.GetAdDateFile(nextyear);
}
List <string> columnNames = new List <string>()
{
"NepaliDate",
"EnglishDate",
"DaysInMonth"
};
//load the both previous year and next year data
CsvFileReader prevfile = new CsvFileReader(prevYearFilepath);
Dictionary <int, string> resultprev = prevfile.ReadFile(columnNames);
prevfile.Dispose();
foreach (KeyValuePair <int, string> pair in resultprev)
{
_conversionData.AppendLine(pair.Value);
}
CsvFileReader file = new CsvFileReader(filepath);
Dictionary <int, string> result = file.ReadFile(columnNames);
file.Dispose();
foreach (KeyValuePair <int, string> pair in result)
{
_conversionData.AppendLine(pair.Value);
}
CsvFileReader nextfile = new CsvFileReader(nextYearFilepath);
Dictionary <int, string> resultnext = nextfile.ReadFile(columnNames);
nextfile.Dispose();
foreach (KeyValuePair <int, string> pair in resultnext)
{
_conversionData.AppendLine(pair.Value);
}
}
public void CsvOpenAndClose()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
Assert.AreEqual(sr.EndOfStream, false);
fr.Dispose();
}
public void CsvReadAllRows()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
while (fr.ReadRow())
{
}
fr.Dispose();
}
public void CsvMoveFile()
{
var sr = new StreamReader(@"CsvReader\Move.csv");
var fr = new CsvFileReader(sr);
var values = new List <string>();
fr.Dispose();
File.Move(@"CsvReader\Move.csv", @"CsvReader\MoveTemp.csv");
File.Move(@"CsvReader\MoveTemp.csv", @"CsvReader\Move.csv");
}
public void CsvFieldCount()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
fr.ReadRow();
var values = fr.Values();
Assert.AreEqual(3, values.Count);
fr.Dispose();
}
public void CsvEmbeddedQuote()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
fr.ReadRow();
fr.ReadRow();
fr.ReadRow();
var values = fr.Values();
Assert.AreEqual("Embedded \" Quote", values[1]);
fr.Dispose();
}
public void CsvEmbeddedComma()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
fr.ReadRow();
fr.ReadRow();
fr.ReadRow();
var values = fr.Values();
Assert.AreEqual(values[2], "Q;A");
fr.Dispose();
}
public void CsvCommaSeperated()
{
var sr = new StreamReader(@"CsvReader\Comma.csv");
var fr = new CsvFileReader(sr, fieldDelimiter: ',');
fr.ReadRow();
fr.ReadRow();
var values = fr.Values();
CollectionAssert.AreEqual(new List <string> {
"Row1A", "Row1B", "Row1C"
}, values);
fr.Dispose();
}
public List <PlayerObject> ReturnObjects()
{
//Row to read values from Other files(dataset, new high score in 000001.csv)
CsvRow readerRow;
//Reader Object for New High Score (or old if run early)
CsvFileReader reader = new CsvFileReader("HighScoreFile.csv");
//Array of Player Objects to fill with readerRow's values read
List <PlayerObject> pastPlayers = new List <PlayerObject> ();
//Loop through the reader till the end
while (!reader.EndOfStream)
{
//if (reader.BaseStream.ReadByte() == -1)
// break;
//Build a new player Object to fill
PlayerObject obj = new PlayerObject();
//Instatiate the CsvRow
readerRow = new CsvRow();
//Build a string array to hold the CsvRow values
string[] list = new string[2];
//Read the rows and Copy the data to the array
reader.ReadRow(readerRow);
readerRow.CopyTo(list);
//Check for "Player" as the first column and skip it
if (list [0].ToString().Contains("Player"))
{
readerRow.Clear();
readerRow = new CsvRow();
list = new string[2];
reader.ReadRow(readerRow);
readerRow.CopyTo(list);
}
//Set player names by formatting the string, and parsing to a float
obj.setPlayerName(string.Format("{0}", list[0].ToString()));
obj.setPoints(float.Parse(list [1]));
//Add the player Object to the array
pastPlayers.Add(obj);
readerRow.Clear();
} //End of while loop
reader.Dispose();
reader.Close();
return(pastPlayers);
}
public void CsvGetValue()
{
var sr = new StreamReader(@"CsvReader\Simple.csv");
var fr = new CsvFileReader(sr);
bool ok1 = fr.ReadRow();
Assert.IsTrue(ok1, "rij 1");
var values1 = fr.Values();
Assert.IsNotNull(values1);
CollectionAssert.AreEqual(new List <string> {
"Header1", "Header2", "Header3"
}, values1);
bool ok2 = fr.ReadRow();
Assert.IsTrue(ok2, "rij 2");
var values2 = fr.Values();
Assert.IsNotNull(values2);
CollectionAssert.AreEqual(new List <string> {
"Row1A", "Row1B", "Row1C"
}, values2);
bool ok3 = fr.ReadRow();
Assert.IsTrue(ok3, "rij 3");
var values3 = fr.Values();
Assert.IsNotNull(values3);
CollectionAssert.AreEqual(new List <string> {
"Quotes", "Embedded \" Quote", "Q;A"
}, values3);
bool ok4 = fr.ReadRow();
Assert.IsFalse(ok4, "er is geen rij 4");
Assert.IsNull(fr.Values());
fr.Dispose();
}
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();
}
}
public void F_SaveLog()
{
//Read FILE LOG_Source
v_FileInput = new DirectoryInfo(ConfigurationManager.AppSettings["PathInput"].ToString()).GetFiles().OrderByDescending(f => f.LastWriteTime).First();
if (v_FileInput.Extension != ".csv")
{
return;
}
DataTable v_DT_Result = new DataTable();
v_DT_Result.Columns.Add("Times", typeof(string));
v_DT_Result.Columns.Add("Model", typeof(string));
v_DT_Result.Columns.Add("Status", typeof(string));
List <string> columns = new List <string>();
CsvFileReader v_Reader = WriteDatatableToFileCSV.ReadFile(v_FileInput.FullName);
while (v_Reader.ReadRow(columns))
{
if (columns[0].Trim().Length > 0 && columns[1].Trim().Length > 0)
{
DataRow v_Dr = v_DT_Result.NewRow();
v_Dr[0] = columns[1].Trim();
v_Dr[1] = columns[5].Trim();
v_Dr[2] = columns[3].Trim();
v_DT_Result.Rows.Add(v_Dr);
}
}
v_Reader.Dispose();
v_DT_Result.Rows.RemoveAt(0);
v_DT_Result.Rows.RemoveAt(0);
//Get PASS OR FAIL
string v_Status = "F";
string v_Model = string.Empty;
string v_Serial = string.Empty;
string v_Station = string.Empty;
//GET Model
v_Model = v_DT_Result.Rows[v_DT_Result.Rows.Count - 1][1].ToString().Trim().Split('_')[1];
//GET Serial
v_Serial = v_DT_Result.Rows[v_DT_Result.Rows.Count - 1][1].ToString().Trim().Split('_')[0];
//Get Status
try
{
if (v_DT_Result.Rows[v_DT_Result.Rows.Count - 1][2].ToString().Trim() == "OK")
{
v_Status = "P";
}
else
{
v_Status = "F";
}
}
catch { v_Status = "F"; }
//Get Station
try
{
//v_Station = Cbx_Station.SelectedValue.ToString();
}
catch { }
Tbx_BarCode.Text = v_Serial + "_" + v_Model;
Tbx_BarCode.ForeColor = Color.Green;
string v_TimeCurrent = DateTime.Now.ToString("yyMMddHHmmss");
string v_FileContent = v_Model + "|" + v_Serial + "_" + v_Model + "|" + v_TimeCurrent + "|" + v_Status + "|" + v_Station;
//Delete OLD File log
try
{
bool v_StatusOld = false;
List <string> v_ListPaths = Directory.GetFiles(ConfigurationManager.AppSettings["PathOutput"].ToString(), "*.txt", SearchOption.AllDirectories).ToList();
string v_PathPASS = "";
string v_PathNG = "";
try
{
v_PathPASS = v_ListPaths.Where(p => File.ReadAllLines(p).Any(line => line.IndexOf(v_Serial + "_" + v_Model) >= 0 && line.IndexOf("|P|") >= 0 && line.IndexOf(v_Station) >= 0)).First();
}
catch { }
try
{
v_PathNG = v_ListPaths.Where(p => File.ReadAllLines(p).Any(line => line.IndexOf(v_Serial + "_" + v_Model) >= 0 && line.IndexOf("|F|") >= 0 && line.IndexOf(v_Station) >= 0)).First();
}
catch { }
if (v_PathPASS.Trim().Length > 0)
{
ControlFile.F_DeleteFile(v_PathPASS);
v_Total = v_Total - 1;
if (v_Status == "P")
{
v_Pass = v_Pass - 1;
}
else if (v_Status == "F")
{
v_Pass = v_Pass - 1;
v_NG = v_NG;
}
if (v_Total < 0)
{
v_Total = 0;
}
if (v_Pass < 0)
{
v_Pass = 0;
}
if (v_NG < 0)
{
v_NG = 0;
}
}
else if (v_PathNG.Trim().Length > 0)
{
ControlFile.F_DeleteFile(v_PathNG);
v_Total = v_Total - 1;
if (v_Status == "P")
{
v_Pass = v_Pass;
v_NG = v_NG - 1;
}
else if (v_Status == "F")
{
v_NG = v_NG - 1;
}
if (v_Total < 0)
{
v_Total = 0;
}
if (v_Pass < 0)
{
v_Pass = 0;
}
if (v_NG < 0)
{
v_NG = 0;
}
}
}
catch { }
//Create NEW File log
ControlFile.F_CreateAndWriteFile(ConfigurationManager.AppSettings["PathOutput"].ToString() + "\\" + v_TimeCurrent + "_" + v_Model.Replace(" ", "").Substring(0, 9) + ".txt", v_FileContent);
if (v_Status == "P")
{
Panel_Result.BackColor = System.Drawing.Color.Blue;
Lbl_Result.BackColor = System.Drawing.Color.Blue;
Lbl_Result.Text = "PASS";
}
else if (v_Status == "F")
{
Panel_Result.BackColor = System.Drawing.Color.Red;
Lbl_Result.BackColor = System.Drawing.Color.Red;
Lbl_Result.Text = "FAIL";
}
//Count PCS
F_CountModelsChecked(v_Status);
F_LoadTotalPCS();
}
public void FillHighScores()
{
//Row to read values from Other files(dataset, new high score in 000001.csv)
CsvRow readerRow;
//Row to insert values into CsvFileWriter below for HighScoreFile good copy
CsvRow row = new CsvRow();
//Reader Object for New High Score (or old if run early)
CsvFileReader reader = new CsvFileReader("HighScoreFile.csv");
//Array of Player Objects to fill with readerRow's values read
List <PlayerObject> pastPlayers = new List <PlayerObject> ();
//Loop through the reader till the end
while (!reader.EndOfStream)
{
//if (reader.BaseStream.ReadByte() == -1)
// break;
//Build a new player Object to fill
PlayerObject obj = new PlayerObject();
//Instatiate the CsvRow
readerRow = new CsvRow();
//Build a string array to hold the CsvRow values
string[] list = new string[2];
//Read the rows and Copy the data to the array
reader.ReadRow(readerRow);
readerRow.CopyTo(list);
//Check for "Player" as the first column and skip it
if (list [0].ToString().Contains("Player"))
{
continue;
}
//Set player names by formatting the string, and parsing to a float
obj.setPlayerName(string.Format("{0}", list[0].ToString()));
obj.setPoints(float.Parse(list [1]));
//Add the player Object to the array
pastPlayers.Add(obj);
readerRow.Clear();
} //End of while loop
reader.Dispose();
reader.Close();
//Reader to loop through Dataset for run just taken. Keeps the values safe.
reader = new CsvFileReader("000001.csv");
while (!reader.EndOfStream)
{
PlayerObject obj = new PlayerObject();
readerRow = new CsvRow();
string[] list = new string[2];
//Read the rows and Copy the data to the array
reader.ReadRow(readerRow);
readerRow.CopyTo(list);
//Set player names by formatting the string, and parsing to a float
obj.setPlayerName(string.Format("{0}", list [0].ToString()));
obj.setPoints(float.Parse(list [1]));
//Add the player Object to the array
pastPlayers.Add(obj);
readerRow.Clear();
}
reader.Dispose();
reader.Close();
//Reader to loop through Dataset given for assignment, which pulls the values
//of the name of the commodity in the list, and the value of the commodity.
//It has taken a shortened version, at the behest of Professor Stanley Pieda
//when asked if I needed to keep the 100K+ file or revise it slightly.
/*reader = new CsvFileReader ("000000.csv");
*
* while(!reader.EndOfStream){
*
* PlayerObject obj = new PlayerObject();
* readerRow = new CsvRow();
* string[] list = new string[6];
*
* reader.ReadRow (readerRow);
* readerRow.CopyTo(list);
* obj.setPlayerName(string.Format("{0}", list [2].ToString ()));
* obj.setPoints (float.Parse(list[5]));
*
* pastPlayers.Add(obj);
* readerRow.Clear ();
* }
*
* reader.Dispose ();
* reader.Close ();
*/
//CsvFileWriter Object to write the high score objects to the csv file
CsvFileWriter writer = new CsvFileWriter("HighScoreFile.csv");
//Adding the headers for Player and Score in the table
row.Add(string.Format("Player"));
row.Add(string.Format("Score"));
//Writing it to the file, and clearing the row which was written
writer.WriteRow(row);
row.Clear();
pastPlayers.Sort((x, y) => y.points.CompareTo(x.points));
//Looping through the number of playerObjects in the List. Printing each one
//To it's own row and clearing that row after it's written.
for (int i = 0; i < pastPlayers.Count; i++)
{
row.Add(string.Format("{0}", pastPlayers[i].getPlayerName()));
row.Add(string.Format("{0}", pastPlayers[i].getPoints()));
writer.WriteRow(row);
row.Clear();
}
//Clean up the writers
writer.Dispose();
writer.Close();
//pastPlayers.Sort (0,pastPlayers.Count,pastPlayers [0].points);
}