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