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