private void Cb_TypePassbook_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (this.Cb_TypePassbook.ItemsSource != null)
{
ComboBox cb = sender as ComboBox;
if (cb.SelectedItem != null)
{
TypePassbook type = cb.SelectedItem as TypePassbook;
int idcustomer = int.Parse(this.Txt_CustomerID.Text);
string name = type.Typename;
this.Txt_PassbookID.Text = PassbookDAO.Instance.GetPassbookIDbyCusIDandidType(idcustomer, name).ToString();
int id = int.Parse(this.Txt_PassbookID.Text);
this.Balance.Text = "Số dư:" + PassbookDAO.Instance.GetBalancebyIDPassbook(id).ToString();
if (type.Kind != "Không kì hạn")
{
this.Money.Text = PassbookDAO.Instance.GetBalancebyIDPassbook(id).ToString();
this.Money.IsEnabled = false;
}
else
{
this.Money.IsEnabled = true;
}
}
}
}
private void Add_Type(object sender, RoutedEventArgs e)
{
TypePassbook type = new TypePassbook
{
Min_passbookblance = int.Parse(this.TextBox_MinBalanceMoney.Text),
Interest_rate = float.Parse(this.TextBox_InterestRate.Text) / 100
};
if (this.RadioButton_Noterm.IsChecked == true)
{
type.Term = 0;
type.Withdrawterm = int.Parse(this.TextBox_MinWithdrawDay.Text.ToString());
}
else
{
type.Term = int.Parse(this.TextBox_Term.Text);
}
type.Min_collectmoney = int.Parse(this.TextBox_MinCollectMoney.Text);
try { TypePassbookDAO.Instance.InsertType(type); }
catch { MessageBoxCustom.setContent("Trùng loại tiết kiệm").ShowDialog(); }
SetReadOnly(true);
enableRadioButton(false);
this.TextBox_Term.IsReadOnly = true;
ShowTreeItem();
}
private void Listview_SelectionChange(object sender, SelectionChangedEventArgs e)
{
if (this.ListView_TransactionType.Items.Count > 0)
{
TypePassbook typepassbook = (TypePassbook)(this.ListView_TransactionType.SelectedItem as ListViewItem).Tag;
this.TextBox_MinBalanceMoney.Text = typepassbook.Min_passbookblance.ToString();
this.TextBox_MinWithdrawDay.Text = typepassbook.Withdrawterm.ToString();
this.TextBox_MinCollectMoney.Text = typepassbook.Min_collectmoney.ToString();
this.TextBox_InterestRate.Text = (typepassbook.Interest_rate * 100).ToString();
this.TextBox_Term.Text = typepassbook.Term.ToString();
this.Button_Add.Visibility = Visibility.Collapsed;
this.Button_Save.Visibility = Visibility.Collapsed;
this.Button_Fix.Visibility = Visibility.Visible;
if (typepassbook.Term > 0)
{
this.RadioButton_Yesterm.IsChecked = true;
SetTermTypeMode(true);
}
else
{
this.RadioButton_Noterm.IsChecked = true;
SetTermTypeMode(false);
}
this.Texblock_title.Text = "Thông tin";
SetReadOnly(true);
enableRadioButton(false);
}
}
public List <TypePassbook> GetListType()
{
List <TypePassbook> list = new List <TypePassbook>();
string query = "select * from dbo.typepassbook";
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
TypePassbook type = new TypePassbook(item);
list.Add(type);
}
return(list);
}
public List <TypePassbook> GetListTypeByCusID(int CusID)
{
List <TypePassbook> list = new List <TypePassbook>();
string query = "select * from dbo.typepassbook where id in( select passbook_type from passbook, customer where passbook_customer=" + CusID + ")";
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
TypePassbook type = new TypePassbook(item);
list.Add(type);
}
return(list);
}
public void InsertType(TypePassbook type)
{
float Interset_rate = type.Interest_rate;
int term = type.Term;
long min_passbookblance = type.Min_passbookblance;
long min_collectmoney = type.Min_collectmoney;
string query1 = string.Format("usp_InsertTypePassbook {0}, {1}, {2}, {3} ", Interset_rate, term, min_passbookblance, min_collectmoney);
DataProvider.Instance.ExcuteNonQuery(query1);
string query = string.Format("update dbo.typepassbook set withdrawterm = {0} where interest_rate = {1} and term = {2} and min_balance = {3} and min_collectmoney = {4} ", type.Withdrawterm, Interset_rate, term, min_passbookblance, min_collectmoney);
if (type.Term == 0)
{
DataProvider.Instance.ExcuteNonQuery(query);
}
}
private void Delete_type(object sender, RoutedEventArgs e)
{
if (MessageBoxCustom.setContent("Bạn thực sự muốn xóa loại tiết kiệm này?").ShowDialog() == true)
{
if (this.ListView_TransactionType.Items.Count > 0)
{
TypePassbook typepassbook = (TypePassbook)(this.ListView_TransactionType.SelectedItem as ListViewItem).Tag;
if (!TypePassbookDAO.Instance.CheckIfExistActivePassbookInType(typepassbook.Id))
{
TypePassbookDAO.Instance.DeleteType(typepassbook.Id);
ShowTreeItem();
}
else
{
MessageBoxCustom.setContent("Loại tiết kiệm này vẫn còn sổ mở").ShowDialog();
}
}
}
}
private void Cb_TypePassbook_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int customerID;
if (int.TryParse(this.Txt_CustomerID.Text, out customerID) == true)
{
if (this.Cb_TypePassbook.ItemsSource == null)
{
return;
}
else
{
ComboBox cb = sender as ComboBox;
if (cb.SelectedItem != null)
{
customerID = int.Parse(this.Txt_CustomerID.Text);
TypePassbook type = cb.SelectedItem as TypePassbook;
string name = type.Typename;
this.Txt_PassbookID.Text = PassbookDAO.Instance.GetPassbookIDbyCusIDandidType(customerID, name).ToString();
}
}
}
}
private void Save_Type(object sender, RoutedEventArgs e)
{
this.Button_Save.Visibility = Visibility.Collapsed;
this.Button_Fix.Visibility = Visibility.Visible;
SetReadOnly(true);
TypePassbook type;
try { type = (this.ListView_TransactionType.SelectedItem as ListViewItem).Tag as TypePassbook; } catch { type = new TypePassbook(); }
if (type != null)
{
long minBalanceMoney = long.Parse(this.TextBox_MinBalanceMoney.Text);
long minCollectMoney = long.Parse(this.TextBox_MinCollectMoney.Text);
float interestRate = float.Parse(this.TextBox_InterestRate.Text) / 100;
int minWithDrawDay = int.Parse(this.TextBox_MinWithdrawDay.Text);
TypePassbookDAO.Instance.UpdateType(type.Id, minCollectMoney, minBalanceMoney, interestRate, minWithDrawDay);
}
LoadListTreeItem();
}
