#Project Description SharepointCommon is a framework for Microsoft SharePoint© 2010 ,2013 and 2016 It allows to map list items to simple hand-writen POCO classes and perform actions by manipulating with entities.

##Project Goals abstract layer on Sharepoint object model simplifying recurring routine actions ability to unit test make all operations typed

##Features create wrappers on a SPSite/SPWeb, opened by url or Ids in normal/elevated/unsafe/impersonated mode* create wrappers on a SPList by list title, Id or Url use lists as repositories, can override methods, add business specific logic create lists by wrapper and ensure fields by typed entity/content type get items by typed query create typed event receivers(since 2.0) get items by LINQ query (preview in 3.0) get items by Id, Guid or value of specified field add items(or items of specific content type) by typed entity update items by typed entity delete items by entity lazy access to any entity property archived by using Castle Dynamic Proxy CAML strings constructing by Caml.NET with typed extentions LINQ provider implemented with Re-LInq and POCO-To-CAML

##Development roadmap more complete LINQ implementation support for BCS and Metadata firlds

##Limitations use carefully with huge amount of data: code uses a lot of reflection!

##Get started Best way to get started with library is using nuget to add library to project. Now nugget package available both for SharePoint 2010 and 2013.

Or you can get required files at download page SharepointCommon latest release

To use library in farm solutions it need to be deployed to GAC. It may be performed manually by gacutil or adding dll to another sharepoint wsp package.

After deployed, library may be referenced and used from any .net 3.5 project (.Net 4.0 and 4.5 for SharePoint 2013, 4.6 for SharePoint 2016)

##Basic example of using

###Entity class example:

public class CustomItem : Item
{
     public virtual string CustomField1 { get; set; }
     public virtual double? CustomFieldNumber { get; set; }
     public virtual bool? CustomBoolean { get; set; }
     public virtual DateTime? CustomDate { get; set; }
     public virtual User CustomUser { get; set; }
     public virtual IEnumerable<User> CustomUsers { get; set; }

     [Field(LookupList = "ListForLookup")]
     public virtual Item CustomLookup { get; set; }

     [Field(LookupList = "ListForLookup")]
     public virtual IEnumerable<Item> CustomMultiLookup { get; set; }
 }

###Entity class for specific content type:

[ContentType("0x0104")]
public class Announcement : Item
{
    public virtual string Body { get; set; }
    public virtual DateTime Expires { get; set; }
}

###Application class example:

public class TestApp : AppBase<TestApp>
{
    [List(Url = "lists/contract")]
    public virtual IQueryList<Contract> Contracts { get; set; }

    [List(Name = "Purchase Request")]
    public virtual IQueryList<PurchaseRequest> PurchaseRequest { get; set; }

    [List(Id = "8A083287-CAEF-4DFA-8246-E8236676F5A1")]
    public virtual IQueryList<Order> Orders { get; set; }
}

###Get Application instance:

using (var app = TestApp.Factory.OpenNew("http://server-url/"))
{
	// app.QueryWeb - wrapper on SPSite and SPWeb
	var contract = app.Contracts;
	var prs = app.PurchaseRequest;
	var orders = app.Orders;
}

Open SPSite and SPWeb in Elevated mode In previous example, elevate existing: factory.Elevate(); Or open new: using (var factory = TestApp.Factory.ElevatedNew("http://server-url/")) { }

###Create list for CustomItem

using (var wf = WebFactory.Open("http://server-url/"))
{
	 var list = wf.Create<CustomItem>("TestList");
}

###Adding item to list:

// create two items for lookup fields
var lookupItem = new Item { Title = "item1" };
listForLookup.Add(lookupItem);

var lookupItem2 = new Item { Title = "item2" };
listForLookup.Add(lookupItem2);

// create item
var customItem = new CustomItem
{
	  Title = "TestTitle",
	  CustomField1 = "Field1",
	  CustomFieldNumber = 123.5,
	  CustomBoolean = true,
	  CustomUser = new Person("DOMAIN\USER1"),
	  CustomUsers = new  {  new Person("DOMAIN\USER1") },
	  CustomLookup = lookupItem,
	  CustomMultiLookup = new List<Item> { lookupItem, lookupItem2 },
	  CustomDate = DateTime.Now,
};
list.Add(customItem);

###Upload documents to SharePoint library:

lib = _queryWeb.Create<Document>("TestLibrary");
var document = new Document
{
	 Name = "TestFile.dat",
	 Content = new byte[] { 5, 10, 15, 25 },
	 RenameIfExists = true,
};
lib.Add(document);

###Get items by Query:

 var items = list.Items(new CamlQuery()
	.Query(Q.Where(
		Q.Eq(
			Q.FieldRef<Item>(i => i.Title), 
			Q.Value("test"))))
   .ViewFields<Item>(i => i.Id, i => i.Title),
   .Recursive()
)

###Get items by LINQ query(preview in 3.0):

var items = list.Items().Where(i => i.Title == "test");

 Converted to CAML:
<Where>
  <Eq>     
	 <FieldRef  Name=”Title” /> 
	 <Value Type=”Text”>test</Value>
  </Eq>
</Where>

Query: var items = list.Items().Select(new { i.Title} );

Converted to CAML: <Query/> <ViewFields> <FieldRef Name="Title" /> </ViewFields>

###Get items of content type 'Announcement' var items = list.Items(CamlQuery.Default);

###Update item customItem.Title = "new value";
list.Update(customItem, true); // update with increment version

###Update one field in item customItem.Title = "new value"; _list.Update(customItem, true, i => i.Title); // update only 'Title'

###Delete items _list.Delete(items.First(), false); // delete by entity, false to no move in recycle _list.Delete(items.First().Id, false); // delete by id

##Documentation All documentation available under 'documentation' tab Documentation

##Contribute All code written are fully unit tested. All checkins must be tested with all previous tests. We are welcome people to contribute the project. To be in, write me message with theme 'contribute SharepointCommon'