protected void Page_Load(object sender, EventArgs e)
{
using (TSQL2012Entities MyEntities = new TSQL2012Entities())
{
var reviews = from review in MyEntities.Products
select new
{
review.productid,
ProductName = review.productname,
Company = review.Supplier.companyname,
Category = review.Category.categoryname,
Price = review.unitprice,
Discontinued = review.discontinued
};
Products.DataSource = reviews.ToList();
Products.DataBind();
var suppid = (from rev in MyEntities.Suppliers
select rev).ToList();
foreach (var item in suppid)
{
DropDownList1.Items.Add(new ListItem(item.companyname, item.supplierid.ToString()));
}
var catid = (from rev in MyEntities.Categories
select rev).ToList();
foreach (var item in catid)
{
DropDownList2.Items.Add(new ListItem(item.categoryname, item.categoryid.ToString()));
}
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
using (TSQL2012Entities myEntities = new TSQL2012Entities())
{
var del = (from review in myEntities.Products
where review.productid == id
select review).SingleOrDefault();
myEntities.Products.Remove(del);
myEntities.SaveChanges();
}
id_tx.Text = string.Empty;
}
protected void update_Click(object sender, EventArgs e)
{
GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent;
var index = gvRow.RowIndex;
id = int.Parse((Products.DataKeys[index].Value).ToString());
using (TSQL2012Entities myEntities = new TSQL2012Entities())
{
var tb = (from review in myEntities.Products
where review.productid == id
select review).SingleOrDefault();
id_tx.Text = tb.productid.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (TSQL2012Entities myEntities = new TSQL2012Entities())
{
var obj = new Product();
obj.productname = name_tx.Text;
obj.supplierid = Convert.ToInt32(DropDownList1.SelectedValue);
obj.categoryid = Convert.ToInt32(DropDownList2.SelectedValue);
obj.unitprice = Convert.ToDecimal(price_tx.Text);
obj.discontinued = Discont_check.Checked;
myEntities.Products.Add(obj);
myEntities.SaveChanges();
}
name_tx.Text = string.Empty;
price_tx.Text = string.Empty;
Discont_check.Checked = false;
grid.Visible = true;
}
private void bindGridView()
{
using (TSQL2012Entities MyEntities = new TSQL2012Entities())
{
var reviews = from review in MyEntities.Products
select new
{
review.productid,
ProductName = review.productname,
Company = review.Supplier.companyname,
Category = review.Category.categoryname,
Price = review.unitprice,
Discontinued = review.discontinued
};
Products.DataSource = reviews.ToList();
Products.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (TSQL2012Entities MyEntities = new TSQL2012Entities())
{
var reviews = from review in MyEntities.Products
select new
{
review.productid,
ProductName = review.productname,
Company = review.Supplier.companyname,
Category = review.Category.categoryname,
Price = review.unitprice,
Discontinued = review.discontinued
};
Products.DataSource = reviews.ToList();
Products.DataBind();
}
}
protected void update_Click(object sender, EventArgs e)
{
GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent;
var index = gvRow.RowIndex;
id = int.Parse((Products.DataKeys[index].Value).ToString());
using (TSQL2012Entities myEntities = new TSQL2012Entities())
{
var tb = (from review in myEntities.Products
where review.productid == id
select review).SingleOrDefault();
name_tx.Text = tb.productname;
DropDownList1.SelectedValue = tb.supplierid.ToString();
DropDownList2.SelectedValue = tb.categoryid.ToString();
price_tx.Text = tb.unitprice.ToString();
Discont_check.Checked = tb.discontinued;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (TSQL2012Entities myEntities = new TSQL2012Entities())
{
var update = (from review in myEntities.Products
where review.productid == id
select review).SingleOrDefault();
update.productname = name_tx.Text;
update.supplierid = Convert.ToInt32(DropDownList1.SelectedValue);
update.categoryid = Convert.ToInt32(DropDownList2.SelectedValue);
update.unitprice = Convert.ToDecimal(price_tx.Text);
update.discontinued = Discont_check.Checked;
myEntities.SaveChanges();
}
name_tx.Text = string.Empty;
price_tx.Text = string.Empty;
Discont_check.Checked = false;
grid.Visible = true;
}
