protected void btnUpdateStatus_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow row in gvDeposits.Rows)
        {
            Label lblDepositedRequestId = (Label)row.FindControl("lblDepositRequestId");
            Label lblAgentId = (Label)row.FindControl("lblAgentId");
            Label lblAmount = (Label)row.FindControl("lblAmount");
            Label lblDepositType = (Label)row.FindControl("lblDepositType");
            Label lblTransactionNumber = (Label)row.FindControl("lblTransactionNumber");
            Label lblDetails = (Label)row.FindControl("lblDetails");
            Label lblDepositBank = (Label)row.FindControl("lblDepositBank");
            Label lblChequeDrawnBank = (Label)row.FindControl("lblChequeDrawnBank");
            Label lblChequeIssueDate = (Label)row.FindControl("lblChequeIssueDate");
            Label lblChequeNo = (Label)row.FindControl("lblChequeNo");
            Label lblStatus = (Label)row.FindControl("lblStatus");
            DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus");
            ClsBAL obj = new ClsBAL();
            DateTime? dtime = null;
            if (lblStatus.Text == "Requested")
            {
                if (lblChequeIssueDate.Text != "")
                {
                    dtime = Convert.ToDateTime(lblChequeIssueDate.Text);
                }
                lblMsg.InnerText = obj.UpdateDepositRequest(Convert.ToInt32(lblAgentId.Text), Convert.ToDouble(lblAmount.Text),
                               lblTransactionNumber.Text, lblDepositType.Text, lblDepositBank.Text, lblChequeDrawnBank.Text, dtime,
                             lblChequeNo.Text, Convert.ToInt32(Session["UserID"].ToString()), Convert.ToInt32(lblDepositedRequestId.Text), lblDetails.Text, ddlStatus.SelectedValue.ToString());
                if (lblMsg.InnerText.ToString() == "Amount has been deposited.")
                {
                    lblMsg.InnerText = lblMsg.InnerText.ToString();
                }

            }

        }
    }
    protected void btnUpdateStatus_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow row in gvDeposits.Rows)
        {
            Label lblDepositedRequestId = (Label)row.FindControl("lblDepositRequestId");
            Label lblAgentId = (Label)row.FindControl("lblAgentId");
            Label lblAgentname = (Label)row.FindControl("lblAgentname");
            Label lblemailId = (Label)row.FindControl("lblemailId");

            Label lblAmount = (Label)row.FindControl("lblAmount");
            Label lblDepositType = (Label)row.FindControl("lblDepositType");
            Label lblTransactionNumber = (Label)row.FindControl("lblTransactionNumber");
            Label lblDetails = (Label)row.FindControl("lblDetails");
            Label lblDepositBank = (Label)row.FindControl("lblDepositBank");
            Label lblChequeDrawnBank = (Label)row.FindControl("lblChequeDrawnBank");
            Label lblChequeIssueDate = (Label)row.FindControl("lblChequeIssueDate");
            Label lblChequeNo = (Label)row.FindControl("lblChequeNo");
            Label lblStatus = (Label)row.FindControl("lblStatus");
            DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus");
            ClsBAL obj = new ClsBAL();
            DateTime? dtime = null;
            if (lblStatus.Text == "Requested")
            {
                if (lblChequeIssueDate.Text != "")
                {
                    dtime = Convert.ToDateTime(lblChequeIssueDate.Text);
                }
                lblMsg.InnerText = obj.UpdateDepositRequest(Convert.ToInt32(lblAgentId.Text), Convert.ToDouble(lblAmount.Text),
                               lblTransactionNumber.Text, lblDepositType.Text, lblDepositBank.Text, lblChequeDrawnBank.Text, dtime,
                             lblChequeNo.Text, Convert.ToInt32(Session["UserID"].ToString()), Convert.ToInt32(lblDepositedRequestId.Text), lblDetails.Text, ddlStatus.SelectedValue.ToString());

                //System.Data.DataSet ds = objBal.GetAgentById(Convert.ToInt32(lblAgentId.Text));

                //DeductAgentBalance(Convert.ToInt32(lblAgentId.Text), Convert.ToDouble(0.00),
                //                   Convert.ToInt32(ds.Tables[0].Rows[0]["UserId"].ToString()), lblDepositType.Text, Convert.ToDouble(lblAmount.Text.ToString()),
                //                   Convert.ToDouble(0.00), Convert.ToInt32(0.00));

                if (lblMsg.InnerText.ToString() == "Amount has been deposited.")
                {
                    lblMsg.InnerText = lblMsg.InnerText.ToString();
                    BindDepositRequests();

                    #region
                    string Body = "Hello <b>" + lblAgentname.Text + "</b>," +
                        "<br /><br />Let us welcome you  with lovejourney.in " +
                        "Following are your Added Balance details. <br/> <br/>" +
                        "Email ID :<b><b>" + lblemailId.Text.Trim() + "</b><br />" +
                        "Added Amount:<b><b>" + lblAmount.Text + "</b><br />" +

                        "<br /><br />We thank you for registering with  lovejourney.in and please " +
                        "do not hesitate<br /> to write to us at <a href='mailto:[email protected]'>Mail </a><b> " +
                        "should you have any questions. <br /><br />Best Regards, <br />Administrator<br /> <a href='http://lovejourney.in'> lovejourney.in</a>" +
                        "<br /><br />";
                    MailSender.SendEmail(lblemailId.Text.Trim(), "*****@*****.**", "*****@*****.**", "lovejourney-Deposit", Body);
                    #endregion

                }
                //lblStatus.Visible = false;
                //ddlStatus.Visible = true;
            }
            //else
            //{
            //    lblStatus.Visible = true;
            //    ddlStatus.Visible = false;
            //}
        }
    }