public MetadataModel(int mainId, MetaDataTypeEnum dataType)
{
SortMainId = mainId;
MetaDataType = dataType.ToString();
Metadata = SortMetaDataObject.GetSortMetaDatas(SortMainId, MetaDataTypeEnum);
}
public List <SortMetaDataObject> GetSortMetaDatas(int sortMainId, MetaDataTypeEnum metaDataType)
{
string sql = @" SELECT d.*, s.Title as 'SortTitle'
FROM dat_SortMetaData d
inner join dat_SortMain s on s.SortMainId = d.SortMainId
WHERE d.SortMainId = @SortMainId
AND d.MetaDataType = @MetaDataType";
return(Config.Conn.Query <SortMetaDataObject>(sql, new { SortMainId = sortMainId, MetaDataType = metaDataType.ToString() }).ToList());
}
