private static void Main()
{
const string urlSharePointOnpremise = "urlsiteSharePoint";
const string listName = "Employed";
using (var site = new SPSite(urlSharePointOnpremise))
{
var web = site.OpenWeb();
var list = web.Lists.TryGetList(listName);
if (list == null)
{
var createList= web.CreateList(listName, "List of Employed of my Company", TypeList.GenericList, false,
typeof (Employed));
Console.WriteLine(string.Concat("List Employed Created", createList));
}
var employed = new Employed
{
Country = "Spain",
DateBorn = new DateTime(1981, 5, 10),
Job = "Sofware Architect",
LastName = "Diaz Cervera",
Name = "Adrian"
};
var employed2 = new Employed
{
Country = "Spain",
DateBorn = new DateTime(1979, 5, 10),
Job = "Head of Innovation",
LastName = "Diaz Martin",
Name = "Alberto"
};
var logger = new LogManager().GetLogger(new System.Diagnostics.StackTrace().GetFrame(0)); ;
var repository= new SharePointRepository<Employed>(web,logger,listName,10);
var resultInsert= repository.Insert(employed);
Console.WriteLine(string.Concat("Insertado el elemento: ", resultInsert));
resultInsert = repository.Insert(employed2);
Console.WriteLine(string.Concat("Insertado el elemento: ", resultInsert));
var employed3= repository.Get(resultInsert);
Console.WriteLine(string.Concat("Return employed: ", employed3.Name));
var employedCollection= repository.GetAll();
Console.WriteLine(string.Concat("Count Employed: ", employedCollection.Count));
var resultBool = repository.Delete(resultInsert);
Console.WriteLine(string.Concat("Elemento Eliminado ", resultBool));
employedCollection = repository.GetAll();
Console.WriteLine(string.Concat("Count Employed: ", employedCollection.Count));
var queryCaml = @"<Where>
<Eq>
<FieldRef Name='Name' />
<Value Type='Text'>Adrian</Value>
</Eq>
</Where>";
var queryCollection = repository.Query(queryCaml, 1);
Console.WriteLine(string.Concat("Count Employed: ", queryCollection.Count));
var query = new Query().Where().Field("Name",string.Empty).Operator(TypeOperators.Eq).Value("Text","Adrian");
queryCollection = repository.Query(query, 1);
Console.WriteLine(string.Concat("Count Employed: ", queryCollection.Count));
var firstEmployed = queryCollection.FirstOrDefault();
firstEmployed.Name = "Alberto Javier";
var updateOperation= repository.Save(Convert.ToInt32(firstEmployed.ID), firstEmployed);
Console.WriteLine(string.Concat("Update Employed: ", updateOperation));
Console.ReadLine();
}
}
// Uncomment the method below to handle the event raised after a feature has been activated.
public override void FeatureActivated(SPFeatureReceiverProperties properties)
{
var site = properties.Feature.Parent as SPSite;
var web = site.RootWeb;
ILog log = new LogManager().GetLogger(new StackTrace().GetFrame(0)); ;
var columnSiteCollection = web.CreateColumnSite("Image Galery", typeof(ImageGallery));
web.CreateContentType(Constants.ContentType.ImageGallery, "Enmarcha ContentType", "Elemento", columnSiteCollection);
web.CreateList(Constants.List.ImageGallery, "Lista de la galeria de imagenes", TypeList.GenericList, true);
var list = web.Lists.TryGetList(Constants.List.ImageGallery);
if (list != null)
{
list.AddContentTypeLibrary("Image Galery");
var repository = new SharePointRepository<ImageGallery>(web, log, Constants.List.ImageGallery, 40);
IList<ImageGallery> collection = new List<ImageGallery>
{
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/01.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/01.jpg" },
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/02.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/02.jpg" },
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/03.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/03.jpg" },
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/04.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/04.jpg" },
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/05.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/05.jpg" },
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/06.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/06.jpg" },
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/07.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/07.jpg" },
OpenWindows = true,
Visible = true
}, new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/08.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/08.jpg" },
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/09.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/09.jpg" },
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/10.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/10.jpg" },
OpenWindows = true,
Visible = true
}
,
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/11.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/11.jpg" },
OpenWindows = true,
Visible = true
}
,
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/12.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/12.jpg" },
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField { Description = "Image", Url = "/Style%20Library/Images/09.jpg"},
UrlNew = new UrlField { Description = "New", Url = "/Style%20Library/Images/09.jpg" },
OpenWindows = true,
Visible = true
}
};
foreach (var element in collection)
{
repository.Insert(element);
}
}
}
// Uncomment the method below to handle the event raised after a feature has been activated.
public override void FeatureActivated(SPFeatureReceiverProperties properties)
{
var site = properties.Feature.Parent as SPSite;
var web = site.RootWeb;
ILog log = new LogManager().GetLogger(new StackTrace().GetFrame(0));;
var columnSiteCollection = web.CreateColumnSite("Image Galery", typeof(ImageGallery));
web.CreateContentType(Constants.ContentType.ImageGallery, "Enmarcha ContentType", "Elemento", columnSiteCollection);
web.CreateList(Constants.List.ImageGallery, "Lista de la galeria de imagenes", TypeList.GenericList, true);
var list = web.Lists.TryGetList(Constants.List.ImageGallery);
if (list != null)
{
list.AddContentTypeLibrary("Image Galery");
var repository = new SharePointRepository <ImageGallery>(web, log, Constants.List.ImageGallery, 40);
IList <ImageGallery> collection = new List <ImageGallery>
{
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/01.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/01.jpg"
},
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/02.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/02.jpg"
},
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/03.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/03.jpg"
},
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/04.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/04.jpg"
},
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/05.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/05.jpg"
},
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/06.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/06.jpg"
},
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/07.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/07.jpg"
},
OpenWindows = true,
Visible = true
}, new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/08.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/08.jpg"
},
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/09.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/09.jpg"
},
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/10.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/10.jpg"
},
OpenWindows = true,
Visible = true
}
,
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/11.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/11.jpg"
},
OpenWindows = true,
Visible = true
}
,
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/12.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/12.jpg"
},
OpenWindows = true,
Visible = true
},
new ImageGallery
{
Description = string.Empty,
Image = new UrlField {
Description = "Image", Url = "/Style%20Library/Images/09.jpg"
},
UrlNew = new UrlField {
Description = "New", Url = "/Style%20Library/Images/09.jpg"
},
OpenWindows = true,
Visible = true
}
};
foreach (var element in collection)
{
repository.Insert(element);
}
}
}
private static void Main()
{
const string urlSharePointOnpremise = "urlsiteSharePoint";
const string listName = "Employed";
using (var site = new SPSite(urlSharePointOnpremise))
{
var web = site.OpenWeb();
var list = web.Lists.TryGetList(listName);
if (list == null)
{
var createList = web.CreateList(listName, "List of Employed of my Company", TypeList.GenericList, false,
typeof(Employed));
Console.WriteLine(string.Concat("List Employed Created", createList));
}
var employed = new Employed
{
Country = "Spain",
DateBorn = new DateTime(1981, 5, 10),
Job = "Sofware Architect",
LastName = "Diaz Cervera",
Name = "Adrian"
};
var employed2 = new Employed
{
Country = "Spain",
DateBorn = new DateTime(1979, 5, 10),
Job = "Head of Innovation",
LastName = "Diaz Martin",
Name = "Alberto"
};
var logger = new LogManager().GetLogger(new System.Diagnostics.StackTrace().GetFrame(0));;
var repository = new SharePointRepository <Employed>(web, logger, listName, 10);
var resultInsert = repository.Insert(employed);
Console.WriteLine(string.Concat("Insertado el elemento: ", resultInsert));
resultInsert = repository.Insert(employed2);
Console.WriteLine(string.Concat("Insertado el elemento: ", resultInsert));
var employed3 = repository.Get(resultInsert);
Console.WriteLine(string.Concat("Return employed: ", employed3.Name));
var employedCollection = repository.GetAll();
Console.WriteLine(string.Concat("Count Employed: ", employedCollection.Count));
var resultBool = repository.Delete(resultInsert);
Console.WriteLine(string.Concat("Elemento Eliminado ", resultBool));
employedCollection = repository.GetAll();
Console.WriteLine(string.Concat("Count Employed: ", employedCollection.Count));
var queryCaml = @"<Where>
<Eq>
<FieldRef Name='Name' />
<Value Type='Text'>Adrian</Value>
</Eq>
</Where>";
var queryCollection = repository.Query(queryCaml, 1);
Console.WriteLine(string.Concat("Count Employed: ", queryCollection.Count));
var query = new Query().Where().Field("Name", string.Empty).Operator(TypeOperators.Eq).Value("Text", "Adrian");
queryCollection = repository.Query(query, 1);
Console.WriteLine(string.Concat("Count Employed: ", queryCollection.Count));
var firstEmployed = queryCollection.FirstOrDefault();
firstEmployed.Name = "Alberto Javier";
var updateOperation = repository.Save(Convert.ToInt32(firstEmployed.ID), firstEmployed);
Console.WriteLine(string.Concat("Update Employed: ", updateOperation));
Console.ReadLine();
}
}