void BindAlbumGrid()
        {
            int k = GridView1.PageCount;
            GridView1.Controls.Clear();

            //gridpageIndex = 0;
            CartDetails cartbll = new CartDetails();
            dt=cartbll.SelectUserCartDetails(Convert.ToInt32(Session["UserId"].ToString()));
            lblCart.Text = dt.Rows.Count.ToString() + " Items in Your Cart";
            if (dt.Rows.Count > 0)
            {
                decTotalPrice = 0;
                tblAdpost.Visible = true;
                tblAmount.Visible = true;
                tblBuy.Visible = true;
            if (dt.Rows.Count > 4)
            {
                decimal dPageSize = (dt.Rows.Count / 4M);
                //GridView1.PagerSettings.PageButtonCount = Convert.ToInt32(Math.Floor(dPageSize));
                //GridView1.PageSize = Convert.ToInt32(Math.Ceiling(dPageSize));
            }
            GridView1.DataSource = dt.DefaultView;
            GridView1.DataBind();
            }
            else
            {
                tblAdpost.Visible = false;
                tblAmount.Visible = false;
                tblBuy.Visible = false;
            }
        }
        protected void btnBuy_Click(object sender, EventArgs e)
        {
            if (Session["UserId"] == null)
                Response.Redirect("Login.aspx");
            else
            {
                if (ddlDeliType.SelectedIndex != 0)
                {
                #region .. GET HISTORY ID ..
                int intHistoryId = 0;
                    objCart = new CartDetails();
                DataTable dtMax = objCart.SelectMaxID();
                if (dtMax.Rows.Count > 0)
                {
                    string st = dtMax.Rows[0]["HistroyId"].ToString();
                    if (dtMax.Rows[0]["HistroyId"].ToString() == "")
                        intHistoryId = 0;
                    else
                        intHistoryId = Convert.ToInt32(dtMax.Rows[0]["HistroyId"].ToString());
                }
                intHistoryId++;
                #endregion
                    #region .. BUY DETAILS ..

                DataTable dtCart = objCart.SelectUserCartDetails(Convert.ToInt32(Session["UserId"].ToString()));
                    double delPrice = 0;
                    int intChargeId = int.Parse(ddlDeliType.SelectedItem.Value.ToString().Trim());

                    ChargeDetails chg = new ChargeDetails();
                    DataTable dt = chg.SelectChargeDetailsByID(intChargeId);
                    string strType = "";
                    string strAmount = "";
                    if (dt.Rows.Count > 0)
                    {
                        strType = dt.Rows[0]["ChargeType"].ToString();
                        strAmount = dt.Rows[0]["AmountOrPercent"].ToString();
                    }

                    double dblDeliAmount = Convert.ToDouble(strAmount);
                    if (strType == "0")
                        delPrice = Convert.ToDouble(decTotalPrice) + dblDeliAmount;
                    else if (strType == "1")
                        delPrice = Convert.ToDouble(decTotalPrice) + (Convert.ToDouble(decTotalPrice) * (dblDeliAmount / 100));

                    string strLocationId = "";
                    string strLocationName = "";
                    if (Session["Location"] != null)
                        strLocationName = Session["Location"].ToString();

                    City objCity = new City();
                    DataTable dtCity = objCity.SelectCityByName(strLocationName);
                    if (dtCity.Rows.Count > 0) strLocationId = dtCity.Rows[0]["CityId"].ToString(); else strLocationId = "0";

                for (int i = 0; i < dtCart.Rows.Count; i++)
                {

                    objCart.CreateBuyDetails(
                        Convert.ToInt32(dtCart.Rows[i]["AdPostId"].ToString()),
                        intHistoryId,
                        Convert.ToInt32(Session["UserId"].ToString()),
                            Convert.ToDecimal(delPrice),
                            int.Parse(ddlDeliType.SelectedItem.Value.ToString().Trim()),
                            Convert.ToInt32(strLocationId),
                        "BOUGHT",
                            1,
                            ddlDeliType.SelectedItem.Text.ToString().Trim(),
                            Convert.ToInt32(strType),
                            Convert.ToDouble(strAmount)
                        );

                    objCart.UpdateCartStatus(Convert.ToInt32(dtCart.Rows[i]["AdPostId"].ToString()), Convert.ToInt32(Session["UserId"].ToString()));
                }
                    decTotalPrice = 0;

                #endregion
                Response.Redirect("MyPurchases.aspx");
            }
                else
                {
                    lblError.Visible = true;
                    lblError.Text = "Select Delivery charges";
                }

            }
        }
        protected void ddlDeliType_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddlDeliType.SelectedIndex != 0)
            {
                objCart = new CartDetails();
                DataTable dtCart = objCart.SelectUserCartDetails(Convert.ToInt32(Session["UserId"].ToString()));
                double delPrice = 0;
                int intChargeId = int.Parse(ddlDeliType.SelectedItem.Value.ToString().Trim());

                ChargeDetails chg = new ChargeDetails();
                DataTable dt = chg.SelectChargeDetailsByID(intChargeId);
                string strType = "";
                string strAmount = "";
                if (dt.Rows.Count > 0)
                {
                    strType = dt.Rows[0]["ChargeType"].ToString();
                    strAmount = dt.Rows[0]["AmountOrPercent"].ToString();
                }

                double dblDeliAmount = Convert.ToDouble(strAmount);
                if (strType == "0")
                    delPrice = Convert.ToDouble(decTotalPrice) + dblDeliAmount;
                else if (strType == "1")
                {
                    dblDeliAmount = (Convert.ToDouble(decTotalPrice) * (dblDeliAmount / 100));
                    delPrice = Convert.ToDouble(decTotalPrice) + dblDeliAmount;
                }
                //decTotalPrice = 0;

                trDeliAmt.Visible = true;
                trTotalAmt.Visible = true;
                lblError.Visible = false;
                lblDeliAmt.Text = "$ " +String.Format("{0:0.00}", dblDeliAmount);
                lblTotalAmt.Text = "$ " + String.Format("{0:0.00}", delPrice);
            }
            else
            {
                trDeliAmt.Visible = false;
                lblError.Visible = true;
                trTotalAmt.Visible = false;
            }
        }