private void dataGrid_Loaded(object sender, RoutedEventArgs e) { try { CsCriteresDevis criteres = new CsCriteresDevis(); criteres.IdDevis = Devis.PK_ID; criteres.NumeroDevis = Devis.NUMDEVIS; criteres.CodeProduit = Devis.CODEPRODUIT; criteres.DateEtape = (DateTime)Devis.DATEETAPE; if (Devis.FK_IDETAPEDEVIS != null) { criteres.IdEtapeDevis = (int)Devis.FK_IDETAPEDEVIS; } LayoutRoot.Cursor = Cursors.Wait; AcceuilServiceClient client = new AcceuilServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("Accueil")); client.GetSuiviDevisByDevisIdCompleted += (ssender, args) => { if (args.Cancelled || args.Error != null) { LayoutRoot.Cursor = Cursors.Arrow; string error = args.Error.Message; Message.Show(error, Languages.txtDevis); return; } if (args.Result == null) { LayoutRoot.Cursor = Cursors.Arrow; Message.Show(Languages.msgErreurChargementDonnees, Languages.txtDevis); return; } dataGrid.ItemsSource = args.Result; this.OKButton.IsEnabled = this.dataGrid.SelectedItems.Count == 1; LayoutRoot.Cursor = Cursors.Arrow; }; client.GetSuiviDevisByDevisIdAsync(criteres); } catch (Exception ex) { LayoutRoot.Cursor = Cursors.Arrow; Message.Show(ex.Message, Languages.txtDevis); } }
public static List <ObjSUIVIDEVIS> GetSuiviDevisByDevisId(CsCriteresDevis pCritereDevis) { List <ObjSUIVIDEVIS> listActualisee = new List <ObjSUIVIDEVIS>(); try { var result = Entities.GetEntityListFromQuery <ObjSUIVIDEVIS>(DevisProcedures.DEVIS_SUIVIDEVIS_RETOURNEByDevisId(pCritereDevis)); foreach (var item in result) { //item.DUREE = CalculerDelai(pCritereDevis); listActualisee.Add(item); } return(listActualisee); } catch (Exception ex) { throw ex; } }
//public static bool UpdateSuiviDevis(ObjSUIVIDEVIS entity) //{ // try // { // return Entities.UpdateEntity<Galatee.Entity.Model.SUIVIDEVIS>(Entities.ConvertObject<Galatee.Entity.Model.SUIVIDEVIS, ObjSUIVIDEVIS>(entity)); // } // catch (Exception ex) // { // throw ex; // } //} //public static bool UpdateSuiviDevis(galadbEntities command, ObjSUIVIDEVIS entity) //{ // try // { // return Entities.UpdateEntity<Galatee.Entity.Model.SUIVIDEVIS>(Entities.ConvertObject<Galatee.Entity.Model.SUIVIDEVIS, ObjSUIVIDEVIS>(entity), command); // } // catch (Exception ex) // { // throw ex; // } //} //public static SUIVIDEVIS GetSuiviDevis(ObjSUIVIDEVIS entity) //{ // try // { // return Entities.ConvertObject<Galatee.Entity.Model.SUIVIDEVIS, ObjSUIVIDEVIS>(entity); // } // catch (Exception ex) // { // throw ex; // } //} //public static bool InsertSuiviDevis(galadbEntities command, ObjSUIVIDEVIS entity) //{ // try // { // return Entities.InsertEntity<Galatee.Entity.Model.SUIVIDEVIS>(Entities.ConvertObject<Galatee.Entity.Model.SUIVIDEVIS, ObjSUIVIDEVIS>(entity), command); // } // catch (Exception ex) // { // throw ex; // } //} private static double CalculerDelai(CsCriteresDevis pCritereDevis) { DateTime date, currentDate; currentDate = DateTime.Now.Date; TimeSpan difference; try { if (pCritereDevis != null) { date = (DateTime)pCritereDevis.DateEtape; difference = (currentDate.Date - date.Date); return(difference.TotalDays); } return(0); } catch (Exception ex) { throw ex; } }