protected void btnAdd_Click(object sender, EventArgs e) { try { Title ttl = new Title(); ttl.TitleName = txtName.Text; ttl.TitleDescription = txtDesc.Text; ttl.Edition = txtEd.Text; ttl.ISBN = txtISBN.Text; ttl.Pages = Int32.Parse(txtPgs.Text); ttl.PubDate = Convert.ToDateTime(txtPubDate.Text); ttl.Rating = 0; ttl.RatingCount = 0; ttl.DownloadCount = 0; ttl.Status = 0; ttl.FileFormat = ddlFormat.SelectedValue; ttl.Price = Decimal.Parse(txtPrice.Text); ebs.Titles.Add(ttl); ebs.SaveChanges(); GenData(); } catch (Exception ex) { lblErr.Text = ex.Message; } }
protected void btnUpdate0_Click(object sender, EventArgs e) { try { if ((txtContact.Text.Trim() != "") && (txtName.Text.Trim() != "")) { int userid = Int32.Parse(Session["eStoreUserId"].ToString()); User us = ebs.Users.Single(u => u.UserId == userid); us.UserName = txtName.Text; us.Contact = txtContact.Text; ebs.SaveChanges(); Response.AddHeader("REFRESH", "0"); btnUpdate0.Visible = false; btnEdit.Visible = true; } else { lblMsg.Text = "You cannot leave any fields blank."; } } catch (Exception ex) { lblErr.Text = ex.Message; } }
protected void btnAdd_Click(object sender, EventArgs e) { int CatId = Int32.Parse(ddlAllCat.SelectedItem.Value); int TitleId = Int32.Parse(Request.QueryString["TitleId"]); Title ttl = ebs.Titles.SingleOrDefault(t => t.TitleId == TitleId); Category cat = ebs.Categories.SingleOrDefault(c => c.CategoryId == CatId); ttl.Categories.Add(cat); ebs.SaveChanges(); GenData(); }
protected void btnAdd_Click(object sender, EventArgs e) { int AuthorId = Int32.Parse(ddlAllAuth.SelectedItem.Value); int TitleId = Int32.Parse(Request.QueryString["TitleId"]); Author au = ebs.Authors.Single(a => a.AuthorId == AuthorId); Title t = ebs.Titles.SingleOrDefault(a => a.TitleId == TitleId); t.Authors.Add(au); ebs.SaveChanges(); GenData(); }
protected void btnAdd_Click(object sender, EventArgs e) { try { Category c = new Category(); c.CategoryName = txtAdd.Text; ebs.Categories.Add(c); ebs.SaveChanges(); GenData(); } catch (Exception ex) { lblErr.Text = ex.Message; } }
protected void btnAdd_Click(object sender, EventArgs e) { try { Author au = new Author(); au.FirstName = txtAddFname.Text; au.LastName = txtAddLName.Text; ebs.Authors.Add(au); ebs.SaveChanges(); GenData(); } catch (Exception ex) { lblErr.Text = ex.Message; } }
protected void btnAddrev_Click(object sender, EventArgs e) { int TitleId = Int32.Parse(Request.QueryString["TitleId"]); imgCover.ImageUrl = "../../Storage/Images/" + TitleId.ToString() + ".png"; Title ttl = ebs.Titles.SingleOrDefault(t => t.TitleId == TitleId); Review rev = new Review(); Htmlify htex = new Htmlify(); rev.ReviewText = htex.Convert(txtRev.Text); rev.ReviewDate = DateTime.Now; rev.UserUserId = Int32.Parse(Session["eStoreUserId"].ToString()); rev.TitleTitleId = TitleId; ebs.Reviews.Add(rev); ebs.SaveChanges(); FillPage(); }
protected void btnDel_Click(object sender, EventArgs e) { int revid = Int32.Parse(lbRev.SelectedItem.Value); Review rev = ebs.Reviews.SingleOrDefault(a => a.ReviewId == revid); ebs.Reviews.Remove(rev); ebs.SaveChanges(); GenDataInner(); }
protected void btnPay_Click(object sender, EventArgs e) { List <Title> cartItems = (List <Title>)Session["eStoreCart"]; int userid = Int32.Parse(Session["eStoreUserId"].ToString()); Bill bl = new Bill(); User us = ebs.Users.SingleOrDefault(u => u.UserId == userid); bl.BillAmount = Decimal.Parse(lblBill.Text); bl.BillDate = DateTime.Now; bl.User = us; foreach (Title item in cartItems) { bl.Titles.Add(ebs.Titles.SingleOrDefault(ttl => ttl.TitleId == item.TitleId)); } ebs.Bills.Add(bl); ebs.SaveChanges(); Response.Redirect("Orders.aspx"); }
protected void Page_Load(object sender, EventArgs e) { ebs = new eBookStoreDBModelContainer(); AuthUser(); try { int TitleId = Int32.Parse(Request.QueryString["TitleId"]); Title t = ebs.Titles.SingleOrDefault(a => a.TitleId == TitleId); t.Status = 1; ebs.SaveChanges(); lblTitle.Text = t.TitleName + " " + t.Edition + " edition."; FillPage(); } catch (Exception ex) { lblTitle.Text = "Undefined."; lblErr.Text = ex.Message; lblErr.Text += "<br> You probably arrived to this page directly."; } }
protected void btnReg_Click(object sender, EventArgs e) { try { ebs = new eBookStoreDBModelContainer(); RijndaelAES ri = new RijndaelAES(); User us = new User(); string login = txtLogin.Text; var unique_check = from u in ebs.Users where u.UserLogin == login select u.UserName; if (txtPass.Text == txtrePass.Text) { if (unique_check.ToList().Count == 0) { us.UserLogin = login; us.UserName = txtName.Text.Trim(); us.Pass = ri.Crypto(txtPass.Text, 0); us.Contact = txtContact.Text; ebs.Users.Add(us); ebs.SaveChanges(); lblMsg.Text = "Successfully Registered. Redirecting now."; Response.AddHeader("REFRESH", "2;URL=../Home.aspx"); } else { lblMsg.Text = "Cannot register. An account with this email already exists."; } } else { lblMsg.Text = "Passwords do not match."; } } catch (Exception ex) { lblErr.Text = ex.Message; } }