public void TestMethodTypeCounters()
{
ArrayList exoplanetArray = null;
if (File.Exists(Constant.UnitTestCSVFolder + "Version2.xml"))
{
exoplanetArray = ReadXML.Read(Constant.UnitTestCSVFolder + "Version2.xml", true);
}
else
{
ReadCSV.Read(Constant.UnitTestCSVFolder + "Version2.csv");
exoplanetArray = ReadXML.Read(Constant.UnitTestCSVFolder + "Version2.xml", true);
}
Assert.IsNotNull(exoplanetArray);
Assert.AreEqual(Exoplanets.NumberOfExoplanets(exoplanetArray), 1950);
Assert.AreEqual(Exoplanets.NumberOfTypeOStars(exoplanetArray), 0);
Assert.AreEqual(Exoplanets.NumberOfTypeBStars(exoplanetArray), 8);
Assert.AreEqual(Exoplanets.NumberOfTypeAStars(exoplanetArray), 13);
Assert.AreEqual(Exoplanets.NumberOfTypeFStars(exoplanetArray), 129);
Assert.AreEqual(Exoplanets.NumberOfTypeGStars(exoplanetArray), 389);
Assert.AreEqual(Exoplanets.NumberOfTypeKStars(exoplanetArray), 274);
Assert.AreEqual(Exoplanets.NumberOfTypeMStars(exoplanetArray), 91);
Assert.AreEqual(Exoplanets.NumberOfMultiPlanetStars(exoplanetArray), 539);
}
public static void WriteCollectionToSQL()
{
ReadCSV.Read();
using (SqlConnection con = new SqlConnection(DatabaseConfig.ConnectionString))
{
con.Open();
SqlTransaction trans = con.BeginTransaction();
SqlCommand cmd = null;
try
{
string query = "";
foreach (Customer item in ReadCSV.list)
{
query += "INSERT INTO Customer VALUES(" + item.CID + ",'" + item.CName + "'," + item.BillNo + ",'" + item.Email + "');";
}
cmd = new SqlCommand(query, con, trans);
cmd.ExecuteNonQuery();
trans.Commit();
Console.WriteLine("Done ..");
}
catch (SqlException ex)
{
trans.Rollback();
Console.WriteLine("Not Done ...");
Console.WriteLine(ex.Message);
}
}
}
bool isCompleteLine = false; // 1文が全部表示されたか？
// Use this for initialization
void Start()
{
ReadCSV readCSV = new ReadCSV();
readCSV.Read();
scenarios = readCSV.csvDatas.ToArray(); // public だから読める listという文字数が決まっていない型から配列に変換して入れている
Show();
}
internal async Task <IEnumerable <Fuel> > GetCompanyCityFuelPrice(string company, string city)
{
ReadCSV cachedCSV = new ReadCSV();
var cachedFuel = cachedCSV.Read();
// cachedFuel.ForEach(x => System.Console.WriteLine(x.City));
if (cachedFuel.Count > 0 && cachedFuel.First().EffectiveDate.AddDays(1) > DateTime.Today)
{
if (city != null)
{
return(cachedFuel.Where(f => f.City == city).ToList().OrderBy(o => o.City));
}
return(cachedFuel.OrderBy(o => o.City));
}
else
{
using (HttpClient client = new HttpClient())
{
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var result = await client.PostAsync("https://www.bharatpetroleum.com/AjaxSmartFleetMap.aspx/SetSmartFleetMap", new StringContent("", Encoding.UTF8, "application/json"));
var responseString = await result.Content.ReadAsStringAsync();
JObject rss = JObject.Parse(responseString);
JArray jArray = (JArray)rss.SelectToken("d");
List <Fuel> fuel = jArray.Select(a => new Fuel
{
Company = "Bharat Petroleum",
City = a.SelectToken("city").Value <string>(),
EffectiveDate = DateTime.ParseExact(a.SelectToken("effDate").Value <string>().Replace(" Hrs", ""), "dd-MM-yyyy hh:mm", CultureInfo.InvariantCulture),
FuelType = ((JArray)a.SelectToken("productList")).Select(f => new FuelType
{
Type = f.SelectToken("name").Value <string>(),
Price = f.SelectToken("rsp").Value <decimal?>()
}).ToList()
})
.ToList();
if (city != null)
{
fuel = fuel.Where(f => f.City == city).ToList();
}
WriteCSV csv = new WriteCSV();
csv.Write(fuel);
return(fuel.OrderBy(o => o.City));
}
}
}
// Start is called before the first frame update
void Start()
{
csvReader = new ReadCSV();
lineLocs = new FixedLenQueue <Vector3>(maxQCap);
lr = GetComponent <LineRenderer>();
csvReader.Read(fileName, out csvData, ReadCSV.FileFrom.StramingAssets);
Vector3 vec = VectorForUnity(csvData.Rows[numInstantiated++]);
startPosition = car.transform.position = nextPoint = vec;
lineLocs.Add(vec);
}
public void TestMethodReadVersion2NValid()
{
ArrayList exoplanetArray = null;
if (File.Exists(Constant.UnitTestCSVFolder + "Version2.xml"))
{
exoplanetArray = ReadXML.Read(Constant.UnitTestCSVFolder + "Version2.xml");
}
else
{
ReadCSV.Read(Constant.UnitTestCSVFolder + "Version2.csv");
exoplanetArray = ReadXML.Read(Constant.UnitTestCSVFolder + "Version2.xml");
}
Assert.IsNotNull(exoplanetArray);
}
private List <Dictionary <string, object> > listOfPoints; // List of points from ReadCSV
void Start()
{
listOfPoints = ReadCSV.Read(dataFile);
Dataset.ListOfPoints = listOfPoints;
//FileThnigs();
Dataset.K = 3;
Dataset.FeatureNames = Dataset.ListOfPoints[0].Keys.ToList();
Dataset.FeatureNames.Remove(Dataset.FeatureNames.Last());
Dataset.FeatureNames.Remove(Dataset.FeatureNames.First());
//TODO ändra så att det inte hårkodas in 4
Dataset.NumberOfFeatures = Dataset.ListOfPoints[0].Keys.Count;
Debug.Log("Number of features: " + Dataset.NumberOfFeatures);
SetFeatureInDataset();
}
public void TestMethodVersion1Dat()
{
ArrayList exoplanetArray = null;
ReadCSV.Read(Constant.UnitTestDATFolder + "Version1.dat");
exoplanetArray = ReadXML.Read(Constant.UnitTestDATFolder + "Version1.xml", true);
WriteCSV.Write(Constant.UnitTestDATFolder + "Version1TestResults.dat", exoplanetArray, Constant.Version2);
ArrayList exoplanetArray2 = null;
ReadCSV.Read(Constant.UnitTestDATFolder + "Version1TestResults.dat");
exoplanetArray2 = ReadXML.Read(Constant.UnitTestDATFolder + "Version1TestResults.xml", true);
Assert.IsNotNull(exoplanetArray);
Assert.IsNotNull(exoplanetArray2);
Assert.AreEqual(exoplanetArray.Count, exoplanetArray2.Count);
Assert.AreEqual(Exoplanets.AreEqual(exoplanetArray, exoplanetArray2), true);
}
static void RetrieveCSV()
{
ReadCSV.Read();
ReadCSV.DisplayConsole();
}
public void TestMethodReadDATs()
{
ReadCSV.Read(Constant.UnitTestDATFolder + "Version1.dat");
ReadCSV.Read(Constant.UnitTestDATFolder + "Version2.dat");
ReadCSV.Read(Constant.UnitTestDATFolder + "Version3.dat");
}
public void TestMethodReadCSVs()
{
ReadCSV.Read(Constant.UnitTestCSVFolder + "Version1.csv");
ReadCSV.Read(Constant.UnitTestCSVFolder + "Version2.csv");
ReadCSV.Read(Constant.UnitTestCSVFolder + "Version3.csv");
}
