Getting Data from Subsites to TopSite with Null Checking.

using System;

using System.Web.UI;

using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Linq;
using Microsoft.SharePoint;
using System.Data;
namespace TestSampleCode001.VisualWebPart1
{
public partial class VisualWebPart1UserControl : UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
try
{
string Title = string.Empty;
string Status = string.Empty;
string AssignedTo = string.Empty;
string WebTitle = string.Empty;
var query = from SPWeb subWeb in
SPContext.Current.Web.GetSubwebsForCurrentUser()
from SPListItem item in
subWeb.Lists["Tasks"].Items
orderby item["ID"] descending
select new
{

Title=item["Title"].ToString(),
Status=(item["Status"]==null) ? "Data
UnAvailable" : item["Status"].ToString(),
Priority = (item["Priority"] == null)
? "Data UnAvailable" : item["Status"].ToString(),
AssignedTo = (item["AssignedTo"] ==
null) ? "Data UnAvailable" :
item["AssignedTo"].ToString().Substring(item["AssignedTo"].ToString().
LastIndexOf("\\") + 1),
WebTitle=subWeb.Title
};

if (query.Count() > 0)
{
sgvTest.DataSource = query;
sgvTest.DataBind();
}

}
catch (Exception ex)
{

this.Controls.Add(new LiteralControl(ex.ToString()));

}

}

}

}

Converting an ASP.NET site into a SharePoint site

Introduction

There are a lot of ASP.NET web developers who are moving to SharePoint site creation. This article will explain in detail how an ASP.NET webpage developed in Visual Studio can be converted into a SharePoint site. If there is a requirement for a website created in Visual Studio, just the old fashioned way with the code-behind logic and other layers like Data Access and Business Logic, to be converted into a SharePoint site, and still make it work the same way with the same code-behind, you are in the right place. This article deals with right that.

Scenario

There is an ASP.NET website solution that contains three layers viz. Code-Behind Layer, Business-Logic Layer, and the Data-Access Layer. The website has functionality implemented in all these layers. The Business-Logic and the Data-Access layers are in a different Class Library project. We have to convert this website into a SharePoint site. Also, we want to use the same look and feel of the SharePoint site. So, we have to use the SharePoint master page instead of the one that we are having (we can also use our own master page; just that you have to add some default Place Holders that are required for the SharePoint functionalities). In this article, we are dealing with a website with the same look and feel as a SharePoint site.

Steps Overview

There are three steps that are explained in the article which will help you to transform your ASP.NET Web Application into a SharePoint site.
Step1: Add a Web Deployment Project to your website solution that will create a single DLL for the website. This step will give us the code-behind DLL and other dependency DLLs for the website.
Step2: Copy the bin folder items (DLLs) into the SharePoint site, and tweak the web configuration file of the SharePoint site to use the copied DLLs.
Step3: Open your created SharePoint site in SharePoint Designer and import the web pages from our web application and link it to the appropriate DLLs.

Step 1: Adding a web deployment project to your website solution that will create a single DLL for the website

1. The first step is to make sure you have added the proper namespaces and avoided class name duplications within a namespace before going to step 2.
2. Add a web deployment project into your website solution. This can be done by right clicking on the website project and choosing 'Add Web Deployment Project' option.
Note: This option will be available once you have installed the Web Deployment Setup.
3. Add a strong name key to the solution which we will be using to sign all the DLLs.
4. Now, we have to set the deployment project properties. Right-click on the deployment project and click 'Property Pages'.
5. Go to the 'Output Assemblies' tab, and choose the 'Merge all assemblies to single assembly' option (this is the default option), and give the assembly name.

1. Next, go to the Signing tab and choose the 'Enable strong naming' option, and choose the strong name key that you have created in step 3.

 

1. Also check the option 'Mark the assemblies with AllowPartiallyTrustedCallersAttribute (APTCA)'. This will make the DLL partially trusted, and thus the SharePoint site can use them. Click on OK.
2. The Data Access, Business Logic, or any other assemblies that are a dependency to the web application must be strong named with a strong name key.

 

