public Dictionary <int, string> GetItemTypesByOrderType(OrderType orderType) { var itemTypes = new Dictionary <int, string>(); using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = @" SELECT IT.ItemType_ID, IT.Code FROM dbo.OrderTypeItemType AS OTIT INNER JOIN dbo.ItemType AS IT ON OTIT.ItemType_ID = IT.ItemType_ID INNER JOIN dbo.OrderType AS OT ON OTIT.OrderType_ID = OT.OrderType_ID WHERE OT.Code = @orderTypeCode"; command.CommandType = CommandType.Text; command.Parameters.Add(new SqlParameter("orderTypeCode", EnumUtility.CctCodeValueOf(orderType))); using (var reader = command.ExecuteReader()) { while (reader.Read()) { itemTypes.Add(Convert.ToInt32(reader["ItemType_ID"]), Convert.ToString(reader["Code"])); } } } } return(itemTypes); }
public Dictionary <int, string> GetPickListItemsByPickListType(PickListType pickListType) { var pickListItems = new Dictionary <int, string>(); using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = @" SELECT PLI.PickListItem_ID, PLI.Code FROM dbo.PickListItem AS PLI INNER JOIN dbo.PickList AS PL ON PLI.PickList_ID = PL.PickList_ID WHERE PL.Code = @pickListCode" ; command.CommandType = CommandType.Text; command.Parameters.Add(new SqlParameter("pickListCode", EnumUtility.CctCodeValueOf(pickListType))); using (var reader = command.ExecuteReader()) { while (reader.Read()) { pickListItems.Add(Convert.ToInt32(reader["PickListItem_ID"]), Convert.ToString(reader["Code"])); } } } } return(pickListItems); }