private void BindBikes()
{
string conn = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
string query = "SELECT * FROM Bike WHERE Availability = '1'";
if (Session["category"].ToString() != "0")
{
query += " AND Category='" + Session["category"] + "' ";
}
//if (Session["searchItem"].ToString() != null)
//{
// query += " AND AdsHeader='"+'%' + Session["searchItem"] + '%'+"' ";
// Session["searchItem"] = "";
//}
query += " order by AddingDate DESC ";
using (SqlConnection con = new SqlConnection(conn))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
RepBikes.DataSource = dt;
RepBikes.DataBind();
}
}
}
}
protected void sortBikes_Click(object sender, EventArgs e)
{
string empty = "0";
string querySelect = "SELECT * FROM Bike";
string queryWhere = " WHERE Availability=1";
string query = querySelect + queryWhere;
if (Session["category"].ToString() != empty)
{
query += " AND Category='" + Session["category"] + "' ";
}
if (ilBike.SelectedValue != empty)
{
query += " AND BikeCity='" + ilBike.SelectedValue + "' ";
}
if (ilceBike.SelectedValue != empty)
{
query += " AND BikeCounty='" + ilceBike.SelectedValue + "' ";
}
if (vites.SelectedValue != empty)
{
query += " AND Transmission='" + vites.SelectedValue + "' ";
}
if (minPrice.Text != "")
{
float minPriceInt = float.Parse(minPrice.Text, System.Globalization.CultureInfo.InvariantCulture);
query += " AND Price>=" + minPriceInt + " ";
}
if (maxPrice.Text != "")
{
float maxPriceInt = float.Parse(maxPrice.Text, System.Globalization.CultureInfo.InvariantCulture);
query += " AND Price<=" + maxPriceInt + " ";
}
query += " order by AddingDate DESC ";
string conn = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(conn))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
RepBikes.DataSource = dt;
RepBikes.DataBind();
}
}
}
}
private void BindBikes()
{
string conn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
using (SqlConnection con = new SqlConnection(conn))
{
using (SqlCommand cmd = new SqlCommand("select * from Bike WHERE Availability='1'", con))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
RepBikes.DataSource = dt;
RepBikes.DataBind();
}
}
}
}
