//read private static UploadQueue GetNextItemFromQueue() { try { return(EVSDatabase.First <UploadQueue>("SELECT TOP 1 * FROM [dbo].[UploadQueue] WHERE [Processing] = 0 ORDER BY [UploadedDate] ASC")); } catch //(Exception exc) { return(null); } }
//create public static void AddExtensionMessage(ExtensionMessage extensionMessage) { try { EVSDatabase.Insert("ExtensionMessage", "ExtensionMessageID", true, extensionMessage); } catch //(Exception exc) { Trace.WriteLine("Could not add message to database", extensionMessage.Message); } }
public static List <Status> GetStatuses(string fileId, string userId) { return(EVSDatabase.Fetch <Status>("SELECT * FROM [dbo].[Status] WHERE [FileID] = @0 AND [UserID] = @1", fileId, userId)); }
//read public static Status GetStatus(int statusId) { return(EVSDatabase.First <Status>("SELECT * FROM [dbo].[Status] WHERE StatusID = @0", statusId)); }
//create public static void AddStatus(Status status) { EVSDatabase.Insert("Status", "StatusID", true, status); }
public static MessageType GetMessageTypeByType(string type) { return(EVSDatabase.First <MessageType>("SELECT * FROM [dbo].[MessageType] WHERE [Type] LIKE @0", type)); }
public static List <ExtensionMessage> GetExtensionMessageList(int extensionId, int messageTypeId) { return(EVSDatabase.Fetch <ExtensionMessage>("SELECT * FROM [dbo].[ExtensionMessage] WHERE ExtensionID = @0 AND MessageTypeID = @1", extensionId, messageTypeId)); }
//update private static void LockItem(int uploadQueueId) { EVSDatabase.Execute("UPDATE [dbo].[UploadQueue] SET [Processing] = 1 WHERE [UploadQueueID] = @0", uploadQueueId); }
//read public static Extension GetExtension(int extensionId) { return(EVSDatabase.First <Extension>("SELECT * FROM [dbo].[Extension] WHERE ExtensionID = @0", extensionId)); }
//create public static void AddExtension(Extension extension) { EVSDatabase.Insert("Extension", "ExtensionID", true, extension); }
public static ExtensionDetail GetExtensionDetail(int extensionDetailID) { return(EVSDatabase.First <ExtensionDetail>("SELECT * FROM [dbo].[ExtensionDetail] WHERE ExtensionDetailID = @0", extensionDetailID)); }
//read public static List <ExtensionDetail> GetExtensionDetailList(int extensionId) { return(EVSDatabase.Fetch <ExtensionDetail>("SELECT * FROM [dbo].[ExtensionDetail] WHERE ExtensionID = @0", extensionId)); }
//create public static void AddExtensionDetail(ExtensionDetail extensionDetail) { EVSDatabase.Insert("ExtensionDetail", "ExtensionDetailID", true, extensionDetail); }
//create //read public static MessageLink GetMessageLink(string messageID) { return(EVSDatabase.SingleOrDefault <MessageLink>("SELECT * FROM [dbo].[MessageLink] WHERE MessageID = @0", messageID)); }
public static ExtensionMessage GetExtensionMessage(int extensionMessageID) { return(EVSDatabase.First <ExtensionMessage>("SELECT * FROM [dbo].[ExtensionMessage] WHERE ExtensionMessageID = @0", extensionMessageID)); }
public static Status GetCurrentStatus(string fileId, string userId) { return(EVSDatabase.First <Status>("SELECT TOP 1 * FROM [dbo].[Status] WHERE [FileID] = @0 AND [UserID] = @1 ORDER BY StatusID DESC", fileId, userId)); }
//create public static void AddItemToQueue(UploadQueue queue) { EVSDatabase.Insert("UploadQueue", "UploadQueueID", true, queue); UpdateItemQueueStatus(); }
public static Extension GetExtension(string fileId) { return(EVSDatabase.First <Extension>("SELECT * FROM [dbo].[Extension] WHERE FileID LIKE @0", fileId)); }
public static List <UploadQueue> GetUploadQueueList() { return(EVSDatabase.Fetch <UploadQueue>("SELECT * FROM [dbo].[UploadQueue]")); }
//create //read public static List <MessageType> GetMessageTypeList() { return(EVSDatabase.Fetch <MessageType>("SELECT * FROM [dbo].[MessageType]")); }
//delete public static void RemoveItemFromQueue(UploadQueue queue) { EVSDatabase.Delete("UploadQueue", "UploadQueueID", queue); UpdateItemQueueStatus(); }
public static MessageType GetMessageTypeByID(int messageTypeId) { return(EVSDatabase.First <MessageType>("SELECT * FROM [dbo].[MessageType] WHERE [MessageTypeID] = @0", messageTypeId)); }