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 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
}
}
public List <ReferentielBLL> ObtenirListeReferentiel_SQLITE()
{
Console.WriteLine("ici");
using (ConnexionSQLITE con = new ConnexionSQLITE())
{
Dictionary <string, string> columnNameToAddColumnSql = new Dictionary <string, string>
{
{
"FlagPreventiel",
"ALTER TABLE TB$S_PrevReferentiel ADD COLUMN FlagPreventiel INTEGER "
}
};
foreach (var pair in columnNameToAddColumnSql)
{
string columnName = pair.Key;
string sql = pair.Value;
try
{
con.ExecuteQuery(sql);
con.ExecuteQuery("Update TB$S_PrevReferentiel set FlagPreventiel = 0");
}
catch (System.Data.SQLite.SQLiteException e)
{
con.sql_con.Close();
Console.WriteLine(string.Format("Failed to create column [{0}]. Most likely it already exists, which is fine.", columnName));
}
}
List <ReferentielBLL> ListRef = new List <ReferentielBLL>();
con.sql_con.Open();
string CommandText = "select * from TB$S_PREVReferentiel";
using (con.sql_cmd = new SQLiteCommand(CommandText, con.sql_con))
{
using (SQLiteDataReader reader = con.sql_cmd.ExecuteReader())
{
Fonc fonc = new Fonc();
while (reader.Read())
{
ReferentielBLL Ref = new ReferentielBLL();
if (reader["Type"] != DBNull.Value)
{
Ref.Type = (string)reader["Type"];
}
if (reader["TypeItem"] != DBNull.Value)
{
Ref.TypeItem = (string)reader["TypeItem"];
}
if (reader["Code"] != DBNull.Value)
{
Ref.Code = (string)reader["Code"];
}
if (reader["Lib"] != DBNull.Value && (string)reader["Lib"] != "")
{
Ref.Lib = (string)reader["Lib"];
Ref.Canonical = fonc.CanonicalString((string)reader["Lib"]);
}
if (reader["CodeOrigine"] != DBNull.Value)
{
Ref.CodeOrigine = (string)reader["CodeOrigine"];
}
if (reader["InActif"] != DBNull.Value)
{
Ref.InActif = Convert.ToBoolean(reader["InActif"]);
}
//Console.WriteLine(reader["InActif"]);
//Ref.InActif = Convert.ToBoolean(Convert.ToString(reader["InActif"]));
if (reader["Cpl"] != DBNull.Value && (string)reader["Cpl"] != "")
{
Ref.Cpl = (string)reader["Cpl"];
}
else
{
Ref.Cpl = "0";
}
if (reader["Cpl1"] != DBNull.Value && (string)reader["Cpl1"] != "")
{
Ref.Cpl1 = (string)reader["Cpl1"];
}
else
{
Ref.Cpl1 = "0";
}
if (reader["Cpl2"] != DBNull.Value && (string)reader["Cpl2"] != "")
{
Ref.Cpl2 = (string)reader["Cpl2"];
}
else
{
Ref.Cpl2 = "0";
}
if (reader["Cpl3"] != DBNull.Value && (string)reader["Cpl3"] != "")
{
Ref.Cpl3 = (string)reader["Cpl3"];
}
else
{
Ref.Cpl3 = "0";
}
if (reader["DateFinValidite"] != DBNull.Value)
{
Ref.DateFinValidite = (string)reader["DateFinValidite"];
}
if (reader["FlagPreventiel"] != DBNull.Value)
{
Ref.FlagPreventiel = Convert.ToInt32(reader["FlagPreventiel"]);
}
ListRef.Add(Ref);
}
con.sql_con.Close();
con.sql_con.Dispose();
}
}
//sql_cmd = sql_con.CreateCommand();
//string CommandText = "select Type_Item, Ancien_Code, Libelle_Ancien_Code,AncienCodeActif,Nouveau_Code,Libelle_Nouveau_Code,Code_utilise,NomSchema,DateRecensement,DateMAJ,TypeRecodage,NouveauCodeInactif,UtilisateurCreation,TypeRef,NomRef,Cpl,Cpl1,Cpl2,Occurrence from TB$S_CorrespondanceItem";
// where TypeItem !='PersonnePhysique'";
//string CommandText = "select Type,TypeItem,Code,Lib,CodeOrigine,InActif,Cpl,Cpl1,Cpl2,Cpl3,DateFinValidite from TB$S_PREVReferentiel where (Type!='CTRL' and Cpl!='0') ";
//DB = new SQLiteDataAdapter(CommandText, sql_con);
return(ListRef);
}
}
