public static List <UploadQueue> GetUploadQueueList()
{
return(EVSDatabase.Fetch <UploadQueue>("SELECT * FROM [dbo].[UploadQueue]"));
}
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 List <ExtensionDetail> GetExtensionDetailList(int extensionId)
{
return(EVSDatabase.Fetch <ExtensionDetail>("SELECT * FROM [dbo].[ExtensionDetail] WHERE ExtensionID = @0", extensionId));
}
//create
//read
public static List <MessageType> GetMessageTypeList()
{
return(EVSDatabase.Fetch <MessageType>("SELECT * FROM [dbo].[MessageType]"));
}
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));
}