public static QueryTableHeaderDTO GetQueryCacheHeader(long queryCacheId, bool isSchedulerCall, bool isArchive) { using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetSpCommand("spAsQueryCacheGetHeader", manager.Parameter("idfQueryCache", queryCacheId), manager.Parameter("blnSchedulerCall", isSchedulerCall), manager.Parameter("blnUseArchivedData", isArchive)); QueryTablePacketDTO headerPacket = new QueryTablePacketDTO { IsArchive = isArchive }; int packetCount = 0; lock (m_DbSyncLock) { using (IDataReader reader = command.ExecuteReader()) { if (reader.Read()) { packetCount = (int)reader["intPacketCount"]; headerPacket.RowCount = (int)reader["intQueryColumnCount"]; var binaryBody = (byte[])reader["blbQuerySchema"]; headerPacket.BinaryBody = new ChunkByteArray(binaryBody); } } avrTran.CommitTransaction(); } return(new QueryTableHeaderDTO(headerPacket, queryCacheId, packetCount)); } }
public static ViewDTO GetViewCache(long viewCacheId, bool isSchedulerCall) { ViewDTO view; using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager headerCmd = manager.SetSpCommand("spAsViewCacheGetHeader", manager.Parameter("idfViewCache", viewCacheId), manager.Parameter("blnSchedulerCall", isSchedulerCall)); lock (m_DbSyncLock) { int packetCount; using (IDataReader reader = headerCmd.ExecuteReader()) { if (!reader.Read()) { return(null); } BaseTableDTO viewTableDTO = new BaseTableDTO { Header = { RowCount = (int)reader["intViewColumnCount"], BinaryBody = new ChunkByteArray((byte[])reader["blbViewSchema"]) } }; var binaryHeader = (byte[])reader["blbViewHeader"]; view = new ViewDTO(viewTableDTO, binaryHeader); packetCount = (int)reader["intPacketCount"]; } for (int packetNumber = 0; packetNumber < packetCount; packetNumber++) { DbManager packetCmd = manager.SetSpCommand("spAsViewCacheGetPacket", manager.Parameter("idfViewCache", viewCacheId), manager.Parameter("intViewCachePacketNumber", packetNumber)); var packetDTO = new BaseTablePacketDTO(); using (IDataReader packetReader = packetCmd.ExecuteReader()) { if (!packetReader.Read()) { return(null); } packetDTO.RowCount = (int)packetReader["intTableRowCount"]; packetDTO.BinaryBody = new ChunkByteArray((byte[])packetReader["blbViewCachePacket"]); } view.BodyPackets.Add(packetDTO); } avrTran.CommitTransaction(); } } return(view); }
public static long SaveViewCache(long queryCacheId, long layoutId, ViewDTO zippedTable) { using (var avrTran = new AvrDbTransaction()) { long id = SaveViewCacheWithoutTransaction(queryCacheId, layoutId, zippedTable); avrTran.CommitTransaction(); return(id); } }
public static long SaveQueryCache(QueryTableModel zippedTable) { using (var avrTran = new AvrDbTransaction()) { long id = SaveQueryCacheWithoutTransaction(zippedTable); avrTran.CommitTransaction(); return(id); } }
public static DateTime?GetsQueryCacheUserRequestDate(long queryId) { using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetSpCommand("spAsQueryCacheUserRequestDate", manager.Parameter("idfQuery", queryId)); object result; lock (m_DbSyncLock) { result = command.ExecuteScalar(); avrTran.CommitTransaction(); } return((result == null || result == DBNull.Value) ? null : (DateTime?)result); } }
public static void InvalidateViewCache(long layoutId) { using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetSpCommand("spAsViewCacheInvalidate", manager.Parameter("idfLayout", layoutId)); lock (m_DbSyncLock) { command.ExecuteNonQuery(); avrTran.CommitTransaction(); } } }
public static void InvalidateQueryCache(long queryId, string lang = null) { using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = string.IsNullOrEmpty(lang) ? manager.SetSpCommand("spAsQueryCacheInvalidate", manager.Parameter("idfQuery", queryId)) : manager.SetSpCommand("spAsQueryCacheInvalidate", manager.Parameter("idfQuery", queryId), manager.Parameter("strLanguage", lang)); lock (m_DbSyncLock) { command.ExecuteNonQuery(); avrTran.CommitTransaction(); } } }
public static long?GetViewCacheId (long queryCacheId, long layoutId, int refresheAfterDays = DaysInAWeek, bool allowSelectInvalidated = false) { using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetSpCommand("spAsViewCacheExist", manager.Parameter("idfQueryCache", queryCacheId), manager.Parameter("idfLayout", layoutId), manager.Parameter("refreshedCacheOnUserCallAfterDays", refresheAfterDays), manager.Parameter("allowSelectInvalidated", allowSelectInvalidated) ); object result; lock (m_DbSyncLock) { result = command.ExecuteScalar(); avrTran.CommitTransaction(); } return((result == null || result == DBNull.Value) ? null : (long?)result); } }
public static QueryTablePacketDTO GetQueryCachePacket(long queryCasheId, int packetNumber) { using (var avrTran = new AvrDbTransaction()) { DbManager command = avrTran.Manager.SetSpCommand("spAsQueryCacheGetPacket", avrTran.Manager.Parameter("idfQueryCache", queryCasheId), avrTran.Manager.Parameter("intQueryCachePacketNumber", packetNumber)); var result = new QueryTablePacketDTO(); using (IDataReader reader = command.ExecuteReader()) { if (reader.Read()) { result.RowCount = (int)reader["intTableRowCount"]; result.BinaryBody = new ChunkByteArray((byte[])reader["blbQueryCachePacket"]); result.IsArchive = (bool)reader["blnArchivedData"]; } } avrTran.CommitTransaction(); return(result); } }
public static long?GetQueryCacheId (QueryCacheKey queryCacheKey, int refresheAfterDays = DaysInAWeek, bool allowSelectInvalidated = false) { using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetSpCommand("spAsQueryCacheExist", manager.Parameter("idfQuery", queryCacheKey.QueryId), manager.Parameter("strLanguage", queryCacheKey.Lang), manager.Parameter("blnUseArchivedData", queryCacheKey.IsArchive), manager.Parameter("refreshedCacheOnUserCallAfterDays", refresheAfterDays), manager.Parameter("allowSelectInvalidated", allowSelectInvalidated) ); object result; lock (m_DbSyncLock) { result = command.ExecuteScalar(); avrTran.CommitTransaction(); } return((result == null || result == DBNull.Value) ? null : (long?)result); } }
public static DateTime GetQueryRefreshDateTime(long queryId, string lang) { DateTime date = DateTime.Now; using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetSpCommand("spAsQueryCacheGetRefreshDateTime", manager.Parameter("idfQuery", queryId), manager.Parameter("strLanguage", lang)); lock (m_DbSyncLock) { using (IDataReader reader = command.ExecuteReader()) { if (reader.Read()) { date = (DateTime)reader["datQueryRefresh"]; } } avrTran.CommitTransaction(); } } return(date); }
public static int DeleteQueryCache(long queryId, string lang, bool leaveLastRecord) { using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetSpCommand("spAsQueryCacheDelete", manager.Parameter("idfQuery", queryId), manager.Parameter("strLanguage", lang), manager.Parameter("blnLeaveLastRecord", leaveLastRecord) ); lock (m_DbSyncLock) { object result = command.ExecuteScalar(); int numberDeleted = 0; if (result is int) { numberDeleted = (int)result; } avrTran.CommitTransaction(); return(numberDeleted); } } }