//Author: Jesper
public List <Eyewear> GetEyewear(string sex, string shape, string color, int length, double fromPrice, double toPrice)
{
Sql_Connection sqlCon = new Sql_Connection();
sqlCon.PrepareSql($"select * from frame f join product p on f.ProductId = p.ProductId " +
$"where sex like '%{sex}%' " +
$"and shape like '%{shape}%' " +
$"and color like '%{color}%' " +
$"and length between {length-10} and {length+10} " +
$"and price between {fromPrice} and {toPrice}");
List <Eyewear> EyewearList = new List <Eyewear>();
SqlDataReader sqld = sqlCon.ReadData();
if (sqld.HasRows)
{
while (sqld.Read())
{
EyewearList.Add(new Eyewear(
sqld["sex"].ToString(),
sqld["shape"].ToString(),
sqld["color"].ToString(),
Convert.ToInt32(sqld["length"]),
sqld["manufactor"].ToString(),
sqld["modelName"].ToString(),
Convert.ToDouble(sqld["price"])
));
}
}
sqlCon.CloseConnection();
return(EyewearList);
}
public DataTable GridGetFrameSpec(int productID)
{
Sql_Connection sqlCon = new Sql_Connection();
sda = new SqlDataAdapter($"Select * from Frame WHERE productID = {productID}", sqlCon.Connection());
dt = new DataTable();
sda.Fill(dt);
return(dt);
}
public List <string> GetDistinctFromFrame(string column)
{
Sql_Connection sqlCon = new Sql_Connection();
sqlCon.PrepareSql($"SELECT DISTINCT {column} FROM frame");
List <string> list = new List <string>();
SqlDataReader sqld = sqlCon.ReadData();
if (sqld.HasRows)
{
while (sqld.Read())
{
list.Add(sqld[0].ToString());
}
}
sqlCon.CloseConnection();
return(list);
}
