void RemplirSessions()
{
try
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString);
string sSql = "SELECT -1 as SessionID, '' as Heures, '' as JourRencontre, '' as DateCommence, '' as DateFin, 0 as MaxEtudiants, 0 as MontantParticipation, 'Cliquez pour Choisir' as Description UNION " +
" SELECT SessionID, Heures, JourRencontre, DateCommence, DateFin, MaxEtudiants, MontantParticipation, JourRencontre + '-' + Heures + '(' + CAST(DateFin as nvarchar(10)) + '-' + CAST(DateFin as nvarchar(10)) + ')' as Description from Sessions " +
"WHERE Actif = 1";
clSession clUneSession = null;
List <clSession> listSession = new List <clSession>();
ArrayList arSessions = new ArrayList();
//SqlDataAdapter da = new SqlDataAdapter(sSql, myConnection);
//DataTable dTable = new DataTable();
//da.Fill(dTable);
//cbo_A_Modifier.DataSource = dTable;
//cbo_A_Modifier.DataValueField = "SessionID";
//cbo_A_Modifier.DataTextField = "Description";
SqlDataReader dr = donnees.GetDataReader(sSql);
if (dr != null)
{
while (dr.Read())
{
clUneSession = new clSession();
clUneSession.SessionID = Int16.Parse(dr["SessionID"].ToString());
clUneSession.Heures = dr["Heures"].ToString();
clUneSession.JourRencontre = dr["JourRencontre"].ToString();
clUneSession.DateCommence = dr["DateCommence"].ToString();
clUneSession.DateFin = dr["DateFin"].ToString();
clUneSession.MaxEtudiants = Int16.Parse(dr["MaxEtudiants"].ToString());
clUneSession.Montant = Double.Parse(dr["MontantParticipation"].ToString());
clUneSession.Description = dr["Description"].ToString();
listSession.Add(clUneSession);
// arSessions.Add(clUneSession);
}
cbo_A_Modifier.DataSource = listSession; //listSession;
cbo_A_Modifier.DataValueField = "SessionID";
cbo_A_Modifier.DataTextField = "Description";
cbo_A_Modifier.DataBind();
}
}
catch (Exception ex)
{
string sError = ex.Message.ToString();
Debug.WriteLine(sError);
sError = "";
}
}
/// <summary>
/// cette methode prendre les annonce dans la base de données pour ensuite l afficher sur l'ecran
/// </summary>
public void Annonce()
{
try
{
int iRowIndex = 0;
Literal1.Text = "<table id='Annonces' width='100%' font-size='20px' align='center'><tr><th></th></tr>";
string sSql = "SELECT * FROM Annonces WHERE Actif = 1";
SqlDataReader dt = baseDeDonnees.GetDataReader(sSql);
if (dt != null)
{
while (dt.Read())
{
if ((iRowIndex++ % 2) == 0)
{
Literal1.Text += string.Format("<tr ><td>{0}</td></tr>", dt["Annonce"].ToString());
}
else
{
Literal1.Text += string.Format("<tr class='alt'><td>{0}</td></tr>", dt["Annonce"].ToString());
}
}
}
Literal1.Text += "</table>";
}
catch (Exception ex)
{
Response.Write("Error " + ex.Message);
}
}
void SelectDate()
{
try
{
String ChaineDeConnexion = ConfigurationManager.ConnectionStrings["connection"].ToString();
string sSql = "SELECT SessionDateID, Convert(varchar, SessionDateDebut) + ' - ' + Convert(varchar,SessionDateFin) AS SessionDate from DatesSessionCourante WHERE Actif = 1 ORDER BY SessionDateDebut DESC";
donnees.GetDataReader(sSql);
SqlDataAdapter da = new SqlDataAdapter(sSql, ChaineDeConnexion);
DataTable dTable = new DataTable();
da.Fill(dTable);
//DataTableReader dt = donnees;
DataTableReader dr = dTable.CreateDataReader();
if (dr != null)
{
dr.Read();
string[] sTemp = dr["SessionDate"].ToString().Split('-');
lblDateDebut.InnerText = "Date Debut de la session : " + sTemp[0].Trim();
lblDateFin.InnerText = "Date fin de La session : " + sTemp[1].Trim();
}
}
catch (Exception ex)
{
string sError = ex.Message.ToString();
Debug.WriteLine(sError);
sError = "";
}
}
protected void BtnAddClasse_Click(object sender, EventArgs e)
{
donnees = new BaseDeDonnees();
string[] sTemp = new string[2];
// Split date Debut and Date fin
String ChaineDeConnexion = ConfigurationManager.ConnectionStrings["connection"].ToString();
string sSql = "SELECT SessionDateID, Convert(varchar, SessionDateDebut) + ' - ' + Convert(varchar,SessionDateFin) AS SessionDate from DatesSessionCourante WHERE Actif = 1 ORDER BY SessionDateDebut DESC";
donnees.GetDataReader(sSql);
SqlDataAdapter da = new SqlDataAdapter(sSql, ChaineDeConnexion);
DataTable dTable = new DataTable();
da.Fill(dTable);
//DataTableReader dt = donnees;
DataTableReader dr = dTable.CreateDataReader();
if (dr != null)
{
dr.Read();
sTemp = dr["SessionDate"].ToString().Split('-');
lblDateDebut.InnerText = sTemp[0].Trim();
lblDateFin.InnerText = sTemp[1].Trim();
}
// Fin
try
{
if (!ToutBagayPaAnfom())
{
lblError.InnerText = ("Toutes les Informations sont obligatoires Pour Continuer !!!");
}
else
{
lblError.InnerText = string.Empty;
string sSql1 = string.Format("INSERT INTO Sessions(ClasseID, ProfesseurID, MaxEtudiants, JourRencontre, Heures, " +
"MontantParticipation, DateCommence, DateFin, byUsername) VALUES ({0},{1},{2},'{3}','{4}',{5},'{6}','{7}','{8}')",
NomClasse.SelectedItem.Value, DrpProfesseurName.SelectedItem.Value, txtMaxEtudiant.Text, dJourDeClasse.SelectedItem.Text,
DropHeureDeClasse.SelectedItem.Text, txtMontant.Text, lblDateDebut.InnerText, lblDateFin.InnerText, BaseDeDonnees.GetWindowsUser()); //donnees.GetWindowsUser()
if (donnees.IssueCommand(sSql1))
{
lblSucces.Text = "Données sauvegardees avec succes !!";
ResetToutBagay(); // Pou ka rantre lòt donnees
}
else
{
lblError.InnerText = "ERROR: Données PAS Sauvegardées -- Voir Un Technicien!!!";
}
}
}
catch (Exception ex)
{
lblError.InnerText = ("ERROR: Données PAS Sauvegardées " + ex);
}
}
private void SelectDate()
{
String ChaineDeConnexion = ConfigurationManager.ConnectionStrings["connection"].ToString();
string sSql = "SELECT SessionDateID, Convert(varchar, SessionDateDebut) + ' - ' + Convert(varchar,SessionDateFin) AS SessionDate from DatesSessionCourante WHERE Actif = 1 ORDER BY SessionDateDebut DESC";
donnees.GetDataReader(sSql);
SqlDataAdapter da = new SqlDataAdapter(sSql, ChaineDeConnexion);
DataTable dTable = new DataTable();
da.Fill(dTable);
//DataTableReader dt = donnees;
DataTableReader dr = dTable.CreateDataReader();
if (dr != null)
{
dr.Read();
string[] sTemp = dr["SessionDate"].ToString().Split('-');
debuSessionCourante.InnerText = " ====> de la session : " + sTemp[0].Trim();
FinSessionCourante.InnerText = " ====> de La session : " + sTemp[1].Trim();
}
}
