public IActionResult Delete([FromBody] Models.Database.StoredProcedures.SP_User_Delete.Inputs data) { data.Token = User.GetToken(); var rst = _ctx.SP_User_Delete(data); return(FromDatabase(rst)); }
public void SP_User_Delete_WhenPassingInvalidData_ThrowsArgumentException(string token, int userId) { var inputs = new Models.Database.StoredProcedures.SP_User_Delete.Inputs() { Token = token, UserId = userId }; Assert.That(() => _dbCTX.SP_User_Delete(inputs), Throws.ArgumentException); }
public void SP_User_Delete_WhenPassingValidData_ItRunsCallMethod() { var inputs = new Models.Database.StoredProcedures.SP_User_Delete.Inputs() { Token = "TokenValue", UserId = 1 }; var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_User_Delete.Inputs> >(); _dbCTX.SP_User_Delete(inputs, sp.Object); sp.Verify(s => s.Call(inputs)); }
public IActionResult Delete([FromBody] Models.Database.StoredProcedures.SP_User_Delete.Inputs data) { try { data.Token = User.GetToken(); var rst = _ctx.SP_User_Delete(data); return(FromDatabase(rst)); } catch (Exception e) { _logger.Add(e, "Error in UsersController.Delete(data)"); return(Problem(e.Message, e.StackTrace, 500, "Error in Update")); } }
public void SP_User_Delete_WhenPassingValidData_ItReturnDBResult() { var inputs = new Models.Database.StoredProcedures.SP_User_Delete.Inputs() { Token = "TokenValue", UserId = 1 }; var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_User_Delete.Inputs> >(); sp.Setup(s => s.Call(inputs)).Returns(new Models.Database.DBResult()); var result = _dbCTX.SP_User_Delete(inputs, sp.Object); Assert.That(result, Is.Not.Null); Assert.That(result, Is.TypeOf(typeof(Models.Database.DBResult))); }
public DBResult SP_User_Delete(Models.Database.StoredProcedures.SP_User_Delete.Inputs inputs, ISP <Models.Database.StoredProcedures.SP_User_Delete.Inputs> sp = null) { if (inputs == null) { throw new ArgumentNullException("Invalid inputs data."); } if (!inputs.IsValid()) { throw new ArgumentException("Invalid input data."); } if (sp == null) { sp = new FTSS.DP.DapperORM.StoredProcedure.SP_User_Delete(GetConnectionString()); } var rst = sp.Call(inputs); return(rst); }