private void FindProduct_type(FrameworkElement p)
{
string id = "";
if (p != null)
{
var fe = p as Grid;
if (fe != null)
{
foreach (var item in fe.Children)
{
var tx = item as TextBox;
if (tx != null)
{
if (tx.Name.Equals("txtSearch"))
{
id = tx.Text;
}
}
}
}
}
if (!string.IsNullOrEmpty(id))
{
Product_typeLists = new ObservableCollection <PRODUCT_TYPE>(Product_TypeDao.Instance().getListByName(id));
}
else
{
Product_typeLists = new ObservableCollection <PRODUCT_TYPE>(Product_TypeDao.Instance().getAll());
}
}
private void OKevent(Window p)
{
PRODUCT pro = new PRODUCT();
pro.PRODUCT_CD = Product_cd;
pro.PRODUCT_TYPE_CD = Product_TypeDao.Instance().SelectbyName(Type).PRODUCT_TYPE_CD;
pro.NAME = Name;
pro.DATE_OFFERED = Convert.ToDateTime(Date_offer);
if (Date_retire == null || Date_retire == "")
{
pro.DATE_RETIRED = null;
}
else
{
pro.DATE_RETIRED = Convert.ToDateTime(Date_retire);
}
if (cv == "insert")
{
ProductDao.Instance().Insert(pro);
vm.ProductViewLists = vm.UpdateListview();
}
else
{
ProductDao.Instance().Update(pro);
vm.ProductViewLists = vm.UpdateListview();
}
p.Close();
}
/// <summary>
/// Constructor
/// </summary>
public Product_typeVM()
{
Product_typeLists = new ObservableCollection <PRODUCT_TYPE>(Product_TypeDao.Instance().getAll());
FindCommand = new RelayCommand <FrameworkElement>((p) => { return(p != null ? true : false); }, (p) => { FindProduct_type(p); });
EditFormCommand = new RelayCommand <PRODUCT_TYPE>((p) => true, (p) => { ShowEditForm(p); });
DeleteRowCommand = new RelayCommand <PRODUCT_TYPE>((p) => true, (p) => { RemoveProduct_type(p); });
NewFormCommand = new RelayCommand <Window>((p) => true, (p) => { NewEditForm(); });
}
private void button1_Click(object sender, EventArgs e)
{
Product_TypeDao ptd = new Product_TypeDao();
PRODUCT_TYPE pt = new PRODUCT_TYPE();
pt.NAME = txt.Text;
ptd.Insert(pt);
}
public ProductListVM()
{
listpt = Product_TypeDao.Instance().getAll();
ProductViewLists = UpdateListview();
FindCommand = new RelayCommand <FrameworkElement>((p) => { return(p != null ? true : false); }, (p) => { FindProduct(p); });
EditFormCommand = new RelayCommand <ProductView>((p) => true, (p) => { ShowEditForm(p); });
DeleteRowCommand = new RelayCommand <ProductView>((p) => true, (p) => { RemoveDepartment(p); });
NewFormCommand = new RelayCommand <Window>((p) => true, (p) => { NewEditForm(); });
}
public ProductView(PRODUCT p)
{
Product_TypeDao ptd = new Product_TypeDao();
this.type = ptd.SelectbyId(p.PRODUCT_TYPE_CD).NAME;
this.product_cd = p.PRODUCT_CD;
this.name = p.NAME;
this.date_retire = p.DATE_RETIRED;
this.date_offer = p.DATE_OFFERED;
}
private void OKevent(Window p)
{
PRODUCT_TYPE pt = new PRODUCT_TYPE();
pt.PRODUCT_TYPE_CD = Product_type_cd;
pt.NAME = Name;
if (cv == "insert")
{
Product_TypeDao.Instance().Insert(pt);
}
else
{
Product_TypeDao.Instance().Update(pt);
}
vm.Product_typeLists = null;
vm.Product_typeLists = new System.Collections.ObjectModel.ObservableCollection <PRODUCT_TYPE>(Product_TypeDao.Instance().getAll());
p.Close();
}
private void RemoveProduct_type(PRODUCT_TYPE pt)
{
Product_TypeDao.Instance().Delete(pt.PRODUCT_TYPE_CD);
Product_typeLists = null;
Product_typeLists = new ObservableCollection <PRODUCT_TYPE>(Product_TypeDao.Instance().getAll());
}
