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. }