private void Include(ItemsDTO items)
{
using (var db = new AzWorkItemContext())
{
var newWorkItem = FillWorkItem(items);
db.WorkItems.Add(newWorkItem);
db.SaveChanges();
}
}
private void Edit(ItemsDTO items)
{
using (var db = new AzWorkItemContext())
{
var workItemOriginal = db.WorkItems.FirstOrDefault(w => w.Id == items.Id);
workItemOriginal.WorkItemType = items.WorkItemType;
workItemOriginal.Title = items.Title;
workItemOriginal.CreatedDate = items.CreatedDate;
db.SaveChanges();
}
}
public ActionResult <ItemsDTO[]> GetWorkItems()
{
using (var db = new AzWorkItemContext())
{
return(db.WorkItems
.Select(w => new ItemsDTO()
{
Id = w.Id,
Title = w.Title,
CreatedDate = w.CreatedDate,
WorkItemType = w.WorkItemType
})
.ToArray());
}
}
private void RecuperaItemsIds(List <ItemsDTO> items)
{
using (var db = new AzWorkItemContext())
{
var workItems = db.WorkItems
.Select(w => new
{
w.Id,
w.IdWorkItem
})
.ToArray();
foreach (var item in items)
{
item.Id = workItems
.Where(w => w.IdWorkItem == item.IdWorkItem)
.Select(w => w.Id)
.FirstOrDefault();
}
}
}
