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