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