public static async Task InsertItemAsync(ReasonValue item)
{
using (var clientContext = await(AuthenticationHelper.GetSharePointClientContextAsync(Permissions.Application)))
{
var list = clientContext.Web.Lists.GetByTitle(SPLists.ReasonValues.Title);;
ListItemCreationInformation newItem = new ListItemCreationInformation();
ListItem listItem = list.AddItem(new ListItemCreationInformation());
listItem[SPLists.ReasonValues.Columns.Reason] = SharePointHelper.BuildSingleLookFieldValue(item.Reason.Id, item.Reason.Name);
listItem[SPLists.ReasonValues.Columns.Date] = item.InputDate;
listItem[SPLists.ReasonValues.Columns.Value] = item.Value;
listItem.Update();
clientContext.Load(listItem);
clientContext.ExecuteQuery();
item.Id = listItem.Id;
}
}
public static async Task <Metric> InsertItemAsync(Metric item)
{
using (var clientContext = await(AuthenticationHelper.GetSharePointClientContextAsync(Permissions.Application)))
{
var list = clientContext.Web.Lists.GetByTitle(SPLists.Metrics.Title);
ListItem listItem = list.AddItem(new ListItemCreationInformation());
listItem[SPLists.Metrics.Columns.Issue] = SharePointHelper.BuildSingleLookFieldValue(item.Issue.Id, item.Issue.Name);
listItem[SPLists.Metrics.Columns.Title] = item.Name;
listItem[SPLists.Metrics.Columns.State] = 1;
listItem[SPLists.Metrics.Columns.TargetGoal] = item.TargetGoal;
listItem[SPLists.Metrics.Columns.ValueType] = item.ValueType;
listItem.Update();
clientContext.Load(listItem);
clientContext.ExecuteQuery();
return(listItem.ToMetric());
}
}
public static async Task InsertItemAsync(Reason item)
{
using (var clientContext = await(AuthenticationHelper.GetSharePointClientContextAsync(Permissions.Application)))
{
var list = clientContext.Web.Lists.GetByTitle(SPLists.Reasons.Title);
ListItem listItem = list.AddItem(new ListItemCreationInformation());
listItem[SPLists.Reasons.Columns.Metric] = SharePointHelper.BuildSingleLookFieldValue(item.Metric.Id, item.Metric.Name);
listItem[SPLists.Reasons.Columns.Title] = item.Name;
listItem[SPLists.Reasons.Columns.State] = 1;
listItem[SPLists.Reasons.Columns.ReasonTracking] = item.ReasonTracking;
listItem[SPLists.Reasons.Columns.ValueType] = item.ValueType;
listItem[SPLists.Reasons.Columns.TrackingFrequency] = Convert.ToString(item.TrackingFrequency);
listItem.Update();
clientContext.Load(listItem);
clientContext.ExecuteQuery();
item.Id = listItem.Id;
}
}
public static async Task InsertItemAsync(Issue item)
{
using (var clientContext = await(AuthenticationHelper.GetSharePointClientContextAsync(Permissions.Application)))
{
var list = clientContext.Web.Lists.GetByTitle(SPLists.Issues.Title);
ListItemCreationInformation newItem = new ListItemCreationInformation();
ListItem listItem = list.AddItem(new ListItemCreationInformation());
listItem[SPLists.Issues.Columns.Category] = SharePointHelper.BuildSingleLookFieldValue(item.Category.Id, item.Category.Name);
listItem[SPLists.Issues.Columns.Title] = item.Name;
listItem[SPLists.Issues.Columns.State] = item.State;
listItem[SPLists.Issues.Columns.IssueMetric] = item.Metric;
listItem[SPLists.Issues.Columns.TargetGoal] = item.TargetGoal;
listItem[SPLists.Issues.Columns.TeamId] = item.MSTeamId;
listItem.Update();
clientContext.Load(listItem);
clientContext.ExecuteQuery();
item.Id = listItem.Id;
}
}
public static async Task <int> InsertItemAsync(Issue item)
{
using (var clientContext = await(AuthenticationHelper.GetSharePointClientContextAsync(Permissions.Application)))
{
User newUser = clientContext.Web.EnsureUser(item.Owner);
clientContext.Load(newUser);
clientContext.ExecuteQuery();
FieldUserValue userValue = new FieldUserValue();
userValue.LookupId = newUser.Id;
var list = clientContext.Web.Lists.GetByTitle(SPLists.Issues.Title);
ListItem listItem = list.AddItem(new ListItemCreationInformation());
listItem[SPLists.Issues.Columns.Category] = SharePointHelper.BuildSingleLookFieldValue(item.Category.Id, item.Category.Name);
listItem[SPLists.Issues.Columns.Title] = item.Name;
listItem[SPLists.Issues.Columns.State] = item.State;
listItem[SPLists.Issues.Columns.TeamId] = item.MSTeamId;
listItem[SPLists.Issues.Columns.Owner] = userValue;
listItem.Update();
clientContext.Load(listItem);
clientContext.ExecuteQuery();
return(listItem.Id);
}
}
public static async Task UpdateItemAsync(Issue item)
{
using (var clientContext = await(AuthenticationHelper.GetSharePointClientContextAsync(Permissions.Application)))
{
User newUser = clientContext.Web.EnsureUser(item.Owner);
clientContext.Load(newUser);
clientContext.ExecuteQuery();
FieldUserValue userValue = new FieldUserValue();
userValue.LookupId = newUser.Id;
var query = new CamlQuery();
query.ViewXml =
@"<View>
<Query>
<Where>
<Eq>
<FieldRef Name='" + SPLists.Issues.Columns.ID + @"'/>
<Value Type='int'>" + item.Id + @"</Value>
</Eq>
</Where>
</Query>
</View>";
var items = clientContext.GetItems(SPLists.Issues.Title, query);
var queryItem = items.FirstOrDefault();
if (queryItem == null)
{
return;
}
queryItem[SPLists.Issues.Columns.Category] = SharePointHelper.BuildSingleLookFieldValue(item.Category.Id, item.Category.Name);
queryItem[SPLists.Issues.Columns.Title] = item.Name;
queryItem[SPLists.Issues.Columns.State] = item.State;
queryItem[SPLists.Issues.Columns.Owner] = userValue;
queryItem.Update();
clientContext.ExecuteQuery();
}
}
