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();
}
}
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);
}
}
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;
}
public void WriteRow(CsvRow row)
{
StringBuilder stringBuilder = new StringBuilder();
bool flag = true;
foreach (string current in row)
{
if (!flag)
{
stringBuilder.Append(',');
}
if (current.IndexOfAny(new char[]
{
'"',
','
}) != -1)
{
stringBuilder.AppendFormat("\"{0}\"", current.Replace("\"", "\"\""));
}
else
{
stringBuilder.Append(current);
}
flag = false;
}
row.LineText = stringBuilder.ToString();
this.WriteLine(row.LineText);
}
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;
}
}
}
public void RunCommand(string cmd)
{
CsvRow row = new CsvRow();
row.Add(DateTime.Now.format("dd-MM-yyyy HH:mm:ss"));
row.Add(this.Com);
row.Add(this.Name);
try
{
string msg = string.Format(cmd, this.board, this.pos);
row.Add(msg);
if (App.listSerialPort != null)
{
for (int i = 0; i < App.listSerialPort.Count; i++)
{
if (this.Com.ToLower() == App.listSerialPort[i].PortName.ToLower())
{
App.listSerialPort[i].sendCommand(msg);
break;
}
}
}
}
catch (Exception)
{
}
App.RowsSend.Add(row);
}
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 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;
}
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));
}
//static void Main(string[] args)
//{
// CsvRow row = new CsvRow();
// CsvFileReader reader = new CsvFileReader("C:\\temp\\XICData.csv");
// while (reader.ReadRow(row))
// {
// Console.Out.WriteLine(row[0] + " -> " + row[1]);
// }
// Console.Read();
//}
static void Main(string[] args)
{
List<XICDataPoint> xicData = new List<XICDataPoint>();
CsvRow row = new CsvRow();
CsvFileReader reader = new CsvFileReader("C:\\temp\\XICData.csv");
while (reader.ReadRow(row))
{
Console.Out.WriteLine(row[0] + " -> " + row[1]);
int scanNumber;
double intensity;
if (int.TryParse(row[0], out scanNumber) && double.TryParse(row[1], out intensity))
xicData.Add(new XICDataPoint { scanNumber = scanNumber, intensity = intensity });
}
PeakFinder finder = new PeakFinder();
foreach (var peakData in finder.GetPeaks(xicData))
{
Console.Out.WriteLine(peakData.startScan + " -> " , peakData.endScan);
foreach (var intensity in peakData.intensityValues)
{
Console.Out.WriteLine("Intensity = " + intensity);
}
}
Console.Read();
}
public citTotalLoadsFload(CsvRow row)
{
this.KycrspFundno = Convert.ToInt32(row[0]);
this.FrontLoad = Convert.ToDouble(row[1]);
this.FrontGroupNo = row[2];
this.Fflbegdt = FuncoesAux.StringToDateTime(row[3]);
this.Fflenddt = FuncoesAux.StringToDateTime(row[4]);
}
public void import(string fileName, int headerRow)
{
List<string> columns = new List<string>();
List<Dictionary<string, string>> rows = new List<Dictionary<string,string>>();
// Read sample data from CSV file
using (CsvFileReader reader = new CsvFileReader(fileName))
{
int lineNumber = 0;
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
if (lineNumber == headerRow)
{
// Read Header Values
foreach (string s in row)
{
columns.Add(s.Replace(" ", ""));
}
}
else if (lineNumber > headerRow)
{
int columnIndex = 0;
Dictionary<string, string> dataRow = new Dictionary<string,string>();
foreach (string s in row)
{
dataRow.Add(columns[columnIndex], s);
++columnIndex;
}
rows.Add(dataRow);
}
++lineNumber;
}
}
// Output using code generator
// IList<BusinessRule> rules = new List<BusinessRule>();
// rules.Add(new BusinessRule
// {
// ErrorCode = "AIRBR1001",
// RuleNumber = "1095C-006",
// Description = "Form 1095C 'TINRequestTypeCd' in 'EmployeeInfoGrp' must have a value equal to 'INDIVIDUAL_TIN'.",
// ErrorCategory = "Incorrect Data",
// Severity = "Report Error",
// Status = "Active"
// });
CodeCompileUnit code = new CodeCompileUnit();
CodeNamespace namespaces = new CodeNamespace();
namespaces.Imports.Add(new CodeNamespaceImport("System"));
}
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);
}
public citExpenseTurnoverFee(CsvRow row)
{
this.KycrspFundno = Convert.ToInt32(row[0]);
this.FexpRatio = Convert.ToDouble(row[1]);
if (!row[2].Equals("")){
this.FmgmtFee = Convert.ToDouble(row[2]);
}
this.FturnRatio = Convert.ToDouble(row[3]);
this.Ffebegdt = FuncoesAux.StringToDateTime(row[4]);
this.Ffeenddt = FuncoesAux.StringToDateTime(row[5]);
}
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 static void kToSqlCreateTable(string tblsFile, string sqlFile = cSqlCreateTblScriptFile)
{
string tSqlFile = string.Format("{0}k{1}.{2}", cScriptHomePath, sqlFile, cSqlFileExt);
SqlScriptLogger scriptLogger = new SqlScriptLogger(tSqlFile);
scriptLogger.kWriteLine("USE akm_m6dtx;" + Environment.NewLine);
Console.WriteLine(string.Format("Creating {0} . . .", tSqlFile));
string tCsvFile = string.Format("{0}{1}_{2}.{3}", cDataHomePath, tblsFile, cDataPostfix, cCsvFileExt);
CsvFileReader reader = new CsvFileReader(tCsvFile);
Console.WriteLine(string.Format("Opening {0} . . .", tCsvFile));
Console.WriteLine("[Press the ENTER key to begin . . .]");
Console.ReadKey();
CsvRow row = new CsvRow();
bool isHeader = true;
while (reader.ReadRow(row))
{
if (isHeader)
{
isHeader = false;
continue;
}
foreach (string tblSchema in row)
{
string script = string.Empty;
try
{
string tTblSchemaFile = string.Format("{0}_{1}", tblSchema, cSchemaPostfix);
scriptLogger.kWriteLineHeader(tblSchema);
scriptLogger.kWriteLine(2);
scriptLogger.kWriteLine(SqlScriptTrans.kToSqlCreateTable(tTblSchemaFile, string.Format("{0}{1}.{2}", cDataHomePath, tTblSchemaFile, cCsvFileExt)));
scriptLogger.kWriteLine(2);
scriptLogger.kWriteLineFooter();
}
catch (FileNotFoundException)
{
scriptLogger.kWriteLine("## [ERROR::" + tblSchema + "] The table does not exists in the database.");
continue;
}
scriptLogger.kWriteLine(4);
}
}
reader.Close();
scriptLogger.kClose();
}
private static CsvFileWriter AbrirArchivo()
{
string filepath = @"C:\Users\Angela\Desktop\estadisticasSimulacion.csv";
CsvFileWriter writer = new CsvFileWriter(@filepath);
//Escribo encabezados de las columnas del archivo
CsvRow header = new CsvRow();
header.Add("Reloj");
header.Add("Promedio clientes en cola");
header.Add("Uso servidor");
header.Add("Clientes atendidos");
header.Add("Demora promedio en cola");
writer.WriteRow(header);
return writer;
}
public CorrData(CsvRow row1, CsvRow row2)
{
Corrout_abs = new double[row1.Count - 1];
distance = new double[row2.Count - 1];
angle = double.Parse(row1[0]);
datatime = DateTime.ParseExact(row2[0], "HH:mm:ss.ff", null);
for (int i = 0; i < row1.Count - 1; i++)
{
Corrout_abs[i] = double.Parse(row1[1 + i]);
}
for (int i = 0; i < row2.Count - 1; i++)
{
distance[i] = double.Parse(row2[1 + i]);
}
}
private static CsvRow CheckBandwidthUsage(DateTime now)
{
CsvRow row = new CsvRow();
try
{
NetworkInterface[] interfaces = NetworkInterface.GetAllNetworkInterfaces();
long bytesReceived = 0;
foreach (NetworkInterface inf in interfaces)
{
if (inf.OperationalStatus == OperationalStatus.Up &&
inf.NetworkInterfaceType != NetworkInterfaceType.Loopback &&
inf.NetworkInterfaceType != NetworkInterfaceType.Tunnel &&
inf.NetworkInterfaceType != NetworkInterfaceType.Unknown && !inf.IsReceiveOnly)
{
bytesReceived += inf.GetIPv4Statistics().BytesReceived;
if (row.Count == 0)
{
PhysicalAddress address = inf.GetPhysicalAddress();
byte[] macAddr = address.GetAddressBytes();
string tMac = "";
foreach (byte part in address.GetAddressBytes())
{
tMac += (tMac.Length > 0 ? "-" : "") + (part < 16 ? "0" : "") + part.ToString("X", CultureInfo.InvariantCulture);
}
row.Add(inf.Description);
row.Add(tMac);
}
}
}
if (bytesReceivedPrev == 0)
{
bytesReceivedPrev = bytesReceived;
}
long bytesUsed = bytesReceived - bytesReceivedPrev;
double kBytesUsed = bytesUsed / 1024;
double mBytesUsed = kBytesUsed / 1024;
bytesReceivedPrev = bytesReceived;
row.Add(mBytesUsed.ToString());
row.Add(now.ToString());
row = (mBytesUsed.ToString() == "0") ? null : row;
}
catch (Exception Ex)
{
WriteLog("Log Path :: " + Ex);
}
return row;
}
public void Test()
{
using (CsvFileReader reader = new CsvFileReader(HttpContext.Current.Server.MapPath("~/SyncFiles/clb_20140825_1134.CSV")))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
foreach (string s in row)
{
Console.Write(s);
Console.Write(" ");
}
Console.WriteLine();
}
}
}
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);
}
}
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();
}
public citModeloC(CsvRow row)
{
this.KYCRSP_FUNDNO = Convert.ToInt32(row[0]);
this.MCALDT = FuncoesAux.StringToDateTime(row[1]);
//this.FMRET = row[2];
//this.RmRfd = row[3];
//this.SMB = row[4];
//this.HML = row[5];
//this.Mom = row[6];
//this.Rfd = row[7];
//this._b_RmRfd = row[8];
//this._b_SMB = row[9];
//this._b_HML = row[10];
//this._b_Mom = row[11];
//this._b_cons = row[12];
//this._p = row[13];
}
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);
}
}
}
String CreateQuery(CsvRow body, String tableName)
{
String pre = String.Format("insert into {0} values ('", tableName);
String mid = "', '";
String post = "')";
String query = pre;
for (int i = 0; i < body.Count; ++i)
{
String connector = mid;
if (body.Count - 1 == i)
{
connector = post;
}
query = query + body[i] + connector;
}
return query;
}
/// <summary>
/// Write a csv row to file
/// </summary>
/// <param name="row"> </param>
public void WriteRow(CsvRow row)
{
var builder = new StringBuilder();
foreach (string value in row)
{
// Add separator if this isn't the first value
if (builder.Length > 0)
builder.Append(',');
if (value.IndexOfAny(new[] {'"', ','}) != -1)
{
// Special handling for values that contain comma or quote
// Enclose in quotes and double up any double quotes
builder.AppendFormat("\"{0}\"", value.Replace("\"", "\"\""));
}
else builder.Append(value);
}
row.LineText = builder.ToString();
WriteLine(row.LineText);
}
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);
}
}
/// <summary>
/// Writes a single row to a CSV file.
/// </summary>
/// <param name="row">The row to be written</param>
public void WriteRow(CsvRow row)
{
StringBuilder builder = new StringBuilder();
bool firstColumn = true;
foreach (string value in row)
{
// Add separator if this isn't the first value
if (!firstColumn)
builder.Append(';');
// Implement special handling for values that contain comma or quote
// Enclose in quotes and double up any double quotes
if (value.IndexOfAny(new char[] { '"', ';' }) != -1)
builder.AppendFormat("\"{0}\"", value.Replace("\"", "\"\""));
else
builder.Append(value);
firstColumn = false;
}
row.LineText = builder.ToString();
WriteLine(row.LineText);
}
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 a row of data from a CSV file
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public bool ReadRow(CsvRow row)
{
row.LineText = ReadLine();
if (String.IsNullOrEmpty(row.LineText))
{
return(false);
}
int pos = 0;
int rows = 0;
while (pos < row.LineText.Length)
{
string value;
// Special handling for quoted field
if (row.LineText[pos] == '"')
{
// Skip initial quote
pos++;
// Parse quoted value
int start = pos;
while (pos < row.LineText.Length)
{
// Test for quote character
if (row.LineText[pos] == '"')
{
// Found one
pos++;
// If two quotes together, keep one
// Otherwise, indicates end of value
if (pos >= row.LineText.Length || row.LineText[pos] != '"')
{
pos--;
break;
}
}
pos++;
}
value = row.LineText.Substring(start, pos - start);
value = value.Replace("\"\"", "\"");
}
else
{
// Parse unquoted value
int start = pos;
while (pos < row.LineText.Length && row.LineText[pos] != ',')
{
pos++;
}
value = row.LineText.Substring(start, pos - start);
}
// Add field to list
if (rows < row.Count)
{
row[rows] = value;
}
else
{
row.Add(value);
}
rows++;
// Eat up to and including next comma
while (pos < row.LineText.Length && row.LineText[pos] != ',')
{
pos++;
}
if (pos < row.LineText.Length)
{
pos++;
}
}
// Delete any unused items
while (row.Count > rows)
{
row.RemoveAt(rows);
}
// Return true if any columns read
return(row.Count > 0);
}
//Generate profile CSV of targets. Includes IP, hostname, domain, loggedon user, and domainrole
static void GenerateTargetCSV(ManagementScope scope, CsvFileWriter writer)
{
try
{
scope.Options.Timeout = TimeSpan.FromSeconds(1);
scope.Connect();
if (!scope.IsConnected)
{
Console.WriteLine("Error connecting to remote machine");
return;
}
int iInterfaceIndex = 0;
string sDomainRole = null;
string sDNSHostname = null;
string sUsername = null;
string sDomain = null;
String[] sIPAddress = null;
//Find the Interface Index with the default route
ObjectQuery oqRoute = new ObjectQuery("Select InterfaceIndex from Win32_IP4RouteTable WHERE destination = '0.0.0.0'");
ManagementObjectSearcher mgmtObjSearcherRoute = new ManagementObjectSearcher(scope, oqRoute);
ManagementObjectCollection colRoute = mgmtObjSearcherRoute.Get();
foreach (ManagementObject objRoute in colRoute)
{
iInterfaceIndex = (int)objRoute["InterfaceIndex"];
}
//Find the IP address of the interface
ObjectQuery oqIPAddr = new ObjectQuery("Select IPAddress from Win32_NetworkAdapterConfiguration WHERE InterfaceIndex = " + iInterfaceIndex);
ManagementObjectSearcher mgmtObjSearcherIP = new ManagementObjectSearcher(scope, oqIPAddr);
ManagementObjectCollection colIP = mgmtObjSearcherIP.Get();
foreach (ManagementObject objIP in colIP)
{
sIPAddress = (String[])objIP["IPAddress"];
}
//Grab profile information - Hostname, Domain, LoggedOn User, and DomainRole
ObjectQuery oqCompSys = new ObjectQuery("SELECT DNSHostName, Domain, Username, DomainRole FROM Win32_ComputerSystem");
ManagementObjectSearcher mgmtObjSearcher = new ManagementObjectSearcher(scope, oqCompSys);
ManagementObjectCollection colCompSys = mgmtObjSearcher.Get();
foreach (ManagementObject objSysInfo in colCompSys)
{
switch (Convert.ToInt32(objSysInfo["DomainRole"]))
{
case 0:
sDomainRole = "StandAlone_Wks";
break;
case 1:
sDomainRole = "DomainMember_Wks";
break;
case 2:
sDomainRole = "StandAlone_Svr";
break;
case 3:
sDomainRole = "DomainMember_Svr";
break;
case 4:
sDomainRole = "BackupDC";
break;
case 5:
sDomainRole = "PrimaryDC";
break;
default:
sDomainRole = "Dunno";
break;
}
sDNSHostname = (string)objSysInfo["DNSHostName"];
sDomain = (string)objSysInfo["Domain"];
sUsername = (string)objSysInfo["Username"];
}
//Craft CSV for Profile
CsvRow row = new CsvRow();
row.Add(sDNSHostname);
row.Add(sDomain);
if (sUsername == null)
{
row.Add("NoLoggedInUser");
}
else
{
row.Add(sUsername);
}
row.Add(sDomainRole);
row.Add(sIPAddress[0]);
writer.WriteRow(row);
row.Clear();
return;
}
catch (Exception e)
{
Console.WriteLine("{0} Expection Caught.", e);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="NewsData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public NewsData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// NewsData.
}
/// <summary>
/// Initializes a new instance of the <see cref="ResourcePackData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public ResourcePackData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// ResourcePackData.
}
/// <summary>
/// Initializes a new instance of the <see cref="TutorialChestOrderData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public TutorialChestOrderData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// TutorialChestOrderData.
}
/// <summary>
/// creates a new station with values from the CsvRow object
/// </summary>
/// <param name="currentRow"></param>
public EDStation(CsvRow Csv_Row)
{
try
{
var SystemsAndStations = Program.Data.BaseData.visystemsandstations;
Id = 0;
SystemId = 0;
var stationID = (SQL.Datasets.dsEliteDB.visystemsandstationsRow[])SystemsAndStations.Select(
String.Format("systemname = '{0}' and stationname = '{1}'",
SQL.DBConnector.DTEscape(Csv_Row.SystemName),
SQL.DBConnector.DTEscape(Csv_Row.StationName)));
if (stationID.GetUpperBound(0) >= 0)
{
Id = stationID[0].StationID;
SystemId = stationID[0].SystemID;
}
else
{
// we'll get the system-id later
SystemName = Csv_Row.SystemName;
}
Name = Csv_Row.StationName;
MaxLandingPadSize = null;
DistanceToStar = null;
Faction = null;
Government = null;
Allegiance = null;
State = null;
Type = null;
HasBlackmarket = false;
HasMarket = false;
HasRefuel = false;
HasRepair = false;
HasRearm = false;
HasOutfitting = false;
HasShipyard = false;
ImportCommodities = new String[0];
ExportCommodities = new String[0];
ProhibitedCommodities = new String[0];
Economies = new String[0];
Listings = new Listing[0];
UpdatedAt = 0;
Shipyard_UpdatedAt = 0;
Outfitting_UpdatedAt = 0;
Market_UpdatedAt = 0;
TypeID = null;
HasCommodities = false;
IsPlanetary = false;
SellingShips = new String[0];
SellingModules = new Int32[0];
}
catch (Exception ex)
{
throw new Exception("Error while creating new EDStation object with values from CsvRow object", ex);
}
}
private void btnImport_Click(object sender, EventArgs e)
{
int num = 0;
int num2 = 0;
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "csv files|*.csv";
if (openFileDialog.ShowDialog() == DialogResult.OK && openFileDialog.FileName != null)
{
using (CsvFileReader csvFileReader = new CsvFileReader(openFileDialog.FileName, Encoding.Default))
{
CsvRow csvRow = new CsvRow();
csvFileReader.ReadRow(csvRow);
if (csvRow.Count == 12 && csvRow.SequenceEqual(ChannelsForm.SZ_HEADER_TEXT))
{
for (num = 0; num < ChannelForm.data.Count; num++)
{
ChannelForm.data.SetIndex(num, 0);
}
while (csvFileReader.ReadRow(csvRow))
{
foreach (string item in csvRow)
{
string text = item;
if (csvRow.Count >= 12)
{
num = 0;
CsvRow csvRow2 = csvRow;
num = 1;
num2 = Convert.ToInt32(((List <string>)csvRow2)[0]);
ChannelForm.data.SetIndex(num2, 1);
ChannelForm.data.Default(num2);
if (num2 < ChannelForm.data.Count)
{
ChannelForm.ChannelOne value = ChannelForm.data[num2];
value.Name = ((List <string>)csvRow)[num++];
value.RxFreq = ((List <string>)csvRow)[num++];
value.TxFreq = ((List <string>)csvRow)[num++];
value.ChModeS = ((List <string>)csvRow)[num++];
value.PowerS = ((List <string>)csvRow)[num++];
value.RxTone = ((List <string>)csvRow)[num++];
value.TxTone = ((List <string>)csvRow)[num++];
value.TxColor = Convert.ToInt32(((List <string>)csvRow)[num++]);
value.RxGroupList = Convert.ToInt32(((List <string>)csvRow)[num++]);
value.Contact = Convert.ToInt32(((List <string>)csvRow)[num++]);
value.RepeaterSlotS = ((List <string>)csvRow)[num++];
ChannelForm.data[num2] = value;
}
}
}
}
this.DispData();
MainForm mainForm = base.MdiParent as MainForm;
mainForm.InitChannels(this.Node);
mainForm.RefreshRelatedForm(base.GetType());
}
else
{
MessageBox.Show("DataFormatError");
}
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="HeroData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public HeroData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// HeroData.
}
/// <summary>
/// Initializes a new instance of the <see cref="CsvRowTypeDescriptor"/> class.
/// </summary>
/// <param name="instance">
/// The instance.
/// </param>
public CsvRowTypeDescriptor(object instance)
{
this.row = (CsvRow)instance;
}
/// <summary>
/// Loads from the specified stream reader.
/// </summary>
/// <param name="s">The stream reader.</param>
/// <param name="cultureInfo">The culture info.</param>
/// <returns>
/// A <see cref="CsvFile" />.
/// </returns>
/// <exception cref="System.ArgumentNullException">s;The stream reader must be specified.</exception>
/// <exception cref="System.InvalidOperationException">Invalid header.</exception>
/// <exception cref="System.FormatException">Wrong number of columns on line + lineNumber</exception>
public static CsvFile Load(StreamReader s, CultureInfo cultureInfo = null)
{
if (s == null)
{
throw new ArgumentNullException("s", "The stream reader must be specified.");
}
if (cultureInfo == null)
{
cultureInfo = CultureInfo.InvariantCulture;
}
var separator = cultureInfo.TextInfo.ListSeparator;
var headerLine = s.ReadLine();
if (headerLine == null)
{
throw new InvalidOperationException("Invalid header.");
}
var headers = SplitLine(headerLine, separator[0]);
int n = headers.Length;
// Create a string collection for each column
var items = new ValueList[n];
for (int i = 0; i < n; i++)
{
items[i] = new ValueList();
}
// Read all rows
int lineNumber = 1;
while (!s.EndOfStream)
{
lineNumber++;
var line = s.ReadLine();
if (line == null)
{
continue;
}
var fields = SplitLine(line, separator[0]);
if (fields.Length != n)
{
throw new FormatException("Wrong number of columns on line " + lineNumber);
}
for (int i = 0; i < n; i++)
{
items[i].Add(fields[i]);
}
}
var file = new CsvFile();
// Determine the type of each column from the data
for (int i = 0; i < n; i++)
{
string name, unit;
SplitHeader(headers[i], out name, out unit);
file.Columns.Add(new CsvColumn(name, unit, items[i].GetSmallestCommonType(cultureInfo)));
}
// Parse the values (and box them)
for (int j = 0; j < items[0].Count; j++)
{
var item = new CsvRow(file);
for (int i = 0; i < file.Columns.Count; i++)
{
item.Values[i] = file.Columns[i].Convert(items[i][j], cultureInfo);
}
file.Rows.Add(item);
}
return(file);
}
/// <summary>
/// Initializes a new instance of the <see cref="MusicData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public MusicData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// MusicData.
}
/// <summary>
/// Initializes a new instance of the <see cref="LocaleData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public LocaleData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// LocaleData.
}
/// <summary>
/// Initializes a new instance of the <see cref="HelpshiftData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public HelpshiftData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// HelpshiftData.
}
// public static ANetApiResponse Run(String ApiLoginID, String ApiTransactionKey, Decimal Amount)
// {
// Console.WriteLine("Create an Accept Transaction Sample");
// ApiOperationBase<ANetApiRequest, ANetApiResponse>.RunEnvironment = AuthorizeNET.Environment.SANDBOX;
// // define the merchant information (authentication / transaction id)
// ApiOperationBase<ANetApiRequest, ANetApiResponse>.MerchantAuthentication = new merchantAuthenticationType()
// {
// name = ApiLoginID,
// ItemElementName = ItemChoiceType.transactionKey,
// Item = ApiTransactionKey,
// };
// //set up data based on transaction
// var opaqueData = new opaqueDataType { dataDescriptor = "COMMON.ACCEPT.INAPP.PAYMENT", dataValue = "9471471570959063005001" };
// //standard api call to retrieve response
// var paymentType = new paymentType { Item = opaqueData };
// var transactionRequest = new transactionRequestType
// {
// transactionType = transactionTypeEnum.authCaptureTransaction.ToString(), // authorize and capture transaction
// amount = Amount,
// payment = paymentType
// };
// var request = new createTransactionRequest { transactionRequest = transactionRequest };
// // instantiate the contoller that will call the service
// var controller = new createTransactionController(request);
// controller.Execute();
// // get the response from the service (errors contained if any)
// var response = controller.GetApiResponse();
// //validate
// if (response != null)
// {
// if (response.messages.resultCode == messageTypeEnum.Ok)
// {
// if(response.transactionResponse.messages != null)
// {
// Console.WriteLine("Successfully created an accept transaction with Transaction ID: " + response.transactionResponse.transId);
// Console.WriteLine("Response Code: " + response.transactionResponse.responseCode);
// Console.WriteLine("Message Code: " + response.transactionResponse.messages[0].code);
// Console.WriteLine("Description: " + response.transactionResponse.messages[0].description);
// }
// else
// {
// Console.WriteLine("Failed Transaction.");
// if (response.transactionResponse.errors != null)
// {
// Console.WriteLine("Error Code: " + response.transactionResponse.errors[0].errorCode);
// Console.WriteLine("Error message: " + response.transactionResponse.errors[0].errorText);
// }
// }
// }
// else
// {
// Console.WriteLine("Failed Transaction.");
// if (response.transactionResponse != null && response.transactionResponse.errors != null)
// {
// Console.WriteLine("Error Code: " + response.transactionResponse.errors[0].errorCode);
// Console.WriteLine("Error message: " + response.transactionResponse.errors[0].errorText);
// }
// else
// {
// Console.WriteLine("Error Code: " + response.messages.message[0].code);
// Console.WriteLine("Error message: " + response.messages.message[0].text);
// }
// }
// }
// else
// {
// Console.WriteLine("Null Response.");
// }
// return response;
// }
public static void CreateAnAcceptTransactionExec(String ApiLoginID, String ApiTransactionKey)
{
using (CsvReader csv = new CsvReader(new StreamReader(new FileStream(@"../../../CSV_DATA/CreateAnAcceptTransaction.csv", FileMode.Open)), true))
{
int flag = 0;
int fieldCount = csv.FieldCount;
string[] headers = csv.GetFieldHeaders();
//Append Data
var item1 = DataAppend.ReadPrevData();
using (CsvFileWriter writer = new CsvFileWriter(new FileStream(@"../../../CSV_DATA/Outputfile.csv", FileMode.Open)))
{
while (csv.ReadNextRecord())
{
// Create Instance of Customer Api
ApiOperationBase <ANetApiRequest, ANetApiResponse> .RunEnvironment = AuthorizeNET.Environment.SANDBOX;
// define the merchant information (authentication / transaction id)
ApiOperationBase <ANetApiRequest, ANetApiResponse> .MerchantAuthentication = new merchantAuthenticationType()
{
name = ApiLoginID,
ItemElementName = ItemChoiceType.transactionKey,
Item = ApiTransactionKey,
};
//CustomersApi instance = new CustomersApi(EnvironmentSet.Sandbox);
// Customer Response Object
// Customer response = null;
//initialization
string amount = null;
string TestCaseId = null;
for (int i = 0; i < fieldCount; i++)
{
switch (headers[i])
{
case "amount":
amount = csv[i];
break;
case "TestCaseId":
TestCaseId = csv[i];
break;
default:
break;
}
}
//Write to output file
CsvRow row = new CsvRow();
try
{
if (flag == 0)
{
row.Add("TestCaseId");
row.Add("APIName");
row.Add("Status");
row.Add("TimeStamp");
writer.WriteRow(row);
flag = flag + 1;
//Append Data
foreach (var item in item1)
{
writer.WriteRow(item);
}
}
//set up data based on transaction
var opaqueData = new opaqueDataType {
dataDescriptor = "COMMON.ACCEPT.INAPP.PAYMENT", dataValue = "9471471570959063005001"
};
//standard api call to retrieve response
var paymentType = new paymentType {
Item = opaqueData
};
var transactionRequest = new transactionRequestType
{
transactionType = transactionTypeEnum.authCaptureTransaction.ToString(), // authorize and capture transaction
amount = Convert.ToDecimal(amount),
payment = paymentType
};
var request = new createTransactionRequest {
transactionRequest = transactionRequest
};
// instantiate the contoller that will call the service
var controller = new createTransactionController(request);
controller.Execute();
// get the response from the service (errors contained if any)
var response = controller.GetApiResponse();
if (response != null && response.messages.resultCode == messageTypeEnum.Ok &&
response.transactionResponse.messages != null)
{
try
{
//Assert.AreEqual(response.Id, customerProfileId);
Console.WriteLine("Assertion Succeed! Valid CustomerId fetched.");
CsvRow row1 = new CsvRow();
row1.Add("CAT_00" + flag.ToString());
row1.Add("CreateAnAcceptTransaction");
row1.Add("Pass");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
// Console.WriteLine("Success " + TestcaseID + " CustomerID : " + response.Id);
flag = flag + 1;
Console.WriteLine("Successfully created an accept transaction with Transaction ID: " + response.transactionResponse.transId);
Console.WriteLine("Response Code: " + response.transactionResponse.responseCode);
Console.WriteLine("Message Code: " + response.transactionResponse.messages[0].code);
Console.WriteLine("Description: " + response.transactionResponse.messages[0].description);
}
catch
{
CsvRow row1 = new CsvRow();
row1.Add("CAT_00" + flag.ToString());
row1.Add("CreateAnAcceptTransaction");
row1.Add("Assertion Failed!");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
Console.WriteLine("Assertion Failed! Invalid CustomerId fetched.");
flag = flag + 1;
}
}
else
{
CsvRow row1 = new CsvRow();
row1.Add("CAT_00" + flag.ToString());
row1.Add("CreateAnAcceptTransaction");
row1.Add("Fail");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
//Console.WriteLine("Assertion Failed! Invalid CustomerId fetched.");
flag = flag + 1;
}
}
catch (Exception e)
{
CsvRow row2 = new CsvRow();
row2.Add("CAT_00" + flag.ToString());
row2.Add("CreateAnAcceptTransaction");
row2.Add("Fail");
row2.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row2);
flag = flag + 1;
Console.WriteLine(TestCaseId + " Error Message " + e.Message);
}
}
}
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
if (FileUploadPayPak.HasFile)
{
string fileExtension = System.IO.Path.GetExtension(FileUploadPayPak.FileName);
if (fileExtension != ".csv")
{
lblStatus.Text = "Please Upload A File with CSV extension.";
trStatus.Visible = true;
}
else
{
try
{
//Uploaded File Saves on Server.
FileUploadPayPak.SaveAs(Server.MapPath("~/App_Data/" + FileUploadPayPak.FileName));
//Internal Working
//string str = "";
string fileName = "";
string filename = "";
lblStatus.Text = string.Empty;
fileName = Path.GetFileName(this.FileUploadPayPak.PostedFile.FileName);
fileName = FileUploadPayPak.FileName;
filename = base.Server.MapPath("~/App_Data") + "/" + fileName;
using (CsvFileReader reader = new CsvFileReader(filename))
{
int i = 0;
CsvRow row = new CsvRow();
try
{
int count = row.Count;
Debug.WriteLine("Total Rows:" + count);
while (reader.ReadRow(row))
{
i++;
if (i > 1)
{
int result = -1;
string Column1 = Convert.ToString(row[0]);
string Column2 = Convert.ToString(row[1]);
string Column3 = Convert.ToString(row[2]);
string Column4 = "";
try
{
result = cls.InsertProscribedOrganisationNACTAData(Column1, Column2, Column3, Column4);
}
catch (Exception ex)
{
lblStatus.Text = "Operation Failed: " + ex.Message;
}
count++;
}
else
{
//if (row[0] == "Column1" && row[1] == "Column2" && row[2] == "Column3" && row[4] == "Column4") { }
//else { lblStatus.Text = "File Invalid Format."; break; }
}
}
}
catch (Exception ex)
{
lblStatus.Text = "Error : " + ex.Message + ")";
}
finally
{
GC.Collect();
}
}
//Internal Working End
if (lblStatus.Text == "File Invalid Format.")
{
}
else
{
//Message Appeared when file uploads completely.
lblStatus.Text = "File Uploaded Successfully.";
}
trStatus.Visible = true;
}
catch (OutOfMemoryException ex)
{
lblStatus.Text = "Memory is not enough. Please delete old data and try again." + ex.Message;
trStatus.Visible = true;
}
catch (Exception ex)
{
lblStatus.Text = "Exception: " + ex.Message;
trStatus.Visible = true;
}
}
}
else
{
lblStatus.Text = "Please Upload A File.";
trStatus.Visible = true;
}
this.UpdatePanel1.Update();
}
/// <summary>
/// Writes the Trial File to a CSV
/// </summary>
private void WriteTrialFile(List <PostProcessingData> ppData)
{
AddPostProcessingToTrialData(ppData);
// Write all entries in data list to file
Directory.CreateDirectory(@"Data/" + pid);
using (CsvFileWriter writer = new CsvFileWriter(@"Data/" + pid + "/TrialData" + pid + ".csv"))
{
Debug.Log("Writing trial data to file");
// write header
CsvRow header = new CsvRow();
header.Add("Participant ID");
header.Add("Using right hand?");
header.Add("Rotating Targets?");
header.Add("Trial Number");
header.Add("Global Time");
header.Add("Target Number");
header.Add("Target Time");
header.Add("Weight Shift Success?");
header.Add("Hit Success?");
header.Add("Random Sequence?");
header.Add("X Coord of COP");
header.Add("Y Coord of COP");
header.Add("COP Total Path");
header.Add("Trial Score");
header.Add("Accuracy Score");
header.Add("Time Score");
header.Add("Cumulative Accuracy Score");
header.Add("Cumulative Time Score");
header.Add("Cumulative Score");
header.Add("Reach Distance");
header.Add("Green Time");
header.Add("Yellow Time");
header.Add("Red Time");
header.Add("Preceding Green Time");
header.Add("Preceding Yellow Time");
header.Add("Preceding Red Time");
writer.WriteRow(header);
// write each line of data
foreach (Data d in data)
{
CsvRow row = new CsvRow();
row.Add(d.participantId);
if (d.rightHanded)
{
row.Add("YES");
}
else
{
row.Add("NO");
}
if (d.isRotation)
{
row.Add("YES");
}
else
{
row.Add("NO");
}
row.Add(d.trialNum.ToString());
row.Add(d.time.ToString());
row.Add(d.targetNum.ToString());
row.Add(d.targetTime.ToString());
if (d.weightShiftSuccess)
{
row.Add("YES");
}
else
{
row.Add("NO");
}
if (d.buttonSuccess)
{
row.Add("YES");
}
else
{
row.Add("NO");
}
if (d.isRandomSequence)
{
row.Add("YES");
}
else
{
row.Add("NO");
}
row.Add(d.weightPosn.x.ToString());
row.Add(d.weightPosn.y.ToString());
row.Add(d.COPTotalPath.ToString());
row.Add(d.trialScore.ToString());
row.Add(d.accuracyScore.ToString());
row.Add(d.timeScore.ToString());
row.Add(d.cumulativeAccuracyScore.ToString());
row.Add(d.cumulativeTimeScore.ToString());
row.Add(d.cumulativeScore.ToString());
row.Add(d.reachDistance.ToString());
row.Add(d.curGreenTime.ToString());
row.Add(d.curYellowTime.ToString());
row.Add(d.curRedTime.ToString());
row.Add(d.precedingGreenTime.ToString());
row.Add(d.precedingYellowTime.ToString());
row.Add(d.precedingRedTime.ToString());
writer.WriteRow(row);
}
}
Task.OnRecordData -= recordTrial;
}
// [END dlp_reidentify_fpe]
// [START dlp_deidentify_date_shift]
public static object DeidDateShift(
string projectId,
string inputCsvFile,
string outputCsvFile,
int lowerBoundDays,
int upperBoundDays,
string dateFields,
string contextField = "",
string keyName = "",
string wrappedKey = "")
{
var dlp = DlpServiceClient.Create();
// Read file
var csvLines = File.ReadAllLines(inputCsvFile);
var csvHeaders = csvLines[0].Split(',');
var csvRows = csvLines.Skip(1).ToArray();
// Convert dates to protobuf format, and everything else to a string
var protoHeaders = csvHeaders.Select(header => new FieldId {
Name = header
});
var protoRows = csvRows.Select(CsvRow =>
{
var rowValues = CsvRow.Split(',');
var protoValues = rowValues.Select(RowValue =>
{
if (System.DateTime.TryParse(RowValue, out var parsedDate))
{
return(new Value
{
DateValue = new Google.Type.Date
{
Year = parsedDate.Year,
Month = parsedDate.Month,
Day = parsedDate.Day
}
});
}
else
{
return(new Value
{
StringValue = RowValue
});
}
});
var rowObject = new Table.Types.Row();
rowObject.Values.Add(protoValues);
return(rowObject);
});
var dateFieldList = dateFields
.Split(',')
.Select(field => new FieldId {
Name = field
});
// Construct + execute the request
var dateShiftConfig = new DateShiftConfig
{
LowerBoundDays = lowerBoundDays,
UpperBoundDays = upperBoundDays
};
var hasKeyName = !String.IsNullOrEmpty(keyName);
var hasWrappedKey = !String.IsNullOrEmpty(wrappedKey);
var hasContext = !String.IsNullOrEmpty(contextField);
if (hasKeyName && hasWrappedKey && hasContext)
{
dateShiftConfig.Context = new FieldId {
Name = contextField
};
dateShiftConfig.CryptoKey = new CryptoKey
{
KmsWrapped = new KmsWrappedCryptoKey
{
WrappedKey = ByteString.FromBase64(wrappedKey),
CryptoKeyName = keyName
}
};
}
else if (hasKeyName || hasWrappedKey || hasContext)
{
throw new ArgumentException("Must specify ALL or NONE of: {contextFieldId, keyName, wrappedKey}!");
}
var deidConfig = new DeidentifyConfig
{
RecordTransformations = new RecordTransformations
{
FieldTransformations =
{
new FieldTransformation
{
PrimitiveTransformation = new PrimitiveTransformation
{
DateShiftConfig = dateShiftConfig
},
Fields ={ dateFieldList }
}
}
}
};
var response = dlp.DeidentifyContent(
new DeidentifyContentRequest
{
Parent = $"projects/{projectId}",
DeidentifyConfig = deidConfig,
Item = new ContentItem
{
Table = new Table
{
Headers = { protoHeaders },
Rows = { protoRows }
}
}
});
// Save the results
var outputLines = new List <string>
{
csvLines[0]
};
outputLines.AddRange(response.Item.Table.Rows.Select(ProtoRow =>
{
var Values = ProtoRow.Values.Select(ProtoValue =>
{
if (ProtoValue.DateValue != null)
{
var ProtoDate = ProtoValue.DateValue;
var Date = new System.DateTime(
ProtoDate.Year, ProtoDate.Month, ProtoDate.Day);
return(Date.ToShortDateString());
}
else
{
return(ProtoValue.StringValue);
}
});
return(String.Join(',', Values));
}));
File.WriteAllLines(outputCsvFile, outputLines);
return(0);
}
public async void CtpToJHTransition(List <State> CtpData)
{
StorageFolder exportFolder = null;
if (StorageApplicationPermissions.FutureAccessList.ContainsItem("ExportFolder"))
{
DateTime currentDate = new DateTime(2020, 3, 2);
DateTime endDate = new DateTime(2020, 4, 11);
while (currentDate <= endDate)
{
exportFolder = await StorageApplicationPermissions.FutureAccessList.GetFolderAsync("ExportFolder");
StorageFile csvFile = await exportFolder?.CreateFileAsync(currentDate.Date.ToString("MM-dd-yyyy", CultureInfo.InvariantCulture) + ".csv", Windows.Storage.CreationCollisionOption.ReplaceExisting);
using (CsvFileWriter dataWriter = new CsvFileWriter(await csvFile.OpenStreamForWriteAsync()))
{
CsvRow headerRow = new CsvRow();
headerRow.Add("Province_State");
headerRow.Add("Country_Region");
headerRow.Add("Last_Update");
headerRow.Add("Lat");
headerRow.Add("Long_");
headerRow.Add("Confirmed");
headerRow.Add("Deaths");
headerRow.Add("Recovered");
headerRow.Add("Active");
headerRow.Add("FIPS");
headerRow.Add("Incident_Rate");
headerRow.Add("Total_Test_Results");
headerRow.Add("People_Hospitalized");
headerRow.Add("Case_Fatality_Ratio");
headerRow.Add("UID");
headerRow.Add("ISO3");
headerRow.Add("Testing_Rate");
headerRow.Add("Testing_Rate");
dataWriter.WriteRow(headerRow);
foreach (State s in CtpData)
{
var dataPoint = s.CovidData.FirstOrDefault(dat => dat.Date.ToString("MM-dd-yyyy", CultureInfo.InvariantCulture) == currentDate.Date.ToString("MM-dd-yyyy", CultureInfo.InvariantCulture));
if (dataPoint != null)
{
CsvRow nextRow = new CsvRow();
nextRow.Add(StateMapHelper.StateBaseToString(s.StateBase.Name));
nextRow.Add("US");
nextRow.Add(currentDate.Date.ToString("MM-dd-yyyy", CultureInfo.InvariantCulture) + " 4:30:00 PM");
nextRow.Add("");
nextRow.Add("");
if (dataPoint.Positive != null)
{
nextRow.Add(dataPoint.Positive.ToString());
}
else
{
nextRow.Add("0");
}
if (dataPoint.Death != null)
{
nextRow.Add(dataPoint.Death.ToString());
}
else
{
nextRow.Add("0");
}
nextRow.Add(""); //Recovered
nextRow.Add(""); //active
nextRow.Add(""); // FIPS
nextRow.Add(""); // Incident_Rate
if (dataPoint.TotalTestResults != null)
{
nextRow.Add(dataPoint.TotalTestResults.ToString());
}
else
{
nextRow.Add("0");
}
if (dataPoint.Hospitalized != null)
{
nextRow.Add(dataPoint.Hospitalized.ToString());
}
else
{
nextRow.Add("0");
}
if (dataPoint.Positive > 0)
{
nextRow.Add(((Convert.ToDouble(dataPoint.Death) / Convert.ToDouble(dataPoint.Positive)) * 100).ToString());
}
else
{
nextRow.Add("0.0");
}
nextRow.Add(""); // UID
nextRow.Add(""); // ISO3
nextRow.Add(""); // TestingRate
nextRow.Add(""); // Hospitalization Rate
dataWriter.WriteRow(nextRow);
}
else
{
CsvRow nextRow = new CsvRow();
nextRow.Add(s.StateBase.Name.ToString());
nextRow.Add("US");
nextRow.Add(currentDate.Date.ToString("MM-dd-yyyy", CultureInfo.InvariantCulture) + " 4:30:00 PM");
nextRow.Add("");
nextRow.Add("");
nextRow.Add("0");
nextRow.Add("0");
nextRow.Add(""); //Recovered
nextRow.Add(""); //active
nextRow.Add(""); // FIPS
nextRow.Add(""); // Incident_Rate
nextRow.Add("0");
nextRow.Add("0");
nextRow.Add("0.0");
nextRow.Add(""); // UID
nextRow.Add(""); // ISO3
nextRow.Add(""); // TestingRate
nextRow.Add(""); // Hospitalization Rate
dataWriter.WriteRow(nextRow);
}
}
currentDate = currentDate + new TimeSpan(1, 0, 0, 0);
}
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="EventOutputData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public EventOutputData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// EventOutputData.
}
/// <summary>
/// Initializes a new instance of the <see cref="TournamentTierData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public TournamentTierData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// TournamentTierData.
}
//public static ANetApiResponse Run(String ApiLoginID, String ApiTransactionKey, Decimal Amount)
//{
// Console.WriteLine("Create Apple Pay Transaction Sample");
// ApiOperationBase<ANetApiRequest, ANetApiResponse>.RunEnvironment = AuthorizeNET.Environment.SANDBOX;
// // define the merchant information (authentication / transaction id)
// ApiOperationBase<ANetApiRequest, ANetApiResponse>.MerchantAuthentication = new merchantAuthenticationType()
// {
// name = ApiLoginID,
// ItemElementName = ItemChoiceType.transactionKey,
// Item = ApiTransactionKey,
// };
// //set up data based on transaction
// var opaqueData = new opaqueDataType { dataDescriptor = "COMMON.APPLE.INAPP.PAYMENT", dataValue = "eyJkYXRhIjoiQkRQTldTdE1tR2V3UVVXR2c0bzdFXC9qKzFjcTFUNzhxeVU4NGI2N2l0amNZSTh3UFlBT2hzaGpoWlBycWRVcjRYd1BNYmo0emNHTWR5KysxSDJWa1BPWStCT01GMjV1YjE5Y1g0bkN2a1hVVU9UakRsbEIxVGdTcjhKSFp4Z3A5ckNnc1NVZ2JCZ0tmNjBYS3V0WGY2YWpcL284WkliS25yS1E4U2gwb3VMQUtsb1VNbit2UHU0K0E3V0tycXJhdXo5SnZPUXA2dmhJcStIS2pVY1VOQ0lUUHlGaG1PRXRxK0grdzB2UmExQ0U2V2hGQk5uQ0hxenpXS2NrQlwvMG5xTFpSVFliRjBwK3Z5QmlWYVdIZWdoRVJmSHhSdGJ6cGVjelJQUHVGc2ZwSFZzNDhvUExDXC9rXC8xTU5kNDdrelwvcEhEY1JcL0R5NmFVTStsTmZvaWx5XC9RSk4rdFMzbTBIZk90SVNBUHFPbVhlbXZyNnhKQ2pDWmxDdXcwQzltWHpcL29iSHBvZnVJRVM4cjljcUdHc1VBUERwdzdnNjQybTRQendLRitIQnVZVW5lV0RCTlNEMnU2amJBRzMiLCJ2ZXJzaW9uIjoiRUNfdjEiLCJoZWFkZXIiOnsiYXBwbGljYXRpb25EYXRhIjoiOTRlZTA1OTMzNWU1ODdlNTAxY2M0YmY5MDYxM2UwODE0ZjAwYTdiMDhiYzdjNjQ4ZmQ4NjVhMmFmNmEyMmNjMiIsInRyYW5zYWN0aW9uSWQiOiJjMWNhZjVhZTcyZjAwMzlhODJiYWQ5MmI4MjgzNjM3MzRmODViZjJmOWNhZGYxOTNkMWJhZDlkZGNiNjBhNzk1IiwiZXBoZW1lcmFsUHVibGljS2V5IjoiTUlJQlN6Q0NBUU1HQnlxR1NNNDlBZ0V3Z2ZjQ0FRRXdMQVlIS29aSXpqMEJBUUloQVBcL1wvXC9cLzhBQUFBQkFBQUFBQUFBQUFBQUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL01Gc0VJUFwvXC9cL1wvOEFBQUFCQUFBQUFBQUFBQUFBQUFBQVwvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cLzhCQ0JheGpYWXFqcVQ1N1BydlZWMm1JYThaUjBHc014VHNQWTd6ancrSjlKZ1N3TVZBTVNkTmdpRzV3U1RhbVo0NFJPZEpyZUJuMzZRQkVFRWF4ZlI4dUVzUWtmNHZPYmxZNlJBOG5jRGZZRXQ2ek9nOUtFNVJkaVl3cFpQNDBMaVwvaHBcL200N242MHA4RDU0V0s4NHpWMnN4WHM3THRrQm9ONzlSOVFJaEFQXC9cL1wvXC84QUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cLys4NXZxdHB4ZWVoUE81eXNMOFl5VlJBZ0VCQTBJQUJHbStnc2wwUFpGVFwva0RkVVNreHd5Zm84SnB3VFFRekJtOWxKSm5tVGw0REdVdkFENEdzZUdqXC9wc2hCWjBLM1RldXFEdFwvdERMYkUrOFwvbTB5Q21veHc9IiwicHVibGljS2V5SGFzaCI6IlwvYmI5Q05DMzZ1QmhlSEZQYm1vaEI3T28xT3NYMkora0pxdjQ4ek9WVmlRPSJ9LCJzaWduYXR1cmUiOiJNSUlEUWdZSktvWklodmNOQVFjQ29JSURNekNDQXk4Q0FRRXhDekFKQmdVckRnTUNHZ1VBTUFzR0NTcUdTSWIzRFFFSEFhQ0NBaXN3Z2dJbk1JSUJsS0FEQWdFQ0FoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQXdKekVsTUNNR0ExVUVBeDRjQUdNQWFBQnRBR0VBYVFCQUFIWUFhUUJ6QUdFQUxnQmpBRzhBYlRBZUZ3MHhOREF4TURFd05qQXdNREJhRncweU5EQXhNREV3TmpBd01EQmFNQ2N4SlRBakJnTlZCQU1lSEFCakFHZ0FiUUJoQUdrQVFBQjJBR2tBY3dCaEFDNEFZd0J2QUcwd2daOHdEUVlKS29aSWh2Y05BUUVCQlFBRGdZMEFNSUdKQW9HQkFOQzgra2d0Z212V0YxT3pqZ0ROcmpURUJSdW9cLzVNS3ZsTTE0NnBBZjdHeDQxYmxFOXc0ZklYSkFEN0ZmTzdRS2pJWFlOdDM5ckx5eTd4RHdiXC81SWtaTTYwVFoyaUkxcGo1NVVjOGZkNGZ6T3BrM2Z0WmFRR1hOTFlwdEcxZDlWN0lTODJPdXA5TU1vMUJQVnJYVFBITmNzTTk5RVBVblBxZGJlR2M4N20wckFnTUJBQUdqWERCYU1GZ0dBMVVkQVFSUk1FK0FFSFpXUHJXdEpkN1laNDMxaENnN1lGU2hLVEFuTVNVd0l3WURWUVFESGh3QVl3Qm9BRzBBWVFCcEFFQUFkZ0JwQUhNQVlRQXVBR01BYndCdGdoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQURnWUVBYlVLWUNrdUlLUzlRUTJtRmNNWVJFSW0ybCtYZzhcL0pYditHQlZRSmtPS29zY1k0aU5ERkFcL2JRbG9nZjlMTFU4NFRId05SbnN2VjNQcnY3UlRZODFncTBkdEM4elljQWFBa0NISUkzeXFNbko0QU91NkVPVzlrSmsyMzJnU0U3V2xDdEhiZkxTS2Z1U2dRWDhLWFFZdVpMazJScjYzTjhBcFhzWHdCTDNjSjB4Z2VBd2dkMENBUUV3T3pBbk1TVXdJd1lEVlFRREhod0FZd0JvQUcwQVlRQnBBRUFBZGdCcEFITUFZUUF1QUdNQWJ3QnRBaEJjbCtQZjMrVTRwazEzblZEOW53UVFNQWtHQlNzT0F3SWFCUUF3RFFZSktvWklodmNOQVFFQkJRQUVnWUJhSzNFbE9zdGJIOFdvb3NlREFCZitKZ1wvMTI5SmNJYXdtN2M2VnhuN1phc05iQXEzdEF0OFB0eSt1UUNnc3NYcVprTEE3a3oyR3pNb2xOdHY5d1ltdTlVandhcjFQSFlTK0JcL29Hbm96NTkxd2phZ1hXUnowbk1vNXkzTzFLelgwZDhDUkhBVmE4OFNyVjFhNUpJaVJldjNvU3RJcXd2NXh1WmxkYWc2VHI4dz09In0=" };
// //standard api call to retrieve response
// var paymentType = new paymentType { Item = opaqueData };
// var transactionRequest = new transactionRequestType
// {
// transactionType = transactionTypeEnum.authCaptureTransaction.ToString() , // authorize and capture transaction
// amount = Amount,
// payment = paymentType
// };
// var request = new createTransactionRequest { transactionRequest = transactionRequest };
// // instantiate the contoller that will call the service
// var controller = new createTransactionController(request);
// controller.Execute();
// // get the response from the service (errors contained if any)
// var response = controller.GetApiResponse();
// //validate
// if (response != null)
// {
// if (response.messages.resultCode == messageTypeEnum.Ok)
// {
// if(response.transactionResponse.messages != null)
// {
// Console.WriteLine("Successfully created an Apple pay transaction with Transaction ID: " + response.transactionResponse.transId);
// Console.WriteLine("Response Code: " + response.transactionResponse.responseCode);
// Console.WriteLine("Message Code: " + response.transactionResponse.messages[0].code);
// Console.WriteLine("Description: " + response.transactionResponse.messages[0].description);
// }
// else
// {
// Console.WriteLine("Failed Transaction.");
// if (response.transactionResponse.errors != null)
// {
// Console.WriteLine("Error Code: " + response.transactionResponse.errors[0].errorCode);
// Console.WriteLine("Error message: " + response.transactionResponse.errors[0].errorText);
// }
// }
// }
// else
// {
// Console.WriteLine("Failed Transaction.");
// if (response.transactionResponse != null && response.transactionResponse.errors != null)
// {
// Console.WriteLine("Error Code: " + response.transactionResponse.errors[0].errorCode);
// Console.WriteLine("Error message: " + response.transactionResponse.errors[0].errorText);
// }
// else
// {
// Console.WriteLine("Error Code: " + response.messages.message[0].code);
// Console.WriteLine("Error message: " + response.messages.message[0].text);
// }
// }
// }
// else
// {
// Console.WriteLine("Null Response.");
// }
// return response;
//}
public static void CreateAnApplePayTransactionExec(String ApiLoginID, String ApiTransactionKey)
{
using (CsvReader csv = new CsvReader(new StreamReader(new FileStream(@"../../../CSV_DATA/CreateAnApplePayTransaction.csv", FileMode.Open)), true))
{
Console.WriteLine("Create Apple Pay Transaction Sample");
int flag = 0;
int fieldCount = csv.FieldCount;
string[] headers = csv.GetFieldHeaders();
//Append Data
var item1 = DataAppend.ReadPrevData();
using (CsvFileWriter writer = new CsvFileWriter(new FileStream(@"../../../CSV_DATA/Outputfile.csv", FileMode.Open)))
{
while (csv.ReadNextRecord())
{
// Create Instance of Customer Api
ApiOperationBase <ANetApiRequest, ANetApiResponse> .RunEnvironment = AuthorizeNET.Environment.SANDBOX;
// define the merchant information (authentication / transaction id)
ApiOperationBase <ANetApiRequest, ANetApiResponse> .MerchantAuthentication = new merchantAuthenticationType()
{
name = ApiLoginID,
ItemElementName = ItemChoiceType.transactionKey,
Item = ApiTransactionKey,
};
string amount = null;
string TestCaseId = null;
for (int i = 0; i < fieldCount; i++)
{
switch (headers[i])
{
case "amount":
amount = csv[i];
break;
case "TestCaseId":
TestCaseId = csv[i];
break;
default:
break;
}
}
//Write to output file
CsvRow row = new CsvRow();
try
{
if (flag == 0)
{
row.Add("TestCaseId");
row.Add("APIName");
row.Add("Status");
row.Add("TimeStamp");
writer.WriteRow(row);
flag = flag + 1;
//Append Data
foreach (var item in item1)
{
writer.WriteRow(item);
}
}
//var opaqueData = new opaqueDataType { dataDescriptor = "COMMON.APPLE.INAPP.PAYMENT", dataValue = "eyJkYXRhIjoiQkRQTldTdE1tR2V3UVVXR2c0bzdFXC9qKzFjcTFUNzhxeVU4NGI2N2l0amNZSTh3UFlBT2hzaGpoWlBycWRVcjRYd1BNYmo0emNHTWR5KysxSDJWa1BPWStCT01GMjV1YjE5Y1g0bkN2a1hVVU9UakRsbEIxVGdTcjhKSFp4Z3A5ckNnc1NVZ2JCZ0tmNjBYS3V0WGY2YWpcL284WkliS25yS1E4U2gwb3VMQUtsb1VNbit2UHU0K0E3V0tycXJhdXo5SnZPUXA2dmhJcStIS2pVY1VOQ0lUUHlGaG1PRXRxK0grdzB2UmExQ0U2V2hGQk5uQ0hxenpXS2NrQlwvMG5xTFpSVFliRjBwK3Z5QmlWYVdIZWdoRVJmSHhSdGJ6cGVjelJQUHVGc2ZwSFZzNDhvUExDXC9rXC8xTU5kNDdrelwvcEhEY1JcL0R5NmFVTStsTmZvaWx5XC9RSk4rdFMzbTBIZk90SVNBUHFPbVhlbXZyNnhKQ2pDWmxDdXcwQzltWHpcL29iSHBvZnVJRVM4cjljcUdHc1VBUERwdzdnNjQybTRQendLRitIQnVZVW5lV0RCTlNEMnU2amJBRzMiLCJ2ZXJzaW9uIjoiRUNfdjEiLCJoZWFkZXIiOnsiYXBwbGljYXRpb25EYXRhIjoiOTRlZTA1OTMzNWU1ODdlNTAxY2M0YmY5MDYxM2UwODE0ZjAwYTdiMDhiYzdjNjQ4ZmQ4NjVhMmFmNmEyMmNjMiIsInRyYW5zYWN0aW9uSWQiOiJjMWNhZjVhZTcyZjAwMzlhODJiYWQ5MmI4MjgzNjM3MzRmODViZjJmOWNhZGYxOTNkMWJhZDlkZGNiNjBhNzk1IiwiZXBoZW1lcmFsUHVibGljS2V5IjoiTUlJQlN6Q0NBUU1HQnlxR1NNNDlBZ0V3Z2ZjQ0FRRXdMQVlIS29aSXpqMEJBUUloQVBcL1wvXC9cLzhBQUFBQkFBQUFBQUFBQUFBQUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL01Gc0VJUFwvXC9cL1wvOEFBQUFCQUFBQUFBQUFBQUFBQUFBQVwvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cLzhCQ0JheGpYWXFqcVQ1N1BydlZWMm1JYThaUjBHc014VHNQWTd6ancrSjlKZ1N3TVZBTVNkTmdpRzV3U1RhbVo0NFJPZEpyZUJuMzZRQkVFRWF4ZlI4dUVzUWtmNHZPYmxZNlJBOG5jRGZZRXQ2ek9nOUtFNVJkaVl3cFpQNDBMaVwvaHBcL200N242MHA4RDU0V0s4NHpWMnN4WHM3THRrQm9ONzlSOVFJaEFQXC9cL1wvXC84QUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cLys4NXZxdHB4ZWVoUE81eXNMOFl5VlJBZ0VCQTBJQUJHbStnc2wwUFpGVFwva0RkVVNreHd5Zm84SnB3VFFRekJtOWxKSm5tVGw0REdVdkFENEdzZUdqXC9wc2hCWjBLM1RldXFEdFwvdERMYkUrOFwvbTB5Q21veHc9IiwicHVibGljS2V5SGFzaCI6IlwvYmI5Q05DMzZ1QmhlSEZQYm1vaEI3T28xT3NYMkora0pxdjQ4ek9WVmlRPSJ9LCJzaWduYXR1cmUiOiJNSUlEUWdZSktvWklodmNOQVFjQ29JSURNekNDQXk4Q0FRRXhDekFKQmdVckRnTUNHZ1VBTUFzR0NTcUdTSWIzRFFFSEFhQ0NBaXN3Z2dJbk1JSUJsS0FEQWdFQ0FoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQXdKekVsTUNNR0ExVUVBeDRjQUdNQWFBQnRBR0VBYVFCQUFIWUFhUUJ6QUdFQUxnQmpBRzhBYlRBZUZ3MHhOREF4TURFd05qQXdNREJhRncweU5EQXhNREV3TmpBd01EQmFNQ2N4SlRBakJnTlZCQU1lSEFCakFHZ0FiUUJoQUdrQVFBQjJBR2tBY3dCaEFDNEFZd0J2QUcwd2daOHdEUVlKS29aSWh2Y05BUUVCQlFBRGdZMEFNSUdKQW9HQkFOQzgra2d0Z212V0YxT3pqZ0ROcmpURUJSdW9cLzVNS3ZsTTE0NnBBZjdHeDQxYmxFOXc0ZklYSkFEN0ZmTzdRS2pJWFlOdDM5ckx5eTd4RHdiXC81SWtaTTYwVFoyaUkxcGo1NVVjOGZkNGZ6T3BrM2Z0WmFRR1hOTFlwdEcxZDlWN0lTODJPdXA5TU1vMUJQVnJYVFBITmNzTTk5RVBVblBxZGJlR2M4N20wckFnTUJBQUdqWERCYU1GZ0dBMVVkQVFSUk1FK0FFSFpXUHJXdEpkN1laNDMxaENnN1lGU2hLVEFuTVNVd0l3WURWUVFESGh3QVl3Qm9BRzBBWVFCcEFFQUFkZ0JwQUhNQVlRQXVBR01BYndCdGdoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQURnWUVBYlVLWUNrdUlLUzlRUTJtRmNNWVJFSW0ybCtYZzhcL0pYditHQlZRSmtPS29zY1k0aU5ERkFcL2JRbG9nZjlMTFU4NFRId05SbnN2VjNQcnY3UlRZODFncTBkdEM4elljQWFBa0NISUkzeXFNbko0QU91NkVPVzlrSmsyMzJnU0U3V2xDdEhiZkxTS2Z1U2dRWDhLWFFZdVpMazJScjYzTjhBcFhzWHdCTDNjSjB4Z2VBd2dkMENBUUV3T3pBbk1TVXdJd1lEVlFRREhod0FZd0JvQUcwQVlRQnBBRUFBZGdCcEFITUFZUUF1QUdNQWJ3QnRBaEJjbCtQZjMrVTRwazEzblZEOW53UVFNQWtHQlNzT0F3SWFCUUF3RFFZSktvWklodmNOQVFFQkJRQUVnWUJhSzNFbE9zdGJIOFdvb3NlREFCZitKZ1wvMTI5SmNJYXdtN2M2VnhuN1phc05iQXEzdEF0OFB0eSt1UUNnc3NYcVprTEE3a3oyR3pNb2xOdHY5d1ltdTlVandhcjFQSFlTK0JcL29Hbm96NTkxd2phZ1hXUnowbk1vNXkzTzFLelgwZDhDUkhBVmE4OFNyVjFhNUpJaVJldjNvU3RJcXd2NXh1WmxkYWc2VHI4dz09In0=" };
var opaqueData = new opaqueDataType {
dataDescriptor = "COMMON.APPLE.INAPP.PAYMENT", dataValue = "eyJkYXRhIjoiMHRTbWRvOGwrbkxYRE5DQWJkdmRBY1wveHNzVGFRYmdpaUpzemlnbEh1aTZzcmI1UHRaSjJQU3RibElmYUNGQVdBSGhXSVFsd1J6Ujg0V3FnOUhxN0o0QVZWMW5wQ2xUOEV2M2hjMlMxSVwvZEZPd1NxYWliQm45ejBFTTg3ZThNWVwvVGdtVmNYSDJ4XC80S1JFM08rZFIrcjNvT2VFV1BMM2Qydlo5WGJ1ZWk4enV4Y21zTG9xM1J4Vzc3WW1RclFCdUhDdUlvdXlEVGcyZmtRV2dleHY5ZTJLMmxIQ0lZa3Bicis3M0UzczZMRitaXC9OYk9acU9Cc0JFaWRrNEdQVU5VcllqQVpLWjRrcThOMVwvdloxU0RsaW1iaGFBKzNlempWWHJYWEowZXFIVnJBc1VHZVpyaGxUYjA5RWdya3cwNWhhbkRuNHdCWG91QU5NbTZhUFZVMWVNTTFcL2dYdm16Mmg4Tm1GbFJxRGljWkk2WmNHRXRoWElsVVpUaXlvQTVOWHFKbzJZaWlWcW8wNGJaemlOM3dVQjQ1b2k4eU1PTVlqaG9IYUZlcnFzUWFLaEU2bFA4bXdaVFV4IiwidmVyc2lvbiI6IkVDX3YxIiwiaGVhZGVyIjp7ImFwcGxpY2F0aW9uRGF0YSI6Ijk0ZWUwNTkzMzVlNTg3ZTUwMWNjNGJmOTA2MTNlMDgxNGYwMGE3YjA4YmM3YzY0OGZkODY1YTJhZjZhMjJjYzIiLCJ0cmFuc2FjdGlvbklkIjoiYzFjYWY1YWU3MmYwMDM5YTgyYmFkOTJiODI4MzYzNzM0Zjg1YmYyZjljYWRmMTkzZDFiYWQ5ZGRjYjYwYTc5NSIsImVwaGVtZXJhbFB1YmxpY0tleSI6Ik1JSUJTekNDQVFNR0J5cUdTTTQ5QWdFd2dmY0NBUUV3TEFZSEtvWkl6ajBCQVFJaEFQXC9cL1wvXC84QUFBQUJBQUFBQUFBQUFBQUFBQUFBXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9NRnNFSVBcL1wvXC9cLzhBQUFBQkFBQUFBQUFBQUFBQUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC84QkNCYXhqWFlxanFUNTdQcnZWVjJtSWE4WlIwR3NNeFRzUFk3emp3K0o5SmdTd01WQU1TZE5naUc1d1NUYW1aNDRST2RKcmVCbjM2UUJFRUVheGZSOHVFc1FrZjR2T2JsWTZSQThuY0RmWUV0NnpPZzlLRTVSZGlZd3BaUDQwTGlcL2hwXC9tNDduNjBwOEQ1NFdLODR6VjJzeFhzN0x0a0JvTjc5UjlRSWhBUFwvXC9cL1wvOEFBQUFBXC9cL1wvXC9cL1wvXC9cL1wvXC8rODV2cXRweGVlaFBPNXlzTDhZeVZSQWdFQkEwSUFCT2lVUkpScVA0WThTV3FXaVk3THJOVWtiMCtpTW1XVHdLdmJyWmtDanlUZTJSd2ZZc2lIU3ArM2Y0UnZqYVE5TjVWeFhzaEo2b0lYSlY3UmJIWmJxKzg9IiwicHVibGljS2V5SGFzaCI6IlFmMEZmdFd1c0FOZmN5c2NwbVJ1b2MxOEJyS1ByeHdQdmJQOEVUUTVNcTA9In0sInNpZ25hdHVyZSI6Ik1JSURRZ1lKS29aSWh2Y05BUWNDb0lJRE16Q0NBeThDQVFFeEN6QUpCZ1VyRGdNQ0dnVUFNQXNHQ1NxR1NJYjNEUUVIQWFDQ0Fpc3dnZ0luTUlJQmxLQURBZ0VDQWhCY2wrUGYzK1U0cGsxM25WRDlud1FRTUFrR0JTc09Bd0lkQlFBd0p6RWxNQ01HQTFVRUF4NGNBR01BYUFCdEFHRUFhUUJBQUhZQWFRQnpBR0VBTGdCakFHOEFiVEFlRncweE5EQXhNREV3TmpBd01EQmFGdzB5TkRBeE1ERXdOakF3TURCYU1DY3hKVEFqQmdOVkJBTWVIQUJqQUdnQWJRQmhBR2tBUUFCMkFHa0Fjd0JoQUM0QVl3QnZBRzB3Z1o4d0RRWUpLb1pJaHZjTkFRRUJCUUFEZ1kwQU1JR0pBb0dCQU5DOCtrZ3RnbXZXRjFPempnRE5yalRFQlJ1b1wvNU1LdmxNMTQ2cEFmN0d4NDFibEU5dzRmSVhKQUQ3RmZPN1FLaklYWU50MzlyTHl5N3hEd2JcLzVJa1pNNjBUWjJpSTFwajU1VWM4ZmQ0ZnpPcGszZnRaYVFHWE5MWXB0RzFkOVY3SVM4Mk91cDlNTW8xQlBWclhUUEhOY3NNOTlFUFVuUHFkYmVHYzg3bTByQWdNQkFBR2pYREJhTUZnR0ExVWRBUVJSTUUrQUVIWldQcld0SmQ3WVo0MzFoQ2c3WUZTaEtUQW5NU1V3SXdZRFZRUURIaHdBWXdCb0FHMEFZUUJwQUVBQWRnQnBBSE1BWVFBdUFHTUFid0J0Z2hCY2wrUGYzK1U0cGsxM25WRDlud1FRTUFrR0JTc09Bd0lkQlFBRGdZRUFiVUtZQ2t1SUtTOVFRMm1GY01ZUkVJbTJsK1hnOFwvSlh2K0dCVlFKa09Lb3NjWTRpTkRGQVwvYlFsb2dmOUxMVTg0VEh3TlJuc3ZWM1BydjdSVFk4MWdxMGR0Qzh6WWNBYUFrQ0hJSTN5cU1uSjRBT3U2RU9XOWtKazIzMmdTRTdXbEN0SGJmTFNLZnVTZ1FYOEtYUVl1WkxrMlJyNjNOOEFwWHNYd0JMM2NKMHhnZUF3Z2QwQ0FRRXdPekFuTVNVd0l3WURWUVFESGh3QVl3Qm9BRzBBWVFCcEFFQUFkZ0JwQUhNQVlRQXVBR01BYndCdEFoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJYUJRQXdEUVlKS29aSWh2Y05BUUVCQlFBRWdZQ0FNdzhVMmsxODM3ZW9mVkFreVVSK2E2bkt3VVNzYWthXC90VEd6QUswOWY4dHdsdDFmQTR0RVJBK21wTEppUWZkU1NZXC9mN2ZQNTJRb001UGhCZFYzTFBRaktSOFo1TjNKUzdGbU5Kd1ZTbndRY3gzYVJuaFR2d0RNRHMrZVJtSm5JK0VcL242Y05wYXpMeDVMRzRFMGplMFwvclJkbEhXYWxEK1NCTW4xQW5YY2c9PSJ9"
};
//standard api call to retrieve response
var paymentType = new paymentType {
Item = opaqueData
};
var transactionRequest = new transactionRequestType
{
transactionType = transactionTypeEnum.authCaptureTransaction.ToString(), // authorize and capture transaction
amount = Convert.ToDecimal(amount),
payment = paymentType
};
var request = new createTransactionRequest {
transactionRequest = transactionRequest
};
// instantiate the contoller that will call the service
var controller = new createTransactionController(request);
controller.Execute();
// get the response from the service (errors contained if any)
var response = controller.GetApiResponse();
if (response != null && response.messages.resultCode == messageTypeEnum.Ok &&
response.transactionResponse.messages != null)
{
try
{
//Assert.AreEqual(response.Id, customerProfileId);
Console.WriteLine("Assertion Succeed! Valid CustomerId fetched.");
CsvRow row1 = new CsvRow();
row1.Add("CAAPT_00" + flag.ToString());
row1.Add("CreateAnApplePayTransaction");
row1.Add("Pass");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
// Console.WriteLine("Success " + TestcaseID + " CustomerID : " + response.Id);
flag = flag + 1;
Console.WriteLine("Successfully created an Apple pay transaction with Transaction ID: " + response.transactionResponse.transId);
Console.WriteLine("Response Code: " + response.transactionResponse.responseCode);
Console.WriteLine("Message Code: " + response.transactionResponse.messages[0].code);
Console.WriteLine("Description: " + response.transactionResponse.messages[0].description);
}
catch
{
CsvRow row1 = new CsvRow();
row1.Add("CAAPT_00" + flag.ToString());
row1.Add("CreateAnApplePayTransaction");
row1.Add("Assertion Failed!");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
Console.WriteLine("Assertion Failed! Invalid CustomerId fetched.");
flag = flag + 1;
}
}
else
{
CsvRow row1 = new CsvRow();
row1.Add("CAAPT_00" + flag.ToString());
row1.Add("CreateAnApplePayTransaction");
row1.Add("Fail");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
//Console.WriteLine("Assertion Failed! Invalid CustomerId fetched.");
flag = flag + 1;
}
}
catch (Exception e)
{
CsvRow row2 = new CsvRow();
row2.Add("CAAPT_00" + flag.ToString());
row2.Add("CreateAnApplePayTransaction");
row2.Add("Fail");
row2.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row2);
flag = flag + 1;
Console.WriteLine(TestCaseId + " Error Message " + e.Message);
}
}
}
}
}
System.Object IntArrayReader(string text)
{
if (!string.IsNullOrEmpty(text.Trim()))
{
return(CSVHelper.CsvHelper.ToIntArray(text));
}
else
{
return new int[] { 0 }
};
}
System.Object FloatReader(string text)
{
if (!string.IsNullOrEmpty(text.Trim()))
{
return(System.Convert.ToSingle(text));
}
else
{
return(0.0f);
}
}
System.Object FloatArrayReader(string text)
{
if (!string.IsNullOrEmpty(text.Trim()))
{
return(CSVHelper.CsvHelper.ToFloatArray(text));
}
else
{
return new float[] { 0.0f }
};
}
System.Object StringReader(string text)
{
return(text);
}
System.Object StringArrayReader(string text)
{
if (!string.IsNullOrEmpty(text))
{
return(CSVHelper.CsvHelper.ToStringArray(text));
}
else
{
return new string[] { "" }
};
}
public void Read(System.Type t, List <CsvRow> rows, IDictionary dic)
{
if (rows.Count <= 3)
{
return;
}
List <string> fileNames = rows[1];
Dictionary <int, FieldInfo> fs = new Dictionary <int, FieldInfo>();
int k = 0;
foreach (var szName in fileNames)
{
#if NETFX_CORE
FieldInfo f = WinRTLegacy.TypeExtensions.GetField(t, fileNames[j], BindingFlags.Instance | BindingFlags.Public);
#else
FieldInfo f = t.GetField(szName, BindingFlags.Instance | BindingFlags.Public);
#endif
fs[k] = f;
k++;
}
for (int i = 3; i < rows.Count; i++)
{
CsvRow r = rows[i];
if (r.Count <= 0)
{
continue;
}
System.Object elem = System.Activator.CreateInstance(t);
for (int j = 0; j < r.Count; j++)
{
string text = r[j];
if (string.IsNullOrEmpty(text))
{
continue;
}
FieldInfo f = null;
if (!fs.TryGetValue(j, out f))
{
continue;
}
if (null != f)
{
System.Object o = Parse(text, f.FieldType);
f.SetValue(elem, o);
if (j == 0)
{
dic[o] = elem;
}
}
}
}
}
int GetIndex(string Name, CsvRow row)
{
int i = -1;
foreach (var r in row)
{
i++;
if (r.Trim() == Name.Trim())
{
return(i);
}
}
return(i);
}
}
public static List <T> LoadCsvFile <T>(string path)
{
path = GetStreamingPath(path);
Debug.Log(string.Format("LoadCsvFile({0})", path));
WWW www = new WWW(path);
while (!www.isDone)
{
}
CsvFileReader reader = new CsvFileReader(new MemoryStream(Encoding.Default.GetBytes(www.text)));
List <T> list = new List <T>();
Type type = typeof(T);
CsvRow names = null;
CsvRow descriptions = null;
while (!reader.EndOfStream)
{
CsvRow row = new CsvRow();
if (reader.ReadRow(row))
{
if (names == null)
{
names = row;
}
else if (descriptions == null)
{
descriptions = row;
}
else
{
if (row.Count == names.Count)
{
T t = Activator.CreateInstance <T>();
for (int i = 0; i < row.Count; i++)
{
FieldInfo field = type.GetField(names[i], BindingFlags.Public | BindingFlags.Instance);
object value = null;
if (field.FieldType == typeof(string))
{
value = row[i];
}
else if (field.FieldType == typeof(int))
{
value = int.Parse(row[i]);
}
else if (field.FieldType == typeof(uint))
{
value = uint.Parse(row[i]);
}
else if (field.FieldType == typeof(float))
{
value = float.Parse(row[i]);
}
else if (field.FieldType.IsEnum)
{
value = Enum.Parse(field.FieldType, row[i]);
}
if (value != null)
{
field.SetValue(t, value);
}
}
list.Add(t);
}
}
}
}
return(list);
}
public async void ExportHopkinsData()
{
Status = "Exporting Johns Hopkins Data";
StorageFolder exportFolder = null;
if (StorageApplicationPermissions.FutureAccessList.ContainsItem("ExportFolder"))
{
exportFolder = await StorageApplicationPermissions.FutureAccessList.GetFolderAsync("ExportFolder");
}
else
{
var picker = new Windows.Storage.Pickers.FolderPicker();
picker.SuggestedStartLocation = Windows.Storage.Pickers.PickerLocationId.Desktop;
picker.FileTypeFilter.Add("*");
exportFolder = await picker.PickSingleFolderAsync();
if (exportFolder != null)
{
StorageApplicationPermissions.FutureAccessList.AddOrReplace("ExportFolder", exportFolder);
}
}
DateTime startDate = new DateTime(2020, 3, 1);
Dictionary <string, List <CalculatedValue> > listOfFiles = null;
listOfFiles = ProcessedJhStateData?.FirstOrDefault()?.OutputFiles;
if (exportFolder == null || listOfFiles == null)
{
return;
}
foreach (KeyValuePair <string, List <CalculatedValue> > kvp in listOfFiles)
{
DateTime currentDate = startDate;
DateTime latestDate = listOfFiles.Values.FirstOrDefault().Max(cv => cv.Date);
StorageFile csvFile = await exportFolder?.CreateFileAsync(kvp.Key + ".csv", Windows.Storage.CreationCollisionOption.ReplaceExisting);
using (CsvFileWriter dataWriter = new CsvFileWriter(await csvFile.OpenStreamForWriteAsync()))
{
CsvRow headerRow = new CsvRow();
headerRow.Add("Date");
foreach (ProcessedJhState ps in ProcessedJhStateData)
{
headerRow.Add(ps.CoreStateData.State.Code.ToString());
}
dataWriter.WriteRow(headerRow);
while (currentDate.Date <= latestDate)
{
CsvRow nextRow = new CsvRow();
nextRow.Add(currentDate.Date.ToString("MM/dd/yyyy", CultureInfo.InvariantCulture));
foreach (ProcessedJhState ps in ProcessedJhStateData)
{
var calcVals = ps.OutputFiles[kvp.Key].FirstOrDefault(calcv => calcv.Date.Date == currentDate.Date);
if (calcVals == null)
{
nextRow.Add("0");
}
else
{
nextRow.Add(calcVals.Value.ToString("F3", CultureInfo.InvariantCulture));
}
}
dataWriter.WriteRow(nextRow);
currentDate = currentDate + new TimeSpan(1, 0, 0, 0);
}
}
}
Status = "Done with JH Data";
}
public static void OnLoad(List <CsvRow> rows)
{
for (int i = 3; i < rows.Count; i++)
{
CsvRow r = rows[i];
if (string.IsNullOrEmpty(r.LineText))
{
continue;
}
aiconfig e = new aiconfig();
if (r.Count > 0)
{
e.id = CsvHelper.Toint(r[0]);
}
if (r.Count > 1)
{
e.allfrienddis = CsvHelper.Toint(r[1]);
}
if (r.Count > 2)
{
e.allenemydis = CsvHelper.Toint(r[2]);
}
if (r.Count > 3)
{
e.nearfrienddis = CsvHelper.Toint(r[3]);
}
if (r.Count > 4)
{
e.nearenemydis = CsvHelper.Toint(r[4]);
}
if (r.Count > 5)
{
e.movevalue = CsvHelper.Toint(r[5]);
}
if (r.Count > 6)
{
e.melee = CsvHelper.Toint(r[6]);
}
if (r.Count > 7)
{
e.defensevalue = CsvHelper.Toint(r[7]);
}
if (r.Count > 8)
{
e.defeat = CsvHelper.Toint(r[8]);
}
if (r.Count > 9)
{
e.attackvalue = CsvHelper.Toint(r[9]);
}
if (r.Count > 10)
{
e.noback = CsvHelper.Toint(r[10]);
}
if (r.Count > 11)
{
e.damage = CsvHelper.Toint(r[11]);
}
if (r.Count > 12)
{
e.heal = CsvHelper.Toint(r[12]);
}
if (r.Count > 13)
{
e.plusvalue = CsvHelper.Toint(r[13]);
}
if (r.Count > 14)
{
e.healvalue = CsvHelper.Toint(r[14]);
}
if (r.Count > 15)
{
e.clean = CsvHelper.Toint(r[15]);
}
if (r.Count > 16)
{
e.cleanvalue = CsvHelper.Toint(r[16]);
}
if (r.Count > 17)
{
e.dispel = CsvHelper.Toint(r[17]);
}
if (r.Count > 18)
{
e.dispelvalue = CsvHelper.Toint(r[18]);
}
if (r.Count > 19)
{
e.reborn = CsvHelper.Toint(r[19]);
}
if (r.Count > 20)
{
e.addbuff = CsvHelper.Toint(r[20]);
}
if (r.Count > 21)
{
e.defenserange = CsvHelper.Toint(r[21]);
}
if (r.Count > 22)
{
e.enemyHP_per = CsvHelper.Toint(r[22]);
}
if (r.Count > 23)
{
e.param_back = CsvHelper.Toint(r[23]);
}
if (r.Count > 24)
{
e.param_side = CsvHelper.Toint(r[24]);
}
if (r.Count > 25)
{
e.nearfrienddis_zero = CsvHelper.Toint(r[25]);
}
if (r.Count > 26)
{
e.fury_add = CsvHelper.Toint(r[26]);
}
if (r.Count > 27)
{
e.fury_add_full = CsvHelper.Toint(r[27]);
}
if (r.Count > 28)
{
e.enemyMov = CsvHelper.Toint(r[28]);
}
if (r.Count > 29)
{
e.harm_unit_distent = CsvHelper.Toint(r[29]);
}
if (r.Count > 30)
{
e.harm_unit_atk = CsvHelper.Toint(r[30]);
}
if (r.Count > 31)
{
e.unharm_unit_distent = CsvHelper.Toint(r[31]);
}
if (r.Count > 32)
{
e.unharm_unit_atk = CsvHelper.Toint(r[32]);
}
if (r.Count > 33)
{
e.enemySpeed = CsvHelper.Toint(r[33]);
}
dic[e.id] = e;
}
}
public void AddChild(CsvRow childRow)
{
Children.Add(childRow);
}
/// <summary>
/// Initializes a new instance of the <see cref="TutorialData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public TutorialData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// TutorialNpcData.
}
//public static ANetApiResponse Run(String ApiLoginID, String ApiTransactionKey, Decimal Amount)
//{
// Console.WriteLine("Create Android Pay Transaction Sample");
// ApiOperationBase<ANetApiRequest, ANetApiResponse>.RunEnvironment = AuthorizeNET.Environment.SANDBOX;
// // define the merchant information (authentication / transaction id)
// ApiOperationBase<ANetApiRequest, ANetApiResponse>.MerchantAuthentication = new merchantAuthenticationType()
// {
// name = ApiLoginID,
// ItemElementName = ItemChoiceType.transactionKey,
// Item = ApiTransactionKey,
// };
// //set up data based on transaction
// var opaqueData = new opaqueDataType { dataDescriptor = "COMMON.ANDROID.INAPP.PAYMENT", dataValue = "eyJkYXRhIjoiQkRQTldTdE1tR2V3UVVXR2c0bzdFXC9qKzFjcTFUNzhxeVU4NGI2N2l0amNZSTh3UFlBT2hzaGpoWlBycWRVcjRYd1BNYmo0emNHTWR5KysxSDJWa1BPWStCT01GMjV1YjE5Y1g0bkN2a1hVVU9UakRsbEIxVGdTcjhKSFp4Z3A5ckNnc1NVZ2JCZ0tmNjBYS3V0WGY2YWpcL284WkliS25yS1E4U2gwb3VMQUtsb1VNbit2UHU0K0E3V0tycXJhdXo5SnZPUXA2dmhJcStIS2pVY1VOQ0lUUHlGaG1PRXRxK0grdzB2UmExQ0U2V2hGQk5uQ0hxenpXS2NrQlwvMG5xTFpSVFliRjBwK3Z5QmlWYVdIZWdoRVJmSHhSdGJ6cGVjelJQUHVGc2ZwSFZzNDhvUExDXC9rXC8xTU5kNDdrelwvcEhEY1JcL0R5NmFVTStsTmZvaWx5XC9RSk4rdFMzbTBIZk90SVNBUHFPbVhlbXZyNnhKQ2pDWmxDdXcwQzltWHpcL29iSHBvZnVJRVM4cjljcUdHc1VBUERwdzdnNjQybTRQendLRitIQnVZVW5lV0RCTlNEMnU2amJBRzMiLCJ2ZXJzaW9uIjoiRUNfdjEiLCJoZWFkZXIiOnsiYXBwbGljYXRpb25EYXRhIjoiOTRlZTA1OTMzNWU1ODdlNTAxY2M0YmY5MDYxM2UwODE0ZjAwYTdiMDhiYzdjNjQ4ZmQ4NjVhMmFmNmEyMmNjMiIsInRyYW5zYWN0aW9uSWQiOiJjMWNhZjVhZTcyZjAwMzlhODJiYWQ5MmI4MjgzNjM3MzRmODViZjJmOWNhZGYxOTNkMWJhZDlkZGNiNjBhNzk1IiwiZXBoZW1lcmFsUHVibGljS2V5IjoiTUlJQlN6Q0NBUU1HQnlxR1NNNDlBZ0V3Z2ZjQ0FRRXdMQVlIS29aSXpqMEJBUUloQVBcL1wvXC9cLzhBQUFBQkFBQUFBQUFBQUFBQUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL01Gc0VJUFwvXC9cL1wvOEFBQUFCQUFBQUFBQUFBQUFBQUFBQVwvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cLzhCQ0JheGpYWXFqcVQ1N1BydlZWMm1JYThaUjBHc014VHNQWTd6ancrSjlKZ1N3TVZBTVNkTmdpRzV3U1RhbVo0NFJPZEpyZUJuMzZRQkVFRWF4ZlI4dUVzUWtmNHZPYmxZNlJBOG5jRGZZRXQ2ek9nOUtFNVJkaVl3cFpQNDBMaVwvaHBcL200N242MHA4RDU0V0s4NHpWMnN4WHM3THRrQm9ONzlSOVFJaEFQXC9cL1wvXC84QUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cLys4NXZxdHB4ZWVoUE81eXNMOFl5VlJBZ0VCQTBJQUJHbStnc2wwUFpGVFwva0RkVVNreHd5Zm84SnB3VFFRekJtOWxKSm5tVGw0REdVdkFENEdzZUdqXC9wc2hCWjBLM1RldXFEdFwvdERMYkUrOFwvbTB5Q21veHc9IiwicHVibGljS2V5SGFzaCI6IlwvYmI5Q05DMzZ1QmhlSEZQYm1vaEI3T28xT3NYMkora0pxdjQ4ek9WVmlRPSJ9LCJzaWduYXR1cmUiOiJNSUlEUWdZSktvWklodmNOQVFjQ29JSURNekNDQXk4Q0FRRXhDekFKQmdVckRnTUNHZ1VBTUFzR0NTcUdTSWIzRFFFSEFhQ0NBaXN3Z2dJbk1JSUJsS0FEQWdFQ0FoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQXdKekVsTUNNR0ExVUVBeDRjQUdNQWFBQnRBR0VBYVFCQUFIWUFhUUJ6QUdFQUxnQmpBRzhBYlRBZUZ3MHhOREF4TURFd05qQXdNREJhRncweU5EQXhNREV3TmpBd01EQmFNQ2N4SlRBakJnTlZCQU1lSEFCakFHZ0FiUUJoQUdrQVFBQjJBR2tBY3dCaEFDNEFZd0J2QUcwd2daOHdEUVlKS29aSWh2Y05BUUVCQlFBRGdZMEFNSUdKQW9HQkFOQzgra2d0Z212V0YxT3pqZ0ROcmpURUJSdW9cLzVNS3ZsTTE0NnBBZjdHeDQxYmxFOXc0ZklYSkFEN0ZmTzdRS2pJWFlOdDM5ckx5eTd4RHdiXC81SWtaTTYwVFoyaUkxcGo1NVVjOGZkNGZ6T3BrM2Z0WmFRR1hOTFlwdEcxZDlWN0lTODJPdXA5TU1vMUJQVnJYVFBITmNzTTk5RVBVblBxZGJlR2M4N20wckFnTUJBQUdqWERCYU1GZ0dBMVVkQVFSUk1FK0FFSFpXUHJXdEpkN1laNDMxaENnN1lGU2hLVEFuTVNVd0l3WURWUVFESGh3QVl3Qm9BRzBBWVFCcEFFQUFkZ0JwQUhNQVlRQXVBR01BYndCdGdoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQURnWUVBYlVLWUNrdUlLUzlRUTJtRmNNWVJFSW0ybCtYZzhcL0pYditHQlZRSmtPS29zY1k0aU5ERkFcL2JRbG9nZjlMTFU4NFRId05SbnN2VjNQcnY3UlRZODFncTBkdEM4elljQWFBa0NISUkzeXFNbko0QU91NkVPVzlrSmsyMzJnU0U3V2xDdEhiZkxTS2Z1U2dRWDhLWFFZdVpMazJScjYzTjhBcFhzWHdCTDNjSjB4Z2VBd2dkMENBUUV3T3pBbk1TVXdJd1lEVlFRREhod0FZd0JvQUcwQVlRQnBBRUFBZGdCcEFITUFZUUF1QUdNQWJ3QnRBaEJjbCtQZjMrVTRwazEzblZEOW53UVFNQWtHQlNzT0F3SWFCUUF3RFFZSktvWklodmNOQVFFQkJRQUVnWUJhSzNFbE9zdGJIOFdvb3NlREFCZitKZ1wvMTI5SmNJYXdtN2M2VnhuN1phc05iQXEzdEF0OFB0eSt1UUNnc3NYcVprTEE3a3oyR3pNb2xOdHY5d1ltdTlVandhcjFQSFlTK0JcL29Hbm96NTkxd2phZ1hXUnowbk1vNXkzTzFLelgwZDhDUkhBVmE4OFNyVjFhNUpJaVJldjNvU3RJcXd2NXh1WmxkYWc2VHI4dz09In0=" };
// //standard api call to retrieve response
// var paymentType = new paymentType { Item = opaqueData };
// var transactionRequest = new transactionRequestType
// {
// transactionType = transactionTypeEnum.authCaptureTransaction.ToString(), // authorize and capture transaction
// amount = Amount,
// payment = paymentType
// };
// var request = new createTransactionRequest { transactionRequest = transactionRequest };
// // instantiate the contoller that will call the service
// var controller = new createTransactionController(request);
// controller.Execute();
// // get the response from the service (errors contained if any)
// var response = controller.GetApiResponse();
// //validate
// if (response != null)
// {
// if (response.messages.resultCode == messageTypeEnum.Ok)
// {
// if(response.transactionResponse.messages != null)
// {
// Console.WriteLine("Successfully created an Android pay transaction with Transaction ID: " + response.transactionResponse.transId);
// Console.WriteLine("Response Code: " + response.transactionResponse.responseCode);
// Console.WriteLine("Message Code: " + response.transactionResponse.messages[0].code);
// Console.WriteLine("Description: " + response.transactionResponse.messages[0].description);
// }
// else
// {
// Console.WriteLine("Failed Transaction.");
// if (response.transactionResponse.errors != null)
// {
// Console.WriteLine("Error Code: " + response.transactionResponse.errors[0].errorCode);
// Console.WriteLine("Error message: " + response.transactionResponse.errors[0].errorText);
// }
// }
// }
// else
// {
// Console.WriteLine("Failed Transaction.");
// if (response.transactionResponse != null && response.transactionResponse.errors != null)
// {
// Console.WriteLine("Error Code: " + response.transactionResponse.errors[0].errorCode);
// Console.WriteLine("Error message: " + response.transactionResponse.errors[0].errorText);
// }
// else
// {
// Console.WriteLine("Error Code: " + response.messages.message[0].code);
// Console.WriteLine("Error message: " + response.messages.message[0].text);
// }
// }
// }
// else
// {
// Console.WriteLine("Null Response.");
// }
// return response;
//}
public static void CreateAnAndroidPayTransactionExec(String ApiLoginID, String ApiTransactionKey)
{
using (CsvReader csv = new CsvReader(new StreamReader(new FileStream(@"../../../CSV_DATA/CreateAnAndroidPayTransaction.csv", FileMode.Open)), true))
{
Console.WriteLine("Create Android Pay Transaction Sample");
int flag = 0;
int fieldCount = csv.FieldCount;
string[] headers = csv.GetFieldHeaders();
//Append Data
var item1 = DataAppend.ReadPrevData();
using (CsvFileWriter writer = new CsvFileWriter(new FileStream(@"../../../CSV_DATA/Outputfile.csv", FileMode.Open)))
{
while (csv.ReadNextRecord())
{
// Create Instance of Customer Api
ApiOperationBase <ANetApiRequest, ANetApiResponse> .RunEnvironment = AuthorizeNET.Environment.SANDBOX;
// define the merchant information (authentication / transaction id)
ApiOperationBase <ANetApiRequest, ANetApiResponse> .MerchantAuthentication = new merchantAuthenticationType()
{
name = ApiLoginID,
ItemElementName = ItemChoiceType.transactionKey,
Item = ApiTransactionKey,
};
string amount = null;
string TestCaseId = null;
for (int i = 0; i < fieldCount; i++)
{
switch (headers[i])
{
case "amount":
amount = csv[i];
break;
case "TestCaseId":
TestCaseId = csv[i];
break;
default:
break;
}
}
//Write to output file
CsvRow row = new CsvRow();
try
{
if (flag == 0)
{
row.Add("TestCaseId");
row.Add("APIName");
row.Add("Status");
row.Add("TimeStamp");
writer.WriteRow(row);
flag = flag + 1;
//Append Data
foreach (var item in item1)
{
writer.WriteRow(item);
}
}
//var opaqueData = new opaqueDataType { dataDescriptor = "COMMON.ANDROID.INAPP.PAYMENT", dataValue = "eyJkYXRhIjoiQkRQTldTdE1tR2V3UVVXR2c0bzdFXC9qKzFjcTFUNzhxeVU4NGI2N2l0amNZSTh3UFlBT2hzaGpoWlBycWRVcjRYd1BNYmo0emNHTWR5KysxSDJWa1BPWStCT01GMjV1YjE5Y1g0bkN2a1hVVU9UakRsbEIxVGdTcjhKSFp4Z3A5ckNnc1NVZ2JCZ0tmNjBYS3V0WGY2YWpcL284WkliS25yS1E4U2gwb3VMQUtsb1VNbit2UHU0K0E3V0tycXJhdXo5SnZPUXA2dmhJcStIS2pVY1VOQ0lUUHlGaG1PRXRxK0grdzB2UmExQ0U2V2hGQk5uQ0hxenpXS2NrQlwvMG5xTFpSVFliRjBwK3Z5QmlWYVdIZWdoRVJmSHhSdGJ6cGVjelJQUHVGc2ZwSFZzNDhvUExDXC9rXC8xTU5kNDdrelwvcEhEY1JcL0R5NmFVTStsTmZvaWx5XC9RSk4rdFMzbTBIZk90SVNBUHFPbVhlbXZyNnhKQ2pDWmxDdXcwQzltWHpcL29iSHBvZnVJRVM4cjljcUdHc1VBUERwdzdnNjQybTRQendLRitIQnVZVW5lV0RCTlNEMnU2amJBRzMiLCJ2ZXJzaW9uIjoiRUNfdjEiLCJoZWFkZXIiOnsiYXBwbGljYXRpb25EYXRhIjoiOTRlZTA1OTMzNWU1ODdlNTAxY2M0YmY5MDYxM2UwODE0ZjAwYTdiMDhiYzdjNjQ4ZmQ4NjVhMmFmNmEyMmNjMiIsInRyYW5zYWN0aW9uSWQiOiJjMWNhZjVhZTcyZjAwMzlhODJiYWQ5MmI4MjgzNjM3MzRmODViZjJmOWNhZGYxOTNkMWJhZDlkZGNiNjBhNzk1IiwiZXBoZW1lcmFsUHVibGljS2V5IjoiTUlJQlN6Q0NBUU1HQnlxR1NNNDlBZ0V3Z2ZjQ0FRRXdMQVlIS29aSXpqMEJBUUloQVBcL1wvXC9cLzhBQUFBQkFBQUFBQUFBQUFBQUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL01Gc0VJUFwvXC9cL1wvOEFBQUFCQUFBQUFBQUFBQUFBQUFBQVwvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cLzhCQ0JheGpYWXFqcVQ1N1BydlZWMm1JYThaUjBHc014VHNQWTd6ancrSjlKZ1N3TVZBTVNkTmdpRzV3U1RhbVo0NFJPZEpyZUJuMzZRQkVFRWF4ZlI4dUVzUWtmNHZPYmxZNlJBOG5jRGZZRXQ2ek9nOUtFNVJkaVl3cFpQNDBMaVwvaHBcL200N242MHA4RDU0V0s4NHpWMnN4WHM3THRrQm9ONzlSOVFJaEFQXC9cL1wvXC84QUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cLys4NXZxdHB4ZWVoUE81eXNMOFl5VlJBZ0VCQTBJQUJHbStnc2wwUFpGVFwva0RkVVNreHd5Zm84SnB3VFFRekJtOWxKSm5tVGw0REdVdkFENEdzZUdqXC9wc2hCWjBLM1RldXFEdFwvdERMYkUrOFwvbTB5Q21veHc9IiwicHVibGljS2V5SGFzaCI6IlwvYmI5Q05DMzZ1QmhlSEZQYm1vaEI3T28xT3NYMkora0pxdjQ4ek9WVmlRPSJ9LCJzaWduYXR1cmUiOiJNSUlEUWdZSktvWklodmNOQVFjQ29JSURNekNDQXk4Q0FRRXhDekFKQmdVckRnTUNHZ1VBTUFzR0NTcUdTSWIzRFFFSEFhQ0NBaXN3Z2dJbk1JSUJsS0FEQWdFQ0FoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQXdKekVsTUNNR0ExVUVBeDRjQUdNQWFBQnRBR0VBYVFCQUFIWUFhUUJ6QUdFQUxnQmpBRzhBYlRBZUZ3MHhOREF4TURFd05qQXdNREJhRncweU5EQXhNREV3TmpBd01EQmFNQ2N4SlRBakJnTlZCQU1lSEFCakFHZ0FiUUJoQUdrQVFBQjJBR2tBY3dCaEFDNEFZd0J2QUcwd2daOHdEUVlKS29aSWh2Y05BUUVCQlFBRGdZMEFNSUdKQW9HQkFOQzgra2d0Z212V0YxT3pqZ0ROcmpURUJSdW9cLzVNS3ZsTTE0NnBBZjdHeDQxYmxFOXc0ZklYSkFEN0ZmTzdRS2pJWFlOdDM5ckx5eTd4RHdiXC81SWtaTTYwVFoyaUkxcGo1NVVjOGZkNGZ6T3BrM2Z0WmFRR1hOTFlwdEcxZDlWN0lTODJPdXA5TU1vMUJQVnJYVFBITmNzTTk5RVBVblBxZGJlR2M4N20wckFnTUJBQUdqWERCYU1GZ0dBMVVkQVFSUk1FK0FFSFpXUHJXdEpkN1laNDMxaENnN1lGU2hLVEFuTVNVd0l3WURWUVFESGh3QVl3Qm9BRzBBWVFCcEFFQUFkZ0JwQUhNQVlRQXVBR01BYndCdGdoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQURnWUVBYlVLWUNrdUlLUzlRUTJtRmNNWVJFSW0ybCtYZzhcL0pYditHQlZRSmtPS29zY1k0aU5ERkFcL2JRbG9nZjlMTFU4NFRId05SbnN2VjNQcnY3UlRZODFncTBkdEM4elljQWFBa0NISUkzeXFNbko0QU91NkVPVzlrSmsyMzJnU0U3V2xDdEhiZkxTS2Z1U2dRWDhLWFFZdVpMazJScjYzTjhBcFhzWHdCTDNjSjB4Z2VBd2dkMENBUUV3T3pBbk1TVXdJd1lEVlFRREhod0FZd0JvQUcwQVlRQnBBRUFBZGdCcEFITUFZUUF1QUdNQWJ3QnRBaEJjbCtQZjMrVTRwazEzblZEOW53UVFNQWtHQlNzT0F3SWFCUUF3RFFZSktvWklodmNOQVFFQkJRQUVnWUJhSzNFbE9zdGJIOFdvb3NlREFCZitKZ1wvMTI5SmNJYXdtN2M2VnhuN1phc05iQXEzdEF0OFB0eSt1UUNnc3NYcVprTEE3a3oyR3pNb2xOdHY5d1ltdTlVandhcjFQSFlTK0JcL29Hbm96NTkxd2phZ1hXUnowbk1vNXkzTzFLelgwZDhDUkhBVmE4OFNyVjFhNUpJaVJldjNvU3RJcXd2NXh1WmxkYWc2VHI4dz09In0=" };
var opaqueData = new opaqueDataType {
dataDescriptor = "COMMON.ANDROID.INAPP.PAYMENT", dataValue = "ewoJInB1YmxpY0tleUhhc2giICAgIDogIlNiMHFVc0tpN1UwWjMrRm1Ed2xsa205UlVEUHZhY1BDVlVUdlk3OFVwWVk9IiwKCSJ2ZXJzaW9uIjogIjEuMCIsCgkiZGF0YSIgOiAiZXdvSkltVnVZM0o1Y0hSbFpFMWxjM05oWjJVaU9pQWllVzVCZGxob1ZVODJPVEpQY0drekwxRm5aVGRhVDB4a04yVXZTMGRNVEhOdFRUaGxlR1JDVFdob1pHZFdSMjVOS3pGNGF5OUNZMkZFVFVkWFdqaGFTVWRIVTBOQlQwNXJaelpZTTB0SmFtRjFjbVpLUmpJcmFrMHdRelp2V0d0RlNqZGlXa1J4ZUhRMldXUjViVWszZEhnMk4yNTJTa3czTm5ndmFYb3JjVzR2TUhWNFIyZEJZVmw1YzNCUVdWQkZhRTVHYkZkUVYxVmxiVEV3VlZKd1NqRTVkVVJwWmtaTFVqTmFTemRNVDA4M1ZYQTRlRkF4VnpodlFWWlVOV05hV1d0MFNIWmtkMjAwUm1SV05VTmFjV0ZXZDNKcU0wcG5kRUZyTnlJc0Nna2laWEJvWlcxbGNtRnNVSFZpYkdsalMyVjVJam9nSWsxR2EzZEZkMWxJUzI5YVNYcHFNRU5CVVZsSlMyOWFTWHBxTUVSQlVXTkVVV2RCUld0V2JGQklTeXREVFdJNE5TOXhSVFY2YW1kaGNYRTFlSGgyYTBzMVdERm5WV3BQU0RKSmJrTkZWamhCUzI5TlNFbFZaamxwUkZveVFWTXhTVEZZWkhZMlEzWktOa0kyTkVoUE1UbEJhRGx6T1doSFpYQlJQVDBpTEFvSkluUmhaeUk2SUNKM1RrMW1PVzFvWVdGb1IydDFWVGdyZG5CclN6UnBVa0o1YWtWaUwzUnNla3BLYVc5RVVGRjNNMVZCUFNJS2ZRPT0iCn0="
};
var paymentType = new paymentType {
Item = opaqueData
};
var transactionRequest = new transactionRequestType
{
transactionType = transactionTypeEnum.authCaptureTransaction.ToString(), // authorize and capture transaction
amount = Convert.ToDecimal(amount),
payment = paymentType
};
var request = new createTransactionRequest {
transactionRequest = transactionRequest
};
var controller = new createTransactionController(request);
controller.Execute();
var response = controller.GetApiResponse();
if (response != null && response.messages.resultCode == messageTypeEnum.Ok &&
response.transactionResponse.messages != null)
{
try
{
//Assert.AreEqual(response.Id, customerProfileId);
Console.WriteLine("Assertion Succeed! Valid CustomerId fetched.");
CsvRow row1 = new CsvRow();
row1.Add("CAPT_00" + flag.ToString());
row1.Add("CreateAnAndroidPayTransaction");
row1.Add("Pass");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
// Console.WriteLine("Success " + TestcaseID + " CustomerID : " + response.Id);
flag = flag + 1;
Console.WriteLine("Successfully created an Android pay transaction with Transaction ID: " + response.transactionResponse.transId);
Console.WriteLine("Response Code: " + response.transactionResponse.responseCode);
Console.WriteLine("Message Code: " + response.transactionResponse.messages[0].code);
Console.WriteLine("Description: " + response.transactionResponse.messages[0].description);
}
catch
{
CsvRow row1 = new CsvRow();
row1.Add("CAPT_00" + flag.ToString());
row1.Add("CreateAnAndroidPayTransaction");
row1.Add("Assertion Failed!");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
Console.WriteLine("Assertion Failed! Invalid CustomerId fetched.");
flag = flag + 1;
}
}
else
{
CsvRow row1 = new CsvRow();
row1.Add("CAPT_00" + flag.ToString());
row1.Add("CreateAnAndroidPayTransaction");
row1.Add("Fail");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
//Console.WriteLine("Assertion Failed! Invalid CustomerId fetched.");
flag = flag + 1;
}
}
catch (Exception e)
{
CsvRow row2 = new CsvRow();
row2.Add("CAPT_00" + flag.ToString());
row2.Add("CreateAnAndroidPayTransaction");
row2.Add("Fail");
row2.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row2);
flag = flag + 1;
Console.WriteLine(TestCaseId + " Error Message " + e.Message);
}
}
}
}
}
/// <summary>
/// adds a record to the pricelistings of this station
/// </summary>
/// <param name="CSV_String"></param>
public void addListing(CsvRow Csv_Row, ref Dictionary <string, Int32> foundCommodityCache)
{
SQL.Datasets.dsEliteDB.tbcommoditylocalizationRow[] CommodityRow;
Int32 CommodityID = 0;
Boolean known = false;
try
{
if (foundCommodityCache != null)
{
if (!foundCommodityCache.TryGetValue(Csv_Row.CommodityName, out CommodityID))
{
CommodityRow = (SQL.Datasets.dsEliteDB.tbcommoditylocalizationRow[])Program.Data.BaseData.tbcommoditylocalization.Select(
String.Format("locname = '{0}'", SQL.DBConnector.DTEscape(Csv_Row.CommodityName)));
if (CommodityRow.GetUpperBound(0) >= 0)
{
CommodityID = (Int32)CommodityRow[0].commodity_id;
foundCommodityCache.Add(Csv_Row.CommodityName, CommodityID);
known = true;
}
}
else
{
known = true;
}
}
else
{
CommodityRow = (SQL.Datasets.dsEliteDB.tbcommoditylocalizationRow[])Program.Data.BaseData.tbcommoditylocalization.Select(
String.Format("locname = '{0}'", SQL.DBConnector.DTEscape(Csv_Row.CommodityName)));
if (CommodityRow.GetUpperBound(0) >= 0)
{
CommodityID = (Int32)CommodityRow[0].commodity_id;
known = true;
}
}
if (known)
{
ListingExtendMode = true;
Listing newListing = new Listing();
newListing.StationId = this.Id;
newListing.CommodityId = CommodityID;
newListing.Supply = (Int32)Csv_Row.Supply;
newListing.SupplyLevel = Csv_Row.SupplyLevel.Trim() == "" ? null : Csv_Row.SupplyLevel;
newListing.BuyPrice = (Int32)Csv_Row.BuyPrice;
newListing.SellPrice = (Int32)Csv_Row.SellPrice;
newListing.Demand = (Int32)Csv_Row.Demand;
newListing.DemandLevel = Csv_Row.DemandLevel.Trim() == "" ? null : Csv_Row.DemandLevel;
newListing.CollectedAt = new System.DateTimeOffset(Csv_Row.SampleDate).ToUnixTimeSeconds();
newListing.DataSource = Csv_Row.DataSource;
newListing.UpdateCount = -1;
Listings[currentIndex + 1] = newListing;
currentIndex++;
}
}
catch (Exception ex)
{
throw new Exception("Error while adding a record to the pricelistings", ex);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="AreaEffectObjectData" /> class.
/// </summary>
/// <param name="CsvRow">The row.</param>
/// <param name="CsvTable">The data table.</param>
public AreaEffectObjectData(CsvRow CsvRow, CsvTable CsvTable) : base(CsvRow, CsvTable)
{
// AreaEffectObjectData.
}
