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); }