public List<CMSTemplateKey> SelectTemplateKeysByID(int id)
{
CMSTemplateKey c = null;
List<CMSTemplateKey> listOfKeys = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CMSTemplateKeys_GetByTemplateId"
, inputParamMapper: delegate (SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}, map: delegate (IDataReader reader, short set)
{
c = new CMSTemplateKey();
int startingIndex = 0; //startingOrdinal
c.Id = reader.GetSafeInt32(startingIndex++);
c.Type = reader.GetSafeInt32(startingIndex++);
c.KeyName = reader.GetSafeString(startingIndex++);
c.TemplateId = reader.GetSafeInt32(startingIndex++);
if (listOfKeys == null)
{
listOfKeys = new List<CMSTemplateKey>();
}
listOfKeys.Add(c);
}
);
return listOfKeys;
}
public CMSTemplateKey GetKeyById(int id)
{
CMSTemplateKey c = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CMSTemplateKeys_SelectByID"
, inputParamMapper: delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}, map: delegate(IDataReader reader, short set)
{
c = new CMSTemplateKey();
int startingIndex = 0; //startingOrdinal
c.Id = reader.GetSafeInt32(startingIndex++);
c.Type = reader.GetSafeInt32(startingIndex++);
c.KeyName = reader.GetSafeString(startingIndex++);
c.TemplateId = reader.GetSafeInt32(startingIndex++);
}
);
return c;
}
