public static int Update(string CurCin, FicheInformations fi)
{
string request = "UPDATE FicheInformation SET CIN=@CIN, Adresse=@Adresse,Civilite=@Civilite, CodePostal=@CodePostal, CoEncadrant=@CoEncadrant, dateNaissance=@dateNaissance, Ville=@Ville," +
"Email=@Email, Employeur=@Employeur, Encadrant=@Encadrant,Gouvernorat=@Gouvernorat,Sujet=@Sujet," +
"LaboUniteeRecherche=@LaboUniteeRecherche, LaboUniteeRechercheCotutelle=@LaboUniteeRechercheCotutelle, Specialite=@Specialite," +
"Nationalite=@Nationalite, NomPrenom=@NomPrenom, PaysOrigine=@PaysOrigine, Profession=@Profession, Telephone=@Telephone, VilleNaissance=@VilleNaissance" +
" WHERE CIN = @CurCin";
SqlCeCommand cmd = new SqlCeCommand(request, Program.cnn);
cmd.Parameters.Add("@CIN", SqlDbType.NVarChar).Value = fi.CIN;
cmd.Parameters.Add("@NomPrenom", SqlDbType.NVarChar).Value = fi.NOMPRENOM;
cmd.Parameters.Add("@Civilite", SqlDbType.NVarChar).Value = fi.CIVILITE;
cmd.Parameters.Add("@DateNaissance", SqlDbType.NVarChar).Value = fi.DATENAISSANCE;
cmd.Parameters.Add("@VilleNaissance", SqlDbType.NVarChar).Value = fi.VILLENAISSANCE;
cmd.Parameters.Add("@PaysOrigine", SqlDbType.NVarChar).Value = fi.PAYSORIGINE;
cmd.Parameters.Add("@Nationalite", SqlDbType.NVarChar).Value = fi.NATIONALITE;
cmd.Parameters.Add("@Adresse", SqlDbType.NVarChar).Value = fi.ADRESSE;
cmd.Parameters.Add("@Ville", SqlDbType.NVarChar).Value = fi.VILLE;
cmd.Parameters.Add("@CodePostal", SqlDbType.NVarChar).Value = fi.CODEPOSTAL;
cmd.Parameters.Add("@Gouvernorat", SqlDbType.NVarChar).Value = fi.GOUVERNORAT;
cmd.Parameters.Add("@Telephone", SqlDbType.NVarChar).Value = fi.TELEPHONE;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = fi.EMAIL;
cmd.Parameters.Add("@Profession", SqlDbType.NVarChar).Value = fi.PROFESSION;
cmd.Parameters.Add("@Employeur", SqlDbType.NVarChar).Value = fi.EMPLOYEUR;
cmd.Parameters.Add("@Specialite", SqlDbType.NVarChar).Value = fi.SPECIALITE;
cmd.Parameters.Add("@LaboUniteeRecherche", SqlDbType.NVarChar).Value = fi.LABOUNITEERECHERCHE;
cmd.Parameters.Add("@LaboUniteeRechercheCotutelle", SqlDbType.NVarChar).Value = fi.LABOUNITEERECHERCHECOTUTELLE;
cmd.Parameters.Add("@Encadrant", SqlDbType.NVarChar).Value = fi.ENCADRANT;
cmd.Parameters.Add("@CoEncadrant", SqlDbType.NVarChar).Value = fi.COENCADRANT;
cmd.Parameters.Add("@Sujet", SqlDbType.NVarChar).Value = fi.SUJET;
cmd.Parameters.Add("@CurCin", SqlDbType.NVarChar).Value = CurCin;
return(DataBaseAccessUtilities.NonQueryRequest(cmd));
}
public static int Insert(FicheInformations fi)
{
string StrSQL = "INSERT INTO FicheInformation VALUES (@CIN,@NomPrenom,@Civilite,@DateNaissance,@VilleNaissance,@PaysOrigine" +
",@Nationalite,@Adresse,@Ville,@CodePostal,@Gouvernorat,@Telephone,@Email,@Profession,@Employeur,@Specialite," +
"@LaboUniteeRecherche,@LaboUniteeRechercheCotutelle,@Encadrant,@CoEncadrant,@Sujet)";
SqlCeCommand cmd = new SqlCeCommand(StrSQL, Program.cnn);
cmd.Parameters.Add("@CIN", SqlDbType.NVarChar).Value = fi.CIN;
cmd.Parameters.Add("@NomPrenom", SqlDbType.NVarChar).Value = fi.NOMPRENOM;
cmd.Parameters.Add("@Civilite", SqlDbType.NVarChar).Value = fi.CIVILITE;
cmd.Parameters.Add("@DateNaissance", SqlDbType.NVarChar).Value = fi.DATENAISSANCE;
cmd.Parameters.Add("@VilleNaissance", SqlDbType.NVarChar).Value = fi.VILLENAISSANCE;
cmd.Parameters.Add("@PaysOrigine", SqlDbType.NVarChar).Value = fi.PAYSORIGINE;
cmd.Parameters.Add("@Nationalite", SqlDbType.NVarChar).Value = fi.NATIONALITE;
cmd.Parameters.Add("@Adresse", SqlDbType.NVarChar).Value = fi.ADRESSE;
cmd.Parameters.Add("@Ville", SqlDbType.NVarChar).Value = fi.VILLE;
cmd.Parameters.Add("@CodePostal", SqlDbType.NVarChar).Value = fi.CODEPOSTAL;
cmd.Parameters.Add("@Gouvernorat", SqlDbType.NVarChar).Value = fi.GOUVERNORAT;
cmd.Parameters.Add("@Telephone", SqlDbType.NVarChar).Value = fi.TELEPHONE;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = fi.EMAIL;
cmd.Parameters.Add("@Profession", SqlDbType.NVarChar).Value = fi.PROFESSION;
cmd.Parameters.Add("@Employeur", SqlDbType.NVarChar).Value = fi.EMPLOYEUR;
cmd.Parameters.Add("@Specialite", SqlDbType.NVarChar).Value = fi.SPECIALITE;
cmd.Parameters.Add("@LaboUniteeRecherche", SqlDbType.NVarChar).Value = fi.LABOUNITEERECHERCHE;
cmd.Parameters.Add("@LaboUniteeRechercheCotutelle", SqlDbType.NVarChar).Value = fi.LABOUNITEERECHERCHECOTUTELLE;
cmd.Parameters.Add("@Encadrant", SqlDbType.NVarChar).Value = fi.ENCADRANT;
cmd.Parameters.Add("@CoEncadrant", SqlDbType.NVarChar).Value = fi.COENCADRANT;
cmd.Parameters.Add("@Sujet", SqlDbType.NVarChar).Value = fi.SUJET;
return(DataBaseAccessUtilities.NonQueryRequest(cmd));
}
public static int getInscriptionsNumber(string Cin)
{
string request = "SELECT count(*) from Inscription where CIN=@CIN";
SqlCeCommand cmd = new SqlCeCommand(request, Program.cnn);
cmd.Parameters.Add("@CIN", SqlDbType.NVarChar).Value = Cin;
return((int)DataBaseAccessUtilities.ScalarRequest(cmd));
}
public static int Delete(string Id)
{
string StrSQL = "DELETE FROM Inscription WHERE id = @Id";
SqlCeCommand cmd = new SqlCeCommand(StrSQL, Program.cnn);
cmd.Parameters.Add("@Id", SqlDbType.NVarChar).Value = Id;
return(DataBaseAccessUtilities.NonQueryRequest(cmd));
}
public static int delete(string Cin)
{
string request = "delete from FicheInformation where CIN=@CIN";
SqlCeCommand cmd = new SqlCeCommand(request, Program.cnn);
cmd.Parameters.Add("@CIN", SqlDbType.NVarChar).Value = Cin;
return(DataBaseAccessUtilities.NonQueryRequest(cmd));
}
public static void Delete(int EntityKey)
{
using (SqlConnection con = DbConnection.GetConnection())
{
string StrSQL = "DELETE FROM Article WHERE Id=@EntityKey";
SqlCommand command = new SqlCommand(StrSQL, con);
command.Parameters.AddWithValue("@EntityKey", EntityKey);
DataBaseAccessUtilities.NonQueryRequest(command);
}
}
public static int Insert(Inscription I)
{
string request = "INSERT INTO Inscription(AnneeUniversitaire,Niveau,Commentaire,Cin) VALUES(@AnneeUniversitaire,@Niveau,@Commentaire,@Cin)";
SqlCeCommand cmd = new SqlCeCommand(request, Program.cnn);
cmd.Parameters.Add("@AnneeUniversitaire", SqlDbType.NVarChar).Value = I.ANNEEUNIVERSITAIRE;
cmd.Parameters.Add("@Niveau", SqlDbType.NVarChar).Value = I.NIVEAU;
cmd.Parameters.Add("@Commentaire", SqlDbType.NVarChar).Value = I.COMMENTAIRE;
cmd.Parameters.Add("@Cin", SqlDbType.NVarChar).Value = I.CIN;
return(DataBaseAccessUtilities.NonQueryRequest(cmd));
}
public static void bindDataToCmbValeur(SqlCeConnection MyConnection, ComboBox Cmb, string ParamTableName, string ParamValueMember, string ParamDisplayMember)
{
DataTable dtSource;
dtSource = DataBaseAccessUtilities.SelectRequest("SELECT * FROM " + ParamTableName, MyConnection);
if (dtSource != null)
{
Cmb.DataSource = dtSource;
Cmb.ValueMember = ParamValueMember;
Cmb.DisplayMember = ParamDisplayMember;
Cmb.SelectedIndex = -1;
}
}
public static int Insert(Diplome D)
{
string request = "INSERT INTO Diplome(Annee,Diplome,Specialite,Mention,Institution,Cin) VALUES(@Annee,@Diplome,@Specialite,@Mention,@Institution,@Cin)";
SqlCeCommand cmd = new SqlCeCommand(request, Program.cnn);
cmd.Parameters.Add("@Annee", SqlDbType.NVarChar).Value = D.ANNEE;
cmd.Parameters.Add("@Diplome", SqlDbType.NVarChar).Value = D.DIPLOME;
cmd.Parameters.Add("@Specialite", SqlDbType.NVarChar).Value = D.SPECIALITE;
cmd.Parameters.Add("@Mention", SqlDbType.NVarChar).Value = D.MENTION;
cmd.Parameters.Add("@Institution", SqlDbType.NVarChar).Value = D.INSTITUTION;
cmd.Parameters.Add("@Cin", SqlDbType.NVarChar).Value = D.CIN;
return(DataBaseAccessUtilities.NonQueryRequest(cmd));
}
public static int Update(string Id, Inscription I)
{
string StrSQL = "UPDATE Inscription SET AnneeUniversitaire=@AnneeUniversitaire,Niveau=@Niveau, Commentaire=@Commentaire WHERE id = @Id";
SqlCeCommand Command = new SqlCeCommand(StrSQL, Program.cnn);
Command.Parameters.Add("@AnneeUniversitaire", SqlDbType.NVarChar).Value = I.ANNEEUNIVERSITAIRE;
Command.Parameters.Add("@Niveau", SqlDbType.NVarChar).Value = I.NIVEAU;
Command.Parameters.Add("@Commentaire", SqlDbType.NVarChar).Value = I.COMMENTAIRE;
Command.Parameters.Add("@Cin", SqlDbType.NVarChar).Value = I.CIN;
Command.Parameters.Add("@Id", SqlDbType.Int).Value = Id;
return(DataBaseAccessUtilities.NonQueryRequest(Command));
}
public static void Add(Article article)
{
using (SqlConnection con = DbConnection.GetConnection())
{
string StrSQL = "INSERT INTO Article (Designation, Categorie, Prix, DateFabrication) VALUES (@Designation, @Categorie,@Prix, @DateFabrication)";
SqlCommand command = new SqlCommand(StrSQL, con);
command.Parameters.AddWithValue("@Designation", article.Designation ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@Categorie", article.Categorie ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@Prix", article.Prix ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@DateFabrication", article.DateFabrication ?? (object)DBNull.Value);
DataBaseAccessUtilities.NonQueryRequest(command);
}
}
public static List <Article> SelectAll()
{
DataTable dataTable;
using (SqlConnection con = DbConnection.GetConnection())
{
con.Open();
string StrSQL = "SELECT * FROM Article";
SqlCommand command = new SqlCommand(StrSQL, con);
dataTable = DataBaseAccessUtilities.SelectRequest(command);
}
return(GetListFromDataTable(dataTable));
}
public static int update(string id, Diplome D)
{
string request = "update Diplome set Annee=@Annee, Diplome=@Diplome,Specialite=@Specialite, Mention=@Mention, Institution=@Institution where id=@Id";
SqlCeCommand cmd = new SqlCeCommand(request, Program.cnn);
cmd.Parameters.Add("@Annee", SqlDbType.NVarChar).Value = D.ANNEE;
cmd.Parameters.Add("@Diplome", SqlDbType.NVarChar).Value = D.DIPLOME;
cmd.Parameters.Add("@Specialite", SqlDbType.NVarChar).Value = D.SPECIALITE;
cmd.Parameters.Add("@Mention", SqlDbType.NVarChar).Value = D.MENTION;
cmd.Parameters.Add("@Institution", SqlDbType.NVarChar).Value = D.INSTITUTION;
cmd.Parameters.Add("@Id", SqlDbType.NVarChar).Value = id;
return(DataBaseAccessUtilities.NonQueryRequest(cmd));
}
public static void Update(int id, Article article)
{
using (SqlConnection con = DbConnection.GetConnection())
{
string StrSQL = "UPDATE Article SET Designation= @Designation, Categorie = @Categorie, Prix = @Prix, DateFabrication = @DateFabrication WHERE Id = @CurId";
SqlCommand command = new SqlCommand(StrSQL, con);
command.Parameters.AddWithValue("@CurId", id);
command.Parameters.AddWithValue("@Designation", article.Designation ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@Categorie", article.Categorie ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@Prix", article.Prix ?? (object)DBNull.Value);
command.Parameters.AddWithValue("@DateFabrication", article.DateFabrication ?? (object)DBNull.Value);
DataBaseAccessUtilities.NonQueryRequest(command);
}
}
public static ListInscription SelectAll()
{
string StrSQL = "SELECT * FROM Inscription ";
SqlCeCommand Command = new SqlCeCommand(StrSQL, Program.cnn);
DataTable Table = DataBaseAccessUtilities.SelectRequest(Command);
if (Table != null && Table.Rows.Count != 0)
{
return(new ListInscription(Table));
}
else
{
return(null);
}
}
public static ListFicheInformations SelectAll()
{
string request = "SELECT * FROM FicheInformation order by NomPrenom ASC";
SqlCeCommand cmd = new SqlCeCommand(request, Program.cnn);
DataTable dt = DataBaseAccessUtilities.SelectRequest(cmd);
if (dt != null && dt.Rows.Count != 0)
{
return(new ListFicheInformations(dt));
}
else
{
return(null);
}
}
public static ListDiplome selectAll()
{
string request = "SELECT * FROM Diplome";
SqlCeCommand cmd = new SqlCeCommand(request, Program.cnn);
DataTable dt = DataBaseAccessUtilities.SelectRequest(cmd);
if ((dt != null) && (dt.Rows.Count != 0))
{
return(new ListDiplome(dt));
}
else
{
return(null);
}
}
public static ListInscription SelectByCriterium(string FieldName, SqlDbType FieldType, string FieldValue)
{
string StrSQL = "SELECT * FROM Inscription WEHRE " + FieldName + "= @" + FieldName;
SqlCeCommand Command = new SqlCeCommand(StrSQL, Program.cnn);
Command.Parameters.Add("@" + FieldName, FieldType).Value = FieldValue;
DataTable Table = DataBaseAccessUtilities.SelectRequest(Command);
if (Table != null && Table.Rows.Count != 0)
{
return(new ListInscription(Table));
}
else
{
return(null);
}
}
public static Inscription SelectById(string Id)
{
string StrSQL = "SELECT * FROM Inscription WEHRE Id = @Id";
SqlCeCommand Command = new SqlCeCommand(StrSQL, Program.cnn);
Command.Parameters.Add("@Id", SqlDbType.NVarChar).Value = Id;
DataTable dt = DataBaseAccessUtilities.SelectRequest(Command);
if (dt != null && dt.Rows.Count != 0)
{
return(new Inscription(dt.Rows[0]));
}
else
{
return(null);
}
}
public static ListFicheInformations SelectByCriterium(string FieldName, SqlDbType FieldType, string FieldValue)
{
string request = "SELECT * FROM FicheInformation where " + FieldName + " = @" + FieldName;
SqlCeCommand Command = new SqlCeCommand(request, Program.cnn);
Command.Parameters.Add("@" + FieldName, FieldType).Value = FieldValue;
DataTable Table = DataBaseAccessUtilities.SelectRequest(Command);
if (Table != null && Table.Rows.Count != 0)
{
return(new ListFicheInformations(Table));
}
else
{
return(null);
}
}
public static DataTable SelectInscriptionByCin(string cin)
{
string StrSQL = "SELECT AnneeUniversitaire,Niveau FROM Inscription WHERE Cin=@Cin";
SqlCeCommand Command = new SqlCeCommand(StrSQL, Program.cnn);
Command.Parameters.Add("@Cin", SqlDbType.NVarChar).Value = cin;
DataTable Table = DataBaseAccessUtilities.SelectRequest(Command);
if (Table != null)
{
return(Table);
}
else
{
return(null);
}
}
public static ListInscription SelectByCIN(string Cin)
{
string StrSQL = "SELECT * FROM Inscription WHERE Cin= @Cin";
SqlCeCommand Command = new SqlCeCommand(StrSQL, Program.cnn);
Command.Parameters.Add("@Cin", SqlDbType.NVarChar).Value = Cin;
DataTable Table = DataBaseAccessUtilities.SelectRequest(Command);
if (Table != null && Table.Rows.Count != 0)
{
return(new ListInscription(Table));
}
else
{
return(null);
}
}
public static bool checkKeyUnicity(string Cin)
{
string request = "SELECT count(*) from FicheInformation where CIN=@CIN";
SqlCeCommand cmd = new SqlCeCommand(request, Program.cnn);
cmd.Parameters.Add("@CIN", SqlDbType.NVarChar).Value = Cin;
int x = (int)DataBaseAccessUtilities.ScalarRequest(cmd);
if (x == 0)
{
return(false);
}
else
{
return(true);
}
}
public static Article SelectById(int EntityKey)
{
using (SqlConnection con = DbConnection.GetConnection())
{
con.Open();
string StrSQL = "SELECT * FROM Article WHERE Id = @EntityKey";
SqlCommand command = new SqlCommand(StrSQL, con);
command.Parameters.AddWithValue("@EntityKey", EntityKey);
DataTable dt = DataBaseAccessUtilities.SelectRequest(command);
if (dt != null && dt.Rows.Count != 0)
{
return(GetEntityFromDataRow(dt.Rows[0]));
}
else
{
return(null);
}
}
}
