public void TestGetUserQueryRefershDateHeader() { QueryTableModel table = GetTestTableModel(); AvrDbHelper.SaveQueryCache(table); var queryId = table.QueryId; long?id = AvrDbHelper.GetQueryCacheId(queryId, "en", false); Assert.IsTrue(id.HasValue); using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetCommand( @" update QueryCache set datUserQueryCacheRequest = NULL where [idfQuery] = @idflQuery", manager.Parameter("idflQuery", queryId) ); command.ExecuteNonQuery(); avrTran.CommitTransaction(); } var date = AvrDbHelper.GetsQueryCacheUserRequestDate(queryId); Assert.IsFalse(date.HasValue); AvrDbHelper.GetQueryCacheHeader(id.Value, true, false); date = AvrDbHelper.GetsQueryCacheUserRequestDate(queryId); Assert.IsFalse(date.HasValue); AvrDbHelper.GetQueryCacheHeader(id.Value, false, false); date = AvrDbHelper.GetsQueryCacheUserRequestDate(queryId); Assert.IsTrue(date.HasValue); }