protected void Button1_Click(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String orderId = Request.QueryString["orderId"].ToString(); EncryptDecrypt obj = new EncryptDecrypt(); orderId = obj.Decrypt(HttpUtility.UrlDecode(orderId)); DatabaseHandler obj1 = new DatabaseHandler(); String sellerUsername = Request.Cookies["Car-Trading"]["Username"].ToString(); DataSet ds = obj1.GetSellerId(sellerUsername); String sellerId = ds.Tables[0].Rows[0]["SELLER_ID"].ToString(); ds = obj1.GetSellerPendingOrderInfo(orderId); String customerId = ds.Tables[0].Rows[0]["CUSTOMER_ID"].ToString(); String carId = ds.Tables[0].Rows[0]["CAR_ID"].ToString(); String oldStock = Label5.Text; int oldStock1 = Convert.ToInt32(oldStock); int newStock = oldStock1-1; String newStock1 = newStock.ToString(); obj1.DecrementCarStock(carId, newStock1); String paymentMode = Label10.Text; String customerAddr = Label9.Text; String orderDate = Label11.Text; obj1.InsertCompletedOrder(orderId, customerId, carId, sellerId, paymentMode, customerAddr, orderDate); Label13.Visible = true; Label13.Text = "Order Completed"; Button1.Enabled = false; }