public void checkUser() { if (txtEmailID1.Text != "") { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.UserName; _objMasters.EmailID = txtEmailID1.Text.Trim(); _objDataSet = (DataSet)_objMasters.fnGetData(); DataTable dt = _objDataSet.Tables[0]; if (dt.Rows.Count > 0) { lblMsg1.Text = "User name is not available"; lblMsg1.ForeColor = Color.Red; lblMsg1.Visible = true; Checked = "null"; // MpeSignUP.Show(); } else { lblMsg1.ForeColor = Color.Blue; lblMsg1.Text = "User name is available"; Checked = "available"; } } else { lblMsg1.Text = "Please Enter Email ID"; lblMsg1.ForeColor = Color.Red; lblMsg1.Visible = true; Checked = "null"; } }
protected void FlightgetGuestDetails() { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.GetFlights1; _objMasters.RequestID = Convert.ToString(Session["Order_Id"]); _objDataSet = new DataSet(); _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { Name = _objDataSet.Tables[0].Rows[0]["Customer_Details"].ToString(); address = _objDataSet.Tables[0].Rows[0]["address"].ToString(); string[] name = Name.ToString().Split('|'); Name = name[0].ToString() + name[1].ToString(); string[] add = address.ToString().Split(','); State = add[1].ToString(); City = add[0].ToString(); PostalCode = add[3].ToString(); Email = _objDataSet.Tables[0].Rows[0]["emailAddress"].ToString(); Mobilenumber = _objDataSet.Tables[0].Rows[0]["telephone"].ToString(); Country = add[2].ToString(); // address = add[0].ToString(); val = "true"; } } } }
protected void btnSavePermissions_Click(object sender, EventArgs e) { try { foreach (GridViewRow row in gvstopservices.Rows) { _objmasters = new clsMasters(); Label lblScrnID = (Label)row.FindControl("lblScreenID"); Label lblScrnName = (Label)row.FindControl("lblScreenName"); CheckBox ChkAdd1 = (CheckBox)row.FindControl("ChkAdd"); _objmasters.ScreenInd = Masters.Getservices; _objmasters.ID = Convert.ToInt32(lblScrnID.Text.Trim()); if (ChkAdd1.Checked == true) { _objmasters.Status = "1"; } else { _objmasters.Status = "0"; } if (_objmasters.fnUpdateRecord() == true) { lblmsg.Text = "Selected services Stopped succesfully"; lblmsg.Visible = true; lblmsg.ForeColor = System.Drawing.Color.Green; } } } catch (Exception ex) { } }
public void D2HRecharge() { lblMobileMsg.Text = ""; lblDataCardmsg.Text = ""; lblD2HMsg.Text = ""; gvD2HRecharge.Visible = true; gvDataCardRecharge.Visible = false; gvMobile.Visible = false; paging.Visible = false; gvD2HRecharge.DataSource = null; gvD2HRecharge.DataBind(); lblD2HMsg.Text = string.Empty; Label4dataCommi.Visible = false; Label4D2hComm.Visible = true; Label3DEH.Visible = true; lblTotalProfit.Visible = false; lblTotalAmount.Visible = false; try { if (DateTime.Parse(txtDF.Text.Trim().ToString()) > DateTime.Parse(txtDT.Text.Trim().ToString())) { lblD2HMsg.Text = "From Date should be less than To Date"; return; } else { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.GetAgentOnly; _objMasters.From = txtDF.Text.Trim().ToString(); _objMasters.To = txtDT.Text.Trim().ToString(); _objMasters.UserID = Convert.ToInt32(Session["UserID"]); _objMasters.Parameter = "DTH"; _objDataSet = (DataSet)_objMasters.fnGetData(); ViewState["D2HData"] = _objDataSet.Tables[0]; if (_objDataSet.Tables[0].Rows.Count > 0) { paging.Visible = true; gvD2HRecharge.DataSource = _objDataSet.Tables[0]; gvD2HRecharge.DataBind(); } else { Label3DEH.Visible = false; Label4D2hComm.Visible = false; paging.Visible = false; lblD2HMsg.Visible = true; lblD2HMsg.Text = "No Numbers are Recharged between " + txtDF.Text + " and " + txtDT.Text; return; } } } catch { } }
public void D2HRecharge() { paging.Visible = false; // gvD2HRecharge.DataSource = null; // gvD2HRecharge.DataBind(); lblD2HMsg.Text = string.Empty; try { _objMasters = new clsMasters(); dt = DateTime.Parse(txtDF.Text, CultureInfo.GetCultureInfo("en-gb")); dt = Convert.ToDateTime(dt.ToShortDateString()); dt1 = DateTime.Parse(txtDT.Text, CultureInfo.GetCultureInfo("en-gb")); dt1 = Convert.ToDateTime(dt1.ToShortDateString()); if (DateTime.Parse(dt.ToString()) > DateTime.Parse(dt1.ToString())) { lblD2HMsg.Text = "From Date should be less than To Date"; gvD2HRecharge.Visible = false; return; } else { _objMasters.ScreenInd = Masters.VisitorsReportd2h; _objMasters.From12 = Convert.ToDateTime(dt.ToString()); _objMasters.To12 = Convert.ToDateTime(dt1.ToString()); // _objMasters.UserID = Convert.ToInt32(Session["RechargeUserID"]); _objMasters.Parameter = "D2H"; _objDataSet = (DataSet)_objMasters.fnGetData(); ViewState["D2HData"] = _objDataSet.Tables[0]; if (_objDataSet.Tables[0].Rows.Count > 0) { paging.Visible = true; gvD2HRecharge.Visible = true; gvD2HRecharge.DataSource = _objDataSet.Tables[0]; gvD2HRecharge.DataBind(); } else { paging.Visible = false; lblD2HMsg.Visible = true; lblD2HMsg.Text = "No Numbers are Recharged between " + txtDF.Text + " and " + txtDT.Text; return; } } } catch { } }
public void fnLoadPage1() { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.AgentCommission; if (Session["Role"].ToString() == "Admin") { _objMasters.Type = "AD"; _objMasters.DistributorID = Convert.ToInt32(Session["UserID"].ToString()); } else if (Session["Role"].ToString() == "DB") { _objMasters.Type = "AG"; _objMasters.DistributorID = Convert.ToInt32(Session["UserID"].ToString()); } _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet.Tables[0].Rows.Count > 0) { gvOperators.DataSource = _objDataSet.Tables[0]; gvOperators.DataBind(); ViewState["OperatorName"] = _objDataSet.Tables[0]; btnUpdate.Visible = false; btnDelete.Visible = false; btnCancel.Visible = false; btnAdd.Visible = true; } } catch (Exception ex) { // LogError("Masters_frmOperatorNameaspx.aspx", "fnLoadPage", DateTime.Now, ex.Message.ToString()); // Response.Redirect("../Error.aspx", false); //Logger.Log(Logger.LogType.Log_In_DB, ex,true); //Logger.Log(ex, Session["APRUserName"].ToString()); lblmessage.Text = ex.Message; } finally { _objMasters = null; if (_objDataSet != null) { _objDataSet.Dispose(); } } }
protected void AddAmountoUserswhenRechargefailed() { try { _objMaster = new clsMasters(); _objMaster.ScreenInd = Masters.AddAmounttoUsersRechargeFailed; _objMaster.amountewallet = Convert.ToDecimal(Session["RRechargeAmount"].ToString()); _objMaster.UserID = Convert.ToInt32(Session["UserID"].ToString()); _objMaster.fnUpdateRecord(); } catch (Exception ex) { // LogError("redirect.aspx", "AddAmountoUserswhenRechargefailed", DateTime.Now, ex.Message.ToString()); } }
private void fnLoadPage() { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.getoperators; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { ddlProvider.DataSource = _objDataSet.Tables[0]; ddlProvider.DataValueField = "OperatorsID"; ddlProvider.DataTextField = "OperatorsName"; ddlProvider.DataBind(); ddlProvider.Items.Insert(0, "Please Select"); } else { lblmsg.Text = "No data found"; } } else { lblmsg.Text = "No data found"; } } else { lblmsg.Text = "No data found"; } } catch (Exception ex) { } finally { _objMasters = null; if (_objDataSet != null) { _objDataSet.Dispose(); } } }
protected void btnRegister_Click(object sender, EventArgs e) { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.GetTarrif; _objMasters.OperatorsID = Convert.ToInt32(ddlProvider.SelectedValue); _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { lblmsg.Text = ""; gvMobile.DataSource = _objDataSet.Tables[0]; gvMobile.DataBind(); gvMobile.Visible = true; } else { lblmsg.Text = "No data found"; lblmsg.Visible = true; lblmsg.ForeColor = Color.Red; gvMobile.Visible = false; } } else { lblmsg.Text = "No data found"; gvMobile.Visible = false; } } else { gvMobile.Visible = false; lblmsg.Text = "No data found"; } } catch (Exception ex) { } }
public void checkUser() { try { if (txtEmailID1.Text != "") { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.UserName; _objMasters.EmailID = txtEmailID1.Text.Trim(); _objDataSet = (DataSet)_objMasters.fnGetData(); DataTable dt = _objDataSet.Tables[0]; if (dt.Rows.Count > 0) { lblMsg1.Text = "User name is not available"; lblMsg1.ForeColor = Color.Red; lblMsg1.Visible = true; Checked = "null"; // MpeSignUP.Show(); } else { lblMsg1.ForeColor = Color.Blue; lblMsg1.Text = "User name is available"; Checked = "available"; } } else { lblMsg1.Text = "Please Enter Email ID"; lblMsg1.ForeColor = Color.Red; lblMsg1.Visible = true; Checked = "null"; } } catch (Exception ex) { LogError("Default.aspx", "CheckUser", DateTime.Now, ex.Message.ToString()); Response.Redirect("Error.aspx", false); } }
public void fnLoadPage1() { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.ListOfAmounts; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables[0].Rows.Count > 0) { gvOperators.DataSource = _objDataSet.Tables[0]; gvOperators.DataBind(); ViewState["OperatorName"] = _objDataSet.Tables[0]; btnUpdate.Visible = false; btnDelete.Visible = false; btnCancel.Visible = false; btnAdd.Visible = true; } } } catch (Exception ex) { // LogError("Masters_frmOperatorNameaspx.aspx", "fnLoadPage", DateTime.Now, ex.Message.ToString()); Response.Redirect("../Error.aspx", false); //Logger.Log(Logger.LogType.Log_In_DB, ex,true); //Logger.Log(ex, Session["APRUserName"].ToString()); } finally { _objMasters = null; if (_objDataSet != null) { _objDataSet.Dispose(); } } }
public void checkAgent() { try { if (txtEmailIDAgent.Text != "") { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.AgentName; _objMasters.EmailID = txtEmailIDAgent.Text.Trim(); _objDataSet = (DataSet)_objMasters.fnGetData(); DataTable dt = _objDataSet.Tables[0]; if (dt.Rows.Count > 0) { lblmsg.Text = "EmailId is already exists"; lblmsg.ForeColor = Color.Red; lblmsg.Visible = true; Checked = "null"; } else { lblmsg.ForeColor = Color.Green; lblmsg.Text = "EmailId is Available"; lblmsg.Visible = true; Checked = "Available"; } } else { lblmsg.Text = "Please Enter Email ID"; lblmsg.ForeColor = Color.Red; lblmsg.Visible = true; Checked = "null"; } } catch (Exception ex) { LogError("AgentLogin", "checkUser", DateTime.Now, ex.Message.ToString()); Response.Redirect("Error.aspx", false); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.gettopcontent; //_objMasters.Content = "Hi"; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables[0].Rows.Count > 0) { if (_objDataSet.Tables[0].Rows[0]["Content"].ToString() != "") { lblContent.Text = _objDataSet.Tables[0].Rows[0]["Content"].ToString(); } else { lblContent.Text = "There is no information"; } } } } }
protected void btnAdd_Click(object sender, EventArgs e) { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.InsertTarrif; // _objDataSet = (DataSet)_objMasters.fnGetData(); _objMasters.OperatorsID =Convert.ToInt32(ddlProvider.SelectedValue); _objMasters.Denomination =Convert.ToInt32( txtDenomination.Text); _objMasters.TalkTime = Convert.ToDecimal(txtTalkTime.Text); _objMasters.Validity = txtValidity.Text; _objMasters.Description = txtDescription.Text; if (_objMasters.fnInsertRecord() == true) { lblmessage.ForeColor = Color.Green; lblmessage.Text = "Record saved successfully."; ddlProvider_SelectedIndexChanged(sender, e); ddlProvider.SelectedIndex = 0; txtDenomination.Text = string.Empty; txtTalkTime.Text = string.Empty; txtValidity.Text = string.Empty; txtDescription.Text = string.Empty; } else { lblmessage.Text = "Insertion Failed"; } } catch(Exception ex) { throw ex; } }
public Boolean MobileRecharge(String CouponNumber, String MobileNumber, Int16 RechargeAmount, String Order_Id, String IPAddr) { Boolean isRechargeSuccess = false; string Provider = String.Empty, balance = String.Empty, Email = String.Empty, requestId = String.Empty; _objMaster = new clsMasters(); _objMaster.ScreenInd = Masters.getrecharge; _objMaster.Parameter = "RequestID"; // _objMaster.RequestID = Session["Order_Id"].ToString(); _objMaster.RequestID = Order_Id.ToString(); _objDataSet = new DataSet(); _objDataSet = (DataSet)_objMaster.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables[0].Rows.Count > 0) { MobileNumber = _objDataSet.Tables[0].Rows[0]["MobileNo"].ToString(); Provider = _objDataSet.Tables[0].Rows[0]["Provider_Name"].ToString(); balance = _objDataSet.Tables[0].Rows[0]["Amount"].ToString(); Email = _objDataSet.Tables[0].Rows[0]["E_Mail"].ToString(); # region Mobile code // requestId = "KAA" + GenerateRandomNumber(11); // string URL = "http://www.bulksel.com/api_reach_bulksel.php?user=kass9378&pass=bus80111&mobileno=918008419101&newid=" + requestId + "&message=BS " + //Provider + " " + MobileNumber + " " + balance; // HttpWebRequest oReq = null; // HttpWebResponse oRes = null; // StreamReader oStream = null; // oReq = (HttpWebRequest)WebRequest.Create(URL); // oReq.Method = "GET"; // oReq.Timeout = 10000; // oRes = (HttpWebResponse)oReq.GetResponse(); // oStream = new StreamReader(oRes.GetResponseStream(), Encoding.GetEncoding(1252)); // string strMessage = oStream.ReadToEnd().ToString(); // Session["strMessage"] = strMessage.ToString(); // string[] s = strMessage.Split('d'); // if (s[0].ToString() == "Request Accepte") // { // #region Insert Data into Database // _objMaster = new clsMasters(); // _objMaster.ScreenInd = Masters.getGuestrecharge1; // _objMaster.Parameter = "update"; // _objMaster.RequestID = Session["Order_Id"].ToString(); // _objMaster.TransactionID = Convert.ToString(s[1].ToString()); // Session["TransactionID"] = Convert.ToString(s[1].ToString()); // _objMaster.IP = IPAddr; // if (_objMaster.fnUpdateRecord() == true) // { // isRechargeSuccess = true; // //lblMessage.Text = "Recharge has Been Success"; // try // { // string body = "<html xmlns='http://www.w3.org/1999/xhtml'><head><title></title></head><body>" + // "<table width='700' border='0' cellspacing='0' cellpadding='0' style='font-family: Verdana;font-size: smaller; margin-left: 1px; margin-right: 1px; padding-bottom: 10px;'><tr>" + // "<td valign='top' width='100%'>" + // "<table width='100%'><tr><td valign='top'" + // " <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); } } }
public AvailableTrips getAvailableRoutes(int sourceId, int destinationId, String dateOfJourney, String URL, String ConsumerKey, int ProviderID) { try { dateOfJourney = dateOfJourney.Split('-')[2] + "-" + dateOfJourney.Split('-')[1] + "-" + dateOfJourney.Split('-')[0]; if (File.Exists(Path.Combine(HttpRuntime.AppDomainAppPath, "Routes\\" + dateOfJourney + ".xml"))) { DataSet ds = new DataSet(); ds.ReadXml(Path.Combine(HttpRuntime.AppDomainAppPath, "Routes\\" + dateOfJourney + ".xml")); if (ds != null && ds.Tables.Count > 0 && ds.Tables["route"].Rows.Count > 0) { objAvailableTrips = new AvailableTrips(); DataView dv = ds.Tables["route"].DefaultView; dv.RowFilter = "origin_id=" + sourceId + "and destination_id=" + destinationId; foreach (DataRowView item in dv) { //add the routes that match with given source and destinations if (int.Parse(item["origin_id"].ToString()) == sourceId && int.Parse(item["destination_id"].ToString()) == destinationId) { LJ.CLB.DTO.TripDetails objTripDetails = new DTO.TripDetails(); objTripDetails.providerName = "BITLA"; objTripDetails.arrivalTime = CalculateArrivalTime(item["dep_time"].ToString(), item["duration"].ToString()); objTripDetails.availableSeats = item["available_seats"].ToString(); //boardingTimes are fetched in seat layout objTripDetails.busType = item["bus_type"].ToString(); //cancellationPolicy is not valid for bitla objTripDetails.cancellationPolicy = String.Empty; objTripDetails.departureTime = item["dep_time"].ToString(); //droppingTimes are fetched in seat layout objTripDetails.duration = item["duration"].ToString(); objTripDetails.fares = item["fare_str"].ToString(); objTripDetails.id = item["reservation_id"].ToString(); objTripDetails.partialCancellationAllowed = item["is_cancellable"].ToString(); objTripDetails.travels = item["travels"].ToString(); objTripDetails.sourceId = int.Parse(item["origin_id"].ToString()); objTripDetails.destinationId = int.Parse(item["destination_id"].ToString()); trip.Add(objTripDetails); } } } //ignore operator list clsMasters obj = new clsMasters(); DataSet dsignore = obj.GetIgnoreList(ProviderID); if (dsignore != null) { if (dsignore.Tables[0].Rows.Count > 0) { foreach (DataRow row in dsignore.Tables[0].Rows) { trip = trip.Where(e => e.travels != row[3].ToString()).ToList(); } } } foreach (var bt in trip) { LJ.CLB.DTO.TripDetails objTripDetails = new DTO.TripDetails(); objTripDetails.providerName = "BITLA"; objTripDetails.arrivalTime = CalculateArrivalTime(bt.departureTime.ToString(), bt.duration.ToString()); objTripDetails.availableSeats = bt.availableSeats.ToString(); //boardingTimes are fetched in seat layout objTripDetails.busType = bt.busType.ToString(); //cancellationPolicy is not valid for bitla objTripDetails.cancellationPolicy = String.Empty; objTripDetails.departureTime = bt.departureTime.ToString(); //droppingTimes are fetched in seat layout objTripDetails.duration = bt.duration.ToString() + " hrs"; objTripDetails.fares = bt.fares.ToString(); objTripDetails.id = bt.id.ToString(); objTripDetails.partialCancellationAllowed = bt.partialCancellationAllowed.ToString(); objTripDetails.travels = bt.travels.ToString(); objTripDetails.sourceId = int.Parse(bt.sourceId.ToString()); objTripDetails.destinationId = int.Parse(bt.destinationId.ToString()); objAvailableTrips.Add(objTripDetails); } } return objAvailableTrips; } catch (Exception ex) { throw ex; } }
protected void BindDisAgents() { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.GetDistributorsList; _objMasters.DistributorID = Convert.ToInt32(Session["RechargeUserID"].ToString()); _objMasters.Parameter = "getagentsbydistributorsId"; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { ddlName.DataSource = _objDataSet.Tables[0]; ddlName.DataValueField = "UserID"; ddlName.DataTextField = "FirstName"; ddlName.DataBind(); ddlName.Items.Insert(0, "Please Select"); } else { ddlName.Items.Clear(); ddlName.Items.Insert(0, "Please Select"); } } } }
private void BindAgents() { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.GetAgentApprovedList; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables[0].Rows.Count > 0) { ddlName.DataSource = _objDataSet.Tables[0]; ddlName.DataValueField = "UserID"; ddlName.DataTextField = "FirstName"; ddlName.DataBind(); ddlName.Items.Insert(0, "Please Select"); // ddlAgentName.SelectedIndex = 0; } } } catch (Exception ex) { } finally { _objMasters = null; if (_objDataSet != null) { _objDataSet.Dispose(); } } }
protected void ddlProvider_SelectedIndexChanged(object sender, EventArgs e) { if (Session["Role"].ToString() == "Admin") { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.GetAdminCommission; _objMasters.Type = "AD"; _objMasters.NetworkName = ddlProvider.SelectedItem.Text; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { lblpercentage.Text = _objDataSet.Tables[0].Rows[0]["AgentCommission"].ToString() + "%"; } else { lblpercentage.Text = "0.00" + "%"; } } else { lblpercentage.Text = "0.00" + "%"; } } else if (Session["Role"].ToString() == "DB") { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.getdisCommission; _objMasters.Type = "DB"; _objMasters.NetworkName = ddlProvider.SelectedValue; _objMasters.DistributorID = Convert.ToInt32(Session["RechargeUserID"].ToString()); _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { lblpercentage.Text = _objDataSet.Tables[0].Rows[0]["AgentCommission"].ToString() + "%"; } else { lblpercentage.Text = "0.00" + "%"; } } else { lblpercentage.Text = "0.00" + "%"; } } }
protected void getlogindetails() { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.loginDetails; _objMasters.UserID = Convert.ToInt32(Session["UserID"].ToString()); if (txtDate.Text == "") { txtDate.Text = "1/1/1900"; } if (txttodate.Text == "") { txttodate.Text = "1/1/1900"; } _objMasters.From12 =Convert.ToDateTime(txtDate.Text); _objMasters.To12 = Convert.ToDateTime(txttodate.Text); _objDataset = (DataSet)_objMasters.fnGetData(); if (_objDataset != null) { if (_objDataset.Tables.Count > 0) { if (_objDataset.Tables[0].Rows.Count > 0) { gvLoginHistory.DataSource = _objDataset.Tables[0]; gvLoginHistory.DataBind(); ViewState["LoginHistory"] = _objDataset.Tables[0]; gvLoginHistory.Visible = true; lblmsg.Visible = false; trpaging.Visible = true; } else { lblmsg.Text = "No Data Found"; lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Visible = true; gvLoginHistory.Visible = false; trpaging.Visible = false; } } else { trpaging.Visible = false; lblmsg.Text = "No Data Found"; lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Visible = true; } } else { trpaging.Visible = false; lblmsg.Text = "No Data Found"; lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Visible = true; } if (txtDate.Text == "1/1/1900") { txtDate.Text = ""; } if (txttodate.Text == "1/1/1900") { txttodate.Text = ""; } } catch (Exception ex) { lblmsg.Text = ex.Message; lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Visible = true; } }
public void LogError(String ScreenName, String MethodName, DateTime Time, String ex) { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.LogError; _objMasters.ScreenName = ScreenName.ToString(); _objMasters.MethodName = MethodName.ToString(); _objMasters.Time = Convert.ToDateTime(Time); _objMasters.Exception = ex.ToString(); _objMasters.fnInsertRecord(); } catch { } }
protected void btnAdd_Click(object sender, EventArgs e) { try { _objMasters = new clsMasters(); _objMasters.OperatorType = ddloperators.SelectedValue; _objMasters.NetworkName = ddlProvider.SelectedItem.Text; _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text); _objMasters.Type = ddlName.SelectedValue; // _objMasters.DistributorID =Convert.ToInt32(ddlName.SelectedValue); _objMasters.ScreenInd = Masters.GetCommisionByNetwork; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables[0].Rows.Count > 0) { DataView dv = _objDataSet.Tables[0].DefaultView; dv.RowFilter = "Type='" + ddlName.SelectedValue + "'and OperatorType='" + ddloperators.SelectedValue + "' and OperatorsName='" + ddlProvider.SelectedItem.Text+"'"; if (dv.Count > 0) { lblmessage.ForeColor = Color.Red; lblmessage.Text = "Already you have given commission for this network,Please try another one."; lblmessage.Visible = true; } else { _objMasters.ScreenInd = Masters.AgentCommission; _objMasters.OperatorType = ddloperators.SelectedValue; _objMasters.NetworkName = ddlProvider.SelectedValue; _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text); _objMasters.Type = ddlName.SelectedValue; if (_objMasters.fnInsertRecord() == true) { lblmessage.ForeColor = Color.Green; lblmessage.Text = "Record saved successfully."; ddlProvider.SelectedIndex = 0; txtRechargeAmount.Text = string.Empty; ddloperators.SelectedIndex = 0; fnLoadPage1(); } else { lblmessage.Text = "Insertion Failed"; } } } else { _objMasters.ScreenInd = Masters.AgentCommission; _objMasters.OperatorType = ddloperators.SelectedValue; _objMasters.NetworkName = ddlProvider.SelectedValue; _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text); _objMasters.Type = ddlName.SelectedValue; if (_objMasters.fnInsertRecord() == true) { lblmessage.ForeColor = Color.Green; lblmessage.Text = "Record saved successfully."; ddlProvider.SelectedIndex = 0; txtRechargeAmount.Text = string.Empty; ddloperators.SelectedIndex = 0; fnLoadPage1(); } else { lblmessage.Text = "Insertion Failed"; } } } else { _objMasters.ScreenInd = Masters.AgentCommission; _objMasters.OperatorType = ddloperators.SelectedValue; _objMasters.NetworkName = ddlProvider.SelectedValue; _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text); _objMasters.Type = ddlName.SelectedValue; if (_objMasters.fnInsertRecord() == true) { lblmessage.ForeColor = Color.Green; lblmessage.Text = "Record saved successfully."; ddlProvider.SelectedIndex = 0; txtRechargeAmount.Text = string.Empty; ddloperators.SelectedIndex = 0; fnLoadPage1(); } else { lblmessage.Text = "Insertion Failed"; } } } catch (Exception ex) { throw ex; } }
//protected void ddlType_SelectedIndexChanged(object sender, EventArgs e) //{ // if(ddlType.SelectedValue == "DB") // { // BindDistributors(); // } // else if(ddlType.SelectedValue == "AG") // { // BindAgents(); // } //} protected void BindDistributors() { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.GetDistributorsList; _objMasters.Parameter = "getdistributorslist"; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { ddlName.DataSource = _objDataSet.Tables[0]; ddlName.DataTextField = "FirstName"; ddlName.DataValueField = "UserID"; ddlName.DataBind(); ddlName.Items.Insert(0, "Please Select"); } else { ddlName.Items.Insert(0, "Please Select"); } } else { } } }
protected void btnSignUp_Click(object sender, EventArgs e) { //if(txtEmailID1.Text =="" || txtFirstName.Text=="" || txtPassword1.Text=="" || txtMobileNum.Text=="" || txtaddress1.Text =="" ||txtState.Text == "" || txtCity.Text=="") //{ // return; //} //else //{ checkUser(); if (Checked == "available") { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.UserMst; _objMasters.EmailID = txtEmailID1.Text.Trim().ToString().ToLower(); _objMasters.FirstName = txtFirstName.Text.Trim(); _objMasters.Password = txtPassword1.Text.Trim().ToString().ToLower(); _objMasters.Mobile_Num = txtMobileNum.Text.Trim(); _objMasters.Address = txtaddress1.Text.Trim(); _objMasters.Statename = txtState.Text.Trim(); _objMasters.cityname = txtCity.Text.Trim(); _objMasters.CountryName = ddlCountry.SelectedValue; _objMasters.PostalCode = txtUserpostalcode.Text.Trim(); if (_objMasters.fnInsertRecord() == true) { lblMsg1.ForeColor = Color.Green; lblMsg2.ForeColor = Color.Green; MpeSignUP.Show(); lblMsg1.Text = "Confirmation: "; lblMsg2.Text = "successfully. Registered"; try { string str = string.Empty; string Body = "Dear <b>" + txtFirstName.Text + "</b>," + "<br /><br />Let us welcome you recharge with lovejourney.in " + "Following are your login details. <br/> <br/>" + " Email ID :<b>" + txtEmailID1.Text.Trim() + "</b><br />" + " Password : <b>" + txtPassword1.Text.Trim() + "</b><br/>" + "<br /><br />you have successfully registered in www.lovejourney.in and please" + "do not hesitate<br /> to write to us at <a href='mailto:[email protected]'>Mail</a> " + " " + "should you have any questions. <br /><br />Best Regards,<br />Administrator <br /> <a href='http://lovejourney.in'> lovejourney.in</a>" + "<br /><br />"; MailSender.SendEmail(txtEmailID1.Text.Trim(), "*****@*****.**", "*****@*****.**", "LoveJourney-login", Body); } catch (Exception ex) { throw ex; } Login(txtEmailID1.Text.Trim().ToString(), txtPassword1.Text.Trim().ToString()); } else { lblMsg1.Text = "<font color='red'> Error Notification: </font>"; lblMsg2.Text = "."; } } else if (Checked == "null") { MpeSignUP.Show(); lblMsg1.Text = "Email ID Already Exists"; lblMsg1.ForeColor = Color.Red; lblMsg1.Visible = true; //lblMessage.Text = "Email ID Already Exists"; //Mpe1.Show(); //Clearfields(); } }
protected void ddloperators_SelectedIndexChanged(object sender, EventArgs e) { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.GetNetworkName; _objMasters.OperatorType = ddloperators.SelectedItem.Text; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { ddlProvider.DataSource = _objDataSet.Tables[0]; ddlProvider.DataValueField = "OperatorsID"; ddlProvider.DataTextField = "OperatorsName"; ddlProvider.DataBind(); ddlProvider.Items.Insert(0, "Please Select"); } else { ddlProvider.Items.Insert(0, "Please Select"); ddlProvider.SelectedIndex = 0; } } } catch (Exception ex) { } }
public void fnLocalCities(ref DropDownList ddlFrom, ref DropDownList DDLTo) { try { //Load Cities _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.citilist; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet.Tables[0].Rows.Count > 0) { //From DDL ddlFrom.DataSource = _objDataSet.Tables[0]; ddlFrom.DataValueField = "ID"; ddlFrom.DataTextField = "Name"; ddlFrom.DataBind(); ddlFrom.Items.Insert(0, "From City"); //To DDL DDLTo.DataSource = _objDataSet.Tables[0]; DDLTo.DataValueField = "ID"; DDLTo.DataTextField = "Name"; DDLTo.DataBind(); DDLTo.Items.Insert(0, "To City"); } } catch (Exception ex) { //Logger.Log(Logger.LogType.Log_In_DB, ex, true); } finally { _objDataSet.Dispose(); } }
protected void btnDelete_Click(object sender, EventArgs e) { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.AgentCommission; _objMasters.RefID = Convert.ToInt32(lblID.Text.Trim()); if (_objMasters.fnDeleteRecord() == true) { lblmessage.ForeColor = Color.Green; lblmessage.ForeColor = Color.Green; lblmessage.Text = "Record deleted successfully."; txtRechargeAmount.Text = string.Empty; fnLoadPage1(); ddlProvider.SelectedIndex = 0; txtRechargeAmount.Text = string.Empty; ddloperators.SelectedIndex = 0; } else { lblmessage.ForeColor = Color.Red; lblmessage.ForeColor = Color.Red; lblmessage.Text = "Record deletion failed."; } } catch (Exception ex) { //LogError("Masters_frmOperatorNameaspx", "btnDelete_Click", DateTime.Now, ex.Message.ToString()); Response.Redirect("../Error.aspx", false); //Logger.Log(Logger.LogType.Log_In_DB, ex,true); //Logger.Log(ex, Session["APRUserName"].ToString()); } finally { _objMasters = null; } }
protected void getservices() { try { val = "false"; _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.Getservices; _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { int i; for (i = 0; i < _objDataSet.Tables[0].Rows.Count; i++) { if (_objDataSet.Tables[0].Rows[i]["Services"].ToString() == "International Flights" && _objDataSet.Tables[0].Rows[i]["Status"].ToString() == "1") { val = "true"; } } } } } } catch (Exception ex) { } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.AgentCommission; _objMasters.RefID = Convert.ToInt32(lblID.Text); _objMasters.OperatorType = ddloperators.SelectedValue; _objMasters.NetworkName = ddlProvider.SelectedValue; _objMasters.AgentCommission = Convert.ToDecimal(txtRechargeAmount.Text); if (_objMasters.fnUpdateRecord() == true) { lblmessage.ForeColor = Color.Green; lblmessage.Text = "Record Updated successfully."; ddlProvider.SelectedIndex = 0; txtRechargeAmount.Text = string.Empty; ddloperators.SelectedIndex = 0; fnLoadPage1(); } else { lblmessage.Text = "Insertion Failed"; } } catch (Exception ex) { throw ex; } }