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 List <ReferentielBLL> SupprimeResExamByExam_RetourneTableRef(List <ReferentielBLL> Referentiel, List <ReferentielBLL> LignesResExamASupprimer) { ReferentielDAL RefObjectDAL = new ReferentielDAL(); RefObjectDAL.DeleteFromSQLITE_TBReferentiel(LignesResExamASupprimer); for (int i = 0; i < LignesResExamASupprimer.Count; i++) { Referentiel = SuppressionItem_RetourneListeReferentiel(Referentiel, LignesResExamASupprimer[i]); } return(Referentiel); }
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 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 } }