// GET: Asset/Edit/5 public ActionResult List() { List <LocatedAssetsViewModel> model = new List <LocatedAssetsViewModel>(); AssetManagementEntities entities = new AssetManagementEntities(); try { List <AssetLocations> assets = entities.AssetLocations.ToList(); //muodostetaan näkymämalli tietokannan rivien pohjalta CultureInfo fiFI = new CultureInfo("fi-FI"); foreach (AssetLocations asset in assets) { LocatedAssetsViewModel view = new LocatedAssetsViewModel(); view.Id = asset.AssetLocationId; view.LocationCode = asset.Location.Code; view.LocationName = asset.Location.Name; view.AssetCode = asset.Asset.Code; view.AssetName = asset.Asset.Type + ": " + asset.Asset.Model; view.LastSeen = asset.LastSeen.Value.ToString("dd.MM.yyyy"); //view.LastSeen = asset.LastSeen.Value.ToString("fiFI"); //[vaihtoehto] model.Add(view); } } finally { entities.Dispose(); } return(View(model)); }
public ActionResult ListJson() { List <LocatedAssetsViewModel> model = new List <LocatedAssetsViewModel>(); Omat_tietokannatEntities entities = new Omat_tietokannatEntities(); try { List <AssetLocation1> assets = entities.AssetLocations1.ToList(); CultureInfo fiFI = new CultureInfo("fi-FI"); // muodostetaan näkymämalli tietokannan rivien pohjalta foreach (AssetLocation1 asset in assets) { LocatedAssetsViewModel view = new LocatedAssetsViewModel(); view.Id = asset.Id; view.LocationCode = asset.AssetLocation.Code; view.LocationName = asset.AssetLocation.Name; view.AssetCode = asset.Asset.Code; view.AssetName = asset.Asset.Type + ": " + asset.Asset.Model; view.LastSeen = asset.LastSeen.Value.ToString(fiFI); model.Add(view); } } finally { entities.Dispose(); } return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult ListJson() { List <LocatedAssetsViewModel> model = new List <LocatedAssetsViewModel>(); PointSQLSrv1Entities entities = new PointSQLSrv1Entities(); try { List <AssetLocations> assets = entities.AssetLocations.ToList(); //muodostetaan näkymämalli tietokannan rivien pohjalta foreach (AssetLocations asset in assets) { LocatedAssetsViewModel view = new LocatedAssetsViewModel(); view.Id = asset.Id; view.LocationCode = asset.AssetLocation.Code; view.LocationName = asset.AssetLocation.Name; view.AssetCode = asset.Assets.Code; view.AssetName = asset.Assets.Type + ": " + asset.Assets.Model; view.LastSeen = asset.LastSeen.ToString(); model.Add(view); } } finally { entities.Dispose(); } return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult List() { List <LocatedAssetsViewModel> model = new List <LocatedAssetsViewModel>(); ProjektitEntities entities = new ProjektitEntities(); try { List <AssetLocation1> assets = entities.AssetLocations1.ToList(); // muodostetaan näkymämalli tietokannan rivien pohjalta CultureInfo fiFi = new CultureInfo("fi-FI"); foreach (AssetLocation1 asset in assets) { LocatedAssetsViewModel view = new LocatedAssetsViewModel(); view.Id = asset.Id; view.LocationCode = asset.AssetLocation.Code; view.LocationName = asset.AssetLocation.Name; view.AssetCode = asset.Asset.Code; view.AssetName = asset.Asset.Type + ": " + asset.Asset.Model; view.LastSeen = asset.LastSeen.Value.ToString(fiFi); model.Add(view); } } finally { entities.Dispose(); } return(View(model)); }
public ActionResult ListJson() { //listan muodostus List <LocatedAssetsViewModel> model = new List <LocatedAssetsViewModel>(); //TIETOKANTAYHTEYS Asset2Entities entities = new Asset2Entities(); try { //haetaan tietoja tietokannasta List <AssetLocations> assets = entities.AssetLocations.ToList(); //muodostetaan näkymämalli tietokannan rivien pohjalta CultureInfo fiFi = new CultureInfo("fi-Fi"); foreach (AssetLocations asset in assets) { LocatedAssetsViewModel view = new LocatedAssetsViewModel(); view.Id = asset.Id; view.LocationCode = asset.AssetLocation.Code; view.LocationName = asset.AssetLocation.Name; view.AssetCode = asset.Assets.Code; view.AssetName = asset.Assets.Type + ": " + asset.Assets.Model; view.LastSeen = asset.LastSeen.Value.ToString(fiFi); model.Add(view); } } //muistinvapautus finally { entities.Dispose(); } //palautetaan ylempänä luotu model-niminen lista return(Json(model, JsonRequestBehavior.AllowGet)); }