protected void gvcashcoupons_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            if (e.CommandName == "status")
            {
                LinkButton lbtn = (LinkButton)e.CommandSource;
                Control ctrl = e.CommandSource as Control;
                GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow;
                LinkButton lbtnstatus = (LinkButton)row.FindControl("lbtnstatus");
                Label lblstatus = (Label)row.FindControl("lblStatus");
                if (lbtnstatus.Text == "Activate")
                {
                    objBAL = new ClsBAL();
                    objBAL.ID = Convert.ToInt32(e.CommandArgument);
                    objBAL.status = "1";
                    objBAL.modifiedBy = Convert.ToInt32(Session["UserID"].ToString());
                    if (objBAL.UpdateCashCouponStatus())
                    {
                        tdmsg.Visible = true;
                        tdmsg.Style.Add("background-color:#6CC417;", "");
                        lblMainMsg.Text = "Updated Successfully....";
                        lblMainMsg.ForeColor = System.Drawing.Color.Green;
                        BindCashCoupons();
                    }
                    else
                    {
                        tdmsg.Visible = true;
                        tdmsg.Style.Add("background-color:#E77471;", "");
                        lblMainMsg.Text = "OOPS Some Problem in updation.Try Later...";
                        lblMainMsg.ForeColor = System.Drawing.Color.Maroon;
                    }
                }
                else if (lbtnstatus.Text == "Deactivate")
                {
                    objBAL = new ClsBAL();
                    objBAL.ID = Convert.ToInt32(e.CommandArgument);
                    objBAL.status = "0";
                    objBAL.modifiedBy = Convert.ToInt32(Session["UserID"].ToString());
                    if (objBAL.UpdateCashCouponStatus())
                    {
                        tdmsg.Visible = true;
                        tdmsg.Style.Add("background-color:#6CC417;", "");
                        lblMainMsg.Text = "Updated Successfully....";
                        lblMainMsg.ForeColor = System.Drawing.Color.Green;
                        BindCashCoupons();
                    }
                    else
                    {
                        tdmsg.Visible = true;
                        tdmsg.Style.Add("background-color:#E77471;", "");
                        lblMainMsg.Text = "OOPS Some Problem in updation.Try Later...";
                        lblMainMsg.ForeColor = System.Drawing.Color.Maroon;
                    }
                }
            }

        }
        catch (Exception ex)
        {

            throw ex;
        }
    }
    protected void btncashcoupon_Click(object sender, EventArgs e)
    {
        try
        {
            if (txtcashcoupon.Text != "" && chkCashCoupon.Checked == true)
            {
                ClsBAL objBal = new ClsBAL();
                objBal.couponNo = txtcashcoupon.Text;
                DataSet ds = objBal.CheckCashCoupon();
                if (ds != null)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["EmailId"].ToString() == txtEmailId.Text.ToString())
                        {
                            if (Convert.ToDouble(lblTotalAmountPayable.Text) >= Convert.ToDouble(ds.Tables[0].Rows[0]["Amount"]))
                            {
                                lblTotalAmountPayable.Text = (Convert.ToDouble(lblTotalAmountPayable.Text) - Convert.ToDouble(ds.Tables[0].Rows[0]["Amount"])).ToString();
                                ClsBAL objBAL = new ClsBAL();
                                objBAL.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["CouponId"]);
                                objBAL.status = "0";
                                objBAL.modifiedBy = 0;
                                bool b = objBAL.UpdateCashCouponStatus();
                                if (b == true)
                                {
                                    lblMsg.Text = "Yours cash coupon amount has update.";
                                    lblMsg.ForeColor = System.Drawing.Color.Green;
                                }
                            }
                            else
                            {
                                double fare = Convert.ToDouble(ds.Tables[0].Rows[0]["Amount"]) - Convert.ToDouble(lblTotalAmountPayable.Text);
                                lblTotalAmountPayable.Text = "0";
                                ClsBAL objBAL = new ClsBAL();
                                objBAL.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["CouponId"]);
                                objBAL.Amount = fare.ToString();
                                objBAL.createdBy = Convert.ToInt32(Session["UserID"]);
                                bool b = objBAL.UpdateCashCoupon();
                                if (b == true)
                                {
                                    lblMsg.Text = "Yours cash coupon amount greater than ticket amount,for the remaining balance use same cash coupon no.";
                                    lblMsg.ForeColor = System.Drawing.Color.Green;
                                }
                            }
                            txtcashcoupon.Text = "";
                            txtcashcoupon.Visible = false;
                            btncashcoupon.Visible = false;
                            chkCashCoupon.Checked = false;
                        }
                        else
                        {
                            lblMsg.Text = "Please enter valid cash coupon person email id.";
                            lblMsg.ForeColor = System.Drawing.Color.Red;
                            txtEmailId.Text = "";
                            txtcashcoupon.Text = "";
                        }
                    }
                    else
                    {
                        lblMsg.Text = "Please enter valid cash coupon no.";
                        lblMsg.ForeColor = System.Drawing.Color.Red;
                    }
                }

            }
            else
            {
                lblMsg.Text = "Please enter cash coupon no.";
                lblMsg.ForeColor = System.Drawing.Color.Red;
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }