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
}
