public long Insert(MerchantWalletStatement merchantWalletStatement)
 {
     using (var con = WriteConnection())
     {
         return(con.ExecuteScalar <long>("INSERT INTO MerchantWalletStatements(WalletId,Action,Amount,Balance,Timestamp,Remark) VALUES(@WalletId,@Action,@Amount,@Balance,@Timestamp,@Remark); SELECT SCOPE_IDENTITY()", merchantWalletStatement));
     }
 }
        public override void Insert(WalletStatement statement)
        {
            var merchantWalletStatement = new MerchantWalletStatement
            {
                Action    = statement.Action,
                Amount    = statement.Amount,
                Balance   = statement.Balance,
                Remark    = statement.Remark,
                Timestamp = statement.Timestamp,
                WalletId  = statement.WalletId
            };

            new MerchantWalletStatementDAC().Insert(merchantWalletStatement);
        }