private void Find(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))
{
BranchLists = new ObservableCollection <BRANCH>(BranchDao.Instance().getListByName(id));
}
else
{
BranchLists = new ObservableCollection <BRANCH>(BranchDao.Instance().getAll());
}
}
private void OKevent(Window p)
{
EMPLOYEE em = new EMPLOYEE();
em.FIRST_NAME = EmployeeViewObj.first_name;
em.LAST_NAME = EmployeeViewObj.last_name;
em.TITLE = EmployeeViewObj.title;
em.START_DATE = EmployeeViewObj.start_date;
em.END_DATE = EmployeeViewObj.end_date;
em.ASSIGNED_BRANCH_ID = BranchDao.Instance().SelectbyName(EmployeeViewObj.branch).BRANCH_ID;
em.DEPT_ID = DepartmentDao.Instace().SelectbyName(EmployeeViewObj.department).DEPT_ID;
em.SUPERIOR_EMP_ID = null;
if (cv == "insert")
{
EmployeeDao.Instance().Insert(em);
evm.EmployeeViewLists = evm.UpdateListview();
}
else
{
em.EMP_ID = EmployeeViewObj.id;
EmployeeDao.Instance().Update(em);
evm.EmployeeViewLists = evm.UpdateListview();
}
p.Close();
}
public BranchVM()
{
BranchLists = new ObservableCollection <BRANCH>(BranchDao.Instance().getAll());
FindCommand = new RelayCommand <FrameworkElement>((p) => { return(p != null ? true : false); }, (p) => { Find(p); });
EditFormCommand = new RelayCommand <BRANCH>((p) => true, (p) => { ShowEditForm(p); });
DeleteRowCommand = new RelayCommand <BRANCH>((p) => true, (p) => { Remove(p); });
NewFormCommand = new RelayCommand <Window>((p) => true, (p) => { NewEditForm(); });
}
private void NewEditForm()
{
EmployeeEdit pro = new EmployeeEdit();
EmployeeEditVM eevm = new EmployeeEditVM();
eevm.evm = this;
pro.DataContext = eevm;
pro.Show();
pro.txtID.IsReadOnly = true;
pro.txtBranch.ItemsSource = BranchDao.Instance().getAll();
pro.txtDepartment.ItemsSource = DepartmentDao.Instace().getAll();
}
private void OKevent(Window p)
{
ACCOUNT ac = new ACCOUNT();
ACC_TRANSACTION tran = new ACC_TRANSACTION();
ac.AVAIL_BALANCE = AccountViewObj.avail_balance;
ac.CLOSE_DATE = AccountViewObj.close_date;
ac.OPEN_DATE = AccountViewObj.open_date;
ac.PENDING_BALANCE = AccountViewObj.pending_balance;
ac.STATUS = AccountViewObj.status;
ac.PRODUCT_CD = ProductDao.Instance().SelectbyName(AccountViewObj.product).PRODUCT_CD;
ac.LAST_ACTIVITY_DATE = AccountViewObj.last_date;
ac.OPEN_BRANCH_ID = BranchDao.Instance().SelectbyName(AccountViewObj.branch).BRANCH_ID;
ac.OPEN_EMP_ID = FindEm(AccountViewObj.NameEm, listem);
ac.CUST_ID = CustId;
tran.EXECUTION_BRANCH_ID = null;
tran.TELLER_EMP_ID = null;
tran.FUNDS_AVAIL_DATE = Account_tranObj.fund_date;
tran.AMOUNT = Account_tranObj.amount;
tran.TXN_DATE = Account_tranObj.txndate;
tran.TXN_TYPE_CD = Account_tranObj.txntype;
if (cv == "insert")
{
try
{
AccountDao.Instance().Insert(ac, tran);
}
catch
{
throw new Exception();
}
}
else
{
using (SalesEntities3 entity = new SalesEntities3())
{
try
{
ac.ACCOUNT_ID = AccountViewObj.id;
tran.ACCOUNT_ID = AccountViewObj.id;
tran.TXN_ID = Account_tranObj.txnid;
AccountDao.Instance().Update(ac, tran);
}
catch
{
throw new Exception();
}
}
}
p.Close();
vm.AccountViewLists = vm.UpdateListview();
}
private void ShowEditForm(EmployeeView pv)
{
if (pv != null)
{
EmployeeEdit pro = new EmployeeEdit();
EmployeeEditVM eevm = new EmployeeEditVM();
eevm.evm = this;
eevm.EmployeeViewObj = pv;
pro.DataContext = eevm;
pro.Show();
pro.txtID.IsReadOnly = true;
pro.txtBranch.ItemsSource = BranchDao.Instance().getAll();
pro.txtDepartment.ItemsSource = DepartmentDao.Instace().getAll();
}
}
public Account_tran(ACC_TRANSACTION at)
{
if (at != null)
{
this.txnid = at.TXN_ID;
this.amount = at.AMOUNT;
this.fund_date = at.FUNDS_AVAIL_DATE;
this.txndate = at.TXN_DATE;
this.txntype = at.TXN_TYPE_CD;
if (at.EXECUTION_BRANCH_ID != null)
{
this.branch = BranchDao.Instance().SelectbyId(at.EXECUTION_BRANCH_ID).NAME;
}
if (at.TELLER_EMP_ID != null)
{
this.employee = EmployeeDao.Instance().SelectbyId(at.TELLER_EMP_ID).FIRST_NAME;
}
}
}
private void ShowEditForm(AccountView pv)
{
if (pv != null)
{
AccountEdit ac = new AccountEdit();
ac.Show();
AccountEditVM avm = new AccountEditVM();
ac.DataContext = avm;
avm.vm = this;
avm.AccountViewObj = AccountViewObj;
avm.Account_tranObj = Account_tranObj;
avm.CustId = AccountViewObj.customer.CUST_ID;
avm.cv = "update";
ac.ComBranch.ItemsSource = BranchDao.Instance().getAll();
ac.ComProduct.ItemsSource = listpro;
avm.listem = listem;
ac.ComEm.ItemsSource = listem;
}
}
private void NewEditForm()
{
if (AccountViewObj != null)
{
AccountEdit ac = new AccountEdit();
ac.Show();
AccountEditVM avm = new AccountEditVM();
ac.DataContext = avm;
avm.vm = this;
avm.CustId = AccountViewObj.customer.CUST_ID;
avm.AccountViewObj.NameCus = AccountViewObj.NameCus;
avm.cv = "insert";
avm.listem = listem;
ac.ComBranch.ItemsSource = BranchDao.Instance().getAll();
ac.ComProduct.ItemsSource = listpro;
ac.ComEm.ItemsSource = listem;
}
else
{
MessageBox.Show("Chưa có tên khách hàng");
}
}
public AccountView(ACCOUNT a)
{
this.id = a.ACCOUNT_ID;
this.avail_balance = a.AVAIL_BALANCE;
this.close_date = a.CLOSE_DATE;
this.last_date = a.LAST_ACTIVITY_DATE;
this.open_date = a.OPEN_DATE;
this.pending_balance = a.PENDING_BALANCE;
this.status = a.STATUS;
this.branch = BranchDao.Instance().SelectbyId(a.OPEN_BRANCH_ID).NAME;
this.employee = EmployeeDao.Instance().SelectbyId(a.OPEN_EMP_ID);
this.NameEm = employee.FIRST_NAME + " " + employee.LAST_NAME;
this.product = ProductDao.Instance().SelectbyId(a.PRODUCT_CD).NAME;
this.customer = CustomerDao.Instance().SelectbyId(a.CUST_ID);
if (customer.CUST_TYPE_CD == "I")
{
INDIVIDUAL ind = IndividualDao.Instance().SelectbyId(a.CUST_ID);
if (ind == null)
{
this.NameCus = "";
}
else
{
this.NameCus = ind.FIRST_NAME + " " + ind.LAST_NAME;
}
}
else
{
OFFICER off = OfficerDao.Instance().SelectbyCustId(a.CUST_ID);
if (off == null)
{
this.NameCus = "";
}
else
{
this.NameCus = off.FIRST_NAME + " " + off.LAST_NAME;
}
}
}
private void OKevent(Window p)
{
BRANCH bra = new BRANCH();
bra.BRANCH_ID = int.Parse(Branch_id);
bra.CITY = City;
bra.ADDRESS = Address;
bra.STATE = State;
bra.NAME = Name;
bra.ZIP_CODE = Zip_code;
if (cv == "insert")
{
BranchDao.Instance().Insert(bra);
vm.BranchLists = new ObservableCollection <BRANCH>(BranchDao.Instance().getAll());
}
else
{
BranchDao.Instance().Update(bra);
vm.BranchLists = new ObservableCollection <BRANCH>(BranchDao.Instance().getAll());
}
p.Close();
}
private void Remove(BRANCH pt)
{
BranchDao.Instance().Delete(pt.BRANCH_ID);
BranchLists.Remove(pt);
}
