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