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