Exemplo n.º 1
0
        public async Task <ActionResult> RasporedOdvoza()
        {
            var rasporedodvoza = await db.rasporedodvoza.Include(r => r.otpad).Include(r => r.ulica).ToListAsync();

            FiltrirajPretraživanje filtrirajPretraživanje = new FiltrirajPretraživanje();

            ViewBag.idGrad        = new SelectList(db.grad, "idGrad", "imeGrad");
            ViewBag.idVrsteOtpada = new SelectList(db.otpad, "idOtpad", "vrstaOtpad");
            ViewBag.idUlice       = new SelectList(db.ulica, "idUlica", "imeUlica");

            Tuple <List <rasporedodvoza>, FiltrirajPretraživanje> tuple = Tuple.Create(rasporedodvoza, filtrirajPretraživanje);

            return(View("~/Views/Home/RasporedOdvoza.cshtml", tuple));
        }
Exemplo n.º 2
0
        public async Task <ActionResult> FiltriranjeRasporedaOdvoza([Bind(Include = "tekstPretraživanja,otpad,grad,ulica,dan")] FiltrirajPretraživanje rez)
        {
            if (rez.tekstPretraživanja != null)
            {
                List <rasporedodvoza> rasporedodvoza = new List <rasporedodvoza>();

                rasporedodvoza = await(from c in db.rasporedodvoza
                                       where c.otpad.vrstaOtpad.Contains(rez.tekstPretraživanja) ||
                                       c.danTjednaOdvoza.Contains(rez.tekstPretraživanja) || c.ulica.imeUlica.Contains(rez.tekstPretraživanja) ||
                                       c.grad.imeGrad.Contains(rez.tekstPretraživanja) || c.vrijemeOdvoza.Contains(rez.tekstPretraživanja)
                                       select c).ToListAsync();

                return(PartialView("~/Views/Administrator/RasporedOdvoza/RasporedOdvozaListPartial.cshtml", rasporedodvoza));
            }
            else
            {
                List <rasporedodvoza> rasporedodvoza = new List <rasporedodvoza>();

                //svi odabrani
                if (rez.dan != null && rez.grad != null && rez.otpad != null && rez.ulica != null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.idUlice.ToString() == (rez.ulica) && c.idGrad.ToString() == (rez.grad) &&
                                           c.idVrsteOtpada.ToString() == (rez.otpad) && c.danTjednaOdvoza.Equals(rez.dan)
                                           select c).ToListAsync();
                }
                //nijedan odabran
                else if (rez.dan == null && rez.grad == null && rez.otpad == null && rez.ulica == null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza select c).ToListAsync();
                }
                //svi odabrani osim prvog
                else if (rez.dan == null && rez.grad != null && rez.otpad != null && rez.ulica != null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.idGrad.ToString() == (rez.grad) &&
                                           c.idVrsteOtpada.ToString() == (rez.otpad) && c.idUlice.ToString() == (rez.ulica)
                                           select c).ToListAsync();
                }
                //svi odabrani osim drugog
                else if (rez.dan != null && rez.grad == null && rez.otpad != null && rez.ulica != null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.danTjednaOdvoza.Equals(rez.dan) &&
                                           c.idVrsteOtpada.ToString() == (rez.otpad) && c.idUlice.ToString() == (rez.ulica)
                                           select c).ToListAsync();
                }
                //svi odabrani osim trećeg
                else if (rez.dan != null && rez.grad != null && rez.otpad == null && rez.ulica != null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.danTjednaOdvoza.Equals(rez.dan) &&
                                           c.idGrad.ToString() == (rez.grad) && c.idUlice.ToString() == (rez.ulica)
                                           select c).ToListAsync();
                }
                //svi odabrani osim četvrtog
                else if (rez.dan != null && rez.grad != null && rez.otpad != null && rez.ulica == null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.danTjednaOdvoza.Equals(rez.dan) &&
                                           c.idVrsteOtpada.ToString() == (rez.otpad) && c.idGrad.ToString() == (rez.grad)
                                           select c).ToListAsync();
                }
                //1 i 2 odabrani
                else if (rez.dan == null && rez.grad == null && rez.otpad != null && rez.ulica != null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.idVrsteOtpada.ToString() == (rez.otpad) &&
                                           c.idUlice.ToString() == (rez.ulica)
                                           select c).ToListAsync();
                }
                //1 i 3 odabrani
                else if (rez.dan == null && rez.grad != null && rez.otpad == null && rez.ulica != null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.idGrad.ToString() == (rez.grad) &&
                                           c.idUlice.ToString() == (rez.ulica)
                                           select c).ToListAsync();
                }
                //1 i 4 odabrani
                else if (rez.dan == null && rez.grad != null && rez.otpad != null && rez.ulica == null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.idGrad.ToString() == (rez.grad) &&
                                           c.idVrsteOtpada.ToString() == (rez.otpad)
                                           select c).ToListAsync();
                }
                //2 i 3 odabrani
                else if (rez.dan != null && rez.grad == null && rez.otpad == null && rez.ulica != null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.danTjednaOdvoza.Equals(rez.dan) &&
                                           c.idUlice.ToString() == (rez.ulica)
                                           select c).ToListAsync();
                }
                //2 i 4 odabrani
                else if (rez.dan != null && rez.grad == null && rez.otpad != null && rez.ulica == null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.danTjednaOdvoza.Equals(rez.dan) &&
                                           c.idVrsteOtpada.ToString() == (rez.otpad)
                                           select c).ToListAsync();
                }
                //3 i 4 odabrani
                else if (rez.dan != null && rez.grad != null && rez.otpad == null && rez.ulica == null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.danTjednaOdvoza.Equals(rez.dan) &&
                                           c.idGrad.ToString() == (rez.grad)
                                           select c).ToListAsync();
                }
                //1 odabran
                else if (rez.dan != null && rez.grad == null && rez.otpad == null && rez.ulica == null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.danTjednaOdvoza.Equals(rez.dan)
                                           select c).ToListAsync();
                }
                //2 odabran
                else if (rez.dan == null && rez.grad != null && rez.otpad == null && rez.ulica == null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.idGrad.ToString() == (rez.grad)
                                           select c).ToListAsync();
                }
                // 3 odabran
                else if (rez.dan == null && rez.grad == null && rez.otpad != null && rez.ulica == null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.idVrsteOtpada.ToString() == (rez.otpad)
                                           select c).ToListAsync();
                }
                //4 odabran
                else if (rez.dan == null && rez.grad == null && rez.otpad == null && rez.ulica != null)
                {
                    rasporedodvoza = await(from c in db.rasporedodvoza
                                           where c.idUlice.ToString() == (rez.ulica)
                                           select c).ToListAsync();
                }
                return(PartialView("~/Views/Administrator/RasporedOdvoza/RasporedOdvozaListPartial.cshtml", rasporedodvoza));
            }
        }
