//method that adds a new asset type to the database
public static void Add(AssetType assetType)
{
var context = new AssetsContext();
context.AssetTypes.Add(assetType); //add the asset to the context
context.SaveChanges(); //save changes to the database
}
public static void Add(AssetType newAsset)
{
var context = new AssetsContext();
context.AssetTypes.Add(newAsset);
context.SaveChanges();
}
//method to get all asset types from the datbase and return them as a list
public static List <AssetType> GetAll()
{
var context = new AssetsContext();
var assetTypes = context.AssetTypes.Include(rp => rp).ToList();
return(assetTypes);
}
public static List <Asset> GetAll()
{
var context = new AssetsContext();
var assets = context.Assets.Include(r => r.AssetType).ToList();
return(assets);
}
// add new type
public static void AddNewType(AssetType type)
{
var context = new AssetsContext();
context.AssetTypes.Add(type);
context.SaveChanges();
}
public static Asset Find(int id)
{
var context = new AssetsContext();
var originalAsset = context.Assets.Find(id);
return(originalAsset);
}
public static AssetType Find(int id)
{
var context = new AssetsContext();
var assetType = context.AssetTypes.Find(id);
return(assetType);
}
public static List <Asset> GetAll()
{
AssetsContext context = new AssetsContext();
List <Asset> assets = context.Assets.Include(type => type.AssetType).ToList();
return(assets);
}
public static List <Asset> GetAssetsByAssetType(int assetTypeId)
{
var context = new AssetsContext();
var AssetList = context.Assets.Include(a => a.AssetType).Where(a => a.AssetTypeId == assetTypeId).ToList();
return(AssetList);
}
public static void Add(AssetType assetType)
{
AssetsContext context = new AssetsContext();
context.AssetTypes.Add(assetType);
context.SaveChanges();
}
public static List <Asset> GetAllAssets()
{
var context = new AssetsContext();
var AssetList = context.Assets.Include(a => a.AssetType).ToList(); // Join the AssetType table
return(AssetList);
}
public static Asset GetAssetByAssetId(int id)
{
var context = new AssetsContext();
var asset = context.Assets.Include(a => a.AssetType).SingleOrDefault(a => a.Id == id);
return(asset);
}
public static IList <AssetType> GetAll()
{
var context = new AssetsContext();
var assetType = context.AssetTypes.OrderBy(a => a.Name).ToList();
return(assetType);
}
public static List <Asset> GetAllByAssetType(int id)
{
var context = new AssetsContext();
var asset = context.Assets.Where(at => at.AssetTypeId == id).Include(a => a.AssetType).ToList();
return(asset);
}
public static List <Asset> GetAll()
{
var context = new AssetsContext();
var asset = context.Assets.Include(at => at.AssetType).OrderBy(a => a.AssetType).ToList();
return(asset);
}
// add a new asset
public static void AddNewAsset(Asset asset)
{
var context = new AssetsContext();
context.Assets.Add(asset);
context.SaveChanges();
}
public static List <AssetType> GetAll()
{
var context = new AssetsContext();
var assets = context.AssetTypes.ToList();
return(assets);
}
public static void update(AssetType assetType)
{
var context = new AssetsContext();
var originalAssetType = context.AssetTypes.Find(assetType.Id);
originalAssetType.Name = assetType.Name;
context.SaveChanges();
}
public static List <Asset> GetAllByAssetType(int id)
{
var context = new AssetsContext();
var assets = context.Assets.
Where(p => p.AssetTypeID == id).Include(rp => rp.AssetType).ToList();
return(assets);
}
// get all
public static List <Asset> GetAllAssets()
{
var context = new AssetsContext();
return(context.Assets.
Include(a => a.AssetType).
OrderBy(a => a.AssetTypeId).
ToList());
}
public static string GetNameByTypeId(int typeId)
{
var context = new AssetsContext();
string result = (from at in context.AssetTypes
where at.Id == typeId
select at.Name).First().ToString();
return(result);
}
// get a certain type assets
public static List <Asset> GetAssetsById(int id)
{
var context = new AssetsContext();
return(context.Assets.
Where(a => a.AssetTypeId == id).
Include(a => a.AssetType).
ToList());
}
public AssetsController(AssetsContext context, IConfiguration iConfig)
{
//_context = context;
var optionsBuilder = new DbContextOptionsBuilder <AssetsContext>();
optionsBuilder.UseSqlServer(iConfig.GetConnectionString("DefaultConnection"));
_context = new AssetsContext(optionsBuilder.Options);
}
public static void UpdateAssetType(AssetType newAssetType)
{
var context = new AssetsContext();
var assetType = context.AssetTypes.SingleOrDefault(a => a.Id == newAssetType.Id);
assetType.Name = newAssetType.Name;
context.SaveChanges();
}
// get type by id
public static void Update(AssetType newType)
{
var context = new AssetsContext();
var old = context.AssetTypes.Include(at => at.Assets).
SingleOrDefault(at => at.Id == newType.Id);
old.Name = newType.Name;
context.SaveChanges();
}
//method to get all assets from the database by type of asset and return
//as a list
public static List <Asset> GetAllByAssetType(int id)
{
var context = new AssetsContext();
var assets = context.Assets.
Where(a => a.AssetTypeId == id). //get the asset for the id past to method
Include(rp => rp.AssetType) //get the assets type for dropdown
.ToList();
return(assets);
}
public static IList GetAsKeyValuePairs()
{
var context = new AssetsContext();
var types = context.AssetTypes.Select(a => new {
a.Id,
a.Name
}).ToList();
return(types);
}
//method to get all asset types from the database and assign to key value pairs
//and return as a list
public static IList GetAsKeyValuePairs()
{
var context = new AssetsContext();
var types = context.AssetTypes.Select(t => new
{
Value = t.Id, //value will be the id
Text = t.Name //text will be the asset type
}).ToList();
return(types);
}
public static IList GetAsKeyValuePair()
{
var context = new AssetsContext();
var types = context.AssetTypes.Select(o => new
{
Value = o.Id,
Text = o.Name
}).ToList();
return(types);
}
public static void Update(Asset asset)
{
var context = new AssetsContext();
var originalAsset = context.Assets.Find(asset.Id);
originalAsset.Manufacturer = asset.Manufacturer;
originalAsset.Model = asset.Model;
originalAsset.SerialNumber = asset.SerialNumber;
originalAsset.TagNumber = asset.TagNumber;
originalAsset.Description = asset.Description;
originalAsset.AssetType = asset.AssetType;
context.SaveChanges();
}
