public IEnumerable <BuildingDTO> Get() { List <BuildingDTO> l = new List <BuildingDTO>(); foreach (Building b in modelloDatiDbContext.Buildings) { l.Add(BuildingConverter.convertToDto(b)); } return(l); }
public List <BuildingDTO> GetByInstaller(string username) { //Ottengo il customer con lo username passatomi come parametro Customer customer = modelloDatiDbContext.Customers.Where(c => c.Username.Equals(username)).FirstOrDefault(); //Ottengo la lista di building che hanno come customerID (chiave esterna) l'id del customer trovato in precedenza List <Building> buildings = modelloDatiDbContext.Buildings.Where(b => b.Customer.CustomerID == customer.CustomerID).ToList(); List <BuildingDTO> buildingDTOs = new List <BuildingDTO>(); foreach (Building b in buildings) { buildingDTOs.Add(BuildingConverter.convertToDto(b)); } return(buildingDTOs); }
public BuildingDTO Modifica(int buildingID, String indirizzo, String cap, String citta, String interno) { Building building = new Building(); foreach (Building b in modelloDatiDbContext.Buildings) { if (b.BuildingID == buildingID) { building = modelloDatiDbContext.Buildings.Where(bb => bb.BuildingID == buildingID).FirstOrDefault(); building.Indirizzo = indirizzo; building.Cap = cap; building.Citta = citta; building.Interno = interno; //building.Customer = modelloDatiDbContext.Customers.Find(customerID); } } modelloDatiDbContext.SaveChanges(); return(BuildingConverter.convertToDto(building)); }
public BuildingDTO Get(int id) { Building b = modelloDatiDbContext.Buildings.Where(build => build.BuildingID == id).FirstOrDefault(); return(BuildingConverter.convertToDto(b)); }