private void UC_Home_Load(object sender, EventArgs e) { OneSemaine(InstantRound.GetInstance().Id); ChartCotisation(); RefreshData(new Cotisation()); lblMax.Text = dgCotisation.Rows.Count.ToString(); }
void SavePhone() { Telephone telephone = new Telephone(); telephone.Id = idPhone; telephone.Initial = initial.Text; telephone.Numero = contactTxt.Text; telephone.RefMembre = InstantRound.GetInstance().IdMembre; telephone.Enregistrer(telephone); }
void RefreshDatas(IInscription insc) { if (radioAgent.Checked == true) { dgInscit.DataSource = insc.AllAgent(); } else if (radioMembre.Checked == true) { dgInscit.DataSource = insc.AllInscriptionsRound(InstantRound.GetInstance().Id); } }
void SaveInscription() { IInscription I = new Inscription(); I.Id = Convert.ToInt32(idInscription); I.RefMembre = idMembre; I.RefRound = InstantRound.GetInstance().Id; I.UserSession = UserSession.GetInstance().UserName.ToString(); I.Enregistrer(I); }
void ActionLancement() { RefreshDatas(new Inscription()); lblMax.Text = InstantRound.GetInstance().LimiteInscription().ToString() + " Membres"; lblDeja.Text = InstantRound.GetInstance().CountInscription().ToString() + " Membres"; if (lblDeja.Text == lblMax.Text) { lblEtat.Visible = true; } }
private void Button4_Click(object sender, EventArgs e) { if (InstantRound.GetInstance().IdMembre == 0) { MessageBox.Show("Veuillez selectionner un membre dans le Tableau"); } else { MiniFormAdresse m = new MiniFormAdresse(); m.ShowDialog(); } }
void SaveDomicile() { Domicile dom = new Domicile(); dom.Id = idDomicile; dom.Avenue = avenueTxt.Text; dom.Numero = numTxt.Text; dom.RefAdresse = idAdresse; dom.RefMembre = InstantRound.GetInstance().IdMembre; dom.Enregistrer(dom); }
private void DgInscit_SelectionChanged(object sender, EventArgs e) { try { int i; i = dgInscit.CurrentRow.Index; InstantRound.GetInstance().IdMembre = Convert.ToInt32(dgInscit["idM", i].Value.ToString()); } catch (Exception ex) { MessageBox.Show("L'erreur suivant est survenue : " + ex.Message); } }
void SaveMembre() { Membre membre = new Membre(); GenererQrCode(); InstantRound.GetInstance().IdMembre = idMembre; membre.Id = idMembre; membre.Matricule = "00000000"; membre.Nom = nomTxt.Text; membre.Postnom = pnomTxt.Text; membre.Prenom = prenomTxt.Text; membre.Sex = sexeTxt.Text.Equals(Sexe.Masculin.ToString()) ? Sexe.Masculin : Sexe.Féminin; membre.DateNaiss = DateTime.Parse(dateNaissTxt.Text); membre.LieuNaiss = lieuTxt.Text; membre.Profession = professionTxt.Text; membre.QrCode = qrCode.Image; membre.Photo = photo.Image; membre.RefMandataire = idMandataire; membre.Enregistrer(membre); }
private void button1_Click(object sender, EventArgs e) { try { if (userTxt.Text == "" || passTxt.Text == "" || tontineCombo.Text == "") { MessageBox.Show("Veuillez completez tout les champs svp !!!", "Erreur de connection", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { PubCon.testlog = DynamicClasses.GetInstance().loginTest(userTxt.Text, passTxt.Text); InstantRound.GetInstance().Id = dn.retourId("Id", "TRound", "Designation", tontineCombo.Text); //Envoyer(); if (PubCon.testlog == 1) { if (UserSession.GetInstance().Etat == "Bloquer") { MessageBox.Show("Vous n'etes pas autorisez à vous connecter veuillez contacter un administrateur", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { MessageBox.Show("La connection a reussie !!!", "Message Serveur...", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); Principale_Form frm = new Principale_Form(); frm.ChargerUser(new UC_Home()); } //frm.Show(); } } } catch (Exception) { throw; } }
void RefreshData(Cotisation cot) { dgCotisation.DataSource = cot.AllCotisationSemaine(InstantSemaine.GetInstance().IdSemaine, InstantRound.GetInstance().Id); }
public void SendSMSDettes() { bool envoie = true; string numero = ""; string message = ""; string codeMs = ""; string utilisateur = ""; string dateEnvoie = ""; string Etat = ""; int count = 0; try { innitialiseConnect(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } cmd = new SqlCommand("SELECT_SMS_DETTE", (SqlConnection)ImplementeConnexion.Instance.Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 30, DbType.String, InstantRound.GetInstance().Id)); dr = cmd.ExecuteReader(); while (dr.Read()) { numero = dr["Numero"].ToString(); message = dr["Message"].ToString(); if (numero != "" && message != "" && count != 1) { ClsMessages ms = new ClsMessages(); if (message.Length <= 140) { //update_Valmsg(codeMs); if (ms.sendshortMsg(numero, message) == false) { if (ms.sendlongMsg(numero, message + " ") == false) { envoie = false; //ClsSMS msInsert = new ClsSMS(); //msInsert.NumeroTutaire1 = numero; //msInsert.CorpsMessage1 = message; //msInsert.DateEnvoie1 = dateEnvoie; //msInsert.EtatSms1 = 0; //msInsert.Utilisateur1 = utilisateur; //insert_Messagerie(msInsert); numero = ""; message = ""; codeMs = ""; dateEnvoie = ""; utilisateur = ""; Etat = ""; } } else { envoie = true; numero = ""; message = ""; codeMs = ""; dateEnvoie = ""; utilisateur = ""; Etat = ""; } } else { //update_Valmsg(codeMs); if (ms.sendlongMsg(numero, message) == true) { numero = ""; message = ""; envoie = true; } else { envoie = false; //ClsSMS msInsert = new ClsSMS(); //msInsert.CorpsMessage1 = message; //msInsert.DateEnvoie1 = dateEnvoie; //msInsert.EtatSms1 = 0; //msInsert.Utilisateur1 = utilisateur; //insert_Messagerie(msInsert); } } //update set statutMessage='non' } } //dr.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); envoie = false; //ClsSMS msInsert = new ClsSMS(); //msInsert.CorpsMessage1 = message; //msInsert.DateEvoie1 = DateTime.Parse(dateEnvoie); //msInsert.EtatSms1 = 0; //msInsert.Utilisateur1 = utilisateur; //insert_Messagerie(msInsert); } finally { con.Close(); } //return envoie; }
public List <Remboursement> AllRemboursements() { List <Remboursement> r = new List <Remboursement>(); //Num = 0; if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT_REMBOURSEMENTS_FROM_ROUND"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, InstantRound.GetInstance().Id)); IDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { r.Add(GetDetailsRemboursement(rd)); } rd.Dispose(); } return(r); }
public string retourLastCotisationMembre(Label champ1, Label champ2, int valeur) { string identifiant = "Prémière Cotisation"; DateTime dateco, datenow = new DateTime(); datenow = DateTime.Now; if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = @"SELECT_LAST_COTISATION"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 5, DbType.Int32, valeur)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@idRound", 5, DbType.Int32, InstantRound.GetInstance().Id)); IDataReader rd = cmd.ExecuteReader(); if (rd.Read()) { //if (rd.IsDBNull(1)) //{ // dateco = InstantSemaine.GetInstance().DateDebut; // identifiant = "Début Round"; //} //else //{ dateco = Convert.ToDateTime(rd["Date_Concernee"].ToString()); //identifiant = Convert.ToInt32(rd["Id"].ToString()); champ1.Text = string.Format("{0}", dateco.ToString("dd/MM/yyyy")); champ2.Text = rd["Designation"].ToString(); //champ3.Text = rd["Postnom"].ToString(); if (Convert.ToDateTime(champ1.Text) == datenow.Date) { identifiant = "En ordre"; } else if (Convert.ToDateTime(champ1.Text) < datenow.Date) { identifiant = "En retard"; } else if (Convert.ToDateTime(champ1.Text) > datenow.Date) { identifiant = "En avance"; } //} } rd.Close(); rd.Dispose(); cmd.Dispose(); } return(identifiant); }
public int retourInfoRembMembre(Label champ1, Label champ2, Label champ3, string valeur, PictureBox photo) { int identifiant = 0; int id = 0; if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT_INFO_REMB"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@noms", 100, DbType.String, valeur)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 5, DbType.Int32, InstantRound.GetInstance().Id)); IDataReader rd = cmd.ExecuteReader(); if (rd.Read()) { champ1.Text = rd["DebutFin"].ToString(); champ2.Text = rd["Matricule"].ToString(); champ3.Text = rd["Mandataire"].ToString(); identifiant = Convert.ToInt32(rd["Id"].ToString()); id = Convert.ToInt32(rd["IdMembre"].ToString()); } rd.Close(); rd.Dispose(); cmd.Dispose(); retreivePhoto(id.ToString(), photo); } return(identifiant); }
public void chargeNomsCombo(ComboBox cmb, string nomChamp, string procedure) { if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = procedure; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 5, DbType.Int32, InstantRound.GetInstance().Id)); //cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 5, DbType.Int32, InstantSemaine.GetInstance().IdSemaine)); IDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { string de = rd[nomChamp].ToString(); cmb.Items.Add(de); } rd.Close(); rd.Dispose(); cmd.Dispose(); } }
public int retourIdSemaine(string valeur1) { int identifiant = 0; if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = @"select Id from Affichage_Details_Semaine where DebutFin = '" + valeur1 + "' And IdRound = '" + InstantRound.GetInstance().Id + "'"; IDataReader rd = cmd.ExecuteReader(); if (rd.Read()) { identifiant = int.Parse(rd["Id"].ToString()); } rd.Close(); rd.Dispose(); cmd.Dispose(); } return(identifiant); }
public List <Cotisation> AllDettes() { List <Cotisation> lst = new List <Cotisation>(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT_ALL_DETTE_ROUND"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, InstantRound.GetInstance().Id)); IDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { lst.Add(GetDetailDettes(rd)); } rd.Dispose(); } return(lst); }
public void Enregistrer(Semaine sem) { if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "INSERT_SEMAINE"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, Id)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@numero", 4, DbType.Int32, RefInscrit)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@refround", 4, DbType.Int32, InstantRound.GetInstance().Id)); cmd.ExecuteNonQuery(); //MessageBox.Show("Enregistrement reussie", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public List <Cotisation> Research(string recherche) { List <Cotisation> lst = new List <Cotisation>(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT * FROM Affichage_Details_Cotisation WHERE IdRound=" + InstantRound.GetInstance().Id + " AND IdSemaine=" + InstantSemaine.GetInstance().IdSemaine + " AND (Nom LIKE '%" + recherche + "%' OR Postnom LIKE '%" + recherche + "' OR Prenom LIKE '%" + recherche + "')"; //cmd.CommandType = CommandType.StoredProcedure; IDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { lst.Add(GetDetailCotisation(rd)); } rd.Dispose(); rd.Close(); } return(lst); }
void RefreshDatas(IInscription insc) { dgInscit.DataSource = insc.AllInscriptionsRound(InstantRound.GetInstance().Id); sexeTxt.DataSource = Enum.GetNames(typeof(Sexe)); dn.chargeCombo(membreCombo, "Nom_Complet", "SELECT_NOM_COMPLET_MEMBRE"); }
public List <IInscription> Research(string recherche) { List <IInscription> lst = new List <IInscription>(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT * FROM Affichage_Details_Inscriptions WHERE IdRound=" + InstantRound.GetInstance().Id + " AND Nom_Complet LIKE '%" + recherche + "%'"; //cmd.CommandType = CommandType.StoredProcedure; IDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { lst.Add(GetAllDetailsInscription(rd)); } rd.Dispose(); rd.Close(); } return(lst); }
public List <Cotisation> ResearchDette(string recherche) { List <Cotisation> lst = new List <Cotisation>(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SEARCH_DETTE_ROUND"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 5, DbType.Int32, InstantRound.GetInstance().Id)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@idSemaine", 5, DbType.Int32, InstantSemaine.GetInstance().IdSemaine)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@text", 200, DbType.String, recherche)); IDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { Matricule.ToUpper(); lst.Add(GetDetailDettes(rd)); } rd.Dispose(); rd.Close(); } return(lst); }
private void OneInfoSemaine() { if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT_CAISSE_RESTE"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, InstantSemaine.GetInstance().IdSemaine)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@idRound", 4, DbType.Int32, InstantRound.GetInstance().Id)); IDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { lblCaisse.Text = dr["En_Caisse"].ToString(); lblReste.Text = dr["Dette"].ToString(); } dr.Dispose(); } //return semaine; }