protected void btnsignup_Click(object sender, EventArgs e) { try { DataFuction objdf = new DataFuction(); SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@signnumber", SqlDbType.BigInt); param[0].Value = Convert.ToInt64(txtsignnumber.Text); param[1] = new SqlParameter("@signemail", SqlDbType.VarChar); param[1].Value = txtsignemail.Text; param[2] = new SqlParameter("@signpassword", SqlDbType.VarChar); param[2].Value = txtsignpassword.Text; int result = objdf.ExecuteQuery("usp_insert_signup", param); if (result > 0) { Response.Write("<script>alert('Sign Up Successful')</script>"); } txtsignnumber.Text = string.Empty; txtsignemail.Text = string.Empty; txtsignpassword.Text = string.Empty; } catch (Exception ex) { Response.Write("<script>alert('Error Occured Please Contact to Admin')</script>"); } }
public static int countcart(int user) { DataFuction objdf = new DataFuction(); DataTable dt = new DataTable(); dt = objdf.FillDT("select * from ORDER_MASTER where User_Id ='" + user + "'"); int countcartvalue = dt.Rows.Count; return(countcartvalue); }
protected void Button1_Click(object sender, EventArgs e) { DataFuction objdf = new DataFuction(); lblcartcount.Text = "0"; btnshopping.Visible = true; //SqlParameter[] param = new SqlParameter[1]; //param[0] = new SqlParameter("@orderid", SqlDbType.Int); //param[0].Value = Convert.ToInt32(lblorderid.Text); //objdf.ExecuteQuery("usp_order_remove", param); //MakePayment master = (MakePayment)Page.Master; //Label lbl = (Label)master.FindControl("lblcartcount"); //lbl.Text = (Count.countcart(Convert.ToInt32(Session["login"])).ToString()); Response.Write("<script>alert('Your Order Booked')</script>"); }
public void FillProductDetail() { try{ DataFuction objdf = new DataFuction(); DataSet ds = new DataSet(); ds = objdf.FillDsS("select * from PRODUCT_MASTER where Product_Id ='" + productid + "'"); imgproductimg.ImageUrl = ds.Tables[0].Rows[0]["Product_Image"].ToString(); lblproductname.Text = ds.Tables[0].Rows[0]["Product_Name"].ToString(); lblProductnamee.Text = ds.Tables[0].Rows[0]["Product_Name"].ToString(); lblproductcolour.Text = ds.Tables[0].Rows[0]["Product_Colour"].ToString(); lblproductdisprice.Text = ds.Tables[0].Rows[0]["Product_Dis_Price"].ToString(); lblproductdiscount.Text = ds.Tables[0].Rows[0]["Product_Discount"].ToString(); lblproductprice.Text = ds.Tables[0].Rows[0]["Product_Price"].ToString(); lblproductpricee.Text = ds.Tables[0].Rows[0]["Product_Price"].ToString(); lbltotal.Text = ds.Tables[0].Rows[0]["Product_Price"].ToString(); lblpay.Text = ds.Tables[0].Rows[0]["Product_Price"].ToString(); } catch (Exception ex) { Response.Write("<script>alert('Error Occured Please Contact to Admin')</script>"); } }
protected void btnaddtocart_Click(object sender, EventArgs e) { try{ if (Session["login"] == null) { Response.Write("<script>alert('Please Login')</script>"); } else { KapdeWala master = (KapdeWala)Page.Master; Label lbl = (Label)master.FindControl("lblcartcount"); DataFuction objdf = new DataFuction(); //ds = objdf.FillDsS("select * from PRODUCT_MASTER where Product_Id ='" + productid + "'"); //imgproductimg.ImageUrl = ds.Tables[0].Rows[0]["Product_Image"].ToString(); //lblproductname.Text = ds.Tables[0].Rows[0]["Product_Name"].ToString(); //lblproductdisprice.Text = ds.Tables[0].Rows[0]["Product_Dis_Price"].ToString(); //lblproductdiscount.Text = ds.Tables[0].Rows[0]["Product_Discount"].ToString(); //lblproductprice.Text = ds.Tables[0].Rows[0]["Product_Price"].ToString(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@ordername", SqlDbType.VarChar); param[0].Value = lblproductname.Text; param[1] = new SqlParameter("@orderimage", SqlDbType.VarChar); param[1].Value = imgproductimg.ImageUrl; param[2] = new SqlParameter("@orderprice", SqlDbType.BigInt); param[2].Value = Convert.ToInt64(lblproductprice.Text); param[3] = new SqlParameter("@orderdisprice", SqlDbType.BigInt); param[3].Value = Convert.ToInt64(lblproductdisprice.Text); param[4] = new SqlParameter("@orderdiscount", SqlDbType.BigInt); param[4].Value = Convert.ToInt64(lblproductdiscount.Text); param[5] = new SqlParameter("@userid", SqlDbType.Int); param[5].Value = Convert.ToInt32(Session["login"]); int result = objdf.ExecuteQuery("usp_order_insert", param); if (result > 0) { lbl.Text = (Count.countcart(Convert.ToInt32(Session["login"])).ToString()); } else { Response.Write("<script> alert('Product already exists !')</script>"); } } } catch (Exception ex) { Response.Write("<script>alert('Error Occured Please Contact to Admin')</script>"); } }