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