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