public void RetourneBalanceAuxilliaire(string CodeSite, DateTime?dateFin) { try { Galatee.Silverlight.ServiceInterfaceComptable.InterfaceComptableServiceClient service = new Galatee.Silverlight.ServiceInterfaceComptable.InterfaceComptableServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("InterfaceComptable")); service.RetourneBalanceAuxilliaireCompleted += (s, args) => { try { prgBar.Visibility = System.Windows.Visibility.Collapsed; if (args.Cancelled || args.Error != null || args.Result == null) { string error = args.Error.InnerException.ToString(); return; } else { if (args.Result != null && args.Result.Count != 0) { List <ServiceInterfaceComptable.CsBalance> lstClient = new List <ServiceInterfaceComptable.CsBalance>(); //var lesClient = args.Result.Select(y => new { y.CENTRE, y.CLIENT, y.ORDRE }).OrderBy(o => o.CENTRE).Distinct(); //foreach (var item in lesClient) // lstClient.Add(new ServiceInterfaceComptable.CsBalance() { CENTRE = item.CENTRE, CLIENT = item.CLIENT, ORDRE = item.ORDRE }); //int Passage = 0; //string[] tableau = new string[] { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V" }; //while (lstClient.Where(o => o.IsSelect != true).Count() != 0) //{ string NomFichier = "BalanceAuxilliaire"; // string NomFichier = "BalanceAuxilliaire" + tableau[Passage]; // List<string> clientSelectionne = lstClient.Where(m => m.IsSelect != true).Take(5000).Select(o => o.CLIENT).ToList(); //List<ServiceInterfaceComptable.CsBalance> factureAEditer = args.Result.Where(p => clientSelectionne.Contains(p.CLIENT)).ToList(); List <ServiceInterfaceComptable.CsBalance> factureAEditer = args.Result.ToList(); Dictionary <string, string> param = new Dictionary <string, string>(); param.Add("AnneFin", dateFin.Value.Year.ToString()); if (this.chk_Excel.IsChecked == true) { Utility.ActionExportation <ServicePrintings.CsBalance, ServiceInterfaceComptable.CsBalance>(factureAEditer, param, NomFichier, SessionObject.CheminImpression, "BalanceAuxilliaire", "InterfaceComptable", true, "xlsx"); } else { Utility.ActionDirectOrientation <ServicePrintings.CsBalance, ServiceInterfaceComptable.CsBalance>(factureAEditer, param, SessionObject.CheminImpression, "BalanceAuxilliaire", "InterfaceComptable", false); } // lstClient.Where(p => clientSelectionne.Contains(p.CLIENT)).ToList().ForEach(p => p.IsSelect = true); // Passage++; //} } else { Message.ShowInformation("Le système n'a trouvé aucun Compte spécifique dans la base de données ", "Avertissement"); } } } catch (Exception ex) { Message.ShowError(ex, Galatee.Silverlight.Resources.Caisse.Langue.errorTitle); } }; service.RetourneBalanceAuxilliaireAsync(CodeSite, dateFin); } catch (Exception ex) { throw ex; } }
public void RetourneBalanceAuxilliaire(string CodeSite, DateTime?dateFin) { try { Galatee.Silverlight.ServiceInterfaceComptable.InterfaceComptableServiceClient service = new Galatee.Silverlight.ServiceInterfaceComptable.InterfaceComptableServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("InterfaceComptable")); service.RetourneBalanceAuxilliaireCompleted += (s, args) => { try { prgBar.Visibility = System.Windows.Visibility.Collapsed; if (args.Cancelled || args.Error != null || args.Result == null) { string error = args.Error.InnerException.ToString(); return; } else { if (args.Result != null && args.Result.Count != 0) { List <ServiceInterfaceComptable.CsBalance> lstClient = new List <ServiceInterfaceComptable.CsBalance>(); var lesClient = args.Result.Select(y => new { y.FK_IDCLIENT, y.LIBELLECATEGORIE }).OrderBy(o => o.LIBELLECATEGORIE).Distinct(); foreach (var item in lesClient) { lstClient.Add(new ServiceInterfaceComptable.CsBalance() { FK_IDCLIENT = item.FK_IDCLIENT }); } int Passage = 0; string[] tableau = new string[] { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "AB", "AC", "AD", "AE", "AF", "AG", "AH", "AI", "AJ" }; while (lstClient.Where(o => o.IsSelect != true).Count() != 0) { string NomFichier = "BalanceAuxilliaire" + tableau[Passage]; List <int> clientSelectionne = lstClient.Where(m => m.IsSelect != true).OrderBy(l => l.CATEGORIE).Take(750).Select(o => o.FK_IDCLIENT).ToList(); List <ServiceInterfaceComptable.CsBalance> factureAEditer = args.Result.Where(p => clientSelectionne.Contains(p.FK_IDCLIENT)).ToList(); if (this.chk_Excel.IsChecked == true) { Utility.ActionExportation <ServicePrintings.CsBalance, ServiceInterfaceComptable.CsBalance>(factureAEditer, null, NomFichier, SessionObject.CheminImpression, "BalanceAuxilliaire", "InterfaceComptable", true, "xlsx"); } else { Utility.ActionDirectOrientation <ServicePrintings.CsBalance, ServiceInterfaceComptable.CsBalance>(factureAEditer, null, SessionObject.CheminImpression, "BalanceAuxilliaire", "InterfaceComptable", false); } lstClient.Where(p => clientSelectionne.Contains(p.FK_IDCLIENT)).ToList().ForEach(p => p.IsSelect = true); Thread.Sleep(120); Passage++; } } else { Message.ShowInformation("Le système n'a trouvé aucun Compte spécifique dans la base de données ", "Avertissement"); } } } catch (Exception ex) { Message.ShowError(ex, Galatee.Silverlight.Resources.Caisse.Langue.errorTitle); } }; service.RetourneBalanceAuxilliaireAsync(CodeSite, dateFin); } catch (Exception ex) { throw ex; } }
public void RetourneBalanceAgee(string CodeSite, DateTime?dateFin) { try { Galatee.Silverlight.ServiceInterfaceComptable.InterfaceComptableServiceClient service = new Galatee.Silverlight.ServiceInterfaceComptable.InterfaceComptableServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("InterfaceComptable")); service.RetourneBalanceAgeeCompleted += (s, args) => { try { prgBar.Visibility = System.Windows.Visibility.Collapsed; if (args.Cancelled || args.Error != null || args.Result == null) { string error = args.Error.InnerException.ToString(); return; } else { if (args.Result != null && args.Result.Count != 0) { if (chk_Excel.IsChecked == true) { Utility.ActionExportation <ServicePrintings.CsBalance, ServiceInterfaceComptable.CsBalance>(args.Result, param, string.Empty, SessionObject.CheminImpression, "BalanceAgee", "InterfaceComptable", true, "xlsx"); } else { Utility.ActionDirectOrientation <ServicePrintings.CsBalance, ServiceInterfaceComptable.CsBalance>(args.Result, param, SessionObject.CheminImpression, "BalanceAgee", "InterfaceComptable", false); } } else { Message.ShowInformation("Aucune donnée trouvée ", "Balance"); } } } catch (Exception ex) { Message.ShowError(ex, Galatee.Silverlight.Resources.Caisse.Langue.errorTitle); } }; service.RetourneBalanceAgeeAsync(CodeSite, dateFin); } catch (Exception ex) { throw ex; } }
public void RetourneOperationCompte() { try { Galatee.Silverlight.ServiceInterfaceComptable.InterfaceComptableServiceClient service = new Galatee.Silverlight.ServiceInterfaceComptable.InterfaceComptableServiceClient(Utility.ProtocoleIndex(), Utility.EndPoint("InterfaceComptable")); service.RetourneOperationComptableCompleted += (s, args) => { try { if (args.Cancelled || args.Error != null || args.Result == null) { string error = args.Error.InnerException.ToString(); return; } else { if (args.Result != null && args.Result.Count != 0) { ListeOperationComptable = new List <ServiceInterfaceComptable.CsOperationComptable>(); ListeOperationComptable = args.Result; } else { Message.ShowInformation("Le système n'a trouvé aucun Compte spécifique dans la base de données ", "Avertissement"); } } } catch (Exception ex) { Message.ShowError(ex, Galatee.Silverlight.Resources.Caisse.Langue.errorTitle); } }; service.RetourneOperationComptableAsync(); } catch (Exception ex) { throw ex; } }