public void Named_WithNull() { Action action = () => InputParameter.Named(null); action.Should().Throw <ArgumentNullException>(); }
public List <Item> GetItems(string searchItem) { List <Item> items = new List <Item>(); List <Location> locations = new List <Location>(); try { StoredProcedure coreCustomerProcedure = new StoredProcedure(""); coreCustomerProcedure.WithParameters(InputParameter.Named("SearchItem").WithValue(searchItem)); //using (IDataReader datareader = DataConnectionHelper.GetConnectionManager().ExecuteReader(coreCustomerProcedure)) //{ // while (datareader.Read()) // { // Item item = new Item(); // item.ItemId = datareader.GetInt32OrDefault("ItemId"); // item.ItemName = datareader.GetStringOrDefault("ItemName"); // items.Add(item); // } // datareader.NextResult(); // while (datareader.Read()) // { // Location location = new Location(); // location.LocationId = datareader.GetInt32OrDefault("LocationId"); // location.ItemId = datareader.GetInt32OrDefault("ItemId"); // location.ItemCount = datareader.GetInt32OrDefault("ItemCount"); // location.LocationName = datareader.GetStringOrDefault("Name"); // locations.Add(location); // } //} items = new List <Item>() { new Item() { ItemId = 100, ItemName = "Item 1", Locations = new List <Location>() { new Location() { LocationId = 1, LocationName = "Bangalore", ItemCount = 10 }, new Location() { LocationId = 2, LocationName = "Hyderabad", ItemCount = 20 }, new Location() { LocationId = 3, LocationName = "Chennai", ItemCount = 30 } } }, new Item() { ItemId = 101, ItemName = "Item 2", Locations = new List <Location>() { new Location() { LocationId = 1, LocationName = "Bangalore", ItemCount = 15 }, new Location() { LocationId = 2, LocationName = "Hyderabad", ItemCount = 25 }, new Location() { LocationId = 3, LocationName = "Chennai", ItemCount = 35 } } }, new Item() { ItemId = 102, ItemName = "Item 3", Locations = new List <Location>() { new Location() { LocationId = 1, LocationName = "Bangalore", ItemCount = 18 }, new Location() { LocationId = 2, LocationName = "Hyderabad", ItemCount = 28 }, new Location() { LocationId = 3, LocationName = "Chennai", ItemCount = 38 } } } }; } catch (Exception ex) { } return(items); }