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