protected void btnAdd_Click(object sender, EventArgs e)
    {
        try
        {
        _objMasters = new clsMasters();
        _objMasters.ScreenInd = Masters.InsertTarrif;
           // _objDataSet = (DataSet)_objMasters.fnGetData();
        _objMasters.OperatorsID =Convert.ToInt32(ddlProvider.SelectedValue);
        _objMasters.Denomination =Convert.ToInt32( txtDenomination.Text);
        _objMasters.TalkTime = Convert.ToDecimal(txtTalkTime.Text);
        _objMasters.Validity = txtValidity.Text;
        _objMasters.Description = txtDescription.Text;

        if (_objMasters.fnInsertRecord() == true)
        {
            lblmessage.ForeColor = Color.Green;
            lblmessage.Text = "Record saved successfully.";

            ddlProvider_SelectedIndexChanged(sender, e);

            ddlProvider.SelectedIndex = 0;
            txtDenomination.Text = string.Empty;
            txtTalkTime.Text = string.Empty;
            txtValidity.Text = string.Empty;
            txtDescription.Text = string.Empty;
        }
        else
        {
            lblmessage.Text = "Insertion Failed";
        }
        }
        catch(Exception ex)
        {
            throw ex;
        }
    }
 public void LogError(String ScreenName, String MethodName, DateTime Time, String ex)
 {
     try
     {
         _objMasters = new clsMasters();
         _objMasters.ScreenInd = Masters.LogError;
         _objMasters.ScreenName = ScreenName.ToString();
         _objMasters.MethodName = MethodName.ToString();
         _objMasters.Time = Convert.ToDateTime(Time);
         _objMasters.Exception = ex.ToString();
         _objMasters.fnInsertRecord();
     }
     catch
     { }
 }
    protected void btnSignUp_Click(object sender, EventArgs e)
    {
        //if(txtEmailID1.Text =="" || txtFirstName.Text=="" || txtPassword1.Text=="" || txtMobileNum.Text=="" || txtaddress1.Text =="" ||txtState.Text == "" || txtCity.Text=="")
        //{
        //    return;
        //}
        //else
        //{
        checkUser();

        if (Checked == "available")
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.UserMst;
            _objMasters.EmailID = txtEmailID1.Text.Trim().ToString().ToLower();
            _objMasters.FirstName = txtFirstName.Text.Trim();
            _objMasters.Password = txtPassword1.Text.Trim().ToString().ToLower();
            _objMasters.Mobile_Num = txtMobileNum.Text.Trim();
            _objMasters.Address = txtaddress1.Text.Trim();
            _objMasters.Statename = txtState.Text.Trim();
            _objMasters.cityname = txtCity.Text.Trim();
            _objMasters.CountryName = ddlCountry.SelectedValue;
            _objMasters.PostalCode = txtUserpostalcode.Text.Trim();

            if (_objMasters.fnInsertRecord() == true)
            {
                lblMsg1.ForeColor = Color.Green;
                lblMsg2.ForeColor = Color.Green;
                MpeSignUP.Show();
                lblMsg1.Text = "Confirmation: ";
                lblMsg2.Text = "successfully. Registered";

                try
                {

                    string str = string.Empty;

                    string Body = "Dear <b>" + txtFirstName.Text + "</b>," +
                    "<br /><br />Let us welcome you recharge with lovejourney.in " +
                     "Following are your login details. <br/> <br/>" +
                    " Email ID :<b>" + txtEmailID1.Text.Trim() + "</b><br />" +
                    " Password : <b>" + txtPassword1.Text.Trim() + "</b><br/>" +
                    "<br /><br />you have successfully registered in www.lovejourney.in and please" +
                    "do not hesitate<br /> to write to us at <a href='mailto:[email protected]'>Mail</a> " + " " +
                    "should you have any questions. <br /><br />Best Regards,<br />Administrator <br /> <a href='http://lovejourney.in'> lovejourney.in</a>" +
                    "<br /><br />";

                    MailSender.SendEmail(txtEmailID1.Text.Trim(), "*****@*****.**", "*****@*****.**", "LoveJourney-login", Body);
                }
                catch (Exception ex)
                {
                    throw ex;
                }

                Login(txtEmailID1.Text.Trim().ToString(), txtPassword1.Text.Trim().ToString());

            }
            else
            {
                lblMsg1.Text = "<font color='red'> Error Notification: </font>";
                lblMsg2.Text = ".";
            }
        }
        else if (Checked == "null")
        {
            MpeSignUP.Show();
            lblMsg1.Text = "Email ID Already Exists";
            lblMsg1.ForeColor = Color.Red;
            lblMsg1.Visible = true;

            //lblMessage.Text = "Email ID Already Exists";
            //Mpe1.Show();
            //Clearfields();

        }
    }
    public Boolean MobileRecharge(String CouponNumber, String MobileNumber, Int16 RechargeAmount, String Order_Id, String IPAddr)
    {
        Boolean isRechargeSuccess = false;

        string Provider = String.Empty, balance = String.Empty, Email = String.Empty, requestId = String.Empty;
        _objMaster = new clsMasters();
        _objMaster.ScreenInd = Masters.getrecharge;
        _objMaster.Parameter = "RequestID";
           // _objMaster.RequestID = Session["Order_Id"].ToString();
        _objMaster.RequestID = Order_Id.ToString();
        _objDataSet = new DataSet();
        _objDataSet = (DataSet)_objMaster.fnGetData();

        if (_objDataSet != null)
        {
            if (_objDataSet.Tables[0].Rows.Count > 0)
            {
                MobileNumber = _objDataSet.Tables[0].Rows[0]["MobileNo"].ToString();
                Provider = _objDataSet.Tables[0].Rows[0]["Provider_Name"].ToString();
                balance = _objDataSet.Tables[0].Rows[0]["Amount"].ToString();
                Email = _objDataSet.Tables[0].Rows[0]["E_Mail"].ToString();

                # region Mobile code
             //   requestId = "KAA" + GenerateRandomNumber(11);

             //   string URL = "http://www.bulksel.com/api_reach_bulksel.php?user=kass9378&pass=bus80111&mobileno=918008419101&newid=" + requestId + "&message=BS " +
             //Provider + " " + MobileNumber + " " + balance;

             //   HttpWebRequest oReq = null;
             //   HttpWebResponse oRes = null;
             //   StreamReader oStream = null;
             //   oReq = (HttpWebRequest)WebRequest.Create(URL);
             //   oReq.Method = "GET";
             //   oReq.Timeout = 10000;
             //   oRes = (HttpWebResponse)oReq.GetResponse();
             //   oStream = new StreamReader(oRes.GetResponseStream(), Encoding.GetEncoding(1252));

             //   string strMessage = oStream.ReadToEnd().ToString();

             //   Session["strMessage"] = strMessage.ToString();
             //   string[] s = strMessage.Split('d');
             //   if (s[0].ToString() == "Request Accepte")
             //   {
             //       #region Insert Data into Database

             //       _objMaster = new clsMasters();

             //       _objMaster.ScreenInd = Masters.getGuestrecharge1;
             //       _objMaster.Parameter = "update";
             //       _objMaster.RequestID = Session["Order_Id"].ToString();
             //       _objMaster.TransactionID = Convert.ToString(s[1].ToString());
             //       Session["TransactionID"] = Convert.ToString(s[1].ToString());

             //       _objMaster.IP = IPAddr;

             //       if (_objMaster.fnUpdateRecord() == true)
             //       {

             //           isRechargeSuccess = true;
             //           //lblMessage.Text = "Recharge has Been Success";

             //           try
             //           {
             //               string body = "<html xmlns='http://www.w3.org/1999/xhtml'><head><title></title></head><body>" +
             //      "<table width='700' border='0' cellspacing='0' cellpadding='0' style='font-family: Verdana;font-size: smaller; margin-left: 1px; margin-right: 1px; padding-bottom: 10px;'><tr>" +
             //      "<td valign='top' width='100%'>" +
             //      "<table width='100%'><tr><td valign='top'" +
             //     " &nbsp;<img src='http://rechargeraja.com/images/ban.jpg' /></td> </tr></table> </td></tr>" + " <tr><td align='left' valign='top' style='height: 0px; background-color: #860f2b;'></td></tr>" +
             //     "<tr><td align='left' valign='top' style='padding-left: 10px;'>Dear User, </td></tr>" +
             //     "<tr><td align='left' valign='top' style='padding-left: 10px;'>Your TransactionID .<span style='font-weight: 600;'>" + Session["TransactionID"] + " </span></td></tr>" +
             //     "<tr><td><table><tr><td align='right' valign='top' style='padding-right: 100px; background-color: #F1F1F1'><span style='color: #860f2b; font-weight: 600;'> Mobile Number:</span>" + MobileNumber + "</td>" +
             //     "<td align='right' valign='top' style='padding-right: 100px; background-color: #F1F1F1'><span style='color: #860f2b; font-weight: 600;'>Amount:</span>" + balance + "</td></tr></table></td></tr>" +
             //      "<tr><td align='left' width='100%' valign='top'><table><tr><td align='center' width='100%' valign='top' style='background-color: #860f2b; color: White;' colspan='2'><b>Contact Us</b></td></tr>" +
             //      "<tr><td align='left' valign='top' style='background-color: #EFEFEF;'><table><tr><td align='right' valign='top'><span style='color: #860f2b;'>Support</span> </td>  " + "<td align='left' valign='top'>  &nbsp;Visit our Knowledge Base / FAQs for quick answers Log a query or problem at  My Helpdesk </td></tr> " +
             //      "<tr><td align='right' valign='top'></td>&quot;</tr></table></td>" +
             //    "<td align='left' valign='top' style='background-color: #EFEFEF;'><table><tr><td align='left' valign='top'> <span style='color: #860f2b;'>Sales Support</span></td> " +
             //    "<td align='left' valign='top'> <p>  </p> Hyderabad - 90</td></tr>" +
             //     "<tr><td align='left' valign='top' style='padding-left: 20px;'></td></tr>" +
             //     "<tr><td align='left' valign='top' style='padding-left: 20px; background-color: #860f2b color: White;'></td></tr>" +
             //     "</table></body></html>" +
             //     "<br />Again, we thank you for registering with <b>www.rechargeraja.com</b> and please " +
             //      "do not hesitate to write to us at <a href='mailto:[email protected]'>Mail</a>" + "if you have any questions.<br /><br />Best Regards,<br /><a href='http://www.rechargeraja.com'>rechargeraja.com</a> " + "<br /><br />";

             //               MailSender.SendEmail(Email, "*****@*****.**", "*****@*****.**", "rechargeraja-Recharge", body);

             //           }
             //           catch (Exception ex)
             //           {
             //               isRechargeSuccess = false;
             //               //throw ex;
             //           }

             //           try
             //           {
             //               string strUrl = "http://sms.i2space.in/WebServiceSMS.aspx?User=i2space1&passwd=smsc&mobilenumber=" + MobileNumber +
             //               "&message= Thank You for usingrechargeraja.com to Recharge Mobile no" + MobileNumber + " for Rs" + " " + balance + "& your order Num is" + "" + Session["TransactionID"] + "" + "for Queries ,Email us at [email protected]" +
             //               "&sid=rechargeraja&mtype=N";
             //               HttpWebRequest oReq1 = null;
             //               HttpWebResponse oRes1 = null;
             //               StreamReader oStream1 = null;
             //               oReq1 = (HttpWebRequest)WebRequest.Create(strUrl);
             //               oReq1.Method = "GET";
             //               oReq1.Timeout = 10000;
             //               oRes1 = (HttpWebResponse)oReq1.GetResponse();
             //               oStream1 = new StreamReader(oRes1.GetResponseStream(), Encoding.GetEncoding(1252));
             //               string strMessage1 = oStream1.ReadToEnd().ToString();
             //           }
             //           catch (ArgumentException ex)
             //           {
             //               //LogError("redirect.aspx", "sms", DateTime.Now, ex.Message.ToString());
             //               //Response.Redirect("Error.aspx", false);
             //           }

             //           isRechargeSuccess = true;
             //           //Response.Redirect("Success.aspx", false);

             //       }
             //       #endregion
             //   }
             //   else
             //   {
             //       isRechargeSuccess = false;
             //       //Response.Redirect("RechargeFailure.aspx", false);
             //       //LogError("redirect.aspx", "API", DateTime.Now, Session["strMessage"].ToString());
             //       _objMaster = new clsMasters();
             //       _objMaster.ScreenInd = Masters.Mobilenew;
             //       _objMaster.Mobile_Num = Convert.ToString(MobileNumber); //txtMobile.Text.Trim();
             //       _objMaster.Provider_Name = Convert.ToString(Provider);
             //       _objMaster.E_Mail = Convert.ToString(Email);
             //       _objMaster.Amount = Convert.ToDouble(balance);
             //       _objMaster.Payment = Convert.ToString("Deposited");
             //       _objMaster.RequestID = requestId.Trim();
             //       _objMaster.TransactionID = Convert.ToString(Session["strMessage"]);

             //       _objMaster.IP = IPAddr;
             //       _objMaster.Status = "Failure";//strMessage.Substring(strMessage.IndexOf("<status>") + 8, 7);
             //       _objMaster.CreatedBy = "NA";
             //       _objMaster.ModifiedBy = "NA";
             //       _objMaster.ModifiedDate = "NA";
             //       _objMaster.fnInsertRecord();
             //       // Response.Redirect("Error.aspx", false);
             //   }

                #endregion

            }
            else
            {
                isRechargeSuccess = false;
                //Response.Redirect("RechargeFailure.aspx", false);
                //LogError("redirect.aspx", "API", DateTime.Now, Session["strMessage"].ToString());
                _objMaster = new clsMasters();
                _objMaster.ScreenInd = Masters.Mobilenew;
                _objMaster.Mobile_Num = MobileNumber; //txtMobile.Text.Trim();
                _objMaster.Provider_Name = Provider;
                _objMaster.E_Mail = Email;
                _objMaster.Amount = Convert.ToDouble(balance);
                _objMaster.Payment = Convert.ToString("Deposited");
                _objMaster.RequestID = requestId.Trim();
                _objMaster.TransactionID = Convert.ToString(Session["strMessage"]);

                _objMaster.IP = IPAddr;
                _objMaster.Status = "Failure";//strMessage.Substring(strMessage.IndexOf("<status>") + 8, 7);
                _objMaster.CreatedBy = "NA";
                _objMaster.ModifiedBy = "NA";
                _objMaster.ModifiedDate = "NA";
                _objMaster.fnInsertRecord();
                // Response.Redirect("Error.aspx", false);
            }
        }

        else
        {
            isRechargeSuccess = false;
            //Mpe1.Show();
            //lblMessage.Text = "Recharge Has Been Failed Please Try Again Later";

        }

        return isRechargeSuccess;
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        try
        {
            _objMasters = new clsMasters();

            _objMasters.OperatorType = ddloperators.SelectedValue;
            _objMasters.NetworkName = ddlProvider.SelectedItem.Text;
            _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text);
            _objMasters.Type = ddlName.SelectedValue;
           // _objMasters.DistributorID =Convert.ToInt32(ddlName.SelectedValue);

            _objMasters.ScreenInd = Masters.GetCommisionByNetwork;
            _objDataSet = (DataSet)_objMasters.fnGetData();
            if (_objDataSet != null)
            {
                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    DataView dv = _objDataSet.Tables[0].DefaultView;

                    dv.RowFilter = "Type='" + ddlName.SelectedValue + "'and OperatorType='" + ddloperators.SelectedValue + "' and OperatorsName='" + ddlProvider.SelectedItem.Text+"'";
                    if (dv.Count > 0)
                    {
                        lblmessage.ForeColor = Color.Red;
                        lblmessage.Text = "Already you have given commission for this network,Please try another one.";
                        lblmessage.Visible = true;
                    }
                    else
                    {
                        _objMasters.ScreenInd = Masters.AgentCommission;

                        _objMasters.OperatorType = ddloperators.SelectedValue;
                        _objMasters.NetworkName = ddlProvider.SelectedValue;
                        _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text);
                        _objMasters.Type = ddlName.SelectedValue;
                        if (_objMasters.fnInsertRecord() == true)
                        {
                            lblmessage.ForeColor = Color.Green;
                            lblmessage.Text = "Record saved successfully.";
                            ddlProvider.SelectedIndex = 0;
                            txtRechargeAmount.Text = string.Empty;

                            ddloperators.SelectedIndex = 0;
                            fnLoadPage1();
                        }
                        else
                        {
                            lblmessage.Text = "Insertion Failed";
                        }
                    }
                }
                else
                {
                    _objMasters.ScreenInd = Masters.AgentCommission;

                    _objMasters.OperatorType = ddloperators.SelectedValue;
                    _objMasters.NetworkName = ddlProvider.SelectedValue;
                    _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text);
                    _objMasters.Type = ddlName.SelectedValue;
                    if (_objMasters.fnInsertRecord() == true)
                    {
                        lblmessage.ForeColor = Color.Green;
                        lblmessage.Text = "Record saved successfully.";
                        ddlProvider.SelectedIndex = 0;
                        txtRechargeAmount.Text = string.Empty;

                        ddloperators.SelectedIndex = 0;
                        fnLoadPage1();
                    }
                    else
                    {
                        lblmessage.Text = "Insertion Failed";
                    }
                }

            }
            else
            {
                _objMasters.ScreenInd = Masters.AgentCommission;

                _objMasters.OperatorType = ddloperators.SelectedValue;
                _objMasters.NetworkName = ddlProvider.SelectedValue;
                _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text);
                _objMasters.Type = ddlName.SelectedValue;
                if (_objMasters.fnInsertRecord() == true)
                {
                    lblmessage.ForeColor = Color.Green;
                    lblmessage.Text = "Record saved successfully.";
                    ddlProvider.SelectedIndex = 0;
                    txtRechargeAmount.Text = string.Empty;

                    ddloperators.SelectedIndex = 0;
                    fnLoadPage1();
                }
                else
                {
                    lblmessage.Text = "Insertion Failed";
                }
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
    protected void imgbtnGuest_Click(object sender, EventArgs e)
    {
        try
        {

            int check;
            _objMaster = new clsMasters();
            _objMaster.ScreenInd = Masters.gettimeforusers;
            _objMaster.MobileNum = txtMobile.Text.Trim();
            _objMaster.Parameter = "Mobile";
            _objDataSet = new DataSet();
            _objDataSet = (DataSet)_objMaster.fnGetData();

            if (_objDataSet.Tables[0].Rows.Count == 0)
            {
                Session["RMobileNumber"] = txtMobile.Text.Trim();
                Session["RProviderName"] = ddlProvider.SelectedValue;
                Session["REmailMobile"] = txtEmailMobile.Text.Trim();
                // Session["RRechargeAmount"] = Convert.ToDouble(txtRecAmount.Text.Trim());
                Session["RRechargeAmount"] = Convert.ToDouble(ddlMobilerechargeamount.Text.Trim());
                lblOrderID.Text =  GenerateRandomNumber(11);
                Session["Order_Id"] = lblOrderID.Text;

                #region inserting
                _objMaster = new clsMasters();
                _objMaster.ScreenInd = Masters.Mobile;
                _objMaster.Mobile_Num = txtMobile.Text.Trim();
                _objMaster.UserID = Convert.ToInt32(Session["UserID"]);

                _objMaster.Type = "AG";

                _objMaster.Provider_Name = ddlProvider.SelectedItem.Value;
                _objMaster.E_Mail = txtEmailMobile.Text.Trim();
                // _objMaster.Amount = Convert.ToDouble(txtRecAmount.Text.Trim());
                _objMaster.Amount = Convert.ToDouble(ddlMobilerechargeamount.Text.Trim());
                _objMaster.Payment = "Deposit";
                _objMaster.RequestID = lblOrderID.Text.Trim();
                _objMaster.TransactionID = Convert.ToString(1111);
                _objMaster.IP = ipaddr;
                _objMaster.Status = "PENDING";
                _objMaster.CreatedBy = "NA";
                _objMaster.ModifiedBy = "NA";
                _objMaster.ModifiedDate = "NA";
                _objMaster.fnInsertRecord();
                #endregion

                getbalance();
                if (Session["Role"].ToString() == "User")
                {

                    Response.Redirect("../User/PaymentMethod.aspx", false);

                    // Response.Redirect("../Pay.aspx", false);
                }
                else if (Session["Role"].ToString() == "Agent")
                {

                    if (Convert.ToDecimal(Session["AgentBalance"].ToString()) > Convert.ToInt32(Session["RRechargeAmount"]))
                    {

                        lbllowbalance.Text = "";
                        mobilerecharge();
                    }
                    else
                    {
                        mpeagentproceed.Show();
                        lbllowbalance.Visible = true;
                        lbllowbalance.Text = "Recharge failed.Please contact administrator.";
                        lbllowbalance.ForeColor = Color.Red;
                    }
                }
                else if (Session["Role"].ToString() == "Admin")
                {
                    lbllowbalance.Text = "";
                  //  adminmobilerecharge();
                }

            }
            else if (_objDataSet.Tables[0].Rows.Count > 0)
            {
                check = Convert.ToInt32(_objDataSet.Tables[0].Rows[0]["Allow"]);
                if (check > 0)
                {
                    _objMaster.ScreenInd = Masters.Mobile;
                    Session["RMobileNumber"] = txtMobile.Text.Trim();
                    Session["RProviderName"] = ddlProvider.SelectedValue;
                    Session["REmailMobile"] = txtEmailMobile.Text.Trim();
                    // Session["RRechargeAmount"] = Convert.ToDouble(txtRecAmount.Text.Trim());
                    Session["RRechargeAmount"] = Convert.ToDouble(ddlMobilerechargeamount.Text.Trim());
                    lblOrderID.Text =  GenerateRandomNumber(11);
                    Session["Order_Id"] = lblOrderID.Text;

                    //  MobileRecharge();

                    #region inserting
                    _objMaster = new clsMasters();
                    _objMaster.ScreenInd = Masters.Mobile;
                    _objMaster.Mobile_Num = txtMobile.Text.Trim();
                    _objMaster.UserID = Convert.ToInt32(Session["UserID"]);
                    _objMaster.Type = "AG";
                    _objMaster.Provider_Name = ddlProvider.SelectedItem.Value;
                    _objMaster.E_Mail = txtEmailMobile.Text.Trim();
                    //  _objMaster.Amount = Convert.ToDouble(txtRecAmount.Text.Trim());
                    _objMaster.Amount = Convert.ToDouble(ddlMobilerechargeamount.Text.Trim());
                    _objMaster.Payment = "Deposit";
                    _objMaster.RequestID = lblOrderID.Text.Trim();
                    _objMaster.TransactionID = Convert.ToString(1111);
                    _objMaster.IP = ipaddr;
                    _objMaster.Status = "PENDING";
                    _objMaster.CreatedBy = "NA";
                    _objMaster.ModifiedBy = "NA";
                    _objMaster.ModifiedDate = "NA";
                    _objMaster.fnInsertRecord();
                    #endregion
                    getbalance();
                    if (Session["Role"].ToString() == "User")
                    {
                        Response.Redirect("../User/PaymentMethod.aspx", false);
                        // Response.Redirect("../Pay.aspx", false);
                    }
                    else if (Session["Role"].ToString() == "Agent")
                    {
                        if (Convert.ToDecimal(Session["AgentBalance"].ToString()) > Convert.ToInt32(Session["RRechargeAmount"]))
                        {

                            lbllowbalance.Text = "";
                            mobilerecharge();
                        }
                        else
                        {
                            mpeagentproceed.Show();
                            lbllowbalance.Visible = true;
                            lbllowbalance.Text = "Recharge failed.Please contact administrator.";
                            lbllowbalance.ForeColor = Color.Red;
                        }

                    }
                    else if (Session["Role"].ToString() == "Admin")
                    {
                        //adminmobilerecharge();
                    }

                }
                else
                {
                    lblMessage.Text = "Please Try Again After 15 Minutes";
                    Mpe1.Show();

                }

            }
        }

        catch (Exception ex)
        {
            //LogError("Masters/Recharge.aspx", "imgbtnGuest_Click", DateTime.Now, ex.Message.ToString());
            throw ex;
        }
        finally
        {

            _objDataSet = null;
        }
    }
    protected void btnRegister_Click(object sender, EventArgs e)
    {
        try
        {
            checkAgent();
            if (Checked == "Available")
            {
                System.DateTime today = System.DateTime.Now;
                if (Convert.ToDateTime(txtDOB.Text.Trim()) >= today)
                {
                    lblmsg.Visible = true;
                    lblmsg.Text = "your DOB should be less than current date";
                    lblmsg.ForeColor = Color.Red;
                    lblMsg1.Text = "";
                    lblMsg2.Text = "";
                }
                else
                {
                    GeneratePassword();
                    Session["Password"] = txtPassword.Text;

                    _objMasters = new clsMasters();
                    _objMasters.ScreenInd = Masters.Agentregistration;
                    _objMasters.EmailID = txtEmailIDAgent.Text.Trim().ToLower();
                    _objMasters.Password = lblPWD.Text;
                    _objMasters.Title = ddlTitle.SelectedItem.Text;
                    _objMasters.FirstName = txtFirstName.Text.Trim();
                    _objMasters.LastName = txtLastName.Text.Trim();
                    _objMasters.DOB = Convert.ToDateTime(txtDOB.Text.Trim());
                    _objMasters.Address = txtAddress.Text.Trim();
                    _objMasters.Pincode = txtPinCode.Text.Trim();
                    _objMasters.Mobile = txtMobile.Text.Trim();
                    _objMasters.Landline = txtLandLine.Text.Trim();
                    _objMasters.Fax = txtFax.Text.Trim();
                    _objMasters.CountryName = ddlCountry.SelectedValue;
                    _objMasters.Statename = ddlState.Text;
                    _objMasters.cityname = ddlCity.Text;
                    _objMasters.Status ="0";
                    _objMasters.UserType = ddltype.SelectedValue;

                    if (_objMasters.fnInsertRecord() == true)
                    {
                        btnRegister.Visible = true;
                        pnlContact.Visible = true;
                        lblMsg1.ForeColor = Color.Green;
                        lblMsg2.ForeColor = Color.Green;
                        lblMsg1.Visible = lblMsg2.Visible = true;
                        lblMsg1.Text = "Confirmation: ";
                        lblMsg2.Text = "your details saved successfully,Please Wait for admin approval.";
                        lblmsg.Visible = false;
                        clearFields();

                    }

                    else
                    {
                        lblMsg1.Text = "<font color='red'> Error Notification: </font>";
                        lblMsg2.Text = "your registration is failed.";
                        lblmsg.Visible = false;
                    }
                }
            }
            else if (Checked == "null")
            {
                lblMsg1.ForeColor = Color.Red;
                lblMsg1.Text = " EmailID is Not available";
                lblMsg1.Visible = true;
                lblmsg.Visible = false;
                txtEmailID.Focus();
                //Reset(this);
            }
        }

        catch (Exception ex)
        {
            LogError("AgentLogin", "btnRegister_Click", DateTime.Now, ex.Message.ToString());
            Response.Redirect("Error.aspx", false);
        }
    }
    protected void ImgbtnNetguests_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            int check;
            Session["Role"] = null;
            _objMaster = new clsMasters();
            _objMaster.ScreenInd = Masters.gettime;
            _objMaster.MobileNum = Session["RMobileNumber"].ToString();// txtMobile.Text.Trim();
            _objMaster.Parameter = "DataCard";
            _objDataSet = new DataSet();
            _objDataSet = (DataSet)_objMaster.fnGetData();
            if (_objDataSet.Tables[0].Rows.Count == 0)
            {
                _objMaster.ScreenInd = Masters.DataCardnew;
                Session["RMobileNumber"] = TextBox123.Text.Trim();
                Session["DRProviderName"] = ddlNetConnect.SelectedItem.Value;
                Session["REmailMobile"] = txtEmailnet.Text.Trim();
                //Session["RRechargeAmount"] = Convert.ToDouble(txtRechargeAmount.Text.Trim());
                Session["RRechargeAmount"] = Convert.ToDouble(ddlDatacardRechargeAmount.SelectedItem.Text);

                lblOrderID.Text =  Convert.ToString(GenerateRandomNumber(11));
                Session["Order_Id"] = lblOrderID.Text;

                #region inserting
                _objMaster = new clsMasters();
                _objMaster.ScreenInd = Masters.DataCardnew;
                _objMaster.Mobile = TextBox123.Text.Trim();
                _objMaster.Provider_Name = ddlNetConnect.SelectedItem.Value;
                _objMaster.E_Mail = txtEmailnet.Text.Trim();
                //  _objMaster.Amount = Convert.ToDouble(txtRechargeAmount.Text.Trim());
                _objMaster.Amount = Convert.ToDouble(ddlDatacardRechargeAmount.SelectedItem.Text);

                _objMaster.Name = txtdcguestname.Text;
                _objMaster.Address = txtdcguestadddress.Text;
                _objMaster.Statename = txtdatacardState.Text;
                _objMaster.cityname = txtDataCardCity.Text;
                _objMaster.PostalCode = txtDataCardPostalCode.Text;
                _objMaster.CountryName = ddlDatacardcountry.SelectedValue;

                _objMaster.Payment = "Deposit";
                _objMaster.RequestID = lblOrderID.Text.Trim();
                _objMaster.TransactionID = Convert.ToString(1111);
                _objMaster.IP = ipaddr;
                _objMaster.Status = "PENDING";
                _objMaster.CreatedBy = "NA";
                _objMaster.ModifiedBy = "NA";
                _objMaster.ModifiedDate = "NA";
                _objMaster.fnInsertRecord();
                #endregion

            }
            else if (_objDataSet.Tables[0].Rows.Count > 0)
            {
                check = Convert.ToInt32(_objDataSet.Tables[0].Rows[0]["Allow"]);

                if (check > 0)
                {
                    _objMaster.ScreenInd = Masters.Mobilenew;
                    Session["RMobileNumber"] = TextBox123.Text.Trim();
                    Session["DRProviderName"] = ddlNetConnect.SelectedItem.Value;
                    Session["REmailMobile"] = txtEmailnet.Text.Trim();
                    //  Session["RRechargeAmount"] = Convert.ToDouble(txtRechargeAmount.Text.Trim());
                    Session["RRechargeAmount"] = Convert.ToDouble(ddlDatacardRechargeAmount.SelectedItem.Text);
                    lblOrderID.Text =  Convert.ToString(GenerateRandomNumber(11));
                    Session["Order_Id"] = lblOrderID.Text;
                    #region inserting
                    _objMaster = new clsMasters();
                    _objMaster.ScreenInd = Masters.DataCardnew;
                    _objMaster.Mobile_Num = TextBox123.Text.Trim();
                    _objMaster.Provider_Name = ddlNetConnect.SelectedItem.Value;
                    _objMaster.E_Mail = txtEmailnet.Text.Trim();
                    // _objMaster.Amount = Convert.ToDouble(txtRechargeAmount.Text.Trim());
                    _objMaster.Amount = Convert.ToDouble(ddlDatacardRechargeAmount.SelectedItem.Text);

                    _objMaster.Name = txtdcguestname.Text;
                    _objMaster.Address = txtdcguestadddress.Text;
                    _objMaster.Statename = txtdatacardState.Text;
                    _objMaster.cityname = txtDataCardCity.Text;
                    _objMaster.PostalCode = txtDataCardPostalCode.Text;
                    _objMaster.CountryName = ddlDatacardcountry.SelectedValue;

                    _objMaster.Payment = "Deposit";
                    _objMaster.RequestID = lblOrderID.Text.Trim();
                    _objMaster.TransactionID = Convert.ToString(1111);
                    _objMaster.IP = ipaddr;
                    _objMaster.Status = "PENDING";
                    _objMaster.CreatedBy = "NA";
                    _objMaster.ModifiedBy = "NA";
                    _objMaster.ModifiedDate = "NA";
                    _objMaster.fnInsertRecord();
                    #endregion

                }
                else
                {
                    lblMessage.Text = "please Try Again after 15 minutes";
                    Mpe1.Show();
                }
            }

            Response.Redirect("Pay.aspx", false);
        }
        catch (Exception ex)
        {
            LogError("Default.aspx", "ImgbtnNetguests_Click", DateTime.Now, ex.Message.ToString());
            throw ex;
        }
    }
    protected void DThGuests()
    {
        try
        {
            int check;
            _objMaster = new clsMasters();
            _objMaster.ScreenInd = Masters.gettime;
            _objMaster.Customer_ID = txtCustID.Text.Trim();
            _objMaster.Parameter = "DTH";
            _objDataSet = new DataSet();
            _objDataSet = (DataSet)_objMaster.fnGetData();

            if (_objDataSet.Tables[0].Rows.Count == 0)
            {

                _objMaster.ScreenInd = Masters.Mobilenew;
                Session["RMobileNumber"] = txtCustID.Text.Trim();
                Session["Rd2hProviderName"] = ddlD2HProvider.SelectedItem.Value;
                Session["REmailMobile"] = txtEmailD2H.Text.Trim();
                //Session["RRechargeAmount"] = Convert.ToDouble(txtD2HAmount.Text.Trim());
                Session["RRechargeAmount"] = ddlD2HAmount.SelectedItem.Text;
                lblOrderID.Text =  Convert.ToString(GenerateRandomNumber(11));
                Session["Order_Id"] = lblOrderID.Text;

                #region inserting
                _objMaster = new clsMasters();
                _objMaster.ScreenInd = Masters.D2H;
                _objMaster.Customer_ID = txtCustID.Text.Trim();
                _objMaster.Provider_Name = ddlD2HProvider.SelectedItem.Text;
                _objMaster.E_Mail = txtEmailD2H.Text.Trim();
                // _objMaster.Amount = Convert.ToDouble(txtD2HAmount.Text.Trim())
                _objMaster.Amount = Convert.ToDouble(ddlD2HAmount.SelectedItem.Text);

                _objMaster.Name = txtGusetdthname.Text;
                _objMaster.Address = txtdthguestaddress.Text;
                _objMaster.Statename = txtDTHState.Text;
                _objMaster.cityname = txtDTHCity.Text;
                _objMaster.PostalCode = txtPostalCodeDTH.Text;

                _objMaster.Payment = "Deposit";
                _objMaster.RequestID = lblOrderID.Text.Trim();
                _objMaster.TransactionID = Convert.ToString(1111);
                _objMaster.IP = ipaddr;
                _objMaster.Status = "PENDING";
                _objMaster.CreatedBy = "NA";
                _objMaster.ModifiedBy = "NA";
                _objMaster.ModifiedDate = "NA";
                _objMaster.fnInsertRecord();
                #endregion
                //Response.Redirect("Checkout.aspx");
            }
            else if (_objDataSet.Tables[0].Rows.Count > 0)
            {
                check = Convert.ToInt32(_objDataSet.Tables[0].Rows[0]["Allow"]);

                if (check > 0)
                {
                    _objMaster.ScreenInd = Masters.Mobilenew;
                    Session["RMobileNumber"] = txtCustID.Text.Trim();
                    Session["Rd2hProviderName"] = ddlD2HProvider.SelectedItem.Value;
                    Session["REmailMobile"] = txtEmailD2H.Text.Trim();
                    // Session["RRechargeAmount"] = Convert.ToDouble(txtD2HAmount.Text.Trim());
                    Session["RRechargeAmount"] = Convert.ToDouble(ddlD2HAmount.SelectedItem.Text);
                    lblOrderID.Text = Convert.ToString(GenerateRandomNumber(11));
                    Session["Order_Id"] = lblOrderID.Text;
                    #region inserting
                    _objMaster = new clsMasters();
                    _objMaster.ScreenInd = Masters.D2H;
                    _objMaster.Customer_ID = txtCustID.Text.Trim();
                    _objMaster.Provider_Name = ddlD2HProvider.SelectedItem.Text;
                    _objMaster.E_Mail = txtEmailD2H.Text.Trim();
                    //  _objMaster.Amount = Convert.ToDouble(txtD2HAmount.Text.Trim());
                    _objMaster.Amount = Convert.ToDouble(ddlD2HAmount.SelectedItem.Text);

                    _objMaster.Name = txtGusetdthname.Text;
                    _objMaster.Address = txtdthguestaddress.Text;
                    _objMaster.Statename = txtDTHState.Text;
                    _objMaster.cityname = txtDTHCity.Text;
                    _objMaster.PostalCode = txtPostalCodeDTH.Text;

                    _objMaster.Payment = "Deposit";
                    _objMaster.RequestID = lblOrderID.Text.Trim();
                    _objMaster.TransactionID = Convert.ToString(1111);
                    _objMaster.IP = ipaddr;
                    _objMaster.Status = "PENDING";
                    _objMaster.CreatedBy = "NA";
                    _objMaster.ModifiedBy = "NA";
                    _objMaster.ModifiedDate = "NA";
                    _objMaster.fnInsertRecord();
                    #endregion

                }
                else
                {
                    lblMessage.Text = "please Try Again after 15 minutes";
                    Mpe1.Show();
                }
            }

            // Response.Redirect("Pay.aspx", false);
        }
        catch (Exception ex)
        {
            LogError("Default.aspx", "DThGuests", DateTime.Now, ex.Message.ToString());
            throw ex;
        }
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        try
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.ListOfAmounts;

            _objMasters.OperatorType = ddloperators.SelectedValue;
            _objMasters.NetworkName =ddlProvider.SelectedValue;
            _objMasters.A_Amount =Convert.ToDecimal(txtRechargeAmount.Text);
            //_objMasters.TalkTime = Convert.ToDecimal(txtTalkTime.Text);

            _objDataSet = (DataSet)_objMasters.fnGetData();
            if (_objDataSet.Tables[0].Rows.Count > 0)
            {
                DataView dv = _objDataSet.Tables[0].DefaultView;
                dv.RowFilter = "NetworkName ='" + ddlProvider.SelectedValue + "' and RechargeAmount='" +txtRechargeAmount.Text.ToString() +"'";
                if (dv.Count > 0)
                {
                    lblmessage.Visible = true;
                    lblmessage.Text = "Already You have added This amount for this network,please add another amount";
                    lblmessage.ForeColor = Color.Red;
                }
                else
                {
                    if (_objMasters.fnInsertRecord() == true)
                    {
                        lblmessage.ForeColor = Color.Green;
                        lblmessage.Text = "Record saved successfully.";
                        ddlProvider.SelectedIndex = 0;
                        txtRechargeAmount.Text = string.Empty;
                        //txtTalkTime.Text = string.Empty;
                        ddlProvider.SelectedIndex = 0;
                        ddloperators.SelectedIndex = 0;
                        fnLoadPage1();

                    }
                    else
                    {
                        lblmessage.Text = "Insertion Failed";
                    }
                }
            }
            else
            {
                if (_objMasters.fnInsertRecord() == true)
                {
                    lblmessage.ForeColor = Color.Green;
                    lblmessage.Text = "Record saved successfully.";
                    ddlProvider.SelectedIndex = 0;
                    txtRechargeAmount.Text = string.Empty;
                    //txtTalkTime.Text = string.Empty;
                    ddlProvider.SelectedIndex = 0;
                    ddloperators.SelectedIndex = 0;
                    fnLoadPage1();

                }
                else
                {
                    lblmessage.Text = "Insertion Failed";
                }
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
Example #11
0
    protected void btnDepositUpdate_Click(object sender, EventArgs e)
    {
        try
        {
            ClsBAL objBAL = new ClsBAL();
            System.Data.DataSet ds1 = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString()));
            string balance = ds1.Tables[0].Rows[0]["Balance"].ToString();
            if ((Convert.ToDecimal(balance)) > ((Convert.ToDecimal(txtDepositAmount.Text.ToString()) + 25)))
            {

                if ((Convert.ToDecimal(txtDepositAmount.Text.ToString()) >= Convert.ToDecimal("1000"))
                    && (Convert.ToDecimal(txtDepositAmount.Text.ToString())) <= Convert.ToDecimal("25000"))
                {

                    clsMasters _objmasters = new clsMasters();
                    _objmasters.ScreenInd = Masters.Dmr;
                    _objmasters.Amount1 = (Convert.ToDecimal(txtDepositAmount.Text.ToString()));
                    _objmasters.ExtraCharges = Convert.ToDecimal("25");
                    _objmasters.Date = txtChequeIssueDate.Text.ToString();
                    _objmasters.Accountholdername = txtholdername.Text;
                    _objmasters.Accountnumber = txtaccountnumber.Text;
                    _objmasters.IFSCCode = ifsccode.Text;
                    _objmasters.BankName = txtbankname.Text;
                    _objmasters.BranchName = txtbranchname.Text;
                    _objmasters.SenderName = txtsendername.Text;
                    _objmasters.MobileNumber = txtMobileNumber.Text;
                    _objmasters.Status = "No";
                    _objmasters.CreatedBy = Session["UserID"].ToString();

                    ClsBAL objBAL1 = new ClsBAL();
                    System.Data.DataSet ds = objBAL1.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString()));

                    _objmasters.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["AgentId"].ToString());

                    if (_objmasters.fnInsertRecord() == true)
                    {
                        lblmsg.Text = "Your request submitted  succesfully.";
                        lblmsg.ForeColor = System.Drawing.Color.Green;
                        ClsBAL objBAL2 = new ClsBAL();
                        System.Data.DataSet ds2 = objBAL2.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString()));
                        Session["Balance"] = ds2.Tables[0].Rows[0]["Balance"].ToString();

                        Label lbl = (Label)this.Master.FindControl("lblBalance");
                        lbl.Text = Session["Balance"].ToString();

                    //    ClsBAL objBal1 = new ClsBAL();
                    //    string msg = objBal1.DeductAgentDeposit(Convert.ToInt32(Session["UserID"].ToString())
                    //, Convert.ToDouble(txtDepositAmount.Text.ToString()), "", Convert.ToInt32(Session["UserID"].ToString())
                    //, "Dmr", "", "");
                    }
                }
                else
                {
                    lblmsg.Text = "Your transaction amount should be minimum 1000 and maximum 25000.";
                    lblmsg.ForeColor = System.Drawing.Color.Red;
                }

            }
            else
            {
                lblmsg.Text = "Your balance  should be greater than the transfer amount. ";
                lblmsg.ForeColor = System.Drawing.Color.Red;
            }

        }
        catch (Exception ex)
        {
            lblmsg.Text = ex.Message;
            lblmsg.ForeColor = System.Drawing.Color.Red;
        }
    }
    protected void imgbtnGuest2Data_Click(object sender, EventArgs e)
    {
        try
        {
            int check;
            _objMaster = new clsMasters();
            _objMaster.ScreenInd = Masters.gettimeforusers;
            _objMaster.MobileNum = TextBox123.Text.Trim();
            _objMaster.Parameter = "DataCard";
            _objDataSet = new DataSet();
            _objDataSet = (DataSet)_objMaster.fnGetData();

            if (_objDataSet.Tables[0].Rows.Count == 0)
            {

                _objMaster.ScreenInd = Masters.DataCard;
                Session["RMobileNumber"] = TextBox123.Text.Trim();
                Session["RProviderName"] = ddlNetConnect.SelectedItem.Value;
                Session["REmailMobile"] = txtEmailnet.Text.Trim();
                // Session["RRechargeAmount"] = Convert.ToDouble(txtRechargeAmount.Text.Trim());
                Session["RRechargeAmount"] = Convert.ToDouble(ddlDatacardRechargeAmount.Text.Trim());
                lblOrderID.Text = GenerateRandomNumber(11);
                Session["Order_Id"] = lblOrderID.Text;

                #region inserting
                _objMaster = new clsMasters();
                _objMaster.ScreenInd = Masters.DataCard;
                _objMaster.Mobile = TextBox123.Text.Trim();
                _objMaster.UserID = Convert.ToInt32(Session["UserID"]);
                if (Session["Role"].ToString() == "CSE")
                {
                    if (chkdataonbehalfof.Checked == true)
                    {
                        ListItem value = ddlagentnameDTCD.Items.FindByText(txtagentnameDTCD.Text.ToString());
                        if (value != null)
                        {
                            ddlagentnameDTCD.SelectedItem.Value = value.Value;
                            _objMaster.UserID = Convert.ToInt32(ddlagentnameDTCD.SelectedValue);
                            Session["AgentId_Agent"] = ddlagentnameDTCD.SelectedItem.Value;
                        }
                        else
                        {

                        }
                        _objMaster.Type = "AG";
                    }
                    else
                    {
                        _objMaster.Type = "CSE";
                    }
                }
                else if (Session["Role"].ToString() == "Admin")
                {
                    _objMaster.Type = "AD";
                }
                else if (Session["Role"].ToString() == "User")
                {
                    _objMaster.Type = "User";
                }
                else if (Session["Role"].ToString() == "Distributor")
                {
                    _objMaster.Type = "Distributor";
                }
                _objMaster.Provider_Name = ddlNetConnect.SelectedItem.Value;
                _objMaster.E_Mail = txtEmailnet.Text.Trim();
                //_objMaster.Amount = Convert.ToDouble(txtRechargeAmount.Text.Trim());
                _objMaster.Amount = Convert.ToDouble(ddlDatacardRechargeAmount.Text.Trim());
                _objMaster.Payment = "Deposit";
                _objMaster.RequestID = lblOrderID.Text.Trim();
                _objMaster.TransactionID = Convert.ToString(1111);
                _objMaster.IP = ipaddr;
                _objMaster.Status = "PENDING";
                _objMaster.CreatedBy = "NA";
                _objMaster.ModifiedBy = "NA";
                _objMaster.ModifiedDate = "NA";
                _objMaster.fnInsertRecord();
                #endregion

                //getbalance();
                if (Session["Role"].ToString() == "User")
                {
                    Response.Redirect("~/Pay.aspx", false);
                }
                else if (Session["Role"].ToString() == "Distributor")
                {
                    if (Convert.ToDecimal(Session["AgentBalance"].ToString()) > Convert.ToInt32(Session["RRechargeAmount"]))
                    {
                        lbllowbalance.Text = "";
                         DataCardRecharge();
                    }
                    else
                    {
                        mpeagentdatacard.Show();
                        lbldacdLowbalance.Visible = true;
                        lbldacdLowbalance.Text = "Insufficient funds to recharge";
                        lbldacdLowbalance.ForeColor = Color.Red;
                    }

                }
                else if (Session["Role"].ToString() == "Admin")
                {
                    adminDataCardRecharge();
                }
                else if (Session["Role"].ToString() == "CSE")
                {

                    adminDataCardRecharge();
                }

            }
            else if (_objDataSet.Tables[0].Rows.Count > 0)
            {
                check = Convert.ToInt32(_objDataSet.Tables[0].Rows[0]["Allow"]);
                if (check > 0)
                {
                    _objMaster.ScreenInd = Masters.DataCard;
                    Session["RMobileNumber"] = TextBox123.Text.Trim();
                    Session["RProviderName"] = ddlNetConnect.SelectedItem.Value;
                    Session["REmailMobile"] = txtEmailnet.Text.Trim();
                    // Session["RRechargeAmount"] = Convert.ToDouble(txtRechargeAmount.Text.Trim());
                    Session["RRechargeAmount"] = Convert.ToDouble(ddlDatacardRechargeAmount.Text.Trim());

                    lblOrderID.Text = GenerateRandomNumber(11);
                    Session["Order_Id"] = lblOrderID.Text;
                    #region inserting

                    _objMaster = new clsMasters();
                    _objMaster.ScreenInd = Masters.DataCard;
                    _objMaster.Mobile = TextBox123.Text.Trim();
                    _objMaster.UserID = Convert.ToInt32(Session["UserID"]);

                    if (Session["Role"].ToString() == "CSE")
                    {
                        if (chkdataonbehalfof.Checked == true)
                        {
                            ListItem value = ddlagentnameDTCD.Items.FindByText(txtagentnameDTCD.Text.ToString());
                            if (value != null)
                            {
                                ddlagentnameDTCD.SelectedItem.Value = value.Value;
                                _objMaster.UserID = Convert.ToInt32(ddlagentnameDTCD.SelectedValue);
                                Session["AgentId_Agent"] = ddlagentnameDTCD.SelectedItem.Value;
                            }
                            else
                            {

                            }
                            _objMaster.Type = "AG";
                        }
                        else
                        {
                            _objMaster.Type = "CSE";
                        }
                    }
                    else if (Session["Role"].ToString() == "Admin")
                    {
                        _objMaster.Type = "AD";
                    }
                      else if (Session["Role"].ToString() == "User")
                {
                    _objMaster.Type = "User";
                }
                    else if (Session["Role"].ToString() == "Distributor")
                    {
                        _objMaster.Type = "Distributor";
                    }
                    _objMaster.Provider_Name = ddlNetConnect.SelectedItem.Value;
                    _objMaster.E_Mail = txtEmailnet.Text.Trim();
                    //  _objMaster.Amount = Convert.ToDouble(txtRechargeAmount.Text.Trim());
                    _objMaster.Amount = Convert.ToDouble(ddlDatacardRechargeAmount.Text.Trim());
                    _objMaster.Payment = "Deposit";
                    _objMaster.RequestID = lblOrderID.Text.Trim();
                    _objMaster.TransactionID = Convert.ToString(1111);
                    _objMaster.IP = ipaddr;
                    _objMaster.Status = "PENDING";
                    _objMaster.CreatedBy = "NA";
                    _objMaster.ModifiedBy = "NA";
                    _objMaster.ModifiedDate = "NA";
                    _objMaster.fnInsertRecord();
                    #endregion
                    //getbalance();
                    if (Session["Role"].ToString() == "User")
                    {
                        Response.Redirect("~/Pay.aspx", false);
                    }
                    else if (Session["Role"].ToString() == "Distributor")
                    {
                        if (Convert.ToDecimal(Session["AgentBalance"].ToString()) > Convert.ToInt32(Session["RRechargeAmount"]))
                        {
                            lbllowbalance.Text = "";
                             DataCardRecharge();
                        }
                        else
                        {
                            mpeagentdatacard.Show();
                            lbldacdLowbalance.Visible = true;
                            lbldacdLowbalance.Text = "Insufficient funds to recharge";
                            lbldacdLowbalance.ForeColor = Color.Red;
                        }

                    }
                    else if (Session["Role"].ToString() == "Admin")
                    {
                         adminDataCardRecharge();
                    }
                    else if (Session["Role"].ToString() == "CSE")
                    {

                        adminDataCardRecharge();
                    }

                }
                else
                {
                    lblMessage.Text = "please Try Again after 15 minutes";
                    Mpe1.Show();
                }
            }
        }
        catch (Exception ex)
        {
            //LogError("Masters/Recharge.aspx", "imgbtnGuest2Data_Click", DateTime.Now, ex.Message.ToString());
            throw ex;
        }
    }