public List <CsLclient> RetourneTauxDeRecouvrement(List <int> IdCentre) { List <string> lstPeriode = DetermineListePeriode(1, 12, System.DateTime.Today); List <CsLclient> lesFacture = new DBReports().RetourneFactureGenere(IdCentre, lstPeriode); List <CsLclient> lesReglement = new DBReports().RetourneFactureRecouvre(IdCentre, lstPeriode); List <CsLclient> lesTaux = new List <CsLclient>(); List <string> lstCateg = new List <string>(); var lstCate = lesFacture.Select(p => p.LIBELLECATEGORIE).Distinct(); foreach (var item in lstCate) { lstCateg.Add(item); } foreach (string item in lstPeriode) { foreach (string categ in lstCateg) { CsLclient l = new CsLclient(); l.REFEM = item; l.LIBELLESITE = categ; l.MONTANTEMIS = lesFacture.FirstOrDefault(i => i.REFEM == item && i.LIBELLECATEGORIE == categ) != null?lesFacture.FirstOrDefault(i => i.REFEM == item && i.LIBELLECATEGORIE == categ).MONTANT.Value : 0; l.MONTANTENCAISSE = lesReglement.FirstOrDefault(i => i.REFEM == item && i.LIBELLECATEGORIE == categ) != null?lesReglement.FirstOrDefault(i => i.REFEM == item && i.LIBELLECATEGORIE == categ).MONTANT.Value : 0; l.TAUXRECOUVREMENT = (l.MONTANTENCAISSE / l.MONTANTEMIS) * 100; lesTaux.Add(l); } } return(lesTaux); }
private void RemplireCombo(List <CsLclient> _LstReglement) { try { // La grid doit afficher le detail d un recu par mode de reglement var reglemntParModereg = (from p in _LstReglement group new { p } by new { p.ACQUIT, p.DTRANS } into pResult select new { pResult.Key.ACQUIT, pResult.Key.DTRANS, MONTANT = (decimal?)pResult.Where(t => t.p.ACQUIT == pResult.Key.ACQUIT).Sum(o => o.p.MONTANT) }); List <CsLclient> ReglementAfficherParModeReg = new List <CsLclient>(); foreach (var r in reglemntParModereg.OrderByDescending(p => p.ACQUIT)) { CsLclient rglt = new CsLclient(); rglt.REFFERENCECLIENT = r.ACQUIT.PadRight(10, ' ') + r.DTRANS.Value.ToShortDateString().ToString().PadRight(10, ' ') + Convert.ToDecimal(r.MONTANT).ToString(SessionObject.FormatMontant).PadLeft(10, ' '); rglt.ACQUIT = r.ACQUIT; ReglementAfficherParModeReg.Add(rglt); } this.Cbo_ListeRecu.ItemsSource = null; this.Cbo_ListeRecu.ItemsSource = ReglementAfficherParModeReg; this.Cbo_ListeRecu.DisplayMemberPath = "REFFERENCECLIENT"; this.Cbo_ListeRecu.SelectedItem = ReglementAfficherParModeReg[0]; } catch (Exception ex) { } }
private CsLclient GetElementDeFrais(CsDetailCampagne Campagne, decimal?montantFrais) { CsLclient Frais = new CsLclient(); try { Frais.CENTRE = Campagne.CENTRE; Frais.CLIENT = Campagne.CLIENT; Frais.ORDRE = Campagne.ORDRE; Frais.REFEM = DateTime.Today.Date.Year.ToString() + DateTime.Today.Date.Month.ToString(); Frais.IDCOUPURE = Campagne.IDCOUPURE; Frais.COPER = SessionObject.Enumere.CoperFRP; Frais.DENR = DateTime.Today.Date; Frais.EXIGIBILITE = DateTime.Today.Date; Frais.DATECREATION = DateTime.Today.Date; Frais.DATEMODIFICATION = DateTime.Today.Date; Frais.DC = SessionObject.Enumere.Debit; Frais.FK_IDCENTRE = Campagne.FK_IDCENTRE; Frais.FK_IDCLIENT = Campagne.FK_IDCLIENT; Frais.MATRICULE = UserConnecte.matricule; Frais.MOISCOMPT = DateTime.Today.Date.Year.ToString() + DateTime.Today.Date.Month.ToString(); Frais.MONTANT = montantFrais; Frais.NATURE = SessionObject.Enumere.NatureFRP; Frais.TOP1 = "0"; return(Frais); } catch (Exception ex) { throw ex; } }
private void galatee_OkClickedChoixClient(object sender, EventArgs e) { if (this.Anciennecamp != null) { foreach (var item_ in this.Anciennecamp) { foreach (var item in item_.DETAILCAMPAGNEGC_) { CsLclient facture = new CsLclient(); facture.CENTRE = item.CENTRE; facture.CLIENT = item.CLIENT; facture.ORDRE = item.ORDRE; facture.NOM = item.NOM; facture.REFEM = item.PERIODE; facture.SOLDEFACTURE = item.MONTANT; facture.NDOC = item.NDOC; Lstfacture.Add(facture); } } } System.Windows.Data.PagedCollectionView view = new System.Windows.Data.PagedCollectionView(Lstfacture); LoadDataPager <CsLclient>(Lstfacture, datapager, dg_facture); if (dg_facture.ItemsSource != null) { this.txt_TotalFacture.Text = Lstfacture.Sum(c => (c.SOLDEFACTURE != null ? c.SOLDEFACTURE : 0)).Value.ToString(SessionObject.FormatMontant); } btn_Rech.IsEnabled = true; desableProgressBar(); ActiverElement(true); Message.ShowInformation("Les factures déja en campagne ne seront pas dans cette campagne", "Information"); }
List <CsLclient> GetFactureOD() { try { List <CsLclient> _Lstfacture = new List <CsLclient>(); CsLclient _Lafacture = new CsLclient(); _Lafacture.CENTRE = UserConnecte.Centre; _Lafacture.CLIENT = "000000000000000"; _Lafacture.ORDRE = "01"; _Lafacture.NDOC = "//////"; _Lafacture.NATURE = "01"; _Lafacture.SOLDEFACTURE = Convert.ToDecimal(this.txt_montant.Text); _Lafacture.MONTANT = Convert.ToDecimal(this.txt_montant.Text); _Lafacture.Selectionner = true; _Lafacture.REFEM = "//////"; _Lafacture.DC = "D"; _Lafacture.COPER = (this.cbo_Operation.SelectedItem as CsCoper).CODE; _Lafacture.NOM = this.txt_NomClient.Text; _Lafacture.SOLDECLIENT = 0; _Lafacture.MATRICULE = UserConnecte.matricule; _Lafacture.CAISSE = UserConnecte.numcaisse; _Lafacture.USERCREATION = UserConnecte.matricule; _Lafacture.DATECREATION = DateTime.Now.Date; //_Lafacture.IDENTITY = txt_IdCard.Text; _Lstfacture.Add(_Lafacture); return(_Lstfacture); } catch (Exception ex) { throw ex; } }
private void InsererCompteClient(CsLclient leFrais) { try { AcceuilServiceClient clients = new AcceuilServiceClient(Utility.Protocole(), Utility.EndPoint("Accueil")); clients.InsererFraisPoseAsync(leFrais); clients.InsererFraisPoseCompleted += (es, result) => { try { if (result.Cancelled || result.Error != null) { string error = result.Error.Message; Message.ShowError("Erreur à l'exécution du service", "InsererCompteClient"); return; } if (result.Result == null) { Message.ShowInformation("Donnée non trouvé ", "InsererCompteClient"); return; } Message.ShowInformation(Langue.MsgOperationTerminee, Langue.lbl_Menu); } catch (Exception ex) { Message.ShowError(ex, Galatee.Silverlight.Resources.Langue.errorTitle); } }; } catch (Exception ex) { throw ex; } }
private void EnregisterLclient(CsDemande _Lademande) { LeEvenementRemboursementAvance = new List <CsLclient>(); CsLclient _LaFacture = new CsLclient(); _LaFacture.CENTRE = LaDemande.LaDemande.CENTRE; _LaFacture.CLIENT = LaDemande.LaDemande.CLIENT; _LaFacture.ORDRE = LaDemande.LaDemande.ORDRE; _LaFacture.MATRICULE = UserConnecte.matricule; _LaFacture.DC = SessionObject.Enumere.Debit; _LaFacture.REFEM = System.DateTime.Now.Date.ToShortDateString().Substring(6, 4) + System.DateTime.Now.Date.ToShortDateString().Substring(3, 2); _LaFacture.DENR = System.DateTime.Now.Date; _LaFacture.EXIGIBILITE = System.DateTime.Now.Date; _LaFacture.TOP1 = SessionObject.Enumere.TopGuichet; _LaFacture.COPER = SessionObject.Enumere.CoperRCD; _LaFacture.NATURE = "00"; _LaFacture.MONTANT = LaDemande.Abonne.AVANCE; _LaFacture.USERCREATION = UserConnecte.matricule; _LaFacture.USERMODIFICATION = UserConnecte.matricule; _LaFacture.DATECREATION = System.DateTime.Now; _LaFacture.DATEMODIFICATION = System.DateTime.Now; if (_LaFacture.MONTANT != null && _LaFacture.MONTANT != 0) { LeEvenementRemboursementAvance.Add(_LaFacture); } }
private List <CsLclient> GetElementDeFrais(List <CsDetailCampagne> LesCampagne) { List <CsLclient> LesFrais = new List <CsLclient>(); try { foreach (var Campagne in LesCampagne) { CsLclient Frais = new CsLclient(); Frais.CENTRE = Campagne.CENTRE; Frais.CLIENT = Campagne.CLIENT; Frais.ORDRE = Campagne.ORDRE; Frais.REFEM = DateTime.Today.Date.Year.ToString("0000") + DateTime.Today.Date.Month.ToString("00"); Frais.COPER = SessionObject.Enumere.CoperFRP; Frais.DENR = DateTime.Today.Date; Frais.EXIGIBILITE = DateTime.Today.Date; Frais.DATECREATION = DateTime.Today.Date; Frais.DATEMODIFICATION = DateTime.Today.Date; Frais.DC = SessionObject.Enumere.Debit; Frais.FK_IDCENTRE = Campagne.FK_IDCENTRE; Frais.FK_IDCLIENT = Campagne.FK_IDCLIENT; Frais.MATRICULE = UserConnecte.matricule; Frais.MOISCOMPT = DateTime.Today.Date.Year.ToString("0000") + DateTime.Today.Date.Month.ToString("00"); Frais.MONTANT = Campagne.MONTANTFRAIS; Frais.TOP1 = "0"; LesFrais.Add(Frais); } return(LesFrais); } catch (Exception ex) { throw ex; } }
public List <CsLclient> RetourneTauxDeEncaissement(List <int> IdCentre) { List <string> lstPeriode = DetermineListePeriode(1, 12, System.DateTime.Today); List <CsLclient> lesFactureRetourne = new List <CsLclient>(); List <CsLclient> lesFacture = new DBReports().RetourneFactureGenere(IdCentre, lstPeriode); List <CsLclient> lesReglement = new DBReports().RetourneFactureRecouvre(IdCentre, lstPeriode); if (lesFacture != null && lesFacture.Count != 0) { CsLclient lafacturePeriode = lesFacture.First(); lafacturePeriode.MONTANTENCAISSE = lesReglement.FirstOrDefault(t => t.REFEM == lesFacture.First().REFEM) == null ? 0 : lesReglement.FirstOrDefault(t => t.REFEM == lesFacture.First().REFEM).MONTANT.Value; lafacturePeriode.MONTANTEMIS = lafacturePeriode.MONTANT.Value; lafacturePeriode.TAUXRECOUVREMENT = (lafacturePeriode.MONTANTENCAISSE / lafacturePeriode.MONTANTEMIS) * 100; lesFactureRetourne.Add(lafacturePeriode); CsLclient AutreFacture = new CsLclient(); AutreFacture.MONTANTEMIS = lesFacture.Where(t => t.REFEM != lesFacture.First().REFEM).Sum(y => y.MONTANT.Value); AutreFacture.MONTANTENCAISSE = lesReglement.Where(t => t.REFEM != lesFacture.First().REFEM) == null ? 0 : lesReglement.Where(t => t.REFEM != lesFacture.First().REFEM).Sum(y => y.MONTANT.Value); AutreFacture.REFEM = "AUTRE"; AutreFacture.TAUXRECOUVREMENT = (AutreFacture.MONTANTENCAISSE / AutreFacture.MONTANTEMIS) * 100; lesFactureRetourne.Add(AutreFacture); } return(lesFactureRetourne); }
private void dgMyDataGrid2_MouseLeftButtonUp(object sender, MouseButtonEventArgs e) { DataGrid dg = (sender as DataGrid); var allObjects = dg.ItemsSource as List <CsLclient>; //foreach (var o in allObjects) // o.Selectionner = false; if (dg.SelectedItem != null) { CsLclient SelectedObject = (CsLclient)dg.SelectedItem; if (SelectedObject.Selectionner == false) { SelectedObject.Selectionner = true; if (SelectedObject.STATUS == SessionObject.Enumere.StatusDemandeValider) { this.btn_Retirer.Visibility = System.Windows.Visibility.Collapsed; } else { this.btn_Retirer.Visibility = System.Windows.Visibility.Visible; } } else { SelectedObject.Selectionner = false; } } }
private void dataGrid1_SelectionChanged(object sender, SelectionChangedEventArgs e) { //CsReglement _LaFacture = (CsReglement)this.dataGrid1.SelectedItem; CsLclient _LaFacture = (CsLclient)this.dataGrid1.SelectedItem; this.Txt_refem.Text = _LaFacture.REFEM; this.Txt_Ndoc.Text = _LaFacture.NDOC; }
void getCloseAfterSelection() { if (Closed != null) { CsLclient _LaFacture = (CsLclient)this.dataGrid1.SelectedItem; LeClientLot = _LaFacture; Closed(this, new EventArgs()); } }
private void chk_Exonere_Unchecked(object sender, RoutedEventArgs e) { List <CsLclient> lstFactureExoneres = (List <CsLclient>) this.LsvFacture.ItemsSource; if (lstFactureExoneres != null && this.LsvFacture.SelectedItem != null) { CsLclient leEltsSelect = lstFactureExoneres.FirstOrDefault(t => t.PK_ID == ((CsLclient)this.LsvFacture.SelectedItem).PK_ID); IsExonnere(leEltsSelect, false); } }
private void LettrageAutomatique(List <CsLclient> _ListeFactureAreglee, decimal montantAvance) { try { List <CsLclient> lstFactureAValider = new List <CsLclient>(); decimal? MontantRestant = montantAvance; foreach (CsLclient laFactureClient in _ListeFactureAreglee) { if (MontantRestant > 0) { decimal?MontantPaye = MontantRestant; if (laFactureClient.SOLDEFACTURE <= MontantPaye) { MontantPaye = laFactureClient.SOLDEFACTURE; } else if (laFactureClient.SOLDEFACTURE >= MontantPaye) { MontantPaye = MontantRestant; } CsLclient leReglement = GetElementDeReglement(laFactureClient, MontantPaye); lstFactureAValider.Add(leReglement); MontantRestant = MontantRestant - laFactureClient.SOLDEFACTURE; lstFactureAValider.Add(leReglement); } } //AcceuilServiceClient client = new Galatee.Silverlight.ServiceAccueil.AcceuilServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("Accueil")); //client.LettrageAutomatiqueCompleted += (ss, b) => //{ // if (b.Cancelled || b.Error != null) // { // string error = b.Error.Message; // Message.ShowError(error, Silverlight.Resources.Devis.Languages.txtDevis); // return; // } // List<string> codes = new List<string>(); // codes.Add(laDetailDemande.InfoDemande.CODE); // Galatee.Silverlight.Shared.ClasseMEthodeGenerique.TransmettreDemande(codes, true, this); // List<CsUtilisateur> leUser = new List<CsUtilisateur>(); // if (laDetailDemande.InfoDemande != null && laDetailDemande.InfoDemande.CODE != null) // { // foreach (CsUtilisateur item in laDetailDemande.InfoDemande.UtilisateurEtapeSuivante) // leUser.Add(item); // Shared.ClasseMEthodeGenerique.NotifierMailDemande(leUser, "0001", laDetailDemande.LaDemande.NUMDEM, laDetailDemande.LaDemande.LIBELLETYPEDEMANDE); // } //}; //client.LettrageAutomatiqueAsync(lstFactureAValider); } catch (Exception ex) { throw ex; } }
private void dgrdAccount_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { CsLclient clientSelected = (CsLclient)dgrdAccount.SelectedItem; updateViewAfterSelection(clientSelected); } catch (Exception ex) { Message.Show(ex, Galatee.Silverlight.Resources.Langue.errorTitle); } }
private void IsExonnere(CsLclient leElt, bool IsChecked) { try { List <CsLclient> lstEltfacture = new List <CsLclient>(); lstEltfacture = ((List <CsLclient>)LsvFacture.ItemsSource).ToList(); CsLclient leElts = lstEltfacture.FirstOrDefault(t => t.PK_ID == leElt.PK_ID); CsLclient leEltss = lesEltInitial.FirstOrDefault(t => t.PK_ID == leElt.PK_ID); if (leElts != null) { if (IsChecked) { decimal montantfact = (leEltss.SOLDEFACTURE - (leEltss.MONTANTTVA == null ? 0 : leEltss.MONTANTTVA)).Value; leElts.MONTANTPAYE = montantfact; leElts.MONTANTEMIS = leEltss.MONTANTTVA.Value; //SAUVEGARDER LA TVA leElts.MONTANTTVA = 0; leElts.SOLDEFACTURE = montantfact; leElts.IsExonerationTaxe = true; lstEltfacture.Where(a => a.PK_ID == leElts.PK_ID).ToList().ForEach(a => a.MONTANTEMIS = leEltss.MONTANTTVA.Value); //SAUVEGARDER LA TVA lstEltfacture.Where(a => a.PK_ID == leElts.PK_ID).ToList().ForEach(a => a.MONTANTTVA = 0); lstEltfacture.Where(a => a.PK_ID == leElts.PK_ID).ToList().ForEach(a => a.MONTANTPAYE = montantfact); lstEltfacture.Where(a => a.PK_ID == leElts.PK_ID).ToList().ForEach(a => a.SOLDEFACTURE = montantfact); } else { decimal montantfact = leEltss.SOLDEFACTURE.Value; leElts.MONTANTPAYE = montantfact; leElts.MONTANTTVA = leEltss.MONTANTTVA.Value; leElts.SOLDEFACTURE = montantfact; leElts.IsExonerationTaxe = false; lstEltfacture.Where(a => a.PK_ID == leElts.PK_ID).ToList().ForEach(a => a.MONTANTTVA = leEltss.MONTANTTVA.Value); lstEltfacture.Where(a => a.PK_ID == leElts.PK_ID).ToList().ForEach(a => a.MONTANTPAYE = montantfact); lstEltfacture.Where(a => a.PK_ID == leElts.PK_ID).ToList().ForEach(a => a.SOLDEFACTURE = montantfact); } this.Txt_TotalHt.Text = lstEltfacture.Sum(t => t.MONTANT).Value.ToString(SessionObject.FormatMontant); this.Txt_totalTaxe.Text = lstEltfacture.Sum(t => t.MONTANTTVA).Value.ToString(SessionObject.FormatMontant); this.Txt_TotalTTC.Text = txt_MontantPayes.Text = lstEltfacture.Sum(t => t.SOLDEFACTURE).Value.ToString(SessionObject.FormatMontant); this.txt_MontantPayes.IsReadOnly = lstEltfacture.FirstOrDefault(a => a.IsExonerationTaxe) != null; //if (LsvFacture.ItemsSource != null) // this.txt_MontantPayes.Text = ((List<CsLclient>)LsvFacture.ItemsSource).Sum(y => y.MONTANTPAYE).Value.ToString(SessionObject.FormatMontant); } } catch (Exception ex) { throw ex; } }
private void btn_Recherche_Click(object sender, RoutedEventArgs e) { if (!string.IsNullOrEmpty(this.Txt_refem.Text) && !string.IsNullOrEmpty(this.Txt_Ndoc.Text)) { CsLclient _LafactureRechercher = _LeCompteParOreientation.FirstOrDefault(p => p.NDOC == this.Txt_Ndoc.Text && p.REFEM == this.Txt_refem.Text); if (_LafactureRechercher != null) { this.Txt_refem.Text = _LafactureRechercher.REFEM; this.Txt_Ndoc.Text = _LafactureRechercher.NDOC; } } }
//Recherche des factures sen fonction des critère entré private void RemplirfactureProduit(CsRegCli csRegCli, List <string> listperiode, List <int> lstIdProduit) { //Activation du busy indicator allowProgressBar(); //Grisé certain éléments du formulaire pour bloqué certainnes actions ActiverElement(false); //Exécution du service web recupération des factures Galatee.Silverlight.ServiceRecouvrement.RecouvrementServiceClient service = new Galatee.Silverlight.ServiceRecouvrement.RecouvrementServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("Recouvrement")); service.RemplirfactureAvecProduitCompleted += (s, args) => { if (args != null && args.Cancelled) { return; } Lstfacture = args.Result; if (this.Anciennecamp != null) { foreach (var item_ in this.Anciennecamp) { foreach (var item in item_.DETAILCAMPAGNEGC_) { CsLclient facture = new CsLclient(); facture.CENTRE = item.CENTRE; facture.CLIENT = item.CLIENT; facture.ORDRE = item.ORDRE; facture.NOM = item.NOM; facture.REFEM = item.PERIODE; facture.SOLDEFACTURE = item.MONTANT; facture.NDOC = item.NDOC; Lstfacture.Add(facture); } } } System.Windows.Data.PagedCollectionView view = new System.Windows.Data.PagedCollectionView(Lstfacture); LoadDataPager <CsLclient>(Lstfacture, datapager, dg_facture); if (dg_facture.ItemsSource != null) { this.txt_TotalFacture.Text = Lstfacture.Sum(c => (c.SOLDEFACTURE != null ? c.SOLDEFACTURE : 0)).Value.ToString(SessionObject.FormatMontant); } btn_Rech.IsEnabled = true; desableProgressBar(); ActiverElement(true); return; }; service.RemplirfactureAvecProduitAsync(csRegCli, listperiode, lstIdProduit); }
private void MiseAjourCompt(List <CsDetailPaiementGc> lstDetailPaiement, int Id) { Galatee.Silverlight.ServiceRecouvrement.RecouvrementServiceClient service = new Galatee.Silverlight.ServiceRecouvrement.RecouvrementServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("Recouvrement")); service.MiseAjourComptCompleted += (s, args) => { if (args != null && args.Cancelled) { return; } if (args.Result == null) { return; } if (args.Result.Count == 0) { return; } Message.Show("Mise à jour effectuée avec succès", "Resultat"); Dictionary <string, string> param = new Dictionary <string, string>(); var lesCompteMaj = args.Result.Select(u => new { u.CENTRE, u.CLIENT, u.ORDRE, u.NOM, u.ACQUIT, u.REFEM, u.NDOC, u.NUMDEVIS, u.NUMDEM }).Distinct(); List <CsLclient> lesCompteAEditer = new List <CsLclient>(); int i = 0; foreach (var item in lesCompteMaj) { CsLclient leC = new CsLclient(); leC.CENTRE = item.CENTRE; leC.CLIENT = item.CLIENT; leC.ORDRE = item.ORDRE; leC.REFEM = item.REFEM; leC.NDOC = item.NDOC; leC.NOM = item.NOM; leC.NUMDEM = item.NUMDEM; leC.NUMDEVIS = item.NUMDEVIS; leC.NUMETAPE = i + 1; leC.ADRESSE = txt_Campagne.Text; leC.CAPUR = System.DateTime.Today.ToShortDateString(); leC.MONTANT = args.Result.Where(t => t.CENTRE == item.CENTRE && t.CLIENT == item.CLIENT && t.ORDRE == item.ORDRE && t.REFEM == item.REFEM && t.NDOC == item.NDOC).Sum(t => t.MONTANT); lesCompteAEditer.Add(leC); } param.Add("pUserMiseAJour", UserConnecte.nomUtilisateur); Utility.ActionDirectOrientation <ServicePrintings.CsLclient, ServiceRecouvrement.CsLclient>(lesCompteAEditer, param, SessionObject.CheminImpression, "MiseAJourGrandCompte", "Recouvrement", true); this.DialogResult = true; //List<int> id = new List<int>(); //id.Add(Id); //EnvoyerDemandeEtapeSuivante(id); return; }; service.MiseAjourComptAsync(lstDetailPaiement, Id); }
//private void btn_Rechercher_Click(object sender, RoutedEventArgs e) //{ // //Utiliser ToutLeCompteClientRecherche pour charger les facture du client // ToutLeCompteClientDeOrientation = new List<CsLclient>(); // if (((CsTypeLot)cbo_TypeBatch.SelectedItem).DC=="D") // { // if (ToutLeCompteClientRecherche != null && // ToutLeCompteClientRecherche.FirstOrDefault(p=>p.CLIENT == this.Txt_Client.Text && p.NDOC == this.Txt_Ordre.Text )!= null ) // { // if (ToutLeCompteClientRecherche.Count() > 0) // foreach (var item in ToutLeCompteClientRecherche) // { // CsLclient facture = new CsLclient(); // //ACQUITANTERIEUR =item.ACQUIT!=null?item.ACQUIT:string.Empty, // facture.NDOC = !string.IsNullOrWhiteSpace(item.NDOC) ? item.NDOC : string.Empty; // facture.REFEM = !string.IsNullOrWhiteSpace(item.REFEM) ? item.REFEM : string.Empty; // facture.COPER = !string.IsNullOrWhiteSpace(item.COPER) ? item.COPER : string.Empty; // facture.NATURE = !string.IsNullOrWhiteSpace(item.NATURE) ? item.NATURE : string.Empty; // facture.DATECREATION = item.DATECREATION; // facture.DC = !string.IsNullOrWhiteSpace(item.DC) ? item.DC : string.Empty; // facture.MONTANT = item.MONTANT != null ? item.MONTANT.Value : decimal.MinValue; // facture.CENTRE = item.CENTRE; // facture.CLIENT = item.CLIENT; // facture.ORDRE = item.ORDRE; // ToutLeCompteClientDeOrientation.Add(facture); // } // if (ToutLeCompteClientDeOrientation != null && ToutLeCompteClientDeOrientation.Count != 0) // { // UcAjustementRecherche Ctrl = new UcAjustementRecherche(ToutLeCompteClientDeOrientation); // Ctrl.Closed += new EventHandler(galatee_OkClicked); // Ctrl.Show(); // } // } // else // { // LoadCompteClient(true); // } // } // else // { // if (ToutLeCompteClientRecherche != null) // { // if (ToutLeCompteClientRecherche.Count() > 0) // foreach (var item in ToutLeCompteClientRecherche) // { // CsLclient facture = new CsLclient(); // facture.NDOC = !string.IsNullOrWhiteSpace(item.NDOC) ? item.NDOC : string.Empty; // facture.REFEM = !string.IsNullOrWhiteSpace(item.REFEM) ? item.REFEM : string.Empty; // facture.COPER = !string.IsNullOrWhiteSpace(item.COPER) ? item.COPER : string.Empty; // facture.NATURE = !string.IsNullOrWhiteSpace(item.NATURE) ? item.NATURE : string.Empty; // facture.DATECREATION = item.DATECREATION; // facture.DC = !string.IsNullOrWhiteSpace(item.DC) ? item.DC : string.Empty; // facture.MONTANT = item.MONTANT != null ? item.MONTANT.Value : decimal.MinValue; // facture.CENTRE = item.CENTRE; // facture.CLIENT = item.CLIENT; // facture.ORDRE = item.ORDRE; // ToutLeCompteClientDeOrientation.Add(facture); // } // if (ToutLeCompteClientDeOrientation != null && ToutLeCompteClientDeOrientation.Count != 0) // { // UcAjustementRecherche Ctrl = new UcAjustementRecherche(ToutLeCompteClientDeOrientation); // Ctrl.Closed += new EventHandler(galatee_OkClicked); // Ctrl.Show(); // } // } // else // { // LoadCompteClient(true); // } // } //} void galatee_OkClicked(object sender, EventArgs e) { UcAjustementRecherche ctrs = sender as UcAjustementRecherche; _leClientLot = new CsLclient(); _leClientLot = ctrs.MyClientDetailLot; if (_leClientLot != null) { this.Txt_Client.Text = _leClientLot.CLIENT; this.Txt_Ordre.Text = _leClientLot.ORDRE; this.Txt_refem.Text = _leClientLot.REFEM; this.Txt_Ndoc.Text = _leClientLot.NDOC; } }
public static decimal?RetourneSoldeDocument(CsLclient lstFacture, List <CsLclient> lstReglement) { try { decimal?sommeDebit = lstFacture.MONTANT; decimal?sommeCrebit = lstReglement.Sum(t => t.MONTANT); decimal?difference = (sommeDebit - sommeCrebit); return(difference); } catch (Exception ex) { throw ex; } }
private void Cbo_ListeRecu_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { leReglementSelect = (CsLclient )this.Cbo_ListeRecu.SelectedItem; if (leReglementSelect != null) { var lesDistinctClient = _LstrefReglement.Where(o => o.ACQUIT == leReglementSelect.ACQUIT).Select(u => new { u.CENTRE, u.CLIENT, u.ORDRE }).Distinct(); int nbr = 0; foreach (var item in lesDistinctClient) { nbr++; if (nbr > 1) { Chk_BorderoSeulement.Visibility = System.Windows.Visibility.Visible; break; } else { Chk_BorderoSeulement.Visibility = System.Windows.Visibility.Collapsed; } } var _lstfacture = (from p in _LstrefReglement where p.ACQUIT == leReglementSelect.ACQUIT group new { p } by new { p.ACQUIT, p.MODEREG } into pResult select new { pResult.Key.ACQUIT, MONTANT = (decimal?)pResult.Where(t => t.p.ACQUIT == pResult.Key.ACQUIT).Sum(o => o.p.MONTANT), LIBELLEMODREG = SessionObject.ListeModesReglement.FirstOrDefault(t => t.CODE == pResult.Key.MODEREG).LIBELLE }).ToList(); List <CsLclient> RegltAfficher = new List <CsLclient>(); foreach (var item in _lstfacture) { CsLclient Reglt = new CsLclient(); Reglt.LIBELLEMODREG = item.LIBELLEMODREG; Reglt.MONTANT = item.MONTANT; RegltAfficher.Add(Reglt); } dtg_FactureAnnule.ItemsSource = null; dtg_FactureAnnule.ItemsSource = RegltAfficher; this.txtMontantRecuTot.Text = Convert.ToDecimal(RegltAfficher[0].MONTANT.Value).ToString(SessionObject.FormatMontant); } } catch (Exception ex) { Message.ShowError(ex, Langue.errorTitle); } }
CsLclient ObtenirFaisChequeImpaye(CsLclient item) { item.MONTANT = Labanque.FRAISDERETOUR; item.USERCREATION = UserConnecte.matricule; item.DATECREATION = System.DateTime.Now; item.DENR = System.DateTime.Now.Date; item.TOP1 = SessionObject.Enumere.TopCheqImpaye; item.DC = SessionObject.Enumere.Debit; item.COPER = SessionObject.Enumere.CoperFraisChqImp; item.FK_IDCOPER = SessionObject.LstDesCopers.FirstOrDefault(t => t.CODE == SessionObject.Enumere.CoperFraisChqImp).PK_ID; item.FK_IDLIBELLETOP = SessionObject.LstDesLibelleTop.FirstOrDefault(t => t.CODE == SessionObject.Enumere.TopCheqImpaye).PK_ID; item.FK_IDADMUTILISATEUR = UserConnecte.PK_ID; item.FK_IDMOTIFCHEQUEINPAYE = (int)this.Cbo_MotifRejet.Tag; return(item); }
private void RemplireDataGrid(List <CsLclient> _LstReglement) { try { var _lstfacture = (from p in _LstReglement group new { p } by new { p.FK_IDHABILITATIONCAISSE, p.NOMCAISSIERE, p.ACQUIT, p.DENR, p.MATRICULE, p.MOTIFANNULATION, p.IsDEMANDEANNULATION, p.CAISSE, p.NUMDEM } into pResult select new { pResult.Key.ACQUIT, pResult.Key.DENR, pResult.Key.MATRICULE, pResult.Key.MOTIFANNULATION, pResult.Key.IsDEMANDEANNULATION, pResult.Key.NOMCAISSIERE, pResult.Key.CAISSE, pResult.Key.FK_IDHABILITATIONCAISSE, pResult.Key.NUMDEM, MONTANT = (decimal?)pResult.Sum(o => o.p.MONTANT) }).ToList(); foreach (var item in _lstfacture) { CsUtilisateur leUSer = _ListeDesUtilisateurs.FirstOrDefault(p => p.MATRICULE == item.MATRICULE); CsLclient leReglement = new CsLclient() { //REFFERENCECLIENT = item.REFFERENCECLIENT, ACQUIT = item.ACQUIT, //NOM = item.NOM, DENR = item.DENR, NUMDEM = item.NUMDEM, MONTANT = item.MONTANT, MOTIFANNULATION = item.MOTIFANNULATION, IsDEMANDEANNULATION = item.IsDEMANDEANNULATION, MATRICULE = item.MATRICULE, CAISSE = item.CAISSE, FK_IDHABILITATIONCAISSE = item.FK_IDHABILITATIONCAISSE, NOMCAISSIERE = (leUSer != null) ? (leUSer.LIBELLE + "(" + item.MATRICULE + ")") : item.MATRICULE }; ListeDesReglementADupliquer.Add(leReglement); } dtg_FactureAnnule.ItemsSource = null; dtg_FactureAnnule.ItemsSource = ListeDesReglementADupliquer; } catch (Exception ex) { } }
void updateViewAfterSelection(CsLclient clientSelected) { try { //lblAccount.Content = clientSelected.NumeroCompte; //lblCode.Content = clientSelected.CodeBank; //lblLibelle.Content = clientSelected.LibelleBank; lblNomabn.Content = clientSelected.NOM; lblRef.Content = clientSelected.CENTRE + " " + clientSelected.CLIENT + " " + clientSelected.ORDRE; //lblCode.Content = clientSelected.CodeBank; } catch (Exception ex) { throw ex; } }
private void btnOk_Click(object sender, RoutedEventArgs e) { try { if (lvwResultat.ItemsSource != null) { CsLclient lstClientSelect = new CsLclient(); lstClientSelect = lvwResultat.SelectedItem as CsLclient; ValiderAutorisationFrais(lstClientSelect); } } catch (Exception ex) { Message.ShowError(ex, Galatee.Silverlight.Resources.Langue.errorTitle); } }
private void Remplirfacture(CsRegCli csRegCli, List <string> listperiode) { allowProgressBar(); ActiverElement(false); Galatee.Silverlight.ServiceRecouvrement.RecouvrementServiceClient service = new Galatee.Silverlight.ServiceRecouvrement.RecouvrementServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("Recouvrement")); service.RemplirfactureCompleted += (s, args) => { if (args != null && args.Cancelled) { return; } Lstfacture = args.Result; if (this.Anciennecamp != null) { foreach (var item_ in this.Anciennecamp) { foreach (var item in item_.DETAILCAMPAGNEGC_) { CsLclient facture = new CsLclient(); facture.CENTRE = item.CENTRE; facture.CLIENT = item.CLIENT; facture.ORDRE = item.ORDRE; facture.NOM = item.NOM; facture.REFEM = item.PERIODE; facture.SOLDEFACTURE = item.MONTANT; facture.NDOC = item.NDOC; Lstfacture.Add(facture); } } } System.Windows.Data.PagedCollectionView view = new System.Windows.Data.PagedCollectionView(Lstfacture); LoadDataPager <CsLclient>(Lstfacture, datapager, dg_facture); if (dg_facture.ItemsSource != null) { this.txt_TotalFacture.Text = Lstfacture.Sum(t => t.SOLDEFACTURE).Value.ToString(SessionObject.FormatMontant); } btn_Rech.IsEnabled = true; desableProgressBar(); ActiverElement(true); return; }; service.RemplirfactureAsync(csRegCli, listperiode); }
private List <CsLclient> RetourneCsLclientFromCsMoratoire(List <CsDetailMoratoire> DetailMor) { List <CsLclient> _lstAEditer = new List <CsLclient>(); foreach (CsDetailMoratoire m in DetailMor) { CsLclient cmpte = new CsLclient(); cmpte.CRET = m.CRET; cmpte.DATEVALEUR = m.DATEVALEUR; cmpte.DC = m.DC; cmpte.EXIGIBILITE = m.EXIGIBILITE; cmpte.CENTRE = m.CENTRE; cmpte.CLIENT = m.CLIENT; cmpte.COPER = m.COPER; cmpte.NATURE = m.NATURE; cmpte.ORDRE = m.ORDRE; cmpte.NDOC = m.NDOC; cmpte.TOP1 = m.TOP1; cmpte.FRAISDERETARD = m.FRAISDERETARD; cmpte.MOISCOMPT = m.MOISCOMPT; cmpte.MONTANT = m.MONTANT; cmpte.REFEM = m.REFEM; cmpte.MATRICULE = m.MATRICULE; cmpte.USERCREATION = m.USERCREATION; cmpte.DATECREATION = m.DATECREATION; cmpte.CAISSE = m.CAISSE; cmpte.MODEREG = m.MODEREG; cmpte.USERCREATION = m.MATRICULE; cmpte.DATECREATION = m.DATECREATION; cmpte.FK_IDCLIENT = m.FK_IDCLIENT; // valorisation des propriétés foreign key cmpte.FK_IDCENTRE = m.FK_IDCENTRE; cmpte.FK_IDCOPER = m.FK_IDCOPER; cmpte.FK_IDLIBELLETOP = m.FK_IDLIBELLETOP; cmpte.FK_IDNATURE = m.FK_IDNATURE; cmpte.FK_IDADMUTILISATEUR = m.FK_IDADMUTILISATEUR; _lstAEditer.Add(cmpte); } return(_lstAEditer); }
private void btn_Ajouter_Click(object sender, RoutedEventArgs e) { try { CsLclient leReglementSelect = (CsLclient)dtg_FactureAAnnule.SelectedItem; if (leReglementSelect != null) { FrmMotifAction ctrl = new FrmMotifAction(_LstrefReglement.Where(t => t.ACQUIT == leReglementSelect.ACQUIT).ToList()); ctrl.Closed += new EventHandler(galatee_OkClickedRaisonAnnulation); ctrl.Show(); } } catch (Exception ex) { Message.Show(ex.Message, Langue.LibelleModule); } }
void frm_CallBack(object sender, Tarification.Helper.CustumEventArgs e) { AjouterPeriodeAListe(); FrmCampagne Frm = (FrmCampagne)sender; //Implementer le callback if (e.Bag != null) { if (!Frm.Arefaire) { var camp = (CsCampagneGc)e.Bag; if (Anciennecamp.FirstOrDefault(c => c.PK_ID == camp.PK_ID) != null) { this.Anciennecamp.Remove(camp); } //List<string> listperiode=new List<string>(); List <CsLclient> dataSource = new List <CsLclient>(); foreach (var item in camp.DETAILCAMPAGNEGC_) { CsLclient facture = new CsLclient(); facture.CENTRE = item.CENTRE; facture.CLIENT = item.CLIENT; facture.ORDRE = item.ORDRE; facture.FK_IDCLIENT = item.FK_IDCLIENT; facture.FK_IDLCLIENT = item.FK_IDLCLIENT; facture.NOM = item.NOM; facture.REFEM = item.PERIODE; facture.MONTANT = item.MONTANT; facture.NDOC = item.NDOC; dataSource.Add(facture); } //dg_facture_Copy.ItemsSource = dataSource; LoadDataPager <CsLclient>(dataSource, datapager_Copy, dg_facture_Copy); } else { this.Anciennecamp.Add((CsCampagneGc)e.Bag); } } else { txt_periode.Text = string.Empty; } }