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