//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));
}
