public List <ToDoListDomain> GetAll()
{
List <ToDoListDomain> list = null;
_dataProvider.ExecuteCmd("dbo.ToDoList_SelectAll"
, inputParamMapper : null
, singleRecordMapper : delegate(IDataReader reader, short set)
{
ToDoListDomain singleItem = new ToDoListDomain();
int startingIndex = 0; //startingOrdinal
singleItem.Id = reader.GetSafeInt32(startingIndex++);
singleItem.ToDoItem = reader.GetSafeString(startingIndex++);
singleItem.Priority = reader.GetSafeInt32(startingIndex++);
singleItem.DateCreated = reader.GetSafeDateTime(startingIndex++);
singleItem.DateModified = reader.GetSafeUtcDateTimeNullable(startingIndex++);
singleItem.DateCompleted = reader.GetSafeUtcDateTimeNullable(startingIndex++);
//not going to create list if there's no data / lazy load / if statement
if (list == null)
{
list = new List <ToDoListDomain>();
}
list.Add(singleItem);
});
return(list);
}
public void Update(ToDoListDomain model)
{
_dataProvider.ExecuteNonQuery("dbo.ToDoList_Update"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ToDoItem", model.ToDoItem);
paramCollection.AddWithValue("@Priority", model.Priority);
paramCollection.AddWithValue("@Id", model.Id);
});
}
public HttpResponseMessage Insert(ToDoListDomain model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, ModelState));
}
else
{
ItemResponse <int> response = new ItemResponse <int>();
response.Item = listService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, model));
}
}
public HttpResponseMessage Update(ToDoListDomain model)
{
try
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
listService.Update(model);
return(Request.CreateResponse(HttpStatusCode.OK, model));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public int Insert(ToDoListDomain model)
{
int Id = 0;
_dataProvider.ExecuteNonQuery("dbo.ToDoList_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ToDoItem", model.ToDoItem);
paramCollection.AddWithValue("@Priority", model.Priority);
SqlParameter idParameter = new SqlParameter("@Id", System.Data.SqlDbType.Int);
idParameter.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(idParameter);
}, returnParameters : delegate(SqlParameterCollection param)
{
Int32.TryParse(param["@Id"].Value.ToString(), out Id);
});
return(Id);
}
