/// <summary>
/// Updates the allowed/not allowed mattress model names by reading the config *csv file.
/// Must be called at application start!
/// </summary>
private static void UpdateMattressModelNamesLists()
{
if (!File.Exists(filePathMattressImportNames))
{
return;
}
queryMattressNamesWhiteList.Clear();
queryMattressNamesBlackList.Clear();
queryAllMattressNames.Clear();
DataTable dtMattressNames = CsvHandler.ReadCSVFile(filePathMattressImportNames);
foreach (DataRow row in dtMattressNames.Rows)
{
if (row["isMattress"].ToString() == "true")
{
queryAllMattressNames.Add(row["partialName"].ToString().ToLower());
}
if (row["mustContain"].ToString() == "true")
{
queryMattressNamesWhiteList.Add(row["partialName"].ToString().ToLower());
}
else
{
queryMattressNamesBlackList.Add(row["partialName"].ToString().ToLower());
}
}
}
public FileHandlingTests()
{
_configuration = new Mock <IConfiguration>();
_csvHandler = new CsvHandler();
_testee = new FileHandler(_configuration.Object, _csvHandler);
_uploadedFile = new Mock <HttpPostedFileBase>();
}
private void btnWSsave_Click(object sender, EventArgs e)
{
wh.AGVList.Clear();
int noOfRacks = Convert.ToInt32(numericUpDown3.Value);
int noOfRacksperLine = Convert.ToInt32(numericUpDown4.Value);
int noOfAgv = Convert.ToInt32(numericUpDown5.Value);
wh.CreateLines(noOfRacks, noOfRacksperLine);
wh.AGVList.Clear();
for (int i = 0; i < noOfAgv; i++)
{
AGV agv = new AGV(i, wh);
wh.AGVList.Add(agv);
}
if (checkBoxSave.Checked)
{
CsvHandler csvh = new CsvHandler(wh);
csvh.SaveWHSpecsToFile(numericUpDown3.Value.ToString(), numericUpDown4.Value.ToString(), numericUpDown5.Value.ToString());
}
this.Close();
mainFormImage.BackgroundImage = wh.DrawAreas();
mainFormImage.Refresh();
iBlade.map.CreateMap("map", iBlade.wh.Width, iBlade.wh.Height);
// wh.AGVList[0].ShortestPath(300, 299, "");
//refresh the picture box when setting warehouse specificaions
//iBlade mainForm = new iBlade();
//mainForm.pbMain.Refresh();
}
public UserDataModel()
{
_csvHandler = new CsvHandler();
_dataTableDictionary = new Dictionary <int, DataTable>
{
{ 9, new DataTable() },
{ 15, new DataTable() },
{ 20, new DataTable() },
{ 25, new DataTable() },
{ 30, new DataTable() },
{ 35, new DataTable() },
{ 40, new DataTable() },
{ 45, new DataTable() },
{ 50, new DataTable() },
{ 55, new DataTable() },
{ 60, new DataTable() },
{ 65, new DataTable() },
{ 70, new DataTable() },
{ 75, new DataTable() },
{ 80, new DataTable() },
{ 85, new DataTable() },
{ 90, new DataTable() }
};
}
public IActionResult ProdutoIncluido(Produto produto)
{
var csv = new CsvHandler();
csv.AddProduto(produto);
return(View());
}
public frmCsvImport(int categoryId, string filePath)
{
this.SelectedCategoryId = categoryId;
csvHandler = new CsvHandler(categoryId, File.ReadAllLines(filePath), this);
InitializeComponent();
}
private static void Main()
{
CsvHandler handler = new CsvHandler();
handler.Test();
Console.WriteLine("");
Console.ReadKey();
}
public BaseballSavantHitterController(Helpers helpers, CsvHandler csvHandler, BaseballSavantHitterEndPoints hitterEndpoints, BaseballScraperContext context, ProjectDirectoryEndPoints projectDirectory)
{
_helpers = helpers;
_csvHandler = csvHandler;
_hitterEndpoints = hitterEndpoints;
_context = context;
_projectDirectory = projectDirectory;
}
private void btnUploadOverview_Click(object sender, EventArgs e)
{
CsvHandler csvh = new CsvHandler(wh);
oldEvents = csvh.UploadOverview();
//oldEvents.ForEach(x => Console.WriteLine($"{x.Agv}, {x.OI.productItem.FullName}, {x.OI.Quantity}, {x.OI.Type}, {x.Time}, {x.Status}"));
CreateComparison();
}
public PlayerBaseController(Helpers helpers, BaseballScraperContext context, CsvHandler csvHandler, GoogleSheetsConnector googleSheetsConnector, ProjectDirectoryEndPoints baseballData)
{
_helpers = helpers;
_context = context;
_csvHandler = csvHandler;
_googleSheetsConnector = googleSheetsConnector;
_baseballData = baseballData;
}
public BaseballHqHitterController(Helpers helpers, BaseballHqUtilitiesController hqUtilitiesController, CsvHandler csvHandler, BaseballScraperContext context, ProjectDirectoryEndPoints projectDirectory)
{
_helpers = helpers;
_hqUtilitiesController = hqUtilitiesController;
_csvHandler = csvHandler;
_context = context;
_projectDirectory = projectDirectory;
}
public FanGraphsSpController(Helpers helpers, FanGraphsUriEndPoints endPoints, GoogleSheetsConnector googleSheetsConnector, CsvHandler csvHandler, BaseballScraperContext context, ProjectDirectoryEndPoints projectDirectory)
{
_helpers = helpers;
_endPoints = endPoints;
_googleSheetsConnector = googleSheetsConnector;
_csvHandler = csvHandler;
_context = context;
_projectDirectory = projectDirectory;
}
public void ReadCsvTestSuccess()
{
// Arrange
// Note: For this test ensure that the Maturity.csv file is in the folder C:\TradingDemo\
var policyList = CsvHandler.ReadCsv("MaturityData.csv");
Assert.IsNotNull(policyList);
}
public BaseballSavantSpController(Helpers helpers, BaseballScraperContext context, DataTabler dataTabler, BaseballSavantPitcherEndPoints baseballSavantEndPoints, CsvHandler csvHandler, ProjectDirectoryEndPoints projectDirectory)
{
_helpers = helpers;
_context = context;
_dataTabler = dataTabler;
_baseballSavantEndPoints = baseballSavantEndPoints;
_csvHandler = csvHandler;
_projectDirectory = projectDirectory;
}
public Rusle2JsonResponseToCsv(
JsonHandler jsonHandler,
Rusle2V5_0 serviceHandler,
CsvHandler csvHandler)
{
this.jsonHandler = jsonHandler;
this.serviceHandler = serviceHandler;
this.csvHandler = csvHandler;
}
public SciJsonResponseToExperimentalResults(
JsonHandler jsonHandler,
SciV2_1 serviceHandler,
CsvHandler csvHandler)
{
this.jsonHandler = jsonHandler;
this.serviceHandler = serviceHandler;
this.csvHandler = csvHandler;
}
public void TestExistingTrainingData()
{
List <InputsAndOutputs> listOfIO = new List <InputsAndOutputs>();
InputsAndOutputs inputsAndOutputs1 = CsvHandler.GetInputsAndOutputs(19, 2, testTrainingData1);
InputsAndOutputs inputsAndOutputs2 = CsvHandler.GetInputsAndOutputs(19, 2, testTrainingData2);
InputsAndOutputs inputsAndOutputs3 = CsvHandler.GetInputsAndOutputs(19, 2, testTrainingData3);
InputsAndOutputs inputsAndOutputs4 = CsvHandler.GetInputsAndOutputs(19, 2, testTrainingData4);
listOfIO.Add(inputsAndOutputs1);
listOfIO.Add(inputsAndOutputs2);
listOfIO.Add(inputsAndOutputs3);
listOfIO.Add(inputsAndOutputs4);
//InputsAndOutputs io = CsvHandler.GetInputsAndOutputs(19, 2, testTrainingData1);
NetworkStartInfo startInfo = new NetworkStartInfo(
name: "ArtificialShellshock_Final",
layers: new[] { 19, 25, 25, 2 },
learningRate: 0.03,
location: @"C:\Users\Roopal\Documents\Aashish\Shellshock",
activationMethod: 0);
NeuralNetwork aiMain = new NeuralNetwork(startInfo);
List <double> averageCost = new List <double>();
foreach (var io in listOfIO)
{
for (int i = 0; i < 5001; i++)
{
double[] costs = new double[io.InputsList.Count];
for (int j = 0; j < io.InputsList.Count; j++)
{
aiMain.FindOutput(io.InputsList[j]);
costs[j] = (Math.Abs(aiMain.MyLayers[3].Values[0] - io.OutputsList[j][0]) +
Math.Abs(aiMain.MyLayers[3].Values[1] - io.OutputsList[j][1])) / 2;
aiMain.Learn(io.OutputsList[j]);
}
if (i % 1000 == 0)
{
aiMain.SaveWeightsAndBiases();
}
if (i % 100 == 0)
{
averageCost.Add(costs.Average());
}
}
}
double[] avgCost = new double[averageCost.Count];
averageCost.CopyTo(avgCost, 0);
CsvHandler.SaveVector(avgCost,
@"C:\Users\Roopal\Documents\Aashish\Shellshock\ArtificialShellshock_Final" + @"\AverageCost.csv");
var actualOutput = aiMain.FindOutput(listOfIO[3].InputsList[0]);
Assert.AreEqual(actualOutput[0], listOfIO[0].OutputsList[0][0], 0.1);
}
public Bank1ViewModel(UserSettingsData userSettings, UserDataModel userData, DataTableHelper dataTableHelper,
AppSettings appSettings)
{
UseMultiSelect = true;
_userSettings = userSettings;
_userDataModel = userData;
_dataTableHelper = dataTableHelper;
_appSettings = appSettings;
_csvHandler = new CsvHandler();
}
public FlexCroppingLocationToCsipLocation(
CsvHandler fileHandler,
WweSoilParamsV2_0 serviceHandler,
PointToPolygonConverter converter,
CokeyChooser cokeyChooser)
{
this.fileHandler = fileHandler;
this.serviceHandler = serviceHandler;
this.converter = converter;
this.cokeyChooser = cokeyChooser;
}
public ErosionModelJsonResponseToErosionParameters(
JsonHandler jsonHandler,
WeppV3_1 weppV3_1Service,
WepsV5_2 wepsV5_2Service,
Rusle2V5_0 rusle2V5_0Service,
CsvHandler csvHandler)
{
this.jsonHandler = jsonHandler;
this.weppV3_1Service = weppV3_1Service;
this.wepsV5_2Service = wepsV5_2Service;
this.rusle2V5_0Service = rusle2V5_0Service;
this.csvHandler = csvHandler;
}
public iBlade()
{
InitializeComponent();
wh = new Warehouse(pbMain);
DrawArea = new Bitmap(pbMain.Size.Width, pbMain.Size.Height);
this.DoubleBuffered = true;
this.SetStyle(ControlStyles.ResizeRedraw, true);
map = new Map();
csvh = new CsvHandler(wh);
rnd = new Random();
// this.WindowState = FormWindowState.Maximized; //the window starts maximized
}
public void ReadFlexCroppingLocationFile_ValidFile_ExpectedResult()
{
// Arrange
var sut = new CsvHandler();
string filePath = @"Assets\verification_10.csv";
// Act
List <FlexCroppingLocation> actual =
sut.ReadFlexCroppingLocationFile(filePath);
// Assert
Assert.Equal(10, actual.Count);
}
public static string WriteTweetFormat(Country arg, Country randomCountry)
{
Emoji argFlag = new Emoji(new int[] { 0x1F1E6, 0x1F1F7 });
int[] hexDataFlagRandomCountry = CsvHandler.GetFlagDataFromCSV(randomCountry);
Emoji countryflag = new Emoji(hexDataFlagRandomCountry);
string str = $" {arg.CountryName} {argFlag} - {randomCountry.CountryName} {countryflag} " + "\n\r" +
$"Casos por millon de habitantes {arg.DailyCases} / {randomCountry.DailyCases}" + "\n\r" +
$"Cantidad de vacunas aplicadas {arg.VaccinationNumber} / {randomCountry.VaccinationNumber}" + "\n\r" +
$"Porcentaje vacunados 0 / 0" + "\n\r" +
$"";
return(str);
}
public YingxiongOverall()
{
var contents = CsvHandler.Read(FileName);
List<string> titles = null;
foreach (var row in contents)
{
if (null == titles)
{
titles = row;
continue;
}
Add(titles, row);
}
}
public HomeController(Helpers helpers, RdotNetConnector r, IOptions <AirtableConfiguration> airtableConfig, IOptions <TwitterConfiguration> twitterConfig, GoogleSheetsConnector gSC, EmailHelper emailHelper, ExcelHandler excelHandler, PythonConnector pythonConnector, DataTabler dataTabler, CsvHandler csvHandler, CbsTransactionTrendsController cbsTrendsController)
{
_helpers = helpers;
_r = r;
_airtableConfig = airtableConfig.Value;
_twitterConfiguration = twitterConfig.Value;
_gSC = gSC;
_emailHelper = emailHelper;
_excelHander = excelHandler;
_pythonConnector = pythonConnector;
_dataTabler = dataTabler;
_csvHandler = csvHandler;
_cbsTrendsController = cbsTrendsController;
// this._cbsTrendsController = cbsTrendsController;
}
public void Weps_Build_ValidInput10Locs_ExpectedResult()
{
// Arrange
CsvHandler reader = new CsvHandler();
IBuildErosionModel sut = new WepsBuilder();
// Act
List <string> actual = sut.BuildScenarios(
reader.ReadCsipLocationFile(@"Assets\location_verification_10.csv"),
sut.GetTemplate(),
sut.GetRotations());
// Assert
Assert.NotNull(actual);
Assert.Equal(33, actual.Count);
}
private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.CheckFileExists = true;
openFileDialog.AddExtension = true;
openFileDialog.Multiselect = false;
openFileDialog.Filter = "Csv files (*.csv)|*.csv";
DialogResult result = openFileDialog.ShowDialog();
// Test result.
if (result == DialogResult.OK)
{
var hander = new CsvHandler <CsvModelMap, CsvModel>(openFileDialog.FileName);
}
}
public void Weps_Build_ValidInput01Loc_ExpectedResult()
{
// Arrange
CsvHandler reader = new CsvHandler();
IBuildErosionModel sut = new WepsBuilder();
// Act
List <string> actual = sut.BuildScenarios(
reader.ReadCsipLocationFile(@"Assets\location_verification_01.csv"),
sut.GetTemplate(),
sut.GetRotations());
// Assert
string strippedJson = Regex.Replace(actual.FirstOrDefault(), @"\s+", "");
// assert rectangle lengths, others?
Assert.Contains("{\"duration\":2,\"length\":350.0", strippedJson);
}
public void ReadFirstCsvFile()
{
//Arrange
var filepath = _ph.GetAllFileNamePath().First();
var except = new List <UserModel>
{
new UserModel {
FirstName = "Dean", LastName = "Flynn", Age = 31, IsAlive = false
}
};
//Act
var csvHelp = new CsvHandler(new List <UserModel>(), filepath);
csvHelp.Read();
//Assert
Assert.NotStrictEqual(except, csvHelp.UserModels);
}
static AttibuteSummary()
{
var contents = CsvHandler.Read(AttributeSummaryFileName);
foreach (var row in contents)
{
if (row.Count == 2)
{
Add(row[0], row[1], false);
}
}
var existingCombinations = Map.Keys.ToList();
foreach (var existingCombination in existingCombinations)
{
Initialize(existingCombination, Map[existingCombination]);
}
}
static void Main(string[] args)
{
const string directory = @"C:\Users\dean.mcgarrigle\Dropbox\public\FootballData";
const string fixtures = @"C:\Users\dean.mcgarrigle\Dropbox\public\FootballData\fixturelist.csv";
Console.WriteLine("Which league do you want to simulate?");
var division = Console.ReadLine();
var context = new AlgoTestContext();
var leagueRepo = new LeagueRepository(context);
var csvHandler = new CsvHandler<LeagueData, LeagueDataMap>();
homeShots = leagueRepo.LeagueShotStatsHome().Where(x => x.League == division.ToUpper()).ToList();
awayShots = leagueRepo.LeagueShotStatsAway().Where(x => x.League == division.ToUpper()).ToList();
var input = Options();
if (input == "download")
{
Console.WriteLine("Please select a season to download (1516 etc): ");
var season = Console.ReadLine();
var leagues = new[] { "E0", "E1", "E2", "E3", "EC" };
var fileUrl = string.Format("http://www.football-data.co.uk/mmz4281/{0}", season);
foreach (var league in leagues)
{
var results = csvHandler.DownloadFile(string.Format("{0}/{1}.csv", fileUrl, league)).Result;
foreach (var result in results)
{
leagueRepo.AddFixture(result);
Console.WriteLine("Adding Fixture: " + result.HomeTeam + " v " + result.AwayTeam);
}
}
context.SaveChanges();
Console.WriteLine("Added fixtures");
Options();
}
if (input == "2")
{
string[] teams = File.ReadAllLines(fixtures);
var query = from line in teams
let data = line.Split(',')
select new HeadToHead()
{
Home = data[0],
Away = data[1],
};
foreach (var a in query.Take(130).Reverse().Take(100).Reverse())
{
if (!RunSimulation(a.Home, a.Away)) break;
}
accuracy = Convert.ToDouble(correct)/Convert.ToDouble(total)*100;
Console.WriteLine("Simulation was "+ accuracy + "% accurate");
Options();
}
if (input == "1")
{
Run();
}
if (input == "4")
{
RunSimulation("Watford", "Man United");
Options();
}
}