9. Also, we have to allow partially trusted callers for the dependency DLLs. This can be done by opening the Assembly.info file of the Class Library project and putting the following line of code as shown above:
Collapse

[assembly: System.Security.AllowPartiallyTrustedCallers]

10. Build the deployment project under Release mode (any mode).
11. Go to the path where the deployment project has put the output. Here, in the bin directory, you will find the web deployment DLL file. If there are any dependency projects such as the Business Layer and the Data-Access Layer, those DLLs also will be copied to this bin folder.

Now, we have the DLLs that can be used in our SharePoint site for using the same functionality as in our ASP.NET site.

Step 2: Copy the bin folder items (DLLs) into the SharePoint site and tweak the web configuration file of the SharePoint site to use the copied DLLs

The next step in our SharePoint site creation is linking the DLLs that we have created in the procedure above into our already existing blank SharePoint site. There are also some changes that are required in our SharePoint site's web.config file (By default found in C:\Inetpub\wwwroot\wss\VirtualDirectories\<PortNo>). Following are the steps that has to be done:

1. Copy the bin folder contents from your ASP.NET deployment folder into the bin folder of your SharePoint site (usually in C:\Inetpub\wwwroot\wss\VirtualDirectories\<PortNo>\bin).
2. Open the web.config file of your SharePoint site.
3. Add the following line in under the <PageParserPath> section:
Collapse

<PageParserPath VirtualPath="/*" CompilationMode="Always" 
   AllowServerSideScript="true" IncludeSubFolders="true" />

4. Register the assemblies that will be used in the SharePoint site (web deployment DLL which has the code-behind code, the Business Layer and Data Access DLLs) as a SafeControl. For this, add the following under the <SafeControls> section:
Collapse

<SafeControl Assembly="SampleWebSiteAssembly" 
   Namespace="SampleSiteNamespace" TypeName="*" Safe="True" />

5. Also add all the other dependency DLLs that your site will be using. Note that all these DLLs must be strong named and marked AllowPartiallyTrusted.
6. Change the trust level from Minimal to Medium by changing the level attribute of the <trust> section from 'WSS_Minimal' to 'WSS_Medium'.
Note: You can also do the following to enable the original errors being shown in the SharePoint site screen for easy error identification. You have to change the mode attribute of the <customErrors> section to Off. Also, change the CallStack attribute of the <SafeMode> section to True.

Step 3: Open your created SharePoint site in SharePoint Designer and import the web pages from our web application

Let us say we have a link in our SharePoint site in the left navigation panel, on the click of which you want to display one of your ASP.NET pages in the content place holder of the SharePoint site. This is what we do:

1. Open your SharePoint site in the SharePoint Designer (in this article, we are using SharePoint Designer 2007).
2. Click on File-->Import-->File. This will open the Import dialog box.
3. Click on 'Add File' and choose the ASPX page that you have created from your local folder. Please note that you have to take the ASPX file from the deployment folder and not the ASPX page that is there in the project. Click OK. This will import the page into your SharePoint site.
4. Now, double-click on the newly imported page. Click on the Split option in the Design/Split/Code option in the centre pane (bottom left of the pane).
5. As soon as you do this, you will see in the designer window an error that says: The Master Page file cannot be loaded. This is because the master file that we have used in the project is different from the master page that the SharePoint site uses. You can either import the master page or use SharePoint's default master page. In this article, we are going to use SharePoint's default master page.
6. Change the 'MasterPageFile' attribute in the Page directive of the web page to a value same as the default.aspx in the SharePoint site, which is ~masterurl/default.master.
7. Delete the 'CodeFile' attribute from the Page directive as this is only for Visual Studio purposes.
8. Now, change the ContentPlaceHolderID of the place holders in the ASP.NET page to a relevant SharePoint site place holder. For example, the ContenPlaceHolderID of the main content place holder of the ASP.NET page must be changed to 'PlaceHolderMain'.
9. After mapping the place holders of the ASP.NET page to that of the SharePoint master page, the page will render in the design view with the default master page.
10. Now, we have to change the Inherits attribute to add the assembly name. For example, if the namespace is 'SampleSiteNamespace' and the assembly name that the page uses for code-behind is SampleWebSiteAssembly, then we set Inherits="SampleSiteNamespace.SampleWebSiteAssembly", and this assembly must be in the bin of the SharePoint site as added in Step 2 above.

