public void UpdateAssetHistoryType(AssetHistoryTypeData newitem)
{
hasError = false;
try
{
using (TraditionAssetEntities db = new TraditionAssetEntities())
{
var aht_ = db.asset_history_type.FirstOrDefault(x => x.asset_history_type_id == newitem.Asset_history_type_id);
if (aht_ != null)
{
aht_.type_code = newitem.Type_code;
aht_.type_description = newitem.Type_description;
aht_.is_active = newitem.Is_active;
aht_.modified_date = DateTime.Now;
db.asset_history_type.AddOrUpdate(aht_);
db.SaveChanges();
MessageBox.Show("Update complete");
}
else
{
MessageBox.Show("Can not update");
}
}
}
catch (Exception ex)
{
errorMessage = "Update error, " + ex.Message;
hasError = true;
}
}
public ObservableCollection <AssetHistoryTypeData> GetAssetTypeHistory()
{
hasError = false;
ObservableCollection <AssetHistoryTypeData> _asset_history_type = new ObservableCollection <AssetHistoryTypeData>();
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.asset_history_type.ToList();
foreach (var item in query)
{
AssetHistoryTypeData pTemp = new AssetHistoryTypeData(/*item*/);
pTemp.Asset_history_type_id = item.asset_history_type_id;
pTemp.Type_code = item.type_code;
pTemp.Type_description = item.type_description;
pTemp.Is_active = (bool)item.is_active;
pTemp.Create_date = (DateTime)item.create_date;
pTemp.Modified_date = (DateTime)item.modified_date;
_asset_history_type.Add(pTemp);
}
}
catch (Exception ex)
{
errorMessage = "GetAsset() error, " + ex.Message;
hasError = true;
}
return(_asset_history_type);
}
public ObservableCollection <AssetHistoryTypeData> GetAssetHistoryTypeNameFromAssetHistoryType(AssetHistoryData item)
{
hasError = false;
ObservableCollection <AssetHistoryTypeData> _result = new ObservableCollection <AssetHistoryTypeData>();
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.asset_history_type.FirstOrDefault(x => x.asset_history_type_id == item.Asset_history_type);
if (query != null)
{
AssetHistoryTypeData pTemp = new AssetHistoryTypeData(/*item*/);
pTemp.Type_code = query.type_code;
_result.Add(pTemp);
}
else
{
MessageBox.Show("NOT FOUND");
}
}
catch (Exception ex)
{
errorMessage = "GetAssetHistoryTypeNameFromAssetHistoryType() error, " + ex.Message;
hasError = true;
}
return(_result);
}
public void AddAssetHistoryType(AssetHistoryTypeData item)
{
hasError = false;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var data = new asset_history_type()
{
type_code = item.Type_code,
type_description = item.Type_description,
is_active = item.Is_active,
create_date = DateTime.Now,
modified_date = DateTime.Now
};
db.asset_history_type.Add(data);
db.SaveChanges();
MessageBox.Show("Insert complete");
}
catch (Exception ex)
{
errorMessage = "Add error, " + ex.Message;
hasError = true;
}
}
