public void UpdateAsset(AssetData newitem)
{
hasError = false;
try
{
using (TraditionAssetEntities db = new TraditionAssetEntities())
{
var asset_ = db.asset.FirstOrDefault(x => x.asset_id == newitem.Asset_id);
if (asset_ != null)
{
asset_.asset_id = newitem.Asset_id;
asset_.os_id = newitem.Os_id;
asset_.asset_type_id = newitem.Asset_type_id;
asset_.supplier_id = newitem.Supplier_id;
asset_.using_by_staff_id = newitem.Using_by_staff_id;
asset_.asset_code = newitem.Asset_code;
asset_.brand = newitem.Brand;
asset_.price = newitem.Price;
asset_.cpu = newitem.Cpu;
asset_.ram = newitem.Ram;
asset_.hdd = newitem.Hdd;
asset_.notes = newitem.Note;
asset_.is_active = newitem.Is_active;
asset_.start_date_warranty = newitem.Start_date_warranty;
asset_.expiry_date_warranty = newitem.Expiry_date_warranty;
asset_.modified_date = DateTime.Now;
db.asset.AddOrUpdate(asset_);
db.SaveChanges();
MessageBox.Show("Update complete");
}
else
{
MessageBox.Show("Can not update");
}
}
}
catch (Exception ex)
{
errorMessage = "Update error, " + ex.Message;
hasError = true;
}
}
public void AddAsset(AssetData item)
{
hasError = false;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var data = new asset()
{
//asset_id = item.Asset_id,
os_id = item.Os_id,
asset_type_id = item.Asset_type_id,
original_supplier_id = item.Original_supplier_id,
supplier_id = item.Supplier_id,
using_by_staff_id = item.Using_by_staff_id,
asset_code = item.Asset_code,
brand = item.Brand,
price = item.Price,
cpu = item.Cpu,
ram = item.Ram,
hdd = item.Hdd,
notes = item.Note,
start_date_warranty = item.Start_date_warranty,
expiry_date_warranty = item.Expiry_date_warranty,
is_active = item.Is_active,
create_date = DateTime.Now,
modified_date = DateTime.Now
};
db.asset.Add(data);
db.SaveChanges();
MessageBox.Show("Insert complete");
}
catch (Exception ex)
{
errorMessage = "Add error, " + ex.Message;
hasError = true;
}
}
public ObservableCollection <AssetData> GetAsset()
{
hasError = false;
ObservableCollection <AssetData> _asset = new ObservableCollection <AssetData>();
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.asset.ToList();
foreach (var item in query)
{
AssetData pTemp = new AssetData(/*item*/);
pTemp.Asset_id = item.asset_id;
pTemp.Os_id = (int)item.os_id;
pTemp.Asset_type_id = (int)item.asset_type_id;
pTemp.Original_supplier_id = (int)item.original_supplier_id;
pTemp.Supplier_id = (int)item.supplier_id;
pTemp.Using_by_staff_id = (int)item.using_by_staff_id;
pTemp.Asset_code = item.asset_code;
pTemp.Brand = item.brand;
pTemp.Price = (decimal)item.price;
if (item.cpu == null)
{
pTemp.Cpu = "-";
}
else
{
pTemp.Cpu = item.cpu;
}
if (item.ram == null)
{
pTemp.Ram = "-";
}
else
{
pTemp.Ram = item.ram;
}
if (item.hdd == null)
{
pTemp.Hdd = "-";
}
else
{
pTemp.Hdd = item.hdd;
}
pTemp.Note = item.notes;
pTemp.Start_date_warranty = (DateTime)item.start_date_warranty;
pTemp.Expiry_date_warranty = (DateTime)item.expiry_date_warranty;
pTemp.Is_active = (bool)item.is_active;
pTemp.Create_date = (DateTime)item.create_date;
pTemp.Modified_date = (DateTime)item.modified_date;
//if (pTemp.Is_active == true)
//{
_asset.Add(pTemp);
//}
}
}
catch (Exception ex)
{
errorMessage = "GetAsset() error, " + ex.Message;
hasError = true;
}
return(_asset);
}
