public override bool CreateTable(string tableName, IEnumerable <Field> fields)
{
try
{
using (var context = GetClientContext(ConnectionDetails))
{
var site = context.Web;
// Create a list.
var listCreationInfo = new SP.ListCreationInformation();
listCreationInfo.Title = tableName;
listCreationInfo.TemplateType = (int)SP.ListTemplateType.GenericList;
listCreationInfo.QuickLaunchOption = SP.QuickLaunchOptions.On;
var list = site.Lists.Add(listCreationInfo);
list.Update();
context.ExecuteQuery();
if (!fields.IsNullOrEmpty())
{
fields.ForEach(field =>
{
CreateField(tableName, field);
});
}
return(true);
}
}
catch (Exception x)
{
TraceService.Instance.WriteException(x);
return(false);
}
}
public void createListwithfields(spClient.ClientContext clientContext, string listName)
{
try
{
spClient.ListCreationInformation creationInfo = new spClient.ListCreationInformation();
creationInfo.Title = listName;
creationInfo.Description = "This list contains InfoPath library data";
creationInfo.TemplateType = (int)spClient.ListTemplateType.GenericList;
spClient.List newList = clientContext.Web.Lists.Add(creationInfo);
clientContext.Load(newList);
clientContext.ExecuteQuery();
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.ActionPlan + "' Name='" + ASMSRequestConstants.ActionPlan + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.APO + "' Name='" + ASMSRequestConstants.APO + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.APOComments + "' Name='" + ASMSRequestConstants.APOComments + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.AssignedTo + "' Name='" + ASMSRequestConstants.AssignedTo + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='DateTime' DisplayName='" + ASMSRequestConstants.CaseDate + "' Format='DateOnly' Name='" + ASMSRequestConstants.CaseDate + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.CaseNo + "' Name='" + ASMSRequestConstants.CaseNo + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.CaseState + "' Name='" + ASMSRequestConstants.CaseState + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.CaseStatus + "' Name='" + ASMSRequestConstants.CaseStatus + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.CaseURL + "' Name='" + ASMSRequestConstants.CaseURL + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.Cost + "' Name='" + ASMSRequestConstants.Cost + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.DisapprovedReason + "' Name='" + ASMSRequestConstants.DisapprovedReason + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='DateTime' DisplayName='" + ASMSRequestConstants.DOC + "' Format='DateOnly' Name='" + ASMSRequestConstants.DOC + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='DateTime' DisplayName='" + ASMSRequestConstants.ImplementedDate + "' Format='DateOnly' Name='" + ASMSRequestConstants.ImplementedDate + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.IsApproved + "' Name='" + ASMSRequestConstants.IsApproved + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.IsConfident + "' Name='" + ASMSRequestConstants.IsConfident + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.IsNewCase + "' Name='" + ASMSRequestConstants.IsNewCase + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.IsVerified + "' Name='" + ASMSRequestConstants.IsVerified + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.mComments + "' Name='" + ASMSRequestConstants.mComments + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.NinetyDay + "' Name='" + ASMSRequestConstants.NinetyDay + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.Notes + "' Name='" + ASMSRequestConstants.Notes + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.NotRechecked + "' Name='" + ASMSRequestConstants.NotRechecked + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.ParentCase + "' Name='" + ASMSRequestConstants.ParentCase + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.PrjtNo + "' Name='" + ASMSRequestConstants.PrjtNo + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.Recheck + "' Name='" + ASMSRequestConstants.Recheck + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.RecheckComments + "' Name='" + ASMSRequestConstants.RecheckComments + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.RecheckDate + "' Name='" + ASMSRequestConstants.RecheckDate + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.ReportedBy + "' Name='" + ASMSRequestConstants.ReportedBy + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.ReqDesc + "' Name='" + ASMSRequestConstants.ReqDesc + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.RequestedBy + "' Name='" + ASMSRequestConstants.RequestedBy + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.Requester + "' Name='" + ASMSRequestConstants.Requester + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='DateTime' DisplayName='" + ASMSRequestConstants.ResolutionDueDate + "' Format='DateOnly' Name='" + ASMSRequestConstants.ResolutionDueDate + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.StatusDate + "' Name='" + ASMSRequestConstants.StatusDate + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.Summary + "' Name='" + ASMSRequestConstants.Summary + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.Urgency + "' Name='" + ASMSRequestConstants.Urgency + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.VerifiedDate + "' Name='" + ASMSRequestConstants.VerifiedDate + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.VerifiedReason + "' Name='" + ASMSRequestConstants.VerifiedReason + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.WFState + "' Name='" + ASMSRequestConstants.WFState + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.CreatedBy + "' Name='" + ASMSRequestConstants.CreatedBy + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.ModifiedBy + "' Name='" + ASMSRequestConstants.ModifiedBy + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
newList.Fields.AddFieldAsXml("<Field Type='Text' DisplayName='" + ASMSRequestConstants.AMSRequestWorkflow + "' Name='" + ASMSRequestConstants.AMSRequestWorkflow + "' />", true, spClient.AddFieldOptions.AddToDefaultContentType);
clientContext.Load(newList);
clientContext.ExecuteQuery();
newList.Update();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
streamWriter.WriteLine("\r\n\r\n----------------------------- Error -------------------------------");
streamWriter.WriteLine("Error Message :" + ex.Message);
streamWriter.WriteLine("Stack Trace :" + ex.StackTrace);
}
}
