internal void supprimerRealiser(RealiserBE realiser) { if (realiserDA.supprimer(realiser)) { journalDA.journaliser("Suppression d'une opération de caisse - " + realiser.numeroop); } }
// Définition d'une liste 'ListeSeries' observable de 'Série' public Ops_caisse() { InitializeComponent(); dpiDateOperation.IsTodayHighlighted = true; dpiDateOperation.SelectedDate = DateTime.Today; dpiDateOperation.IsTodayHighlighted = true; dpiDateOperation2.SelectedDate = DateTime.Today; dpiDateOperation2.IsTodayHighlighted = true; CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name); ci.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd"; Thread.CurrentThread.CurrentCulture = ci; objet_realiser = new RealiserBE(); string op = "%"; if (cmbOperation2.SelectedValue != null) { op = cmbOperation2.SelectedValue.ToString(); } date = DateTime.Today.Date.ToShortDateString(); motif = txtMotif2.Text; string critere = "dateop = " + "'" + date + "' AND codeop LIKE " + "'" + op + "' AND motif LIKE " + "'" + motif + "%'"; //MessageBox.Show(critere); List <String> listTypes = new List <string>(); //operations = new List<OperationBE>(); types = new List <TypeoperationBE>(); realisers = new List <RealiserBE>(); caisseBL = new GestionCaisseBL(); types = caisseBL.listerTypeOperation(); listTypes = caisseBL.listerValeursColonneTypeOperation("codetypeop"); cmbTypeOperation.ItemsSource = listTypes; cmbTypeOperation.SelectedIndex = 0; List <string> liste = new List <string>(); liste = caisseBL.listerValeursColonneTypeOperation("codetypeop"); if (liste != null) { liste.Add("Tout"); cmbOperation2.ItemsSource = liste; } grdListe.DataContext = this; realisers = caisseBL.listerSuivantCritereRealisers(critere); grdListe.ItemsSource = realisers; //initialisation du type pour l'enregistrement typeValidation = "enregistrer"; }
internal bool modifierRealiser(RealiserBE realiser) { if (realiserDA.modifier(realiser)) { journalDA.journaliser("Modification d'une opération de caisse - " + realiser.numeroop); return(true); } else { return(false); } }
internal bool enregistrerRealiser(RealiserBE realiserBE) { if (realiserDA.ajouter(realiserBE)) { journalDA.journaliser("Enregistrement d'une opération de caisse - " + realiserBE.numeroop); return(true); } else { return(false); } }
//private void btnUpdate_Click(object sender, RoutedEventArgs e) //{ //} //private void btnDelete_Click(object sender, RoutedEventArgs e) //{ // MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Etes vous sure?", "Delete Confirmation", System.Windows.MessageBoxButton.YesNo); // if (messageBoxResult == MessageBoxResult.Yes) // { // } // else // { // MessageBox.Show("operation aborded"); // } //} private void grdListe_MouseDoubleClick(object sender, MouseButtonEventArgs e) { if (grdListe.SelectedIndex >= 0) { objet_realiser = realisers.ElementAt(grdListe.SelectedIndex); txtMotif.Text = objet_realiser.motif; txtMontant.Text = objet_realiser.montant.ToString(); txtConcerne.Text = objet_realiser.concerne; dpiDateOperation.SelectedDate = objet_realiser.dateop.Date; numero = objet_realiser.numeroop; //cmbOperation.SelectedIndex = cmbOperation.Items.IndexOf(objet_realiser.codeop); cmbTypeOperation.IsEnabled = false; //cmbOperation.IsEnabled = false; typeValidation = "update"; grdListe.UnselectAll(); } }
private void grdListe_KeyUp(object sender, KeyEventArgs e) { String //recuperation des valeurs des conditions pour la recherche des objets realisers date = DateTime.Today.Date.ToShortDateString(); string op = "%"; if (cmbOperation2.SelectedValue != null) { if (cmbOperation2.SelectedValue.ToString() != "Tout") { op = cmbOperation2.SelectedValue.ToString(); } } if (dpiDateOperation2.SelectedDate != null) { date = dpiDateOperation2.SelectedDate.Value.Date.ToShortDateString(); } motif = txtMotif2.Text; string critere = "dateop = " + "'" + date + "' AND codeop LIKE " + "'" + op + "' AND motif LIKE " + "'%" + motif + "%'"; if (e.Key == Key.Delete) { if (MessageBox.Show("Voulez vous supprimer?", "School : Confirmation", System.Windows.MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (grdListe.SelectedIndex != -1) { RealiserBE realiser = new RealiserBE(); realiser = realisers.ElementAt(grdListe.SelectedIndex); caisseBL.supprimerRealiser(realiser); realisers.Remove(realiser); grdListe.ItemsSource = realisers; grdListe.Items.Refresh(); } else { MessageBox.Show("Aucune ligne sélectionnée", "School brain:Alerte"); } } } }
private void valider_Click(object sender, RoutedEventArgs e) { if (validerFormulaire()) { string typeop = ""; //c'est un nouvel enregistrement if (typeValidation == "enregistrer") { stype = cmbTypeOperation.SelectedValue.ToString(); //soperation = cmbOperation.SelectedValue.ToString(); smotif = txtMotif.Text; if (stype == "entree") { smotif = "Encaissement - " + smotif; typeop = "Bon d'Encaissement"; } else { smotif = "Decaissement - " + smotif; typeop = "Bon de Decaissement"; } smontant = Convert.ToDecimal(txtMontant.Text); sdate = (DateTime)dpiDateOperation.SelectedDate; concerne = txtConcerne.Text; numero = caisseBL.getNumeroSuivant(); RealiserBE realiser = new RealiserBE(stype, Ecole.UI.ConnexionUI.utilisateur.login, numero, smotif, smontant, sdate, concerne); //MessageBox.Show(numero); //enregistrement dans la BD if (caisseBL.enregistrerRealiser(realiser)) { CreerEtat etat = new CreerEtat("bordorau-" + DateTime.Today.ToShortDateString(), typeop + " N° " + realiser.numeroop); etat.bordoreauOperation(realiser); } else { MessageBox.Show("Enregistrement échoué"); } } else //c'est une modification { RealiserBE realiser = new RealiserBE(); realiser = caisseBL.rechercherByNumeroRealiser(objet_realiser); realiser.motif = txtMotif.Text; realiser.montant = Convert.ToDecimal(txtMontant.Text); realiser.dateop = (DateTime)dpiDateOperation.SelectedDate; realiser.concerne = txtConcerne.Text; //modification dans la BD if (caisseBL.modifierRealiser(realiser)) { CreerEtat etat = new CreerEtat("bordorau-" + DateTime.Today.ToShortDateString(), "Bon d' " + realiser.motif.Split('-')[0] + " N° " + realiser.numeroop); etat.bordoreauOperation(realiser); } else { MessageBox.Show("Mise à jour échouée"); } cmbTypeOperation.IsEnabled = true; //cmbOperation.IsEnabled = true; typeValidation = "enregistrer"; } //recuperation des valeurs des conditions pour la recherche des objets realisers string op = "%"; if (cmbOperation2.SelectedValue != null) { op = cmbOperation2.SelectedValue.ToString(); } //if (dpiDateOperation2.SelectedDate != null) // date = dpiDateOperation2.SelectedDate.Value.Date.ToShortDateString(); motif = txtMotif2.Text; string critere = "dateop = " + "'" + date + "' AND codeop LIKE " + "'" + op + "' AND motif LIKE " + "'%" + motif + "%'"; //MessageBox.Show(critere); realisers = caisseBL.listerSuivantCritereRealisers(critere); grdListe.ItemsSource = realisers; grdListe.Items.Refresh(); txtMontant.Clear(); txtMotif.Clear(); txtConcerne.Clear(); cmbTypeOperation.Text = ""; //cmbOperation.Text = ""; dpiDateOperation.IsTodayHighlighted = true; dpiDateOperation2.IsTodayHighlighted = true; } else { MessageBox.Show("Renseigner tous les champs", "School brain : Message d'alerte"); } }
internal RealiserBE rechercherByNumeroRealiser(RealiserBE realiser) { return(realiserDA.rechercherParNumero(realiser)); }