public List <Customer> GetAllCustomers() { List <Customer> results = null; //string connectionString = Configuration.GetConnectionString("DefaultConnection"); try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "Select * from customers"; SqlCommand cmd = new SqlCommand(query, cn); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { if (results == null) { results = new List <Customer>(); } Customer member = new Customer(); member.id = (int)dr["id"]; member.username = (string)dr["username"]; member.password = (string)dr["password"]; member.full_name = (string)dr["full_name"]; if (dr["address"] != null) { member.address = (string)dr["address"]; } // Voir si modifications souhaitées CitiesDB citiesDB = new CitiesDB(configuration); member.city = citiesDB.GetCityById((int)dr["fk_cities"]); results.Add(member); } } } } catch (Exception e) { throw e; } return(results); }
public Customer CheckAuthentication(string user, string password) { Customer result = null; //string connectionString = Configuration.GetConnectionString("DefaultConnection"); try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "Select * from customers where username=@user and password=@password"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@user", user); cmd.Parameters.AddWithValue("@password", password); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { if (result == null) { result = new Customer(); } result.id = (int)dr["id"]; result.username = (string)dr["username"]; result.password = (string)dr["password"]; result.full_name = (string)dr["full_name"]; if (dr["address"] != null) { result.address = (string)dr["address"]; } // Voir si modifications souhaitées CitiesDB citiesDB = new CitiesDB(configuration); result.city = citiesDB.GetCityById((int)dr["fk_cities"]); } } } } catch (Exception e) { throw e; } return(result); }
public Deliverer GetDelivererById(int id) { Deliverer result = null; //string connectionString = Configuration.GetConnectionString("DefaultConnection"); try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "Select * from deliverers where id=@id"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@id", id); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { if (result == null) { result = new Deliverer(); } result.id = (int)dr["id"]; result.username = (string)dr["username"]; result.password = (string)dr["password"]; result.full_name = (string)dr["full_name"]; // Voir si modifications souhaitées CitiesDB citiesDB = new CitiesDB(configuration); result.city = citiesDB.GetCityById((int)dr["fk_cities"]); } } } } catch (Exception e) { throw e; } return(result); }
public List <Restaurant> GetAllRestaurants() { List <Restaurant> results = null; try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "Select * from restaurants order by merchant_name"; SqlCommand cmd = new SqlCommand(query, cn); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { if (results == null) { results = new List <Restaurant>(); } Restaurant member = new Restaurant(); member.id = (int)dr["id"]; member.merchant_name = (string)dr["merchant_name"]; // Voir si modifications souhaitées CitiesDB citiesDB = new CitiesDB(configuration); member.city = citiesDB.GetCityById((int)dr["fk_cities"]); results.Add(member); } } } } catch (Exception e) { throw e; } return(results); }
public Restaurant GetRestaurantById(int id) { Restaurant result = null; try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "Select * from restaurants where id=@id"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@id", id); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { if (result == null) { result = new Restaurant(); } result.id = (int)dr["id"]; result.merchant_name = (string)dr["merchant_name"]; // Voir si modifications souhaitées CitiesDB citiesDB = new CitiesDB(configuration); result.city = citiesDB.GetCityById((int)dr["fk_cities"]); } } } } catch (Exception e) { throw e; } return(result); }