protected void btnCreate_Click(object sender, EventArgs e)
{
using (WebDL.Team2_BookDBEntities cntx = new WebDL.Team2_BookDBEntities())
{
//var u = new user();
// u= cntx.users.Where(m => m.userEmail == txtEmail.Text).FirstOrDefault();
// if (u == null)
// {
//var createUser=new user();
//createUser.userName = txtUserName.Text;
//createUser.roleID = 2;
//createUser.userPassword = txtPassword.Text;
//createUser.userEmail = txtEmail.Text;
//createUser.userPhone = Convert.ToInt32(txtPhoneNo.Text);
//createUser.userAddress = txtAddress.Text;
//createUser.userDescription = txtDesc.Text;
//cntx.users.Add(createUser);
// cntx.SaveChanges();
// Response.Redirect("/LogIn.aspx");
//}
//else
//{
// Response.Redirect("/Member/CreateMember.aspx");
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (WebDL.Team2_BookDBEntities context = new WebDL.Team2_BookDBEntities())
{
string catSelected = "Arts & Photography";
List <WebDL.category> cats = context.categories.ToList();
var data = from p in context.products where p.category.categoryName == catSelected select p;
ListView1.DataSource = data.ToList();
ListView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (WebDL.Team2_BookDBEntities context = new WebDL.Team2_BookDBEntities())
{
var data = from u in context.users where u.userID == 5 select u;
WebDL.user tmpUser = data.First();
Label1.Text = tmpUser.userEmail;
WebDL.shoppingCart sc = context.shoppingCarts.First();
}
//using (WebDL.Team2_BookDBEntities context = new WebDL.Team2_BookDBEntities())
//{
// WebDL.payment p = new WebDL.payment();
// WebDL.user u = context.users.First();
// Label1.Text = u.userAddress;
//}
}
private Table loadOrderTable(int userid)
{
using (WebDL.Team2_BookDBEntities bke = new WebDL.Team2_BookDBEntities())
{
var date = from sel in bke.orders where sel.userID == userid select sel;
List <WebDL.order> odl = date.ToList();
foreach (WebDL.order o in odl)
{
TableRow tr = new TableRow();
TableCell c1 = new TableCell();
TableCell c2 = new TableCell();
TableCell c3 = new TableCell();
c1.Text = o.ordersID.ToString();
c2.Text = o.ordersDate.ToString();
c3.Text = o.ordersDescription.ToString();
tr.Cells.Add(c1);
tr.Cells.Add(c2);
tr.Cells.Add(c3);
t.Rows.Add(tr);
}
return(t);
}
}
