public MerchantDeposit Insert(MerchantDeposit merchantDeposit) { const string sql = @"INSERT INTO [dbo].[MerchantDeposits] ([MerchantAccountId],[MerchantWalletId],[FromType],[FromAddress],[ToAddress],[Amount],[Status],[Timestamp],[Remark],[OrderNo],[TransactionId],[SelfPlatform],[RequestId],[CryptoCode]) VALUES (@MerchantAccountId,@MerchantWalletId,@FromType,@FromAddress,@ToAddress,@Amount,@Status,@Timestamp,@Remark,@OrderNo,@TransactionId,@SelfPlatform,@RequestId,@CryptoCode); SELECT SCOPE_IDENTITY()"; using (var conn = WriteConnection()) { merchantDeposit.Id = conn.ExecuteScalar <long>(sql, merchantDeposit); return(merchantDeposit); } }
public override Deposit Insert(Deposit deposit) { var userDeposit = new MerchantDeposit { MerchantAccountId = deposit.AccountId, MerchantWalletId = deposit.WalletId, FromType = deposit.FromType, FromAddress = deposit.FromAddress, ToAddress = deposit.ToAddress, Amount = deposit.Amount, Status = deposit.Status, Timestamp = deposit.Timestamp, OrderNo = deposit.OrderNo, TransactionId = deposit.TransactionId, RequestId = deposit.RequestId, SelfPlatform = false, Remark = null, CryptoCode = deposit.CryptoCode }; userDeposit = new MerchantDepositDAC().Insert(userDeposit); deposit.Id = userDeposit.Id; return(deposit); }