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