public static async Task UpdateItemAsync(ReasonValue item)
{
using (var clientContext = await(AuthenticationHelper.GetSharePointClientContextAsync(Permissions.Application)))
{
var query = new CamlQuery();
query.ViewXml =
@"<View>
<Query>
<Where>
<Eq>
<FieldRef Name='" + SPLists.ReasonValues.Columns.ID + @"'/>
<Value Type='int'>" + item.Id + @"</Value>
</Eq>
</Where>
</Query>
</View>";
var items = clientContext.GetItems(SPLists.ReasonValues.Title, query);
var queryItem = items.FirstOrDefault();
if (queryItem == null)
{
return;
}
queryItem[SPLists.ReasonValues.Columns.Value] = item.Value;
queryItem.Update();
clientContext.ExecuteQuery();
}
}
public static object ToJson(this ReasonValue reasonValue)
{
return(new
{
id = reasonValue.Id,
reason = reasonValue.Reason.ToJson(),
reasonMetricValues = reasonValue.Value,
inputDate = reasonValue.InputDate
});
}
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;
}
}
