public String ajouterDevis(devis Bl) { String resultat = "Ok"; using (NewCampusEntities db = new NewCampusEntities()) { if (this.testAjouterDevis(Bl) == false) { try { db.devis.Add(Bl); db.SaveChanges(); } catch (Exception e) { resultat = e.Message; } } else { resultat = "Devis existante, verifiez le champs num devis "; } } return(resultat); }
public void modifier(devis bl) { using (NewCampusEntities db = new NewCampusEntities()) { db.devis.Attach(db.devis.Single(x => x.id == bl.id)); db.Entry(db.devis.Single(x => x.id == bl.id)).CurrentValues.SetValues(bl); //db.piece.ApplyCurrentValues(Cab); db.SaveChanges(); } }
public devis GetDevisBynum(int num) { // NewCampusEntities db = new NewCampusEntities(); devis Bl = new devis(); try { using (NewCampusEntities db = new NewCampusEntities()) { return(db.devis.Where(aa => aa.numero_devis == num).FirstOrDefault()); } } catch (Exception) { Bl = new devis(); } return(Bl); }
public String supprimerDevis(devis bl) { String resultat = "Devis supprimé"; using (NewCampusEntities db = new NewCampusEntities()) { try { db.devis.Attach(bl);// selectionne l'element dans la base pour le supprimer dans l'etape suivante db.devis.Remove(bl); db.SaveChanges(); } catch (Exception) { resultat = resultat + "," + bl.numero_devis; db.Dispose(); } } return(resultat); }
public Boolean testAjouterDevis(devis b) { Boolean trouve = true; //string s = cli.code; using (NewCampusEntities db = new NewCampusEntities()) { try { var cx = db.devis.Single(c => c.numero_devis.Equals(b.numero_devis)); if (cx == null) { trouve = false; } } catch (Exception) { trouve = false; } } return(trouve); }