コード例 #1
0
        public ActionResult Dojam(dojmovi Dojam)
        {
            Dojam.idPosiljaoca = Convert.ToInt32(Session["id"]);
            string        constr = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;
            SqlConnection sqlcon = new SqlConnection(constr);

            if (sqlcon.State == ConnectionState.Closed)
            {
                sqlcon.Open();
            }
            //return RedirectToAction(Dojam.idPrimaoca.ToString(), "Korisnik");
            SqlCommand sqlcmd = new SqlCommand("dodajDojam", sqlcon);

            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.AddWithValue("@idPosiljaoca", Dojam.idPosiljaoca);
            sqlcmd.Parameters.AddWithValue("@idPrimaoca", Dojam.idPrimaoca);
            sqlcmd.Parameters.AddWithValue("@dojam", Dojam.dojam);
            sqlcmd.ExecuteNonQuery();
            sqlcon.Close();
            return(RedirectToAction("Profil/" + Dojam.idPrimaoca.ToString(), "Korisnik"));
        }
コード例 #2
0
        public ActionResult Profil(int id)
        {
            Korisnik       korisnikModel = new Korisnik();
            List <dojmovi> listaDojmova  = new List <dojmovi>();
            List <rute>    listaRuta     = new List <rute>();

            string        constr = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;
            SqlConnection sqlcon = new SqlConnection(constr);

            if (sqlcon.State == ConnectionState.Closed)
            {
                sqlcon.Open();
            }
            SqlCommand    sqlcmd = new SqlCommand("getPodaciKorisnika", sqlcon);
            SqlDataReader reader;

            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.AddWithValue("@id", id);
            reader = sqlcmd.ExecuteReader();

            while (reader.Read())
            {
                korisnikModel.id       = reader.GetInt32(0);
                korisnikModel.ime      = reader.GetString(1);
                korisnikModel.prezime  = reader.GetString(2);
                korisnikModel.email    = reader.GetString(3);
                korisnikModel.profilna = reader.GetString(7);
                if (!reader.IsDBNull(8))
                {
                    korisnikModel.mjestoStanovanja = reader.GetString(8);
                }
                if (!reader.IsDBNull(9))
                {
                    korisnikModel.brojTelefona = reader.GetString(9);
                }
            }
            reader.Close();

            sqlcmd             = new SqlCommand("selectRute", sqlcon);
            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.AddWithValue("@id", id);
            reader = sqlcmd.ExecuteReader();

            while (reader.Read())
            {
                rute ruteModel = new rute();
                ruteModel.idRute        = reader.GetInt32(0);
                ruteModel.polaziste     = reader.GetString(2);
                ruteModel.odrediste     = reader.GetString(3);
                ruteModel.datum         = reader.GetDateTime(4);
                ruteModel.vrijeme       = reader.GetTimeSpan(5);
                ruteModel.drzava        = reader.GetString(6);
                ruteModel.nacinPlacanja = reader.GetString(7);
                listaRuta.Add(ruteModel);
            }
            reader.Close();

            sqlcmd             = new SqlCommand("selectDojmove", sqlcon);
            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.AddWithValue("@id", korisnikModel.id);
            reader = sqlcmd.ExecuteReader();
            while (reader.Read())
            {
                dojmovi dojamModel = new dojmovi();
                dojamModel.idPosiljaoca = reader.GetInt32(1);
                dojamModel.idPrimaoca   = reader.GetInt32(2);
                dojamModel.dojam        = reader.GetString(3);
                //reader.Close();
                SqlCommand    sqlcmd2 = new SqlCommand("getPodaciKorisnika", sqlcon);
                SqlDataReader reader2;
                sqlcmd2.CommandType = CommandType.StoredProcedure;
                sqlcmd2.Parameters.AddWithValue("@id", reader.GetInt32(1));
                reader2 = sqlcmd2.ExecuteReader();

                while (reader2.Read())
                {
                    dojamModel.imePosiljaoca      = reader2.GetString(1);
                    dojamModel.profilnaPosiljaoca = reader2.GetString(7);
                }
                reader2.Close();
                listaDojmova.Add(dojamModel);
            }
            sqlcon.Close();

            ProfilModel profilModel = new ProfilModel();
            dojmovi     Dojam       = new dojmovi();

            profilModel.Dojam        = Dojam;
            profilModel.Korisnik     = korisnikModel;
            profilModel.ListaDojmova = listaDojmova;
            profilModel.ListaRuta    = listaRuta;
            return(View(profilModel));
        }