Example #1
0
    //public string bindc()
    //{
    //    int i = 0, j = 0;
    //    com.CommandText = "select item_name,qty,item_price,cart_id from cart where client_user_id='" + cid + "' AND client_session_id='" + sessionid + "'";
    //    com.Connection = con;
    //    reader = com.ExecuteReader();
    //    if (reader.HasRows)
    //    {
    //        while (reader.Read())
    //        {

    //        }
    //    }
    //    string data = "";
    //    int total=0;
    //    reader.Close();
    //    reader = com.ExecuteReader();
    //    if (reader.HasRows)
    //    {
    //        while (reader.Read())
    //        {
    //            string name = reader.GetString(0);
    //            int qty = reader.GetInt32(1);
    //            int price = reader.GetInt32(2);
    //            total = total + price;
    //            data += "<ul class='carttablehead'><li class=''>" + name + "</li><li class=''>" + qty + "</li><li class=''>" + price + "</li><li class=''>" + "</li></ul>";
    //        }
    //        reader.Close();
    //    }
    //    else
    //    {
    //        data += "<ul class='carttablehead'><li class=''>NO DATA</li></ul>";
    //    }
    //    //reader.Close();
    //    return data;
    //}
    public void bindtotal()
    {
        UpdatePanel1.Update();
        Mycart3.Update();
        reader.Close();
        string data  = "";
        int    total = 0;

        com.CommandText = "select item_price,qty from cart where client_user_id='" + cid + "' AND client_session_id='" + sessionid + "' AND payment_status='Pending'";
        com.Connection  = con;
        reader          = com.ExecuteReader();
        if (reader.HasRows)
        {
            while (reader.Read())
            {
                int pro_price = reader.GetInt32(0);
                int qty       = reader.GetInt32(1);
                total = total + pro_price * qty;
                data  = "Rs. " + total;
            }
            reader.Close();
            totalprice.InnerText = data;
        }
        else
        {
            //UpdatePanel1.Visible = false;
            //totalprice.Visible = false;
            checkoutlink.Visible = false;
            //Response.Redirect("gallery.aspx");
            data = "Rs. 0";
            reader.Close();
            totalprice.InnerText = data + "";
        }
    }
Example #2
0
    protected void save_ServerClick(object sender, System.EventArgs e)
    {
        int k = 0;
        //System.Threading.Thread.Sleep(3000);
        //Response.Write("<script>alert(' text=" + text_qty_val + "')</script>");
        int        changeqty = 0;
        LinkButton hl        = sender as LinkButton;
        string     url       = HttpContext.Current.Request.Url.AbsoluteUri;
        string     id        = hl.ID;

        tval    = Convert.ToInt32(text_qty_val);
        cartid1 = Convert.ToInt32(id);
        //strOriginal.Remove(20, 5);
        com.CommandText = "update cart set qty=" + tval + " where client_user_id='" + cid + "' AND client_session_id='" + sessionid + "' AND cart_id=" + cartid1;
        com.Connection  = con;
        //Response.Write("update cart set qty=" + tval + " where client_user_id='" + cid + "' AND client_session_id='" + sessionid + "' AND cart_id=" + cartid);
        changeqty = com.ExecuteNonQuery();
        //Label1.Text = "Panel refreshed at " +
        //DateTime.Now.ToString();
        //if (hl.HasAttributes)
        //{
        //    username.InnerText = hl.Attributes.Keys.ToString();
        //}
        if (changeqty > 0)
        {
            HyperLink qt = (HyperLink)Page.Form.FindControl("qty_" + id);
            qt.Text = text_qty_val;
            HiddenField        hd      = (HiddenField)Page.Form.FindControl("hide_" + id);
            string             p_price = hd.Value;
            HtmlGenericControl chli    = (HtmlGenericControl)Page.Form.FindControl("pricel" + id);
            chli.InnerText = (Convert.ToInt32(text_qty_val) * Convert.ToInt32(p_price)).ToString();



            bindtotal();


            Mycart3.Update();
            //Control c = (UpdatePanel)Page.Form.Controls(Mycart);
            UpdatePanel1.Update();
        }
        else
        {
            //Mycart.Update();
            //Response.Write("<script>alert('fail ')</script>");
        }
    }