public void checkUser()
    {
        if (txtEmailID1.Text != "")
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.UserName;
            _objMasters.EmailID = txtEmailID1.Text.Trim();
            _objDataSet = (DataSet)_objMasters.fnGetData();
            DataTable dt = _objDataSet.Tables[0];
            if (dt.Rows.Count > 0)
            {

                lblMsg1.Text = "User name is not available";
                lblMsg1.ForeColor = Color.Red;
                lblMsg1.Visible = true;
                Checked = "null";
                // MpeSignUP.Show();
            }
            else
            {
                lblMsg1.ForeColor = Color.Blue;
                lblMsg1.Text = "User name is available";
                Checked = "available";
            }
        }
        else
        {
            lblMsg1.Text = "Please Enter Email ID";
            lblMsg1.ForeColor = Color.Red;
            lblMsg1.Visible = true;
            Checked = "null";
        }
    }
    protected void FlightgetGuestDetails()
    {
        _objMasters = new clsMasters();
        _objMasters.ScreenInd = Masters.GetFlights1;
        _objMasters.RequestID = Convert.ToString(Session["Order_Id"]);
        _objDataSet = new DataSet();
        _objDataSet = (DataSet)_objMasters.fnGetData();

        if (_objDataSet != null)
        {
            if (_objDataSet.Tables.Count > 0)
            {
                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    Name = _objDataSet.Tables[0].Rows[0]["Customer_Details"].ToString();
                    address = _objDataSet.Tables[0].Rows[0]["address"].ToString();
                    string[] name = Name.ToString().Split('|');
                    Name = name[0].ToString() + name[1].ToString();

                    string[] add = address.ToString().Split(',');

                    State = add[1].ToString();
                    City = add[0].ToString();
                    PostalCode = add[3].ToString();
                    Email = _objDataSet.Tables[0].Rows[0]["emailAddress"].ToString();
                    Mobilenumber = _objDataSet.Tables[0].Rows[0]["telephone"].ToString();
                    Country = add[2].ToString();
                    //  address = add[0].ToString();
                    val = "true";
                }
            }
        }
    }
    protected void btnSavePermissions_Click(object sender, EventArgs e)
    {
        try
        {
            foreach (GridViewRow row in gvstopservices.Rows)
            {
                _objmasters = new clsMasters();
                Label lblScrnID = (Label)row.FindControl("lblScreenID");
                Label lblScrnName = (Label)row.FindControl("lblScreenName");
                CheckBox ChkAdd1 = (CheckBox)row.FindControl("ChkAdd");
                _objmasters.ScreenInd = Masters.Getservices;
                _objmasters.ID = Convert.ToInt32(lblScrnID.Text.Trim());
                if (ChkAdd1.Checked == true)
                {
                    _objmasters.Status = "1";
                }
                else
                {
                    _objmasters.Status = "0";
                }
                if (_objmasters.fnUpdateRecord() == true)
                {
                    lblmsg.Text = "Selected services Stopped succesfully";
                    lblmsg.Visible = true;
                    lblmsg.ForeColor = System.Drawing.Color.Green;
                }
            }

        }
        catch (Exception ex)
        {
        }
    }
    public void D2HRecharge()
    {
        lblMobileMsg.Text = ""; lblDataCardmsg.Text = ""; lblD2HMsg.Text = "";
        gvD2HRecharge.Visible = true;
        gvDataCardRecharge.Visible = false;
        gvMobile.Visible = false;
        paging.Visible = false;
        gvD2HRecharge.DataSource = null;
        gvD2HRecharge.DataBind();
        lblD2HMsg.Text = string.Empty;

        Label4dataCommi.Visible = false;
        Label4D2hComm.Visible = true;
        Label3DEH.Visible = true;

        lblTotalProfit.Visible = false;
        lblTotalAmount.Visible = false;

        try
        {
            if (DateTime.Parse(txtDF.Text.Trim().ToString()) > DateTime.Parse(txtDT.Text.Trim().ToString()))
            {
                lblD2HMsg.Text = "From Date should be less than To Date";
                return;
            }
            else
            {
                _objMasters = new clsMasters();
                _objMasters.ScreenInd = Masters.GetAgentOnly;
                _objMasters.From = txtDF.Text.Trim().ToString();
                _objMasters.To = txtDT.Text.Trim().ToString();
                _objMasters.UserID = Convert.ToInt32(Session["UserID"]);
                _objMasters.Parameter = "DTH";
                _objDataSet = (DataSet)_objMasters.fnGetData();
                ViewState["D2HData"] = _objDataSet.Tables[0];

                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    paging.Visible = true;
                    gvD2HRecharge.DataSource = _objDataSet.Tables[0];
                    gvD2HRecharge.DataBind();
                }
                else
                {
                    Label3DEH.Visible = false;
                    Label4D2hComm.Visible = false;
                    paging.Visible = false;
                    lblD2HMsg.Visible = true;
                    lblD2HMsg.Text = "No Numbers are Recharged between " + txtDF.Text + " and  " + txtDT.Text;
                    return;
                }
            }
        }
        catch
        {

        }
    }
    public void D2HRecharge()
    {
        paging.Visible = false;
           // gvD2HRecharge.DataSource = null;
          //  gvD2HRecharge.DataBind();
        lblD2HMsg.Text = string.Empty;

        try
        {
            _objMasters = new clsMasters();
            dt = DateTime.Parse(txtDF.Text, CultureInfo.GetCultureInfo("en-gb"));
            dt = Convert.ToDateTime(dt.ToShortDateString());

            dt1 = DateTime.Parse(txtDT.Text, CultureInfo.GetCultureInfo("en-gb"));
            dt1 = Convert.ToDateTime(dt1.ToShortDateString());

            if (DateTime.Parse(dt.ToString()) > DateTime.Parse(dt1.ToString()))
            {
                lblD2HMsg.Text = "From Date should be less than To Date";
                gvD2HRecharge.Visible = false;
                return;
            }
            else
            {

                _objMasters.ScreenInd = Masters.VisitorsReportd2h;
                _objMasters.From12 = Convert.ToDateTime(dt.ToString());
                _objMasters.To12 = Convert.ToDateTime(dt1.ToString());
               // _objMasters.UserID = Convert.ToInt32(Session["RechargeUserID"]);
                _objMasters.Parameter = "D2H";

                _objDataSet = (DataSet)_objMasters.fnGetData();
                ViewState["D2HData"] = _objDataSet.Tables[0];

                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    paging.Visible = true;
                    gvD2HRecharge.Visible = true;
                    gvD2HRecharge.DataSource = _objDataSet.Tables[0];
                    gvD2HRecharge.DataBind();
                }
                else
                {
                    paging.Visible = false;
                    lblD2HMsg.Visible = true;
                    lblD2HMsg.Text = "No Numbers are Recharged between " + txtDF.Text + " and  " + txtDT.Text;
                    return;
                }
            }
        }
        catch
        {

        }
    }
    public void fnLoadPage1()
    {
        try
        {

            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.AgentCommission;

            if (Session["Role"].ToString() == "Admin")
            {
                _objMasters.Type = "AD";
                _objMasters.DistributorID = Convert.ToInt32(Session["UserID"].ToString());
            }
            else if (Session["Role"].ToString() == "DB")
            {
                _objMasters.Type = "AG";
                _objMasters.DistributorID = Convert.ToInt32(Session["UserID"].ToString());
            }

            _objDataSet = (DataSet)_objMasters.fnGetData();

            if (_objDataSet.Tables[0].Rows.Count > 0)
            {
                gvOperators.DataSource = _objDataSet.Tables[0];
                gvOperators.DataBind();
                ViewState["OperatorName"] = _objDataSet.Tables[0];
                btnUpdate.Visible = false;
                btnDelete.Visible = false;
                btnCancel.Visible = false;
                btnAdd.Visible = true;
            }

        }
        catch (Exception ex)
        {
          //  LogError("Masters_frmOperatorNameaspx.aspx", "fnLoadPage", DateTime.Now, ex.Message.ToString());
          //  Response.Redirect("../Error.aspx", false);
            //Logger.Log(Logger.LogType.Log_In_DB, ex,true);
            //Logger.Log(ex, Session["APRUserName"].ToString());
            lblmessage.Text = ex.Message;
        }
        finally
        {
            _objMasters = null;
            if (_objDataSet != null)
            {
                _objDataSet.Dispose();
            }
        }
    }
 protected void AddAmountoUserswhenRechargefailed()
 {
     try
     {
         _objMaster = new clsMasters();
         _objMaster.ScreenInd = Masters.AddAmounttoUsersRechargeFailed;
         _objMaster.amountewallet = Convert.ToDecimal(Session["RRechargeAmount"].ToString());
         _objMaster.UserID = Convert.ToInt32(Session["UserID"].ToString());
         _objMaster.fnUpdateRecord();
     }
     catch (Exception ex)
     {
       //  LogError("redirect.aspx", "AddAmountoUserswhenRechargefailed", DateTime.Now, ex.Message.ToString());
     }
 }
    private void fnLoadPage()
    {
        try
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.getoperators;
            _objDataSet = (DataSet)_objMasters.fnGetData();
            if (_objDataSet != null)
            {
                if (_objDataSet.Tables.Count > 0)
                {
                    if (_objDataSet.Tables[0].Rows.Count > 0)
                    {
                        ddlProvider.DataSource = _objDataSet.Tables[0];
                        ddlProvider.DataValueField = "OperatorsID";
                        ddlProvider.DataTextField = "OperatorsName";
                        ddlProvider.DataBind();
                        ddlProvider.Items.Insert(0, "Please Select");

                    }
                    else
                    {
                        lblmsg.Text = "No data found";
                    }
                }
                else
                {
                    lblmsg.Text = "No data found";
                }
            }
            else
            {
                lblmsg.Text = "No data found";
            }
        }
        catch (Exception ex)
        {

        }
        finally
        {
            _objMasters = null;
            if (_objDataSet != null)
            {
                _objDataSet.Dispose();
            }
        }
    }
    protected void btnRegister_Click(object sender, EventArgs e)
    {
        try
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.GetTarrif;
            _objMasters.OperatorsID = Convert.ToInt32(ddlProvider.SelectedValue);
            _objDataSet = (DataSet)_objMasters.fnGetData();
            if (_objDataSet != null)
            {
                if (_objDataSet.Tables.Count > 0)
                {
                    if (_objDataSet.Tables[0].Rows.Count > 0)
                    {
                        lblmsg.Text = "";
                        gvMobile.DataSource = _objDataSet.Tables[0];
                        gvMobile.DataBind();
                        gvMobile.Visible = true;

                    }
                    else
                    {
                        lblmsg.Text = "No data found";
                        lblmsg.Visible = true;
                        lblmsg.ForeColor = Color.Red;
                        gvMobile.Visible = false;
                    }
                }
                else
                {
                    lblmsg.Text = "No data found";
                    gvMobile.Visible = false;
                }
            }
            else
            {
                gvMobile.Visible = false;
                lblmsg.Text = "No data found";
            }
        }
        catch (Exception ex)
        {

        }
    }
    public void checkUser()
    {
        try
        {

            if (txtEmailID1.Text != "")
            {
                _objMasters = new clsMasters();
                _objMasters.ScreenInd = Masters.UserName;
                _objMasters.EmailID = txtEmailID1.Text.Trim();
                _objDataSet = (DataSet)_objMasters.fnGetData();
                DataTable dt = _objDataSet.Tables[0];
                if (dt.Rows.Count > 0)
                {

                    lblMsg1.Text = "User name is not available";
                    lblMsg1.ForeColor = Color.Red;
                    lblMsg1.Visible = true;
                    Checked = "null";
                    // MpeSignUP.Show();
                }
                else
                {
                    lblMsg1.ForeColor = Color.Blue;
                    lblMsg1.Text = "User name is available";
                    Checked = "available";
                }
            }
            else
            {
                lblMsg1.Text = "Please Enter Email ID";
                lblMsg1.ForeColor = Color.Red;
                lblMsg1.Visible = true;
                Checked = "null";
            }
        }
        catch (Exception ex)
        {
            LogError("Default.aspx", "CheckUser", DateTime.Now, ex.Message.ToString());
            Response.Redirect("Error.aspx", false);
        }
    }
    public void fnLoadPage1()
    {
        try
        {

            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.ListOfAmounts;
            _objDataSet = (DataSet)_objMasters.fnGetData();

            if (_objDataSet != null)
            {

                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    gvOperators.DataSource = _objDataSet.Tables[0];
                    gvOperators.DataBind();
                    ViewState["OperatorName"] = _objDataSet.Tables[0];
                    btnUpdate.Visible = false;
                    btnDelete.Visible = false;
                    btnCancel.Visible = false;
                    btnAdd.Visible = true;
                }
            }

        }
        catch (Exception ex)
        {
           // LogError("Masters_frmOperatorNameaspx.aspx", "fnLoadPage", DateTime.Now, ex.Message.ToString());
            Response.Redirect("../Error.aspx", false);
            //Logger.Log(Logger.LogType.Log_In_DB, ex,true);
            //Logger.Log(ex, Session["APRUserName"].ToString());
        }
        finally
        {
            _objMasters = null;
            if (_objDataSet != null)
            {
                _objDataSet.Dispose();
            }
        }
    }
 public void checkAgent()
 {
     try
     {
         if (txtEmailIDAgent.Text != "")
         {
             _objMasters = new clsMasters();
             _objMasters.ScreenInd = Masters.AgentName;
             _objMasters.EmailID = txtEmailIDAgent.Text.Trim();
             _objDataSet = (DataSet)_objMasters.fnGetData();
             DataTable dt = _objDataSet.Tables[0];
             if (dt.Rows.Count > 0)
             {
                 lblmsg.Text = "EmailId is already exists";
                 lblmsg.ForeColor = Color.Red;
                 lblmsg.Visible = true;
                 Checked = "null";
             }
             else
             {
                 lblmsg.ForeColor = Color.Green;
                 lblmsg.Text = "EmailId is Available";
                 lblmsg.Visible = true;
                 Checked = "Available";
             }
         }
         else
         {
             lblmsg.Text = "Please Enter Email ID";
             lblmsg.ForeColor = Color.Red;
             lblmsg.Visible = true;
             Checked = "null";
         }
     }
     catch (Exception ex)
     {
         LogError("AgentLogin", "checkUser", DateTime.Now, ex.Message.ToString());
         Response.Redirect("Error.aspx", false);
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         _objMasters = new clsMasters();
         _objMasters.ScreenInd = Masters.gettopcontent;
         //_objMasters.Content = "Hi";
         _objDataSet = (DataSet)_objMasters.fnGetData();
         if (_objDataSet != null)
         {
             if (_objDataSet.Tables[0].Rows.Count > 0)
             {
                 if (_objDataSet.Tables[0].Rows[0]["Content"].ToString() != "")
                 {
                     lblContent.Text = _objDataSet.Tables[0].Rows[0]["Content"].ToString();
                 }
                 else
                 {
                     lblContent.Text = "There is no information";
                 }
             }
         }
     }
 }
    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 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 Page_Load(object sender, EventArgs e)
        {
            string sQS;
            //string[] aQS;
            //string lsDetail1, lsDetail2, lsDetail;
               // string pwd = "ebskey";
               string pwd = "91fd335602ba035c96e9ec6f427082aa";

            string DR = Request.QueryString["DR"].ToString();

               // string DR = "IXc9laP5EPzkG8rJUEkT9GPYZKb+340d1KINeq1DJAbrqc5GeRs3RVwRJ7YShbNZUyaxTmSW46lexsfKVHpZGaEckYB8lZxGvToGUG9WVbC2b86UjHu125hgs12+1Ql5j0PVxNN9JqB32SFu+2e9n2eDeWfaVS3KZKnENgwdth3GL8LGG3rbDq5YXYEfOxqAYAmvoOTNxuyHt+yBl6uKqGOdRsToe5dPnIXXo1zBh8q2asX6Rj7jd/xOFtrZV+uhlq1kYZdvUrREXZz6/P0QxRAZioRGzjf1AyYhXA6i/NgCKixXHSR3r15FScNIqyb74SeGq19oOSp5+lDqFGZZfz8Vb+tGJYxSwOFM4Og362rqjHd+YvQpFSIwl0MUInW5PZprjS0zGMmSMOIpnUNDXuevflzn1yRkTgGztwdakfplA6k1118CerVjt6K2c1z4grA936AdbSW2JkQEnyp0krr3GAOV+v3ug6l1WDyPdyN+vvaWAhJAgxd15QpuDVeZ1uTvO42XjjFPetnskmtzyNZH0GmWSjQo91f7/dqV4kpgLOCe//iVmnTbws23K8ueosn6Pbh4jgGix0wRXgySz2Nw0xXwHDEsdKZSIuLOVyxn3Zdx5JzdAseuc/P2vzH8xDCJ6GVcvD+7eeyv1+ZqAnOpT26eJ3vIPskxVWiSePXpMiZUSY4RcL6K3Gy+j+O3Ib4uZ85XbrzJ0e+yT4pcv8q7KQWb02vJ/0iD25HrSlCpNkE3lcxctoASzz1sZ48CLg==";

            DR = DR.Replace(' ', '+');
            sQS = Base64Decode(DR);
            DR = RC4.Decrypt(pwd, sQS, false);
            Session["DR"] = DR.ToString();

            if (Session["DR"] != null)
            {
                string str = Session["DR"].ToString();
                string[] words = str.Split('&');

                string msgid1 = words[0].ToString();
               // ResponseCode = msgid1.Substring(msgid1.IndexOf("ResponseCode=") + 13, 1);

                ResponseCode = msgid1.Substring(13).ToString().Trim();

                string msgid2 = words[1].ToString();
               // ResponseMessage = msgid2.Substring(msgid2.IndexOf("ResponseMessage=") + 16, 22);

                ResponseMessage = msgid2.Substring(16).ToString().Trim();

                string msgid5 = words[4].ToString();
                //MerchantRefNo = msgid5.Substring(msgid5.IndexOf("MerchantRefNo=") + 14, 11);

                MerchantRefNo = msgid5.Substring(14).ToString().Trim();

                //string msgid6 = words[23].ToString();
                //IsFlagged = msgid6.Substring(msgid6.IndexOf("IsFlagged=") + 10, 2);

                Session["Ticketrefno"] = Session["Order_Id"] = MerchantRefNo.ToString();

                if (ResponseMessage == "Transaction Successful" && ResponseCode == "0")
                {
                    //_objMaster = new clsMasters();
                    //_objMaster.ScreenInd = Masters.Ewalletbyrequestid;
                    //_objMaster.RequestID = Session["Order_Id"].ToString();
                    //_objDataSet = (DataSet)_objMaster.fnGetData();
                    //if (_objDataSet != null)
                    //{
                    //    if (_objDataSet.Tables.Count > 0)
                    //    {
                    //        if (_objDataSet.Tables[0].Rows.Count > 0)
                    //        {
                    //            Session["Ewallet"] = _objDataSet.Tables[0].Rows[0]["Type"].ToString();
                    //        }
                    //    }
                    //}

                    //if (Session["Ewallet"].ToString() == "null")
                    //{

                    if (MerchantRefNo.Contains("LJIF"))
                    {
                        Response.Redirect("~/frmIntFlightsAvailability.aspx", false);
                    }
                    else if (MerchantRefNo.Contains("LJC"))
                    {
                        Session["refno"] = Session["Order_Id"].ToString();
                        Response.Redirect("~/CarTicket.aspx", false);
                    }

                    else if (MerchantRefNo.Contains("LJH"))
                    {
                        Session["HotelRefNo"] = Session["Order_Id"].ToString();
                        Response.Redirect("~/HotelTicket.aspx", false);
                    }

                    else if (MerchantRefNo.Contains("LJDF"))
                    {

                        _objMasters = new clsMasters();
                        _objMasters.ScreenInd = Masters.GetFlights1;
                        _objMasters.RequestID = Convert.ToString(Session["Order_Id"]);
                        _objDataSet = new DataSet();
                        _objDataSet = (DataSet)_objMasters.fnGetData();

                        if (_objDataSet != null)
                        {
                            if (_objDataSet.Tables.Count > 0)
                            {
                                if (_objDataSet.Tables[0].Rows.Count > 0)
                                {
                                    if (_objDataSet.Tables[0].Rows[0]["Type"].ToString() == "Guest")
                                    {
                                        ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('" + "Domestic flights 1111" + "');</script>", false);

                                        Response.Redirect("~/frmFlightsAvailability.aspx", false);
                                    }
                                    else
                                    {
                                        Response.Redirect("~/frmFlightsAvailability.aspx", false);
                                    }

                                }
                            }
                        }
                    }
                    else if (MerchantRefNo.Contains("LJB"))
                    {
                        Response.Redirect("~/redirectbus.aspx?Refno=" + MerchantRefNo.ToString(), false);
                    }
                    else if (MerchantRefNo.Contains("RVPG"))
                    {
                        // Response.Redirect("~/Agent/Bus/AddBalance.aspx?status=Yes", false);
                    }
                    else
                    {
                        // Response.Redirect("~/Rechargemethods.aspx", false);
                    }

                    //}
                    //else if (Session["Ewallet"].ToString() == "Ewallet")
                    //{
                    //    Session["Status12"] = "Y";
                    //    //Response.Redirect("~/User/EWallet.aspx", false);
                    //}
                }
                //else if (ResponseMessage == "Transaction Successful" && ResponseCode == "0")
                //{
                //    Session["IsFlagged"] = "Yes";
                //    Response.Redirect("~/Default.aspx", false);
                //}
                else
                {
                    Session["Transaction"] = "Failure";
                    Response.Redirect("~/Default.aspx", false);
                }
            }
        }
