public static void Add(Asset asset)
{
var context = new AssetTrackContext();
context.Assets.Add(asset);
context.SaveChanges();
}
public static void Delete(Asset asset)
{
var context = new AssetTrackContext();
context.Assets.Remove(asset);
context.SaveChanges();
}
public static Asset Find(int id)
{
var context = new AssetTrackContext();
var asset = context.Assets.Find(id);
return(asset);
}
public static List <Asset> GetAll()
{
var context = new AssetTrackContext();
var assets = context.Assets.Include(rp => rp.AssetType).ToList();
return(assets);
}
public static AssetType Find(int id)
{
var context = new AssetTrackContext();
var assetType = context.AssetTypes.Find(id);
return(assetType);
}
public static List <AssetType> GetAll()
{
var context = new AssetTrackContext();
var assetTypes = context.AssetTypes.OrderBy(o => o.Name).ToList();
return(assetTypes);
}
public static List <Asset> GetAllByAssetType(int id)
{
var context = new AssetTrackContext();
var assets = context.Assets.
Where(prop => prop.AssetTypeId == id).Include(rp => rp.AssetType).ToList();
return(assets);
}
public static void Update(AssetType assetType)
{
var context = new AssetTrackContext();
var originalAssetType = context.AssetTypes.Find(assetType.Id);
originalAssetType.Name = assetType.Name;
context.SaveChanges();
}
public static IList GetAsKeyValuePairsById(int id)
{
var context = new AssetTrackContext();
var types = context.AssetTypes.Where(cs => cs.Id == id).Select(type => new
{
Value = type.Id,
Text = type.Name
}).ToList();
return(types);
}
public static IList GetAsKeyValuePairs()
{
var context = new AssetTrackContext();
var types = context.AssetTypes.Select(type => new
{
Value = type.Id,
Text = type.Name
}).ToList();
return(types);
}
public static void Update(Asset asset)
{
var context = new AssetTrackContext();
var originalAsset = context.Assets.Find(asset.Id);
originalAsset.TagNumber = asset.TagNumber;
originalAsset.AssetTypeId = asset.AssetTypeId;
originalAsset.Manufacturer = asset.Manufacturer;
originalAsset.Model = asset.Model;
originalAsset.Description = asset.Description;
originalAsset.SerialNumber = asset.SerialNumber;
context.SaveChanges();
}
