|
public WriteRow ( List |
||
| columns | List |
The list of columns to write |
| return | void | |
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 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();
}
}
private void saveButton_Click(object sender, EventArgs e)
{
FileStream aStreamForReading = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aStreamForReading);
List<string> aRecord = new List<string>();
while (aReader.ReadRow(aRecord))
{
string regNo = aRecord[0];
if (regNoTextBox.Text == regNo)
{
MessageBox.Show(@"Reg no already exists");
aStreamForReading.Close();
return;
}
}
aStreamForReading.Close();
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> aStudentRecord = new List<string>();
aStudentRecord.Add(regNoTextBox.Text);
aStudentRecord.Add(nameTextBox.Text);
aWriter.WriteRow(aStudentRecord);
aStream.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);
}
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);
}
private void saveButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> aEmployeeRecord = new List<string>();
aEmployeeRecord.Add(employeeNameTextBox.Text);
aEmployeeRecord.Add(idTextBox.Text);
aEmployeeRecord.Add(salaryAmountTextBox.Text);
aWriter.WriteRow(aEmployeeRecord);
aStream.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
FileStream aFileStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aCsvFileWriter = new CsvFileWriter(aFileStream);
List<string> aRecordList = new List<string>();
GetValue(aRecordList);
MessageBox.Show("Saved");
aCsvFileWriter.WriteRow(aRecordList);
aFileStream.Close();
}
private void button1_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> aStudentRecord = new List<string>();
aStudentRecord.Add(regNoTextBox.Text);
aStudentRecord.Add(nameTextBox.Text);
aWriter.WriteRow(aStudentRecord);
aStream.Close();
}
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);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> addressBook = new List<string>();
addressBook.Add(nameTextBox.Text);
addressBook.Add(emailTextBox.Text);
addressBook.Add(personalContactTextBox.Text);
addressBook.Add(homeContactTextBox.Text);
addressBook.Add(homeAddressTextBox.Text);
aWriter.WriteRow(addressBook);
aStream.Close();
}
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);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
FileStream aFileStream = new FileStream(fileLocation, FileMode.Open);
CsvFileReader aReader = new CsvFileReader(aFileStream);
List<string> aRecordList = new List<string>();
while (aReader.ReadRow(aRecordList))
{
string number = aRecordList[0];
if(number == txtPhoneNumber.Text)
{
MessageBox.Show("Wrong Entry");
aFileStream.Close();
return;
}
}
aFileStream.Close();
FileStream aStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aStream);
List<string> addressRecord = new List<string>();
addressRecord.Add(txtPhoneNumber.Text);
addressRecord.Add(txtName.Text);
addressRecord.Add(txtEmail.Text);
addressRecord.Add(txtAddress.Text);
addressRecord.Add(txtHomePhone.Text);
aWriter.WriteRow(addressRecord);
aStream.Close();
}
//public static ANetApiResponse Run(String ApiLoginID, String ApiTransactionKey, Decimal Amount)
//{
// Console.WriteLine("Create Android Pay Transaction Sample");
// ApiOperationBase<ANetApiRequest, ANetApiResponse>.RunEnvironment = AuthorizeNET.Environment.SANDBOX;
// // define the merchant information (authentication / transaction id)
// ApiOperationBase<ANetApiRequest, ANetApiResponse>.MerchantAuthentication = new merchantAuthenticationType()
// {
// name = ApiLoginID,
// ItemElementName = ItemChoiceType.transactionKey,
// Item = ApiTransactionKey,
// };
// //set up data based on transaction
// var opaqueData = new opaqueDataType { dataDescriptor = "COMMON.ANDROID.INAPP.PAYMENT", dataValue = "eyJkYXRhIjoiQkRQTldTdE1tR2V3UVVXR2c0bzdFXC9qKzFjcTFUNzhxeVU4NGI2N2l0amNZSTh3UFlBT2hzaGpoWlBycWRVcjRYd1BNYmo0emNHTWR5KysxSDJWa1BPWStCT01GMjV1YjE5Y1g0bkN2a1hVVU9UakRsbEIxVGdTcjhKSFp4Z3A5ckNnc1NVZ2JCZ0tmNjBYS3V0WGY2YWpcL284WkliS25yS1E4U2gwb3VMQUtsb1VNbit2UHU0K0E3V0tycXJhdXo5SnZPUXA2dmhJcStIS2pVY1VOQ0lUUHlGaG1PRXRxK0grdzB2UmExQ0U2V2hGQk5uQ0hxenpXS2NrQlwvMG5xTFpSVFliRjBwK3Z5QmlWYVdIZWdoRVJmSHhSdGJ6cGVjelJQUHVGc2ZwSFZzNDhvUExDXC9rXC8xTU5kNDdrelwvcEhEY1JcL0R5NmFVTStsTmZvaWx5XC9RSk4rdFMzbTBIZk90SVNBUHFPbVhlbXZyNnhKQ2pDWmxDdXcwQzltWHpcL29iSHBvZnVJRVM4cjljcUdHc1VBUERwdzdnNjQybTRQendLRitIQnVZVW5lV0RCTlNEMnU2amJBRzMiLCJ2ZXJzaW9uIjoiRUNfdjEiLCJoZWFkZXIiOnsiYXBwbGljYXRpb25EYXRhIjoiOTRlZTA1OTMzNWU1ODdlNTAxY2M0YmY5MDYxM2UwODE0ZjAwYTdiMDhiYzdjNjQ4ZmQ4NjVhMmFmNmEyMmNjMiIsInRyYW5zYWN0aW9uSWQiOiJjMWNhZjVhZTcyZjAwMzlhODJiYWQ5MmI4MjgzNjM3MzRmODViZjJmOWNhZGYxOTNkMWJhZDlkZGNiNjBhNzk1IiwiZXBoZW1lcmFsUHVibGljS2V5IjoiTUlJQlN6Q0NBUU1HQnlxR1NNNDlBZ0V3Z2ZjQ0FRRXdMQVlIS29aSXpqMEJBUUloQVBcL1wvXC9cLzhBQUFBQkFBQUFBQUFBQUFBQUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL01Gc0VJUFwvXC9cL1wvOEFBQUFCQUFBQUFBQUFBQUFBQUFBQVwvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cLzhCQ0JheGpYWXFqcVQ1N1BydlZWMm1JYThaUjBHc014VHNQWTd6ancrSjlKZ1N3TVZBTVNkTmdpRzV3U1RhbVo0NFJPZEpyZUJuMzZRQkVFRWF4ZlI4dUVzUWtmNHZPYmxZNlJBOG5jRGZZRXQ2ek9nOUtFNVJkaVl3cFpQNDBMaVwvaHBcL200N242MHA4RDU0V0s4NHpWMnN4WHM3THRrQm9ONzlSOVFJaEFQXC9cL1wvXC84QUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cLys4NXZxdHB4ZWVoUE81eXNMOFl5VlJBZ0VCQTBJQUJHbStnc2wwUFpGVFwva0RkVVNreHd5Zm84SnB3VFFRekJtOWxKSm5tVGw0REdVdkFENEdzZUdqXC9wc2hCWjBLM1RldXFEdFwvdERMYkUrOFwvbTB5Q21veHc9IiwicHVibGljS2V5SGFzaCI6IlwvYmI5Q05DMzZ1QmhlSEZQYm1vaEI3T28xT3NYMkora0pxdjQ4ek9WVmlRPSJ9LCJzaWduYXR1cmUiOiJNSUlEUWdZSktvWklodmNOQVFjQ29JSURNekNDQXk4Q0FRRXhDekFKQmdVckRnTUNHZ1VBTUFzR0NTcUdTSWIzRFFFSEFhQ0NBaXN3Z2dJbk1JSUJsS0FEQWdFQ0FoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQXdKekVsTUNNR0ExVUVBeDRjQUdNQWFBQnRBR0VBYVFCQUFIWUFhUUJ6QUdFQUxnQmpBRzhBYlRBZUZ3MHhOREF4TURFd05qQXdNREJhRncweU5EQXhNREV3TmpBd01EQmFNQ2N4SlRBakJnTlZCQU1lSEFCakFHZ0FiUUJoQUdrQVFBQjJBR2tBY3dCaEFDNEFZd0J2QUcwd2daOHdEUVlKS29aSWh2Y05BUUVCQlFBRGdZMEFNSUdKQW9HQkFOQzgra2d0Z212V0YxT3pqZ0ROcmpURUJSdW9cLzVNS3ZsTTE0NnBBZjdHeDQxYmxFOXc0ZklYSkFEN0ZmTzdRS2pJWFlOdDM5ckx5eTd4RHdiXC81SWtaTTYwVFoyaUkxcGo1NVVjOGZkNGZ6T3BrM2Z0WmFRR1hOTFlwdEcxZDlWN0lTODJPdXA5TU1vMUJQVnJYVFBITmNzTTk5RVBVblBxZGJlR2M4N20wckFnTUJBQUdqWERCYU1GZ0dBMVVkQVFSUk1FK0FFSFpXUHJXdEpkN1laNDMxaENnN1lGU2hLVEFuTVNVd0l3WURWUVFESGh3QVl3Qm9BRzBBWVFCcEFFQUFkZ0JwQUhNQVlRQXVBR01BYndCdGdoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQURnWUVBYlVLWUNrdUlLUzlRUTJtRmNNWVJFSW0ybCtYZzhcL0pYditHQlZRSmtPS29zY1k0aU5ERkFcL2JRbG9nZjlMTFU4NFRId05SbnN2VjNQcnY3UlRZODFncTBkdEM4elljQWFBa0NISUkzeXFNbko0QU91NkVPVzlrSmsyMzJnU0U3V2xDdEhiZkxTS2Z1U2dRWDhLWFFZdVpMazJScjYzTjhBcFhzWHdCTDNjSjB4Z2VBd2dkMENBUUV3T3pBbk1TVXdJd1lEVlFRREhod0FZd0JvQUcwQVlRQnBBRUFBZGdCcEFITUFZUUF1QUdNQWJ3QnRBaEJjbCtQZjMrVTRwazEzblZEOW53UVFNQWtHQlNzT0F3SWFCUUF3RFFZSktvWklodmNOQVFFQkJRQUVnWUJhSzNFbE9zdGJIOFdvb3NlREFCZitKZ1wvMTI5SmNJYXdtN2M2VnhuN1phc05iQXEzdEF0OFB0eSt1UUNnc3NYcVprTEE3a3oyR3pNb2xOdHY5d1ltdTlVandhcjFQSFlTK0JcL29Hbm96NTkxd2phZ1hXUnowbk1vNXkzTzFLelgwZDhDUkhBVmE4OFNyVjFhNUpJaVJldjNvU3RJcXd2NXh1WmxkYWc2VHI4dz09In0=" };
// //standard api call to retrieve response
// var paymentType = new paymentType { Item = opaqueData };
// var transactionRequest = new transactionRequestType
// {
// transactionType = transactionTypeEnum.authCaptureTransaction.ToString(), // authorize and capture transaction
// amount = Amount,
// payment = paymentType
// };
// var request = new createTransactionRequest { transactionRequest = transactionRequest };
// // instantiate the contoller that will call the service
// var controller = new createTransactionController(request);
// controller.Execute();
// // get the response from the service (errors contained if any)
// var response = controller.GetApiResponse();
// //validate
// if (response != null)
// {
// if (response.messages.resultCode == messageTypeEnum.Ok)
// {
// if(response.transactionResponse.messages != null)
// {
// Console.WriteLine("Successfully created an Android pay transaction with Transaction ID: " + response.transactionResponse.transId);
// Console.WriteLine("Response Code: " + response.transactionResponse.responseCode);
// Console.WriteLine("Message Code: " + response.transactionResponse.messages[0].code);
// Console.WriteLine("Description: " + response.transactionResponse.messages[0].description);
// }
// else
// {
// Console.WriteLine("Failed Transaction.");
// if (response.transactionResponse.errors != null)
// {
// Console.WriteLine("Error Code: " + response.transactionResponse.errors[0].errorCode);
// Console.WriteLine("Error message: " + response.transactionResponse.errors[0].errorText);
// }
// }
// }
// else
// {
// Console.WriteLine("Failed Transaction.");
// if (response.transactionResponse != null && response.transactionResponse.errors != null)
// {
// Console.WriteLine("Error Code: " + response.transactionResponse.errors[0].errorCode);
// Console.WriteLine("Error message: " + response.transactionResponse.errors[0].errorText);
// }
// else
// {
// Console.WriteLine("Error Code: " + response.messages.message[0].code);
// Console.WriteLine("Error message: " + response.messages.message[0].text);
// }
// }
// }
// else
// {
// Console.WriteLine("Null Response.");
// }
// return response;
//}
public static void CreateAnAndroidPayTransactionExec(String ApiLoginID, String ApiTransactionKey)
{
using (CsvReader csv = new CsvReader(new StreamReader(new FileStream(@"../../../CSV_DATA/CreateAnAndroidPayTransaction.csv", FileMode.Open)), true))
{
Console.WriteLine("Create Android Pay Transaction Sample");
int flag = 0;
int fieldCount = csv.FieldCount;
string[] headers = csv.GetFieldHeaders();
//Append Data
var item1 = DataAppend.ReadPrevData();
using (CsvFileWriter writer = new CsvFileWriter(new FileStream(@"../../../CSV_DATA/Outputfile.csv", FileMode.Open)))
{
while (csv.ReadNextRecord())
{
// Create Instance of Customer Api
ApiOperationBase <ANetApiRequest, ANetApiResponse> .RunEnvironment = AuthorizeNET.Environment.SANDBOX;
// define the merchant information (authentication / transaction id)
ApiOperationBase <ANetApiRequest, ANetApiResponse> .MerchantAuthentication = new merchantAuthenticationType()
{
name = ApiLoginID,
ItemElementName = ItemChoiceType.transactionKey,
Item = ApiTransactionKey,
};
string amount = null;
string TestCaseId = null;
for (int i = 0; i < fieldCount; i++)
{
switch (headers[i])
{
case "amount":
amount = csv[i];
break;
case "TestCaseId":
TestCaseId = csv[i];
break;
default:
break;
}
}
//Write to output file
CsvRow row = new CsvRow();
try
{
if (flag == 0)
{
row.Add("TestCaseId");
row.Add("APIName");
row.Add("Status");
row.Add("TimeStamp");
writer.WriteRow(row);
flag = flag + 1;
//Append Data
foreach (var item in item1)
{
writer.WriteRow(item);
}
}
//var opaqueData = new opaqueDataType { dataDescriptor = "COMMON.ANDROID.INAPP.PAYMENT", dataValue = "eyJkYXRhIjoiQkRQTldTdE1tR2V3UVVXR2c0bzdFXC9qKzFjcTFUNzhxeVU4NGI2N2l0amNZSTh3UFlBT2hzaGpoWlBycWRVcjRYd1BNYmo0emNHTWR5KysxSDJWa1BPWStCT01GMjV1YjE5Y1g0bkN2a1hVVU9UakRsbEIxVGdTcjhKSFp4Z3A5ckNnc1NVZ2JCZ0tmNjBYS3V0WGY2YWpcL284WkliS25yS1E4U2gwb3VMQUtsb1VNbit2UHU0K0E3V0tycXJhdXo5SnZPUXA2dmhJcStIS2pVY1VOQ0lUUHlGaG1PRXRxK0grdzB2UmExQ0U2V2hGQk5uQ0hxenpXS2NrQlwvMG5xTFpSVFliRjBwK3Z5QmlWYVdIZWdoRVJmSHhSdGJ6cGVjelJQUHVGc2ZwSFZzNDhvUExDXC9rXC8xTU5kNDdrelwvcEhEY1JcL0R5NmFVTStsTmZvaWx5XC9RSk4rdFMzbTBIZk90SVNBUHFPbVhlbXZyNnhKQ2pDWmxDdXcwQzltWHpcL29iSHBvZnVJRVM4cjljcUdHc1VBUERwdzdnNjQybTRQendLRitIQnVZVW5lV0RCTlNEMnU2amJBRzMiLCJ2ZXJzaW9uIjoiRUNfdjEiLCJoZWFkZXIiOnsiYXBwbGljYXRpb25EYXRhIjoiOTRlZTA1OTMzNWU1ODdlNTAxY2M0YmY5MDYxM2UwODE0ZjAwYTdiMDhiYzdjNjQ4ZmQ4NjVhMmFmNmEyMmNjMiIsInRyYW5zYWN0aW9uSWQiOiJjMWNhZjVhZTcyZjAwMzlhODJiYWQ5MmI4MjgzNjM3MzRmODViZjJmOWNhZGYxOTNkMWJhZDlkZGNiNjBhNzk1IiwiZXBoZW1lcmFsUHVibGljS2V5IjoiTUlJQlN6Q0NBUU1HQnlxR1NNNDlBZ0V3Z2ZjQ0FRRXdMQVlIS29aSXpqMEJBUUloQVBcL1wvXC9cLzhBQUFBQkFBQUFBQUFBQUFBQUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL01Gc0VJUFwvXC9cL1wvOEFBQUFCQUFBQUFBQUFBQUFBQUFBQVwvXC9cL1wvXC9cL1wvXC9cL1wvXC9cL1wvXC9cLzhCQ0JheGpYWXFqcVQ1N1BydlZWMm1JYThaUjBHc014VHNQWTd6ancrSjlKZ1N3TVZBTVNkTmdpRzV3U1RhbVo0NFJPZEpyZUJuMzZRQkVFRWF4ZlI4dUVzUWtmNHZPYmxZNlJBOG5jRGZZRXQ2ek9nOUtFNVJkaVl3cFpQNDBMaVwvaHBcL200N242MHA4RDU0V0s4NHpWMnN4WHM3THRrQm9ONzlSOVFJaEFQXC9cL1wvXC84QUFBQUFcL1wvXC9cL1wvXC9cL1wvXC9cLys4NXZxdHB4ZWVoUE81eXNMOFl5VlJBZ0VCQTBJQUJHbStnc2wwUFpGVFwva0RkVVNreHd5Zm84SnB3VFFRekJtOWxKSm5tVGw0REdVdkFENEdzZUdqXC9wc2hCWjBLM1RldXFEdFwvdERMYkUrOFwvbTB5Q21veHc9IiwicHVibGljS2V5SGFzaCI6IlwvYmI5Q05DMzZ1QmhlSEZQYm1vaEI3T28xT3NYMkora0pxdjQ4ek9WVmlRPSJ9LCJzaWduYXR1cmUiOiJNSUlEUWdZSktvWklodmNOQVFjQ29JSURNekNDQXk4Q0FRRXhDekFKQmdVckRnTUNHZ1VBTUFzR0NTcUdTSWIzRFFFSEFhQ0NBaXN3Z2dJbk1JSUJsS0FEQWdFQ0FoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQXdKekVsTUNNR0ExVUVBeDRjQUdNQWFBQnRBR0VBYVFCQUFIWUFhUUJ6QUdFQUxnQmpBRzhBYlRBZUZ3MHhOREF4TURFd05qQXdNREJhRncweU5EQXhNREV3TmpBd01EQmFNQ2N4SlRBakJnTlZCQU1lSEFCakFHZ0FiUUJoQUdrQVFBQjJBR2tBY3dCaEFDNEFZd0J2QUcwd2daOHdEUVlKS29aSWh2Y05BUUVCQlFBRGdZMEFNSUdKQW9HQkFOQzgra2d0Z212V0YxT3pqZ0ROcmpURUJSdW9cLzVNS3ZsTTE0NnBBZjdHeDQxYmxFOXc0ZklYSkFEN0ZmTzdRS2pJWFlOdDM5ckx5eTd4RHdiXC81SWtaTTYwVFoyaUkxcGo1NVVjOGZkNGZ6T3BrM2Z0WmFRR1hOTFlwdEcxZDlWN0lTODJPdXA5TU1vMUJQVnJYVFBITmNzTTk5RVBVblBxZGJlR2M4N20wckFnTUJBQUdqWERCYU1GZ0dBMVVkQVFSUk1FK0FFSFpXUHJXdEpkN1laNDMxaENnN1lGU2hLVEFuTVNVd0l3WURWUVFESGh3QVl3Qm9BRzBBWVFCcEFFQUFkZ0JwQUhNQVlRQXVBR01BYndCdGdoQmNsK1BmMytVNHBrMTNuVkQ5bndRUU1Ba0dCU3NPQXdJZEJRQURnWUVBYlVLWUNrdUlLUzlRUTJtRmNNWVJFSW0ybCtYZzhcL0pYditHQlZRSmtPS29zY1k0aU5ERkFcL2JRbG9nZjlMTFU4NFRId05SbnN2VjNQcnY3UlRZODFncTBkdEM4elljQWFBa0NISUkzeXFNbko0QU91NkVPVzlrSmsyMzJnU0U3V2xDdEhiZkxTS2Z1U2dRWDhLWFFZdVpMazJScjYzTjhBcFhzWHdCTDNjSjB4Z2VBd2dkMENBUUV3T3pBbk1TVXdJd1lEVlFRREhod0FZd0JvQUcwQVlRQnBBRUFBZGdCcEFITUFZUUF1QUdNQWJ3QnRBaEJjbCtQZjMrVTRwazEzblZEOW53UVFNQWtHQlNzT0F3SWFCUUF3RFFZSktvWklodmNOQVFFQkJRQUVnWUJhSzNFbE9zdGJIOFdvb3NlREFCZitKZ1wvMTI5SmNJYXdtN2M2VnhuN1phc05iQXEzdEF0OFB0eSt1UUNnc3NYcVprTEE3a3oyR3pNb2xOdHY5d1ltdTlVandhcjFQSFlTK0JcL29Hbm96NTkxd2phZ1hXUnowbk1vNXkzTzFLelgwZDhDUkhBVmE4OFNyVjFhNUpJaVJldjNvU3RJcXd2NXh1WmxkYWc2VHI4dz09In0=" };
var opaqueData = new opaqueDataType {
dataDescriptor = "COMMON.ANDROID.INAPP.PAYMENT", dataValue = "ewoJInB1YmxpY0tleUhhc2giICAgIDogIlNiMHFVc0tpN1UwWjMrRm1Ed2xsa205UlVEUHZhY1BDVlVUdlk3OFVwWVk9IiwKCSJ2ZXJzaW9uIjogIjEuMCIsCgkiZGF0YSIgOiAiZXdvSkltVnVZM0o1Y0hSbFpFMWxjM05oWjJVaU9pQWllVzVCZGxob1ZVODJPVEpQY0drekwxRm5aVGRhVDB4a04yVXZTMGRNVEhOdFRUaGxlR1JDVFdob1pHZFdSMjVOS3pGNGF5OUNZMkZFVFVkWFdqaGFTVWRIVTBOQlQwNXJaelpZTTB0SmFtRjFjbVpLUmpJcmFrMHdRelp2V0d0RlNqZGlXa1J4ZUhRMldXUjViVWszZEhnMk4yNTJTa3czTm5ndmFYb3JjVzR2TUhWNFIyZEJZVmw1YzNCUVdWQkZhRTVHYkZkUVYxVmxiVEV3VlZKd1NqRTVkVVJwWmtaTFVqTmFTemRNVDA4M1ZYQTRlRkF4VnpodlFWWlVOV05hV1d0MFNIWmtkMjAwUm1SV05VTmFjV0ZXZDNKcU0wcG5kRUZyTnlJc0Nna2laWEJvWlcxbGNtRnNVSFZpYkdsalMyVjVJam9nSWsxR2EzZEZkMWxJUzI5YVNYcHFNRU5CVVZsSlMyOWFTWHBxTUVSQlVXTkVVV2RCUld0V2JGQklTeXREVFdJNE5TOXhSVFY2YW1kaGNYRTFlSGgyYTBzMVdERm5WV3BQU0RKSmJrTkZWamhCUzI5TlNFbFZaamxwUkZveVFWTXhTVEZZWkhZMlEzWktOa0kyTkVoUE1UbEJhRGx6T1doSFpYQlJQVDBpTEFvSkluUmhaeUk2SUNKM1RrMW1PVzFvWVdGb1IydDFWVGdyZG5CclN6UnBVa0o1YWtWaUwzUnNla3BLYVc5RVVGRjNNMVZCUFNJS2ZRPT0iCn0="
};
var paymentType = new paymentType {
Item = opaqueData
};
var transactionRequest = new transactionRequestType
{
transactionType = transactionTypeEnum.authCaptureTransaction.ToString(), // authorize and capture transaction
amount = Convert.ToDecimal(amount),
payment = paymentType
};
var request = new createTransactionRequest {
transactionRequest = transactionRequest
};
var controller = new createTransactionController(request);
controller.Execute();
var response = controller.GetApiResponse();
if (response != null && response.messages.resultCode == messageTypeEnum.Ok &&
response.transactionResponse.messages != null)
{
try
{
//Assert.AreEqual(response.Id, customerProfileId);
Console.WriteLine("Assertion Succeed! Valid CustomerId fetched.");
CsvRow row1 = new CsvRow();
row1.Add("CAPT_00" + flag.ToString());
row1.Add("CreateAnAndroidPayTransaction");
row1.Add("Pass");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
// Console.WriteLine("Success " + TestcaseID + " CustomerID : " + response.Id);
flag = flag + 1;
Console.WriteLine("Successfully created an Android pay transaction with Transaction ID: " + response.transactionResponse.transId);
Console.WriteLine("Response Code: " + response.transactionResponse.responseCode);
Console.WriteLine("Message Code: " + response.transactionResponse.messages[0].code);
Console.WriteLine("Description: " + response.transactionResponse.messages[0].description);
}
catch
{
CsvRow row1 = new CsvRow();
row1.Add("CAPT_00" + flag.ToString());
row1.Add("CreateAnAndroidPayTransaction");
row1.Add("Assertion Failed!");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
Console.WriteLine("Assertion Failed! Invalid CustomerId fetched.");
flag = flag + 1;
}
}
else
{
CsvRow row1 = new CsvRow();
row1.Add("CAPT_00" + flag.ToString());
row1.Add("CreateAnAndroidPayTransaction");
row1.Add("Fail");
row1.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row1);
//Console.WriteLine("Assertion Failed! Invalid CustomerId fetched.");
flag = flag + 1;
}
}
catch (Exception e)
{
CsvRow row2 = new CsvRow();
row2.Add("CAPT_00" + flag.ToString());
row2.Add("CreateAnAndroidPayTransaction");
row2.Add("Fail");
row2.Add(DateTime.Now.ToString("yyyy/MM/dd" + "::" + "HH:mm:ss:fff"));
writer.WriteRow(row2);
flag = flag + 1;
Console.WriteLine(TestCaseId + " Error Message " + e.Message);
}
}
}
}
}
/// <summary>
/// Write data to .csv file, close file stream, and unsubscribe from events.
/// </summary>
void OnDisable()
{
// all data writing takes place inside using statement
using (CsvFileWriter writer = new CsvFileWriter(@"Data/" + fileName + ".csv"))
{
CsvRow header = new CsvRow();
header.Add("Trial #");
header.Add("Catch Time");
header.Add("Throw Time");
header.Add("Caught");
header.Add("Thrown");
header.Add("Hit Target");
header.Add("Score");
writer.WriteRow(header);
foreach (Data d in data)
{
CsvRow row = new CsvRow();
row.Add(d.trialNum.ToString());
row.Add(d.catchTime.ToString());
row.Add(d.throwTime.ToString());
if (d.wasCaught)
{
row.Add("yes");
}
else
{
row.Add("no");
}
if (d.wasThrown)
{
row.Add("yes");
}
else
{
row.Add("no");
}
if (d.hitTarget)
{
row.Add("yes");
}
else
{
row.Add("no");
}
row.Add(d.score.ToString());
writer.WriteRow(row);
}
writer.WriteRow(new CsvRow());
CsvRow sumheader = new CsvRow();
sumheader.Add("Level");
sumheader.Add("Score");
sumheader.Add("Successful Trials");
sumheader.Add("Total Trials");
sumheader.Add("Success Rate");
writer.WriteRow(sumheader);
string diff;
switch (GameControl.Instance.label)
{
case MenuController.SessionLabels.BASELINE:
diff = "baseline";
break;
case MenuController.SessionLabels.ACQUISITION1:
diff = "aquisition 1";
break;
case MenuController.SessionLabels.ACQUISITION2:
diff = "aquisition 2";
break;
case MenuController.SessionLabels.RETENTION:
diff = "retention";
break;
case MenuController.SessionLabels.RETENTION_DISTRACTION:
diff = "retention distraction";
break;
default:
diff = "transfer";
break;
}
CsvRow summary = new CsvRow();
summary.Add(diff);
summary.Add(finalScore.ToString());
summary.Add(numSuccesses.ToString());
summary.Add(GameControl.Instance.numTrials.ToString());
summary.Add(((float)numSuccesses / (float)GameControl.Instance.numTrials).ToString());
writer.WriteRow(summary);
}
UIController.RecordData -= AddLine;
UIController.OnTrialsComplete -= WriteSummary;
}
//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);
}
}
}
}
}
void Write_PbTLog_FileOut_Header(CsvFileWriter writer)
{
CsvRow row = new CsvRow();
//row.Add("Date");
//row.Add("Count");
//row.Add("Rate");
//row.Add("Price");
//row.Add("Notional");
//TODO
writer.WriteRow(row);
}
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 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 void buttonSave_Click(object sender, EventArgs e)
{
FileStream aFileStream = new FileStream(fileLocation, FileMode.OpenOrCreate);
CsvFileReader aReader = new CsvFileReader(aFileStream);
List <string> aRecord = new List <string>();
name = nameTextBox.Text;
email = emailTextBox.Text;
pcontact = pcontactTextBox.Text;
hcontact = hcontactTextBox.Text;
address = addressTextBox.Text;
while (aReader.ReadRow(aRecord))
{
string fileEmail = aRecord[1];
string filepContact = aRecord[2];
string filehContact = aRecord[3];
if (email == fileEmail)
{
MessageBox.Show(fileEmail + " " + "Already Existed");
aFileStream.Close();
return;
}
if (pcontact == filepContact)
{
MessageBox.Show(filepContact + " " + "Already Existed");
aFileStream.Close();
return;
}
if (hcontact == filehContact)
{
MessageBox.Show(filehContact + " " + "Already Existed");
aFileStream.Close();
return;
}
}
aFileStream.Close();
nameTextBox.Text = "";
emailTextBox.Text = "";
pcontactTextBox.Text = "";
hcontactTextBox.Text = "";
addressTextBox.Text = "";
FileStream aNewStream = new FileStream(fileLocation, FileMode.Append);
CsvFileWriter aWriter = new CsvFileWriter(aNewStream);
List <string> contactInfo = new List <string>();
contactInfo.Add(name);
contactInfo.Add(email);
contactInfo.Add(pcontact);
contactInfo.Add(hcontact);
contactInfo.Add(address);
aWriter.WriteRow(contactInfo);
aNewStream.Close();
}
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);
}
}
}
//기록들을 csv파일에 적기
public void writeTimeLine()
{
writer.WriteRow(timeLine);
Debug.Log(timeLine);
}
void WriteRowToCSV(bool sectionChange = false)
{
string id = amaiManager.GetID();
int group = amaiManager.GetGroup();
int stage = amaiManager.GetStage();
string now = System.DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss");
if (stage < 1)
{
return;
}
string csvPath = basePath + "/" + id + ".csv";
List <List <string> > dataGrid = new List <List <string> >();
if (System.IO.File.Exists(csvPath))
{
dataGrid = CsvFileReader.ReadAll(csvPath, Encoding.GetEncoding("gbk"));
}
else
{
List <string> header = new List <string>()
{
"id",
"group",
"stage",
"datetime",
"emotion_joy",
"emotion_fear",
"emotion_disgust",
"emotion_sadness",
"emotion_anger",
"emotion_surprise",
"emotion_contempt",
"emotion_valence",
"emotion_engagement",
"expression_smile",
"music_valence_initial",
"music_valence_overall",
"music_section_change"
};
dataGrid.Add(header);
}
CsvFileWriter writer = new CsvFileWriter(csvPath);
List <string> row = new List <string> ()
{
id,
group.ToString(),
stage.ToString(),
now,
currentJoy.ToString(),
currentFear.ToString(),
currentDisgust.ToString(),
currentSadness.ToString(),
currentAnger.ToString(),
currentSurprise.ToString(),
currentContempt.ToString(),
currentValence.ToString(),
currentEngagement.ToString(),
currentSmile.ToString(),
initialValence.ToString(),
overallValence.ToString(),
sectionChange ? "1" : "0"
};
//writer.WriteRow (row);
//writer.Dispose ();
dataGrid.Add(row);
//CsvFileWriter.WriteAll (dataGrid, csvPath, Encoding.GetEncoding("utf-32"));
foreach (List <string> r in dataGrid)
{
writer.WriteRow(r);
}
writer.Dispose();
}
private void ExecutionProgress(string service, AnalysisExecutionProgressEventArgs ea)
{
if (_cancelFlag)
{
ea.Cancel = true;
return;
}
if (ea.Status == AnalysisExecutionStatus.Canceled)
{
MessageBox.Show(ea.Reason, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
_cancelFlag = true;
return;
}
if (ea.Status == AnalysisExecutionStatus.Processed || ea.Status == AnalysisExecutionStatus.Failed)
{
WriteDebugInfo("Got the {0} progress event from {1}. Total documents: {2}\tProcessed: {3}\tFailed:{4}", ea.Progress, service, ea.TotalDocuments, ea.ProcessedDocuments, ea.FailedDocuments);
SetControlPropertyThreadSafe(pbMechanicalTurk, "Value", ea.Progress);
}
if (ea.Status == AnalysisExecutionStatus.Success)
{
WriteDebugInfo("All documents have been sent for processing. Sent documents: {0} Failed documents: {1}", ea.ProcessedDocuments, ea.FailedDocuments);
bool hasComplianceScore = _documents.Any(item => item.Value.HasReferencePolarity());
if (hasComplianceScore)
{
NormalizeResultSet(_documents);
}
string outputFile = GetControlPropertyThreadSafe(tbSource, "Text") as string;
try
{
using (CsvFileWriter writter = new CsvFileWriter(outputFile))
{
List <string> columns = new List <string>();
columns.Add("Document ID");
IList <string> services = _documents.First().Value.GetServices();
foreach (string item in services)
{
if (item == "MechanicalTurk")
{
columns.AddRange(new List <string>()
{
string.Format("{0} Polarity", item),
string.Format("{0} Confidence Score", item)
});
}
else if (item == "Bitext")
{
columns.AddRange(new List <string>()
{
string.Format("{0} Polarity", item),
string.Format("{0} Average Sentiment Score", item)
});
}
else if (item == "Viralheat")
{
columns.AddRange(new List <string>()
{
string.Format("{0} Polarity", item),
string.Format("{0} Probability Score", item)
});
}
else
{
columns.AddRange(new List <string>()
{
string.Format("{0} Polarity", item),
string.Format("{0} Sentiment Score", item)
});
}
}
columns.Add("Source text");
writter.WriteRow(columns);
foreach (KeyValuePair <string, ResultSet> data in _documents)
{
columns = new List <string>();
columns.Add(data.Key);
foreach (string srvc in services)
{
ResultSet results = data.Value;
columns.Add(results.GetPolarity(srvc));
columns.Add(results.GetScore(srvc).ToString("F"));
}
columns.Add(data.Value.Source);
writter.WriteRow(columns);
}
}
}
catch (IOException ex)
{
MessageBox.Show("Looks like the file is in use. Close another program that locks the file.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
WriteDebugInfo("IO Exception: {0}", ex.Message);
}
WriteDebugInfo("The output file is written!");
SetControlPropertyThreadSafe(btClose, "Enabled", true);
SetControlPropertyThreadSafe(btProcess, "Text", "Process");
SetControlPropertyThreadSafe(pbMechanicalTurk, "Value", 0);
MessageBox.Show("Analysis is done! Check the output file for results.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void Save(string name, SecurityId securityId, object nativeId)
{
DelayAction.DefaultGroup.Add(() =>
{
var fileName = Path.Combine(_path, name + ".csv");
var appendHeader = !File.Exists(fileName);
using (var writer = new CsvFileWriter(new TransactionFileStream(fileName, FileMode.Append)))
{
var nativeIdType = nativeId.GetType();
var typleType = nativeIdType.GetGenericType(typeof(Tuple <,>));
if (appendHeader)
{
if (typleType == null)
{
writer.WriteRow(new[]
{
"Symbol",
"Board",
GetTypeName(nativeIdType),
});
}
else
{
dynamic tuple = nativeId;
writer.WriteRow(new[]
{
"Symbol",
"Board",
GetTypeName((Type)tuple.Item1.GetType()),
GetTypeName((Type)tuple.Item2.GetType()),
});
}
}
if (typleType == null)
{
writer.WriteRow(new[]
{
securityId.SecurityCode,
securityId.BoardCode,
nativeId.ToString()
});
}
else
{
dynamic tuple = nativeId;
writer.WriteRow(new[]
{
securityId.SecurityCode,
securityId.BoardCode,
(string)tuple.Item1.ToString(),
(string)tuple.Item2.ToString()
});
}
}
}, canBatch: false);
}
/// <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;
}
public virtual void WriteRow()
{
CurrentRowCompleted = true;
csvWriter.WriteRow(Row);
}
// 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);
}
}
}
}
}
/// @brief 인테리어 정보 저장 함수
/// @return 없음
/// @param 없음
public void save()
{
#region 1. 바닥 정보 저장
using (var writer = new CsvFileWriter("Assets/Resources/SaveFiles/floor.csv"))
//using (var writer = new CsvFileWriter(sourceDir))
//var writer = new CsvFileWriter(sourceDir);
{
// columns.Add("str"); // 수차례
// writer.WriteRow(columns);
// columns.Clear();
// 이상 반복으로 행 채워넣기
List <string> columns = new List <string>();
// 1층. 2~3층 추후 추가 예정
FieldManager FM = FC.Floor[0].GetComponent <FieldManager>();
// 각 타일을 순회하며 놓여진 오브젝트의 정보를 저장
for (int i = 0; i < FM.field.GetLength(0); i++)
{
for (int j = 0; j < FM.field.GetLength(1); j++)
{
ArrangeablePosState APS = FM.field[i, j].GetComponent <ArrangeablePosState>();
string str = null;
// 타일 정보 가져오기
str += APS.getTile() + "/";
// 오브젝트의 시리얼번호 가져오기
GameObject obj = FM.field[i, j].GetComponent <ArrangeablePosState>().putHere;
if (obj == null)
{ // 오브젝트 없이 타일 정보만 저장
}
else
{
// Serial numb
string serial = obj.GetComponent <SerialNumbManager>().getSerialNumb();
str += serial + "/";
// Rotate state
string rotate = obj.GetComponent <FurnitureManager>().getRotateState().ToString();
str += rotate;
}
columns.Add(str);
}
writer.WriteRow(columns);
columns.Clear();
}
}
#endregion
#region 2. 벽 정보 저장
using (var writer = new CsvFileWriter("Assets/Resources/SaveFiles/wall.csv"))
//writer = new CsvFileWriter("Assets/Resources/SaveFiles/wall.csv");
{
// columns.Add("str"); // 수차례
// writer.WriteRow(columns);
// columns.Clear();
// 이상 반복으로 행 채워넣기
List <string> columns = new List <string>();
// 1층. 2~3층 추후 추가 예정
FieldManager FM = FC.Floor[0].GetComponent <FieldManager>();
#region leftWall save process
// 각 타일을 순회하며 놓여진 오브젝트의 정보를 저장
for (int i = 0; i < FM.leftWall.GetLength(1); i++)
{
for (int j = 0; j < FM.leftWall.GetLength(0); j++)
{
// active가 false 인 벽에 대해서는 저장하는 과정을 생략한다.
if (!FM.leftWall[j, i].activeSelf)
{
continue;
}
ArrangeablePosState APS = FM.leftWall[j, i].GetComponent <ArrangeablePosState>();
string str = null;
// 타일 정보 가져오기
str += APS.getTile() + "/";
// 오브젝트의 시리얼번호 가져오기
GameObject obj = FM.leftWall[j, i].GetComponent <ArrangeablePosState>().putHere;
if (obj == null)
{ // 오브젝트 없이 타일 정보만 저장
}
else
{
// Serial numb
string serial = obj.GetComponent <SerialNumbManager>().getSerialNumb();
str += serial;
}
columns.Add(str);
Debug.Log("wall add");
}
writer.WriteRow(columns);
columns.Clear();
}
#endregion
#region rightWall save process
// 각 타일을 순회하며 놓여진 오브젝트의 정보를 저장
for (int i = 0; i < FM.rightWall.GetLength(0); i++)
{
for (int j = 0; j < FM.rightWall.GetLength(1); j++)
{
// active가 false 인 벽에 대해서는 저장하는 과정을 생략한다.
if (!FM.rightWall[i, j].activeSelf)
{
continue;
}
ArrangeablePosState APS = FM.rightWall[i, j].GetComponent <ArrangeablePosState>();
string str = null;
// 타일 정보 가져오기
str += APS.getTile() + "/";
// 오브젝트의 시리얼번호 가져오기
GameObject obj = FM.rightWall[i, j].GetComponent <ArrangeablePosState>().putHere;
if (obj == null)
{ // 오브젝트 없이 타일 정보만 저장
}
else
{
// Serial numb
string serial = obj.GetComponent <SerialNumbManager>().getSerialNumb();
str += serial;
}
columns.Add(str);
}
writer.WriteRow(columns);
columns.Clear();
}
#endregion
// right wall에 대해서 좌우반전 시행
// target.GetComponent<Transform>().localScale = new Vector3(-1, 1, 1);
}
#endregion
Debug.Log("save done");
}
public List<string> ImportReferral(string serverPath, Stream stream, string destinationPath, string filename,
int campaignId,
int userId, string ip_address, out ImportReferralHistory history)
{
try
{
history = new ImportReferralHistory();
List<Tuple<string, string>> listUsers = new List<Tuple<string, string>>();
string savedFile = destinationPath + filename;
List<string> builderErrors = new List<string>(); ;
List<Tuple<int, string>> listValidUsername = new List<Tuple<int, string>>();
List<string> listInValidUsername = new List<string>();
using (CsvFileReader reader = new CsvFileReader(stream))
{
CsvRow row = new CsvRow();
int rowNumber = 1;
List<string> username = new List<string>();
using (CsvFileWriter writer = new CsvFileWriter(savedFile))
{
while (!reader.EndOfStream)
{
var errorMsg = reader.CheckValidRow(row, rowNumber == 1, ref username);
if (!string.IsNullOrEmpty(errorMsg))
builderErrors.Add(string.Format("Line {0}: {1}", rowNumber, errorMsg));
else if (username != null && username.Any())
{
foreach (var item in username)
{
if (!listValidUsername.Select(t => t.Item2).Contains(item) && !listInValidUsername.Contains(item))
{
var id = GetIdByUsername(item);
if (id > 0)
listValidUsername.Add(new Tuple<int, string>(id, item));
else
{
listInValidUsername.Add(item);
builderErrors.Add(string.Format("Line {0}: {1} is invalid username", rowNumber, item));
}
}
}
listUsers.Add(new Tuple<string, string>(username[0], username[1]));
}
else if (rowNumber != 1 && !username.Any())
{
builderErrors.Add(string.Format("Line {0}: This row is empty", rowNumber));
}
rowNumber++;
reader.ReadRow(row);
writer.WriteRow(row);
}
}
}
if (builderErrors != null && builderErrors.Any())
return builderErrors;
string filePath = savedFile.Replace(serverPath, "\\");
if (string.IsNullOrEmpty(filePath))
{
builderErrors.Add(ErrorCodes.SAVE_FILE_ERROR.ToErrorMessage());
return builderErrors;
}
#region Save data to DB
var repo = Repo.Instance;
using (var db = repo.OpenConnectionFromPool())
{
ReferralCampaign referralCampaign = repo.GetReferralCampaign(db
, new List<int>() { (int)ReferralCampaignStatus.Running, (int)ReferralCampaignStatus.Finished }
, campaignId);
if (referralCampaign == null)
{
builderErrors.Add(ErrorCodes.INVALID_REFERRAL_CAMPAIGN.ToErrorMessage());
return builderErrors;
}
//if (repo.CountRecordDownloadHistory(db, referralCampaign.id) + listUsers.Count() > referralCampaign.quantity)
//{
// builderErrors.Add(ErrorCodes.REFERRAL_CAMPAIGN_QUANTITY_IS_OVER.ToErrorMessage());
// return builderErrors;
//}
List<Tuple<string, string, string>> listFail = new List<Tuple<string, string, string>>();
foreach (var row in listUsers)
{
var uid = listValidUsername.FirstOrDefault(u => string.Compare(u.Item2, row.Item1, true) == 0).Item1;
string error = ImportUserRerralCampaigns(repo, db, uid, referralCampaign.game_id, row.Item1, row.Item2, ip_address, referralCampaign);
if (!string.IsNullOrEmpty(error))
{
listFail.Add(new Tuple<string, string, string>(row.Item1, row.Item2, error));
}
}
string failData = string.Empty;
if (listFail.Any())
{
failData = SaveFailedImportResult(destinationPath, filename, listFail);
}
ImportReferralResult importResult = new ImportReferralResult
{
failed = listFail.Count(),
file_path = !string.IsNullOrEmpty(failData)
? failData.Replace(serverPath, "\\")
: string.Empty,
pass = listUsers.Count() - listFail.Count(),
total = listUsers.Count()
};
//TODO: need to consider about the case when 100% is fail from VV api
CustomerAccount creator = repo.GetCustomerById(db, userId).Data;
history = new ImportReferralHistory
{
file_name = filename,
file_path = filePath,
game_id = referralCampaign.game_id, //TODO: can remove
importer_username = creator.username,
result = JsonConvert.SerializeObject(importResult),
referral_campaign_id = campaignId
};
history.id = repo.CreateImportReferralHistory(db, history);
return null;
}
#endregion
}
catch (Exception ex)
{
logger.Fatal("ImportReferral: " + ex.ToString());
history = null;
return new List<string>() { ErrorCodes.SYSTEM_ERROR.ToErrorMessage() };
}
}
/// <inheritdoc />
protected override void Write(CsvFileWriter writer, ExecutionMessage data, IMarketDataMetaInfo metaInfo)
{
var row = new[]
{
data.ServerTime.WriteTimeMls(),
data.ServerTime.ToString("zzz"),
data.TransactionId.ToString(),
data.OriginalTransactionId.ToString(),
data.OrderId.ToString(),
data.OrderStringId,
data.OrderBoardId,
data.UserOrderId,
data.OrderPrice.ToString(),
data.OrderVolume.ToString(),
data.Balance.ToString(),
data.VisibleVolume.ToString(),
data.Side.ToString(),
data.OriginSide.ToString(),
data.OrderState.ToString(),
data.OrderType.ToString(),
data.TimeInForce.ToString(),
data.TradeId.ToString(),
data.TradeStringId,
data.TradePrice.ToString(),
data.TradeVolume.ToString(),
data.PortfolioName,
data.ClientCode,
data.BrokerCode,
data.DepoName,
data.IsSystem.ToString(),
data.HasOrderInfo.ToString(),
data.HasTradeInfo.ToString(),
data.Commission.ToString(),
data.Currency.ToString(),
data.Comment,
data.SystemComment,
/*data.DerivedOrderId.ToString()*/ string.Empty,
/*data.DerivedOrderStringId*/ string.Empty,
data.IsUpTick.ToString(),
/*data.IsCancellation.ToString()*/ string.Empty,
data.OpenInterest.ToString(),
data.PnL.ToString(),
data.Position.ToString(),
data.Slippage.ToString(),
data.TradeStatus.ToString(),
data.OrderStatus.ToString(),
data.Latency?.Ticks.ToString(),
data.Error?.Message,
data.ExpiryDate?.WriteDate(),
data.ExpiryDate?.WriteTimeMls(),
data.ExpiryDate?.ToString("zzz"),
data.LocalTime.WriteTimeMls(),
data.LocalTime.ToString("zzz"),
data.IsMarketMaker.ToString(),
data.CommissionCurrency,
data.IsMargin.ToString(),
data.IsManual.ToString(),
data.MinVolume.To <string>(),
data.PositionEffect.To <string>(),
data.PostOnly.To <string>(),
data.Initiator.To <string>(),
data.SeqNum.To <string>(),
};
writer.WriteRow(row);
metaInfo.LastTime = data.ServerTime.UtcDateTime;
}
private void Application_Exit(object sender, ExitEventArgs e)
{
if (Timethread != null)
{
Timethread.Abort();
}
if (checkFile != null)
{
this.checkFile.Abort();
}
Alarms.Write(_FILE_Alarm_Data, DataAlarm);
Users.write(_FILE_User_Data, DataUser);
Cameras.Write(_FILE_Camera_Data, DataCamera);
// Map.Write(_FILE_Map_Data, Map);
Presets.Write(_FILE_PRESET_DATA, DataPreset);
// Config.Write(_FILE_Config, setting);
if (m_bInitSDK == true)
{
CHCNetSDK.NET_DVR_Cleanup();
}
using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_CSV_COMMAND, FileMode.Append), Encoding.UTF8))
{
for (int i = 0; i < Rows.Count; i++)
{
LogCSV.WriteRow(Rows[i]);
}
}
using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_Send_COMMAND, FileMode.Append), Encoding.UTF8))
{
for (int i = 0; i < RowsSend.Count; i++)
{
LogCSV.WriteRow(RowsSend[i]);
}
}
//VlcContext.CloseAll();
}
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("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);
}
}
}
}
}
/// <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 + "TrialAttempt" + attemptNum + ".csv"))
{
Debug.Log("Writing trial data to file");
// write header
CsvRow header = new CsvRow();
header.Add("Time");
header.Add("Trial Number");
header.Add("Score");
header.Add("Time Fruit Spent Falling");
header.Add("Caught fruit?");
header.Add("COP X");
header.Add("COP Y");
header.Add("Spawn Location Difficulty");
header.Add("User Size Difficulty");
header.Add("Fall Speed Difficulty");
header.Add("User Sensitivity Difficulty");
header.Add("Fruit Size Difficulty");
header.Add("Spawn Frequency Difficulty");
header.Add("Exploration Mode");
writer.WriteRow(header);
// write each line of data
foreach (TrialData d in trialData)
{
CsvRow row = new CsvRow();
row.Add(d.time.ToString());
row.Add(d.trialNum.ToString());
row.Add(d.score.ToString());
row.Add(d.timeSinceSpawned.ToString());
if (d.caught)
{
row.Add("YES");
}
else
{
row.Add("NO");
}
row.Add(d.CoP.x.ToString());
row.Add(d.CoP.y.ToString());
row.Add(GlobalControl.Instance.DifficultyToString(d.spawnDif));
row.Add(GlobalControl.Instance.DifficultyToString(d.userSizeDif));
row.Add(GlobalControl.Instance.DifficultyToString(d.fallSpeedDif));
row.Add(GlobalControl.Instance.DifficultyToString(d.userSensitivityDif));
row.Add(GlobalControl.Instance.DifficultyToString(d.fruitSizeDif));
row.Add(GlobalControl.Instance.DifficultyToString(d.spawnFrequencyDif));
if (GlobalControl.Instance.explorationMode == GlobalControl.ExplorationMode.NONE)
{
row.Add("NONE");
}
else
{
row.Add("FORCED");
}
writer.WriteRow(row);
}
}
}
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);
}
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 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);
}
}
}
}
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);
}
}
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 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);
}
}
}
}
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 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);
}
}
}
}
//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);
}
}
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++;
}
}
}
}
private void Save(string name, SecurityId securityId, object nativeId)
{
CultureInfo.InvariantCulture.DoInCulture(() =>
{
var fileName = Path.Combine(_path, name + ".csv");
var appendHeader = !File.Exists(fileName);
using (var stream = new FileStream(fileName, FileMode.Append, FileAccess.Write))
using (var writer = new CsvFileWriter(stream))
{
var nativeIdType = nativeId.GetType();
var typleType = nativeIdType.GetGenericType(typeof(Tuple <,>));
if (appendHeader)
{
if (typleType == null)
{
writer.WriteRow(new[]
{
"Symbol",
"Board",
GetTypeName(nativeIdType),
});
}
else
{
dynamic tuple = nativeId;
writer.WriteRow(new[]
{
"Symbol",
"Board",
GetTypeName((Type)tuple.Item1.GetType()),
GetTypeName((Type)tuple.Item2.GetType()),
});
}
}
if (typleType == null)
{
writer.WriteRow(new[]
{
securityId.SecurityCode,
securityId.BoardCode,
nativeId.ToString()
});
}
else
{
dynamic tuple = nativeId;
writer.WriteRow(new[]
{
securityId.SecurityCode,
securityId.BoardCode,
(string)tuple.Item1.ToString(),
(string)tuple.Item2.ToString()
});
}
}
});
}
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);
}
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);
}
}
}
}
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 WriteToFile()
{
Directory.CreateDirectory(@"Data/" + pid);
using (CsvFileWriter writer = new CsvFileWriter(@"Data/" + pid + "/IKData" + pid + ".csv"))
{
Debug.Log("Writing IK Recording to file");
// 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");
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.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);
}
}
}
void WriteHeader(CsvFileWriter writer)
{
CsvRow row = new CsvRow();
row.Add("CurDate");
row.Add("KospiWeight");
writer.WriteRow(row);
}
private void processToExportData()
{
//check if a valid export file has been selected
if (string.IsNullOrEmpty(txtBoxExportDataExportFolder.Text))
{
MessageBox.Show("Must select an export file.", "Warning Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string filename = txtBoxExportDataExportFolder.Text;
progBarExportData.Visible = true;
progBarExportData.Minimum = 1;
progBarExportData.Value = 1;
progBarExportData.Step = 1;
try
{
ICollection <KeyValuePair <String, bool> > selectedRows = new Dictionary <String, bool>();
if (chkBoxExportDataRes1.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_1.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_1.Text, chkBoxExportDataRes1.Checked));
}
if (chkBoxExportDataRes2.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_2.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_2.Text, chkBoxExportDataRes2.Checked));
}
if (chkBoxExportDataRes3.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_3.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_3.Text, chkBoxExportDataRes3.Checked));
}
if (chkBoxExportDataRes4.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_4.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_4.Text, chkBoxExportDataRes4.Checked));
}
if (chkBoxExportDataRes5.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_5.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_5.Text, chkBoxExportDataRes5.Checked));
}
if (chkBoxExportDataRes6.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_6.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_6.Text, chkBoxExportDataRes6.Checked));
}
if (chkBoxExportDataRes7.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_7.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_7.Text, chkBoxExportDataRes7.Checked));
}
if (chkBoxExportDataRes8.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_8.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_8.Text, chkBoxExportDataRes8.Checked));
}
if (chkBoxExportDataRes9.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_9.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_9.Text, chkBoxExportDataRes9.Checked));
}
if (chkBoxExportDataRes10.Checked && !string.IsNullOrEmpty(lnklblExportDataPersonId_10.Text))
{
selectedRows.Add(new KeyValuePair <string, bool>(lnklblExportDataPersonId_10.Text, chkBoxExportDataRes10.Checked));
}
if (selectedRows.Count < 1)
{
MessageBox.Show("Must select one or more record(s) from the table below.", "Warning Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (chkBoxExportDataSelectAll.Checked)
{
DialogResult dr = MessageBox.Show("All records will will be exported. Do you want to continue?", "Warning Message", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
}
progBarExportData.Maximum = selectedRows.Count;
activityLog.setActivity("Batch Export to a file - " + filename + ". Totall record exported = " + selectedRows.Count + "\n");
using (var writer = new CsvFileWriter(filename))
{
progBarExportData.PerformStep();
//add the headers
List <string> columns = new List <string>();
columns.Add("Person Id");
columns.Add("First Name");
columns.Add("Last Name");
columns.Add("Middle Name");
columns.Add("Prefix");
columns.Add("Suffix");
columns.Add("DOB");
columns.Add("Street");
columns.Add("City");
columns.Add("State");
columns.Add("Postal Code");
columns.Add("Country");
columns.Add("Profession");
columns.Add("Father Name");
columns.Add("Cell Nbr");
columns.Add("Home Nbr");
columns.Add("Work Nbr");
columns.Add("Email");
columns.Add("Photo");
columns.Add("RT");
columns.Add("RI");
columns.Add("RM");
columns.Add("RR");
columns.Add("RL");
columns.Add("LT");
columns.Add("LI");
columns.Add("LM");
columns.Add("LR");
columns.Add("LL");
writer.WriteRow(columns);
foreach (KeyValuePair <string, bool> selectedRow in selectedRows)
{
progBarExportData.PerformStep();
string personId = selectedRow.Key;
bool rowSelected = selectedRow.Value;
PersonDetail personDetail = getPersonDetail(personId);
MyPerson person = new DataAccess().retrievePersonFingerprintsById(personId).FirstOrDefault();
List <Fingerprint> fingerprints = person.Fingerprints;
columns = new List <string>();
columns.Add(personDetail.getPersonId() ?? String.Empty);
columns.Add(personDetail.getFirstName() ?? String.Empty);
columns.Add(personDetail.getLastName() ?? String.Empty);
columns.Add(personDetail.getMiddleName() ?? String.Empty);
columns.Add(personDetail.getPrefix() ?? String.Empty);
columns.Add(personDetail.getSuffix() ?? String.Empty);
columns.Add(personDetail.getDOB().ToString() ?? String.Empty);
columns.Add(personDetail.getStreetAddress() ?? String.Empty);
columns.Add(personDetail.getCity() ?? String.Empty);
columns.Add(personDetail.getState() ?? String.Empty);
columns.Add(personDetail.getPostalCode() ?? String.Empty);
columns.Add(personDetail.getCountry() ?? String.Empty);
columns.Add(personDetail.getProfession() ?? String.Empty);
columns.Add(personDetail.getFatherName() ?? String.Empty);
columns.Add(personDetail.getCellNbr() ?? String.Empty);
columns.Add(personDetail.getHomePhoneNbr() ?? String.Empty);
columns.Add(personDetail.getWorkPhoneNbr() ?? String.Empty);
columns.Add(personDetail.getEmail() ?? String.Empty);
//Passport photo
System.Drawing.Image photo = personDetail.getPassportPhoto();
string photoStr = (photo != null) ? Program.ImageToBase64(personDetail.getPassportPhoto(), System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(photoStr ?? String.Empty);
//RT fingerprint
System.Drawing.Image rT = getFingerprintImage(fingerprints, MyFingerprint.RightThumb);
string rTStr = (rT != null) ? Program.ImageToBase64(rT, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(rTStr ?? String.Empty);
//RI fingerprint
System.Drawing.Image rI = getFingerprintImage(fingerprints, MyFingerprint.RightIndex);
string rIStr = (rI != null) ? Program.ImageToBase64(rI, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(rIStr ?? String.Empty);
//RM fingerprint
System.Drawing.Image rM = getFingerprintImage(fingerprints, MyFingerprint.RightMiddle);
string rMStr = (rM != null) ? Program.ImageToBase64(rM, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(rMStr ?? String.Empty);
//RR fingerprint
System.Drawing.Image rR = getFingerprintImage(fingerprints, MyFingerprint.RightRing);
string rRStr = (rR != null) ? Program.ImageToBase64(rR, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(rRStr ?? String.Empty);
//RL fingerprint
System.Drawing.Image rL = getFingerprintImage(fingerprints, MyFingerprint.RightLittle);
string rLStr = (rL != null) ? Program.ImageToBase64(rL, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(rLStr ?? String.Empty);
//LT fingerprint
System.Drawing.Image lT = getFingerprintImage(fingerprints, MyFingerprint.LeftThumb);
string lTStr = (lT != null) ? Program.ImageToBase64(lT, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(lTStr ?? String.Empty);
//LI fingerprint
System.Drawing.Image lI = getFingerprintImage(fingerprints, MyFingerprint.LeftIndex);
string lIStr = (lI != null) ? Program.ImageToBase64(lI, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(lIStr ?? String.Empty);
//LM fingerprint
System.Drawing.Image lM = getFingerprintImage(fingerprints, MyFingerprint.LeftMiddle);
string lMStr = (lM != null) ? Program.ImageToBase64(lM, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(lMStr ?? String.Empty);
//LR fingerprint
System.Drawing.Image lR = getFingerprintImage(fingerprints, MyFingerprint.LeftRing);
string lRStr = (lR != null) ? Program.ImageToBase64(lR, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(lRStr ?? String.Empty);
//LL fingerprint
System.Drawing.Image lL = getFingerprintImage(fingerprints, MyFingerprint.LeftLittle);
string lLStr = (lL != null) ? Program.ImageToBase64(lL, System.Drawing.Imaging.ImageFormat.Bmp) : null;
columns.Add(lLStr ?? String.Empty);
writer.WriteRow(columns);
}//end foreach
}
//set the status - exportcomplete
lblExportDataStatus.Text = "Export Complete.";
}
catch (Exception ex)
{
Console.WriteLine("###-->> Exception = " + ex.StackTrace);
MessageBox.Show(String.Format("Error writing to {0}.\r\n\r\n{1}", filename, ex.Message));
}
finally
{
Cursor = Cursors.Default;
}
}//end processToExportData
//Add a stater to the stater list.
private void addStaterToStaterListToolStripMenuItem_Click(object sender, EventArgs e)
{
createStaterObjects();
Form3 form3 = new Form3();
if (form3.ShowDialog() == DialogResult.OK)
{
staters.Add(new Stater(form3.firstName, form3.lastName));
staters[staters.Count - 1].Barcode = form3.pin;
staters[staters.Count - 1].City = form3.city;
staters[staters.Count - 1].County = form3.county;
string filePath = loadStaterList();
using (CsvFileWriter writer = new CsvFileWriter(filePath))
{
foreach (Stater s in staters)
{
CsvRow row = new CsvRow() { s.Barcode.ToString(), s.FirstName, s.LastName, s.City, s.County };
writer.WriteRow(row);
}
}
createStaterObjects();
if (programRunning != "")
{
Picture.Text += form3.pin + "\n";
Picture.Focus();
Picture.SelectionStart = Picture.Text.Length + 1;
SendKeys.Send("{ENTER}");
}
}
}
public static void _ExecuteSelect(int timeout, IDbConnection conn, string cmdText, string tableName)
{
DateTime started = DateTime.Now;
IDataReader reader = null;
IDbCommand cmd = null;
bool bConnOpenedHere = HelperFunctions.EnsureConnectionOpen(conn);
IDbTransaction transaction = conn.BeginTransaction();
// DataSet retv = new DataSet();
try
{
cmd = conn.CreateCommand();
cmd.CommandTimeout = timeout;
cmd.Transaction = transaction;
cmd.CommandText = cmdText;
/*
* DbType[] reqLenTypes = new DbType[] { DbType.AnsiString, DbType.AnsiStringFixedLength, DbType.String, DbType.StringFixedLength, DbType.Binary, DbType.Object, DbType.Xml };
* for (int i = 0; i < paramList.Length; i++)
* {
* IDbDataParameter idb = cmd.CreateParameter();
* cmd.Parameters.Add(HelperFunctions.BuildParameter(idb, paramList[i]));
* if (reqLenTypes.Contains(idb.DbType))
* {
* if (idb is OdbcParameter)
* {
* (idb as OdbcParameter).Size = paramList[i].Size;
* }
* }
* }
*
*/
DataTable dt;
reader = cmd.ExecuteReader();
string retStr = string.Empty;
if (reader.FieldCount > 0)
{
dt = new DataTable(tableName);
// retv.Tables.Add(dt = new DataTable(tableName));
// retv.Tables.Add(reader.GetSchemaTable());
DataTable schemaTable = reader.GetSchemaTable();
Helpers.DataTableExtensions.WriteToCsvFile(schemaTable, string.Format("{0}{1}.{2}", cBaseSqlDir, tableName + "_schema", cFileExt));
CsvFileWriter csvFileWriter = new CsvFileWriter(string.Format("{0}{1}.{2}", cBaseSqlDir, tableName + "_data", cFileExt));
bool columnsBuilt = false;
while (reader.Read())
{
if (columnsBuilt == false)
{
HelperFunctions.BuildColumnData(dt, reader);
columnsBuilt = true;
}
// Old Function but Memory Exhausted
// HelperFunctions.AddDataRow(dt, reader);
// New Function write every row
CsvRow row = new CsvRow();
HelperFunctions.AddDataRowCSVWriter(row, reader);
csvFileWriter.WriteRow(row);
}
retStr += string.Format("Count:{0}=Columns:{1},Rows:{2}", tableName, reader.FieldCount, csvFileWriter.Length());
// Old Function
// Helpers.DataTableExtensions.WriteToCsvFile(dt, string.Format("{0}{1}.{2}", cBaseSqlDir, tableName + "_data", cFileExt));
// MessageBox.Show(retStr);
// New Function
csvFileWriter.Close();
Console.WriteLine(retStr);
}
transaction.Commit();
/*
* for (int i = 0; i < paramList.Length; i++)
* {
* IDbDataParameter p = (IDbDataParameter)cmd.Parameters[i];
* if (p.Direction != ParameterDirection.Input)
* {
* paramList[i].OutValue = p.Value;
* }
* }
*/
}
catch (Exception e)
{
transaction.Rollback();
HelperFunctions.LogException(e, false);
throw e;
}
finally
{
if (reader != null)
{
if (!reader.IsClosed)
{
reader.Close();
}
reader.Dispose();
}
if (cmd != null)
{
cmd.Dispose();
}
if (bConnOpenedHere)
{
conn.Close();
}
}
// return retv;
}
