protected void btnAddProduct_Click(object sender, EventArgs e)
{
MembershipSystemContext dbContext = new MembershipSystemContext();
Product d = new Product {
Name = txtName.Text, Details = txtDetails.Text, Price = decimal.Parse(txtPrice.Text)
};
dbContext.Products.Add(d);
dbContext.SaveChanges();
ClearPageTextboxes();
}
private object CreateDataSource()
{
DataTable dt = new DataTable();
DataRow dr;
MembershipSystemContext DBConn = new MembershipSystemContext();
IEnumerable <Product> Products = DBConn.Products.ToList <Product>();
// Define the columns of the table.
dt.Columns.Add(new DataColumn("ProductId", typeof(Int32)));
dt.Columns.Add(new DataColumn("Name", typeof(String)));
dt.Columns.Add(new DataColumn("Details", typeof(String)));
dt.Columns.Add(new DataColumn("AmtVoted", typeof(decimal)));
dt.Columns.Add(new DataColumn("Price", typeof(decimal)));
dt.Columns.Add(new DataColumn("Score", typeof(Int32)));
dt.Columns.Add(new DataColumn("Rating", typeof(decimal)));
// Populate the table with sample values.
foreach (Product x in Products)
{
dr = dt.NewRow();
dr[0] = x.ProductID;
dr[1] = x.Name;
dr[2] = x.Details;
dr[3] = x.AmtVoted;
dr[4] = x.Score;
dr[5] = x.Price;
dr[6] = x.Rating;
dt.Rows.Add(dr);
}
DataView dv = new DataView(dt);
return(dv);
}
