/// <summary>
/// Le type de donnees dans le parametre donnee .
/// </summary>
/// <param name="donnees"></param>
/// <returns></returns>
public static double volatilite(Data.Data donnees, string columnName)
{
//Initialisation de la volatilite
double ecart_type = 0;
int nbr_ligne = donnees.Ds.Tables[0].Rows.Count;
//Traitement identique pour tous les types de donnees
//On calcule la moyenne du cours
double moyenne = 0;
for (int i = 0; i < nbr_ligne; i++)
{
moyenne += (double)donnees.Ds.Tables[0].Rows[i][columnName];
}
moyenne /= nbr_ligne;
//On calcule sont ecart type
for (int i = 0; i < nbr_ligne; i++)
{
ecart_type += Math.Pow((double)donnees.Ds.Tables[0].Rows[i][columnName] - moyenne, 2);
}
ecart_type = Math.Sqrt(ecart_type / nbr_ligne);
return(ecart_type);
}
public override void Execute(Data.Data data)
{
SessionHandler.EnqueueAction(() =>
{
var player = Utils.GetPlayer();
if (player != null)
{
var character = player.Character;
var inventory = character.GetInventory();
foreach (var planItem in character.BuildPlanner)
{
foreach (var component in planItem.Components)
{
var newObject = MyObjectBuilderSerializer.CreateNewObject(component.ComponentDefinition.Id);
if (inventory.AddItems(component.Count, newObject))
{
component.Count = 0;
}
else
{
var matrix = player.Character.WorldMatrix;
MyFloatingObjects.Spawn(component.ComponentDefinition, matrix.Translation, matrix.Forward, matrix.Up, component.Count);
component.Count = 0;
}
}
planItem.Components.RemoveAll(component => component.Count <= 0);
}
character.CleanFinishedBuildPlanner();
}
});
}
/// <summary>
/// Télécharge le fichier désiré
/// et la parse, en remplissant les données
/// </summary>
/// <param name="d">Base de donnée, doit être de type HistoricalData</param>
public override void ImportAndParse(Data.Data d, Data.DataRetour Erreur = null)
{
// On vérifie que les données soient de type historique
switch (d.Type)
{
case Data.Data.TypeData.HistoricalData:
//On teste le bon ordre des dates
if (d.End < d.Start)
{
throw new WrongDates(@"La date de E ne peut être antérieure au début de l'acquisition");
}
// pour contenir la liste des entrées incorecte
List <string> listeErreur = new List <string>();
// Pour chaque symbol, on récupère le fichier et on le parse
foreach (string symbol in d.Symbol)
{
_Filepath = "Yahoo_" + symbol + "_" + d.Start.ToString("dd-MM-yy") + "_" + d.End.ToString("dd-MM-yy") + ".csv";
Uri siteUri;
// exemple d'url voulu : http://ichart.finance.yahoo.com/table.csv?s=GOOG&d=5&e=8&f=2013&g=d&a=5&b=8&c=2011&ignore=.csv
// http://ichart.finance.yahoo.com/table.csv?s=GOOG&d=5&e=3&f=2014&g=d&a=4&b=2&c=2014&ignore=.csv
int moiDebt = d.Start.Month - 1;
int moiFin = d.End.Month - 1;
siteUri = new Uri("http://ichart.finance.yahoo.com/table.csv?s=" + symbol
+ "&d=" + moiFin + "&e=" + d.End.Day + "&f=" + d.End.Year
+ "&g=d" + "&a=" + moiDebt + "&b=" + d.Start.Day + "&c=" + d.Start.Year + "&ignore=.csv");
try
{
// Télécharge le fichier
ImportFile(siteUri);
// On indique au parser le symbol courant et le nom du fichier, puis on parse le fichier obtenu
_Parser.set(_Filepath, symbol);
_Parser.ParseFile(d);
}
catch
{
listeErreur.Add(symbol);
}
// On supprime le fichier
System.IO.File.Delete(@_Filepath);
}
// on renvoie la liste d'erreur
if (listeErreur.Count != 0)
{
Erreur.SetListeErreur(listeErreur);
}
break;
default:
throw new Mauvaistype(@"Mauvais Type utilisé");
}
}
public override void Execute(Data.Data data, Dictionary <string, object> parameters)
{
SessionHandler.EnqueueAction(() =>
{
var player = Utils.GetPlayer();
if (player != null)
{
var controlledEntity = player.Controller.ControlledEntity;
if (controlledEntity is MyShipController controller)
{
var grid = controller.CubeGrid;
var blocks = grid.GetFatBlocks <MyJumpDrive>();
if (blocks.MoveNext())
{
var jumpDrive = blocks.Current;
if (jumpDrive != null && jumpDrive.CanJump && !grid.GridSystems.JumpSystem.IsJumping)
{
((IMyJumpDrive)jumpDrive).Jump(false);
}
}
}
}
});
}
private List <BaseAction> GetAndExecute(Data.Data data)
{
var actions = _actionHandler.GetActions(data);
actions.ForEach(action => action.Execute(data));
return(actions);
}
public void Importer()
{
Data.Data manager = new Data.Data("LojaFaria");
string filePath = @"Url do excel"; //URL MISSING
if (File.Exists(filePath))
{
using (var reader = new StreamReader(File.OpenRead(filePath)))
{
List <string> listaProdutos = new List <string>();
while (!reader.EndOfStream)
{
//line é a row da excel sheet,
string line = reader.ReadLine();
listaProdutos.Add(line);
}
List <Produto> produtos = new List <Produto>();
foreach (string product in listaProdutos)
{
Produto produto = new Produto();
var substrings = product.Split(';');
produto.Id = substrings[0];
produto.Nome = substrings[1];
produto.Preco = Convert.ToDouble(substrings[2]);
produto.Tipo = substrings[3];
produto.DataDeAquisicao = DateTime.Parse(substrings[4]);
produto.DataDeVenda = DateTime.Parse(substrings[5]);
produtos.Add(produto);
}
manager.AdicionarProdutos(produtos);
}
}
}
/// <summary>
/// Crée les fichiers
/// et le parse, en remplissant les données
/// </summary>
/// <param name="d">Base de donnée, DataXML </param>
public override void ImportAndParse(Data.Data d, Data.DataRetour Erreur = null)
{
// Création des fichiers
string filePath = "xml.xml";
string filePathSchema = "Schema/xmlSchema.xsd";
// Si les fichiers existe,nt alors on les nomme autrement
int i = 0;
string nameFile = filePath;
while (System.IO.File.Exists(@nameFile))
{
i++;
nameFile = i + "_" + filePath;
}
filePath = nameFile;
// Fichier XML
StreamWriter stw = new StreamWriter(filePath);
stw.Write(contentXML);
stw.Close();
WebAPI_final.Models.Constantes.displayDEBUG("Fichier XML créé", 1);
// Parse
_Parser = new Parser.ParserXML(filePath, filePathSchema);
_Parser.ParseFile(d);
// On supprime les fichiers
System.IO.File.Delete(@filePath);
}
/// <summary>
/// Télécharge le fichier désiré
/// et la parse, en remplissant les données
/// </summary>
/// <param name="d">Base de donnée, doit être de type InterestRate</param>
public override void ImportAndParse(Data.Data d, Data.DataRetour Erreur = null)
{
// On vérifie que les données soient de type InterestRate
switch (d.Type)
{
case Data.Data.TypeData.InterestRate:
//On teste le bon ordre des dates
if (d.End < d.Start)
{
throw new WrongDates(@"La date de fin ne peut être antérieure au début de l'acquisition");
}
// pour contenir la liste des entrées incorecte
List <string> listeErreur = new List <string>();
// Pour chaque année, on récupère le fichier et on le parse
for (int i = d.Start.Year; i <= d.End.Year; i++)
{
_CurrentYear = i;
string symbol = d.Symbol.First();
_Filepath = "EBF_" + symbol + "_" + _CurrentYear + ".csv";
Uri siteUri;
// exemple d'url voulu : http://www.euribor-ebf.eu/assets/modules/rateisblue/processed_files/hist_EURIBOR_2013.csv
siteUri = new Uri("http://www.euribor-ebf.eu/assets/modules/rateisblue/processed_files/hist_" + symbol + "_" + _CurrentYear + ".csv");
try
{
// Télécharge le fichier
ImportFile(siteUri);
// On indique au parser le symbol courant et le nom du fichier, puis on parse le fichier obtenu
Parser.ParserCSV p = (Parser.ParserCSV)_Parser;
p.set(CultureInfo.GetCultureInfo("FR"));
_Parser.set(_Filepath, symbol);
_Parser.ParseFile(d);
}
catch
{
listeErreur.Add(symbol);
}
// On supprime le fichier
System.IO.File.Delete(@_Filepath);
}
// on renvoie la liste d'erreur
if (listeErreur.Count != 0)
{
Erreur.SetListeErreur(listeErreur);
}
break;
default:
throw new Mauvaistype(@"Mauvais Type utilisé");
}
}
private void PrintData(Data.Data data)
{
richTextBoxUser.Clear();
richTextBoxGood.Clear();
richTextBoxCategory.Clear();
richTextBoxReference.Clear();
foreach (var item in data.UserList)
{
richTextBoxUser.Text += "Id: " + item.Id + " | Name: " + item.Name + "\n\n";
}
foreach (var item in data.CategoryList)
{
richTextBoxCategory.Text += "Id: " + item.Id + " | Name: " + item.Name + "\n";
richTextBoxCategory.Text += "UserId: " + item.UserId;
richTextBoxCategory.Text += "\n\n";
}
foreach (var item in data.GoodList)
{
richTextBoxGood.Text += "Id: " + item.Id + " | Name: " + item.Name + "\n";
richTextBoxGood.Text += "UserId: " + item.UserId;
richTextBoxGood.Text += "\n\n";
}
foreach (var item in data.ReferenceList)
{
richTextBoxReference.Text += "GoodId: " + item.GoodId + " | CategoryId: " + item.CategoryId + "\n\n";
}
}
public override void Execute(Data.Data data, Dictionary <string, object> parameters)
{
SessionHandler.EnqueueAction(() =>
{
var player = Utils.GetPlayer();
if (player != null)
{
if (Vehicle)
{
var controlledEntity = player.Controller.ControlledEntity;
if (controlledEntity is MyShipController controller)
{
var grid = controller.CubeGrid;
grid.CubeBlocks.Where(block => _random.NextDouble() < VehiclePercentage).ToList()
.ForEach(block => grid.RemoveBlock(block));
}
}
if (_random.NextDouble() < PlayerPercentage)
{
player.Character.Kill(true, new MyDamageInformation());
}
ActionNotification.SendActionMessage("SNAP!", Color.Red, "ArcHudGPSNotification1");
}
});
}
public override void Execute(Data.Data data, Dictionary <string, object> parameters)
{
SessionHandler.EnqueueAction(() =>
{
var player = Utils.GetPlayer();
if (player != null)
{
var character = player.Character;
var health = character.StatComp.Health;
if (health != null)
{
health.Value = health.MaxValue;
}
if (MySession.Static.Settings.EnableOxygen)
{
character.OxygenComponent.SuitOxygenAmount =
character.OxygenComponent.OxygenCapacity;
}
var myDefinitionId = MyCharacterOxygenComponent.HydrogenId;
character.OxygenComponent.UpdateStoredGasLevel(ref myDefinitionId, 1.0f);
character.SuitBattery.ResourceSource.SetRemainingCapacityByType(
MyResourceDistributorComponent.ElectricityId, 1E-05f);
}
});
}
public override void Execute(Data.Data data)
{
SessionHandler.EnqueueAction(() =>
{
var player = Utils.GetPlayer();
if (player == null)
{
return;
}
var controlledEntity = player?.Controller.ControlledEntity;
if (controlledEntity is MyShipController controller)
{
var blocks = controller.CubeGrid.GetFatBlocks <MyThrust>();
foreach (var block in blocks)
{
block.Enabled = true;
}
}
else
{
controlledEntity?.SwitchThrusts();
}
});
}
public override void Execute(Data.Data data, Dictionary <string, object> parameters)
{
SessionHandler.EnqueueAction(() =>
{
var player = Utils.GetPlayer();
if (player != null)
{
var character = player.Character;
var matrix = character.WorldMatrix;
foreach (var planItem in character.BuildPlanner)
{
foreach (var component in planItem.Components)
{
var amount = (double)component.Count;
Utils.AddOrDropItem(player, component.ComponentDefinition, ref amount, matrix);
component.Count = (int)amount;
}
planItem.Components.RemoveAll(component => component.Count <= 0);
}
character.CleanFinishedBuildPlanner();
}
});
}
public override void Execute(Data.Data data, Dictionary <string, object> parameters)
{
SessionHandler.EnqueueAction(() =>
{
var player = Utils.GetPlayer();
if (player == null)
{
return;
}
var controlledEntity = player.Controller.ControlledEntity;
if (controlledEntity is MyShipController controller)
{
var blocks = controller.CubeGrid.GetFatBlocks <MyThrust>();
foreach (var block in blocks)
{
block.Enabled = !block.Enabled;
}
}
else
{
ActionHelper.SetThrusters(ActionHelper.ActionEnum.Toggle, player.Id.SteamId);
}
});
}
public static bool IsAuthenticated(string sessionId)
{
var data = new Data.Data();
return(data.Context.Logins
.Any(x => x.SessionId == sessionId && x.IsActive));
}
public void ChainingTest()
{
Person person0 = new Person("", "", DateTime.Now);
Wallet wallet0 = new Wallet();
Data.Data data0 = new Data.Data(person0, wallet0);
//First Data
Person person1 = new Person("Monroe Jamal", "Budapest",
new DateTime(1979, 1, 21));
Wallet wallet1 = new Wallet();
Data.Data data1 = new Data.Data(person1, wallet1);
//Second Data
Person person2 = new Person("Wood Dario", "Debrecen",
new DateTime(1997, 4, 2));
Wallet wallet2 = new Wallet();
Data.Data data2 = new Data.Data(person2, wallet2);
//Third Data
Person person3 = new Person("Weiss Ella", "Debrecen",
new DateTime(1993, 10, 10));
Wallet wallet3 = new Wallet();
Data.Data data3 = new Data.Data(person3, wallet3);
//Fourth Data
Person person4 = new Person("Patricia T. Smith", "Pécs",
new DateTime(1999, 2, 7));
Wallet wallet4 = new Wallet();
Data.Data data4 = new Data.Data(person4, wallet4);
Block genesis = new Block(data0);
Chain.Add(genesis);
Block block1 = new Block(data1);
Chain.Add(block1);
Block block2 = new Block(data2);
Chain.Add(block2);
Block block3 = new Block(data3);
Chain.Add(block3);
Block block4 = new Block(data4);
Chain.Add(block4);
List <Block> chain = IO.IO.Read <Block>();
Assert.AreEqual(block2.Hash, chain[2].Hash);
}
public IEnumerator GetInfos(Data.Data data, Action <Data.Data> onComplete)
{
data.Children = new[] { new Data.Child {
id = "0", name = "Local profile"
} };
onComplete?.Invoke(data);
yield break;
}
public MainViewModel(INavigation navigation)
{
RegisterCommand = new Command(Register);
ViewCommand = new Command(NavigateTo);
Navigation = navigation;
_user = new User();
UserData = new Data.Data();
}
public override void Execute(Data.Data data)
{
SessionHandler.EnqueueAction(() =>
{
var player = Utils.GetPlayer();
player?.Controller.ControlledEntity.SwitchDamping();
});
}
public IEnumerator GetInfos(Data.Data data, Action <Data.Data> onComplete)
{
var accountRequest = UnityWebRequest.Get("https://cambridgekids.sophiacloud.com/console/index.php?page=MyDaily");
accountRequest.SetRequestHeader("User-Agent", "Mozilla/5.0 Firefox/74.0");
accountRequest.SetRequestHeader("Cookie", sessionId);
yield return(accountRequest.SendWebRequest());
var response = "";
foreach (var line in accountRequest.downloadHandler.text.Split('\n'))
{
if (line.TrimStart('\t').StartsWith("window.page_data = "))
{
response = line.TrimStart('\t').Substring("window.page_data = ".Length);
response = response.Remove(response.Length - 2);
break;
}
}
if (string.IsNullOrEmpty(response))
{
Logging.Log("Un erreur est survenue", LogType.Error); Manager.HideLoadingPanel(); yield break;
}
var json = new FileFormat.JSON(response);
var userID = json.GetCategory("user_session").GetCategory("settings").Value <string>("user_id");
accountRequest = UnityWebRequest.Get($"https://cambridgekids.sophiacloud.com/console/sophiacloud/data_mgr.php?s=user&user_id={userID}&verbose=page");
accountRequest.SetRequestHeader("User-Agent", "Mozilla/5.0 Firefox/74.0");
accountRequest.SetRequestHeader("Cookie", sessionId);
yield return(accountRequest.SendWebRequest());
json = new FileFormat.JSON(accountRequest.downloadHandler.text);
var accountId = json.jToken.SelectToken("account_user").First.Value <string>("account_id");
accountRequest = UnityWebRequest.Get($"https://cambridgekids.sophiacloud.com/console/sophiacloud/data_mgr.php?s=account&account_id={accountId}&verbose=page");
accountRequest.SetRequestHeader("User-Agent", "Mozilla/5.0 Firefox/74.0");
accountRequest.SetRequestHeader("Cookie", sessionId);
yield return(accountRequest.SendWebRequest());
json = new FileFormat.JSON(accountRequest.downloadHandler.text);
var enfants = json.jToken.SelectToken("account_user").Where(obj => obj.Value <string>("type") == "1").Select(enfant =>
{
var name = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase($"{enfant.Value<string>("prenom")}{enfant.Value<string>("nom")}".ToLower());
return(new Child {
name = name, id = enfant.Value <string>("user_id"), modules = new List <string> {
"Homeworks"
}
});
}).ToArray();
Manager.HideLoadingPanel();
var label = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(json.Value <string>("account_name").ToLower());
data.Children = enfants;
data.Label = label;
onComplete?.Invoke(data);
Manager.HideLoadingPanel();
}
public static User GetUser(string sessionId)
{
var data = new Data.Data();
var login = data.Context.Logins
.FirstOrDefault(x => x.SessionId == sessionId && x.IsActive);
return(login.User);
}
/// <summary>
/// Télécharge le fichier désiré
/// et la parse, en remplissant les données
/// </summary>
/// <param name="d">Base de donnée, doit être de type HistoricalData</param>
public override void ImportAndParse(Data.Data d, Data.DataRetour Erreur = null)
{
// On vérifie que les données soient de type historique
switch (d.Type)
{
case Data.Data.TypeData.HistoricalData:
//On teste le bon ordre des dates
if (d.End < d.Start)
{
throw new WrongDates(@"La date de fin ne peut être antérieure au début de l'acquisition");
}
// pour contenir la liste des entrées incorecte
List <string> listeErreur = new List <string>();
// Pour chaque symbol, on récupère le fichier et on le parse
foreach (string symbol in d.Symbol)
{
_Filepath = "Google_" + symbol + ".csv";
Uri siteUri;
// exemple d'url voulu : https://www.google.com/finance/historical?q=GOOG&startdate=May+8+2011&enddate=Jun+8%2C+2013&num=30&output=csv
//https://www.google.com/finance/historical?q=CA.PA&startdate=juin+1+2014&enddate=juin+3+2014&num=30&output=csv
siteUri = new Uri("http://www.google.com/finance/historical?q=" + symbol
+ "&startdate=" + d.Start.ToString("MMM+d+yyyy")
+ "&enddate=" + d.End.ToString("MMM+d+yyyy") + "&num=30&output=csv");
try
{
// Télécharge le fichier
ImportFile(siteUri);
// On indique au parser le symbol courant et le nom du fichier, puis on parse le fichier obtenu
_Parser.set(_Filepath, symbol);
_Parser.ParseFile(d);
}
catch
{
listeErreur.Add(symbol);
}
// On supprime le fichier
System.IO.File.Delete(@_Filepath);
}
// on renvoie la liste d'erreur
if (listeErreur.Count != 0)
{
Erreur.SetListeErreur(listeErreur);
}
break;
default:
throw new Mauvaistype(@"Mauvais Type utilisé");
}
}
public static void Logout(string sessionId)
{
var data = new Data.Data();
var login = data.Context.Logins.FirstOrDefault(x => x.SessionId == sessionId);
login.IsActive = false;
login.User.LastLoginTime = login.LoginTime;
data.Context.SaveChanges();
}
public override void Execute(Data.Data data, Dictionary <string, object> parameters)
{
if (_actions.Count <= 0)
{
return;
}
Message = string.Join(" ", _actions.Select(action => action.Message ?? ""));
_actions.ForEach(action => action.Execute(data, parameters));
}
public GameController(Data.Data data, MainWindowController mainWindowController, MarkersWindowController markersWindowController, PlayerView leftPlayerView, PlayerView rightPlayerView)
{
_data = data;
_mainWindowController = mainWindowController;
_markersWindowController = markersWindowController;
_mainWindowController.RestartGame += _mainWindowController_RestartGame;
_leftPlayerView = leftPlayerView;
_rightPlayerView = rightPlayerView;
}
public override void Execute(Data.Data data, Dictionary <string, object> parameters)
{
SessionHandler.EnqueueAction(() =>
{
var player = Utils.GetPlayer();
if (player == null)
{
return;
}
ActionHelper.SetDampener(ActionHelper.ActionEnum.Disable, player.Id.SteamId);
});
}
public override void Execute(Data.Data data)
{
if (_actions.Count <= 0)
{
return;
}
var action = _actions.SelectRandomItem();
Message = action.Message;
action.Execute(data);
}
public override void Execute(Data.Data data, Dictionary <string, object> parameters)
{
if (_actions.Count <= 0)
{
return;
}
var action = _actions.SelectRandomItem();
Message = action.Message;
action.Execute(data, parameters);
}
/// <summary>
/// Parse le fichier désiré
/// Insère les données dans d
/// </summary>
/// <param name="d">base de donnée</param>
public override void ParseFile(Data.Data d)
{
WebAPI_final.Models.Constantes.displayDEBUG("start parseGenerique", 2);
// Lecture du schema
List <Balise> list = readSchema();
// Récupération des données
readFile(list);
WebAPI_final.Models.Constantes.displayDEBUG("end parseGenerique", 2);
}
public List <BaseAction> GetAndExecute(Data.Data data)
{
var actions = _actionHandler.GetActions(data);
var param = GetParams(data);
if (EventType.TwitchSubscription.Equals(data.Type))
{
param.Add("tier", data.Tier);
}
actions.ForEach(action => action.Execute(data, param));
return(actions);
}
public Project()
{
data = new Data.Data();
}
