public ActionResult Poruke(PorukeModel porukaModel) { porukaModel.poruka.vrijemeSlanja = DateTime.Now.TimeOfDay; var pom = porukaModel.poruka.idPosiljaoca; porukaModel.poruka.idPosiljaoca = Convert.ToInt32(Session["id"]); porukaModel.poruka.idPrimaoca = pom; porukaModel.poruka.procitana = 0; string constr = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString; SqlConnection sqlcon = new SqlConnection(constr); if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("dodajPoruku", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@idPrimaoca", Convert.ToInt32(porukaModel.poruka.idPrimaoca)); sqlcmd.Parameters.AddWithValue("@idPosiljaoca", Convert.ToInt32(Session["id"])); sqlcmd.Parameters.AddWithValue("@tekst", porukaModel.poruka.sadrzaj); sqlcmd.Parameters.AddWithValue("@procitana", 0); sqlcmd.Parameters.AddWithValue("@vrijeme", porukaModel.poruka.vrijemeSlanja); sqlcmd.ExecuteNonQuery(); porukaModel.listaZaCitanje.Add(porukaModel.poruka); return(RedirectToAction("Poruke/" + porukaModel.poruka.idPrimaoca, "Korisnik")); }
public ActionResult Poruke(int id) { PorukeModel porukeModel = new PorukeModel(); List <poruke> listaPoruka = new List <poruke>(); List <int> listaIntova = new List <int>(); List <Korisnik> listaKorisnika = new List <Korisnik>(); List <poruke> listaZaCitanje = new List <poruke>(); poruke Poruka = new poruke(); Poruka.idPrimaoca = Convert.ToInt32(Session["id"]); Poruka.idPosiljaoca = Convert.ToInt32(id); string constr = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString; SqlConnection sqlcon = new SqlConnection(constr); if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd4 = new SqlCommand("procitajPoruku", sqlcon); sqlcmd4.CommandType = CommandType.StoredProcedure; sqlcmd4.Parameters.AddWithValue("@idPosiljaoca", Poruka.idPosiljaoca); sqlcmd4.Parameters.AddWithValue("@idPrimaoca", Poruka.idPrimaoca); sqlcmd4.ExecuteNonQuery(); SqlCommand sqlcmd5 = new SqlCommand("ukupnoNeprocitanih", sqlcon); sqlcmd5.CommandType = CommandType.StoredProcedure; sqlcmd5.Parameters.AddWithValue("@id", Convert.ToInt32(Session["id"])); SqlDataReader rd = sqlcmd5.ExecuteReader(); if (rd.HasRows) { rd.Read(); var brojUkupnoNeprocitanih2 = rd.GetInt32(0); Session["brojUkupnoNeprocitanih"] = brojUkupnoNeprocitanih2; } SqlCommand sqlcmd3 = new SqlCommand("ukupnoNeprocitanih", sqlcon); sqlcmd3.CommandType = CommandType.StoredProcedure; sqlcmd3.Parameters.AddWithValue("@id", Convert.ToInt32(Session["id"])); int brojUkupnoNeprocitanih = sqlcmd3.ExecuteNonQuery(); SqlCommand sqlcmd = new SqlCommand("selectMojePoruke", sqlcon); SqlDataReader reader; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@id", Convert.ToInt32(Session["id"])); reader = sqlcmd.ExecuteReader(); while (reader.Read()) { poruke porukeM = new poruke(); porukeM.idPoruke = reader.GetInt32(0); porukeM.idPosiljaoca = reader.GetInt32(1); porukeM.idPrimaoca = reader.GetInt32(2); porukeM.procitana = reader.GetByte(3); porukeM.sadrzaj = reader.GetString(4); porukeM.vrijemeSlanja = reader.GetTimeSpan(5); if (!listaIntova.Contains(porukeM.idPosiljaoca)) { listaIntova.Add(porukeM.idPosiljaoca); Korisnik korisnikModel = new Korisnik(); SqlCommand sqlcmd2 = new SqlCommand("getPodaciKorisnika", sqlcon); SqlDataReader reader2; sqlcmd2.CommandType = CommandType.StoredProcedure; sqlcmd2.Parameters.AddWithValue("@id", porukeM.idPosiljaoca); reader2 = sqlcmd2.ExecuteReader(); while (reader2.Read()) { korisnikModel.id = reader2.GetInt32(0); korisnikModel.ime = reader2.GetString(1); korisnikModel.prezime = reader2.GetString(2); korisnikModel.email = reader2.GetString(3); korisnikModel.profilna = reader2.GetString(7); if (!reader2.IsDBNull(8)) { korisnikModel.mjestoStanovanja = reader2.GetString(8); } if (!reader2.IsDBNull(9)) { korisnikModel.brojTelefona = reader2.GetString(9); } listaKorisnika.Add(korisnikModel); } } listaPoruka.Add(porukeM); } if (id == Convert.ToInt32(Session["id"])) { } else { sqlcmd = new SqlCommand("selectPoruke", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@idPrimaoca", Convert.ToInt32(Session["id"])); sqlcmd.Parameters.AddWithValue("@idPosiljaoca", id); reader = sqlcmd.ExecuteReader(); while (reader.Read()) { poruke porukeM = new poruke(); porukeM.idPoruke = reader.GetInt32(0); porukeM.idPosiljaoca = reader.GetInt32(1); porukeM.idPrimaoca = reader.GetInt32(2); porukeM.procitana = reader.GetByte(3); porukeM.sadrzaj = reader.GetString(4); porukeM.vrijemeSlanja = reader.GetTimeSpan(5); listaZaCitanje.Add(porukeM); } } porukeModel.listaPoruka = listaPoruka; porukeModel.poruka = Poruka; porukeModel.brojNeprocitanih = brojUkupnoNeprocitanih; //Session["brojUkupnoNeprocitanih"] = brojUkupnoNeprocitanih; porukeModel.listaZaCitanje = listaZaCitanje; porukeModel.listaKorisnika = listaKorisnika; return(View(porukeModel)); }