Now, we have our ASP.NET site as a SharePoint site, ready to run with the same look and feel of the SharePoint site.

  

    

Usefull Links

 http://blogs.msdn.com/b/kaevans/archive/2010/07/09/sql-server-provider-for-claims-based-authentication-in-sharepoint-2010.aspx


 http://blogs.msdn.com/b/kaevans/archive/2011/04/02/code-behind-page-layouts-with-visual-studio-2010.aspx


http://blogs.msdn.com/b/kaevans/archive/2010/06/25/enable-javascript-intellisense-for-sharepoint-development.aspx

http://praveenbattula.blogspot.com/

http://www.codeproject.com/KB/sharepoint/ASPNET_to_Sharepoint.aspx

http://darryl1975.wordpress.com/2009/04/23/event-handlers-in-sharepoint/

http://get-spscripts.com/

http://pshscripts.blogspot.com/

http://sharepoint.stackexchange.com/questions/4481/using-code-compiled-for-moss-2007-in-2010

http://blog.sharepointsite.co.uk/2010/10/spdatagrid-error-unable-to-cast-object.html

http://www.thesharepointblog.net/Lists/Posts/Post.aspx?List=815f255a%2Dd0ef%2D4258%2Dbe2a%2D28487dc9975c&ID=64

http://www.learningsharepoint.com/2011/12/28/create-folder-in-listlibrary-using-ecmascriptjavascript-client-object-model/

https://www.nothingbutsharepoint.com/sites/devwiki/SP2007Dev/Pages/Event%20Receivers.aspx

http://www.ebookshare.net/microsoft/Wrox-Beginning-SharePoint-2007-Administration-Jun-2007-eBook-BBL-3895.html 

Deleting all library items in a document library.

1. private static void DeleteAllItemsUsingBatch()  
2.         {  
3.             using (SPSite site = new SPSite("http://mysharepointserver"))  
4.             {  
5.                 SPWeb web = site.OpenWeb("/");  
6.                 SPList list = web.Lists["Documents"];  
7.                 StringBuilder sb = new StringBuilder();  
8.                 sb.Append("<batch>");  
9.                 string batchCommand = "<method><setlist scope=\"Request\">" + list.ID + "</setlist><setvar name=\"ID\">{0}</setvar><setvar name=\"Cmd\">DELETE</setvar><setvar name=\"owsfileref\">{1}</setvar></method>";  
10.                 foreach (SPListItem item in list.Items)  
11.                 {  
12.                     sb.AppendFormat(batchCommand, item.ID.ToString(), item.File.ServerRelativeUrl);  
13.                 }  
14.                 sb.Append("</batch>");  
15.   
16.                 web.AllowUnsafeUpdates = true;  
17.                 site.RootWeb.ProcessBatchData(sb.ToString());  
18.                 web.AllowUnsafeUpdates = false;  
19.                 web.Close();  
20.             }  
21.         } 

To delete all the list items in a SharePoint list

1. private void DeleteAllItemsUsingBatch()  
2.     {  
3.         using (SPSite site = new SPSite("http://mySharePointServer"))  
4.         {  
5.             SPWeb web = site.OpenWeb("/");  
6.             SPList list = web.Lists["Links"];  
7.             StringBuilder sb = new StringBuilder();  
8.             sb.Append("<batch>");  
9.             string batchCommand = "<method><setlist scope=\"Request\">" + list.ID + "</setlist><setvar name=\"ID\">{0}</setvar><setvar name=\"Cmd\">DELETE</setvar></method>";  
10.             foreach (SPListItem item in list.Items)  
11.             {  
12.                 sb.Append(string.Format(batchCommand, item.ID.ToString()));  
13.             }  
14.             sb.Append("</batch>");  
15.             web.AllowUnsafeUpdates = true;  
16.             site.RootWeb.ProcessBatchData(sb.ToString());  
17.             web.AllowUnsafeUpdates = false;  
18.             web.Close();  
19.         }  
20.     }