protected void Page_Load(object sender, EventArgs e)
{
if ((bool)HttpContext.Current.Session["loggedIn"] == true)
{
btnAddToCart.Visible = true;
DetailsView1.Fields[4].Visible = false;
}
else
{
btnAddToCart.Visible = false;
DetailsView1.Fields[4].Visible = true;
}
if (GridView1.SelectedValue != null)
{
DataView productTable = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
productTable.RowFilter = "ProductID = " + GridView1.SelectedValue;
DataRowView row = productTable[0];
selectedProduct = new Product();
selectedProduct.ProductID = (int)row["ProductID"];
selectedProduct.Name = row["ProductName"].ToString();
selectedProduct.Category = row["Category"].ToString();
selectedProduct.Price = (decimal)row["Price"];
}
}
protected void g_relatedProducts_BeforePerformDataSelect(object sender, System.EventArgs e)
{
ASPxGridView gridView = (ASPxGridView)sender;
if (gridView.DataSource != null)
{
return;
}
if (Session[gridView.GetMasterRowKeyValue().ToString()] != null)
{
string selectCommand = (string)Session[gridView.GetMasterRowKeyValue().ToString()];
AccessDataSource2.SelectCommand = selectCommand;
DataView view = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
gridView.DataSource = view;
gridView.DataBind();
}
}
protected void relatedProducts_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
ASPxGridView g_relatedProducts = (ASPxGridView)sender;
int visibleIndex = int.Parse(e.Parameters);
ASPxPageControl pc = (ASPxPageControl)grid.FindDetailRowTemplateControl(visibleIndex, "ASPxPageControl1");
HtmlInputText editor = (HtmlInputText)pc.TabPages[0].FindControl("SearchString");
string searchString = editor.Value;
string selectCommand = "select * from [Products] where (([CategoryID]=" + g_relatedProducts.GetMasterRowKeyValue().ToString() + ") and ([ProductName] Like '%" + searchString + "%'))";
Session[g_relatedProducts.GetMasterRowKeyValue().ToString()] = selectCommand;
AccessDataSource2.SelectCommand = selectCommand;
DataView view = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
g_relatedProducts.DataSource = view;
g_relatedProducts.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserType"] == null || !Session["UserType"].ToString().Equals("user"))
{
Response.Redirect("~/Login.aspx");
}
if (Session["Username"] == null)
{
return;
}
DataView dv = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
if (dv.Count == 0)
{
return;
}
TextBox2.Text = dv[0].Row["FullName"].ToString();
TextBox3.Text = dv[0].Row["Email"].ToString();
TextBox4.Text = dv[0].Row["ContactNo"].ToString();
TextBox5.Text = dv[0].Row["Address"].ToString();
}
protected string GetImageFileNameById(string id)
{
AccessDataSource2.SelectParameters["ID"].DefaultValue = id;
return(((DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty))[0]["ImageFileName"].ToString());
}
