// update public void Update(EVA_AttributeRequestModel model) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.EVA_Attribute_Update" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@ID", model.ID); paramCollection.AddWithValue("@Name", model.Name); paramCollection.AddWithValue("@Slug", model.Slug); paramCollection.AddWithValue("@Description", model.Description); paramCollection.AddWithValue("@DataType", model.DataType); }, returnParameters : delegate(SqlParameterCollection param) { } ); }
// create public int Insert(EVA_AttributeRequestModel model) { int uid = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.EVA_Attribute_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Name", model.Name); paramCollection.AddWithValue("@Slug", model.Slug); paramCollection.AddWithValue("@Description", model.Description); paramCollection.AddWithValue("@DataType", model.DataType); SqlParameter p = new SqlParameter("@OID", System.Data.SqlDbType.Int); p.Direction = System.Data.ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { int.TryParse(param["@OID"].Value.ToString(), out uid); } ); return(uid); }