private int GetIdByTitle(string title)
{
SqlConnection connection = Library.Connection.Instance();
string queryString = "SELECT id FROM dbo.category WHERE title='"+title+"';";
SqlCommand command = new SqlCommand(queryString, connection);
SqlDataReader reader = command.ExecuteReader();
int id = 0;
while (reader.Read())
{
id = (int)reader["id"];
break;
}
reader.Close();
return id;
}