I have an ASP.NET web application hosted on Azure for use internally by our company. On this site, I keep a few spreadsheets and word documents that I would like employees of the company to be able to click on, and have them open directly in Microsoft's Office Web Apps where they can view and edit them. This is very similar to being logged in to SkyDrive and clicking on the file. Here is what I'm looking for:
The user should be able to edit the documents directly in their browser and save them.
My ASP.NET web application should be able to obtain a list of the documents and display them.
My ASP.NET web application should be able to allow users to upload new documents
The user should not have to login more than once (i.e., they should only have to login to our internal ASP.NET web application).
What I've tried: I cannot seem to figure out how to do this though, here are a couple things I've thought of and tried.
Using SkyDrive + API: Keeping the documents in SkyDrive, sharing them across employees, and using the SkyDrive/Live API to log them in and open the documents. This doesn't work for us because SkyDrive does not allow you to share documents without making them completely public (i.e., anyone with the link can view/edit them). They must be kept internally.
Using SkyDrive Pro: SkyDrive pro has the benefit of better sharing credentials. You can share something with a particular user, and only that user (i.e., they need to be logged in to view/edit it). Unfortunately, SkyDrive Pro is not supported in the Live API so I cannot access the files directly from my ASP.NET application.
Sharepoint: I think a possibility is SharePoint by keeping the documents in a Document Library and a using SharePoint Client. I think I can specify user credentials to obtain a list of documents in the Document Library, but I'm not sure that I can "open" one of those documents in the Office Web within their without bothering them to login to the SharePoint site again, and again. Especially if their own personal login times out? I have to re-enter my SharePoint password constantly using SharePoint in my browser, I do not want this when integrating with our ASP.NET app.
It would be great if Microsoft integrated the Office Web Apps in to Azure, potentially allowing you to open Excel and Word documents stored in Blob Storage. But that's not possible.
Anyone have any other ideas?