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;
}