public static List<User> getUsersByOrganization(int organization_id) { List<User> users = new List<User>(); SqlConnection konekcija = getConnection(); string sqlString = "SELECT * FROM Users WHERE organization_id=@organization_id and is_active=1"; SqlCommand komanda = new SqlCommand(sqlString, konekcija); komanda.Parameters.AddWithValue("@organization_id", organization_id); try { konekcija.Open(); SqlDataReader citac = komanda.ExecuteReader(); while (citac.Read()) { User u = new User(); u.user_id = int.Parse(citac["user_id"].ToString()); u.first_name = citac["first_name"].ToString(); u.last_name = citac["last_name"].ToString(); u.organization_id = int.Parse(citac["organization_id"].ToString()); users.Add(u); } } catch (Exception err) { Console.Write(err.ToString()); } finally { konekcija.Close(); } return users; }
public static User authenticateUser(string username, string password) { SqlConnection konekcija = getConnection(); string sqlString = "SELECT * FROM Users WHERE username=@username AND password=@password AND is_active = 1"; SqlCommand komanda = new SqlCommand(sqlString, konekcija); komanda.Parameters.AddWithValue("@username", username); komanda.Parameters.AddWithValue("@password", password); try { konekcija.Open(); SqlDataReader citac = komanda.ExecuteReader(); if (citac.Read()) { User u = new User(); u.user_id = int.Parse(citac["user_id"].ToString()); u.first_name = citac["first_name"].ToString(); u.last_name = citac["last_name"].ToString(); u.organization_id = int.Parse(citac["organization_id"].ToString()); return u; } else return null; } catch (Exception err) { Console.Write(err.ToString()); } finally { konekcija.Close(); } return null; }
public static User getUserByID(int id) { SqlConnection konekcija = getConnection(); string sqlString = "SELECT u.*, o.organization_name FROM Users u, Organizations o WHERE u.user_id=@user_id AND u.organization_id=o.organization_id"; SqlCommand komanda = new SqlCommand(sqlString, konekcija); komanda.Parameters.AddWithValue("@user_id", id); try { konekcija.Open(); SqlDataReader citac = komanda.ExecuteReader(); if (citac.Read()) { User u = new User(); u.user_id = int.Parse(citac["user_id"].ToString()); u.first_name = citac["first_name"].ToString(); u.last_name = citac["last_name"].ToString(); u.username = citac["username"].ToString(); u.gender = Convert.ToBoolean(citac["gender"].ToString()); u.birth_date = Convert.ToDateTime(citac["birth_date"].ToString()); u.organization_id = int.Parse(citac["organization_id"].ToString()); u.organization_name = citac["organization_name"].ToString(); u.join_date = Convert.ToDateTime(citac["join_date"].ToString()); u.location = citac["location"].ToString(); u.address = citac["address"].ToString(); u.phone = citac["phone"].ToString(); u.email = citac["email"].ToString(); u.image_path = citac["image_path"].ToString(); return u; } else return null; } catch (Exception err) { Console.Write(err.ToString()); } finally { konekcija.Close(); } return null; }
public static List<User> getAllUsers() { List<User> users = new List<User>(); SqlConnection konekcija = getConnection(); string sqlString = "SELECT u.*, o.organization_name FROM Users u, Organizations o WHERE o.organization_id = u.organization_id"; SqlCommand komanda = new SqlCommand(sqlString, konekcija); try { konekcija.Open(); SqlDataReader citac = komanda.ExecuteReader(); while (citac.Read()) { User u = new User(); u.user_id = int.Parse(citac["user_id"].ToString()); u.first_name = citac["first_name"].ToString(); u.last_name = citac["last_name"].ToString(); u.organization_name = citac["organization_name"].ToString(); users.Add(u); } } catch (Exception err) { Console.Write(err.ToString()); } finally { konekcija.Close(); } return users; }