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