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