private string RpaExecution(FlowLayoutPanel flPlanning, frmConsultPlanning frmConsultPlanning, MySqlDataReader mySqlDataReader) { if (!mySqlDataReader.HasRows) { return("0"); } DataTablePrint = new DataTable(); DataTablePrint.Columns.Add("Activité", typeof(string)); DataTablePrint.Columns.Add("Date", typeof(DateTime)); DataTablePrint.Columns.Add("Participants", typeof(int)); while (mySqlDataReader.Read()) { CodeActivite = mySqlDataReader.GetInt16(0); DateActivite = mySqlDataReader.GetDateTime(1); LibelleActivite = mySqlDataReader.GetString(2); UcPlanning = new UcPlanning { LblDateM = { Text = DateActivite.ToString("g", CultureInfo.CreateSpecificCulture("fr-FR")), Tag = DateActivite }, BtnSupprActM = { Tag = CodeActivite }, }; RecupIdParticipants(); UcPlanning.LblLibelleActiviteM.Text = LibelleActivite; DataTablePrint.Rows.Add(LibelleActivite, DateActivite.ToString("dd/MM/yyyy HH:mm"), UcPlanning.ComboParticipantsM.Items.Count - 1); if (frmConsultPlanning.IsHandleCreated) { flPlanning.BeginInvoke((MethodInvoker) delegate { flPlanning.Controls.Add(UcPlanning); }); } } return("1"); }
public string RecupPlanningActivites(FlowLayoutPanel flPlanning, frmConsultPlanning frmConsultPlanning) { using (var mySqlConnection = new MySqlConnection()) { mySqlConnection.ConnectionString = Utilisateur.Connexion.SqlConnexion; mySqlConnection.Open(); const string query = "SELECT PLAN_ACTIVITE, PLAN_DATE_DEBUT, ACT_LIBELLE " + "FROM PLANNING B " + "INNER JOIN ACTIVITES A " + "ON B.PLAN_ACTIVITE = A.ACT_CODE " + "ORDER BY PLAN_DATE_DEBUT DESC LIMIT 10"; using (var mySqlCommand = new MySqlCommand(query, mySqlConnection)) { using (var mySqlDataReader = mySqlCommand.ExecuteReader()) { return(RpaExecution(flPlanning, frmConsultPlanning, mySqlDataReader)); } } } }