public String ajouterLF(piece_fact lBl) { String resultat = "Ok"; using (NewCampusEntities db = new NewCampusEntities()) { if (this.testAjouterLF(lBl) == false) { try { db.piece_fact.Add(lBl); db.SaveChanges(); } catch (Exception e) { resultat = e.Message; } } else { resultat = "LF existante "; } } return(resultat); }
public string supprimerLF(List <piece_fact> listp) { String resultat = "OK"; foreach (piece_fact aX in listp) { using (NewCampusEntities db = new NewCampusEntities()) { try { if (aX.id_piece > 0) { piece_fact artX = db.piece_fact.Single(a => a.id_piece == aX.id_piece); db.piece_fact.Remove(artX); db.SaveChanges(); } } catch (Exception) { //resultat = resultat + "," + aX.id_commande; db.Dispose(); } } } return(resultat); }
public Boolean testAjouterLF(piece_fact b) { Boolean trouve = true; //string s = cli.code; using (NewCampusEntities db = new NewCampusEntities()) { try { var cx = db.piece_fact.Single(c => c.id_piece.Equals(b.id_piece)); if (cx == null) { trouve = false; } } catch (Exception) { trouve = false; } } return(trouve); }