public ResponseModel CustomerInformation(string AgreementNo)
{
_statement.AppendStatement("EXEC REST_CustomerInformation @AgreementNo");
_statement.AppendParameter("@AgreementNo", AgreementNo);
return(_resAccess.ExecuteDataTable(_statement));
}
public async Task <SMSResponse> BindAccount(AccountRequestModel request, string OTPType = "Bind")
{
SMSResponse response = new SMSResponse();
statement = new Statement();
statement.AppendStatement("EXEC REST_CheckPhoneNumber @IDCard, @BirthDay, @OTPType"); // , @UserId
statement.AppendParameter("@IDCard", request.IDCard);
statement.AppendParameter("@BirthDay", request.BirthDay);
statement.AppendParameter("@OTPType", OTPType);
// statement.AppendParameter("@UserId", request.UserId);
dt = resAccess.ExecuteDataTable(statement);
if (dt.Rows.Count > 0)
{
string urlData = string.Format(state.SMSConfigs.UrlBase + "user={0}&pass={1}&type={2}&to={3}&from={4}&text={5}&servid={6}", state.SMSConfigs.User, state.SMSConfigs.Pass, state.SMSConfigs.Type, dt.Rows[0]["PhoneNumber"].ToString(), state.SMSConfigs.From, func.ToHexString(dt.Rows[0]["Message"].ToString()), state.SMSConfigs.ServID);
CallAPI(urlData);
response.phoneNumber = dt.Rows[0]["OriginalPhoneNumber"].ToString();
response.result = dt.Rows[0]["result"].ToString();
response.refOTP = dt.Rows[0]["OTP_Reference"].ToString();
}
else
{
response.phoneNumber = "";
response.result = "";
response.refOTP = "";
return(response);
}
return(response);
}
public void SP_GenerateRouteStep(string UserID, string Keyword)
{
statement = new Statement();
statement.AppendStatement("EXEC [LineDB]..[SP_GenerateRouteStep] @UserId, @Keyword");
statement.AppendParameter("@UserId", UserID);
statement.AppendParameter("@Keyword", Keyword);
resAccess.ExecuteDataTable(statement);
}
public DataTable REST_GenerateOTP(string phoneNumber, string agreementNo, string OTPType)
{
statement = new Statement();
DataTable dt = new DataTable();
statement.AppendStatement("EXEC REST_GenerateOTP @phoneNumber, @agreementNo, @OTPType");
statement.AppendParameter("@phoneNumber", phoneNumber);
statement.AppendParameter("@agreementNo", agreementNo);
statement.AppendParameter("@OTPType", OTPType);
dt = resAccess.ExecuteDataTable(statement);
return(dt);
}
public DataTable CheckSecretCode(string SecretCode)
{
dt = new DataTable();
statement = new Statement();
statement.AppendStatement("EXEC REST_CheckSecretCode @SecretCode");
statement.AppendParameter("@SecretCode", SecretCode);
dt = resAccess.ExecuteDataTable(statement);
return(dt);
}
public DataTable REST_CustomerInformation(string agreementNo)
{
statement = new Statement();
statement.AppendStatement("EXEC REST_CustomerInformation @AgreementNo");
statement.AppendParameter("@AgreementNo", agreementNo);
return(resAccess.ExecuteDataTable(statement));
}