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