protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
all.BackColor = Color.FromArgb(0xbc5b51);
all.ForeColor = Color.White;
User user = Session["LoginUser"] as User;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
conn.Open();
string query = @"select * from products where ArtistID = @id ";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("id", user.ID);
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
ProductGalleryDataList.DataSource = dt;
ProductGalleryDataList.DataBind();
ViewState["PagedDataSurce"] = dt;
DataListPaging(dt);
}
ViewState["PageCount"] = 0;
}
}
CurrentPage = (int)ViewState["PageCount"];
}
protected void ddlSortBy_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string tabValue = "";
if (Request.Cookies["tab"] != null)
{
tabValue = Request.Cookies["tab"].Value;
}
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
conn.Open();
string query = @"select * from products where Quantity >= 1 and IsActive = 1 ";
var sortValue = "";
query += tabValue;
if (ddlSortBy.SelectedValue == "New Arrived")
{
sortValue += @"ORDER BY ReleasedDate DESC";
}
else if (ddlSortBy.SelectedValue == "Name : A to Z")
{
sortValue += @"ORDER BY ProductName";
}
else if (ddlSortBy.SelectedValue == "Name : Z to A")
{
sortValue += @"ORDER BY ProductName DESC";
}
else if (ddlSortBy.SelectedValue == "Price: Cheap to Expensive")
{
sortValue += @"ORDER BY ProductPrice";
}
else
{
sortValue += @"ORDER BY ProductPrice DESC";
}
query += sortValue;
SqlCommand cmd = new SqlCommand(query, conn);
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
ProductGalleryDataList.DataSource = dt;
ProductGalleryDataList.DataBind();
CurrentPage = 0;
ViewState["PageCount"] = 0;
ViewState["PagedDataSurce"] = dt;
DataListPaging(dt);
}
HttpCookie sortCookies = new HttpCookie("sort");
sortCookies.Value = sortValue;
Response.Cookies.Add(sortCookies);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
all.BackColor = Color.FromArgb(0xBC4639);
all.ForeColor = Color.White;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
conn.Open();
string query = @"select * from products where Quantity >= 1 and IsActive = 1";
SqlCommand cmd = new SqlCommand(query, conn);
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
ProductGalleryDataList.DataSource = dt;
ProductGalleryDataList.DataBind();
ViewState["PagedDataSurce"] = dt;
DataListPaging(dt);
}
ViewState["PageCount"] = 0;
}
}
CurrentPage = (int)ViewState["PageCount"];
}
private void DataListPaging(DataTable dt)
{
PagedDataSource PD = new PagedDataSource();
PD.DataSource = dt.DefaultView;
PD.PageSize = 12;
PD.AllowPaging = true;
PD.CurrentPageIndex = CurrentPage;
Button1.Enabled = !PD.IsFirstPage;
Button2.Enabled = !PD.IsFirstPage;
Button4.Enabled = !PD.IsLastPage;
Button3.Enabled = !PD.IsLastPage;
ViewState["TotalCount"] = PD.PageCount;
ProductGalleryDataList.DataSource = PD;
ProductGalleryDataList.DataBind();
ViewState["PagedDataSurce"] = dt;
}
protected void status_Click(object sender, EventArgs e)
{
try
{
string value = "ORDER BY ReleasedDate";
if (Request.Cookies["sort"] != null)
{
value = Request.Cookies["sort"].Value;
}
all.BackColor = Color.FromArgb(0xF3E0DC);
all.ForeColor = Color.Black;
instock.BackColor = Color.FromArgb(0xF3E0DC);
instock.ForeColor = Color.Black;
soldout.BackColor = Color.FromArgb(0xF3E0DC);
soldout.ForeColor = Color.Black;
inactive.BackColor = Color.FromArgb(0xF3E0DC);
inactive.ForeColor = Color.Black;
Button btn = sender as Button;
btn.BackColor = Color.FromArgb(0xbc5b51);
btn.ForeColor = Color.White;
string tab = "";
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
User user = Session["LoginUser"] as User;
conn.Open();
string query = @"select * from products where ArtistID = @id ";
if (btn.Text == "Show All")
{
query += "";
}
else if (btn.Text == "In Stock")
{
tab = @"and Quantity >= 1 and IsActive = 1 ";
}
else if (btn.Text == "Sold Out")
{
tab = @"and Quantity = 0 and IsActive = 1 ";
}
else if (btn.Text == "Inactive")
{
tab = @"and IsActive = 0 ";
}
query += tab;
query += value;
HttpCookie tabCookies = new HttpCookie("tab");
tabCookies.Value = tab;
Response.Cookies.Add(tabCookies);
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("id", user.ID);
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
ProductGalleryDataList.DataSource = dt;
ProductGalleryDataList.DataBind();
CurrentPage = 0;
ViewState["PageCount"] = 0;
ViewState["PagedDataSurce"] = dt;
DataListPaging(dt);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Category_Click(object sender, EventArgs e)
{
try
{
string value = "ORDER BY ReleasedDate";
if (Request.Cookies["sort"] != null)
{
value = Request.Cookies["sort"].Value;
}
all.BackColor = Color.FromArgb(0xD4A59A);
all.ForeColor = Color.White;
paintingTab.BackColor = Color.FromArgb(0xD4A59A);
paintingTab.ForeColor = Color.White;
oilpaint.BackColor = Color.FromArgb(0xD4A59A);
oilpaint.ForeColor = Color.White;
arcylirpaint.BackColor = Color.FromArgb(0xD4A59A);
arcylirpaint.ForeColor = Color.White;
watercolor.BackColor = Color.FromArgb(0xD4A59A);
watercolor.ForeColor = Color.White;
sculptureTab.BackColor = Color.FromArgb(0xD4A59A);
sculptureTab.ForeColor = Color.White;
animals.BackColor = Color.FromArgb(0xD4A59A);
animals.ForeColor = Color.White;
bronzo.BackColor = Color.FromArgb(0xD4A59A);
bronzo.ForeColor = Color.White;
wood.BackColor = Color.FromArgb(0xD4A59A);
wood.ForeColor = Color.White;
Button btn = sender as Button;
if (btn.Text == "All")
{
all.BackColor = Color.FromArgb(0xBC4639);
all.ForeColor = Color.White;
}
else if (btn.Text == "Oil Paint" || btn.Text == "Arcylir Paint" || btn.Text == "Water Color")
{
paintingTab.BackColor = Color.FromArgb(0xBC4639);
paintingTab.ForeColor = Color.White;
if (btn.Text == "Oil Paint")
{
oilpaint.BackColor = Color.FromArgb(0xBC4639);
oilpaint.ForeColor = Color.White;
}
else if (btn.Text == "Arcylir Paint")
{
arcylirpaint.BackColor = Color.FromArgb(0xBC4639);
arcylirpaint.ForeColor = Color.White;
}
else if (btn.Text == "Water Color")
{
watercolor.BackColor = Color.FromArgb(0xBC4639);
watercolor.ForeColor = Color.White;
}
}
else if (btn.Text == "Animals" || btn.Text == "Bronzo" || btn.Text == "Wood")
{
sculptureTab.BackColor = Color.FromArgb(0xBC4639);
sculptureTab.ForeColor = Color.White;
if (btn.Text == "Animals")
{
animals.BackColor = Color.FromArgb(0xBC4639);
animals.ForeColor = Color.White;
}
else if (btn.Text == "Bronzo")
{
bronzo.BackColor = Color.FromArgb(0xBC4639);
bronzo.ForeColor = Color.White;
}
else if (btn.Text == "Wood")
{
wood.BackColor = Color.FromArgb(0xBC4639);
wood.ForeColor = Color.White;
}
}
string tab = "";
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
conn.Open();
string query = @"select * from products where Quantity >= 1 and IsActive = 1 ";
if (btn.Text == "All")
{
query += "";
}
else if (btn.Text == "Animals")
{
tab = @"and CategoryID = 'S1001' ";
}
else if (btn.Text == "Bronzo")
{
tab = @"and CategoryID = 'S1002' ";
}
else if (btn.Text == "Wood")
{
tab = @"and CategoryID = 'S1003' ";
}
else if (btn.Text == "Oil Paint")
{
tab = @"and CategoryID = 'S1004' ";
}
else if (btn.Text == "Water Color")
{
tab = @"and CategoryID = 'S1005' ";
}
else if (btn.Text == "Arcylir Paint")
{
tab = @"and CategoryID = 'S1006' ";
}
query += tab;
query += value;
HttpCookie tabCookies = new HttpCookie("tab");
tabCookies.Value = tab;
Response.Cookies.Add(tabCookies);
SqlCommand cmd = new SqlCommand(query, conn);
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
ProductGalleryDataList.DataSource = dt;
ProductGalleryDataList.DataBind();
CurrentPage = 0;
ViewState["PageCount"] = 0;
ViewState["PagedDataSurce"] = dt;
DataListPaging(dt);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
