protected void Page_Load(object sender, EventArgs e)
{
using (var db = new bigshopeEntities())
{
var query = db.showBrands();
DLBrnd.DataSource = query;
DLBrnd.DataBind();
var qury = db.showProcessor();
DLProc.DataSource = qury;
DLProc.DataBind();
var qry = db.showGen();
DLGen.DataSource = qry;
DLGen.DataBind();
}
}
private void FillCatagories()
{
using (var db = new bigshopeEntities())
{
var query_brnd = db.showBrands();
GV_Brnds.DataSource = query_brnd;
GV_Brnds.DataBind();
var query_proc = db.showProcessor();
GV_Proc.DataSource = query_proc;
GV_Proc.DataBind();
var query_gen = db.showGen();
GV_Gen.DataSource = query_gen;
GV_Gen.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (Request.QueryString["prod_id"] != null)
{
using (var db = new bigshopeEntities())
{
int prod_id = Convert.ToInt32(Request.QueryString["prod_id"]);
tblProduct p = db.tblProducts.FirstOrDefault(v => v.prod_id == prod_id);
tbName.Text = p.prod_name;
tbDesc.Text = p.prod_desc;
tbPrice.Text = Convert.ToString(p.prod_price);
tbQty.Text = Convert.ToString(p.prod_qnty);
tbRAM.Text = p.prod_ram;
}
}
using (var db = new bigshopeEntities())
{
var query_brnd = db.showBrands();
slctBrand.DataSource = query_brnd;
slctBrand.DataValueField = "brnd_id";
slctBrand.DataTextField = "brnd_name";
slctBrand.DataBind();
slctBrand.Items.Insert(0, new ListItem("-- Select a brand --", "0"));
var query_proc = db.showProcessor();
slctProc.DataSource = query_proc;
slctProc.DataValueField = "proc_id";
slctProc.DataTextField = "proc_name";
slctProc.DataBind();
slctProc.Items.Insert(0, new ListItem("-- Select a processor --", "0"));
var query_gen = db.showGen();
slctGen.DataSource = query_gen;
slctGen.DataValueField = "gen_id";
slctGen.DataTextField = "gen_name";
slctGen.DataBind();
slctGen.Items.Insert(0, new ListItem("-- Select a generation --", "0"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (Request.QueryString["brnd_id"] != null)
{
using (var db = new bigshopeEntities())
{
int brnd_id = Convert.ToInt32(Request.QueryString["brnd_id"]);
var qryBrnd = db.showProdByBrnds(brnd_id);
RP.DataSource = qryBrnd;
RP.DataBind();
}
}
else if (Request.QueryString["proc_id"] != null)
{
using (var db = new bigshopeEntities())
{
int proc_id = Convert.ToInt32(Request.QueryString["proc_id"]);
var qryProc = db.showProdByProc(proc_id);
RP.DataSource = qryProc;
RP.DataBind();
}
}
else if (Request.QueryString["gen_id"] != null)
{
using (var db = new bigshopeEntities())
{
int gen_id = Convert.ToInt32(Request.QueryString["gen_id"]);
var qryGen = db.showProdByProc(gen_id);
RP.DataSource = qryGen;
RP.DataBind();
}
}
else if (Request.QueryString["search"] != null)
{
using (var db = new bigshopeEntities())
{
var qrySrch = db.searchProducts(Request.QueryString["search"].ToString());
RP.DataSource = qrySrch;
RP.DataBind();
}
}
else
{
using (var db = new bigshopeEntities())
{
var query = db.showProducts();
RP.DataSource = query;
RP.DataBind();
var queryBrnd = db.showBrands();
DLBrnd.DataSource = queryBrnd;
DLBrnd.DataBind();
var quryProc = db.showProcessor();
DLProc.DataSource = quryProc;
DLProc.DataBind();
var qryGen = db.showGen();
DLGen.DataSource = qryGen;
DLGen.DataBind();
}
}
}
