public static void AddToDb(SqlConnection connectionStr, Zaposlenik zaposlenik)
{
string name = zaposlenik.Name;
int age = zaposlenik.Age;
int id = 0;
using (connectionStr)
{
SqlCommand command = new SqlCommand(
"SELECT id FROM users;",
connectionStr);
connectionStr.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
id = reader.GetInt32(0);
}
}
id = id + 1;
reader.Close();
string queryString =
$"Insert into users values ({id},'{name}',{age});";
SqlDataAdapter adapter = new SqlDataAdapter(queryString, connectionStr);
DataSet newZaposlenik = new DataSet();
adapter.Fill(newZaposlenik, "users");
}
connectionStr.Close();
return;
}
public List <Zaposlenik> HasRows(SqlConnection connectionStr)
{
string name = "";
int age = 0;
Zaposlenik zaposlenik;
using (connectionStr)
{
SqlCommand command = new SqlCommand(
"SELECT username, age FROM users;",
connectionStr);
connectionStr.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
name = reader.GetString(0);
age = reader.GetInt32(1);
zaposlenik = new Zaposlenik(name, age);
popis.Add(zaposlenik);
}
}
reader.Close();
connectionStr.Close();
}
return(popis);
}
