Exemple #1
0
        public List <outbondProfileView> GetAlloutbonds()
        {
            List <outbondProfileView> outbonds = new List <outbondProfileView>();

            using (DemoEntities1 db = new DemoEntities1())
            {
                outbondProfileView MV;
                var outbond = db.outbonds.ToList();
                foreach (outbond m in db.outbonds)
                {
                    MV            = new outbondProfileView();
                    MV.id_outbond = m.id_outbond;
                    MV.keterangan = m.keterangan;
                    MV.harga      = (int)m.harga;

                    outbonds.Add(MV);
                }
                return(outbonds);
            }
        }
Exemple #2
0
        //[AuthorizeRoles("Admin")]
        public ActionResult UpdateoutbondData(int id_outbond, string keterangan, int harga)
        {
            outbondProfileView MPV = new outbondProfileView();

            MPV.id_outbond = id_outbond;
            MPV.keterangan = keterangan;
            MPV.harga      = harga;

            using (DemoEntities1 db = new DemoEntities1())
            {
                using (var dbContext = db.Database.BeginTransaction())
                {
                    try
                    {
                        outbond m = db.outbonds.Find(MPV.id_outbond);
                        m.keterangan = MPV.keterangan;
                        m.harga      = MPV.harga;

                        db.SaveChanges();
                        dbContext.Commit();
                    }
                    catch (Exception ex)
                    {
                        dbContext.Rollback();
                    }
                }
            }

            return(Json(new
            {
                success = true,
                id_outbond = MPV.id_outbond,
                keterangan = MPV.keterangan,
                harga = MPV.harga
            }));
        }