public TecajModel GetTecaj(int IdTecaj)
{
TecajModel tecaj = new TecajModel();
using (SqlConnection conn = new SqlConnection(conString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "DohvatiTecaj";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("IdTecaj", IdTecaj);
//md.Parameters["IdTecaj"].Value = IdTecaj;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
tecaj.IdTecaj = int.Parse(reader["IdTecaj"].ToString());
tecaj.Naziv = reader["Naziv"].ToString();
tecaj.Opis = reader["Opis"].ToString();
}
}
return(tecaj);
}
}
public List <TecajModel> GetTecaje()
{
List <TecajModel> tecajevi = new List <TecajModel>();
using (SqlConnection conn = new SqlConnection(conString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "DohvatiTecajeve";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
TecajModel tecaj = new TecajModel();
tecaj.IdTecaj = int.Parse(reader["IdTecaj"].ToString());
tecaj.Naziv = reader["Naziv"].ToString();
tecaj.Opis = reader["Opis"].ToString();
tecajevi.Add(tecaj);
}
}
}
return(tecajevi);
}
public ActionResult Edit()
{
int ID = int.Parse(Request.QueryString["id"]);
TecajModel tecaj = repo.GetTecaj(ID);
return(View(tecaj));
}
public static TecajModel DohvatiTecaj(int idTecaj)
{
ds = SqlHelper.ExecuteDataset(cs, "DohvatiTecaj", idTecaj);
DataRow row = ds.Tables[0].Rows[0];
TecajModel tecaj = new TecajModel();
tecaj.IdTecaj = (int)row["IdTecaj"];
tecaj.Naziv = row["Naziv"].ToString();
tecaj.Opis = row["Opis"].ToString();
return(tecaj);
}
public static List <TecajModel> DohvatiTecajeve()
{
List <TecajModel> kolekcija = new List <TecajModel>();
ds = SqlHelper.ExecuteDataset(cs, "DohvatiTecajeve");
foreach (DataRow row in ds.Tables[0].Rows)
{
TecajModel tecaj = new TecajModel();
tecaj.IdTecaj = (int)row["IdTecaj"];
tecaj.Naziv = row["Naziv"].ToString();
tecaj.Opis = row["Opis"].ToString();
kolekcija.Add(tecaj);
}
return(kolekcija);
}
public void UrediTecaj(TecajModel tecaj)
{
using (SqlConnection conn = new SqlConnection(conString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "UrediTecaj";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("IdTecaj", tecaj.IdTecaj);
//cmd.Parameters["IdTecaj"].Value = tecaj.IdTecaj;
cmd.Parameters.AddWithValue("Naziv", tecaj.Naziv);
//cmd.Parameters["Naziv"].Value = tecaj.Naziv;
cmd.Parameters.AddWithValue("Opis", tecaj.Opis);
//cmd.Parameters["Opis"].Value = tecaj.Opis;
cmd.ExecuteNonQuery();
}
}
public ActionResult Edit(TecajModel tecaj)
{
repo.UrediTecaj(tecaj);
return(RedirectToAction("List"));
}
public ActionResult Create(TecajModel tecaj)
{
repo.KreirajTecaj(tecaj);
return(RedirectToAction("List"));
}
public static object KreirajTecaj(TecajModel tecaj)
{
var id = SqlHelper.ExecuteScalar(cs, "KreirajTecaj", tecaj.Naziv, tecaj.Opis);
return(id);
}
public static void UrediTecaj(TecajModel tecaj)
{
SqlHelper.ExecuteNonQuery(cs, "UrediTecaj", tecaj.IdTecaj, tecaj.Naziv, tecaj.Opis);
}