Example #17
0
        public AvailableTrips getAvailableRoutes(int sourceId, int destinationId, String dateOfJourney, String URL, String ConsumerKey, int ProviderID)
        {
            try
            {
                dateOfJourney = dateOfJourney.Split('-')[2] + "-" + dateOfJourney.Split('-')[1] + "-" + dateOfJourney.Split('-')[0];
                if (File.Exists(Path.Combine(HttpRuntime.AppDomainAppPath, "Routes\\" + dateOfJourney + ".xml")))
                {
                    DataSet ds = new DataSet();
                    ds.ReadXml(Path.Combine(HttpRuntime.AppDomainAppPath, "Routes\\" + dateOfJourney + ".xml"));
                    if (ds != null && ds.Tables.Count > 0 && ds.Tables["route"].Rows.Count > 0)
                    {
                        objAvailableTrips = new AvailableTrips();
                        DataView dv = ds.Tables["route"].DefaultView;
                        dv.RowFilter = "origin_id=" + sourceId + "and destination_id=" + destinationId;
                        foreach (DataRowView item in dv)
                        {
                            //add the routes that match with given source and destinations
                            if (int.Parse(item["origin_id"].ToString()) == sourceId && int.Parse(item["destination_id"].ToString()) == destinationId)
                            {
                                LJ.CLB.DTO.TripDetails objTripDetails = new DTO.TripDetails();
                                objTripDetails.providerName = "BITLA";
                                objTripDetails.arrivalTime = CalculateArrivalTime(item["dep_time"].ToString(), item["duration"].ToString());
                                objTripDetails.availableSeats = item["available_seats"].ToString();
                                //boardingTimes are fetched in seat layout
                                objTripDetails.busType = item["bus_type"].ToString();
                                //cancellationPolicy  is not valid for bitla
                                objTripDetails.cancellationPolicy = String.Empty;
                                objTripDetails.departureTime = item["dep_time"].ToString();
                                //droppingTimes are fetched in seat layout
                                objTripDetails.duration = item["duration"].ToString();
                                objTripDetails.fares = item["fare_str"].ToString();
                                objTripDetails.id = item["reservation_id"].ToString();
                                objTripDetails.partialCancellationAllowed = item["is_cancellable"].ToString();
                                objTripDetails.travels = item["travels"].ToString();
                                objTripDetails.sourceId = int.Parse(item["origin_id"].ToString());
                                objTripDetails.destinationId = int.Parse(item["destination_id"].ToString());
                                trip.Add(objTripDetails);
                            }
                        }

                    }
                    //ignore operator list
                    clsMasters obj = new clsMasters();
                    DataSet dsignore = obj.GetIgnoreList(ProviderID);
                    if (dsignore != null)
                    {
                        if (dsignore.Tables[0].Rows.Count > 0)
                        {
                            foreach (DataRow row in dsignore.Tables[0].Rows)
                            {
                                trip = trip.Where(e => e.travels != row[3].ToString()).ToList();
                            }

                        }

                    }
                    foreach (var bt in trip)
                    {
                        LJ.CLB.DTO.TripDetails objTripDetails = new DTO.TripDetails();
                        objTripDetails.providerName = "BITLA";
                        objTripDetails.arrivalTime = CalculateArrivalTime(bt.departureTime.ToString(), bt.duration.ToString());
                        objTripDetails.availableSeats = bt.availableSeats.ToString();
                        //boardingTimes are fetched in seat layout
                        objTripDetails.busType = bt.busType.ToString();
                        //cancellationPolicy  is not valid for bitla
                        objTripDetails.cancellationPolicy = String.Empty;
                        objTripDetails.departureTime = bt.departureTime.ToString();
                        //droppingTimes are fetched in seat layout
                        objTripDetails.duration = bt.duration.ToString() + " hrs";
                        objTripDetails.fares = bt.fares.ToString();
                        objTripDetails.id = bt.id.ToString();
                        objTripDetails.partialCancellationAllowed = bt.partialCancellationAllowed.ToString();
                        objTripDetails.travels = bt.travels.ToString();
                        objTripDetails.sourceId = int.Parse(bt.sourceId.ToString());
                        objTripDetails.destinationId = int.Parse(bt.destinationId.ToString());
                        objAvailableTrips.Add(objTripDetails);
                    }
                }

                return objAvailableTrips;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
 protected void BindDisAgents()
 {
     _objMasters = new clsMasters();
     _objMasters.ScreenInd = Masters.GetDistributorsList;
     _objMasters.DistributorID = Convert.ToInt32(Session["RechargeUserID"].ToString());
     _objMasters.Parameter = "getagentsbydistributorsId";
     _objDataSet = (DataSet)_objMasters.fnGetData();
     if (_objDataSet != null)
     {
         if (_objDataSet.Tables.Count > 0)
         {
             if (_objDataSet.Tables[0].Rows.Count > 0)
             {
                 ddlName.DataSource = _objDataSet.Tables[0];
                 ddlName.DataValueField = "UserID";
                 ddlName.DataTextField = "FirstName";
                 ddlName.DataBind();
                 ddlName.Items.Insert(0, "Please Select");
             }
             else
             {
                 ddlName.Items.Clear();
                 ddlName.Items.Insert(0, "Please Select");
             }
         }
     }
 }
    private void BindAgents()
    {
        try
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.GetAgentApprovedList;
            _objDataSet = (DataSet)_objMasters.fnGetData();
            if (_objDataSet != null)
            {
                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    ddlName.DataSource = _objDataSet.Tables[0];
                    ddlName.DataValueField = "UserID";
                    ddlName.DataTextField = "FirstName";
                    ddlName.DataBind();
                    ddlName.Items.Insert(0, "Please Select");
                    // ddlAgentName.SelectedIndex = 0;

                }
            }
        }
        catch (Exception ex)
        {

        }
        finally
        {
            _objMasters = null;
            if (_objDataSet != null)
            {
                _objDataSet.Dispose();
            }
        }
    }
    protected void ddlProvider_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (Session["Role"].ToString() == "Admin")
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.GetAdminCommission;
            _objMasters.Type = "AD";

            _objMasters.NetworkName = ddlProvider.SelectedItem.Text;

            _objDataSet = (DataSet)_objMasters.fnGetData();
            if (_objDataSet.Tables.Count > 0)
            {
                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    lblpercentage.Text = _objDataSet.Tables[0].Rows[0]["AgentCommission"].ToString() + "%";
                }
                else
                {
                    lblpercentage.Text = "0.00" + "%";
                }
            }
            else
            {
                lblpercentage.Text = "0.00" + "%";
            }

        }
        else if (Session["Role"].ToString() == "DB")
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.getdisCommission;
            _objMasters.Type = "DB";

            _objMasters.NetworkName = ddlProvider.SelectedValue;
            _objMasters.DistributorID = Convert.ToInt32(Session["RechargeUserID"].ToString());
            _objDataSet = (DataSet)_objMasters.fnGetData();
            if (_objDataSet.Tables.Count > 0)
            {
                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    lblpercentage.Text = _objDataSet.Tables[0].Rows[0]["AgentCommission"].ToString() + "%";
                }
                else
                {
                    lblpercentage.Text = "0.00" + "%";
                }
            }
            else
            {
                lblpercentage.Text = "0.00" + "%";
            }
        }
    }
    protected void getlogindetails()
    {
        try
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.loginDetails;
            _objMasters.UserID = Convert.ToInt32(Session["UserID"].ToString());

            if (txtDate.Text == "")
            {
                txtDate.Text = "1/1/1900";
            }
            if (txttodate.Text == "")
            {
                txttodate.Text = "1/1/1900";
            }

            _objMasters.From12 =Convert.ToDateTime(txtDate.Text);
            _objMasters.To12 = Convert.ToDateTime(txttodate.Text);
            _objDataset = (DataSet)_objMasters.fnGetData();
            if (_objDataset != null)
            {
                if (_objDataset.Tables.Count > 0)
                {
                    if (_objDataset.Tables[0].Rows.Count > 0)
                    {
                        gvLoginHistory.DataSource = _objDataset.Tables[0];
                        gvLoginHistory.DataBind();
                        ViewState["LoginHistory"] = _objDataset.Tables[0];
                        gvLoginHistory.Visible = true;
                        lblmsg.Visible = false;
                        trpaging.Visible = true;
                    }
                    else
                    {
                        lblmsg.Text = "No Data Found";
                        lblmsg.ForeColor = System.Drawing.Color.Red;
                        lblmsg.Visible = true;
                        gvLoginHistory.Visible = false;
                        trpaging.Visible = false;
                    }
                }
                else
                {
                    trpaging.Visible = false;
                    lblmsg.Text = "No Data Found";
                    lblmsg.ForeColor = System.Drawing.Color.Red;
                    lblmsg.Visible = true;
                }
            }
            else
            {
                trpaging.Visible = false;
                lblmsg.Text = "No Data Found";
                lblmsg.ForeColor = System.Drawing.Color.Red;
                lblmsg.Visible = true;
            }
            if (txtDate.Text == "1/1/1900")
            {
                txtDate.Text = "";
            }
            if (txttodate.Text == "1/1/1900")
            {
                txttodate.Text = "";
            }

        }
        catch (Exception ex)
        {
            lblmsg.Text = ex.Message;
            lblmsg.ForeColor = System.Drawing.Color.Red;
            lblmsg.Visible = true;
        }
    }
 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 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 ddlType_SelectedIndexChanged(object sender, EventArgs e)
    //{
    //    if(ddlType.SelectedValue == "DB")
    //    {
    //        BindDistributors();
    //    }
    //    else if(ddlType.SelectedValue == "AG")
    //    {
    //       BindAgents();
    //    }
    //}
    protected void BindDistributors()
    {
        _objMasters = new clsMasters();
        _objMasters.ScreenInd = Masters.GetDistributorsList;
        _objMasters.Parameter = "getdistributorslist";
        _objDataSet = (DataSet)_objMasters.fnGetData();
        if (_objDataSet != null)
        {
            if (_objDataSet.Tables.Count > 0)
            {
                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    ddlName.DataSource = _objDataSet.Tables[0];
                    ddlName.DataTextField = "FirstName";
                    ddlName.DataValueField = "UserID";
                    ddlName.DataBind();

                    ddlName.Items.Insert(0, "Please Select");
                }

                else
                {
                    ddlName.Items.Insert(0, "Please Select");
                }
            }
            else
            {

            }
        }
    }
    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();

        }
    }
 protected void ddloperators_SelectedIndexChanged(object sender, EventArgs e)
 {
     try
     {
         _objMasters = new clsMasters();
         _objMasters.ScreenInd = Masters.GetNetworkName;
         _objMasters.OperatorType = ddloperators.SelectedItem.Text;
         _objDataSet = (DataSet)_objMasters.fnGetData();
         if (_objDataSet.Tables.Count > 0)
         {
             if (_objDataSet.Tables[0].Rows.Count > 0)
             {
                 ddlProvider.DataSource = _objDataSet.Tables[0];
                 ddlProvider.DataValueField = "OperatorsID";
                 ddlProvider.DataTextField = "OperatorsName";
                 ddlProvider.DataBind();
                 ddlProvider.Items.Insert(0, "Please Select");
             }
             else
             {
                 ddlProvider.Items.Insert(0, "Please Select");
                 ddlProvider.SelectedIndex = 0;
             }
         }
     }
     catch (Exception ex)
     {
     }
 }
        public void fnLocalCities(ref DropDownList ddlFrom, ref DropDownList DDLTo)
        {
            try
            {
                //Load Cities
                _objMasters = new clsMasters();
                _objMasters.ScreenInd = Masters.citilist;
                _objDataSet = (DataSet)_objMasters.fnGetData();

                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    //From DDL
                    ddlFrom.DataSource = _objDataSet.Tables[0];
                    ddlFrom.DataValueField = "ID";
                    ddlFrom.DataTextField = "Name";
                    ddlFrom.DataBind();
                    ddlFrom.Items.Insert(0, "From City");

                    //To DDL
                    DDLTo.DataSource = _objDataSet.Tables[0];
                    DDLTo.DataValueField = "ID";
                    DDLTo.DataTextField = "Name";
                    DDLTo.DataBind();
                    DDLTo.Items.Insert(0, "To City");
                }
            }
            catch (Exception ex)
            {
                //Logger.Log(Logger.LogType.Log_In_DB, ex, true);
            }
            finally
            {
                _objDataSet.Dispose();
            }
        }
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        try
        {
            _objMasters = new clsMasters();

            _objMasters.ScreenInd = Masters.AgentCommission;
            _objMasters.RefID = Convert.ToInt32(lblID.Text.Trim());

            if (_objMasters.fnDeleteRecord() == true)
            {

                lblmessage.ForeColor = Color.Green;
                lblmessage.ForeColor = Color.Green;
                lblmessage.Text = "Record deleted successfully.";
                txtRechargeAmount.Text = string.Empty;
                fnLoadPage1();
                ddlProvider.SelectedIndex = 0;
                txtRechargeAmount.Text = string.Empty;

                ddloperators.SelectedIndex = 0;
            }
            else
            {
                lblmessage.ForeColor = Color.Red;
                lblmessage.ForeColor = Color.Red;
                lblmessage.Text = "Record deletion failed.";
            }
        }
        catch (Exception ex)
        {
            //LogError("Masters_frmOperatorNameaspx", "btnDelete_Click", DateTime.Now, ex.Message.ToString());
            Response.Redirect("../Error.aspx", false);
            //Logger.Log(Logger.LogType.Log_In_DB, ex,true);
            //Logger.Log(ex, Session["APRUserName"].ToString());
        }
        finally
        {
            _objMasters = null;
        }
    }
    protected void getservices()
    {
        try
        {
            val = "false";
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.Getservices;
            _objDataSet = (DataSet)_objMasters.fnGetData();
            if (_objDataSet != null)
            {
                if (_objDataSet.Tables.Count > 0)
                {
                    if (_objDataSet.Tables[0].Rows.Count > 0)
                    {
                        int i;
                        for (i = 0; i < _objDataSet.Tables[0].Rows.Count; i++)
                        {
                            if (_objDataSet.Tables[0].Rows[i]["Services"].ToString() == "International Flights" && _objDataSet.Tables[0].Rows[i]["Status"].ToString() == "1")
                            {
                                val = "true";
                            }
                        }

                    }
                }
            }

        }
        catch (Exception ex)
        {
        }
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        try
        {
            _objMasters = new clsMasters();
            _objMasters.ScreenInd = Masters.AgentCommission;
            _objMasters.RefID = Convert.ToInt32(lblID.Text);

            _objMasters.OperatorType = ddloperators.SelectedValue;
            _objMasters.NetworkName = ddlProvider.SelectedValue;
            _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text);

            if (_objMasters.fnUpdateRecord() == true)
            {
                lblmessage.ForeColor = Color.Green;
                lblmessage.Text = "Record Updated successfully.";
                ddlProvider.SelectedIndex = 0;
                txtRechargeAmount.Text = string.Empty;

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