//protected void btnCheckPincode_Click(object sender, EventArgs e)
    //{
    //    tblPinCode objPinCode = new tblPinCode();
    //    objPinCode.Where.AppPinCode.Value = txtPincode.Text;
    //    objPinCode.Query.Load();
    //    if (objPinCode.RowCount > 0)
    //    {
    //        lblAvailability.Visible = true;
    //        lblAvailability.Text = "Available";
    //        lblAvailability.ForeColor = System.Drawing.Color.Green;
    //    }
    //    else
    //    {
    //        lblAvailability.Visible = true;
    //        lblAvailability.Text = "Not Available";
    //        lblAvailability.ForeColor = System.Drawing.Color.Red;
    //    }
    //    objPinCode = null;
    //}


    protected void btnCheckCouponCode_Click(object sender, EventArgs e)
    {
        decimal       decprice         = 0;
        decimal       decpricediscount = 0;
        tblCouponCode objCouponCode    = new tblCouponCode();

        objDataTable  = objCouponCode.CheckCouponCodeExists(txtCouponCode.Text);
        objCouponCode = null;
        if (objDataTable.Rows.Count > 0 && lblDiscount.Text == "")
        {
            //decprice = Convert.ToDecimal(SpanPrice.InnerText.ToString().Split('.')[1] + "." + SpanPrice.InnerText.ToString().Split('.')[2]);
            decprice         = Convert.ToDecimal(SpanPrice.InnerText.ToString().Split('.')[1]);
            decpricediscount = (Convert.ToDecimal(objDataTable.Rows[0][tblCouponCode.ColumnNames.AppDiscountPer].ToString()) * decprice) / 100;

            DataTable            dtTemp = new DataTable();
            tblCouponCodeProduct objCouponCodeProduct = new tblCouponCodeProduct();
            if (objDataTable.Rows[0][tblCouponCode.ColumnNames.AppType].ToString() == Convert.ToInt32(Enums.Enum_CouponCodeType.General).ToString())
            {
                lblCouponCode.Text      = "Price after discount: " + Convert.ToInt32(Math.Round((decprice - decpricediscount), 0));
                lblCouponCode.ForeColor = System.Drawing.Color.Green;
                hdnPriceDiscount.Value  = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString();
            }
            else if (objDataTable.Rows[0][tblCouponCode.ColumnNames.AppType].ToString() == Convert.ToInt32(Enums.Enum_CouponCodeType.Category).ToString())
            {
                dtTemp = objCouponCodeProduct.GetReferenceIDByCouponID(objDataTable.Rows[0][tblCouponCode.ColumnNames.AppCouponCodeID].ToString(), Convert.ToInt32(Enums.Enum_CouponCodeType.Category), hdnPKID.Value);
                objCouponCodeProduct = null;
                if (dtTemp.Rows.Count > 0)
                {
                    lblCouponCode.Text      = "Price after discount: " + Convert.ToInt32(Math.Round((decprice - decpricediscount), 0));
                    lblCouponCode.ForeColor = System.Drawing.Color.Green;
                    hdnPriceDiscount.Value  = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString();
                }
                else
                {
                    lblCouponCode.Text      = "This coupon code does not exist for this product.";
                    lblCouponCode.ForeColor = System.Drawing.Color.Red;
                    hdnPriceDiscount.Value  = "0";
                }
            }
            else if (objDataTable.Rows[0][tblCouponCode.ColumnNames.AppType].ToString() == Convert.ToInt32(Enums.Enum_CouponCodeType.SubCategory).ToString())
            {
                dtTemp = objCouponCodeProduct.GetReferenceIDByCouponID(objDataTable.Rows[0][tblCouponCode.ColumnNames.AppCouponCodeID].ToString(), Convert.ToInt32(Enums.Enum_CouponCodeType.SubCategory), hdnPKID.Value);
                objCouponCodeProduct = null;
                if (dtTemp.Rows.Count > 0)
                {
                    lblCouponCode.Text      = "Price after discount: " + Convert.ToInt32(Math.Round((decprice - decpricediscount), 0));
                    lblCouponCode.ForeColor = System.Drawing.Color.Green;
                    hdnPriceDiscount.Value  = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString();
                }
                else
                {
                    lblCouponCode.Text = "This coupon code does not exist for this product.";

                    lblCouponCode.ForeColor = System.Drawing.Color.Red;
                    hdnPriceDiscount.Value  = "0";
                }
            }
            else if (objDataTable.Rows[0][tblCouponCode.ColumnNames.AppType].ToString() == Convert.ToInt32(Enums.Enum_CouponCodeType.Product).ToString())
            {
                dtTemp = objCouponCodeProduct.GetReferenceIDByCouponID(objDataTable.Rows[0][tblCouponCode.ColumnNames.AppCouponCodeID].ToString(), Convert.ToInt32(Enums.Enum_CouponCodeType.Product), hdnPKID.Value);
                objCouponCodeProduct = null;
                if (dtTemp.Rows.Count > 0)
                {
                    lblCouponCode.Text      = "Price after discount: " + Convert.ToInt32(Math.Round((decprice - decpricediscount), 0));
                    lblCouponCode.ForeColor = System.Drawing.Color.Green;
                    hdnPriceDiscount.Value  = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString();
                }
                else
                {
                    lblCouponCode.Text      = "This coupon code does not exist for this product.";
                    lblCouponCode.ForeColor = System.Drawing.Color.Red;
                    hdnPriceDiscount.Value  = "0";
                }
            }
            objCouponCodeProduct = null;
            dtTemp = null;
        }
        else
        {
            hdnPriceDiscount.Value  = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString();
            lblCouponCode.Text      = "This coupon code does not exist for this product.";
            lblCouponCode.ForeColor = System.Drawing.Color.Red;
        }
    }