public void UpdateAssetType(AssetTypeData newitem) { hasError = false; try { using (TraditionAssetEntities db = new TraditionAssetEntities()) { var assettype_ = db.asset_type.FirstOrDefault(x => x.asset_type_id == newitem.asset_type_id); if (assettype_ != null) { assettype_.asset_type_name = newitem.asset_type_name; assettype_.is_active = newitem.is_active; assettype_.modified_date = DateTime.Now; db.asset_type.AddOrUpdate(assettype_); db.SaveChanges(); MessageBox.Show("Update complete"); } else { MessageBox.Show("Can not update"); } } } catch (Exception ex) { errorMessage = "Update error, " + ex.Message; hasError = true; } }
public ObservableCollection <AssetTypeData> GetAssetType() { hasError = false; ObservableCollection <AssetTypeData> _asset_type = new ObservableCollection <AssetTypeData>(); try { TraditionAssetEntities db = new TraditionAssetEntities(); var query = db.asset_type.ToList(); foreach (var item in query) { AssetTypeData pTemp = new AssetTypeData(/*item*/); pTemp.asset_type_id = item.asset_type_id; pTemp.asset_type_name = item.asset_type_name; pTemp.is_active = (bool)item.is_active; pTemp.create_date = (DateTime)item.create_date; pTemp.modified_date = (DateTime)item.modified_date; _asset_type.Add(pTemp); } } catch (Exception ex) { errorMessage = "GetAsset() error, " + ex.Message; hasError = true; } return(_asset_type); }
public ObservableCollection <AssetTypeData> GetAssetTypeFromAsset(AssetData item) { hasError = false; ObservableCollection <AssetTypeData> _result = new ObservableCollection <AssetTypeData>(); try { TraditionAssetEntities db = new TraditionAssetEntities(); var query = db.asset_type.FirstOrDefault(x => x.asset_type_id == item.Asset_type_id); if (query != null) { AssetTypeData pTemp = new AssetTypeData(/*item*/); pTemp.asset_type_id = query.asset_type_id; pTemp.asset_type_name = query.asset_type_name; _result.Add(pTemp); } else { MessageBox.Show("NOT FOUND"); } } catch (Exception ex) { errorMessage = "GetAssetTypeFromAsset() error, " + ex.Message; hasError = true; } return(_result); }
public void AddAssetType(AssetTypeData item) { hasError = false; try { TraditionAssetEntities db = new TraditionAssetEntities(); var data = new asset_type() { asset_type_name = item.asset_type_name, is_active = item.is_active, create_date = DateTime.Now, modified_date = DateTime.Now }; db.asset_type.Add(data); db.SaveChanges(); MessageBox.Show("Insert complete"); } catch (Exception ex) { errorMessage = "Add error, " + ex.Message; hasError = true; } }