private void button10_Click(object sender, EventArgs e)
{///creation devis
//Clipper_Dll.Test_quote testquote = new Clipper_Dll.Test_quote();
//testquote.createnewquote(_Context);
IEntity mpart = null;
IEntityList mparts = _Context.EntityManager.GetEntityList("_MACHINABLE_PART");
mparts.Fill(false);
mpart = mparts.FirstOrDefault();
Topologie topo = new Topologie();
topo.GetTopologie(ref mpart, ref _Context);
}
//méthodes sut la table Topologie
/// <summary>
/// Créé une topologie
/// </summary>
/// <param name="topo">Topologie</param>
public void SetTopologie(Topologie topo)
{
using (IDbConnection connexion = new SQLiteConnection(sqliteInfo))
{
if (connexion.State == ConnectionState.Closed)
{
connexion.Open();
}
try
{
string msg = "INSERT INTO Topologie (idMachine,fk_Date) VALUES ('" + topo.idMachine + "','" + topo.fk_Date.ToString("yyyy-MM-dd HH:mm:ss.fff") + "')";
connexion.Execute(msg);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
}
/// <summary>
/// Fonction qui va initialiser une machine dans <c>BDDInterface</c>
/// </summary>
/// <param name="idMachine">Numéro d'ID de la machine</param>
/// <param name="fk_Date">date de création/modifiction</param>
public void SetTopologie(string idMachine, DateTime fk_Date)
{
Topologie topo = new Topologie(idMachine, fk_Date);
bd.SetTopologie(topo);
}
/// <summary>
/// Fonction privée qui seed une topologie
/// </summary>
/// <param name="numSerie">ID de machine</param>
/// <param name="dateSynchro">La date de la synchronisation</param>
private void setTopo(string numSerie, DateTime dateSynchro)
{
Topologie topo = new Topologie(numSerie, dateSynchro);
bd.SetTopologie(topo);
}
