public WorkItem Add(WorkItem workItem) { var sqlQuery = "INSERT INTO WorkItem (Title, Description, DateCreated, Status_Id, DateFinished) " + "VALUES (@Title, @Description,'" + DateTime.Now.ToShortDateString() + "', 1, NULL)" + "SELECT Id FROM WorkItem WHERE Id = scope_identity()"; if (workItem == null) return null; var workitemId = _dbConnection.QueryWithRetry<WorkItem>(sqlQuery, new { workItem.Title, workItem.Description }).First(); workItem.Id = workitemId.Id; workItem.DateCreated = DateTime.Now.ToShortDateString(); return workItem; }
public WorkItem CreateWorkItem(WorkItem workItem) { try { if(workItem == null) throw new NullReferenceException(); var newWorkItem = _workItemRepository.Add(workItem); return newWorkItem; } catch (Exception e) { throw new Exception(e.Message); } }