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