void Session_End(object sender, EventArgs e) { DataSet dataSet = (DataSet)Session["UpdateInfoHits"]; DataServices dataS; DBQuery DBQuery = new DBQuery(); foreach (DataRow row in dataSet.Tables[0].Rows) { dataS = new DataServices(dsn, DBQuery.QcmsINFO_Update); dataS.AddParameter("@ID", SqlDbType.Int, 0, ParameterDirection.Input, row["info_id"], "info_id"); dataS.AddParameter("@HITS", SqlDbType.Int, 0, ParameterDirection.Input, row["info_hits"], "info_hits"); dataS.Execute(DataServices.ExecutionMode.UPDATE); dataS.Dispose(); } foreach (DataRow row in dataSet.Tables[1].Rows) { dataS = new DataServices(dsn, DBQuery.QcmsCONTENT_HIT_Update); dataS.AddParameter("@DATE", SqlDbType.DateTime, 0, ParameterDirection.Input, row["hit_date"], "hit_date"); dataS.AddParameter("@CONTENT", SqlDbType.Int, 0, ParameterDirection.Input, row["hit_content"], "hit_content"); dataS.AddParameter("@USER", SqlDbType.Int, 0, ParameterDirection.Input, row["hit_user"], "hit_user"); dataS.Execute(DataServices.ExecutionMode.INSERT); dataS.Dispose(); } //Mise à jour de la base de données }
static void Main(string[] args) { string dsn = ConfigurationManager.AppSettings["dsn"]; DataServices ds = new DataServices(dsn, "Visiteur_Enregistre_Hit"); ds.UtilitySqlCommand.CommandType = CommandType.StoredProcedure; ds.AddParameter("@referer", SqlDbType.VarChar, 255, ParameterDirection.Input, "url11", "test"); ds.AddParameter("@domaine", SqlDbType.VarChar, 255, ParameterDirection.Input, "testurl", "test"); ds.AddParameter("@site", SqlDbType.Int, 255, ParameterDirection.Input, 7, "test"); ds.AddParameter("@date", SqlDbType.DateTime, 255, ParameterDirection.Input, "2020-06-03", "test"); ds.AddParameter("@session", SqlDbType.Int, 255, ParameterDirection.Input, 7, "test"); ds.AddParameter("@rubrique", SqlDbType.Int, 255, ParameterDirection.Input, 7, "test"); ds.AddParameter("@url", SqlDbType.VarChar, 255, ParameterDirection.Input, "url2", "test"); ds.UtilitySqlCommand.ExecuteReader(); /* * Snippets snippets= new Snippets(); * DataSet dataSet = new DataSet(); * * //démarrage de la session :création du dataset avec les tables vides au démarrage de la session du user * string requete2 = "SELECT * FROM [dbo].[cmsINFO] where info_id=0"; * string requete3 = "SELECT * FROM [dbo].[cmsCONTENT_HIT] where content_hit=0"; * * DataTables dataTable = new DataTables(dsn); * dataSet.Tables.Add(dataTable.ChargeTable(requete2)); * dataSet.Tables.Add(dataTable.ChargeTable(requete3)); * * //user appelle 1 displayCart * * //mise à jour de mon dataset par le displaycart * * int infoid = 3; * affiche(dataSet); * snippets.UpdateInfoHits(dataSet,infoid,0); * affiche(dataSet); * * * * * * void affiche(DataSet ds) * { * foreach (DataTable table in ds.Tables) * { * Console.WriteLine(table.TableName); * foreach (DataRow row in table.Rows) * { * foreach (DataColumn column in table.Columns) * { * Console.WriteLine(row[column]); * } * } * Console.WriteLine(); * } * } * */ }
private DataTable ChargeData(string req, int id) { DataOlinwone.BuildCommand(req); DataOlinwone.AddParameter("@ID", SqlDbType.Int, 0, ParameterDirection.Input, id, "questionnaire_id"); DataOlinwone.GetStructures(); DataTable resultat = DataOlinwone.UtilityDataTable; CheckChargement = DataOlinwone.UtilityDataExiste; DataOlinwone.CloseCommand(); return(resultat); }