public ZakazInfo Delete(int id)
{
ZakazInfo Info = GetbyId(id);
using (LD_kursEntities db = new LD_kursEntities())
{
var zakaz = db.zakaz.SingleOrDefault(c => c.id == id);
if (zakaz == null)
{
return(null);
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
foreach (var item in zakaz.work.ToList())
{
db.Entry(item).State = EntityState.Deleted;
}
db.Entry(zakaz).State = EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
return(Info);
}
public Designer Delete(int id)
{
var user = GetbyIduser(id);
if (user != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var orders = db.zakaz.Where(x => x.designer_id == id).ToList();
foreach (var zakaz in orders)
{
var wk = db.work.Where(x => x.zakazId == zakaz.id).ToList();
foreach (var it in wk)
{
db.Entry(it).State = EntityState.Deleted;
}
db.Entry(zakaz).State = EntityState.Deleted;
}
db.Entry(user).State = EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
return(Mapper.Map <Designer>(user));
}
//test
public Customer Del(int id)
{
var user = GetcustomerById(id);
using (LD_kursEntities db = new LD_kursEntities())
{
if (user != null)
{
foreach (var land in user.land.ToList())
{
db.Entry(land).State = EntityState.Deleted;
}
db.Entry(user).State = EntityState.Deleted;
db.SaveChanges();
}
}
return(Mapper.Map <Customer>(user));
}
public Customer Delete(int id)
{
var user = GetcustomerById(id);
using (LD_kursEntities db = new LD_kursEntities())
{
if (user != null)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
foreach (var item in user.land.ToList())
{
var orders = db.zakaz.Where(x => x.land.id == item.id).ToList();
foreach (var zk in orders)
{
var wk = db.work.Where(x => x.zakazId == zk.id).ToList();
foreach (var it in wk)
{
db.Entry(it).State = EntityState.Deleted;
}
db.Entry(zk).State = EntityState.Deleted;
}
db.Entry(item).State = EntityState.Deleted;
}
db.Entry(Mapper.Map <customer>(user)).State = EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
return(Mapper.Map <Customer>(user));
}
public Land Delete(int id)
{
var land = GetbyId(id);
if (land != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
db.Entry(Mapper.Map <land>(land)).State = EntityState.Deleted;
db.SaveChanges();
}
}
return(land);
}
public int Edit(Land _land)
{
if (_land != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
db.Entry(Mapper.Map <land>(_land)).State = EntityState.Modified;
return(db.SaveChanges());
}
}
else
{
throw new Exception("Couldn't save null instance");
}
}
public int Edit(Designer user)
{
if (user != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
db.Entry(Mapper.Map <designer>(user)).State = EntityState.Modified;
return(db.SaveChanges());
}
}
else
{
throw new Exception("Couldn't save null instance");
}
}
public Zakaz Edit(Zakaz _zakaz)
{
Zakaz returnZakaz;
if (_zakaz != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
var zakaz = Mapper.Map <zakaz>(_zakaz);
db.Entry(zakaz).State = EntityState.Modified;
db.SaveChanges();
returnZakaz = Mapper.Map <Zakaz>(zakaz);
}
}
else
{
throw new Exception("Couldn't edit null instance");
}
return(returnZakaz);
}