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(); } } }