// GET api/<controller>/5
public List <itemDeployedModel> Get(int id)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <itemDeployedModel> items = new List <itemDeployedModel>();
List <ItemDeployed> list = (from item in db.ItemDeployeds
where id == item.deployedID
select item).ToList();
foreach (ItemDeployed item in list)
{
projectModel newProject = new projectModel(item.Project.projectName);
typeModel newType = new typeModel(item.Item.SubType.Type.typeID, item.Item.SubType.Type.typeName);
subTypeModel newSubType = new subTypeModel(item.Item.SubType.subTypeID, newType, item.Item.SubType.subTypeName, item.Item.SubType.description);
itemModel itemModel = new itemModel(item.itemID, newSubType, item.Item.itemNote);
itemDeployedModel newDeploy = new itemDeployedModel(newProject, itemModel, item.location, item.date.ToString(), item.notes);
items.Add(newDeploy);
}
return(items);
}
//method to return the list of itemsIssued makes the code more modular
private List <itemsIssuedModel> populateList(List <ItemIssue> allItemsLinq)
{
List <itemsIssuedModel> itemsIssued = new List <itemsIssuedModel>();
foreach (var item in allItemsLinq)
{
typeModel newType = new typeModel(item.Item.SubType.Type.typeID, item.Item.SubType.Type.typeName);
subTypeModel newSubType = new subTypeModel(item.Item.SubType.subTypeID, newType, item.Item.SubType.subTypeName, item.Item.SubType.description);
itemModel itemModel = new itemModel(item.itemID, newSubType, item.Item.itemNote);
personModel newPerson = new personModel(item.Person.personID, item.Person.name, item.Person.phoneNumber, item.Person.email);
itemsIssuedModel newItem = new itemsIssuedModel(item.issueID, newPerson, itemModel, item.itemReturned);
itemsIssued.Add(newItem);
}
return(itemsIssued);
}
// GET api/<controller>
public IEnumerable <itemModel> Get()
{
List <itemModel> itemList = new List <itemModel>();
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
var allItems = from theItem in db.Items
select theItem;
foreach (var item in allItems)
{
typeModel newType = new typeModel(item.SubType.typeID, item.SubType.Type.typeName);
subTypeModel newSubType = new subTypeModel(item.SubType.subTypeID, newType, item.SubType.subTypeName, item.SubType.description);
itemModel itemModel = new itemModel(item.itemID, newSubType, item.itemNote);
itemList.Add(itemModel);
}
return(itemList);
}
