public CMSTemplate SelectTemplateByID(int id) { CMSTemplate c = null; DataProvider.ExecuteCmd(GetConnection, "dbo.CMSTemplates_SelectByID" , inputParamMapper: delegate (SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", id); }, map: delegate (IDataReader reader, short set) { c = new CMSTemplate(); int startingIndex = 0; //startingOrdinal c.Id = reader.GetSafeInt32(startingIndex++); c.Name = reader.GetSafeString(startingIndex++); c.Path = reader.GetSafeString(startingIndex++); } ); return c; }
public List<CMSTemplate> SelectAllTemplates() { List<CMSTemplate> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.CMSTemplates_SelectAll" , inputParamMapper: delegate(SqlParameterCollection paramCollection) { } , map: delegate(IDataReader reader, short set) { CMSTemplate c = new CMSTemplate(); int startingIndex = 0; c.Id = reader.GetSafeInt32(startingIndex++); c.Name = reader.GetSafeString(startingIndex++); c.Path = reader.GetSafeString(startingIndex++); if (list == null) { list = new List<CMSTemplate>(); } list.Add(c); } ); return list; }