public int NewSujet(int idRub, string nomUser, string titresujet, string textsujet, DateTime datecreatsujet) { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "NewSujet"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter pIdRub = new SqlParameter("IDRUB", idRub); cmd.Parameters.Add(pIdRub); SqlParameter pNomUser = new SqlParameter("NOMUSER", nomUser); cmd.Parameters.Add(pNomUser); SqlParameter pTitresujet = new SqlParameter("TITRESUJET", titresujet); cmd.Parameters.Add(pTitresujet); SqlParameter pTextsujet = new SqlParameter("TEXTSUJET", textsujet); cmd.Parameters.Add(pTextsujet); SqlParameter pDatecreatsujet = new SqlParameter("DATECREATSUJET", datecreatsujet); cmd.Parameters.Add(pDatecreatsujet); // Ou .......... : //cmd.Parameters.Add(new SqlParameter("IDUSER", idUser)); //cmd.Parameters.Add(new SqlParameter("IDSUJET", idSujet)); //cmd.Parameters.Add(new SqlParameter("TEXTREP", textrep)); int nbLigne = cmd.ExecuteNonQuery(); return nbLigne; }
public int NewReponse(int idSujet, string nomUser, string textrep, DateTime dateenvoirep) { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "NewReponse"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter pIdSujet = new SqlParameter("IDSUJET", idSujet); cmd.Parameters.Add(pIdSujet); SqlParameter pNomUser = new SqlParameter("NOMUSER", nomUser); cmd.Parameters.Add(pNomUser); SqlParameter pTextrep = new SqlParameter("TEXTREP", textrep); cmd.Parameters.Add(pTextrep); SqlParameter pDateenvoirep = new SqlParameter("DATEENVOIREP", dateenvoirep); cmd.Parameters.Add(pDateenvoirep); // Ou .......... : //cmd.Parameters.Add(new SqlParameter("IDUSER", idUser)); //cmd.Parameters.Add(new SqlParameter("IDSUJET", idSujet)); //cmd.Parameters.Add(new SqlParameter("TEXTREP", textrep)); int nbLigne = cmd.ExecuteNonQuery(); return(nbLigne); }
public static int DeleteSujet(int idSujet) { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "DeleteSujet"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter pIdSujet = new SqlParameter("IDSUJET", idSujet); cmd.Parameters.Add(pIdSujet); int nbLigne = cmd.ExecuteNonQuery(); return nbLigne; }
public DataSet GetSujets() { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "GetSujets"; cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter objDataAdapter = new SqlDataAdapter(cmd); DataSet objDataSet = new DataSet(); objDataAdapter.Fill(objDataSet); return objDataSet; }
public DataSet GetRubriqueByIdRub(int idrub) { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "GetRubriqueById "; cmd.CommandType = CommandType.StoredProcedure; SqlParameter pDeptno = new SqlParameter("IDRUB", idrub); cmd.Parameters.Add(pDeptno); SqlDataAdapter objDataAdapter = new SqlDataAdapter(cmd); DataSet objDataSet = new DataSet(); objDataAdapter.Fill(objDataSet); return objDataSet; }
public DataSet GetRubriqueByNomRub(string nomrub) { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "GetRubriqueByNomRub"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter pNomrub = new SqlParameter("NOMRUB", nomrub); cmd.Parameters.Add(pNomrub); SqlDataAdapter objDataAdapter = new SqlDataAdapter(cmd); DataSet objDataSet = new DataSet(); objDataAdapter.Fill(objDataSet); return objDataSet; }
public static int DeleteReponse(int idRep) { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "DeleteReponse"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter pIdRep = new SqlParameter("IDREP", idRep); cmd.Parameters.Add(pIdRep); int nbLigne = cmd.ExecuteNonQuery(); return(nbLigne); }
public DataSet GetUtilisateurById(int iduser) { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "GetUtilisateurById "; cmd.CommandType = CommandType.StoredProcedure; SqlParameter pIduser = new SqlParameter("IDUSER", iduser); cmd.Parameters.Add(pIduser); SqlDataAdapter objDataAdapter = new SqlDataAdapter(cmd); DataSet objDataSet = new DataSet(); objDataAdapter.Fill(objDataSet); return(objDataSet); }
public DataSet GetReponseByIdSujet(int idsujet) { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "GetReponseByIdSujet "; cmd.CommandType = CommandType.StoredProcedure; SqlParameter pIdsujet = new SqlParameter("IDSUJET", idsujet); cmd.Parameters.Add(pIdsujet); SqlDataAdapter objDataAdapter = new SqlDataAdapter(cmd); DataSet objDataSet = new DataSet(); objDataAdapter.Fill(objDataSet); return(objDataSet); }
public int UpdateSujet(int idSujet, string titresujet, string ancientitre, string textsujet, string ancientext) { SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlDataBaseDAO.GetInstance().GetConnection(); cmd.CommandText = "UpdateSujet"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter pISujet = new SqlParameter("IDSUJET", idSujet); cmd.Parameters.Add(pISujet); //SqlParameter pNomUser = new SqlParameter("NOMUSER", nomUser); //cmd.Parameters.Add(pNomUser); SqlParameter pTitresujet = new SqlParameter("TITRESUJET", titresujet); cmd.Parameters.Add(pTitresujet); SqlParameter pAncienTitre = new SqlParameter("ANCIENTITRE", ancientitre); cmd.Parameters.Add(pAncienTitre); SqlParameter pTextsujet = new SqlParameter("TEXTSUJET", textsujet); cmd.Parameters.Add(pTextsujet); SqlParameter pAncienText = new SqlParameter("ANCIENTEXT", ancientext); cmd.Parameters.Add(pAncienText); //SqlParameter pDatecreatsujet = new SqlParameter("DATECREATSUJET", datecreatsujet); //cmd.Parameters.Add(pDatecreatsujet); // Ou .......... : //cmd.Parameters.Add(new SqlParameter("IDUSER", idUser)); //cmd.Parameters.Add(new SqlParameter("IDSUJET", idSujet)); //cmd.Parameters.Add(new SqlParameter("TEXTREP", textrep)); int nbLigne = cmd.ExecuteNonQuery(); return nbLigne; }
private UtilisateurDAO() { _Database = SqlDataBaseDAO.GetInstance(); }
private RubriqueDAO() { _Database = SqlDataBaseDAO.GetInstance(); }
private SujetDAO() { _Database = SqlDataBaseDAO.GetInstance(); }
private ReponseDAO() { _Database = SqlDataBaseDAO.GetInstance(); }