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