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 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 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 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 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 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));
}
