protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int bookid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
int quantity = int.Parse((row.FindControl("TextBox1") as TextBox).Text);
ShopBooksEntities obj = new ShopBooksEntities();
Book bo = obj.Books.Where(x => x.BookID == bookid).First <Book>();
CartDetail b = obj.CartDetails.Where(x => x.BookID == bookid).First <CartDetail>();
if (bo.Quantity > quantity)
{
b.Quantity = quantity;
obj.SaveChanges();
lblMsg.Visible = false;
bo.Quantity = bo.Quantity - quantity;
obj.SaveChanges();
}
else
{
lblMsg.Text = "Out of Stock. Please update the quantity.";
lblMsg.Visible = true;
}
GridView1.EditIndex = -1;
BindGrid();
}
protected void Button1_Click(object sender, EventArgs e)
{
ShopBooksEntities obj = new ShopBooksEntities();
User u = new User();
u.UserID = TextBoxEmail.Text;
u.Password = TextBoxReEnter.Text;
u.Role = "customer";
obj.Users.Add(u);
if (RegularExpressionValidator1.IsValid && RegularExpressionValidator2.IsValid && CompareValidator1.IsValid)
{
User u0 = new User();
try
{
u0 = obj.Users.Where(x => x.UserID == u.UserID && x.Password == u.Password).ToList().First();
Label1.Visible = true;
Label1.Text = "This email have already been registered, please just log in";
}
catch (System.InvalidOperationException)
{
obj.SaveChanges();
Label1.Visible = true;
Label1.Text = "Sign Up Successfully";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//userid = Request.QueryString["userid"];
//bookid = Convert.ToInt32(Request.QueryString["bookid"]);
userid = Convert.ToString(Session["login"]);
bookid = Convert.ToInt32(Request.QueryString["bookid"]);
if (userid == null || userid == "")
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
if (bookid > 0)
{
ShopBooksEntities obj = new ShopBooksEntities();
CartDetail cart1 = new CartDetail();
Book book = obj.Books.Where(x => x.BookID == bookid).First();
cart1.BookID = book.BookID;
cart1.UserID = userid;
cart1.Quantity = 1;
obj.CartDetails.Add(cart1);
obj.SaveChanges();
}
BindGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
ShopBooksEntities obj = new ShopBooksEntities();
List <Book> qry = (from x in obj.Books select x).ToList <Book>();
var jsonSerialiser = new JavaScriptSerializer();
var json = jsonSerialiser.Serialize(qry);
jsonval = json;
}
protected void BindGrid()
{
ShopBooksEntities obj = new ShopBooksEntities();
var q = obj.CartDetails.Where(x => x.UserID == userid).Select(y => new { y.Quantity, y.BookID, y.UserID, y.Book.BookTitle, y.Book.ISBN, y.Book.Price });
GridView1.DataSource = q.ToList();
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int bookid = Convert.ToInt32(Request.QueryString["bookid"]);
ShopBooksEntities obj = new ShopBooksEntities();
//var qry = (from x in obj.BookDescriptions where x.BookId == bookid select new { x.BookId, x.BookDescription1, x.Book.Price, x.Book.ISBN, x.Book.BookTitle }).ToList();
//var jsonSerialiser = new JavaScriptSerializer();
//var json = jsonSerialiser.Serialize(qry);
//jsonval = json;
}
protected void Page_Load(object sender, EventArgs e)
{
ShopBooksEntities obj = new ShopBooksEntities();
string userid = Convert.ToString(Session["login"]);
liAdd.Visible = false;
liEdit.Visible = false;
if (userid != null && userid != "")
{
User q = obj.Users.Where(x => x.UserID == userid).First <User>();
if (q.Role.ToUpper() == "OWNER")
{
liAdd.Visible = true;
liEdit.Visible = true;
}
}
}
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
int bookid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
ShopBooksEntities obj = new ShopBooksEntities();
CartDetail cart = obj.CartDetails.Where(x => x.BookID == bookid).First <CartDetail>();
try
{
obj.CartDetails.Remove(cart);
obj.SaveChanges();
}
catch (Exception ex)
{
lblMsg.Text = "Exception caught" + ex.Message;
}
lblMsg.Visible = false;
BindGrid();
}
private void ClearCart()
{
string userid = Convert.ToString(Session["login"]);
ShopBooksEntities obj = new ShopBooksEntities();
var cart = obj.CartDetails.Where(x => x.UserID == userid).ToList <CartDetail>();
for (int i = 0; i < cart.Count; i++)
{
obj.CartDetails.Remove(cart[i]);
obj.SaveChanges();
}
lblMsg.Visible = false;
btnCheckout.Visible = false;
txtTotal.Visible = false;
lblTtotal.Visible = false;
BindGrid();
}
private string CheckLogin(string name, string password)
{
ShopBooksEntities obj = new ShopBooksEntities();
User u = new User();
try
{
u = obj.Users.Where(x => x.UserID == name && x.Password == password).First();
}
catch (System.InvalidOperationException)
{
return(null);
}
//if ((u.Role).ToUpper() == "OWNER")
//{
// return "Owner_" + u.UserID;
//}
//else
return(u.UserID);
}
