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