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