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;
}
}