// GET: Asset
private Ms_Asset[] GridAsset()
{
dc = new DCAssetDataContext();
List <Ms_Asset> msasset = new List <Ms_Asset>();
try
{
var query = dc.MsAsset_View("", "G");
foreach (var res in query)
{
Ms_Asset asset = new Ms_Asset();
asset.Photo = res.AssetPhoto;
asset.AssetCode = res.AssetTagID;
asset.AssetName = res.AssetName;
asset.AssetBrandCode = res.AssetBrand;
asset.PurchaseDate = res.PurchaseDate;
double price = Convert.ToDouble(res.PurchasePrice);
asset.PurchasePrice = res.CurrencyCode + " " + price.ToString("N0");
asset.bStatus = res.NamaStatus;
msasset.Add(asset);
}
}
catch
{
msasset = null;
}
return(msasset.ToArray());
}