//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);
}
}
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));
}
public static MessageType GetMessageTypeByType(string type)
{
return(EVSDatabase.First <MessageType>("SELECT * FROM [dbo].[MessageType] WHERE [Type] LIKE @0", type));
}
//read
public static Status GetStatus(int statusId)
{
return(EVSDatabase.First <Status>("SELECT * FROM [dbo].[Status] WHERE StatusID = @0", statusId));
}
public static MessageType GetMessageTypeByID(int messageTypeId)
{
return(EVSDatabase.First <MessageType>("SELECT * FROM [dbo].[MessageType] WHERE [MessageTypeID] = @0", messageTypeId));
}
public static Extension GetExtension(string fileId)
{
return(EVSDatabase.First <Extension>("SELECT * FROM [dbo].[Extension] WHERE FileID LIKE @0", fileId));
}
//read
public static Extension GetExtension(int extensionId)
{
return(EVSDatabase.First <Extension>("SELECT * FROM [dbo].[Extension] WHERE ExtensionID = @0", extensionId));
}
public static ExtensionDetail GetExtensionDetail(int extensionDetailID)
{
return(EVSDatabase.First <ExtensionDetail>("SELECT * FROM [dbo].[ExtensionDetail] WHERE ExtensionDetailID = @0", extensionDetailID));
}
public static ExtensionMessage GetExtensionMessage(int extensionMessageID)
{
return(EVSDatabase.First <ExtensionMessage>("SELECT * FROM [dbo].[ExtensionMessage] WHERE ExtensionMessageID = @0", extensionMessageID));
}