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