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