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