public static List<Organization> getUserOrganizations(int user_id) { List<Organization> organizations = new List<Organization>(); SqlConnection konekcija = getConnection(); string sqlString = "SELECT DISTINCT o.* FROM Organizations o, URO uro WHERE uro.user_id=@user_id and o.organization_id=uro.organization_id"; SqlCommand komanda = new SqlCommand(sqlString, konekcija); komanda.Parameters.AddWithValue("@user_id", user_id); try { konekcija.Open(); SqlDataReader citac = komanda.ExecuteReader(); while (citac.Read()) { Organization o = new Organization(int.Parse(citac[0].ToString()), citac[1].ToString()); organizations.Add(o); } } catch (Exception err) { Console.Write(err.ToString()); } finally { konekcija.Close(); } return organizations; }
public static List<Organization> getOrganizations() { List<Organization> organizations = new List<Organization>(); SqlConnection konekcija = getConnection(); string sqlString = "SELECT * FROM Organizations"; SqlCommand komanda = new SqlCommand(sqlString, konekcija); try { konekcija.Open(); SqlDataReader citac = komanda.ExecuteReader(); while (citac.Read()) { Organization o = new Organization(int.Parse(citac[0].ToString()), citac[1].ToString()); organizations.Add(o); } } catch (Exception err) { Console.Write(err.ToString()); } finally { konekcija.Close(); } return organizations; }