public void SaveDatas(Enseignant e) { if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "INSERT_ENSEIGNANT"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@idModif", 10, DbType.Int32, e.Id)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@nom", 100, DbType.String, e.Nom)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@postnom", 100, DbType.String, e.Postnom)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@prenom", 100, DbType.String, e.Prenom)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@sexe", 2, DbType.String, e.Sexe)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@dob", 20, DbType.Date, e.DBO)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@annee", 5, DbType.String, e.AnneeFinEtude)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@filiere", 100, DbType.String, e.Filiere)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@refgrade", 20, DbType.Int32, e.RefGrade)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@reftype", 20, DbType.Int32, e.RefType)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@url", 255, DbType.String, e.UrlImage)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@telephone", 255, DbType.String, e.Telephone)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@mail", 255, DbType.String, e.Email)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@statut", 255, DbType.String, e.Statut)); cmd.ExecuteNonQuery(); SaveLogin(e); } }
public void SaveLogin(Enseignant e) { if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "INSERT_LOGIN"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@idModif", 10, DbType.Int32, e.Id)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@pseudo", 50, DbType.String, e.Pseudo)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@pass", 255, DbType.String, e.Pass)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@statut", 255, DbType.String, "Enseignant")); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@nom", 255, DbType.String, e.Nom)); cmd.Parameters.Add(Parametres.Instance.AddParametres(cmd, "@postnom", 255, DbType.String, e.Postnom)); cmd.ExecuteNonQuery(); } }