예제 #1
0
        public void SP_Log_Insert_WhenPassingEmptyMSG_ThrowsArgumentNullException(string msg)
        {
            var inputs = new Models.Database.StoredProcedures.SP_Log_Insert.Inputs()
            {
                MSG = msg
            };

            Assert.That(() => _dbCTX.SP_Log_Insert(inputs),
                        Throws.ArgumentNullException);
        }
예제 #2
0
        public void SP_Log_Insert_WhenPassingValidData_ItRunsCallMethod()
        {
            var inputs = new Models.Database.StoredProcedures.SP_Log_Insert.Inputs()
            {
                MSG = "Simple log message"
            };
            var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_Log_Insert.Inputs> >();

            _dbCTX.SP_Log_Insert(inputs, sp.Object);

            sp.Verify(s => s.Call(inputs));
        }
예제 #3
0
        /// <summary>
        /// Log a simple text at database
        /// </summary>
        /// <param name="msg"></param>
        public void Add(string msg)
        {
            if (string.IsNullOrEmpty(msg))
            {
                throw new ArgumentNullException("Message could not be empty.");
            }

            string text = string.Format("{0}", msg);
            var    data = new Models.Database.StoredProcedures.SP_Log_Insert.Inputs()
            {
                MSG = text
            };

            _ctx.SP_Log_Insert(data);
        }
예제 #4
0
        public void SP_Log_Insert_WhenPassingValidData_ItReturnDBResult()
        {
            var inputs = new Models.Database.StoredProcedures.SP_Log_Insert.Inputs()
            {
                MSG = "Simple log message"
            };
            var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_Log_Insert.Inputs> >();

            sp.Setup(s => s.Call(inputs)).Returns(new Models.Database.DBResult());

            var result = _dbCTX.SP_Log_Insert(inputs, sp.Object);

            Assert.That(result, Is.Not.Null);
            Assert.That(result, Is.TypeOf(typeof(Models.Database.DBResult)));
        }
예제 #5
0
        public DBResult SP_Log_Insert(Models.Database.StoredProcedures.SP_Log_Insert.Inputs inputs,
                                      ISP <Models.Database.StoredProcedures.SP_Log_Insert.Inputs> sp = null)
        {
            if (inputs == null)
            {
                throw new ArgumentNullException("Invalid inputs data.");
            }

            if (string.IsNullOrEmpty(inputs.MSG))
            {
                throw new ArgumentNullException("Text message could not be empty.");
            }

            if (sp == null)
            {
                sp = new DP.DapperORM.StoredProcedure.SP_Log_Insert(GetConnectionString());
            }

            var rst = sp.Call(inputs);

            return(rst);
        }
 public IActionResult Add([FromBody] Models.Database.StoredProcedures.SP_Log_Insert.Inputs data)
 {
     _logger.Add(data.MSG);
     return(Ok(data));
 }