public static bool Updatecontroles(CsControleTravaux pControle) { try { return(Entities.UpdateEntity <Galatee.Entity.Model.CONTROLETRAVAUX>(Entities.ConvertObject <Galatee.Entity.Model.CONTROLETRAVAUX, CsControleTravaux>(pControle))); } catch (Exception ex) { throw ex; } }
//public static bool InsertControl(CsControleTravaux pControle) //{ // try // { // //pControle.FK_IDMATRICULE =GetAgentByMatricul(pControle.USERCREATION); // return Entities.InsertEntity<Galatee.Entity.Model.CONTROLETRAVAUX>(Entities.ConvertObject<Galatee.Entity.Model.CONTROLETRAVAUX, CsControleTravaux>(pControle)); // } // catch (Exception ex) // { // throw ex; // } //} public static bool InsertControl(CsControleTravaux pControle) { try { //pControle.FK_IDMATRICULE =GetAgentByMatricul(pControle.USERCREATION); bool DmdSaved = false; DEMANDE laDemande = new DEMANDE(); using (galadbEntities context = new galadbEntities()) { laDemande = context.DEMANDE.FirstOrDefault(d => d.PK_ID == pControle.FK_IDDEMANDE); laDemande.ISCONTROLE = true; } DmdSaved = Entities.UpdateEntity(laDemande); var CrtTravaux = Entities.ConvertObject <Galatee.Entity.Model.CONTROLETRAVAUX, CsControleTravaux>(pControle); CrtTravaux.NUMDEM = laDemande.NUMDEM; CrtTravaux.FK_IDDEMANDE = laDemande.PK_ID; return(DmdSaved && Entities.InsertEntity <Galatee.Entity.Model.CONTROLETRAVAUX>(CrtTravaux)); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); //return exceptionMessage; // Throw a new DbEntityValidationException with the improved exception message. throw new System.Data.Entity.Validation.DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } }
private void EnregisterDemande(bool isTransmettre) { try { if (ChkMaterielConsomme.IsChecked == false) { throw new Exception("Veuillez renseigner le matériel consommé"); } if (NumUpDownNoteEvaluation.Value == 0) { throw new Exception("Veuillez attribuer une note allant de 0 à 5"); } if (NumUpDownNoteEvaluation.Value > 5) { throw new Exception("Vous ne pouvez pas attribuer une note supérieur à 5"); } CsControleTravaux NewControl = new CsControleTravaux(); NewControl.FK_IDDEMANDE = laDetailDemande.LaDemande.PK_ID; NewControl.FK_IDMATRICULE = UserConnecte.PK_ID; NewControl.NUMDEM = laDetailDemande.LaDemande.NUMDEM; NewControl.ORDRE = int.Parse(laDetailDemande.LaDemande.ORDRE); NewControl.METMOYCONTROLE = TxtMethodeDeControle.Text; NewControl.DEGRADATIONVOIE = TxtDegradationVoiePublic.Text; NewControl.VOLUMETERTRVX = TxtVolumeTravauxTerassement.Text; NewControl.DATECONTROLE = Convert.ToDateTime(DtpDateControle.SelectedDate.Value); NewControl.NOTE = (int)NumUpDownNoteEvaluation.Value; NewControl.USERMODIFICATION = UserConnecte.matricule; NewControl.MATRICULECHEFEQUIPE = UserConnecte.matricule; NewControl.NOMCHEFEQUIPE = UserConnecte.nomUtilisateur; NewControl.DATEMODIFICATION = DateTime.Now; NewControl.USERCREATION = UserConnecte.matricule; NewControl.DATECREATION = DateTime.Now; NewControl.FK_IDTYPECONTROLE = 1; AcceuilServiceClient service = new AcceuilServiceClient(Utility.ProtocoleFacturation(), Utility.EndPoint("Accueil")); service.InsertControlCompleted += (ss, back) => { if (back.Cancelled || back.Error != null) { LayoutRoot.Cursor = Cursors.Arrow; string error = back.Error.Message; Message.ShowError(error, Silverlight.Resources.Devis.Languages.txtDevis); return; } if (!back.Result) { LayoutRoot.Cursor = Cursors.Arrow; Message.ShowError(Silverlight.Resources.Devis.Languages.msgErreurMiseAJourDevis, Silverlight.Resources.Devis.Languages.txtDevis); return; } else { if (isTransmettre) { List <string> codes = new List <string>(); codes.Add(laDetailDemande.InfoDemande.CODE); Galatee.Silverlight.Shared.ClasseMEthodeGenerique.TransmettreDemande(codes, false, this); if (laDetailDemande.InfoDemande != null && laDetailDemande.InfoDemande.CODE != null) { Shared.ClasseMEthodeGenerique.NotifierMailDemande(laDetailDemande.InfoDemande.UtilisateurEtapeSuivante, "0001", laDetailDemande.LaDemande.NUMDEM, laDetailDemande.LaDemande.LIBELLETYPEDEMANDE); } } LayoutRoot.Cursor = Cursors.Arrow; this.DialogResult = true; } }; service.InsertControlAsync(NewControl); } catch (Exception ex) { Message.ShowError(ex.Message, Galatee.Silverlight.Resources.Devis.Languages.txtDevis); } }