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