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));
}
