public JsonResult Location()
{
string json = Request.InputStream.ReadToEnd();
LocationModel inputData = JsonConvert.DeserializeObject <LocationModel>(json);
bool success = false;
string error = "";
AssetEntities entities = new AssetEntities();
try
{
AssetLocation newEntry = new AssetLocation();
newEntry.Address = inputData.LocationAddress;
newEntry.Code = inputData.LocationCode;
newEntry.Name = inputData.LocationName;
entities.AssetLocations.Add(newEntry);
entities.SaveChanges();
success = true;
}
catch (Exception ex)
{
error = ex.GetType().Name + ": " + ex.Message;
}
finally
{
entities.Dispose();
}
var result = new { success = success, error = error };
return(Json(result));
}
public ActionResult List()
{
List <AssetinNakymaViewModel> model = new List <AssetinNakymaViewModel>();
AssetEntities entities = new AssetEntities();
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)
{
AssetinNakymaViewModel view = new AssetinNakymaViewModel();
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 AssetEntity GetAssetById(string assetId)
{
return(AssetEntities
.Include(x => x.StreamingUrl)
.Include(x => x.AssetMetaDataEntity)
.FirstOrDefault(x => x.Id.ToString()
.Equals(assetId)));
}
public Task <List <AssetEntity> > SearchForAssets(VideoSearchRequest videoSearchRequest)
{
if (videoSearchRequest == null)
{
return(AssetEntities
.Include(x => x.StreamingUrl)
.Include(x => x.AssetMetaDataEntity).Select(x => x).Take(10)
.OrderByDescending(x => x.CreatedDate)
.ToListAsync());
}
throw new NotImplementedException();
}
public static async Task <AssetEntities> GetAllAssetsAsync(this SquidexAssetClient assetClient, int batchSize = 200)
{
var skip = 0;
var entities = new AssetEntities();
do
{
var getResult = await assetClient.GetAssetsAsync(skip : skip, top : batchSize);
entities.Total = getResult.Total;
entities.Items.AddRange(getResult.Items);
skip += entities.Items.Count;
}while (skip < entities.Total);
return(entities);
}
public static async Task <AssetEntities> GetAllAssetsAsync(this SquidexAssetClient assetClient, int batchSize = 200)
{
var query = new ODataQuery {
Top = batchSize, Skip = 0
};
var entities = new AssetEntities();
do
{
var getResult = await assetClient.GetAssetsAsync(query);
entities.Total = getResult.Total;
entities.Items.AddRange(getResult.Items);
query.Skip = entities.Items.Count;
}while (query.Skip < entities.Total);
return(entities);
}
public JsonResult AssignLocation()
{
string json = Request.InputStream.ReadToEnd();
AssignLocationModel inputData = JsonConvert.DeserializeObject <AssignLocationModel>(json);
bool success = false;
string error = "";
AssetEntities entities = new AssetEntities();
try
{
int LocationId = (from l in entities.AssetLocations
where l.Code == inputData.LocationCode
select l.Id).FirstOrDefault();
int AssetId = (from a in entities.Assets
where a.Code == inputData.AssetCode
select a.Id).FirstOrDefault();
if (LocationId > 0 && AssetId > 0)
{
AssetLocation1 newEntry = new AssetLocation1();
newEntry.AssetId = AssetId;
newEntry.LocationId = LocationId;
newEntry.LastSeen = DateTime.Now;
entities.AssetLocations1.Add(newEntry);
entities.SaveChanges();
success = true;
}
}
catch (Exception ex)
{
error = ex.GetType().Name + ": " + ex.Message;
}
finally
{
entities.Dispose();
}
var result = new { success = success, error = error };
return(Json(result));
}
public async Task <AssetEntity> CreateUpdateAssetEntity(MediaAsset mediaAsset)
{
var assetEntity = AssetEntity.CreateInstance();
assetEntity.Id = Guid.NewGuid();
assetEntity.FileName = mediaAsset.FormFile.FileName;
assetEntity.AssetName = mediaAsset.AssetName;
assetEntity.InputAssetName = mediaAsset.InputAssetName;
assetEntity.OutputAssetName = mediaAsset.OutputAssetName;
assetEntity.JobName = mediaAsset.JobName;
assetEntity.LocatorName = mediaAsset.LocatorName;
assetEntity.StreamingUrl = mediaAsset.StreamingUrls.Select(x =>
{
var url = new StreamingUrl
{
Id = Guid.NewGuid(), AssetEntityId = assetEntity.Id, AssetEntity = assetEntity, Url = x.Url
};
return(url);
}).ToHashSet();
assetEntity.AssetMetaDataEntity = new AssetMetaDataEntity
{
Id = Guid.NewGuid(),
AssetEntityId = assetEntity.Id,
AssetEntity = assetEntity,
FirstName = mediaAsset.AssetMetaData.FirstName,
LastName = mediaAsset.AssetMetaData.LastName,
PhoneNumber = mediaAsset.AssetMetaData.PhoneNumber,
Street = mediaAsset.AssetMetaData.Street,
ZipCode = mediaAsset.AssetMetaData.ZipCode,
City = mediaAsset.AssetMetaData.City,
State = mediaAsset.AssetMetaData.State,
Date = mediaAsset.AssetMetaData.Date,
Time = mediaAsset.AssetMetaData.Time
};
await AssetEntities.AddAsync(assetEntity);
await SaveChangesAsync();
return(assetEntity);
}
public async Task <AssetEntity> GetAssetsByName(string filename)
{
return(await AssetEntities
.Include(x => x.StreamingUrl)
.FirstOrDefaultAsync(x => x.FileName == filename));
}
