public PolaznikModel(bool isSingle)
{
if (isSingle)
{
this.lstGradovi = new List <GradModel>();
string conString = ConfigurationManager.ConnectionStrings["sqlConnString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(conString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM tblGradovi";
cmd.Connection.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
GradModel grad = new GradModel
{
IdGrad = int.Parse(reader["IdGrada"].ToString()),
Naziv = reader["Naziv"].ToString(),
IdDrzava = int.Parse(reader["IdDrzave"].ToString())
};
this.lstGradovi.Add(grad);
}
}
}
}
}
public string ImeGrad()
{
string ime;
GradModel obj = this.lstGradovi.Where(grad => grad.IdGrad == this.IdGrad).SingleOrDefault();
if (obj != null)
{
ime = obj.Naziv;
}
else
{
ime = "";
}
return(ime);
}