public void AjouteLigneEntEtab(Form1 myform, RattachementEtablissementEntreprise myformrattachement, CorrespondanceBLL ligne_selectionné, string Code, string Libelle, bool ent_existante)
{
List <CorrespondanceBLL> lignes_a_ajouter = new List <CorrespondanceBLL>();
CorrespondanceBLL ligne_a_ajouter = new CorrespondanceBLL();
ligne_a_ajouter = ligne_a_ajouter.CopieLigneCorrespondanceSansReference(ligne_selectionné);
// ligne_a_ajouter = ligne_selectionné;
ligne_a_ajouter.Ancien_Code = ligne_a_ajouter.Nouveau_Code;
ligne_a_ajouter.Libelle_Ancien_Code = ligne_a_ajouter.Libelle_Nouveau_Code;
//ligne_a_ajouter.Nouveau_Code = (myformrattachement.comboBox_entreprise_existante.SelectedItem as ComboBox_EntrepriseBLL).Code.ToString();
ligne_a_ajouter.Nouveau_Code = Code;
ligne_a_ajouter.Libelle_Nouveau_Code = Libelle;
ligne_a_ajouter.Cpl = "1000";
ligne_a_ajouter.NomRef = "Rapprochement-Entreprise-Etablissement";
if (ent_existante)
{
ligne_a_ajouter.FlagReferentiel = 1;
}
else
{
ligne_a_ajouter.FlagReferentiel = 2;
}
lignes_a_ajouter.Add(ligne_a_ajouter);
VariablePartage.TableCorrespondance.Add(ligne_a_ajouter);
CorrespondanceDAL CorObjDAL = new CorrespondanceDAL();
CorObjDAL.InsertIntoSQLITE_TBCorrespondance(lignes_a_ajouter);
if (!ent_existante)
{
ReferentielBLL ligne_referentiel = new ReferentielBLL();
ligne_referentiel = ligne_referentiel.CreerLigneReferentiel_ByLigneCorresp(ligne_a_ajouter);
ligne_referentiel.Cpl = "3";
ligne_referentiel.TypeItem = "Entreprise";
ligne_referentiel.Code = Code;
ligne_referentiel.Lib = Libelle;
ligne_referentiel.InActif = true;
List <ReferentielBLL> lignes_referentiel_a_ajouter = new List <ReferentielBLL>();
lignes_referentiel_a_ajouter.Add(ligne_referentiel);
VariablePartage.TableReferentiel.Add(ligne_referentiel);
ReferentielDAL RefObjDAL = new ReferentielDAL();
RefObjDAL.InsertIntoSQLITE_TBReferentiel(lignes_referentiel_a_ajouter);
}
ComboBoxFiltreDAL ComboObject = new ComboBoxFiltreDAL();
VariablePartage.ComboBoxFiltre = ComboObject.ObtenirComboBoxFiltre();
GUIFonction GUI = new GUIFonction();
GUI.InitComboBoxFiltre(myform);
}
public void AffectationCode_ByLigneCorrespReferentiel_Test_Examen()
{
Form1 myform = new Form1();
string CPLCLEF = "135|0|0|NOMEN";
VariablePartage.CheminBaseClient = "C:\\temp\\BaseRecodageCHVAL.db";
ReferentielDAL referentielDAL = new ReferentielDAL();
VariablePartage.TableReferentiel = referentielDAL.ObtenirListeReferentiel_SQLITE();
ReferentielBLL referentielBLL = new ReferentielBLL();
VariablePartage.TableReferentielFiltre = referentielBLL.FiltrerListeReferentiel_parCPL(VariablePartage.TableReferentiel, CPLCLEF);
CorrespondanceDAL correspondanceDAL = new CorrespondanceDAL();
VariablePartage.TableCorrespondance = correspondanceDAL.ObtenirListeCorrespondance_SQLITE(VariablePartage.TableReferentiel, myform);
CorrespondanceBLL correspondanceBLL = new CorrespondanceBLL();
VariablePartage.TableCorrespondanceFiltre = correspondanceBLL.FiltrerListeCorrespondance_parCPL(VariablePartage.TableCorrespondance, CPLCLEF);
DataGridView dataGridView_ref = new DataGridView();
dataGridView_ref.BindingContext = new BindingContext(); // this makes it work.
var bindingListRef = new BindingList <ReferentielBLL>(VariablePartage.TableReferentielFiltre);
var source_ref = new BindingSource(bindingListRef, null);
dataGridView_ref.DataSource = source_ref;
DataGridView dataGridView_saisie = new DataGridView();
dataGridView_saisie.BindingContext = new BindingContext(); // this makes it work.
var bindingListCorr = new BindingList <CorrespondanceBLL>(VariablePartage.TableCorrespondanceFiltre);
var source_corr = new BindingSource(bindingListCorr, null);
dataGridView_saisie.DataSource = source_corr;
ActionRecodage actionRecodage = new ActionRecodage();
List <ReferentielBLL> TableRefLevenshtein = new List <ReferentielBLL>();
for (int i = 0; i < VariablePartage.TableCorrespondanceFiltre.Count; i++)
{
TableRefLevenshtein = actionRecodage.SaisieCellClick_ByLigneCorresp(VariablePartage.TableCorrespondanceFiltre[i], VariablePartage.TableReferentielFiltre, VariablePartage.TableReferentiel, CPLCLEF);
if (TableRefLevenshtein.Any())
{
actionRecodage.AffectationCode_ByLigneCorrespReferentiel(VariablePartage.TableCorrespondanceFiltre[i], TableRefLevenshtein[0], VariablePartage.TableCorrespondanceFiltre, VariablePartage.TableCorrespondance, TableRefLevenshtein, CPLCLEF);
Assert.AreEqual(TableRefLevenshtein[0].Code, VariablePartage.TableCorrespondanceFiltre[i].Nouveau_Code);
Assert.AreEqual(TableRefLevenshtein[0].Lib, VariablePartage.TableCorrespondanceFiltre[i].Libelle_Nouveau_Code);
}
else
{
Assert.AreEqual("", VariablePartage.TableCorrespondanceFiltre[i].Nouveau_Code);
Assert.AreEqual("", VariablePartage.TableCorrespondanceFiltre[i].Libelle_Nouveau_Code);
}
//VariablePartage.TableCorrespondanceFiltre = correspondanceBLL.FiltrerListeCorrespondance_parCPL(VariablePartage.TableCorrespondance, CPLCLEF);
}
}
public void AffectationCodeCreeInactifMemeCodeMemeLibelle_ByLigneCorrRef_PersonnelMedical()
{
Form1 myform = new Form1();
string CPLCLEF = "2|0|0|CTRL";
VariablePartage.CheminBaseClient = "C:\\temp\\BaseRecodageCHVAL.db";
ReferentielDAL referentielDAL = new ReferentielDAL();
VariablePartage.TableReferentiel = referentielDAL.ObtenirListeReferentiel_SQLITE();
ReferentielBLL referentielBLL = new ReferentielBLL();
VariablePartage.TableReferentielFiltre = referentielBLL.FiltrerListeReferentiel_parCPL(VariablePartage.TableReferentiel, CPLCLEF);
CorrespondanceDAL correspondanceDAL = new CorrespondanceDAL();
VariablePartage.TableCorrespondance = correspondanceDAL.ObtenirListeCorrespondance_SQLITE(VariablePartage.TableReferentiel, myform);
CorrespondanceBLL correspondanceBLL = new CorrespondanceBLL();
VariablePartage.TableCorrespondanceFiltre = correspondanceBLL.FiltrerListeCorrespondance_parCPL(VariablePartage.TableCorrespondance, CPLCLEF);
DataGridView dataGridView_ref = new DataGridView();
dataGridView_ref.BindingContext = new BindingContext(); // this makes it work.
var bindingListRef = new BindingList <ReferentielBLL>(VariablePartage.TableReferentielFiltre);
var source_ref = new BindingSource(bindingListRef, null);
dataGridView_ref.DataSource = source_ref;
DataGridView dataGridView_saisie = new DataGridView();
dataGridView_saisie.BindingContext = new BindingContext(); // this makes it work.
var bindingListCorr = new BindingList <CorrespondanceBLL>(VariablePartage.TableCorrespondanceFiltre);
var source_corr = new BindingSource(bindingListCorr, null);
dataGridView_saisie.DataSource = source_corr;
ActionRecodage actionRecodage = new ActionRecodage();
List <ReferentielBLL> TableRefLevenshtein = new List <ReferentielBLL>();
for (int i = 0; i < VariablePartage.TableCorrespondanceFiltre.Count; i++)
{
// actionRecodage.AffectationCodeCreeInactifMemeCodeMemeLibelle_ByLigneCorrRef(VariablePartage.TableCorrespondanceFiltre[i], VariablePartage.TableCorrespondance, VariablePartage.TableCorrespondanceFiltre, VariablePartage.TableReferentiel, VariablePartage.TableReferentielFiltre, "2|0|0|CTRL");
if (!referentielBLL.CodeEstDansLeReferentiel(VariablePartage.TableReferentielFiltre, VariablePartage.TableCorrespondanceFiltre[i].Ancien_Code) &&
VariablePartage.TableCorrespondanceFiltre[i].Ancien_Code != null && VariablePartage.TableCorrespondanceFiltre[i].Libelle_Ancien_Code != null &&
VariablePartage.TableCorrespondanceFiltre[i].Ancien_Code != "" && VariablePartage.TableCorrespondanceFiltre[i].Libelle_Ancien_Code != "")
{
Assert.AreEqual(VariablePartage.TableCorrespondanceFiltre[i].Ancien_Code, VariablePartage.TableCorrespondanceFiltre[i].Nouveau_Code);
Assert.AreEqual(VariablePartage.TableCorrespondanceFiltre[i].Libelle_Ancien_Code, VariablePartage.TableCorrespondanceFiltre[i].Libelle_Nouveau_Code);
Assert.AreEqual(true, VariablePartage.TableCorrespondanceFiltre[i].NouveauCodeInactif);
}
}
}
public void AffecteCode_Test_Examen()
{
Form1 myform = new Form1();
myform.InitializeComponent();
string CPLCLEF = "135|0|0|NOMEN";
VariablePartage.CheminBaseClient = "C:\\temp\\BaseRecodageCHVAL.db";
ReferentielDAL referentielDAL = new ReferentielDAL();
VariablePartage.TableReferentiel = referentielDAL.ObtenirListeReferentiel_SQLITE();
ReferentielBLL referentielBLL = new ReferentielBLL();
VariablePartage.TableReferentielFiltre = referentielBLL.FiltrerListeReferentiel_parCPL(VariablePartage.TableReferentiel, CPLCLEF);
CorrespondanceDAL correspondanceDAL = new CorrespondanceDAL();
VariablePartage.TableCorrespondance = correspondanceDAL.ObtenirListeCorrespondance_SQLITE(VariablePartage.TableReferentiel, myform);
CorrespondanceBLL correspondanceBLL = new CorrespondanceBLL();
VariablePartage.TableCorrespondanceFiltre = correspondanceBLL.FiltrerListeCorrespondance_parCPL(VariablePartage.TableCorrespondance, CPLCLEF);
DataGridView dataGridView_ref = new DataGridView();
dataGridView_ref.BindingContext = new BindingContext(); // this makes it work.
var bindingListRef = new BindingList <ReferentielBLL>(VariablePartage.TableReferentielFiltre);
var source_ref = new BindingSource(bindingListRef, null);
dataGridView_ref.DataSource = source_ref;
DataGridView dataGridView_saisie = new DataGridView();
dataGridView_saisie.BindingContext = new BindingContext(); // this makes it work.
var bindingListCorr = new BindingList <CorrespondanceBLL>(VariablePartage.TableCorrespondanceFiltre);
var source_corr = new BindingSource(bindingListCorr, null);
dataGridView_saisie.DataSource = source_corr;
ActionRecodage actionRecodage = new ActionRecodage();
List <ReferentielBLL> TableRefLevenshtein = new List <ReferentielBLL>();
myform.comboBox_filtre.SelectedValue = CPLCLEF;
dataGridView_saisie.CurrentCell = dataGridView_saisie.Rows[0].Cells[4];
actionRecodage.SaisieCellClick(dataGridView_saisie, dataGridView_ref, myform, CPLCLEF);
dataGridView_ref.CurrentCell = dataGridView_ref.Rows[0].Cells[1];
actionRecodage.AffectationCode(dataGridView_saisie, dataGridView_ref, myform, CPLCLEF);
//Verifie que l'affectation graphique est bien faite
Assert.AreEqual(dataGridView_saisie.Rows[0].Cells[4].Value.ToString(), dataGridView_ref.Rows[0].Cells[2].Value.ToString());
//Verifie que l'affectation dans l'objet est bien faite
Assert.AreEqual(VariablePartage.TableCorrespondanceFiltre[0].Nouveau_Code, VariablePartage.TableReferentielFiltre[0].Code);
}
public void DesaffecteCode_Saisie_ByLigneCorresp_PersonnelMedical()
{
Form1 myform = new Form1();
string CPLCLEF = "2|0|0|CTRL";
VariablePartage.CheminBaseClient = "C:\\temp\\BaseRecodageCHVAL.db";
ReferentielDAL referentielDAL = new ReferentielDAL();
VariablePartage.TableReferentiel = referentielDAL.ObtenirListeReferentiel_SQLITE();
ReferentielBLL referentielBLL = new ReferentielBLL();
VariablePartage.TableReferentielFiltre = referentielBLL.FiltrerListeReferentiel_parCPL(VariablePartage.TableReferentiel, CPLCLEF);
CorrespondanceDAL correspondanceDAL = new CorrespondanceDAL();
VariablePartage.TableCorrespondance = correspondanceDAL.ObtenirListeCorrespondance_SQLITE(VariablePartage.TableReferentiel, myform);
CorrespondanceBLL correspondanceBLL = new CorrespondanceBLL();
VariablePartage.TableCorrespondanceFiltre = correspondanceBLL.FiltrerListeCorrespondance_parCPL(VariablePartage.TableCorrespondance, CPLCLEF);
DataGridView dataGridView_ref = new DataGridView();
dataGridView_ref.BindingContext = new BindingContext(); // this makes it work.
var bindingListRef = new BindingList <ReferentielBLL>(VariablePartage.TableReferentielFiltre);
var source_ref = new BindingSource(bindingListRef, null);
dataGridView_ref.DataSource = source_ref;
DataGridView dataGridView_saisie = new DataGridView();
dataGridView_saisie.BindingContext = new BindingContext(); // this makes it work.
var bindingListCorr = new BindingList <CorrespondanceBLL>(VariablePartage.TableCorrespondanceFiltre);
var source_corr = new BindingSource(bindingListCorr, null);
dataGridView_saisie.DataSource = source_corr;
ActionRecodage actionRecodage = new ActionRecodage();
for (int i = 0; i < VariablePartage.TableCorrespondanceFiltre.Count; i++)
{
//actionRecodage.DesaffecteCode_Saisie_ByLigneCorresp(VariablePartage.TableCorrespondanceFiltre[i], VariablePartage.TableCorrespondanceFiltre, VariablePartage.TableCorrespondance);
Assert.AreEqual("", VariablePartage.TableCorrespondanceFiltre[i].Nouveau_Code);
Assert.AreEqual("", VariablePartage.TableCorrespondanceFiltre[i].Libelle_Nouveau_Code);
}
}
public void TestCalcLevenshtein()
{
VariablePartage.CheminBaseClient = "E:\\temp\\CHVAL.db";
Form1 myform = new Form1();
LevenshteinBLL objLevenshtein = new LevenshteinBLL();
ReferentielDAL RefObject = new ReferentielDAL();
CorrespondanceDAL CorrObject = new CorrespondanceDAL();
ComboBoxFiltreDAL ComboboxObject = new ComboBoxFiltreDAL();
VariablePartage.TableReferentiel = RefObject.ObtenirListeReferentiel_SQLITE();
VariablePartage.TableCorrespondance = CorrObject.ObtenirListeCorrespondance_SQLITE(VariablePartage.TableReferentiel, myform);
GUIFonction GUI = new GUIFonction();
GUI.InitListeNomRef_admin();
VariablePartage.ComboBoxFiltre = ComboboxObject.ObtenirComboBoxFiltre();
objLevenshtein.InitALLLevenshtein(VariablePartage.TableCorrespondance, VariablePartage.TableReferentiel, VariablePartage.ComboBoxFiltre);
}
public List <CorrespondanceBLL> DeleteRattachementEntEtab(List <CorrespondanceBLL> CorrespFULL, string CodeEtablissement)
{
List <CorrespondanceBLL> CorrespRattachementSupprime = new List <CorrespondanceBLL>();
for (int i = 0; i < CorrespFULL.Count; i++)
{
if (CorrespFULL[i].Cpl != "1000" || CorrespFULL[i].Ancien_Code != CodeEtablissement)
{
CorrespRattachementSupprime.Add(CorrespFULL[i]);
}
else
{
Console.WriteLine("Je supprime la ligne suivante : " + CorrespFULL[i]);
CorrespondanceDAL correspondanceDAL = new CorrespondanceDAL();
correspondanceDAL.DeleteSQLITE_TBCorrespondance(CorrespFULL[i]);
}
}
return(CorrespRattachementSupprime);
}
public void TestBindingDatagrid()
{
Form1 myform = new Form1();
string CPLCLEF = "135|0|0|NOMEN";
VariablePartage.CheminBaseClient = "C:\\temp\\BaseRecodageCHVAL.db";
ReferentielDAL referentielDAL = new ReferentielDAL();
VariablePartage.TableReferentiel = referentielDAL.ObtenirListeReferentiel_SQLITE();
ReferentielBLL referentielBLL = new ReferentielBLL();
VariablePartage.TableReferentielFiltre = referentielBLL.FiltrerListeReferentiel_parCPL(VariablePartage.TableReferentiel, CPLCLEF);
CorrespondanceDAL correspondanceDAL = new CorrespondanceDAL();
VariablePartage.TableCorrespondance = correspondanceDAL.ObtenirListeCorrespondance_SQLITE(VariablePartage.TableReferentiel, myform);
CorrespondanceBLL correspondanceBLL = new CorrespondanceBLL();
VariablePartage.TableCorrespondanceFiltre = correspondanceBLL.FiltrerListeCorrespondance_parCPL(VariablePartage.TableCorrespondance, CPLCLEF);
DataGridView dataGridView_ref = new DataGridView();
dataGridView_ref.BindingContext = new BindingContext(); // this makes it work.
var bindingListRef = new BindingList <ReferentielBLL>(VariablePartage.TableReferentielFiltre);
var source_ref = new BindingSource(bindingListRef, null);
dataGridView_ref.DataSource = source_ref;
DataGridView dataGridView_saisie = new DataGridView();
dataGridView_saisie.BindingContext = new BindingContext(); // this makes it work.
var bindingListCorr = new BindingList <CorrespondanceBLL>(VariablePartage.TableCorrespondanceFiltre);
var source_corr = new BindingSource(bindingListCorr, null);
dataGridView_saisie.DataSource = source_corr;
Assert.AreEqual(dataGridView_saisie.Rows[0].Cells[1].Value.ToString(), "55|P01");
}
public void RoutineCreationExamenResExamPuisSuppression()
{
Form1 myform = new Form1();
string CPLCLEF = "135|0|0|NOMEN";
VariablePartage.CheminBaseClient = "C:\\temp\\BaseRecodageCHVAL.db";
ReferentielDAL referentielDAL = new ReferentielDAL();
VariablePartage.TableReferentiel = referentielDAL.ObtenirListeReferentiel_SQLITE();
ReferentielBLL referentielBLL = new ReferentielBLL();
VariablePartage.TableReferentielFiltre = referentielBLL.FiltrerListeReferentiel_parCPL(VariablePartage.TableReferentiel, CPLCLEF);
CorrespondanceDAL correspondanceDAL = new CorrespondanceDAL();
VariablePartage.TableCorrespondance = correspondanceDAL.ObtenirListeCorrespondance_SQLITE(VariablePartage.TableReferentiel, myform);
CorrespondanceBLL correspondanceBLL = new CorrespondanceBLL();
VariablePartage.TableCorrespondanceFiltre = correspondanceBLL.FiltrerListeCorrespondance_parCPL(VariablePartage.TableCorrespondance, CPLCLEF);
DataGridView dataGridView_ref = new DataGridView();
dataGridView_ref.BindingContext = new BindingContext(); // this makes it work.
var bindingListRef = new BindingList <ReferentielBLL>(VariablePartage.TableReferentielFiltre);
var source_ref = new BindingSource(bindingListRef, null);
dataGridView_ref.DataSource = source_ref;
DataGridView dataGridView_saisie = new DataGridView();
dataGridView_saisie.BindingContext = new BindingContext(); // this makes it work.
var bindingListCorr = new BindingList <CorrespondanceBLL>(VariablePartage.TableCorrespondanceFiltre);
var source_corr = new BindingSource(bindingListCorr, null);
dataGridView_saisie.DataSource = source_corr;
ActionRecodage actionRecodage = new ActionRecodage();
List <ReferentielBLL> TableRefLevenshtein = new List <ReferentielBLL>();
/*
* for (int i = 0; i < VariablePartage.TableCorrespondanceFiltre.Count; i++)
* {
* actionRecodage.AffectationCodeCreeInactifMemeCodeMemeLibelle_ByLigneCorrRef(VariablePartage.TableCorrespondanceFiltre[i], VariablePartage.TableCorrespondance, VariablePartage.TableCorrespondanceFiltre, VariablePartage.TableReferentiel, VariablePartage.TableReferentielFiltre, "2|0|0|CTRL");
* if (!referentielBLL.CodeEstDansLeReferentiel(VariablePartage.TableReferentielFiltre, VariablePartage.TableCorrespondanceFiltre[i].Ancien_Code)
* && VariablePartage.TableCorrespondanceFiltre[i].Ancien_Code != null && VariablePartage.TableCorrespondanceFiltre[i].Libelle_Ancien_Code != null
* && VariablePartage.TableCorrespondanceFiltre[i].Ancien_Code != "" && VariablePartage.TableCorrespondanceFiltre[i].Libelle_Ancien_Code != "")
* {
* Assert.AreEqual(VariablePartage.TableCorrespondanceFiltre[i].Ancien_Code, VariablePartage.TableCorrespondanceFiltre[i].Nouveau_Code);
* Assert.AreEqual(VariablePartage.TableCorrespondanceFiltre[i].Libelle_Ancien_Code, VariablePartage.TableCorrespondanceFiltre[i].Libelle_Nouveau_Code);
* Assert.AreEqual(true, VariablePartage.TableCorrespondanceFiltre[i].NouveauCodeInactif);
* TableRefLevenshtein = actionRecodage.SaisieCellClick_ByLigneCorresp(VariablePartage.TableCorrespondanceFiltre[i], VariablePartage.TableReferentielFiltre, VariablePartage.TableReferentiel, CPLCLEF);
* Assert.AreEqual(VariablePartage.TableCorrespondanceFiltre[i].Nouveau_Code, TableRefLevenshtein[0].Code);
* Assert.AreEqual(VariablePartage.TableCorrespondanceFiltre[i].Libelle_Nouveau_Code, TableRefLevenshtein[0].Lib);
* }
* }*/
VariablePartage.TableReferentiel = actionRecodage.DesaffecteCode_Referentiel_ByLigneCorr(VariablePartage.TableCorrespondanceFiltre[0], VariablePartage.TableReferentiel, VariablePartage.TableReferentielFiltre, CPLCLEF);
VariablePartage.TableReferentielFiltre = referentielBLL.FiltrerListeReferentiel_parCPL(VariablePartage.TableReferentiel, CPLCLEF);
//actionRecodage.DesaffecteCode_Saisie_ByLigneCorresp(VariablePartage.TableCorrespondanceFiltre[0], VariablePartage.TableCorrespondanceFiltre, VariablePartage.TableCorrespondance);
// actionRecodage.AffectationCodeCreeInactifMemeCodeMemeLibelle_ByLigneCorrRef(VariablePartage.TableCorrespondanceFiltre[0], VariablePartage.TableCorrespondance, VariablePartage.TableCorrespondanceFiltre, VariablePartage.TableReferentiel, VariablePartage.TableReferentielFiltre, CPLCLEF);
TableRefLevenshtein = actionRecodage.SaisieCellClick_ByLigneCorresp(VariablePartage.TableCorrespondanceFiltre[1], VariablePartage.TableReferentielFiltre, VariablePartage.TableReferentiel, CPLCLEF);
if (TableRefLevenshtein.Any())
{
Assert.AreEqual("", "");
}
else
{
//Assert.AreEqual(null, TableRefLevenshtein[0].Code); // Erreur
}
}
