protected void btnYes_Click(object sender, EventArgs e)
{
var dbContext = new DBClassesDataContext();
var userOrders = (from ord in dbContext.Orders
where ord.UserId == int.Parse(Request.QueryString["UserId"])
select ord).ToList();
var user = (from u in dbContext.Users
where u.UserId == int.Parse(Request.QueryString["UserId"])
select u).SingleOrDefault();
try
{
dbContext.Orders.DeleteAllOnSubmit(userOrders);
dbContext.Users.DeleteOnSubmit(user);
dbContext.SubmitChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Response.Redirect("Default.aspx");
}
protected void btnYes_Click(object sender, EventArgs e)
{
var dbContext = new DBClassesDataContext();
var user = (from u in dbContext.Users
where u.UserId == int.Parse(Request.QueryString["UserId"])
select u).SingleOrDefault();
try
{
if (user != null)
{
user.UserName = Session["name"].ToString();
user.UserEmail = Session["address"].ToString();
}
dbContext.SubmitChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Response.Redirect("Default.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
var dbContext = new DBClassesDataContext();
if (Request.QueryString["id"] == null)
{
return;
}
var q = (from o in dbContext.Orders
where o.UserId == int.Parse(Request.QueryString["id"])
select new
{
o.OrderDate,
o.Amount
}).ToList();
DetailInfo.DataSource = q;
DetailInfo.DataBind();
}