Exemplo n.º 1
0
        public void save(RuteTol dbitem, int id)
        {
            var query = "";

            if (dbitem.Id == 0) //create
            {
                context.RuteTol.Add(dbitem);
            }
            else //edit
            {
                context.RuteTol.Attach(dbitem);
                var entry = context.Entry(dbitem);
                entry.State = EntityState.Modified;
                query      += "DELETE FROM dbo.\"TolBerangkat\" WHERE \"IdRuteTol\" = " + dbitem.Id + ";";
                query      += "DELETE FROM dbo.\"TolPulang\" WHERE \"IdRuteTol\" = " + dbitem.Id + ";";
            }
            context.SaveChanges();
            foreach (Context.TolBerangkat tp in dbitem.ListTolBerangkat)
            {
                query += "INSERT INTO dbo.\"TolBerangkat\" (\"IdRuteTol\", \"IdTol\") VALUES (" + tp.IdRuteTol + ", " + tp.IdTol + ");";
            }
            foreach (Context.TolPulang tp in dbitem.ListTolPulang)
            {
                query += "INSERT INTO dbo.\"TolPulang\" (\"IdRuteTol\", \"IdTol\") VALUES (" + tp.IdRuteTol + ", " + tp.IdTol + ");";
            }
            var auditrail = new Auditrail {
                Actionnya = dbitem.Id == 0 ? "Add" : "Edit", EventDate = DateTime.Now, Modulenya = "Rute Tol", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(),
                IdUser    = id
            };

            context.Auditrail.Add(auditrail);
            context.SaveChanges();
        }
Exemplo n.º 2
0
        public ActionResult Edit(int id)
        {
            Context.RuteTol dbitem = RepoRuteTol.FindByPK(id);
            RuteTol         model  = new RuteTol(dbitem);

            ViewBag.name = model.NamaRute;
            return(View("Form", model));
        }
Exemplo n.º 3
0
        public ActionResult Edit(RuteTol model)
        {
            if (ModelState.IsValid)
            {
                Context.RuteTol dbitem = RepoRuteTol.FindByPK(model.Id);
                model.setDb(dbitem);
                RepoRuteTol.save(dbitem, UserPrincipal.id);

                return(RedirectToAction("Index"));
            }
            TolPP[] resultBerangkat = JsonConvert.DeserializeObject <TolPP[]>(model.strBerangkat);
            TolPP[] resultPulang    = JsonConvert.DeserializeObject <TolPP[]>(model.strPulang);
            model.ListTolBerangkat = resultBerangkat.ToList();
            model.ListTolPulang    = resultPulang.ToList();
            return(View("Form", model));
        }
Exemplo n.º 4
0
        public void delete(RuteTol dbitem)
        {
            context.RuteTol.Remove(dbitem);

            context.SaveChanges();
        }
Exemplo n.º 5
0
        public ActionResult Add()
        {
            RuteTol model = new RuteTol();

            return(View("Form", model));
        }