public bool insertAll(Int16 costumerid, string name, Int16 orderid, DateTime data, string produs, Decimal valoareOD, Int16 serial, string adress = "", Decimal valoareO = -1)
{
bool insert = false;
using (var testEntities = new TestEntities())
{
CUSTOMER c = new CUSTOMER();
c.CUSTOMERID = costumerid;
if (testEntities.CUSTOMER.Where(x => x.CUSTOMERID == c.CUSTOMERID).Count() <= 0)
{
c.NAME = name;
c.ADRESA = adress;
if (testEntities.ORDER.Where(x => x.ORDERID == orderid).Count() <= 0 && testEntities.ORDERDETAILS.Where(x => x.SERIAL == serial).Count() <= 0)
{// nu exita conflicte
ORDER o = new ORDER {
ORDERID = orderid, DATA = data, CUSTOMERID = costumerid, VALOARE = valoareO
};
c.ORDER.Add(o);
o.ORDERDETAILS.Add(new ORDERDETAILS {
ORDERID = orderid, PRODUS = produs, VALOARE = valoareOD, SERIAL = serial
});
testEntities.AddToCUSTOMER(c);
testEntities.SaveChanges();
insert = true;
}
}
else
{
return(false);
}
}
return(insert);
}
public bool addCostumer(Int16 id, string name, string adress = "")
{
using (var testEntities = new TestEntities())
{
CUSTOMER c = new CUSTOMER();
c.CUSTOMERID = id;
// verificam daca mai exista un asemena id in bd
if (testEntities.CUSTOMER.Where(x => x.CUSTOMERID == c.CUSTOMERID).Count() <= 0)
{
c.NAME = name;
c.ADRESA = adress;
testEntities.AddToCUSTOMER(c);
testEntities.SaveChanges();
}
else
{
return(false);
}
}
return(true); // clientul a fost adauga
}