public ObservableCollection <ReportData> GetAssetHistory()
{
hasError = false;
ObservableCollection <ReportData> _history = new ObservableCollection <ReportData>();
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.asset_history.ToList();
foreach (var item in query)
{
ReportData pTemp = new ReportData(/*item*/);
pTemp.asset_history_id = item.asset_history_id;
pTemp.user_id = (int)item.user_id;
pTemp.asset_id = (int)item.asset_id;
pTemp.asset_history_type = (int)item.asset_history_type;
pTemp.remark = item.remark;
pTemp.history_timestamp = (DateTime)item.history_timestamp;
_history.Add(pTemp);
}
}
catch (Exception ex)
{
errorMessage = "Gethistory() error, " + ex.Message;
hasError = true;
}
return(_history);
}
public void UpdateStaff(StaffData newitem)
{
hasError = false;
try
{
using (TraditionAssetEntities db = new TraditionAssetEntities())
{
var staff_ = db.staff.FirstOrDefault(x => x.staff_id == newitem.staff_id);
if (staff_ != null)
{
staff_.firstname = newitem.firstname;
staff_.lastname = newitem.lastname;
staff_.aka = newitem.aka;
staff_.start_date = newitem.start_date;
staff_.end_date = newitem.end_date;
staff_.is_active = newitem.is_active;
staff_.modified_date = DateTime.Now;
db.staff.AddOrUpdate(staff_);
db.SaveChanges();
MessageBox.Show("Update complete");
}
else
{
MessageBox.Show("Can not update");
}
}
}
catch (Exception ex)
{
errorMessage = "Update error, " + ex.Message;
hasError = true;
}
}
public string GetOsName(int Oid)
{
hasError = false;
string _result = null;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.os.FirstOrDefault(x => x.os_id == Oid);
if (query != null)
{
_result = query.os_name;
}
else
{
MessageBox.Show("NOT FOUND");
}
}
catch (Exception ex)
{
errorMessage = "GetOsName() error, " + ex.Message;
hasError = true;
}
return(_result);
}
public void AddSupplier(SupplierData item)
{
hasError = false;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var data = new supplier()
{
supplier_id = item.supplier_id,
company_name = item.company_name,
contact_person = item.contact_person,
address = item.address,
email = item.email,
phone = item.phone,
is_active = item.is_active,
create_date = DateTime.Now,
modified_date = DateTime.Now
};
db.supplier.Add(data);
db.SaveChanges();
MessageBox.Show("Insert complete");
}
catch (Exception ex)
{
errorMessage = "Add error, " + ex.Message;
hasError = true;
}
}
public void AddAssetHistory(AssetHistoryData item)
{
hasError = false;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var data = new asset_history()
{
asset_history_id = item.Asset_history_id,
user_id = item.User_id,
asset_id = item.Asset_id,
asset_history_type = item.Asset_history_type,
remark = item.Remark,
history_timestamp = item.History_timestamp
};
db.asset_history.Add(data);
db.SaveChanges();
MessageBox.Show("Insert complete");
}
catch (Exception ex)
{
errorMessage = "Add error, " + ex.Message;
hasError = true;
}
}
public void UpdateOs(OsData newitem)
{
hasError = false;
try
{
using (TraditionAssetEntities db = new TraditionAssetEntities())
{
var os_ = db.os.FirstOrDefault(x => x.os_id == newitem.os_id);
if (os_ != null)
{
os_.os_name = newitem.os_name;
os_.is_active = newitem.is_active;
os_.modified_date = DateTime.Now;
db.os.AddOrUpdate(os_);
db.SaveChanges();
MessageBox.Show("Update complete");
}
else
{
MessageBox.Show("Can not update");
}
}
}
catch (Exception ex)
{
errorMessage = "Update error, " + ex.Message;
hasError = true;
}
}
public void UpdateSupplier(SupplierData newitem)
{
hasError = false;
try
{
using (TraditionAssetEntities db = new TraditionAssetEntities())
{
var supplier_ = db.supplier.FirstOrDefault(x => x.supplier_id == newitem.supplier_id);
if (supplier_ != null)
{
supplier_.company_name = newitem.company_name;
supplier_.contact_person = newitem.contact_person;
supplier_.address = newitem.address;
supplier_.email = newitem.email;
supplier_.phone = newitem.phone;
supplier_.is_active = newitem.is_active;
//supplier_.create_date = DateTime.Now;
supplier_.modified_date = DateTime.Now;
db.supplier.AddOrUpdate(supplier_);
db.SaveChanges();
MessageBox.Show("Update complete");
}
else
{
MessageBox.Show("Can not update");
}
}
}
catch (Exception ex)
{
errorMessage = "Update error, " + ex.Message;
hasError = true;
}
}
public ObservableCollection <SupplierData> GetSupplierFromAsset(AssetData item)
{
hasError = false;
ObservableCollection <SupplierData> _result = new ObservableCollection <SupplierData>();
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.supplier.FirstOrDefault(x => x.supplier_id == item.Supplier_id);
if (query != null)
{
SupplierData pTemp = new SupplierData(/*item*/);
pTemp.company_name = query.company_name;
pTemp.email = query.email;
pTemp.contact_person = query.contact_person;
pTemp.phone = query.phone;
pTemp.address = query.address;
_result.Add(pTemp);
}
else
{
MessageBox.Show("NOT FOUND");
}
}
catch (Exception ex)
{
errorMessage = "GetAssetTypeFromAsset() error, " + ex.Message;
hasError = true;
}
return(_result);
}
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 int UserLogin(UserData item)
{
hasError = false;
TraditionAssetEntities db = new TraditionAssetEntities();
int result = 0;
try
{
var query = db.user_login.FirstOrDefault(x => x.username == item.username);
if (query.username == item.username && query.password == item.password)
{
result = query.user_id;
}
else
{
result = 0;
}
}
catch (Exception ex)
{
errorMessage = "Login error, " + ex.Message;
hasError = true;
}
return(result);
}
public ObservableCollection <OsData> GetOsFromAsset(AssetData item)
{
hasError = false;
ObservableCollection <OsData> _result = new ObservableCollection <OsData>();
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.os.FirstOrDefault(x => x.os_id == item.Os_id);
if (query != null)
{
OsData pTemp = new OsData(/*item*/);
pTemp.os_id = query.os_id;
pTemp.os_name = query.os_name;
_result.Add(pTemp);
}
else
{
MessageBox.Show("NOT FOUND");
}
}
catch (Exception ex)
{
errorMessage = "GetAssetTypeFromAsset() error, " + ex.Message;
hasError = true;
}
return(_result);
}
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 ObservableCollection <StaffData> GetStaff()
{
hasError = false;
ObservableCollection <StaffData> _staff = new ObservableCollection <StaffData>();
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.staff.ToList();
foreach (var item in query)
{
StaffData pTemp = new StaffData(/*item*/);
pTemp.staff_id = item.staff_id;
pTemp.aka = item.aka;
pTemp.firstname = item.firstname;
pTemp.lastname = item.lastname;
pTemp.start_date = (DateTime)item.start_date;
pTemp.end_date = (DateTime)item.end_date;
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)
//{
_staff.Add(pTemp);
//}
}
}
catch (Exception ex)
{
errorMessage = "GetStaff() error, " + ex.Message;
hasError = true;
}
return(_staff);
}
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 <OsData> GetOs()
{
hasError = false;
ObservableCollection <OsData> _os = new ObservableCollection <OsData>();
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.os.ToList();
foreach (var item in query)
{
OsData pTemp = new OsData(/*item*/);
pTemp.os_id = item.os_id;
pTemp.os_name = item.os_name;
pTemp.is_active = (bool)item.is_active;
pTemp.create_date = (DateTime)item.create_date;
pTemp.modified_date = (DateTime)item.modified_date;
_os.Add(pTemp);
}
}
catch (Exception ex)
{
errorMessage = "GetAsset() error, " + ex.Message;
hasError = true;
}
return(_os);
}
public ObservableCollection <SupplierData> GetSupplier()
{
hasError = false;
ObservableCollection <SupplierData> _supplier = new ObservableCollection <SupplierData>();
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var query = db.supplier.ToList();
foreach (var item in query)
{
SupplierData pTemp = new SupplierData(/*item*/);
pTemp.supplier_id = item.supplier_id;
pTemp.company_name = item.company_name;
pTemp.contact_person = item.contact_person;
pTemp.address = item.address;
pTemp.email = item.email;
pTemp.phone = item.phone;
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)
//{
_supplier.Add(pTemp);
//}
}
}
catch (Exception ex)
{
errorMessage = "GetStaff() error, " + ex.Message;
hasError = true;
}
return(_supplier);
}
public void AddStaff(StaffData item)
{
hasError = false;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var data = new staff()
{
//staff_id = item.staff_id,
firstname = item.firstname,
lastname = item.lastname,
aka = item.aka,
start_date = item.start_date,
end_date = item.end_date,
is_active = item.is_active,
create_date = DateTime.Now,
modified_date = DateTime.Now
};
db.staff.Add(data);
db.SaveChanges();
MessageBox.Show("Insert complete");
}
catch (Exception ex)
{
errorMessage = "Add error, " + ex.Message;
hasError = true;
}
}
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 AddOs(OsData item)
{
hasError = false;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var data = new os()
{
os_name = item.os_name,
is_active = item.is_active,
create_date = DateTime.Now,
modified_date = DateTime.Now
};
db.os.Add(data);
db.SaveChanges();
MessageBox.Show("Insert complete");
}
catch (Exception ex)
{
errorMessage = "Add 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 void LogHistory(HistoryData item)
{
hasError = false;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var data = new history()
{
//history_id = item.History_id,
user_id = item.User_id,
detail = item.Detail,
history_timestamp = DateTime.Now,
history_type = item.History_id
};
db.history.Add(data);
db.SaveChanges();
//MessageBox.Show("Insert complete");
}
catch (Exception ex)
{
errorMessage = "Add error, " + ex.Message;
hasError = true;
}
}
public void AddUser(UserData item)
{
hasError = false;
try
{
TraditionAssetEntities db = new TraditionAssetEntities();
var data = new user_login()
{
username = item.username,
password = item.password,
is_active = item.is_active,
create_date = DateTime.Now,
modified_date = DateTime.Now
};
db.user_login.Add(data);
db.SaveChanges();
MessageBox.Show("Insert complete");
}
catch (Exception ex)
{
errorMessage = "Add error, " + ex.Message;
hasError = true;
}
}
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;
}
}
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);
}
