public Bussiness.AuthResponse GPRSTOWEB(int Mainid, string CustomerMobile, float Amount, string TranPwd) { DataTable dtMob = SqlHelper.GetDataUsingQuery("SELECT TOP 1 MOBILE FROM USERS WHERE MAINID=" + Mainid + ""); if (dtMob.Rows.Count > 0) { string[,] param = { { "KEYWORD", "GBAL" }, { "ACTION", "102" }, { "AMOUNT", Amount.ToString() }, { "PROCMOBILE", CustomerMobile.ToString().Trim() }, { "MOBILE", dtMob.Rows[0]["MOBILE"].ToString() }, { "TRANSPASS", TranPwd.ToString().Trim() }, }; MEMBERS.SQLReturnValue mOVal = ExecuteProcWithMessageValue2("PROCESS_WITH_KEYWORDS1", param, true); if (mOVal.ValueFromSQL > 0) { return(new Bussiness.AuthResponse(1, mOVal.MessageFromSQL1)); } else { return(new Bussiness.AuthResponse(0, mOVal.MessageFromSQL)); } } else { return(new Bussiness.AuthResponse(0, "INVALID USERS")); } }
public Bussiness.AuthResponse SaveDTHBooking(DataClass.DataDTHBooking obj) { string[,] param = { { "OperatorCode", obj.OperatorCode.ToString() }, { "ConnectionType", obj.ConnectionType.ToString() }, { "Qty", obj.Qty.ToString() }, { "FirstLanguageId", obj.FirstLanguageId.ToString() }, { "SecoundLanguageId", obj.SecoundLanguageId.ToString() }, { "FirstName", obj.FirstName.ToString() }, { "LastName", obj.LastName.ToString() }, { "EmailID", obj.EmailID.ToString() }, { "MobileNumber1", obj.MobileNumber1.ToString() }, { "MobileNumber2", obj.MobileNumber2.ToString() }, { "StateName", obj.StateName.ToString() }, { "CityName", obj.CityName.ToString() }, { "Pincode", obj.Pincode.ToString() }, { "Address", obj.Address.ToString() }, { "LandMark", obj.LandMark.ToString() }, { "Userlevel", obj.Userlevel.ToString() }, { "Mainid", obj.Mainid.ToString() } }; MEMBERS.SQLReturnValue M = ExecuteProcWithMessageValue("SAVE_DTHBOOKING", param, true); if (M.ValueFromSQL == 1) { return(new Bussiness.AuthResponse(1, M.MessageFromSQL)); } else { return(new Bussiness.AuthResponse(0, M.MessageFromSQL)); } }
public Bussiness.AuthResponse Add_Like(DataClass.Like_DisLikeData obj) { string[,] param = { { "UploadVideoIDF", obj.VideoIDF.ToString() }, { "status", obj.Status.ToString() },{ "UserID", obj.UserID.ToString() } }; MEMBERS.SQLReturnValue M = ExecuteProcWithMessageValue("ADD_LIKE_DISLIKE", param, true); return(new Bussiness.AuthResponse(M.ValueFromSQL, M.MessageFromSQL)); }
public Bussiness.AuthResponse ForgotPassword(DataClass.DataForgotPassword obj) { string[,] param = { { "EmailId", obj.EmailId.ToString() } }; MEMBERS.SQLReturnValue M = ExecuteProcWithMessageValue("Get_ForgetPassword_apps", param, true); if (M.ValueFromSQL == 1) { #region SendForgetwd string MailToUser = @"<table width='600' border='0' align='center' cellpadding='10' cellspacing='0' style='border: 4px solid #01A0E2; font-family: Arial, Helvetica, sans-serif; font-size: 13px;'> <tr> <td height='223' colspan='2' align='center' style='background-image: url(http://apexmedconnect.com/images/belt_bg.jpg); background-repeat: repeat-x; background-position: center;'> <img src='http://livereporting.in/WaterMarkImg/logo-V13.png' title='LiveReporting.in' alt='livereporting' /> </td> </tr> <tr> <td width='196'> <h2 align='center'> Forget Password</h2> <p align='center'> your password is : " + M.MessageFromSQL + @" </p> </td> </tr> </table>"; #endregion SendMail SM = new SendMail(); SM.SendMailForgetIn(obj.EmailId, MailToUser); return(new Bussiness.AuthResponse(1, "Please Confirm that you would link to reset password for the account shown below.we will send your Mail id with password.")); } else { return(new Bussiness.AuthResponse(0, M.MessageFromSQL)); } }
protected void rptData_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandArgument != null) { Int64 AdvertiserPlanIDP = Int64.Parse(e.CommandArgument.ToString()); switch (e.CommandName) { case "cEdit": hfID.Value = AdvertiserPlanIDP.ToString(); DataTable dtAdvertiserPlan = SetPlanInAdvertiserClass.GetAdvertiserPlan_ByID(AdvertiserPlanIDP); if (dtAdvertiserPlan.Rows.Count > 0) { DataRow dr = dtAdvertiserPlan.Rows[0]; ddlAdvertise.SelectedValue = (dr["AdvertiserIDF"].ToString() == "0" ? "-1" : dr["AdvertiserIDF"].ToString()); ddlAdvertisePlan.SelectedValue = (dr["PlanIDF"].ToString() == "0" ? "-1" : dr["PlanIDF"].ToString()); tbPlanStartDate.Text = (!string.IsNullOrEmpty(dr["PlanStartDate"].ToString()) ? Convert.ToDateTime(dr["PlanStartDate"].ToString()).ToString(MyLogic.DateFormat) : ""); tbPlanEndDate.Text = (!string.IsNullOrEmpty(dr["PlanEndDate"].ToString()) ? Convert.ToDateTime(dr["PlanEndDate"].ToString()).ToString(MyLogic.DateFormat) : ""); pnC.Visible = true; pnG.Visible = false; btAddNew.Visible = false; } break; case "cDelete": MEMBERS.SQLReturnValue mRes = SetPlanInAdvertiserClass.DeleteAdvertiserPlan_ByID(AdvertiserPlanIDP); ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true); ClearControls(); BindData(); break; } } }
public Bussiness.AuthResponse SAVE_RETAILER(DataClass.DataRetailer obj, string UserName, string Password) { DataTable dt = SqlHelper.GetDataUsingQuery("SELECT TOP 1 COMM_Id,Slabid FROM USERS WHERE MainId=" + obj.Mainid + " and (MAILID='" + UserName + "' OR MOBILE='" + UserName + "') AND LOGINPASS='******'"); if (dt.Rows.Count > 0) { string[,] param = { { "UNM", obj.Name }, { "ADDRESS", obj.Address }, { "MOBILE", obj.Mobile }, { "MAIL", obj.EmailID }, { "COMMTYPE", dt.Rows[0]["COMM_Id"].ToString() }, { "SLABID", dt.Rows[0]["Slabid"].ToString() }, { "VIA", "2" }, { "UPPERID", obj.UpperID.ToString() }, { "PancardNo", obj.PancardNo.ToString() }, { "GstnNo", obj.GstNo.ToString() }, { "createbyid", obj.Mainid.ToString() } }; MEMBERS.SQLReturnValue mOVal = ExecuteProcWithMessageValue("SAVE_RETAILER", param, true); if (mOVal.ValueFromSQL > 0) { SendSMS.SendSMSFire(obj.Mobile, "DEAR " + obj.Name + " YOUR ACCOUNT HAS BEEN CREATED AS RETAILER.USERNAME IS : " + obj.Mobile + ",PASSWORD IS : " + mOVal.MessageFromSQL + ""); return(new Bussiness.AuthResponse(1, "DEAR " + obj.Name + " YOUR ACCOUNT HAS BEEN CREATED AS RETAILER.USERNAME IS : " + obj.Mobile + ",PASSWORD IS : " + mOVal.MessageFromSQL + "")); } else { return(new Bussiness.AuthResponse(0, mOVal.MessageFromSQL)); } } else { return(new Bussiness.AuthResponse(0, "server internal error.")); } }
protected static MEMBERS.SQLReturnValue ExecuteProcedureReturnValue(string ProcedureName, SqlParameter[] param) { try { MEMBERS.SQLReturnValue returnval = new MEMBERS.SQLReturnValue(); SqlCommand COMMAND = new SqlCommand(); COMMAND.CommandText = ProcedureName; SqlConnection MYCON = new SqlConnection(mConnection.ConnectionString); COMMAND.Connection = MYCON; COMMAND.CommandType = CommandType.StoredProcedure; COMMAND.Parameters.AddRange(param); ///Adds the output parameter COMMAND.Parameters.Add("@OUTVAL", SqlDbType.Int).Direction = ParameterDirection.Output; COMMAND.Parameters.Add("@OUTMESSAGE", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; if (MYCON.State != ConnectionState.Open) { MYCON.Open(); } COMMAND.ExecuteNonQuery(); MYCON.Close(); ///Retrive value from output parameters to return value structure. returnval.MessageFromSQL = COMMAND.Parameters["@OUTMESSAGE"].Value.ToString(); returnval.ValueFromSQL = int.Parse(COMMAND.Parameters["@OUTVAL"].Value.ToString()); return(returnval); } catch (Exception ex) { throw ex; } }
public Bussiness.AuthResponse ChangePassword(DataClass.DataChangePassword obj) { if (obj.PwdType == 1) { editTranpwd = "Editpwd"; } else if (obj.PwdType == 2) { editTranpwd = "EditTranspwd"; } string[,] param = { { "MAINID", obj.Mainid.ToString() }, { "OLDPASS", obj.OldPassword.ToString() }, { "NEWPASS", obj.NewPassword.ToString() }, { "EDITTRANSPWD", editTranpwd.ToString() } }; MEMBERS.SQLReturnValue mOVal = ExecuteProcWithMessageValue("UPDATE_ADMIN_TRANSPASS", param, true); if (mOVal.ValueFromSQL > 0) { return(new Bussiness.AuthResponse(1, mOVal.MessageFromSQL)); } else { return(new Bussiness.AuthResponse(0, mOVal.MessageFromSQL)); } }
protected void btnsignin_Click(object sender, EventArgs e) { if (Session["USERNAME"] == null) { MEMBERS.SQLReturnValue mRes = AdminProfileClass.CheckUserLogin_FrantEndUsers(txtUserName.Text, txtPWD.Text); if (mRes.ValueFromSQL != 0) { Session["USERNAME"] = mRes.MessageFromSQL; MyLogic.GetUserID = mRes.ValueFromSQL.ToString(); if (Session["Upload"] != null) { Session["Upload"] = null; Response.Redirect("upload_video.aspx"); } else { Response.Redirect("Default.aspx"); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('SingIn Failed Please Try Again.',1);", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('SingIn Already Exists.',1);", true); } }
protected void rptData_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandArgument != null) { Int64 RuleIDP = Int64.Parse(e.CommandArgument.ToString()); switch (e.CommandName) { case "cEdit": hfID.Value = RuleIDP.ToString(); DataTable dtGetCity = KnowYourRuleClass.GetKnowYourRule_ByID(RuleIDP); if (dtGetCity.Rows.Count > 0) { DataRow dr = dtGetCity.Rows[0]; tbRuleName.Text = dr["Rules"].ToString(); txtsource.Text = dr["sourcename"].ToString(); cbIsActive.Checked = bool.Parse(dtGetCity.Rows[0]["IsActive"].ToString()); cbIsShow.Checked = bool.Parse(dtGetCity.Rows[0]["IsShow"].ToString()); pnC.Visible = true; pnG.Visible = false; btAddNew.Visible = false; } break; case "cDelete": MEMBERS.SQLReturnValue mRes = KnowYourRuleClass.DeleteKnowYourRule_ByID(RuleIDP); ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true); ClearControls(); BindData(); break; } } }
protected void rptData_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandArgument != null) { Int64 CityIDP = Int64.Parse(e.CommandArgument.ToString()); switch (e.CommandName) { case "cEdit": hfID.Value = CityIDP.ToString(); DataTable dtGetCity = CityClass.GetCity_ByCityIDP(CityIDP); if (dtGetCity.Rows.Count > 0) { tbCityName.Text = dtGetCity.Rows[0]["CityName"].ToString(); cbIsActive.Checked = bool.Parse(dtGetCity.Rows[0]["IsActive"].ToString()); tbPinCode.Text = dtGetCity.Rows[0]["PinCode"].ToString(); ddlState.SelectedValue = (!string.IsNullOrEmpty(dtGetCity.Rows[0]["StateIDF"].ToString()) ? dtGetCity.Rows[0]["StateIDF"].ToString() : "-1"); pnC.Visible = true; pnG.Visible = false; btAddNew.Visible = false; } break; case "cDelete": MEMBERS.SQLReturnValue mRes = CityClass.DeleteCity_ByCityID(CityIDP); ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true); ClearControls(); BindData(); break; } } }
protected void rptData_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandArgument != null) { Int64 ClientIDP = Int64.Parse(e.CommandArgument.ToString()); switch (e.CommandName) { case "cEdit": hfID.Value = ClientIDP.ToString(); DataTable dtGetStaff = ClientClass.GetClient_ByClientID(ClientIDP); if (dtGetStaff.Rows.Count > 0) { DataRow dr = dtGetStaff.Rows[0]; tbFirstName.Text = dr["FirstName"].ToString(); tbLastName.Text = dr["LastName"].ToString(); tbIMEINo.Text = dr["IMEINo"].ToString(); tbEmailID.Text = dr["EmailID"].ToString(); ddlState.SelectedValue = (dr["StateIDF"].ToString() == "0" ? "-1" : dr["StateIDF"].ToString()); Int64 mStateIDF = 0; Int64.TryParse(dr["StateIDF"].ToString(), out mStateIDF); if (mStateIDF > 0) { BindCity(mStateIDF); } ddlCity.SelectedValue = (dr["CityIDF"].ToString() == "0" ? "-1" : dr["CityIDF"].ToString()); tbAddress.Text = dr["Address"].ToString(); tbMobileNo.Text = dr["MobileNo"].ToString(); tbUserName.Text = dr["UserName"].ToString(); tbPassword.Text = dr["Password"].ToString(); cbIsActive.Checked = bool.Parse(dr["IsActive"].ToString()); pnC.Visible = true; pnG.Visible = false; btAddNew.Visible = false; } break; case "cDelete": MEMBERS.SQLReturnValue mRes = ClientClass.DeleteClient_ByClientID(ClientIDP); ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true); ClearControls(); BindData(); break; } } }
public Bussiness.AuthResponse EditMyProfile(DataClass.DataEditProfile obj) { string[,] param = { { "MAINID", obj.Mainid.ToString() }, { "UserName", obj.UserName.ToString() }, { "EmailID", obj.EmailID.ToString() }, { "Address", obj.Address.ToString() } }; MEMBERS.SQLReturnValue mOVal = ExecuteProcWithMessageValue("EDIT_PROFILE", param, true); if (mOVal.ValueFromSQL > 0) { return(new Bussiness.AuthResponse(1, mOVal.MessageFromSQL)); } else { return(new Bussiness.AuthResponse(0, mOVal.MessageFromSQL)); } }
public Bussiness.AuthResponse SaveRechargeTickets(DataClass.DataRechargeTickets obj) { string[,] param = { { "mainid", obj.Mainid.ToString() }, { "req_id", obj.RechargeId.ToString() }, { "tran_type", obj.TicketsId.ToString() }, { "userlevel", obj.Userlevel.ToString() }, { "remark", obj.Remarks.ToString() }, { "archiveid", obj.Archiveid.ToString() } }; MEMBERS.SQLReturnValue M = ExecuteProcWithMessageValue("ADD_TICKET", param, true); if (M.ValueFromSQL == 1) { return(new Bussiness.AuthResponse(1, "Your Ticket has be Successfully Recieved.your Ticket No." + obj.TicketsId.ToString() + " Ticket Date is:" + DateTime.Now.ToString() + "")); } else { return(new Bussiness.AuthResponse(0, M.MessageFromSQL)); } }
public static MEMBERS.SQLReturnValue ExecuteProcWithMessageValue2(string ProcedureName, string[,] ParamValue, bool AddOutputParameters) { SqlConnection MYCON = new SqlConnection(CONNECTION.ConnectionString); try { SqlCommand COMMAND = new SqlCommand(); COMMAND.CommandText = ProcedureName; COMMAND.Connection = MYCON; COMMAND.CommandType = CommandType.StoredProcedure; SqlParameter[] param = new SqlParameter[ParamValue.GetUpperBound(0) + 1]; for (int i = 0; i < param.Length; i++) { param[i] = new SqlParameter("@" + ParamValue[i, 0].ToString(), ParamValue[i, 1].ToString()); } COMMAND.Parameters.AddRange(param); if (AddOutputParameters == true) { COMMAND.Parameters.Add("@OUTMESSAGE1", SqlDbType.VarChar, 5000).Direction = ParameterDirection.Output; COMMAND.Parameters.Add("@OUTMESSAGE", SqlDbType.VarChar, 5000).Direction = ParameterDirection.Output; COMMAND.Parameters.Add("@OUTVAL", SqlDbType.Int).Direction = ParameterDirection.Output; } if (MYCON.State != ConnectionState.Open) { MYCON.Open(); } COMMAND.ExecuteNonQuery(); MYCON.Close(); MEMBERS.SQLReturnValue M = new MEMBERS.SQLReturnValue(); M.MessageFromSQL1 = COMMAND.Parameters["@OUTMESSAGE1"].Value.ToString(); M.MessageFromSQL = COMMAND.Parameters["@OUTMESSAGE"].Value.ToString(); M.ValueFromSQL = int.Parse(COMMAND.Parameters["@OUTVAL"].Value.ToString()); return(M); } catch (Exception ex) { throw ex; } finally { MYCON.Close(); } }
/// <summary> /// Executes the procedure and return output value and message from sql server. /// </summary> /// <param name="ProcedureName">Name of procedure</param> /// <param name="ParamValue">Collection of sql parameters as two dimentional array.</param> /// <returns>Returns Return values from sql procedure.</returns> protected static MEMBERS.SQLReturnValue ExecuteProcedureReturnValue(string ProcedureName, string[,] ParamValue) { SqlConnection MYCON = new SqlConnection(CONNECTION.ConnectionString); try { MEMBERS.SQLReturnValue returnval = new MEMBERS.SQLReturnValue(); SqlCommand COMMAND = new SqlCommand(); COMMAND.CommandText = ProcedureName; COMMAND.Connection = MYCON; COMMAND.CommandType = CommandType.StoredProcedure; SqlParameter[] param = new SqlParameter[ParamValue.GetUpperBound(0) + 1]; for (int i = 0; i < param.Length; i++) { param[i] = new SqlParameter("@" + ParamValue[i, 0].ToString(), ParamValue[i, 1].ToString()); } COMMAND.Parameters.AddRange(param); ///Adds the output parameter COMMAND.Parameters.Add("@OUTVAL", SqlDbType.Int).Direction = ParameterDirection.Output; COMMAND.Parameters.Add("@OUTMESSAGE", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; if (MYCON.State != ConnectionState.Open) { MYCON.Open(); } COMMAND.ExecuteNonQuery(); MYCON.Close(); ///Retrive value from output parameters to return value structure. returnval.MessageFromSQL = COMMAND.Parameters["@OUTMESSAGE"].Value.ToString(); returnval.ValueFromSQL = int.Parse(COMMAND.Parameters["@OUTVAL"].Value.ToString()); return(returnval); } catch (Exception ex) { throw ex; } finally { MYCON.Close(); } }
protected void rptData_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandArgument != null) { Int64 PlanIDP = Int64.Parse(e.CommandArgument.ToString()); switch (e.CommandName) { case "cEdit": hfID.Value = PlanIDP.ToString(); DataTable dtGetPlan = PlanClass.GetPlan_ByPlanID(PlanIDP); if (dtGetPlan.Rows.Count > 0) { DataRow dr = dtGetPlan.Rows[0]; tbPlanTitle.Text = dr["PlanTitle"].ToString(); ddlPlanTypeID.SelectedValue = dr["PlanTypeID"].ToString(); ddlCity.SelectedValue = (dr["CityIDF"].ToString() == "0" ? "-1" : dr["CityIDF"].ToString()); ddlState.SelectedValue = (dr["StateIDF"].ToString() == "0" ? "-1" : dr["StateIDF"].ToString()); tbPlanAmount.Text = dr["PlanAmount"].ToString(); cbIsActive.Checked = bool.Parse(dr["IsActive"].ToString()); pnC.Visible = true; pnG.Visible = false; btAddNew.Visible = false; } break; case "cDelete": MEMBERS.SQLReturnValue mRes = PlanClass.DeletePlan_ByPlanID(PlanIDP); ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true); ClearControls(); BindData(); break; } } }
protected void btLogin_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tbUserName.Text) || string.IsNullOrEmpty(tbPassword.Text)) { lErrMessage.Visible = true; lErrMessage.InnerText = "Enter user name & password first."; } else { MEMBERS.SQLReturnValue mRes = AdminProfileClass.CheckUserLogin(tbUserName.Text, tbPassword.Text, (Int32)MyLogic.UserType.AdminPanel); if (mRes.ValueFromSQL == 0) { lErrMessage.Visible = true; lErrMessage.InnerText = mRes.MessageFromSQL; } else { MyLogic.GetUserID = mRes.MessageFromSQL; MyLogic.GetUserType = ((Int32)MyLogic.UserType.AdminPanel).ToString(); Response.Redirect("Dashboard.aspx"); } } }
public Bussiness.AuthResponse SaveFundRequest(DataClass.DataFundRequest obj) { string[,] param = { { "FUNDREQUESTID", "1" }, { "FAMOUNT", obj.FAmount.ToString() }, { "PAYMENTMODE", obj.PaymentMode.ToString() }, { "TXNPASSWORD", obj.TxnPassword }, { "BANKNAME", obj.BankNameID.ToString() }, { "BRANCH", obj.Branch }, { "CHQEUEDDONLINETYPE", obj.ChqeueDDOnlineType }, { "DATEOFDEPOSITE", obj.DateofDeposite }, { "TIMEOFDEPOSITE", obj.TimeofDeposite }, { "REMARKS", obj.Remarks.ToString() }, { "MAINID", obj.MainId.ToString() } }; MEMBERS.SQLReturnValue M = ExecuteProcWithMessageValue("SAVE_FUNDREQUEST", param, true); if (M.ValueFromSQL == 1) { return(new Bussiness.AuthResponse(1, M.MessageFromSQL)); } else { return(new Bussiness.AuthResponse(0, M.MessageFromSQL)); } }
public Bussiness.AuthResponse ALLRecharge(DataClass.DataDoRecharge obj) { string[,] param = { { "OPCOD", obj.OperatorCode.ToString() }, { "RCTYPE", obj.RecType.ToString() }, { "NUMTORECH", obj.NumberToRecharge.ToString() }, { "AMTTORECH", obj.Amount.ToString() }, { "MAINID", obj.Mainid.ToString() }, { "REQVIA", obj.Via },{ "ConIP", MRServiceClass.IpAddress() }, { "OPTIONALPARAM", string.Empty } }; M = ExecuteProcWithMessageValue("ADD_REQUEST_TO_RECHARGE", param, true); string[] REQ = M.MessageFromSQL.Split(';'); string API = string.Empty, API1 = string.Empty; string ReqId = string.Empty, StatusCode = string.Empty; string TxnID = string.Empty; if (M.ValueFromSQL == 1) { if (REQ[0].Split(':')[2].StartsWith("C"))//----Cyberplate { if (REQ.Length == 4) { API = REQ[1].Split('|')[0]; //-----REQUEST URL API1 = REQ[1].Split('|')[1]; //-----PAY URL } } else { if (REQ.Length == 2) { API = REQ[1];//-----URL API = API.Replace("#DATE#", DateTime.Now.ToString("MM.dd.yyyy hh:mm:ss")); } } } if (API != string.Empty) { string LocalID = string.Empty; if (REQ[0].Split(':')[2].StartsWith("S")) { #region Simple Recharge string RESULT1 = string.Empty; try { LocalID = REQ[0].Split(':')[2].StartsWith("S") ? REQ[0].Split(':')[2].Remove(0, 1) : REQ[0].Split(':')[2]; //---RechargeId System.Net.WebClient Client1 = new System.Net.WebClient(); System.IO.Stream Output1 = Client1.OpenRead(API); System.IO.StreamReader str1 = new System.IO.StreamReader(Output1); RESULT1 = str1.ReadToEnd(); str1.Close(); } catch { return(new Bussiness.AuthResponse(0, "Could not Connect to Server.Pleas Try After Some times.")); } string SRechargeAccountID = Regex.Split(API, "transid=")[1]; if (RESULT1 == "1210" || RESULT1 == "1211" || RESULT1 == "1206") //means request accepted. 1200 status code for 100% accepted. { RechargeModule.Recharge rch = new RechargeModule.Recharge(); rch.TxId = LocalID; rch.rechargeid = Int64.Parse(SRechargeAccountID); rch.Status = 'f'; rch.RechargeVia = 1; MEMBERS.SQLReturnValue V = RechargeModule.UpdateRequests(rch); } #endregion } else if (REQ[0].Split(':')[2].StartsWith("O")) { #region OneAfter string RESULT1 = string.Empty; try { LocalID = REQ[0].Split(':')[2].StartsWith("O") ? REQ[0].Split(':')[2].Remove(0, 1) : REQ[0].Split(':')[2]; //---RechargeId System.Net.WebClient Client1 = new System.Net.WebClient(); System.IO.Stream Output1 = Client1.OpenRead(API); System.IO.StreamReader str1 = new System.IO.StreamReader(Output1); RESULT1 = str1.ReadToEnd(); str1.Close(); string strLog1 = "INSERT INTO LogDetailResponse(logdata) Values('JIO: " + RESULT1 + " Mob:" + obj.NumberToRecharge + "')"; SqlHelper.DML(strLog1); } catch { return(new Bussiness.AuthResponse(0, "Could not Connect to Server.Pleas Try After Some times.")); } RechargeModule.Recharge rch = new RechargeModule.Recharge(); ReqId = Regex.Split(RESULT1, "<reqid>", RegexOptions.IgnoreCase)[1]; ReqId = Regex.Split(ReqId, "</reqid>", RegexOptions.IgnoreCase)[0]; StatusCode = Regex.Split(RESULT1, "<ec>", RegexOptions.IgnoreCase)[1]; StatusCode = Regex.Split(StatusCode, "</ec>", RegexOptions.IgnoreCase)[0]; if (StatusCode == "1000") { TxnID = Regex.Split(RESULT1, "<field1>", RegexOptions.IgnoreCase)[1]; TxnID = Regex.Split(TxnID, "</field1>", RegexOptions.IgnoreCase)[0]; rch.TxId = TxnID; rch.rechargeid = Int64.Parse(LocalID); rch.Status = 'S'; rch.RechargeVia = 1; MEMBERS.SQLReturnValue V = RechargeModule.UpdateRequests(rch); } else if (StatusCode == "1002" || StatusCode == "1003" || StatusCode == "1004" || StatusCode == "1005" || StatusCode == "1006" || StatusCode == "1007" || StatusCode == "1008" || StatusCode == "1009" || StatusCode == "1011" || StatusCode == "1012" || StatusCode == "1013" || StatusCode == "1014" || StatusCode == "1015" || StatusCode == "1016" || StatusCode == "1017") { rch.TxId = "NA"; rch.rechargeid = Int64.Parse(LocalID); rch.Status = 'f'; rch.RechargeVia = 1; MEMBERS.SQLReturnValue V = RechargeModule.UpdateRequests(rch); } #endregion } else if (REQ[0].Split(':')[2].StartsWith("X")) { #region PAY2CELL string RESULT1 = string.Empty; DataTable dt = new DataTable(); try { LocalID = REQ[0].Split(':')[2].StartsWith("X") ? REQ[0].Split(':')[2].Remove(0, 1) : REQ[0].Split(':')[2]; //---RechargeId string[] VAL = REQ[1].Split('|'); SRService.Information info = new Information(); SRService.SRServiceSoapClient client = new SRService.SRServiceSoapClient(); MRServiceClass MrJson = new MRServiceClass(); string X = client.DoRecharge(new SRService.Information { Amount = Convert.ToDecimal(VAL[1]), ApiCredentials = new SRService.Credentials { Password = VAL[5], UserName = VAL[6] }, MobileToRecharge = VAL[0], OperatorCode = int.Parse(VAL[2]), ServiceCode = int.Parse(VAL[4]), TypeOfRecharge = Convert.ToByte(VAL[3].ToString()), }); dt = MrJson.JsonStringToDataTable(X); if (dt.Rows.Count > 0) { string SResponse = dt.Rows[0]["DoRechargeResponse"].ToString(); if (!string.IsNullOrEmpty(SResponse)) { string[] SplitMyCode = SResponse.Split(':'); if (SplitMyCode[1] == "SR113") { RechargeModule.Recharge objsuc = new RechargeModule.Recharge(); objsuc.TxId = dt.Rows[0]["ReferenceID"].ToString(); SqlHelper.DML("UPDATE RECHARGE SET accountref='" + objsuc.TxId + "' WHERE accountref=" + LocalID); } else { RechargeModule.Recharge objsuc = new RechargeModule.Recharge(); objsuc.TxId = dt.Rows[0]["ReferenceID"].ToString(); SqlHelper.DML("UPDATE RECHARGE SET accountref='" + objsuc.TxId + "' WHERE accountref=" + LocalID); } } } } catch (Exception ex) { } #endregion } else { #region Our_API LocalID = REQ[0].Split(':')[2]; //---RechargeId System.Net.WebClient Client = new System.Net.WebClient(); System.IO.Stream Output = Client.OpenRead(API); System.IO.StreamReader str = new System.IO.StreamReader(Output); string RESULT = str.ReadToEnd(); str.Close(); ReqId = Regex.Split(RESULT, "<requestID>", RegexOptions.IgnoreCase)[1]; ReqId = Regex.Split(ReqId, "</requestID>", RegexOptions.IgnoreCase)[0]; StatusCode = Regex.Split(RESULT, "<statusCode>", RegexOptions.IgnoreCase)[1]; StatusCode = Regex.Split(StatusCode, "</statusCode>", RegexOptions.IgnoreCase)[0]; if (StatusCode.Trim() == "10008") //means request accepted. 10008 status code for 100% accepted. { string[,] prm = { { "id", LocalID }, { "accountid", ReqId } }; RechargeModule.UPDATERECHARGEVIAAPI(prm); } else// call refund procedure. { RechargeModule.Recharge rch = new RechargeModule.Recharge(); rch.TxId = StatusCode; rch.rechargeid = Int64.Parse(LocalID); rch.Status = 'f'; int K = RechargeModule.UpdateRequests(rch).ValueFromSQL; } #endregion } return(new Bussiness.AuthResponse(1, REQ[0].ToString())); } else { return(new Bussiness.AuthResponse(1, REQ[0].ToString())); } }
protected void Page_Load(object sender, EventArgs e) { #region Facebook Login if (HttpContext.Current.Session["cCeSTO_fB_Ken"] != null) { string json = GetFacebookUserJSON(HttpContext.Current.Session["cCeSTO_fB_Ken"].ToString()); JavaScriptSerializer js = new JavaScriptSerializer(); FacebookUser oUser = js.Deserialize <FacebookUser>(json); if (oUser != null) { lblfbName.Text = string.IsNullOrEmpty(oUser.name) ? string.Empty : oUser.name; lblfbFirstName.Text = string.IsNullOrEmpty(oUser.first_name) ? string.Empty : oUser.first_name; lblfbLastName.Text = string.IsNullOrEmpty(oUser.last_name) ? string.Empty : oUser.last_name; lblfbemail.Text = string.IsNullOrEmpty(oUser.email) ? string.Empty : oUser.email; lblfbGender.Text = string.IsNullOrEmpty(oUser.gender) ? string.Empty : oUser.gender; lblfbLink.Text = string.IsNullOrEmpty(oUser.link) ? string.Empty : oUser.link; lblfbPicture.Text = string.IsNullOrEmpty(oUser.picture) ? string.Empty : oUser.picture; lblfbid.Text = oUser.id.ToString(); ObjFb.FBName = lblfbName.Text; ObjFb.FirstName = lblfbFirstName.Text; ObjFb.LastName = lblfbLastName.Text; ObjFb.Gender = lblfbGender.Text; ObjFb.Link = lblfbLink.Text; ObjFb.Picture = lblfbPicture.Text; ObjFb.FBID = oUser.id.ToString(); ObjFb.EMail = lblfbemail.Text; ObjFb.ST = "F"; MEMBERS.SQLReturnValue MVal = SocialLogin.AUTHFacebookLogin(ObjFb); if (MVal.ValueFromSQL > 0) { Session["USERNAME"] = lblfbFirstName.Text; Session["cCeSTO_fB_Ken"] = null; MyLogic.GetUserID = MVal.ValueFromSQL.ToString(); Response.Redirect("Default.aspx"); } else { Session["cCeSTO_fB_Ken"] = null; ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('facebook login Failed Please Try Again emailid not valid.',1);", true); } } } else { Session["cCeSTO_fB_Ken"] = null; } #endregion #region Google Login if (HttpContext.Current.Session["cCeSTO_goG_Ken"] != null) { string jsonG = GetGoogleUserJSON(HttpContext.Current.Session["cCeSTO_goG_Ken"].ToString()); JavaScriptSerializer jsG = new JavaScriptSerializer(); GoogleUser profile = new JavaScriptSerializer().Deserialize <GoogleUser>(jsonG); if (profile != null) { lblfbName.Text = string.IsNullOrEmpty(profile.name) ? string.Empty : profile.name; lblfbFirstName.Text = string.IsNullOrEmpty(profile.given_name) ? string.Empty : profile.given_name; lblfbLastName.Text = string.IsNullOrEmpty(profile.family_name) ? string.Empty : profile.family_name; lblfbemail.Text = string.IsNullOrEmpty(profile.email) ? string.Empty : profile.email; lblfbGender.Text = string.IsNullOrEmpty(profile.gender) ? string.Empty : profile.gender; lblfbLink.Text = string.IsNullOrEmpty(profile.link) ? string.Empty : profile.link; lblfbPicture.Text = string.IsNullOrEmpty(profile.picture) ? string.Empty : profile.picture; lblfbid.Text = profile.id.ToString(); ObjFb.FBName = lblfbName.Text; ObjFb.FirstName = lblfbFirstName.Text; ObjFb.LastName = lblfbLastName.Text; ObjFb.Gender = lblfbGender.Text; ObjFb.Link = lblfbLink.Text; ObjFb.Picture = lblfbPicture.Text; ObjFb.FBID = profile.id.ToString(); ObjFb.EMail = lblfbemail.Text; ObjFb.ST = "G"; MEMBERS.SQLReturnValue MVal = SocialLogin.AUTHFacebookLogin(ObjFb); if (MVal.ValueFromSQL > 0) { Session["USERNAME"] = lblfbFirstName.Text; Session["cCeSTO_goG_Ken"] = null; MyLogic.GetUserID = MVal.ValueFromSQL.ToString(); Response.Redirect("Default.aspx"); } else { Session["cCeSTO_goG_Ken"] = null; ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('Google + login Failed Please Try Again emailid not valid.',1);", true); } } else { Session["cCeSTO_goG_Ken"] = null; } } #endregion }