public static void ajouter(Utilisateur u)
{
var db = new dbProjetE2ProdEntities();
var add = new tblUtilisateur();
add.NomUtil = u.NomUtilisateur;
add.MotPasUtil = u.MotDePasse;
add.MotPasExpire = u.Expire;
add.PremiereConex = u.Premiere;
add.DateModifMotPas = u.DateModifMotPas;
add.IdEmp = u.Emp;
add.IdRole = u.Role;
add.Actif = u.UtilActif;
db.tblUtilisateur.Add(add);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void setCompte(Utilisateur u)
{
var db = new dbProjetE2ProdEntities();
var i = u.NomUtilisateur;
var r =
(from the in db.tblUtilisateur
where the.NomUtil == i
select the).First();
r.NomUtil = u.NomUtilisateur;
r.MotPasUtil = u.MotDePasse;
r.MotPasExpire = u.Expire;
r.PremiereConex = u.Premiere;
r.IdEmp = u.Emp;
r.IdRole = u.Role;
r.Actif = u.UtilActif;
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void addEmploye(Employe settings)
{
var bd = new dbProjetE2ProdEntities();
var ajout = new tblEmploye();
var lstTypeTest = new List<tblTypeTest>();
var tt =
from e in bd.tblTypeTest
select e;
int i = 0;
foreach (tblTypeTest item in tt)
{
foreach (TypeTest ty in settings.lstEmTypeTest)
{
if (item.CodeTypeTest == ty.codeTypeTest)
{
ajout.tblTypeTest.Add(item);
i++;
break;
}
}
if (settings.lstEmTypeTest.Count == i)
break;
}
ajout.IdEmp = settings.idEmp;
ajout.PrenomEmp = settings.prenomEmp;
ajout.NomEmp = settings.nomEmp;
ajout.CourrielEmp = settings.courrielEmp;
ajout.NoTelPrincipal = settings.noTelPrincipal;
ajout.NoTelSecondaire = settings.noTelSecondaire;
ajout.AdressePostale = settings.adressePostale;
ajout.DateEmbaucheEmp = settings.dateEmbaucheEmp;
ajout.CompetenceParticuliere = settings.competenceParticuliere;
ajout.Statut = settings.statut;
ajout.CommentaireEmp = settings.commentaireEmp;
//ajout.tblTypeTest = lstTypeTest;
bd.tblEmploye.Add(ajout);
try
{
bd.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
MessageBox.Show("Une erreur est survenue lors de l'ajout du nouvel employe", "Erreur système", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ajouter(object o)
{
var ajout = new tblPlateforme();
tblSysExp systemp;
//List<tblPlateforme> lstPlat = new List<tblPlateforme>();
//lstPlat.Add(ajout);
//systemp.tblPlateforme = lstPlat;
ICollection<tblSysExp> lstSysExp = new List<tblSysExp>();
ajout.CodePlateforme = ((plateforme)o).codePlate;
ajout.NomPlateforme = ((plateforme)o).nomPlate;
ajout.CodeCategorie = ((plateforme)o).codeCateg;
ajout.CPU = ((plateforme)o).cpuPlate;
ajout.CarteMere = ((plateforme)o).carteMerePlate;
ajout.RAM = ((plateforme)o).ramPlate;
ajout.Stockage=((plateforme)o).stockage;
ajout.DescPlateforme = ((plateforme)o).descPlate;
ajout.InfoSupPlateforme = ((plateforme)o).infoSupPlate;
var db = new dbProjetE2ProdEntities();
foreach (SystemeExploitation item in ((plateforme)o).lstSysExpPlate)
{
systemp = new tblSysExp();
systemp.CodeSysExp = item.CodeSysExp;
systemp.EditionSysExp = item.editSysExp;
systemp.IdSysExp = item.idSysExp;
systemp.InfoSupSysExp = item.infoSysExp;
systemp.NomSysExp = item.nomSysExp;
systemp.Tag = item.tagSysExp;
systemp.VersionSysExp = item.versionSysExp;
systemp.IdSysExp = item.idSysExp;
ajout.tblSysExp.Add(systemp);
// lstSysExp.Add(systemp);
}
//ajout.tblSysExp = lstSysExp;
db.tblPlateforme.Add(ajout);
//ajout.tblSysExp = lstSysExp;
//RequeteSql.addPlateforme(ajout);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void addEmploye(Employe settings)
{
var bd = new dbProjetE2ProdEntities();
var add = new tblEmploye();
var lstTypeTest = new List<tblTypeTest>();
var tt =
from e in bd.tblTypeTest
select e;
int i = 0;
foreach (tblTypeTest item in tt)
{
foreach (TypeTest ty in settings.lstEmTypeTest)
{
if (item.CodeTypeTest == ty.codeTypeTest)
{
lstTypeTest.Add(item);
i++;
break;
}
}
if (settings.lstEmTypeTest.Count == i)
break;
}
add.IdEmp = settings.idEmp;
add.PrenomEmp = settings.prenomEmp;
add.NomEmp = settings.nomEmp;
add.CourrielEmp = settings.courrielEmp;
add.NoTelPrincipal = settings.noTelPrincipal;
add.NoTelSecondaire = settings.noTelSecondaire;
add.AdressePostale = settings.adressePostale;
add.DateEmbaucheEmp = settings.dateEmbaucheEmp;
add.CompetenceParticuliere = settings.competenceParticuliere;
add.Statut = settings.statut;
add.CommentaireEmp = settings.commentaireEmp;
add.tblTypeTest = lstTypeTest;
bd.tblEmploye.Add(add);
try
{
bd.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void addPlateforme(tblPlateforme p)
{
var db = new dbProjetE2ProdEntities();
foreach (tblSysExp tblSysExpTemp in p.tblSysExp)
{
db.tblPlateforme.Add(p);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
}
//static public void setJeu(Jeu jeu)
//{
// var db = new dbProjetE2ProdEntities();
// var r =
// (from j in db.tblJeu
// where j.IdJeu == jeu.idJeu
// select j).First();
// r.NomJeu = jeu.nomJeu;
// r.DescJeu = jeu.descJeu;
// r.Actif = jeu.actif;
// r.InfoSupJeu = jeu.infoSupJeu;
// r.CoteESRB = jeu.coteESRB;
// r.IdGenre = jeu.idGenre;
// r.IdMode = jeu.idMode;
// //Manque le lien aux thèmes
// try
// {
// db.SaveChanges();
// }
// catch (Exception e)
// {
// Console.WriteLine(e);
// }
//}
public static void addJeu(tblJeu p)
{
var db = new dbProjetE2ProdEntities();
foreach (tblTheme tblThemeTemp in p.tblTheme)
{
db.tblJeu.Add(p);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
}
public static void addGenre(Genre genre)
{
var db = new dbProjetE2ProdEntities();
var add = new tblGenre();
add.NomGenre = genre.nomGenre;
add.ComGenre = genre.comGenre;
db.tblGenre.Add(add);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void addMode(Mode mode)
{
var db = new dbProjetE2ProdEntities();
var add = new tblMode();
add.NomMode = mode.nomMode;
add.DescMode = mode.descMode;
db.tblMode.Add(add);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void addClassification(Classification classification)
{
var db = new dbProjetE2ProdEntities();
var add = new tblClassification();
add.CoteESRB = classification.coteESRB;
add.NomESRB = classification.nomESRB;
add.DescESRB = classification.descESRB;
db.tblClassification.Add(add);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void addCateg(Categorie settings)
{
var db = new dbProjetE2ProdEntities();
var add = new tblCategorie();
add.CodeCategorie = settings.codeCateg;
add.ComCategorie = settings.comCateg;
add.DescCategorie = settings.descCateg;
db.tblCategorie.Add(add);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void setClassification(Classification classification)
{
var db = new dbProjetE2ProdEntities();
var r =
(from classif in db.tblClassification
where classif.CoteESRB == classification.coteESRB
select classif).First();
r.NomESRB = classification.nomESRB;
r.DescESRB = classification.descESRB;
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void deleteEmploye(int cle)
{
var bd = new dbProjetE2ProdEntities();
var i = cle;
var r =
(from e in bd.tblEmploye
where e.IdEmp == i
select e).First();
r.Statut = "n";
try
{
bd.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static bool ChangerMDP(Utilisateur u,string NouvMDP)
{
var db = new dbProjetE2ProdEntities();
var r = (from the in db.tblUtilisateur
where the.NomUtil == u.NomUtilisateur
select the).First();
r.MotPasUtil = NouvMDP;
r.PremiereConex = "n";
r.MotPasExpire = "n";
r.DateModifMotPas = DateTime.Now;
try
{
db.SaveChanges();
}
catch (Exception e)
{
return false;
}
return true;
}
public static void deleteClassification(string coteESRB)
{
var db = new dbProjetE2ProdEntities();
var r =
from classif in db.tblClassification
where classif.CoteESRB == coteESRB
select classif;
foreach (var item in r)
{
db.tblClassification.Remove(item);
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void deleteTheme(int idTheme)
{
var db = new dbProjetE2ProdEntities();
var r =
from the in db.tblTheme
where the.IdTheme == idTheme
select the;
foreach (var item in r)
{
db.tblTheme.Remove(item);
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void setTheme(Theme theme)
{
var db = new dbProjetE2ProdEntities();
var r =
(from the in db.tblTheme
where the.IdTheme == theme.idTheme
select the).First();
r.NomTheme = theme.nomTheme;
r.ComTheme = theme.comTheme;
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void setSysExp(SystemeExploitation settings)
{
var db = new dbProjetE2ProdEntities();
var i = Convert.ToInt32(settings.idSysExp);
var r =
(from sysExp in db.tblSysExp
where sysExp.IdSysExp == i
select sysExp).First();
r.CodeSysExp = settings.CodeSysExp;
r.NomSysExp = settings.nomSysExp;
r.EditionSysExp = settings.editSysExp;
r.VersionSysExp = settings.versionSysExp;
r.InfoSupSysExp = settings.infoSysExp;
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void setMode(Mode mode)
{
var db = new dbProjetE2ProdEntities();
var r =
(from mod in db.tblMode
where mod.IdMode == mode.idMode
select mod).First();
r.NomMode = mode.nomMode;
r.DescMode = mode.descMode;
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void setGenre(Genre genre)
{
var db = new dbProjetE2ProdEntities();
var r =
(from gen in db.tblGenre
where gen.IdGenre == genre.idGenre
select gen).First();
r.NomGenre = genre.nomGenre;
r.ComGenre = genre.comGenre;
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void setCateg(Categorie settings)
{
var db = new dbProjetE2ProdEntities();
var r =
(from categ in db.tblCategorie
where categ.CodeCategorie == settings.codeCateg
select categ).First();
r.CodeCategorie = settings.codeCateg;
r.ComCategorie = settings.comCateg;
r.DescCategorie = settings.descCateg;
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void setVersion(version vers)
{
var db = new dbProjetE2ProdEntities();
var r =
(from v in db.tblVersion
where v.CodeVersion == vers.codeVersion
select v).First();
r.DateSortiePrevue = vers.dateSortie;
r.DateVersion = vers.dateVersion;
r.DescVersion = vers.descVersion;
r.IdJeu = vers.idJeu;
r.NomVersion = vers.nomVersion;
r.StadeDeveloppement = vers.stadeVersion;
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void addTheme(Theme theme)
{
var db = new dbProjetE2ProdEntities();
var add = new tblTheme();
add.NomTheme = theme.nomTheme;
add.ComTheme = theme.comTheme;
db.tblTheme.Add(add);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void deleteSysExp(int ID)
{
var db = new dbProjetE2ProdEntities();
var i = Convert.ToInt32(ID);
var r =
from sysExp in db.tblSysExp
where sysExp.IdSysExp == i
select sysExp;
foreach (var item in r)
{
db.tblSysExp.Remove(item);
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void deleteMode(int idMode)
{
var db = new dbProjetE2ProdEntities();
var r =
from mod in db.tblMode
where mod.IdMode == idMode
select mod;
foreach (var item in r)
{
db.tblMode.Remove(item);
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void deleteGenre(int idGenre)
{
var db = new dbProjetE2ProdEntities();
var r =
from gen in db.tblGenre
where gen.IdGenre == idGenre
select gen;
foreach (var item in r)
{
db.tblGenre.Remove(item);
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void addVersion(tblVersion v)
{
var db = new dbProjetE2ProdEntities();
db.tblVersion.Add(v);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void deleteCateg(string code)
{
var db = new dbProjetE2ProdEntities();
var r =
from categ in db.tblCategorie
where categ.CodeCategorie == code
select categ;
foreach (var item in r)
{
db.tblCategorie.Remove(item);
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
/// <summary>
/// Ajouter un nouveau systeme d'exploitation.
/// </summary>
/// <param name="settings">code,nom,edition,version,info supplementaire</param>
public static void addSysExp(SystemeExploitation settings)
{
var db = new dbProjetE2ProdEntities();
var add = new tblSysExp();
add.CodeSysExp = settings.CodeSysExp;
add.NomSysExp = settings.nomSysExp;
add.EditionSysExp = settings.editSysExp;
add.VersionSysExp = settings.versionSysExp;
add.InfoSupSysExp = settings.infoSysExp;
db.tblSysExp.Add(add);
try
{
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void deleteVersion(string code)
{
var db = new dbProjetE2ProdEntities();
var r =
from v in db.tblVersion
where v.CodeVersion == code
select v;
foreach (var item in r)
{
db.tblVersion.Remove(item);
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}