Esempio n. 1
0
        public ActionResult OrderDetails(OrderAndTable model)
        {
            var order = model.order;

            using (var dc = new MySQLEntities())
            {
                var orderInDb = dc.orders.Find(order.idOrders);

                if (orderInDb == null)
                {
                    order.idOrders = Guid.NewGuid();
                    dc.orders.Add(order);
                    dc.SaveChanges();
                }
                else
                {
                    //dc.Set<order>().AddOrUpdate(order);

                    dc.Entry(orderInDb).CurrentValues.SetValues(order);
                    dc.Entry(orderInDb).State = EntityState.Modified;
                    dc.SaveChanges();
                }
            }

            Thread.Sleep(1000);
            return(RedirectToAction("../Home/Index"));
        }
Esempio n. 2
0
        public ActionResult OrderDetails(string idOrdersAsString)
        {
            try
            {
                using (var dc = new MySQLEntities())
                {
                    SelectList districts = new SelectList(dc.districts.ToList(), "iddistricts", "name");
                    ViewBag.Districts = districts;

                    SelectList statuses = new SelectList(dc.status.ToList(), "idstatus", "name");
                    ViewBag.Statuses = statuses;

                    SelectList customers = new SelectList(dc.customers.ToList(), "idcustomers", "name");
                    ViewBag.Customers = customers;

                    SelectList worktypes = new SelectList(dc.worktypes.ToList(), "idWorkTypes", "name");
                    ViewBag.Worktypes = worktypes;

                    SelectList masters = new SelectList(dc.masters.ToList(), "idMasters", "name");
                    ViewBag.Masters = masters;

                    SelectList works = new SelectList(dc.works.ToList(), "idWorks", "name");
                    ViewBag.Works = works;

                    var order = new orders();
                    if (idOrdersAsString == "")
                    {
                        order.idOrders = Guid.NewGuid();
                    }
                    else
                    {
                        Guid idOrders = new Guid(idOrdersAsString);
                        order = dc.orders.Find(idOrders);
                    }

                    var model = new OrderAndTable(order)
                    {
                        order = order,
                    };
                    return(PartialView(model));
                };
            }
            catch (Exception ex)
            {
                return(HttpNotFound());
            }
        }
Esempio n. 3
0
 public ActionResult RemoveWorkOrder(OrderAndTable model, int index)
 {
     model.RemoveWorkOrder(index);
     return(Json(model));
 }
Esempio n. 4
0
 public ActionResult AddWorkOrder(OrderAndTable model)
 {
     model.AddWorkOrder();
     return(Json(model));
 }
Esempio n. 5
0
 public ActionResult SaveOrder(OrderAndTable model)
 {
     model.SaveTable();
     return(Json(model));
 }