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); }
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(); } }
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); }
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; }
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 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)); }
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 void writePlayers(List<Player> listPlayers) { using (CsvFileWriter writer = new CsvFileWriter(file)) { foreach (var item in listPlayers) { CsvRow row = new CsvRow(); row.Add(item.Name); for (int i = 0; i < Constants.RaceNumber; i++) { row.Add(item.Races[i].ToString()); row.Add(item.Victory[i].ToString()); row.Add(item.Defeat[i].ToString()); row.Add(item.Elo[i].ToString()); } writer.WriteRow(row); } } }
void WriteBody(CsvFileWriter writer) { List<EventPoint> eps = _eventPoints.EventPoints; Dictionary<String, List<DateTimeDoublePair>> indicators = _indicators.GetIndicators(_targetDate); for (int i = 0; i < eps.Count; i = i + 2) { EventPoint ep = eps[i]; CsvRow row = new CsvRow(); row.Add(ep.DateTimeFrom.ToString("yyyy-MM-dd HH:mm:ss.fff")); row.Add(ep.RangeMax.ToString("n")); foreach (List<DateTimeDoublePair> pair in indicators.Values.ToList()) { row.Add(pair[i].DoubleValue.ToString("n")); Trace.Assert(pair[i].DateTimeValue == ep.DateTimeFrom); } writer.WriteRow(row); } }
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); }
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); } }
/// <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; // 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); }
private void mainBackgroundWorker_DoWork(object sender, DoWorkEventArgs e) { #region Initialization BibDetector.Cleanup(); ProgressReport.Directory = baseDirectory; ProgressReport.UseSubdirs = includeSubdirsCheckbox.Checked; ProgressReport.DataFile = dataFilePath; ProgressReport.Operation = CurrentOperation.Start; ProgressReport.Operation = CurrentOperation.ListingAllPhotos; ProgressReport.TotalPhotos = -1; List <string> files = filesInDirectory(baseDirectory); ProgressReport.TotalPhotos = files.Count; ProgressReport.Operation = CurrentOperation.PhotoListingDone; ProgressReport.Operation = CurrentOperation.ReadingParticipantsData; ProgressReport.TotalParticipants = -1; List <CsvRow> data = CsvManager.ReadAllWithoutHeader(dataFilePath); ProgressReport.TotalParticipants = data.Count; ProgressReport.Operation = CurrentOperation.ParticipantsDataReadingDone; ProgressReport.Operation = CurrentOperation.ProcessingParticipantsBibs; List <string> participantsBibs = new List <string>(); foreach (var part in data) { if (mainBackgroundWorker.CancellationPending) { e.Cancel = true; break; } participantsBibs.Add(part.Columns[bibColumnIndex]); } ProgressReport.Operation = CurrentOperation.ProcessingParticipantsBibsDone; List <CsvRow> report = new List <CsvRow>(); List <TaggableFace> processedFaces = new List <TaggableFace>(); TaggableResult tagResult = new TaggableResult(baseDirectory); if (useSavedProgressCheckbox.Checked) { ProgressReport.Operation = CurrentOperation.ReadingSavedProgress; var savedData = readSavedProgress(); report = savedData.Item1; tagResult = savedData.Item2; } ProgressReport.Configuration = _params; #endregion #region First step procession: detecting bibs if (ProgressReport.Configuration.DetectionSteps == DetectionSteps.DetectionAndRecognition || ProgressReport.Configuration.DetectionSteps == DetectionSteps.Both) { ProgressReport.Operation = CurrentOperation.ProcessingPhotos; for (int i = 0; i < files.Count; i++) { if (mainBackgroundWorker.CancellationPending) { e.Cancel = true; break; } var photo = files[i]; if (tagResult.PhotoExists(photo)) { continue; } ProgressReport.CurrentPhoto = Path.GetFileName(photo); ProgressReport.CurrentPhotoIndex = i; if (i != 0) { Thread.Sleep(_params.Delay); } TaggableImage tagImage = new TaggableImage(baseDirectory, photo); var faces = BibDetector.GetPossibleBibs(photo, _params.FaceRecognition, _params.BibArea, _params.DigitsRecognition, baseDirectory); if (faces == null) { LogManager.Error("Force break and cancellation of bib procession."); break; } else { processedFaces.AddRange(faces); } CsvRow row = new CsvRow(); row.Add(photo); int actualBibs = 0; int totalNum = 0; int resolvedFaces = 0; foreach (var face in faces) { List <string> nums = new List <string>(); bool faceResolved = false; foreach (var num in face.NumericBibs) { totalNum++; if (participantsBibs.Contains(num)) { faceResolved = true; ProgressReport.DetectedBibs++; actualBibs++; nums.Add(num); } } if (faceResolved) { row.Add(nums.ToArray()); string tag = nums.First(); tagImage.AddFace(face.FaceId, tag, face.DetectedBibs); resolvedFaces++; } else { tagImage.AddFace(face.FaceId, face.DetectedBibs); } } //recognized numbers - RN //existing numbers - EN //detected faces - DF //resolved faces - RF string logMsg = string.Format("RN: {0}; EN: {1}; DF: {2}; RF: {3}", totalNum, actualBibs, faces.Length, resolvedFaces); if (actualBibs == 0) { ProgressReport.UnresolvedImages++; row.Add("UNRESOLVED"); } else { ProgressReport.ResolvedImages++; } LogManager.Info(logMsg); report.Add(row); CsvManager.SaveCsv(report, saveReportPath); tagResult.AddImage(tagImage); tagResult.Save(saveDataPath); ProgressReport.CurrentPhotoIndex = i + 1; //TODO: iteration cleanup //BibDetector.IterationCleanup(); } } #endregion #region Second step procession: train faces if (ProgressReport.Configuration.DetectionSteps == DetectionSteps.FacialUnresolved || ProgressReport.Configuration.DetectionSteps == DetectionSteps.Both) { tagResult = readSavedProgress().Item2; ProgressReport.Operation = CurrentOperation.TrainingFaces; Dictionary <string, string> idsAndTags = new Dictionary <string, string>(); for (int i = 0; i < tagResult.Images.Count; i++) { //TODO: set current photo index var image = tagResult.Images[i]; for (int j = 0; j < image.Data.Count; j++) { if (mainBackgroundWorker.CancellationPending) { e.Cancel = true; break; } var face = image.Data[j]; if (face.Resolved) { idsAndTags.Add(face.FaceId, face.ResolvedBib); } } } //train resolved faces LogManager.Info("Starting training resolved faces: " + idsAndTags.Count); //BibDetector.StudyFaces(idsAndTags, ProgressReport.Configuration.Delay); ProgressReport.Operation = CurrentOperation.SearchingUnresolvedFaces; for (int i = 0; i < tagResult.Images.Count; i++) { //TODO: set current photo index var image = tagResult.Images[i]; for (int j = 0; j < image.Data.Count; j++) { var face = image.Data[j]; if (!face.Resolved) { Thread.Sleep(ProgressReport.Configuration.Delay); //search unresolved photo List <FaceSearchModel> samePeople = BibDetector.SearchFace(face.FaceId); if (samePeople != null && samePeople.Count > 0) { int bestIndex = 0; for (int k = bestIndex + 1; i < samePeople.Count; i++) { if (samePeople[i].Confidence > samePeople[bestIndex].Confidence) { bestIndex = i; } } FaceSearchModel bestMatch = samePeople[bestIndex]; face.Resolved = true; face.ResolvedBib = bestMatch.Tag; tagResult.Save(saveDataPath); LogManager.Info("Match \"" + face.FaceId + "\" with BIB \"" + face.ResolvedBib + "\""); } else { LogManager.Warning("No matches for \"" + face.FaceId + "\""); } } } } } #endregion //TODO: saving csv file after detecting each bib number to prevent cancelling and loosing results CsvManager.SaveCsv(report, saveReportPath); }
private void SaveCoordinates(string filename) { if (!Directory.Exists(Path.GetDirectoryName(filename))) Directory.CreateDirectory(Path.GetDirectoryName(filename)); //filename = string.Format(filename + Path.DirectorySeparatorChar + // string.Format("sample{0}.csv", DateTime.Now.ToBinary())); CsvFileWriter writer = new CsvFileWriter(filename); for (int i = 0; i < winners.Count; i++) { CsvRow row = new CsvRow(); SOM.Neuron n = winners[i]; row.Add(n.X); row.Add(n.Y); if (labels[i].Contains("A")) { row.Add(1); } else if (labels[i].Contains("B")) { row.Add(2); } else if (labels[i].Contains("C")) { row.Add(3); } else if (labels[i].Contains("Neutral")) { row.Add(4); } writer.WriteRow(row); writer.Flush(); } writer.Close(); }
/// <summary> /// Writes the file that has the continuous data (CoP, CoM) to a file /// </summary> private void WriteContinuousFile() { // Write all entries in data list to file Directory.CreateDirectory(@"Data/" + pid); using (CsvFileWriter writer = new CsvFileWriter(@"Data/" + pid + "/ContinuousData" + pid + ".csv")) { Debug.Log("Writing continuous data to file"); // write header CsvRow header = new CsvRow(); header.Add("Participant ID"); header.Add("Global Time"); header.Add("CoP X"); header.Add("CoP Y"); header.Add("Current Color"); header.Add("CoM X"); header.Add("CoM Y"); header.Add("CoM Z"); header.Add("Target Number"); header.Add("Trial Number"); header.Add("CoP Velocity X"); header.Add("CoP Velocity Y"); writer.WriteRow(header); // write each line of data foreach (ContinuousData d in continuousData) { CsvRow row = new CsvRow(); row.Add(d.participantId); row.Add(d.time.ToString()); row.Add(d.CoPposition.x.ToString()); row.Add(d.CoPposition.y.ToString()); if (d.curColor == Target.posnIndicator.GREEN) { row.Add("GREEN"); } else if (d.curColor == Target.posnIndicator.YELLOW) { row.Add("YELLOW"); } else { row.Add("RED"); } row.Add(d.CoMposition.x.ToString()); row.Add(d.CoMposition.y.ToString()); row.Add(d.CoMposition.z.ToString()); row.Add(d.targetNum.ToString()); row.Add(d.trialNum.ToString()); row.Add(d.CoPVelocity.x.ToString()); row.Add(d.CoPVelocity.y.ToString()); writer.WriteRow(row); } } Task.OnRecordContinuousData -= recordContinuousTrial; }
private static void PerformAction(ref int intCurrState, char chrInputChar, ref StringBuilder strElem, ref CsvRow alParsedCsv) { string strTemp = null; switch (intCurrState) { case 0: //Seperate out value to array list strTemp = strElem.ToString(); alParsedCsv.Add(strTemp); strElem = new StringBuilder(); break; case 1: case 3: case 4: //accumulate the character strElem.Append(chrInputChar); break; case 5: //End of line reached. Seperate out value to array list strTemp = strElem.ToString(); alParsedCsv.Add(strTemp); break; case 6: //Erroneous input. Reject line. alParsedCsv.Clear(); break; case 7: //wipe ending " and Seperate out value to array list strElem.Remove(strElem.Length - 1, 1); strTemp = strElem.ToString(); alParsedCsv.Add(strTemp); strElem = new StringBuilder(); intCurrState = 5; break; case 8: //wipe ending " and Seperate out value to array list strElem.Remove(strElem.Length - 1, 1); strTemp = strElem.ToString(); alParsedCsv.Add(strTemp); strElem = new StringBuilder(); //goto state 0 intCurrState = 0; break; } }
private static void WriteGeoLocationNames() { if (locationNames_Filename != null) { using (CsvFileWriter writer = new CsvFileWriter(locationNames_Filename)) { foreach (string key in MapTools.locationNames.Keys) { string name = MapTools.locationNames[key]; CsvRow row = new CsvRow(); // row.Add(trip.id.ToString()); // row.Add(trip.startTime.ToString()); row.Add(key); row.Add(name); writer.WriteRow(row); } } } }
void WriteRemainLongBody(KtbSpotPosition longPos, CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add(longPos.TradingDate.ToString("yyyy-MM-dd")); row.Add("" + longPos.Count); row.Add(longPos.Rate.ToString("n5")); row.Add("" + longPos.Price); row.Add("" + longPos.Notional); writer.WriteRow(row); }
private static bool CheckCSVRowText(CsvRow row) { if (string.IsNullOrEmpty(row.RowText)) { return(false); } int _offset = 0; int _rowCount = 0; while (_offset < row.RowText.Length) { string _tmpText; if (row.RowText[_offset] == '"') { _offset++; int _start = _offset; while (_offset < row.RowText.Length) { if (row.RowText[_offset] == '"') { _offset++; if (_offset >= row.RowText.Length || row.RowText[_offset] != '"') { _offset--; break; } } _offset++; } _tmpText = row.RowText.Substring(_start, _offset - _start); _tmpText = _tmpText.Replace("\"\"", "\""); } else { int start = _offset; while (_offset < row.RowText.Length && row.RowText[_offset] != ',') { _offset++; } _tmpText = row.RowText.Substring(start, _offset - start); } if (_rowCount < row.Count) { row[_rowCount] = _tmpText; } else { row.Add(_tmpText); } _rowCount++; while (_offset < row.RowText.Length && row.RowText[_offset] != ',') { _offset++; } if (_offset < row.RowText.Length) { _offset++; } } while (row.Count > _rowCount) { row.RemoveAt(_rowCount); } return(row.Count > 0); }
private void btnToCSV_Click(object sender, EventArgs e) { try { // Displays a SaveFileDialog so the user can save the Image // assigned to Button2. SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Filter = "CSV|*.csv"; saveFileDialog1.Title = "Guardar como csv..."; saveFileDialog1.ShowDialog(); if (saveFileDialog1.FileName != "") { Cursor = Cursors.WaitCursor; System.IO.FileStream fs = (System.IO.FileStream)saveFileDialog1.OpenFile(); fs.Close(); CsvFileWriter file = new CsvFileWriter(saveFileDialog1.FileName); CsvRow header = new CsvRow(); foreach (DataGridViewColumn col in dgvParte4Final.Columns) { header.Add(col.Name); } file.WriteRow(header); foreach (Source.citParte4Final item in _result) { file.WriteRow(item.ToCsv()); } file.Flush(); file.Close(); MessageBox.Show("Ficheiro guardado."); } } catch (Exception ex) { MessageBox.Show("Erro\n" + ex.Message); } finally { Cursor = Cursors.Default; } }
//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); } }
public DynamicsDataCollection() { header.Add("x-coordinate"); header.Add("y-coordinate"); header.Add("z-coordinate"); header.Add("Heading"); header.Add("Bank"); header.Add("Pitch"); header.Add("Speed"); header.Add("Altitude"); header.Add("Aircraft Type"); header.Add("Score"); header.Add("CameraRig x-rotation"); header.Add("CameraRig y-rotation"); header.Add("CameraRig z-rotation"); header.Add("Closest Point x-coordinate"); header.Add("Closest Point y-coordinate"); header.Add("Closest Point z-coordinate"); header.Add("Bearing Horizontal"); header.Add("Bearing Vertical"); header.Add("Aspect Horizontal"); header.Add("Aspect Vertical"); header.Add("Target Aircraft x-coordinate"); header.Add("Target Aircraft y-coordinate"); header.Add("Target Aircraft z-coordinate"); header.Add("Target Aircraft Heading"); header.Add("Target Aircraft Bank"); header.Add("Target Aircraft Pitch"); header.Add("Target Aircraft Speed"); header.Add("Target Aircraft Altitude"); header.Add("Target Aircraft Type"); header.Add("Airspace Violated"); rows.Add(header); }
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); } } } }
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 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); } } } } }
private string SaveFailedImportResult(string destinationPath, string filename, List<Tuple<string, string, string>> listFail) { string failData = destinationPath + "error_" + filename; using (CsvFileWriter writer = new CsvFileWriter(failData)) { CsvRow row = new CsvRow(); row.Add("Downloader username"); row.Add("Referral username"); row.Add("Error"); writer.WriteRow(row); foreach (var item in listFail) { row = new CsvRow(); row.Add(item.Item1); row.Add(item.Item2); row.Add(item.Item3); writer.WriteRow(row); } } return failData; }
private static void TestSeeds(WhatToTest condition, int AmountOfSeedsToTest, int PlatesPerEvent) { var random = new Random(); if (condition == WhatToTest.NumberOfNumToOneRow) { using (CsvFileWriter writer = new CsvFileWriter("TestOfOneRow.csv")) { CsvRow row = new CsvRow(); row.Add("Seed"); row.Add("AntalTal"); writer.WriteRow(row); for (int i = 0; i < AmountOfSeedsToTest; i++) { BingoEvent TestEvent = new BingoEvent(); TestEvent.Initialize(RandomSeed(random), "Test nr." + i, PlatesPerEvent); TestEvent.PInfo.CardList = TestEvent.PInfo.CardGenerator.GenerateCard(TestEvent.PInfo.PlatesGenerated); Random rdnForEvents = new Random(); int numbersNeededForCondition = 0; while (!RunTestEvent(1, TestEvent)) { PickRandomNumber(TestEvent, rdnForEvents); numbersNeededForCondition++; } //Write here CsvRow resultRow = new CsvRow(); row.Add(TestEvent.SInfo.OriginalSeed); row.Add(numbersNeededForCondition.ToString()); writer.WriteRow(row); } } } else if (condition == WhatToTest.NumberOfNumToPlate) { using (CsvFileWriter writer = new CsvFileWriter("TestOfPlate.csv")) { CsvRow row = new CsvRow(); row.Add("Seed"); row.Add("AntalTal"); writer.WriteRow(row); for (int i = 0; i < AmountOfSeedsToTest; i++) { BingoEvent TestEvent = new BingoEvent(); TestEvent.Initialize(RandomSeed(random), "Test nr." + i, PlatesPerEvent); TestEvent.PInfo.CardList = TestEvent.PInfo.CardGenerator.GenerateCard(TestEvent.PInfo.PlatesGenerated); Random rdnForEvents = new Random(); int numbersNeededForCondition = 0; while (!RunTestEvent(3, TestEvent)) { PickRandomNumber(TestEvent, rdnForEvents); numbersNeededForCondition++; } //Write here CsvRow resultRow = new CsvRow(); row.Add(TestEvent.SInfo.OriginalSeed); row.Add(numbersNeededForCondition.ToString()); writer.WriteRow(row); } } } }
private void serialPort_DataReceived(object sender, SerialDataReceivedEventArgs e) { bool flag = true; char[] charsToTrim = { '\n' }; SerialPort s = sender as SerialPort; string tmp = s.ReadExisting().Trim(charsToTrim); if (!string.IsNullOrEmpty(tmp)) { CsvRow row = new CsvRow(); row.Add(DateTime.Now.format("dd-MM-yyy HH:mm:ss")); row.Add(s.PortName); row.Add(tmp); Rows.Add(row); if (tmp.IndexOf("#") >= 0) { this.cmd = string.Empty; this.cmd += tmp; flag = false; } if (tmp.IndexOf("$") >= 0) { this.cmd += tmp; int to = this.cmd.IndexOf("#"); if (to >= 0) { int from = 0; try { from = this.cmd.IndexOf("$", to + 1); this.cmd = this.cmd.Substring(to + 1, from - to - 1); } catch (Exception) { } string[] element = this.cmd.Split(' '); if (element.Length == 4) { if ((element[1] == "A" || element[1] == "B") && (element[3] == "1") && element.Length < 5) { QueueCMD.Enqueue(this.cmd); //alert = true; } } Regex myRegex = new Regex(@"\d$"); if (myRegex.IsMatch(this.cmd) && !string.IsNullOrEmpty(this.cmd)) { s.sendCommand(element[0] + " OK$"); } // else if (!string.IsNullOrEmpty(this.cmd) && this.command != null) // { //if (s.PortName.ToLower() == command.name.ToLower() && command.mode == CommandMode.WAIT) //{ // command.mode = CommandMode.RUN; //} // } try { int id_board = Convert.ToInt32(element[0]); if (App.DataAlarm != null) { for (int i = 0; i < App.DataAlarm.Count; i++) { if (App.DataAlarm[i].board == id_board) { App.DataAlarm[i].Com = s.PortName; } } } } catch (Exception ex) { Console.WriteLine(ex.GetBaseException().ToString() + "id: " + this.cmd); } //mysql_helpper.setCommand(this.cmd, s.PortName.ToString()); } flag = false; this.cmd = string.Empty; } if (flag) this.cmd += tmp; } }
void addDataRow() { if (oncomingAircraftData != null) { CsvRow row = new CsvRow(); SerializedDynamicsData data = new SerializedDynamicsData(); data.xCoordinate = coordinates.x; data.yCoordinate = coordinates.y; data.zCoordinate = coordinates.z; data.heading = heading; data.bank = bank; data.pitch = pitch; data.speed = speed; data.altitude = altitude; data.aircraftType = aircraftType; data.score = score; data.cameraRigXRotation = ovrCameraRigRotation.x; data.cameraRigYRotation = ovrCameraRigRotation.y; data.cameraRigZRotation = ovrCameraRigRotation.z; data.closestPointXCoordinate = closestPoint.x; data.closestPointYCoordinate = closestPoint.y; data.closestPointZCoordinate = closestPoint.z; data.bearingHorizontal = bearingHorizontal; data.bearingVertical = bearingVertical; data.aspectHorizontal = aspectHorizontal; data.aspectVertical = aspectVertical; data.targetAircraftXCoordinate = oncomingAircraftData.coordinates.x; data.targetAircraftYCoordinate = oncomingAircraftData.coordinates.y; data.targetAircraftZCoordinate = oncomingAircraftData.coordinates.z; data.targetAircraftHeading = oncomingAircraftData.heading; data.targetAircraftBank = oncomingAircraftData.bank; data.targetAircraftPitch = oncomingAircraftData.pitch; data.targetAircraftSpeed = oncomingAircraftData.speed; data.targetAircraftAltitude = oncomingAircraftData.altitude; data.targetAircraftType = oncomingAircraftData.aircraftType; data.airspaceViolated = airspaceViolated; row.Add(String.Format("{0}", coordinates.x)); row.Add(String.Format("{0}", coordinates.y)); row.Add(String.Format("{0}", coordinates.z)); row.Add(String.Format("{0}", heading)); row.Add(String.Format("{0}", bank)); row.Add(String.Format("{0}", pitch)); row.Add(String.Format("{0}", speed)); row.Add(String.Format("{0}", altitude)); row.Add(String.Format("{0}", aircraftType)); row.Add(String.Format("{0}", score)); row.Add(String.Format("{0}", ovrCameraRigRotation.x)); row.Add(String.Format("{0}", ovrCameraRigRotation.y)); row.Add(String.Format("{0}", ovrCameraRigRotation.z)); row.Add(String.Format("{0}", closestPoint.x)); row.Add(String.Format("{0}", closestPoint.y)); row.Add(String.Format("{0}", closestPoint.z)); row.Add(String.Format("{0}", bearingHorizontal)); row.Add(String.Format("{0}", bearingVertical)); row.Add(String.Format("{0}", aspectHorizontal)); row.Add(String.Format("{0}", aspectVertical)); row.Add(String.Format("{0}", oncomingAircraftData.coordinates.x)); row.Add(String.Format("{0}", oncomingAircraftData.coordinates.y)); row.Add(String.Format("{0}", oncomingAircraftData.coordinates.z)); row.Add(String.Format("{0}", oncomingAircraftData.heading)); row.Add(String.Format("{0}", oncomingAircraftData.bank)); row.Add(String.Format("{0}", oncomingAircraftData.pitch)); row.Add(String.Format("{0}", oncomingAircraftData.speed)); row.Add(String.Format("{0}", oncomingAircraftData.altitude)); row.Add(String.Format("{0}", oncomingAircraftData.aircraftType)); row.Add(String.Format("{0}", airspaceViolated)); savedDynamicsData.addDataRow(row, data); } }
void WriteLongBody(KtbSpotPosition longPos, CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("" + 2); row.Add("" + longPos.Count / CommonConst._100_000_000); row.Add(longPos.Rate.ToString("n5")); row.Add("" + longPos.Price); row.Add("" + longPos.Notional); writer.WriteRow(row); }
/// <summary> /// Writes the Trial File to a CSV /// </summary> private void WriteTrialFile() { // Write all entries in data list to file Directory.CreateDirectory(@"Data/" + pid); using (CsvFileWriter writer = new CsvFileWriter(@"Data/" + pid + "/" + pid + "Try" + tryNum + ".csv")) { Debug.Log("Writing trial data to file"); // write header CsvRow header = new CsvRow(); header.Add("Participant ID"); header.Add("Trial Number"); header.Add("Score"); header.Add("Number of Pickups Collected"); header.Add("Number of Bad Pickups Collected"); header.Add("Number of Falls"); header.Add("Time remaining (seconds)"); header.Add("Total time (seconds)"); header.Add("Level Difficulty"); header.Add("Game won?"); writer.WriteRow(header); // write each line of data foreach (TrialData d in trialData) { CsvRow row = new CsvRow(); row.Add(pid); row.Add(tryNum); row.Add(d.score.ToString()); row.Add(d.numPickups.ToString()); row.Add(d.numBadPickups.ToString()); row.Add(d.numFalls.ToString()); row.Add(d.timeRemaining.ToString()); row.Add(GlobalControl.Instance.timeLimit.ToString()); row.Add(GlobalControl.Instance.levelNumber.ToString()); if (d.won) { row.Add("YES"); } else { row.Add("NO"); } writer.WriteRow(row); } } }
void WriteDoneBody(KtbSpotDonePosition done, CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("" + done.ShortPosition.Long_2_Short_1); row.Add("" + done.ShortPosition.Count); row.Add(done.ShortPosition.Rate.ToString("n5")); row.Add("" + done.ShortPosition.Price); row.Add("" + done.ShortPosition.Notional); row.Add("" + done.LongPosition.TradingDate.ToString("yyyyMMdd")); row.Add("" + done.LongPosition.Price); writer.WriteRow(row); }
public void WriteToFile(string location) { // Write all entries in data list to file using (CsvFileWriter writer = new CsvFileWriter(location)) { // write header CsvRow header = new CsvRow(); header.Add("Time"); header.Add("Head X"); header.Add("Head Y"); header.Add("Head Z"); header.Add("Neck X"); header.Add("Neck Y"); header.Add("Neck Z"); header.Add("SpineShoulder X"); header.Add("SpineShoulder Y"); header.Add("SpineShoulder Z"); header.Add("SpineMid X"); header.Add("SpineMid Y"); header.Add("SpineMid Z"); header.Add("SpineBase X"); header.Add("SpineBase Y"); header.Add("SpineBase Z"); header.Add("RightShoulder X"); header.Add("RightShoulder Y"); header.Add("RightShoulder Z"); header.Add("LeftShoulder X"); header.Add("LeftShoulder Y"); header.Add("LeftShoulder Z"); header.Add("RightElbow X"); header.Add("RightElbow Y"); header.Add("RightElbow Z"); header.Add("LeftElbow X"); header.Add("LeftElbow Y"); header.Add("LeftElbow Z"); header.Add("RightWrist X"); header.Add("RightWrist Y"); header.Add("RightWrist Z"); header.Add("LeftWrist X"); header.Add("LeftWrist Y"); header.Add("LeftWrist Z"); header.Add("RightHand X"); header.Add("RightHand Y"); header.Add("RightHand Z"); header.Add("LeftHand X"); header.Add("LeftHand Y"); header.Add("LeftHand Z"); header.Add("RightThumb X"); header.Add("RightThumb Y"); header.Add("RightThumb Z"); header.Add("LeftThumb X"); header.Add("LeftThumb Y"); header.Add("LeftThumb Z"); header.Add("RightHandTip X"); header.Add("RightHandTip Y"); header.Add("RightHandTip Z"); header.Add("LeftHandTip X"); header.Add("LeftHandTip Y"); header.Add("LeftHandTip Z"); header.Add("RightHip X"); header.Add("RightHip Y"); header.Add("RightHip Z"); header.Add("LeftHip X"); header.Add("LeftHip Y"); header.Add("LeftHip Z"); header.Add("RightKnee X"); header.Add("RightKnee Y"); header.Add("RightKnee Z"); header.Add("LeftKnee X"); header.Add("LeftKnee Y"); header.Add("LeftKnee Z"); header.Add("RightAnkle X"); header.Add("RightAnkle Y"); header.Add("RightAnkle Z"); header.Add("LeftAnkle X"); header.Add("LeftAnkle Y"); header.Add("LeftAnkle Z"); header.Add("RightFoot X"); header.Add("RightFoot Y"); header.Add("RightFoot Z"); header.Add("LeftFoot X"); header.Add("LeftFoot Y"); header.Add("LeftFoot Z"); header.Add("Trial In Progress?"); writer.WriteRow(header); // write each line of data foreach (JointData d in data) { CsvRow row = new CsvRow(); row.Add(d.time); row.Add(d.Head.X.ToString()); row.Add(d.Head.Y.ToString()); row.Add(d.Head.Z.ToString()); row.Add(d.Neck.X.ToString()); row.Add(d.Neck.Y.ToString()); row.Add(d.Neck.Z.ToString()); row.Add(d.SpineShoulder.X.ToString()); row.Add(d.SpineShoulder.Y.ToString()); row.Add(d.SpineShoulder.Z.ToString()); row.Add(d.SpineMid.X.ToString()); row.Add(d.SpineMid.Y.ToString()); row.Add(d.SpineMid.Z.ToString()); row.Add(d.SpineBase.X.ToString()); row.Add(d.SpineBase.Y.ToString()); row.Add(d.SpineBase.Z.ToString()); row.Add(d.RightShoulder.X.ToString()); row.Add(d.RightShoulder.Y.ToString()); row.Add(d.RightShoulder.Z.ToString()); row.Add(d.LeftShoulder.X.ToString()); row.Add(d.LeftShoulder.Y.ToString()); row.Add(d.LeftShoulder.Z.ToString()); row.Add(d.RightElbow.X.ToString()); row.Add(d.RightElbow.Y.ToString()); row.Add(d.RightElbow.Z.ToString()); row.Add(d.LeftElbow.X.ToString()); row.Add(d.LeftElbow.Y.ToString()); row.Add(d.LeftElbow.Z.ToString()); row.Add(d.RightWrist.X.ToString()); row.Add(d.RightWrist.Y.ToString()); row.Add(d.RightWrist.Z.ToString()); row.Add(d.LeftWrist.X.ToString()); row.Add(d.LeftWrist.Y.ToString()); row.Add(d.LeftWrist.Z.ToString()); row.Add(d.RightHand.X.ToString()); row.Add(d.RightHand.Y.ToString()); row.Add(d.RightHand.Z.ToString()); row.Add(d.LeftHand.X.ToString()); row.Add(d.LeftHand.Y.ToString()); row.Add(d.LeftHand.Z.ToString()); row.Add(d.RightThumb.X.ToString()); row.Add(d.RightThumb.Y.ToString()); row.Add(d.RightThumb.Z.ToString()); row.Add(d.LeftThumb.X.ToString()); row.Add(d.LeftThumb.Y.ToString()); row.Add(d.LeftThumb.Z.ToString()); row.Add(d.RightHandTip.X.ToString()); row.Add(d.RightHandTip.Y.ToString()); row.Add(d.RightHandTip.Z.ToString()); row.Add(d.LeftHandTip.X.ToString()); row.Add(d.LeftHandTip.Y.ToString()); row.Add(d.LeftHandTip.Z.ToString()); row.Add(d.RightHip.X.ToString()); row.Add(d.RightHip.Y.ToString()); row.Add(d.RightHip.Z.ToString()); row.Add(d.LeftHip.X.ToString()); row.Add(d.LeftHip.Y.ToString()); row.Add(d.LeftHip.Z.ToString()); row.Add(d.RightKnee.X.ToString()); row.Add(d.RightKnee.Y.ToString()); row.Add(d.RightKnee.Z.ToString()); row.Add(d.LeftKnee.X.ToString()); row.Add(d.LeftKnee.Y.ToString()); row.Add(d.LeftKnee.Z.ToString()); row.Add(d.RightAnkle.X.ToString()); row.Add(d.RightAnkle.Y.ToString()); row.Add(d.RightAnkle.Z.ToString()); row.Add(d.LeftAnkle.X.ToString()); row.Add(d.LeftAnkle.Y.ToString()); row.Add(d.LeftAnkle.Z.ToString()); row.Add(d.RightFoot.X.ToString()); row.Add(d.RightFoot.Y.ToString()); row.Add(d.RightFoot.Z.ToString()); row.Add(d.LeftFoot.X.ToString()); row.Add(d.LeftFoot.Y.ToString()); row.Add(d.LeftFoot.Z.ToString()); if (d.marking) { row.Add("YES"); } else { row.Add("NO"); } writer.WriteRow(row); } } }
void WriteHeader(CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("CurDate"); row.Add("KospiWeight"); writer.WriteRow(row); }
private void btnExport_Click(object sender, EventArgs e) { int i = 0; SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.DefaultExt = "*.csv"; saveFileDialog.AddExtension = true; saveFileDialog.Filter = "csv files|*.csv"; saveFileDialog.OverwritePrompt = true; saveFileDialog.CheckPathExists = true; saveFileDialog.FileName = "Channel_" + DateTime.Now.ToString("MMdd_HHmmss"); if (saveFileDialog.ShowDialog() == DialogResult.OK && saveFileDialog.FileName != null) { using (CsvFileWriter csvFileWriter = new CsvFileWriter(new FileStream(saveFileDialog.FileName, FileMode.Create), Encoding.Default)) { CsvRow csvRow = new CsvRow(); csvRow.AddRange(ChannelsForm.SZ_HEADER_TEXT); csvFileWriter.WriteRow(csvRow); for (i = 0; i < ChannelForm.data.Count; i++) { if (ChannelForm.data.DataIsValid(i)) { csvRow.RemoveAll(ChannelsForm.smethod_0); ChannelForm.ChannelOne channelOne = ChannelForm.data[i]; csvRow.Add(i.ToString()); csvRow.Add(channelOne.Name); csvRow.Add(channelOne.RxFreq); csvRow.Add(channelOne.TxFreq); csvRow.Add(channelOne.ChModeS); csvRow.Add(channelOne.PowerS); csvRow.Add(channelOne.RxTone); csvRow.Add(channelOne.TxTone); csvRow.Add(channelOne.TxColor.ToString()); csvRow.Add(channelOne.RxGroupList.ToString()); csvRow.Add(channelOne.Contact.ToString()); csvRow.Add(channelOne.RepeaterSlotS); csvFileWriter.WriteRow(csvRow); } } } } }
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; if (row.LineText[pos] == '"') { pos++; int start = pos; while (pos < row.LineText.Length) { if (row.LineText[pos] == '"') { pos++; if (pos >= row.LineText.Length || row.LineText[pos] != '"') { pos--; break; } } pos++; } value = row.LineText.Substring(start, pos - start); value = value.Replace("\"\"", "\""); } else { int start = pos; while (pos < row.LineText.Length && row.LineText[pos] != ',') { pos++; } value = row.LineText.Substring(start, pos - start); } if (rows < row.Count) { row[rows] = value; } else { row.Add(value); } rows++; while (pos < row.LineText.Length && row.LineText[pos] != ',') { pos++; } if (pos < row.LineText.Length) { pos++; } } while (row.Count > rows) { row.RemoveAt(rows); } return(row.Count > 0); }
public void WorkerProc() { _success = true; // all is good unless something fails _active = true; _client = new TranslateService.LanguageServiceClient(); // Get the manually corrected values if they exist System.Collections.Generic.SortedList <string, string> translatedValues = new SortedList <string, string>(); // automatic translations System.Collections.Generic.SortedList <string, string> manualValues = new SortedList <string, string>(); // User translations string fixedLanguageFileName = Path.Combine(_localisationPath, _languageCode + "-fixed.txt"); if (File.Exists(fixedLanguageFileName)) { using (CsvFileReader reader = new CsvFileReader(fixedLanguageFileName)) { CsvRow row = new CsvRow(); while (reader.ReadRow(row)) { if (row.Count > 1) { if (!manualValues.ContainsKey(row[0])) { manualValues.Add(row[0], row[1]); // Create a sorted list of values with manual updates } } } } } // Create the language file string languageFileName = Path.Combine(_localisationPath, _languageCode + ".txt"); // If the file already exists then don't overwrite it // So we don't overwrite from scratch. If new translations are required then the existing files needs to be deleted first // If the language file already exists then load the file so we can add new strings and deletes one not being used // BING now limits the amount of data that can be downloaded so we should only update what's required instead of downloading everthing again CsvRow orgRow = new CsvRow(); if (File.Exists(languageFileName)) { using (CsvFileReader orgReader = new CsvFileReader(languageFileName)) { while (orgReader.ReadRow(orgRow)) // Read all the data in { if (manualValues.ContainsKey(orgRow[0])) { _manual++; // We have a manual translation } if (!translatedValues.ContainsKey(orgRow[0])) { translatedValues.Add(orgRow[0], orgRow[1]); // Add to the sorted listed - we don't add manual translations here, just track them. They are added on the fly at runtime } else { _duplicate++; // Duplicate } } } } using (CsvFileWriter writer = new CsvFileWriter(languageFileName)) { using (CsvFileReader reader = new CsvFileReader(_englishFilePath)) { CsvRow row = new CsvRow(); while (reader.ReadRow(row)) { if (row.Count > 0) { while (row.Count > 1) { row.RemoveAt(1); } string transText = ""; if (translatedValues.ContainsKey(row[0])) { transText = translatedValues[row[0]]; _replaced++; } else { transText = TranslateText(row[0], _languageCode); // check for a null return, then BING failed due to quota issues if (transText == null) { _success = false; // break out and clean up the file break; } else { _downloaded++; } } row.Add(transText); writer.WriteRow(row); // Write the data _progress++; if (_cancelled) { _success = false; break; } if (Console.KeyAvailable) // check if any other thread caught the cancellation event (ESC) { ConsoleKeyInfo cki = Console.ReadKey(true); if ((cki.Key == ConsoleKey.Escape) || ((cki.Modifiers == ConsoleModifiers.Control) && (cki.Key == ConsoleKey.C))) { _cancelled = true; // signal all thread to exit _success = false; // Clean up the file break; } } } } } } _client.Close(); _active = false; // First set this to avoid overwriting console // Check for failure, if so delete the file - we do not keep partially translated files if (_success == false) { string consoleTxt = _languageCode + " (" + _languageName + ")" + " -> " + "Translation cancelled..."; TranslateAll.WriteStatus(consoleTxt, _row, ConsoleColor.DarkMagenta); File.Delete(languageFileName); } else { string consoleTxt = _languageCode + " (" + _languageName + ")" + " -> " + _progress + " translations complete! Downloaded " + _downloaded + " Existing " + _replaced + " Manual " + _manual + " Duplicate " + _duplicate; TranslateAll.WriteStatus(consoleTxt, _row, ConsoleColor.Green); } return; }
public void FillHighScores() { //Row to read values from Other files(dataset, new high score in 000001.csv) CsvRow readerRow; //Row to insert values into CsvFileWriter below for HighScoreFile good copy CsvRow row = new CsvRow(); //Reader Object for New High Score (or old if run early) CsvFileReader reader = new CsvFileReader("HighScoreFile.csv"); //Array of Player Objects to fill with readerRow's values read List <PlayerObject> pastPlayers = new List <PlayerObject> (); //Loop through the reader till the end while (!reader.EndOfStream) { //if (reader.BaseStream.ReadByte() == -1) // break; //Build a new player Object to fill PlayerObject obj = new PlayerObject(); //Instatiate the CsvRow readerRow = new CsvRow(); //Build a string array to hold the CsvRow values string[] list = new string[2]; //Read the rows and Copy the data to the array reader.ReadRow(readerRow); readerRow.CopyTo(list); //Check for "Player" as the first column and skip it if (list [0].ToString().Contains("Player")) { continue; } //Set player names by formatting the string, and parsing to a float obj.setPlayerName(string.Format("{0}", list[0].ToString())); obj.setPoints(float.Parse(list [1])); //Add the player Object to the array pastPlayers.Add(obj); readerRow.Clear(); } //End of while loop reader.Dispose(); reader.Close(); //Reader to loop through Dataset for run just taken. Keeps the values safe. reader = new CsvFileReader("000001.csv"); while (!reader.EndOfStream) { PlayerObject obj = new PlayerObject(); readerRow = new CsvRow(); string[] list = new string[2]; //Read the rows and Copy the data to the array reader.ReadRow(readerRow); readerRow.CopyTo(list); //Set player names by formatting the string, and parsing to a float obj.setPlayerName(string.Format("{0}", list [0].ToString())); obj.setPoints(float.Parse(list [1])); //Add the player Object to the array pastPlayers.Add(obj); readerRow.Clear(); } reader.Dispose(); reader.Close(); //Reader to loop through Dataset given for assignment, which pulls the values //of the name of the commodity in the list, and the value of the commodity. //It has taken a shortened version, at the behest of Professor Stanley Pieda //when asked if I needed to keep the 100K+ file or revise it slightly. /*reader = new CsvFileReader ("000000.csv"); * * while(!reader.EndOfStream){ * * PlayerObject obj = new PlayerObject(); * readerRow = new CsvRow(); * string[] list = new string[6]; * * reader.ReadRow (readerRow); * readerRow.CopyTo(list); * obj.setPlayerName(string.Format("{0}", list [2].ToString ())); * obj.setPoints (float.Parse(list[5])); * * pastPlayers.Add(obj); * readerRow.Clear (); * } * * reader.Dispose (); * reader.Close (); */ //CsvFileWriter Object to write the high score objects to the csv file CsvFileWriter writer = new CsvFileWriter("HighScoreFile.csv"); //Adding the headers for Player and Score in the table row.Add(string.Format("Player")); row.Add(string.Format("Score")); //Writing it to the file, and clearing the row which was written writer.WriteRow(row); row.Clear(); pastPlayers.Sort((x, y) => y.points.CompareTo(x.points)); //Looping through the number of playerObjects in the List. Printing each one //To it's own row and clearing that row after it's written. for (int i = 0; i < pastPlayers.Count; i++) { row.Add(string.Format("{0}", pastPlayers[i].getPlayerName())); row.Add(string.Format("{0}", pastPlayers[i].getPoints())); writer.WriteRow(row); row.Clear(); } //Clean up the writers writer.Dispose(); writer.Close(); //pastPlayers.Sort (0,pastPlayers.Count,pastPlayers [0].points); }
/// <summary> /// Writes the Continuous File to a CSV /// </summary> private void WriteContinuousFile() { // Write all entries in data list to file Directory.CreateDirectory(@"Data/" + pid + VersionString()); using (CsvFileWriter writer = new CsvFileWriter(@"Data/" + pid + VersionString() + "/Continuous" + pid + ".csv")) { Debug.Log("Writing continuous data to file"); // write header CsvRow header = new CsvRow(); header.Add("Time"); header.Add("Trial Number"); header.Add("Ball X"); header.Add("Ball Y"); header.Add("Ball Z"); header.Add("COP X"); header.Add("COP Y"); header.Add("Wrist X"); header.Add("Wrist Y"); header.Add("Wrist Z"); header.Add("Arm X"); header.Add("Arm Y"); header.Add("Arm Z"); writer.WriteRow(header); // write each line of data foreach (ContinuousData d in continuousData) { CsvRow row = new CsvRow(); row.Add(d.time.ToString()); row.Add(d.trialNum.ToString()); row.Add(d.ballPosition.x.ToString()); row.Add(d.ballPosition.y.ToString()); row.Add(d.ballPosition.z.ToString()); row.Add(d.cop.x.ToString()); row.Add(d.cop.y.ToString()); row.Add(d.wristPosition.x.ToString()); row.Add(d.wristPosition.y.ToString()); row.Add(d.wristPosition.z.ToString()); row.Add(d.armPosition.x.ToString()); row.Add(d.armPosition.y.ToString()); row.Add(d.armPosition.z.ToString()); writer.WriteRow(row); } } SkittlesGame.OnRecordContinuousData -= recordContinuousTrial; VirtualSkittlesGame.OnRecordContinuousData -= recordContinuousTrial; }
public void WriteToFile() { Directory.CreateDirectory(@"Data/" + pid + "Virtual"); using (CsvFileWriter writer = new CsvFileWriter(@"Data/" + pid + "Virtual/IKData" + pid + ".csv")) { Debug.Log("Writing IK Recording to file"); // write header CsvRow header = new CsvRow(); header.Add("Time"); header.Add("Current Trial"); header.Add("Head X"); header.Add("Head Y"); header.Add("Head Z"); header.Add("Neck X"); header.Add("Neck Y"); header.Add("Neck Z"); header.Add("SpineShoulder X"); header.Add("SpineShoulder Y"); header.Add("SpineShoulder Z"); header.Add("SpineMid X"); header.Add("SpineMid Y"); header.Add("SpineMid Z"); header.Add("SpineBase X"); header.Add("SpineBase Y"); header.Add("SpineBase Z"); header.Add("RightShoulder X"); header.Add("RightShoulder Y"); header.Add("RightShoulder Z"); header.Add("LeftShoulder X"); header.Add("LeftShoulder Y"); header.Add("LeftShoulder Z"); header.Add("RightElbow X"); header.Add("RightElbow Y"); header.Add("RightElbow Z"); header.Add("LeftElbow X"); header.Add("LeftElbow Y"); header.Add("LeftElbow Z"); header.Add("RightWrist X"); header.Add("RightWrist Y"); header.Add("RightWrist Z"); header.Add("LeftWrist X"); header.Add("LeftWrist Y"); header.Add("LeftWrist Z"); header.Add("RightHand X"); header.Add("RightHand Y"); header.Add("RightHand Z"); header.Add("LeftHand X"); header.Add("LeftHand Y"); header.Add("LeftHand Z"); header.Add("RightThumb X"); header.Add("RightThumb Y"); header.Add("RightThumb Z"); header.Add("LeftThumb X"); header.Add("LeftThumb Y"); header.Add("LeftThumb Z"); header.Add("RightHandTip X"); header.Add("RightHandTip Y"); header.Add("RightHandTip Z"); header.Add("LeftHandTip X"); header.Add("LeftHandTip Y"); header.Add("LeftHandTip Z"); header.Add("RightHip X"); header.Add("RightHip Y"); header.Add("RightHip Z"); header.Add("LeftHip X"); header.Add("LeftHip Y"); header.Add("LeftHip Z"); header.Add("RightKnee X"); header.Add("RightKnee Y"); header.Add("RightKnee Z"); header.Add("LeftKnee X"); header.Add("LeftKnee Y"); header.Add("LeftKnee Z"); header.Add("RightAnkle X"); header.Add("RightAnkle Y"); header.Add("RightAnkle Z"); header.Add("LeftAnkle X"); header.Add("LeftAnkle Y"); header.Add("LeftAnkle Z"); header.Add("RightFoot X"); header.Add("RightFoot Y"); header.Add("RightFoot Z"); header.Add("LeftFoot X"); header.Add("LeftFoot Y"); header.Add("LeftFoot Z"); writer.WriteRow(header); // write each line of data foreach (JointData d in data) { CsvRow row = new CsvRow(); row.Add(d.time.ToString()); row.Add(d.curTrial.ToString()); row.Add(d.Head.x.ToString()); row.Add(d.Head.y.ToString()); row.Add(d.Head.z.ToString()); row.Add(d.Neck.x.ToString()); row.Add(d.Neck.y.ToString()); row.Add(d.Neck.z.ToString()); row.Add(d.SpineShoulder.x.ToString()); row.Add(d.SpineShoulder.y.ToString()); row.Add(d.SpineShoulder.z.ToString()); row.Add(d.SpineMid.x.ToString()); row.Add(d.SpineMid.y.ToString()); row.Add(d.SpineMid.z.ToString()); row.Add(d.SpineBase.x.ToString()); row.Add(d.SpineBase.y.ToString()); row.Add(d.SpineBase.z.ToString()); row.Add(d.RightShoulder.x.ToString()); row.Add(d.RightShoulder.y.ToString()); row.Add(d.RightShoulder.z.ToString()); row.Add(d.LeftShoulder.x.ToString()); row.Add(d.LeftShoulder.y.ToString()); row.Add(d.LeftShoulder.z.ToString()); row.Add(d.RightElbow.x.ToString()); row.Add(d.RightElbow.y.ToString()); row.Add(d.RightElbow.z.ToString()); row.Add(d.LeftElbow.x.ToString()); row.Add(d.LeftElbow.y.ToString()); row.Add(d.LeftElbow.z.ToString()); row.Add(d.RightWrist.x.ToString()); row.Add(d.RightWrist.y.ToString()); row.Add(d.RightWrist.z.ToString()); row.Add(d.LeftWrist.x.ToString()); row.Add(d.LeftWrist.y.ToString()); row.Add(d.LeftWrist.z.ToString()); row.Add(d.RightHand.x.ToString()); row.Add(d.RightHand.y.ToString()); row.Add(d.RightHand.z.ToString()); row.Add(d.LeftHand.x.ToString()); row.Add(d.LeftHand.y.ToString()); row.Add(d.LeftHand.z.ToString()); row.Add(d.RightThumb.x.ToString()); row.Add(d.RightThumb.y.ToString()); row.Add(d.RightThumb.z.ToString()); row.Add(d.LeftThumb.x.ToString()); row.Add(d.LeftThumb.y.ToString()); row.Add(d.LeftThumb.z.ToString()); row.Add(d.RightHandTip.x.ToString()); row.Add(d.RightHandTip.y.ToString()); row.Add(d.RightHandTip.z.ToString()); row.Add(d.LeftHandTip.x.ToString()); row.Add(d.LeftHandTip.y.ToString()); row.Add(d.LeftHandTip.z.ToString()); row.Add(d.RightHip.x.ToString()); row.Add(d.RightHip.y.ToString()); row.Add(d.RightHip.z.ToString()); row.Add(d.LeftHip.x.ToString()); row.Add(d.LeftHip.y.ToString()); row.Add(d.LeftHip.z.ToString()); row.Add(d.RightKnee.x.ToString()); row.Add(d.RightKnee.y.ToString()); row.Add(d.RightKnee.z.ToString()); row.Add(d.LeftKnee.x.ToString()); row.Add(d.LeftKnee.y.ToString()); row.Add(d.LeftKnee.z.ToString()); row.Add(d.RightAnkle.x.ToString()); row.Add(d.RightAnkle.y.ToString()); row.Add(d.RightAnkle.z.ToString()); row.Add(d.LeftAnkle.x.ToString()); row.Add(d.LeftAnkle.y.ToString()); row.Add(d.LeftAnkle.z.ToString()); row.Add(d.RightFoot.x.ToString()); row.Add(d.RightFoot.y.ToString()); row.Add(d.RightFoot.z.ToString()); row.Add(d.LeftFoot.x.ToString()); row.Add(d.LeftFoot.y.ToString()); row.Add(d.LeftFoot.z.ToString()); writer.WriteRow(row); } } }
/// <summary> /// Writes the Trial File to a CSV /// </summary> private void WriteTrialFile() { // Write all entries in data list to file Directory.CreateDirectory(@"Data/" + pid + VersionString()); using (CsvFileWriter writer = new CsvFileWriter(@"Data/" + pid + VersionString() + "/Trial" + pid + ".csv")) { Debug.Log("Writing trial data to file"); // write header CsvRow header = new CsvRow(); header.Add("Time"); header.Add("Using right hand?"); header.Add("Current Trial"); header.Add("Ball X"); header.Add("Ball Y"); header.Add("Ball Z"); header.Add("Wrist X"); header.Add("Wrist Y"); header.Add("Wrist Z"); header.Add("Hand-Ball Distance"); header.Add("Target Hit?"); header.Add("Error Distance"); header.Add("Ball Velocity m/s"); header.Add("Pole Top X"); header.Add("Pole Top Y"); header.Add("Pole Top Z"); header.Add("Rope-Pole Angle (Degrees)"); header.Add("Score"); header.Add("Exploration Mode"); header.Add("Target Position Number"); header.Add("Colliding Obstacle"); header.Add("Target Position X"); header.Add("Target Position Y"); header.Add("Target Position Z"); writer.WriteRow(header); // write each line of data foreach (TrialData d in trialData) { CsvRow row = new CsvRow(); row.Add(d.time.ToString()); if (GlobalControl.Instance.rightHanded) { row.Add("YES"); } else { row.Add("NO"); } row.Add(d.curTrial.ToString()); row.Add(d.ballPosition.x.ToString()); row.Add(d.ballPosition.y.ToString()); row.Add(d.ballPosition.z.ToString()); row.Add(d.wristPosition.x.ToString()); row.Add(d.wristPosition.y.ToString()); row.Add(d.wristPosition.z.ToString()); row.Add(d.handToBallDistance.ToString()); if (d.targetHit) { row.Add("YES"); } else { row.Add("NO"); } row.Add(d.errorDistance.ToString()); row.Add(d.ballVelocity.ToString()); row.Add(d.poleTopPosition.x.ToString()); row.Add(d.poleTopPosition.y.ToString()); row.Add(d.poleTopPosition.z.ToString()); row.Add(d.ropePoleAngle.ToString()); row.Add(d.score.ToString()); if (GlobalControl.Instance.explorationMode == GlobalControl.ExplorationMode.NONE) { row.Add("NONE"); } else if (GlobalControl.Instance.explorationMode == GlobalControl.ExplorationMode.FORCED) { row.Add("FORCED"); } else { row.Add("REWARD"); } // Make the target position 1-indexed instead of 0-indexed row.Add((GlobalControl.Instance.targetPositionIndex + 1).ToString()); if (d.IDNumber == 0) { row.Add("POLE"); } else { row.Add("OBSTACLE " + d.IDNumber.ToString()); } row.Add(d.targetPosition.x.ToString()); row.Add(d.targetPosition.y.ToString()); row.Add(d.targetPosition.z.ToString()); writer.WriteRow(row); } } SkittlesGame.OnRecordTrialData -= recordTrial; VirtualSkittlesGame.OnRecordTrialData -= recordTrial; }
public void btnExport_Click(object sender, EventArgs e) { // export the atomized budget // I'll do more summarized budgets later if (svdSave.ShowDialog() == DialogResult.OK) { // 1 = excel file if (svdSave.FilterIndex == 1) { // first, set up string array to be sent to Excel object[,] output = new object[1 + ClsStorage.currentClub.iMember, 9]; output[0, 0] = "Term"; output[0, 1] = "Description"; output[0, 2] = "Debit"; output[0, 3] = "Credit"; output[0, 4] = "Category"; output[0, 5] = "Type"; output[0, 6] = "Date of Occurrence"; output[0, 7] = "Date in Account"; output[0, 8] = "Comments"; int i = 0; foreach (BudgetItem item in ClsStorage.currentClub.budget) { output[i + 1, 0] = ClsStorage.currentClub.listTerms[item.term].strName; output[i + 1, 1] = item.name; if (item.type == TransactionType.Revenue) output[i + 1, 3] = item.value; else output[i + 1, 2] = item.value; output[i + 1, 4] = item.cat; output[i + 1, 5] = Convert.ToString(item.type); output[i + 1, 6] = item.dateOccur; output[i + 1, 7] = item.dateAccount; output[i + 1, 8] = item.comment; i++; } ExcelFile.saveExcel(output, svdSave.FileName, "dd/MM/yy"); } else if (svdSave.FilterIndex == 2) { // 2 = CSV file using (CsvFileWriter writer = new CsvFileWriter(svdSave.FileName)) { CsvRow firstrow = new CsvRow(); firstrow.Add("Term"); firstrow.Add("Description"); firstrow.Add("Debit"); firstrow.Add("Credit"); firstrow.Add("Category"); firstrow.Add("Type"); firstrow.Add("Date of Occurrence"); firstrow.Add("Date in Account"); firstrow.Add("Comments"); writer.WriteRow(firstrow); foreach (BudgetItem item in ClsStorage.currentClub.budget) { CsvRow row = new CsvRow(); row.Add(ClsStorage.currentClub.listTerms[item.term].strName); row.Add(item.name); if (item.type == TransactionType.Revenue) { row.Add(String.Empty); row.Add(String.Format("${0}", item.value)); } else { row.Add(String.Format("${0}", item.value)); row.Add(String.Empty); } row.Add(item.cat); row.Add(Convert.ToString(item.type)); row.Add(item.dateOccur.ToShortDateString()); row.Add(item.dateAccount.ToShortDateString()); row.Add(item.comment); writer.WriteRow(row); } } if (Properties.Settings.Default.playSounds) Sound.Success.Play(); } } }
// 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); } } } } }
/// <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); }
//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); } } } } }
static void Main(string[] args) { string domain = ""; string category = ""; string type = ""; string filename = "catalog.csv"; OpenDataService odServices = new OpenDataService(); foreach (string arg in args) { if (arg == "-h") { Console.WriteLine( "SoCat: Get Socrata Catalog - Help\n" + "---------------------------------\n\n" + "Proper usage:\n\n" + "socat [-d:domain] [-c:category] [-t:type] [-f:filename]\n\n" + "Ex. socat -d:data.ny.gov -c:transportation -t:map -f:myfile.csv\n\n" + "domain: either data.ny.gov or health.data.ny.gov\n" + "category: valid category (education, health, transportation, etc.)\n" + "type: valid type (tabular, map, chart, etc.)\n" + "filename: valid output path and filename ending with .csv\n\n" + "Notes:\n" + "- If the category or type contains more than one word, enclose it in \"\",\n" + " like this: socat -c:\"energy & environment\"\n" + "- If you don't specify a filename, output will be written to catalog.csv in\n" + " the same location as this program."); return; } if (arg.StartsWith("-d:") && arg.Length > 3) { domain = arg.Substring(3).Trim(); } else if (arg.StartsWith("-c:") && arg.Length > 3) { category = arg.Substring(3).Trim(); } else if (arg.StartsWith("-t:") && arg.Length > 3) { type = arg.Substring(3).Trim(); } else if (arg.StartsWith("-f:") && arg.Length > 3) { filename = arg.Substring(3).Trim(); } else { Console.WriteLine("Invalid arguments. Type \"socat -h\" for help."); return; } } Console.WriteLine( "SoCat: Get Socrata Catalog\n" + "--------------------------\n\n" + "Domain: {0}\n" + "Category: {1}\n" + "Type: {2}\n\n" + "Getting catalog...please wait.\n", (domain == "" ? "Not specified" : domain), (category == "" ? "Not specified" : category), (type == "" ? "Not specified" : type)); var catalog = odServices.getCatalog(); if (domain != "") { catalog = catalog.Where(p => String.Equals(p.Domain, domain, StringComparison.OrdinalIgnoreCase)).ToList<CatalogItem>(); } if (category != "") { catalog = catalog.Where(p => String.Equals(p.Category, category, StringComparison.OrdinalIgnoreCase)).ToList<CatalogItem>(); } if (type != "") { catalog = catalog.Where(p => String.Equals(p.Type, type, StringComparison.OrdinalIgnoreCase)).ToList<CatalogItem>(); } try { using (CsvFileWriter writer = new CsvFileWriter(filename)) { CsvRow row = new CsvRow(); row.Add("Id"); row.Add("Name"); row.Add("Type"); row.Add("Description"); row.Add("URL"); row.Add("Category"); row.Add("Keywords"); row.Add("Agency"); row.Add("Contact Information"); row.Add("Time Period"); row.Add("Coverage"); row.Add("Posting Frequency"); row.Add("Created At"); row.Add("Updated At"); row.Add("Domain"); row.Add("View Count"); row.Add("Download Count"); row.Add("Row Count"); row.Add("Rows Updated At"); writer.WriteRow(row); foreach (var item in catalog) { row = new CsvRow(); row.Add(String.Format("{0}", item.Id)); row.Add(String.Format("{0}", item.Name)); row.Add(String.Format("{0}", item.Type)); row.Add(String.Format("{0}", item.Description)); row.Add(String.Format("{0}", item.Url)); row.Add(String.Format("{0}", item.Category)); row.Add(String.Format("{0}", item.Keywords)); row.Add(String.Format("{0}", item.Agency)); row.Add(String.Format("{0}", item.ContactInformation)); row.Add(String.Format("{0}", item.TimePeriod)); row.Add(String.Format("{0}", item.Coverage)); row.Add(String.Format("{0}", item.PostingFrequency)); row.Add(String.Format("{0:MM/dd/yyyy HH:mm:ss}", item.CreatedAt)); row.Add(String.Format("{0:MM/dd/yyyy HH:mm:ss}", item.UpdatedAt)); row.Add(String.Format("{0}", item.Domain)); row.Add(String.Format("{0}", item.ViewCount)); row.Add(String.Format("{0}", item.DownloadCount)); // Get row count and rows last updated for Tabular items only if (item.Type == "Tabular") { row.Add(String.Format("{0}", item.RowCount)); row.Add(String.Format("{0:MM/dd/yyyy HH:mm:ss}", item.RowsUpdatedAt)); } else { row.Add(""); row.Add(""); } writer.WriteRow(row); } } Console.WriteLine("\n{0} catalog items written to {1}\n", catalog.Count, filename); } catch (UnauthorizedAccessException e) { Console.WriteLine("Cannot write to: " + filename); } }
//public static ANetApiResponse Run(String ApiLoginID, String ApiTransactionKey, decimal amount) //{ // Console.WriteLine("GetAnAcceptPaymentPage Sample"); // ApiOperationBase<ANetApiRequest, ANetApiResponse>.RunEnvironment = AuthorizeNET.Environment.SANDBOX; // ApiOperationBase<ANetApiRequest, ANetApiResponse>.MerchantAuthentication = new merchantAuthenticationType() // { // name = ApiLoginID, // ItemElementName = ItemChoiceType.transactionKey, // Item = ApiTransactionKey, // }; // settingType[] settings = new settingType[2]; // settings[0] = new settingType(); // settings[0].settingName = settingNameEnum.hostedPaymentButtonOptions.ToString(); // settings[0].settingValue = "{\"text\": \"Pay\"}"; // settings[1] = new settingType(); // settings[1].settingName = settingNameEnum.hostedPaymentOrderOptions.ToString(); // settings[1].settingValue = "{\"show\": false}"; // var transactionRequest = new transactionRequestType // { // transactionType = transactionTypeEnum.authCaptureTransaction.ToString(), // authorize capture only // amount = amount // }; // var request = new getHostedPaymentPageRequest(); // request.transactionRequest = transactionRequest; // request.hostedPaymentSettings = settings; // // instantiate the contoller that will call the service // var controller = new getHostedPaymentPageController(request); // controller.Execute(); // // get the response from the service (errors contained if any) // var response = controller.GetApiResponse(); // //validate // if (response != null && response.messages.resultCode == messageTypeEnum.Ok) // { // Console.WriteLine("Message code : " + response.messages.message[0].code); // Console.WriteLine("Message text : " + response.messages.message[0].text); // Console.WriteLine("Token : " + response.token); // } // else if (response != null) // { // Console.WriteLine("Error: " + response.messages.message[0].code + " " + response.messages.message[0].text); // Console.WriteLine("Failed to get hosted payment page"); // } // return response; //} public static void GetAnAcceptPaymentPageExec(String ApiLoginID, String ApiTransactionKey) { using (CsvReader csv = new CsvReader(new StreamReader(new FileStream(@"../../../CSV_DATA/GetAnAcceptPaymentPage.csv", FileMode.Open)), true)) { int fieldCount = csv.FieldCount; //Append Data var item1 = DataAppend.ReadPrevData(); using (CsvFileWriter writer = new CsvFileWriter(new FileStream(@"../../../CSV_DATA/Outputfile.csv", FileMode.Open))) { int flag = 0; string[] headers = csv.GetFieldHeaders(); 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); } } settingType[] settings = new settingType[2]; settings[0] = new settingType(); settings[0].settingName = settingNameEnum.hostedPaymentButtonOptions.ToString(); settings[0].settingValue = "{\"text\": \"Pay\"}"; settings[1] = new settingType(); settings[1].settingName = settingNameEnum.hostedPaymentOrderOptions.ToString(); settings[1].settingValue = "{\"show\": false}"; var transactionRequest = new transactionRequestType { transactionType = transactionTypeEnum.authCaptureTransaction.ToString(), // authorize capture only amount = Convert.ToDecimal(Amount) }; var request = new getHostedPaymentPageRequest(); request.transactionRequest = transactionRequest; request.hostedPaymentSettings = settings; // instantiate the contoller that will call the service var controller = new getHostedPaymentPageController(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) { try { //Assert.AreEqual(response.Id, customerProfileId); Console.WriteLine("Assertion Succeed! Valid CustomerId fetched."); CsvRow row1 = new CsvRow(); row1.Add("GAPP-00" + flag.ToString()); row1.Add("GetAnAcceptPaymentPage"); 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("Message code : " + response.messages.message[0].code); Console.WriteLine("Message text : " + response.messages.message[0].text); Console.WriteLine("Token : " + response.token); } catch { CsvRow row1 = new CsvRow(); row1.Add("GAPP_00" + flag.ToString()); row1.Add("GetAnAcceptPaymentPage"); 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("GAPP_00" + flag.ToString()); row1.Add("GetAnAcceptPaymentPage"); 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("GAPP_00" + flag.ToString()); row2.Add("GetAnAcceptPaymentPage"); 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); } } } } }
public int BeginScrape() { List<Models.Website> websites = websiteDb.Websites.Where(x => x.Domain == HostField).ToList(); string guid = websites[0].GUID; List<Models.Filter> filters = filterDb.Filters.Where(x => x.GUID == guid).ToList(); BrowserDriver driver = new BrowserDriver(); //filters = filters.OrderBy(x => x.Id) //.ThenBy(x => x.Column).ToList(); //Orders the list so that the primarykey is first, if not specified it will organize by column string folderPath = "~/Downloads/" + guid; DirectoryInfo directory = new DirectoryInfo(HttpContext.Current.Server.MapPath(folderPath)); if (directory.Exists) { foreach (FileInfo file in directory.GetFiles()) { file.Delete(); } foreach (DirectoryInfo dir in directory.GetDirectories()) { dir.Delete(true); } directory.Delete(true); System.Threading.Thread.Sleep(1000); } directory.Create(); System.Threading.Thread.Sleep(1000); using (CsvFileWriter writer = new CsvFileWriter(directory.ToString() + "/Output.csv")) { CsvRow row = new CsvRow(); foreach (Models.Filter filter in filters.Where(x => x.Action == 0)) row.Add(filter.Column); writer.WriteRow(row); int rowindex = 2; foreach (string link in LinksField) { driver.GoTo(link); row = new CsvRow(); foreach(Models.Filter filter in filters) { bool skip = false; switch (filter.Action) { case 0: string result = driver.GetElement(filter.Selector, false); if(result != null) { string downloadlink = isFile(result); if(downloadlink != null) { DownloadFile(downloadlink, guid, rowindex, filter.Column); } foreach (Models.Filter igfilter in filterDb.Filters.Where(x => x.Action == 1)) { string ignoreexists = driver.GetElement(igfilter.Selector, true); if(ignoreexists != null) { result = result.Replace(ignoreexists, ""); } } result = Regex.Replace(result, @"\s*(?<capture><(?<markUp>\w+)>.*<\/\k<markUp>>)\s*", "${capture}", RegexOptions.Singleline); result = result.Replace("\t", ""); result = result.Replace("\r", ""); result = result.Replace("\n", ""); row.Add(result); } else { if (filter.Required) skip = true; else row.Add(""); } break; case 1://make this work for the new engine break; case 2: bool didClick = driver.Click(filter.Selector); if (!didClick) if (filter.Required) skip = true; break; default: break; } if (skip) { row = null; break; } } if (row != null) { writer.WriteRow(row); rowindex++; } } } driver.Close(); return 0; }
static void Main(string[] args) { //string dirPath = "/home/suraj/Documents/"; Aspose.Cells.Workbook workbook = new Workbook("ProductList.xlsx"); Aspose.Cells.Worksheet sheet = workbook.Worksheets[0]; int row1 = sheet.Cells.Rows.Count; int column = sheet.Cells.Columns.Count; bool Valueisgreaterthan = false, ErrorValue = false, ValueCheck = false; int increment = 0, count = 0, ErrorPoint = 0; CsvRow rowF = new CsvRow(); object[] ExcelHeaderData = new object[15] { "PID", "Product Id", "Mfr-Name", "Vendor_PN", "MfrPN", "Vendor_PN", "Cost", "Coo", "Short Description", "Long Description", "UPC", "UOM", "Sale-Start-Date", "Sale-End-Date", "Sales-Price" }; object[] CsvHeaderData = new object[15] { "PID", "Product Id", "Mfr P/N", "Mfr Name", "Vendor Name", "Vendor P/N", "Price", "COO", "Short Description", "Long Description", "UPC", "UOM", "Sale Start Date", "Sale End Date", "Sale Price" }; void WriteTest() { // Write sample data to CSV file using (CsvFileWriter writer = new CsvFileWriter("ProductList.csv")) { for (int i = 0; i < row1; i++) { CsvRow row = new CsvRow(); for (int j = 0; j < 15; j++) { // Console.WriteLine(sheet.Cells.GetCell(i, j)?.Value); if (j == 8) { ErrorPoint = j; ErrorValue = true; ++j; } if (i <= 10000) { row.Add(String.Format("{0} ", sheet.Cells.GetCell(i, j)?.Value)); } else { Valueisgreaterthan = true; } } writer.WriteRow(row); } } if (Valueisgreaterthan == true) { using (CsvFileWriter writer = new CsvFileWriter("ProductList" + increment + ".csv")) { for (int i = 10001; i < row1; i++) { CsvRow row = new CsvRow(); for (int j = 0; j < 15; j++) { if (j == 8) { ErrorPoint = j; ErrorValue = true; ++j; } if (count == 0) { i = 0; row.Add(String.Format("{0} ", sheet.Cells.GetCell(i, j)?.Value)); } if (i < 20000) { row.Add(String.Format("{0} ", sheet.Cells.GetCell(i, j)?.Value)); } else { ValueCheck = true; ++increment; } } count++; writer.WriteRow(row); } } count = 0; } if (ValueCheck == true) { using (CsvFileWriter writer = new CsvFileWriter("ProductList" + increment + ".csv")) { for (int i = 20001; i < row1; i++) { CsvRow row = new CsvRow(); for (int j = 0; j < 15; j++) { if (j == 8) { ErrorPoint = j; ErrorValue = true; ++j; } if (count == 0) { i = 0; row.Add(String.Format("{0} ", sheet.Cells.GetCell(i, j)?.Value)); } else { row.Add(String.Format("{0} ", sheet.Cells.GetCell(i, j)?.Value)); } } count++; writer.WriteRow(row); } } } if (ErrorValue == true) { using (CsvFileWriter writer = new CsvFileWriter("error.xlsx")) { for (int i = 0; i < row1; i++) { CsvRow row = new CsvRow(); for (int j = ErrorPoint; j < ErrorPoint + 1; j++) { row.Add(String.Format("{0} ", sheet.Cells.GetCell(i, j)?.Value)); } writer.WriteRow(row); } } } } WriteTest(); Console.WriteLine("Conveted into CSV file Successfully !!!!\nThanks for using this app."); }
private static void WriteGeoLocationAddresses() { if (locationAddresses_Filename != null) { using (CsvFileWriter writer = new CsvFileWriter(locationAddresses_Filename)) { foreach (string key in MapTools.locationAddresses.Keys) { Pair<string, string> address = MapTools.locationAddresses[key]; CsvRow row = new CsvRow(); // row.Add(trip.id.ToString()); // row.Add(trip.startTime.ToString()); row.Add(key); row.Add(address.First); row.Add(address.Second); writer.WriteRow(row); } } } }
private void CardScanCompleteEventHandle(object sender, EventArgs e) { string cardNumber; CardListener listener = (CardListener)sender; if (e is CardReaderScannedEventArgs) { CardReaderScannedEventArgs checkScannedEvent = e as CardReaderScannedEventArgs; cardNumber = checkScannedEvent.Message; logger.Debug("Card number: " + cardNumber); // NFC if (listener.dInfo.deviceName.Contains("VID_08FF&PID_0009")) { nfcID = cardNumber.ToLower(); if (updateNFCIDToolStripMenuItem.Checked) { frmNFCUpConfirm.getNFCCode(nfcID); } else if (manualToolStripMenuItem.Checked) { bool foundMRS = false; foreach (CsvData data in cardList) { if (data.mrsId == magneticCardID) { data.nfcId = nfcID; foundMRS = true; break; } } if (!foundMRS) { cardList.Add(new CsvData(magneticCardID, nfcID)); } // Write to CSV using (CsvFileWriter writer = new CsvFileWriter(csvFilePath)) { for (int i = 0; i < cardList.Count; i++) { CsvRow row = new CsvRow(); row.Add(cardList[i].mrsId); row.Add(cardList[i].nfcId); writer.WriteRow(row); } } } detectCardIDMethod(cardNumber); } // MRS else if (listener.dInfo.deviceName.Contains("VID_6352&PID_213A")) { magneticCardID = cardNumber; if (updateNFCIDToolStripMenuItem.Checked) { if (frmNFCUpConfirm.Visible) { frmNFCUpConfirm.Close(); } string result = serviceHandle.makeRequest(magneticCardID); if (result == "NFC not found") { frmNFCUpConfirm = new NFCCardIdUpload(magneticCardID, notifyReader); frmNFCUpConfirm.BackColor = Color.FromArgb(255, 211, 183); frmNFCUpConfirm.passControl = new NFCCardIdUpload.PassControl(serviceHandle.uploadNFCCode); frmNFCUpConfirm.Show(); detectCardIDMethod(cardNumber); } else { notifyReader.BalloonTipText = result; notifyReader.ShowBalloonTip(100); } } } } }
private static void WriteGeoRoutes() { if (routes_Filename != null) { using (CsvFileWriter writer = new CsvFileWriter(routes_Filename)) { int routeID = 0; foreach (Route r in MapTools.routes.Values) { { foreach (Waypoint w in r.waypoints) { CsvRow row = new CsvRow(); // row.Add(trip.id.ToString()); // row.Add(trip.startTime.ToString()); row.Add(routeID.ToString()); row.Add(w.Lat.ToString()); row.Add(w.Lng.ToString()); row.Add(w.elapse.ToString()); row.Add(w.distance.ToString()); row.Add(w.Address); writer.WriteRow(row); } } routeID++; } } } }
/// <summary> /// 反序列化. /// </summary> public static CsvFile Deserialize(MemoryStream stream) { int ver = FileMgr.ReadInt(stream); if (ver != CsvFileMgr.Version) { NIDebug.Log("Csv版本 {0} 错误, 最新版本 {1}", ver, CsvFileMgr.Version); return(null); } // 文件名 string name = FileMgr.ReadString(stream); CsvFile csv = new CsvFile(name); csv.primaryKey = FileMgr.ReadString(stream); // 主key类型 var pkeyType = (LPC.LPCValue.ValueType)FileMgr.ReadInt(stream); // 列名 int n = FileMgr.ReadInt(stream); csv.columns = new Dictionary <string, int>(n); for (int i = 0; i < n; i++) { string k = FileMgr.ReadString(stream); int v = FileMgr.ReadInt(stream); csv.columns.Add(k, v); } // 行数 n = FileMgr.ReadInt(stream); csv.rows = new CsvRow[n]; // 主key的列 int pkeyIdx = csv.columns[csv.primaryKey]; // 每行主key for (var i = 0; i < n; i++) { var row = new CsvRow(csv); if (pkeyType == LPCValue.ValueType.INT) { int pkey = FileMgr.ReadInt(stream); row.Add(pkeyIdx, LPCValue.Create(pkey)); } else { string pkey = FileMgr.ReadString(stream); row.Add(pkeyIdx, LPCValue.Create(pkey)); } csv.AddRow(i, row); } // 行数据 for (int i = 0; i < n; i++) { int len = FileMgr.ReadInt(stream); csv.rows[i].rowData = new byte[len]; stream.Read(csv.rows[i].rowData, 0, len); } return(csv); }
void WriteDoneFileOutHeader(CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("LongShort"); row.Add("Count"); row.Add("Rate"); row.Add("Price"); row.Add("Notional"); row.Add("LongDate"); row.Add("LongPrice"); writer.WriteRow(row); }
/// <summary> /// 序列化csv文件操作. /// </summary> public static void Save(string filePath, bool checkValid, string dir) { CsvFile csv = new CsvFile(System.IO.Path.GetFileNameWithoutExtension(filePath)); string[] lines = FileMgr.ReadLines(filePath); if (lines.Length == 0) { NIDebug.Log("空文件 {0}", lines); return; } // 解析csv文件 CsvParser cp = new CsvParser(); LPCValue m; try { cp.Load(filePath, checkValid); if (cp.Fields.Count == 0 || cp.Records.Count == 0) { return; } m = ImportMgr.Read(cp); } catch (Exception e) { NIDebug.Log("读取csv错误 {0}\n{1}", filePath, e.ToString()); return; } // 主key csv.primaryKey = cp.PrimaryKey; // 列名字对应的索引 for (int i = 0; i < cp.Fields.Count; i++) { csv.columns.Add(cp.Fields[i].name, i); } // 每列值 csv.rows = new CsvRow[m.AsArray.Count]; for (int i = 0; i < m.AsArray.Count; i++) { LPCValue v = m.AsArray[i]; CsvRow row = new CsvRow(csv); for (int idx = 0; idx < cp.Fields.Count; idx++) { row.Add(idx, v.AsMapping[cp.Fields[idx].name]); } csv.AddRow(i, row); } // 序列化 MemoryStream ms = new MemoryStream(); CsvFileMgr.Serialize(ms, csv); // 写入数据 string fileName = System.IO.Path.GetFileNameWithoutExtension(filePath); // 确保路径存在 Directory.CreateDirectory(dir); FileStream fs = new FileStream(dir + "/" + fileName + CSV_EXT, FileMode.Create, FileAccess.Write); fs.Write(ms.GetBuffer(), 0, (int)ms.Length); fs.Close(); }
void WriteRemainLongFileOutHeader(CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("Date"); row.Add("Count"); row.Add("Rate"); row.Add("Price"); row.Add("Notional"); writer.WriteRow(row); }
public void setSweep() { double[] fftFreqAverage = new double[segments.Length]; for (int i = 0; i < fftFreqAverage.Length; i++) { fftFreqAverage[i] = 0; } sweepParams = new AgSalLib.SweepParms(); sweepParams.numSweeps = 1; // 0 = sweep forever sweepParams.numSegments = (uint)segments.Length; flowControl = new AgSalLib.salFlowControl(); float maxBytesPerSec = 500e3F; flowControl.pacingPolicy = 1; flowControl.maxBacklogSeconds = 0.5F; flowControl.maxBacklogMessages = 50; flowControl.maxBytesPerSec = maxBytesPerSec; connectToSensor(); getSensorCapibilities(); pSegmentTable = new AgSalLib.FrequencySegment[segments.Length]; numPoints = (int)(fftBlockSize * freqSpan / sensorCapabilities.maxSampleRate); amplitudeData = new float[numPoints]; int firstPoint = (fftBlockSize - numPoints) / 2; for (var i = 0; i < segments.Length; i++) { //numPoints = (int)(fftBlockSize * segmentRange[i] / sensorCapabilities.maxSampleRate); //amplitudeData = new float[numPoints]; //int firstPoint = (fftBlockSize - numPoints) / 2; pSegmentTable[i].numFftPoints = (uint)fftBlockSize; pSegmentTable[i].numPoints = (uint)numPoints; pSegmentTable[i].firstPoint = (uint)firstPoint; pSegmentTable[i].centerFrequency = segments[i]; pSegmentTable[i].sampleRate = sensorCapabilities.maxSampleRate; } Console.WriteLine("323"); segmentCallback = new AgSalLib.SAL_SEGMENT_CALLBACK(callback); tempRow.Add("INT_TIME"); tempRow.Add("INT_LAT"); tempRow.Add("INT_LON"); tempRow.Add("EXT_TIME"); tempRow.Add("EXT_LAT"); tempRow.Add("EXT_LON"); }
public void SetArticleHeader() { articleRow = new CsvRow(); articleRow.Add(ArticleHeader.KeyRef); articleRow.Add(ArticleHeader.Handing); articleRow.Add(ArticleHeader.DimensionX); articleRow.Add(ArticleHeader.DimensionY); articleRow.Add(ArticleHeader.DimensionZ); articleRow.Add(ArticleHeader.IsDimensionXVariable); articleRow.Add(ArticleHeader.IsDimensionYVariable); articleRow.Add(ArticleHeader.IsDimensionZVariable); articleRow.Add(ArticleHeader.Topic); articleRow.Add(ArticleHeader.Layer); articleRow.Add(ArticleHeader.Type); articleRow.Add(ArticleHeader.BlockCode); articleRow.Add(ArticleHeader.Name); _csvFile.WriteRow(articleRow); }
/// <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; }