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