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)); }
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 void Save(Land _land) { if (_land != null) { using (LD_kursEntities db = new LD_kursEntities()) { db.land.Add(Mapper.Map <land>(_land)); db.SaveChanges(); } } else { throw new Exception("Couldn't save null instance"); } }
public int Save(int orderId, int DifficultsId) { using (LD_kursEntities db = new LD_kursEntities()) { var order = db.zakaz.SingleOrDefault(c => c.id == orderId); var diff = db.difficulties.SingleOrDefault(c => c.id == DifficultsId); if (order == null || diff == null) { return(-1); } order.difficulties.Add(diff); db.SaveChanges(); } return(DifficultsId); }
public void Save(Customer _customer) { if (_customer != null) { using (LD_kursEntities db = new LD_kursEntities()) { db.customer.Add(Mapper.Map <customer>(_customer)); 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 void Save(Designer user) { if (user != null) { using (LD_kursEntities db = new LD_kursEntities()) { db.designer.Add(Mapper.Map <designer>(user)); db.SaveChanges(); } } else { throw new Exception("Couldn't save null instance"); } }
public int Save(int orderId, Work Work) { int result = -1; using (LD_kursEntities db = new LD_kursEntities()) { var order = db.zakaz.SingleOrDefault(m => m.id == orderId); var work = Mapper.Map <work>(Work); if (order != null && work != null) { order.work.Add(work); db.SaveChanges(); result = work.id; } } return(result); }
public Difficulties Remove(int orderId, int DifficultsId) { Difficulties difficults = new Difficulties(); using (LD_kursEntities db = new LD_kursEntities()) { var order = db.zakaz.SingleOrDefault(c => c.id == orderId); var diff = db.difficulties.SingleOrDefault(c => c.id == DifficultsId); if (order == null || diff == null) { return(null); } order.difficulties.Remove(diff); db.SaveChanges(); difficults = Mapper.Map <Difficulties>(diff); } return(difficults); }
//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 Work Remove(int orderId, int WorkId) { Work Work = new Work(); using (LD_kursEntities db = new LD_kursEntities()) { var order = db.zakaz.SingleOrDefault(c => c.id == orderId); var work = db.work.SingleOrDefault(c => c.id == WorkId); if (order == null || work == null) { return(null); } order.work.Remove(work); db.SaveChanges(); Work = Mapper.Map <Work>(work); } return(Work); }
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); }
public Zakaz Save(Zakaz _zakaz) { Zakaz returnZakaz; if (_zakaz != null) { using (LD_kursEntities db = new LD_kursEntities()) { var zakaz = Mapper.Map <zakaz>(_zakaz); db.zakaz.Add(zakaz); db.SaveChanges(); returnZakaz = Mapper.Map <Zakaz>(zakaz); } } else { throw new Exception("Couldn't save null instance"); } return(returnZakaz); }
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)); }