Exemplo n.º 3
0
        public void CreatePDF(FiltrirajPretraživanje rezultat)
        {
            Random r   = new Random();
            int    i   = r.Next(1, 100000000);
            string rnd = i.ToString();

            var exportFolder = Server.MapPath("~/PDF-s");
            var exportFile   = Path.Combine(exportFolder, rnd + ".pdf");

            var writer = new PdfWriter(exportFile);
            var pdf    = new PdfDocument(writer);
            var doc    = new Document(pdf);

            Table table = new Table(new float[10]).UseAllAvailableWidth();
            Cell  cell  = new Cell(1, 10).Add(new Paragraph("Kreirano: " + DateTime.Now.ToString()));

            cell.SetTextAlignment(TextAlignment.CENTER);
            cell.SetPadding(5);
            cell.SetBackgroundColor(new DeviceRgb(140, 200, 150));
            table.AddCell(cell);

            Table table3 = new Table(new float[10]).UseAllAvailableWidth();
            Cell  cell4  = new Cell(1, 10).SetBorder(Border.NO_BORDER).Add(new Paragraph(""));

            cell4.SetPadding(5);
            table3.AddCell(cell4);

            Table table2 = new Table(new float[10]).UseAllAvailableWidth();
            Cell  cell3  = new Cell(1, 10).Add(new Paragraph("Raspored odvoza otpada za trenutni tjedan"));

            cell3.SetTextAlignment(TextAlignment.CENTER);
            cell3.SetPadding(5);
            cell3.SetBackgroundColor(new DeviceRgb(140, 221, 8));
            table2.AddCell(cell3);

            Table table4 = new Table(new float[10]).UseAllAvailableWidth();

            table4.SetVerticalAlignment(VerticalAlignment.BOTTOM);
            Cell cell5 = new Cell(1, 10).Add(new Paragraph("Odvoz otpada d.d."));

            cell5.SetTextAlignment(TextAlignment.CENTER);
            cell5.SetPadding(5);
            cell5.SetBackgroundColor(new DeviceRgb(140, 221, 8));
            table4.AddCell(cell5);

            doc.Add(table4);
            doc.Add(table);
            doc.Add(table3);
            doc.Add(table2);

            doc.Add(CreateTable(PretragaRasporedaOdvoza(rezultat)));

            doc.Close();

            Response.ContentType = "application/pdf";
            Response.Clear();
            Response.AppendHeader("Content-Disposition", "attachment; filename=" + rnd + ".pdf");
            Response.AppendHeader("Content-Transfer-Encoding", "binary");
            Response.TransmitFile(Server.MapPath("~/PDF-s/" + rnd + ".pdf"));
            Response.End();

            if (System.IO.File.Exists(Server.MapPath("~/PDF-s/" + rnd + ".pdf")))
            {
                try
                {
                    System.IO.File.Delete(Server.MapPath("~/PDF-s/" + rnd + ".pdf"));
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }
        }
Exemplo n.º 4
0
        private List <rasporedodvoza> PretragaRasporedaOdvoza(FiltrirajPretraživanje rez)
        {
            if (rez.tekstPretraživanja != null)
            {
                List <rasporedodvoza> rasporedodvoza = new List <rasporedodvoza>();

                rasporedodvoza = (from c in db.rasporedodvoza
                                  where c.otpad.vrstaOtpad.Contains(rez.tekstPretraživanja) ||
                                  c.danTjednaOdvoza.Contains(rez.tekstPretraživanja) || c.ulica.imeUlica.Contains(rez.tekstPretraživanja) ||
                                  c.grad.imeGrad.Contains(rez.tekstPretraživanja) || c.vrijemeOdvoza.Contains(rez.tekstPretraživanja)
                                  select c).ToList();

                return(rasporedodvoza);
            }
            else
            {
                List <rasporedodvoza> rasporedodvoza = new List <rasporedodvoza>();

                //svi odabrani
                if (rez.dan != null && rez.grad != null && rez.otpad != null && rez.ulica != null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.idUlice.ToString() == (rez.ulica) && c.idGrad.ToString() == (rez.grad) &&
                                      c.idVrsteOtpada.ToString() == (rez.otpad) && c.danTjednaOdvoza.Equals(rez.dan)
                                      select c).ToList();
                }
                //nijedan odabran
                else if (rez.dan == null && rez.grad == null && rez.otpad == null && rez.ulica == null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza select c).ToList();
                }
                //svi odabrani osim prvog
                else if (rez.dan == null && rez.grad != null && rez.otpad != null && rez.ulica != null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.idGrad.ToString() == (rez.grad) &&
                                      c.idVrsteOtpada.ToString() == (rez.otpad) && c.idUlice.ToString() == (rez.ulica)
                                      select c).ToList();
                }
                //svi odabrani osim drugog
                else if (rez.dan != null && rez.grad == null && rez.otpad != null && rez.ulica != null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.danTjednaOdvoza.Equals(rez.dan) &&
                                      c.idVrsteOtpada.ToString() == (rez.otpad) && c.idUlice.ToString() == (rez.ulica)
                                      select c).ToList();
                }
                //svi odabrani osim trećeg
                else if (rez.dan != null && rez.grad != null && rez.otpad == null && rez.ulica != null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.danTjednaOdvoza.Equals(rez.dan) &&
                                      c.idGrad.ToString() == (rez.grad) && c.idUlice.ToString() == (rez.ulica)
                                      select c).ToList();
                }
                //svi odabrani osim četvrtog
                else if (rez.dan != null && rez.grad != null && rez.otpad != null && rez.ulica == null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.danTjednaOdvoza.Equals(rez.dan) &&
                                      c.idVrsteOtpada.ToString() == (rez.otpad) && c.idGrad.ToString() == (rez.grad)
                                      select c).ToList();
                }
                //1 i 2 odabrani
                else if (rez.dan == null && rez.grad == null && rez.otpad != null && rez.ulica != null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.idVrsteOtpada.ToString() == (rez.otpad) &&
                                      c.idUlice.ToString() == (rez.ulica)
                                      select c).ToList();
                }
                //1 i 3 odabrani
                else if (rez.dan == null && rez.grad != null && rez.otpad == null && rez.ulica != null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.idGrad.ToString() == (rez.grad) &&
                                      c.idUlice.ToString() == (rez.ulica)
                                      select c).ToList();
                }
                //1 i 4 odabrani
                else if (rez.dan == null && rez.grad != null && rez.otpad != null && rez.ulica == null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.idGrad.ToString() == (rez.grad) &&
                                      c.idVrsteOtpada.ToString() == (rez.otpad)
                                      select c).ToList();
                }
                //2 i 3 odabrani
                else if (rez.dan != null && rez.grad == null && rez.otpad == null && rez.ulica != null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.danTjednaOdvoza.Equals(rez.dan) &&
                                      c.idUlice.ToString() == (rez.ulica)
                                      select c).ToList();
                }
                //2 i 4 odabrani
                else if (rez.dan != null && rez.grad == null && rez.otpad != null && rez.ulica == null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.danTjednaOdvoza.Equals(rez.dan) &&
                                      c.idVrsteOtpada.ToString() == (rez.otpad)
                                      select c).ToList();
                }
                //3 i 4 odabrani
                else if (rez.dan != null && rez.grad != null && rez.otpad == null && rez.ulica == null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.danTjednaOdvoza.Equals(rez.dan) &&
                                      c.idGrad.ToString() == (rez.grad)
                                      select c).ToList();
                }
                //1 odabran
                else if (rez.dan != null && rez.grad == null && rez.otpad == null && rez.ulica == null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.danTjednaOdvoza.Equals(rez.dan)
                                      select c).ToList();
                }
                //2 odabran
                else if (rez.dan == null && rez.grad != null && rez.otpad == null && rez.ulica == null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.idGrad.ToString() == (rez.grad)
                                      select c).ToList();
                }
                // 3 odabran
                else if (rez.dan == null && rez.grad == null && rez.otpad != null && rez.ulica == null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.idVrsteOtpada.ToString() == (rez.otpad)
                                      select c).ToList();
                }
                //4 odabran
                else if (rez.dan == null && rez.grad == null && rez.otpad == null && rez.ulica != null)
                {
                    rasporedodvoza = (from c in db.rasporedodvoza
                                      where c.idUlice.ToString() == (rez.ulica)
                                      select c).ToList();
                }
                return(rasporedodvoza);
            }
        }