public OrderAndTable(orders order)
{
this.order = order;
worksId = new List <int>();
using (var dc = new MySQLEntities())
{
works = dc.works.ToList();
for (int i = 0; i <= works.Count - 1; i++)
{
works[i].index = i;
worksId.Add(i);
}
worksorder = (from item in dc.worksorders
where item.order == order.idOrders
select item).ToList();
foreach (var item in worksorder)
{
item.index = works.Where(c => c.idWorks == item.work).First().index;
}
}
}
public MasterAndTable(masters master)
{
this.master = master;
districtsId = new List <int>();
worktypesId = new List <int>();
using (var dc = new MySQLEntities())
{
districts = dc.districts.ToList();
for (int i = 0; i <= districts.Count - 1; i++)
{
districts[i].index = i;
districtsId.Add(i);
}
worktypes = dc.worktypes.ToList();
for (int i = 0; i <= worktypes.Count - 1; i++)
{
worktypes[i].index = i;
worktypesId.Add(i);
}
districtsmaster = (from item in dc.districtsmasters
where item.master == master.idMasters
select item).ToList();
foreach (var item in districtsmaster)
{
item.index = districts.Where(c => c.iddistricts == item.district).First().index;
}
worktypesmaster = (from item in dc.worktypesmasters
where item.master == master.idMasters
select item).ToList();
foreach (var item in worktypesmaster)
{
item.index = worktypes.Where(c => c.idWorkTypes == item.worktype).First().index;
}
}
}
public void SaveTable()
{
try
{
using (var dc = new MySQLEntities())
{
//работы
var result = (from c in dc.worksorders
where c.order == order.idOrders
select c);
if (result.Count() != 0)
{
foreach (var item in result)
{
dc.worksorders.Remove(item);
}
}
if (worksorder != null && worksorder.Count() != 0)
{
foreach (var item in worksorder)
{
//if (item.index == )
item.order = order.idOrders;
item.work = works[(int)item.index].idWorks;
dc.worksorders.Add(item);
}
}
dc.SaveChanges();
}
}
catch (Exception ex)
{
}
}
public void Save()
{
try
{
using (var dc = new MySQLEntities())
{
if (master.idMasters == Guid.Empty || dc.masters.Find(master.idMasters) == null)
{
master.idMasters = Guid.NewGuid();
dc.masters.Add(master);
}
else
{
dc.Entry(master).State = EntityState.Modified;
}
//районы
var result = (from c in dc.districtsmasters
where c.master == master.idMasters
select c);
if (result.Count() != 0)
{
foreach (districtsmasters item in result)
{
dc.districtsmasters.Remove(item);
}
}
if (districtsmaster != null && districtsmaster.Count() != 0)
{
foreach (var item in districtsmaster)
{
//if (item.index == )
item.master = master.idMasters;
item.district = districts[(int)item.index].iddistricts;
dc.districtsmasters.Add(item);
}
}
//виды деятельности
var result2 = (from c in dc.worktypesmasters
where c.master == master.idMasters
select c);
if (result.Count() != 0)
{
foreach (worktypesmasters item in result2)
{
dc.worktypesmasters.Remove(item);
}
}
if (worktypesmaster != null && worktypesmaster.Count() != 0)
{
foreach (var item in worktypesmaster)
{
//if (item.index == )
item.master = master.idMasters;
item.worktype = worktypes[(int)item.index].idWorkTypes;
dc.worktypesmasters.Add(item);
}
}
//-
dc.SaveChanges();
//foreach (var item in worktypesmasters)
//{
// item.master = master.idMasters;
// dc.districtsmasters.Add(item);
// dc.SaveChanges();
//}
}
}
catch (Exception ex)
{
}
}