public JsonResult Update(int id_OrdersTables, int[] ordersList) { using (PortalKATEKEntities db = new PortalKATEKEntities()) { db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; var posList = db.OrdersTablesPositions.Where(d => d.id_OrdersTables == id_OrdersTables).ToList(); foreach (var pos in posList) { if (ordersList.Where(d => d == pos.id_PZ_PlanZakaz).Count() == 0) { db.OrdersTablesPositions.Remove(pos); db.SaveChanges(); } } posList = db.OrdersTablesPositions.Where(d => d.id_OrdersTables == id_OrdersTables).ToList(); foreach (var ord in ordersList) { if (posList.Where(d => d.id_PZ_PlanZakaz == ord).Count() == 0) { OrdersTablesPositions order = new OrdersTablesPositions { isActive = true, id_PZ_PlanZakaz = ord, id_OrdersTables = id_OrdersTables }; db.OrdersTablesPositions.Add(order); db.SaveChanges(); } } return(Json(1, JsonRequestBehavior.AllowGet)); } }
public JsonResult Add(int[] ordersList) { string login = HttpContext.User.Identity.Name; using (PortalKATEKEntities db = new PortalKATEKEntities()) { db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; Wiki.OrdersTables order = new Wiki.OrdersTables { dateCreate = DateTime.Now, dateClose = null, dateRemove = null, isActive = true, id_AspNetUsersCreate = db.AspNetUsers.First(a => a.Email == login).Id }; db.OrdersTables.Add(order); db.SaveChanges(); foreach (var data in ordersList) { OrdersTablesPositions pos = new OrdersTablesPositions(); pos.id_PZ_PlanZakaz = data; pos.id_OrdersTables = order.id; pos.isActive = true; db.OrdersTablesPositions.Add(pos); db.SaveChanges(); } string directory = @"\\192.168.1.30\m$\_ЗАКАЗЫ\Таблички\" + order.id.ToString() + "\\"; Directory.CreateDirectory(directory); DirectoryInfo dr = new DirectoryInfo(@"\\192.168.1.30\m$\_ЗАКАЗЫ\Таблички\BU\"); foreach (FileInfo fi in dr.GetFiles("*.cdr")) { fi.CopyTo(directory + fi.Name, true); } string[] body = GetFileBodyCRD(ordersList, directory); System.IO.File.WriteAllLines(directory + "RecordedMacros.bas", body, Encoding.Unicode); body = GetArrayFileBodyCRD(ordersList); System.IO.File.WriteAllLines(directory + "RecordedMacros.txt", body, Encoding.Unicode); return(Json(1, JsonRequestBehavior.AllowGet)); } }