/* En stand by */ public static DataTable RetournerCoodonnesAbonne(CsClientRechercher client) { try { using (galadbEntities context = new galadbEntities()) { var Ag = context.AG; IEnumerable <object> localisations = from a in Ag from c in a.CLIENT1 from b in a.BRT where a.CLIENT == client.CLIENT && a.CENTRE == client.CENTRE select new { Centre = b.CENTRE, Latitude = b.LATITUDE, Longitude = b.LONGITUDE, NomAbonne = c.NOMABON, NumeroClient = b.CLIENT, Telephone = c.TELEPHONE }; return(Galatee.Tools.Utility.ListToDataTable(localisations)); } } catch (Exception ex) { throw ex; } }
private void ChargeDetailDEvis(int IdDemandeDevis) { prgBar.Visibility = System.Windows.Visibility.Visible; AcceuilServiceClient client = new AcceuilServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("Accueil")); client.ChargerDetailDemandeCompleted += (ssender, args) => { prgBar.Visibility = System.Windows.Visibility.Collapsed; if (args.Cancelled || args.Error != null) { LayoutRoot.Cursor = Cursors.Arrow; string error = args.Error.Message; Message.ShowError(error, Silverlight.Resources.Devis.Languages.txtDevis); return; } if (args.Result == null) { LayoutRoot.Cursor = Cursors.Arrow; Message.ShowError(Silverlight.Resources.Devis.Languages.AucunesDonneesTrouvees, Silverlight.Resources.Devis.Languages.txtDevis); return; } else { laDetailDemande = new CsDemande(); laDetailDemande = args.Result; this.txtCentre_Origine.Text = laDetailDemande.Transfert.LIBELLECENTREORIGINE; this.txtSite_Origine.Text = laDetailDemande.Transfert.LIBELLESITEORIGINE; this.txtCentreTransfert.Text = laDetailDemande.Transfert.LIBELLECENTRETRANSFERT; this.txtSiteTransfert.Text = laDetailDemande.Transfert.LIBELLESITETRANSFERT; this.Txt_CodeRegroupement.Text = string.IsNullOrEmpty(laDetailDemande.Transfert.LIBELLEREGROUPEMENT) ? string.Empty : laDetailDemande.Transfert.LIBELLEREGROUPEMENT; this.txtNumeroDemande.Text = laDetailDemande.LaDemande.NUMDEM; this.txtProduit.Text = laDetailDemande.LaDemande.LIBELLEPRODUIT; this.txt_Ref_Branchement.Text = laDetailDemande.LaDemande.CLIENT; this.txt_ordre.Text = laDetailDemande.LaDemande.ORDRE; laDetailDemande.LaDemande.FK_IDETAPEENCOURE = laDetailDemande.InfoDemande.FK_IDETAPEACTUELLE; CsClientRechercher leclientRech = new CsClientRechercher() { CENTRE = laDetailDemande.LeClient.CENTRE, CLIENT = laDetailDemande.LeClient.REFCLIENT, ORDRE = laDetailDemande.LeClient.ORDRE, FK_IDCENTRE = laDetailDemande.LeClient.FK_IDCENTRE.Value, }; RetourneLeCompteClient(leclientRech); RemplireOngletClient(laDetailDemande.LeClient); RemplirOngletAbonnement(laDetailDemande.Abonne); RemplireOngletCanalisation(laDetailDemande.LstCanalistion); RemplireBranchementParProduit(laDetailDemande.Branchement); RemplireOngletAdresse(laDetailDemande.Ag); if (laDetailDemande.ObjetScanne != null && laDetailDemande.ObjetScanne.Count != 0) { this.tabPieceJointe.Visibility = System.Windows.Visibility.Visible; } RenseignerInformationsDocumentScanne(); } }; client.ChargerDetailDemandeAsync(IdDemandeDevis, string.Empty); }
public List <CsAbonneCarte> RetourneCoordonneesAbon(CsClientRechercher client) { try { DBSig DbSig = new DBSig(); return(DbSig.RetournerCoodonnesAbonne(client)); } catch (Exception ex) { ErrorManager.LogException(this, ex); return(null); } }
private void RetourneLeCompteClient(CsClientRechercher leClient) { try { AcceuilServiceClient service = new AcceuilServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("Accueil")); service.RetourneLeCompteClientCompleted += (s, args) => { leClasseurClient = new CsCompteClient(); if (args != null && args.Cancelled) { return; } leClasseurClient = args.Result; if (leClasseurClient != null) { decimal _totalDebit = 0; decimal _totalCredit = 0; _totalDebit = decimal.Parse(leClasseurClient.ToutLClient.Where(t => t.DC == SessionObject.Enumere.Debit).Sum(p => p.MONTANT).ToString()); this.tab4_txt_TotalDebit.Text = _totalDebit.ToString(SessionObject.FormatMontant); _totalCredit = leClasseurClient.ToutLClient.Where(t => t.DC == SessionObject.Enumere.Credit).Sum(p => decimal.Parse(p.MONTANT.ToString())); this.tab4_txt_TotalCredit.Text = _totalCredit.ToString(SessionObject.FormatMontant); tab4_txt_balance.Text = (_totalDebit - _totalCredit).ToString(SessionObject.FormatMontant);; LstReglementClient = new List <CsLclient>(); LstFactureClient = new List <CsLclient>(); if (leClasseurClient.LstFacture != null) { LstFactureClient = leClasseurClient.LstFacture; } if (leClasseurClient.LstReglement != null) { LstReglementClient = leClasseurClient.LstReglement; } RemplirTypeAction(0); } }; service.RetourneLeCompteClientAsync(leClient.FK_IDCENTRE, leClient.CENTRE, leClient.CLIENT, leClient.ORDRE); service.CloseAsync(); } catch (Exception ex) { } }
private void AfficheFacture(string centre, string client, string ordre, string orientation, List <CsDemandeDetailCout> LstDetail) { try { List <CsLclient> ListeElement = null; List <CsLclient> ListeElementDg2 = new List <CsLclient>(); AcceuilServiceClient service = new AcceuilServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("Accueil")); service.RetourneCompteClientTransfertCompleted += (s, args) => { if (args != null && args.Cancelled) { return; } ListeElement = args.Result; dgclientselectionne.ItemsSource = ListeElement; if (this.IsEnregistre == true) { foreach (CsDemandeDetailCout detail in LstDetail) { CsLclient Unclient = new CsLclient(); Unclient = ListeElement.Where(c => c.CLIENT == detail.CLIENT && c.CENTRE == detail.CENTRE && c.ORDRE == detail.ORDRE && c.NDOC == detail.NDOC && c.REFEM == detail.REFEM).FirstOrDefault(); ListeElementDg2.Add(Unclient); } dgClientEligible.ItemsSource = ListeElementDg2; } }; CsClientRechercher Leclient = new CsClientRechercher(); Leclient.CENTRE = centre; Leclient.CLIENT = client; Leclient.ORDRE = ordre; service.RetourneCompteClientTransfertAsync(Leclient, orientation); service.CloseAsync(); } catch (Exception ex) { throw ex; } }
public List <CsAbonneCarte> RetournerCoodonnesAbonne(CsClientRechercher client) { DataTable dt = SIGProcedures.RetournerCoodonnesAbonne(client); return(Galatee.Entity.Model.Entities.GetEntityListFromQuery <CsAbonneCarte>(dt)); }