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"; } } } }
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"; } }
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(); } } }
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"; } } } } }
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'" + // " <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'> 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>"</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); } } }
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 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"); } } } }
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) { } }
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 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 getpopularrechargesDTH() { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.GetTarrif; _objMasters.OperatorsID = Convert.ToInt32(ddlpopDTH.SelectedValue); _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { lbldthpop.Text = ""; gvdthpopo.DataSource = _objDataSet.Tables[0]; gvdthpopo.DataBind(); gvdthpopo.Visible = true; } else { lbldthpop.Text = "No data found"; lbldthpop.Visible = true; lblmsg.ForeColor = Color.Red; gvdthpopo.Visible = false; } } else { lbldthpop.Text = "No data found"; gvdthpopo.Visible = false; } } else { gvdthpopo.Visible = false; lbldthpop.Text = "No data found"; } } catch (Exception ex) { } }
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 AllRecharges() { lblMobileMsg.Text = ""; lblDataCardmsg.Text = ""; lblDataCardmsg.Text = ""; gvD2HRecharge.Visible = false; gvDataCardRecharge.Visible = false; gvMobile.Visible = true; paging.Visible = false; gvMobile.DataSource = null; gvMobile.DataBind(); lblMobileMsg.Text = string.Empty; lblTotalAmount.Text = string.Empty; lblTotalProfit.Text = string.Empty; lblD2HMsg.Visible = false; Label4dataCommi.Visible = false; Label4D2hComm.Visible = false; Label3DEH.Visible = false; lblTotalProfit.Visible = true; lblTotalAmount.Visible = true; 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())) { lblMobileMsg.Text = "From Date should be less than To Date"; return; } else { _objMasters.ScreenInd = Masters.GetAgentAllReports; _objMasters.From = dt.ToString(); _objMasters.To = dt1.ToString(); _objMasters.UserID = Convert.ToInt32(Session["UserID"]); _objMasters.Parameter = "Mobile"; _objDataSet = (DataSet)_objMasters.fnGetData(); ViewState["MobileData"] = _objDataSet.Tables[0]; if (_objDataSet.Tables[0].Rows.Count > 0) { paging.Visible = true; gvMobile.DataSource = _objDataSet.Tables[0]; gvMobile.DataBind(); } else { paging.Visible = false; lblMobileMsg.Text = "No Numbers are Recharged between " + txtDF.Text + " and " + txtDT.Text; return; } } } 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 txtMobile_TextChanged(object sender, EventArgs e) { clsMasters _objmasters = new clsMasters(); _objmasters.ScreenInd = Masters.GetOpeartorByMobileSeries; string Mobile = txtMobile.Text.Trim(); string prefix = Mobile.Substring(0, 4); _objmasters.Parameter = prefix; _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]["MobileOperator"].ToString() == "") { } else { ddlProvider.SelectedValue = _objDataSet.Tables[0].Rows[0]["MobileOperator"].ToString(); } } } } }
protected void LoadDropdown2() { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.operatorsname2; _objDataSet = new DataSet(); _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables[0].Rows.Count > 0) { ddlNetConnect.DataSource = _objDataSet.Tables[0]; ddlNetConnect.DataTextField = "NetworkName"; ddlNetConnect.DataValueField = "OperatorKeyword"; ddlNetConnect.DataBind(); ddlNetConnect.Items.Insert(0, "Please Select"); } } } catch (Exception ex) { throw ex; } }
protected void loadDropdown() { //HttpWebRequest request = (HttpWebRequest)WebRequest.Create // ("http://api.buysmart.co.in/hydrasales/services/thirdpartyapi.asmx/ListProducts?GUID=" + "FCC4FE618FD28CE4" + "&basketID=" + "10"); //request.Method = "GET"; //HttpWebResponse response = (HttpWebResponse)request.GetResponse(); //DataSet ds = null; //if (response.StatusCode == HttpStatusCode.OK) //{ // StreamReader responseReader = new StreamReader(response.GetResponseStream()); // string responseData = responseReader.ReadToEnd(); // XmlDocument doc = new XmlDocument(); // doc.LoadXml(responseData); // XmlNodeReader xmlReader = new XmlNodeReader(doc); // ds = new DataSet(); // ds.ReadXml(xmlReader); // DataTable dt = new DataTable(); // dt = ds.Tables["Prod"]; // dt.DefaultView.Sort = "ProductName ASC"; // ddlProvider.DataSource = dt.DefaultView; // ddlProvider.DataTextField = "ProductName"; // ddlProvider.DataValueField = "ProductID"; // ddlProvider.DataBind(); // Session["ProductsList"] = ds.Tables["Prod"]; // ddlProvider.Items.Insert(0, "Please Select"); //} try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.operatorsname; _objDataSet = new DataSet(); _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables[0].Rows.Count > 0) { ddlProvider.DataSource = _objDataSet.Tables[0]; ddlProvider.DataTextField = "NetworkName"; ddlProvider.DataValueField = "OperatorKeyword"; ddlProvider.DataBind(); ddlProvider.Items.Insert(0, "Please Select"); } } } 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; } }
private void fnLoadPageDTH() { 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) { ddlpopDTH.DataSource = _objDataSet.Tables[0]; ddlpopDTH.DataValueField = "OperatorsID"; ddlpopDTH.DataTextField = "OperatorsName"; ddlpopDTH.DataBind(); ddlpopDTH.Items.Insert(0, "Please Select"); if (ddlD2HProvider.SelectedValue != "Please Select") { DataTable dt = _objDataSet.Tables[0]; DataRow[] dr = dt.Select("OperatorsName = '" + ddlD2HProvider.SelectedItem.Text + "'"); DataTable dt1 = new DataTable(); dt1.Columns.Add("OperatorsID"); dt1.Columns.Add("OperatorsName"); foreach (DataRow row in dr) { dt1.ImportRow(row); } ddlpopDTH.SelectedValue = dt1.Rows[0]["OperatorsID"].ToString(); } } 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 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 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 DataCardRecharge() { try { getip(); string MobileNumber, Provider, balance, Email; _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.getagentDatacardrecharge; _objMasters.Parameter = "RequestID"; _objMasters.RequestID = Session["Order_Id"].ToString(); _objDataSet = new DataSet(); _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables.Count > 0) { 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(); //-----------Gettinh the commission of agent for a network----- // _objMaster = new clsMasters(); _objMaster.ScreenInd = Masters.GetCommisionByNetwork; _objMaster.NetworkName = Session["NetWorkName"].ToString(); if (Session["Role"].ToString() == "Agent") { _objMaster.Type = "AG"; } _objMaster.UserID = Convert.ToInt32(Session["UserID"].ToString()); _objDataSet = (DataSet)_objMaster.fnGetData(); if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { Commission = Convert.ToDecimal(_objDataSet.Tables[0].Rows[0]["AgentCommission"].ToString()); } } decimal rechargeAmount = Convert.ToDecimal(Session["RRechargeAmount"]); decimal DeductAmountOnCommission = (rechargeAmount * Commission) / (100); decimal deductamount = rechargeAmount - DeductAmountOnCommission; //----------end------- # region Mobile code string all = "10118" + Session["Order_Id"] + Session["RProviderName"] + "|" + Session["RMobileNumber"] + "|" + Session["RRechargeAmount"] + "A8JW8FX7KQ7PY5ZT2S1V"; string pwhash = FormsAuthentication.HashPasswordForStoringInConfigFile(all, "sha1"); HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://www.payintegra.com/RechargeService"); request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; string postData = "PartnerId=10118&TransId=" + Session["Order_Id"] + "&Message=" + Session["RProviderName"] + "|" + Session["RMobileNumber"] + "|" + Session["RRechargeAmount"] + "&Hash=" + pwhash; byte[] bytes = Encoding.UTF8.GetBytes(postData); request.ContentLength = bytes.Length; Stream requestStream = request.GetRequestStream(); requestStream.Write(bytes, 0, bytes.Length); WebResponse response = request.GetResponse(); Stream stream = response.GetResponseStream(); StreamReader reader = new StreamReader(stream); var result = reader.ReadToEnd(); string[] s = result.Split('|'); stream.Dispose(); reader.Dispose(); if (s[0].ToString().Trim() == "100" && s[4].ToString().Trim() == "Transaction Successful") { #region Insert Data into Database //getstatus(); //if (Session["GetStatus"].ToString() == "Success ") //{ AdminiBalance(); Session["TranscationId"] = s[1].ToString(); _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.getrecharge3; _objMasters.Parameter = "update"; _objMasters.RequestID = Session["Order_Id"].ToString(); _objMasters.TransactionID = Convert.ToString(s[1].ToString()); Session["TransactionID"] = Convert.ToString(s[1].ToString()); _objMasters.Amount = Convert.ToDouble(balance); _objMasters.UserID = Convert.ToInt32(Session["UserID"]); _objMasters.AgentCommission = DeductAmountOnCommission; _objMasters.Status = "SUCCESS"; Session["Status"] = "Recharge successfully"; _objMasters.IP = ipaddr; _objMasters.A_Amount = Convert.ToDecimal(Session["FinalAdminBalance"].ToString()); if (_objMasters.fnUpdateRecord() == true) { Mpe1.Show(); 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'" + " <img src='http://lovejourney.in/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"] + " " + "& Your request Id is " + "" + Session["Order_Id"] + " </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'> 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>"</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'> </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.lovejourney.in</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.lovejourney.in'>lovejourney.in</a> " + "<br /><br />"; MailSender.SendEmail("*****@*****.**", "*****@*****.**", "*****@*****.**", "LoveJourney-Recharge", body); } catch (Exception ex) { //LogError("redirect.aspx", "Mail", DateTime.Now, ex.Message.ToString()); // Response.Redirect("Error.aspx", false); } try { //string strUrl = "http://sms.i2space.in/WebServiceSMS.aspx?User=i2space1&passwd=smsc&mobilenumber=" + MobileNumber + //"&message= Thank You for using lovejourney.in to Recharge Mobile no" + MobileNumber + " for Rs" + " " + balance + "& your order Num is" + "" + Session["TransactionID"] + "" + "for Queries ,Email us at [email protected]" + //"&sid=LoveJourney&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); } //_objMaster = new clsMasters(); //_objMaster.ScreenInd = Masters.deductagentbalance; //_objMaster.UserID = Convert.ToInt32(Session["UserID"]); //_objMaster.A_Amount = deductamount; //_objMaster.fnUpdateRecord(); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(deductamount), Convert.ToInt32(Session["UserID"].ToString()), Session["TransactionID"].ToString().Trim(), Convert.ToDouble(Session["RRechargeAmount"].ToString()), Convert.ToDouble(DeductAmountOnCommission), Convert.ToInt32(Session["CommisionPercentage_Agent"].ToString())); objBAL = new ClsBAL(); DataSet dsBalanceA = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); string balanceAgent = dsBalanceA.Tables[0].Rows[0]["Balance"].ToString(); Label lbl = (Label)this.Master.FindControl("lblBalance"); lbl.Text = balanceAgent; Session["Balance"] = balanceAgent; Response.Redirect("~/Agent/Recharge/RechargeSucces.aspx", false); #endregion } // } } else { AdminiBalance(); _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.getrecharge3; _objMasters.Parameter = "update"; _objMasters.RequestID = Session["Order_Id"].ToString(); _objMasters.TransactionID = Convert.ToString(s[1].ToString()); Session["TransactionID"] = Convert.ToString(s[1].ToString()); _objMasters.Amount = Convert.ToDouble(balance); _objMasters.UserID = Convert.ToInt32(Session["UserID"]); _objMasters.Status = "Failure"; Session["Status"] = "Recharge Failure"; _objMasters.A_Amount = Convert.ToDecimal(Session["FinalAdminBalance"].ToString()); _objMasters.IP = ipaddr; Session["errorcode"] = s[0].ToString(); Session["errorDecsription"] = s[4].ToString(); _objMasters.fnUpdateRecord(); Response.Redirect("~/Agent/Recharge/Failure.aspx", false); } } } else { Mpe1.Show(); lblMessage.Text = "Recharge Has Been Failed Please Try Again Later"; } #endregion } else { Mpe1.Show(); lblMessage.Text = "Recharge Has Been Failed Please Try Again Later"; } } catch (Exception ex) { //LogError("Masters/Recharge.aspx", "DataCardRecharge", DateTime.Now, ex.Message.ToString()); throw ex; } }