Ejemplo n.º 1
0
        public async Task <IActionResult> AddOrEdit(int id, [Bind("GarisId,AwalId,AkhirId")] Garis garis)
        {
            if (id != garis.GarisId)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(garis);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!GarisExists(garis.GarisId))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["AkhirId"] = new SelectList(_context.TblKoordinat, "KoordId", "KoordId", garis.AkhirId);
            ViewData["AwalId"]  = new SelectList(_context.TblKoordinat, "KoordId", "KoordId", garis.AwalId);
            return(View(garis));
        }
Ejemplo n.º 2
0
        public IActionResult KompGaris(int? polaId, int? garisId, int? koorId, int? skl, bool inzet = false)
        {
            var sesPola = SPola.GetSesi(this);
            int _polaId = 0;
            if (polaId == null || polaId == 0)
            {
                _polaId = sesPola.PolaId;
            }
            else
            {
                _polaId = (int)polaId;
            }

            if(garisId != null)
            {
                // simpan ke sessi
                sesPola.SetGarisId(garisId);
            }
            else {
                garisId = sesPola.GarisId;
            }

            if (skl != null)
            {
                // simpan ke sessi
                sesPola.SetSkala(skl);
            }
            else
            {
                skl = sesPola.Skala;
            }
            //tidak ada pilihan pola

            decimal skala = (decimal)skl;
            var polaNama = "";

            //int polId = ;

            var mvKompGaris = new MVGambarKompGaris();
            var mvGambarGarisParsial = new MVGambarGarisParsial()
            {
                Skala = skala / 100,
                PolaId = _polaId
            };
            var mvGambarGarisValid = new MVGambarGarisValid()
            {
                Skala = skala / 100,
                PolaId = _polaId
            };

            if (_polaId != 0)
            {

                #region garis valid
                polaNama = _context.TblPola.Find(_polaId).Nama;

                var qGaris = new List<Garis>().AsQueryable();
                var qGrsKoor = new List<OKetGarisKoordinat>().AsQueryable();
                var qTtkKoor = new List<Koordinat>().AsQueryable();
                try
                {
                    QCekGaris qcGaris = new QCekGaris(_context, _polaId);
                    qcGaris.UpdateDariGambar();
                    qGaris = qcGaris.QryTblIniPosUpToDate.OrderBy(g => g.Arah);

                    // memperbaharui tabel garis di pola terpilih
                    QCekGaris qGrs = new QCekGaris(_context, _polaId);
                    qGrs.UpdateDariGambar();

                    QCekKoordinat qKoor = new QCekKoordinat(_context, _polaId);
                    qGrsKoor = qKoor.GarisKoordinat;
                    qTtkKoor = qKoor.QryTblIniPosUpToDate;
                    // filter titik koordinat yang ada garis saja--------------------
                    var lstKoorAwalGrs = qGaris.Select(g => g.KoordAwal.KoordId).ToList();
                    var lstKoorAkhirGrs = qGaris.Select(g => g.KoordAkhir.KoordId).ToList();
                    qTtkKoor = qTtkKoor.Where(t => lstKoorAwalGrs.Contains(t.KoordId) || lstKoorAkhirGrs.Contains(t.KoordId));
                    //---------------------------------------------------------------------------------------------------------
                    mvGambarGarisValid.TinggiMax = qGrsKoor.Where(g => g.Garis.Arah == ESumbu.Y)
                                .Select(s => s.Garis.Akhir.TitikY.PosAbs).Max() + 300;
                    mvGambarGarisValid.LebarMax = qGrsKoor.Where(g => g.Garis.Arah == ESumbu.X)
                                .Select(s => s.Garis.Akhir.TitikX.PosAbs).Max() + 300;
                    //buat garis koordinat
                }
                catch (Exception) { }
                mvGambarGarisValid.LstGarisReal = qGaris.ToList();
                mvGambarGarisValid.LstGrsKoord = qGrsKoor.ToList();
                mvGambarGarisValid.LstKoord = qTtkKoor.ToList();
                #endregion
                #region garis parsial
                var garis = new Garis();
                try
                {
                    // for test
                    //garisId = 1;
                    QCekGaris qcGaris = new QCekGaris(_context, _polaId);
                    garis = qcGaris.QryTblIniPosUpToDate.Single(g => g.GarisId == (int)garisId);  //OrderBy(g => g.Arah);

                    QCekKoordinat qKoor = new QCekKoordinat(_context, _polaId);
                    qGrsKoor = qKoor.GarisKoordinat4Z;
                    qTtkKoor = qKoor.QryTblIni4ZPosUpToDate;

                    mvGambarGarisParsial.TinggiMax = qGrsKoor.Where(g => g.Garis.Arah == ESumbu.Y)
                                .Select(s => s.Garis.Akhir.TitikY.PosRel).Max();
                }
                catch (Exception) { }
                if (garisId != 0)
                {
                    QCekKompGaris qcKGaris = new QCekKompGaris(_context, _polaId, (int) garisId);
                    mvGambarGarisParsial.GarisReal = garis;
                    mvGambarGarisParsial.LstGarisKomp = qcKGaris.GarisKomponen.ToList();
                }
                mvGambarGarisParsial.LstGrsKoord = qGrsKoor.ToList();
                mvGambarGarisParsial.LstKoord = qTtkKoor.ToList();

                #endregion

                mvKompGaris.GarisValid = mvGambarGarisValid;
                mvKompGaris.GarisParsial = mvGambarGarisParsial;
                // menambang tabel komponen garis
                var tblKompGaris = _context.TblKomponenGaris
                        .Include(k => k.Garis)
                            .Include(g => g.Garis.KoordAwal)
                            .Include(g => g.Garis.KoordAkhir)
                            .Include(g => g.Garis.KoordAwal.TitikX)
                            .Include(g => g.Garis.KoordAwal.TitikY)
                            .Include(g => g.Garis.KoordAkhir.TitikX)
                            .Include(g => g.Garis.KoordAkhir.TitikY)
                        .Include(k => k.PolaKomponen).ThenInclude(p => p.Komponen)
                        .Include(k => k.TitikZ)
                        .Where(k => k.Garis.GarisId == garisId)
                        ;

                mvKompGaris.GarisParsial.TblKompGaris = tblKompGaris;
            }

            ViewBag.Skala = skala / 50;
            ViewBag.GarisTerpilih = garisId;
            ViewBag.KoordTerpilih = koorId;
            bool isAjax = HttpContext.Request.Headers["X-Requested-With"] == "XMLHttpRequest";
            if (isAjax)
            {
                if (inzet)
                {
                    return PartialView("RAB/_ViewGambarKompGaris", mvGambarGarisValid);
                }
                else
                {
                    return PartialView("RAB/_ViewGambarGarisParsial", mvGambarGarisParsial);
                }
            }

            //ViewBag.PolaNama = polaNama;
            ViewBag.ListSkala = new SelectList(LstSkala, "Nilai", "Nama", skala);

            return View(mvKompGaris);
        }