public void Annuler() { ActionRecodage actionRecodage = new ActionRecodage(); actionRecodage.DesaffecteCode(form1.dataGridView_saisie, form1.dataGridView_ref, form1); Close(); }
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 FilterModule_invoke(Form1 myform) { try { ActionRecodage actionRecodage = new ActionRecodage(); myform.Invoke((FilterModuleDelegate)actionRecodage.FilterModule, myform.dataGridView_saisie, myform.dataGridView_ref, myform); } catch (Exception e) { Console.WriteLine(e.Message); } }
public void Valider() { ActionRecodage actionRecodage = new ActionRecodage(); //Form1 myform = new Form1(); bool codeactif; if (checkBox_inactif.Checked == true) { codeactif = false; } else { codeactif = true; } actionRecodage.CreerCodeInterfaceAvancee(myform.dataGridView_saisie, myform.dataGridView_ref, myform, textBox_nouveau_code.Text, textBox_libelle_nouveau_code.Text, codeactif); this.Close(); }
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); } }
/* * private void dataGridView_saisie_CellEndEdit(object sender, DataGridViewCellEventArgs e) * { * if (dataGridView_saisie.CurrentCell == dataGridView_saisie.Rows[e.RowIndex].Cells[5] * && dataGridView_saisie.Rows[e.RowIndex].Cells[5].Value != null * && dataGridView_saisie.Rows[e.RowIndex].Cells[5].Value.ToString().Trim() != "") * { * dataGridView_saisie.CurrentRow.Cells[20].Value = 0; * ActionRecodage.CreerCodeInterfaceAvancee(dataGridView_saisie, dataGridView_ref, this, dataGridView_saisie.Rows[e.RowIndex].Cells[4].Value.ToString().Trim(), dataGridView_saisie.Rows[e.RowIndex].Cells[5].Value.ToString().Trim()); * } * //else if (dataGridView_saisie.CurrentCell == dataGridView_saisie.Rows[e.RowIndex].Cells[5] * // && (dataGridView_saisie.Rows[e.RowIndex].Cells[5].Value == null * // || dataGridView_saisie.Rows[e.RowIndex].Cells[5].Value.ToString().Trim() == "")) * //{ * // MessageBox.Show("Code et Libellé obligatoire."); * // dataGridView_saisie.CurrentCell = dataGridView_saisie.Rows[e.RowIndex].Cells[5]; * // dataGridView_saisie.EditMode = DataGridViewEditMode.EditProgrammatically; * // dataGridView_saisie.BeginEdit(true); * //} * else if (dataGridView_saisie.CurrentCell == dataGridView_saisie.Rows[e.RowIndex].Cells[4] * && dataGridView_saisie.Rows[e.RowIndex].Cells[4].Value != null * && dataGridView_saisie.Rows[e.RowIndex].Cells[4].Value.ToString().Trim() != "") * { * dataGridView_saisie.CurrentCell = dataGridView_saisie.Rows[e.RowIndex].Cells[5]; * dataGridView_saisie.ReadOnly = false; * dataGridView_saisie.EditMode = DataGridViewEditMode.EditProgrammatically; * dataGridView_saisie.BeginEdit(true); * } * } */ private void dataGridView_ref_MouseClick(object sender, MouseEventArgs e) { if (e.Button == MouseButtons.Right) { ActionRecodage actionRecodage = new ActionRecodage(); ContextMenu m = new ContextMenu(); //m.MenuItems.Add(new MenuItem("Creer en inactif, même code, même libellé. (Raccourci clavier : C)", actionRecodage.CreerCodeInactifMemeCodeMemeLibelle_ByMenuItem(sender,e,dataGridView_saisie,dataGridView_ref,this))); m.MenuItems.Add(new MenuItem("Affecter code (Raccourci clavier : ESPACE ou Double-Click gauche)", AffecterCode_ByMenuItem)); //MessageBox.Show("e.RowIndex.ToString() : " + e.RowIndex.ToString() + "\r\ne.X : " + e.X + "\r\ne.Y : " + e.Y); int currentMouseOverRow = dataGridView_ref.HitTest(e.X, e.Y).RowIndex; int currentMouseOverColumns = dataGridView_ref.HitTest(e.X, e.Y).ColumnIndex; if (currentMouseOverRow >= 0) { //m.MenuItems.Add(new MenuItem(string.Format("Do something to row {0}", currentMouseOverRow.ToString()))); m.Show(dataGridView_ref, new Point(e.X, e.Y)); } } }
private void dataGridView_saisie_MouseClick(object sender, MouseEventArgs e) { if (e.Button == MouseButtons.Right) { ActionRecodage actionRecodage = new ActionRecodage(); ContextMenu m = new ContextMenu(); //m.MenuItems.Add(new MenuItem("Creer en inactif, même code, même libellé. (Raccourci clavier : C)", actionRecodage.CreerCodeInactifMemeCodeMemeLibelle_ByMenuItem(sender,e,dataGridView_saisie,dataGridView_ref,this))); m.MenuItems.Add(new MenuItem("Creer en inactif, même code, même libellé. (Raccourci clavier : C)", CreerCodeInactifMemeCodeMemeLibelle_ByMenuItem)); m.MenuItems.Add(new MenuItem("Creer en actif, même code, même libellé. (Raccourci clavier : A)", CreerCodeActifMemeCodeMemeLibelle_ByMenuItem)); m.MenuItems.Add(new MenuItem("Creer personnalisé (Raccourci clavier : F2)", AfficherCreationCode_ByMenuItem)); m.MenuItems.Add(new MenuItem("Supprimer recodage (Raccourci clavier : SUPPR.)", SupprimerRecodage_ByMenuItem)); m.MenuItems.Add(new MenuItem("Ne pas reprendre (Raccourci clavier : N)", NePasReprendre_ByMenuItem)); int currentMouseOverRow = dataGridView_saisie.HitTest(e.X, e.Y).RowIndex; int currentMouseOverColumns = dataGridView_saisie.HitTest(e.X, e.Y).ColumnIndex; if (currentMouseOverRow >= 0 && currentMouseOverColumns == 4) { //m.MenuItems.Add(new MenuItem(string.Format("Do something to row {0}", currentMouseOverRow.ToString()))); m.Show(dataGridView_saisie, new Point(e.X, e.Y)); } } }
public void NePasReprendre_ByMenuItem(Object sender, System.EventArgs e) { ActionRecodage actionRecodage = new ActionRecodage(); actionRecodage.NePasReprendre(dataGridView_saisie, dataGridView_ref, this); }
public void SupprimerRecodage_ByMenuItem(Object sender, System.EventArgs e) { ActionRecodage actionRecodage = new ActionRecodage(); actionRecodage.DeleteButton(dataGridView_saisie, dataGridView_ref, this); }
public void CreerCodeActifMemeCodeMemeLibelle_ByMenuItem(Object sender, System.EventArgs e) { ActionRecodage actionRecodage = new ActionRecodage(); actionRecodage.CreerCodeMemeCodeMemeLibelle(dataGridView_saisie, dataGridView_ref, this, true); }
public void AffecterCode_ByMenuItem(Object sender, System.EventArgs e) { ActionRecodage actionRecodage = new ActionRecodage(); actionRecodage.AffecteCode(dataGridView_saisie, dataGridView_ref, this, (string)comboBox_filtre.SelectedValue); }
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 } }