public IEnumerable <AvbItemTypeDto> getItemType()
{
IAvbRequestItemRepository avbRequestItemRepository = new AvbRequestItemRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
string sql = "SELECT ID id, " +
"ITEM_TYPE_NAME itemTypeName, " +
"[DESCRIPTION] description " +
"FROM [EVENT].ITEM_TYPE ";
return(avbRequestItemRepository.SqlQuery <AvbItemTypeDto>(sql));
}
IEnumerable <AvbItemDto> IAvbRequestFormService.getItem(int itemTypeId)
{
IAvbRequestItemRepository avbRequestItemRepository = new AvbRequestItemRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
string sql = " SELECT ID id, " +
" ITEM_NAME itemName, " +
" DESCRIPTION description " +
" FROM [EVENT].ITEM " +
" WHERE ITEM_TYPE_ID =@itemTypeId ";
return(avbRequestItemRepository.SqlQuery <AvbItemDto>(sql, new object[] { new SqlParameter("@itemTypeId", itemTypeId) }));
}
public IEnumerable <AvbItemDto> getItem(string itemTypeName)
{
IAvbRequestItemRepository avbRequestItemRepository = new AvbRequestItemRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
string sql = @"SELECT
I.ID id,
I.ITEM_NAME itemName,
I.[DESCRIPTION] description
FROM [EVENT].ITEM I INNER JOIN [EVENT].[ITEM_TYPE] T ON T.ID = I.ITEM_TYPE_ID
WHERE T.ITEM_TYPE_NAME = @itemTypeName";
return(avbRequestItemRepository.SqlQuery <AvbItemDto>(sql, new object[] { new SqlParameter("@itemTypeName", itemTypeName) }));
}
