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