public AddToPassBook()
{
InitializeComponent();
//cbbTerm.IsReadOnly = true;
//cbbPayInterest.IsReadOnly = true;
//cbbDue.IsReadOnly = true;
using (var db = new MoneyLoverDB())
{
cbPassbookId.ItemsSource = db.PassBooks.ToList();
cbPassbookId.DisplayMemberPath = "PassBookID";
cbPassbookId.SelectedValuePath = "PassBookID";
}
//cbbTerm.ItemsSource = term;
//cbbTerm.SelectedValuePath = "Keys";
//cbbTerm.DisplayMemberPath = "Value";
//cbbPayInterest.ItemsSource = payInterest;
//cbbPayInterest.SelectedValuePath = "Keys";
//cbbPayInterest.DisplayMemberPath = "Value";
//cbbDue.ItemsSource = due;
//cbbDue.SelectedValuePath = "Keys";
//cbbDue.DisplayMemberPath = "Value";
}
private void btnSettlement_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Bạn muốn tất toán sổ tiết kiệm này?", "Thông báo", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
using (var db = new MoneyLoverDB())
{
//var ct = db.PassBooks.SingleOrDefault(t => t.PassBookID.ToString() == cbPassbookId.SelectedValue.ToString());
//ct.Settlement = true;
//db.SaveChanges();
var ct = db.PassBooks.SingleOrDefault(t => t.PassBookID.ToString() == cbPassbookId.SelectedValue.ToString());
var userId = ct.UserID;
Models.User user = db.Users.SingleOrDefault(t => t.UserID.ToString() == ct.UserID.ToString());
if (userId == user.UserID)
{
ct.Settlement = true;
}
user.Wallet += ConvertStringToDouble(txtTotal.Text);
user.SavingsWallet -= ct.Deposit;
db.SaveChanges();
}
MessageBox.Show("Tất toán thành công", "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
int TermKey = Convert.ToInt32(((KeyValuePair <int, string>)cbbTerm.SelectedItem).Key);
int payInterestKey = Convert.ToInt32(((KeyValuePair <int, string>)cbbPayInterest.SelectedItem).Key);
int dueKey = Convert.ToInt32(((KeyValuePair <int, string>)cbbDue.SelectedItem).Key);
try
{
using (var db = new MoneyLoverDB())
{
var savingPb = db.PassBooks.SingleOrDefault(t => t.PassBookID.ToString() == cbPassbookId.SelectedValue.ToString());
savingPb.InterestRates = double.Parse(txtInterestRates.Text);
savingPb.IndefiniteTerm = double.Parse(txtIndefiniteTerm.Text);
savingPb.Due = dueKey;
savingPb.PayInterest = payInterestKey;
savingPb.Term = TermKey;
db.SaveChanges();
//dataHD.ItemsSource = db.HopDongs.ToList();
//dataHD.Items.Refresh();
}
MessageBox.Show("Cập nhật thành công", "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void btnRefresh_Click(object sender, RoutedEventArgs e)
{
using (var db = new MoneyLoverDB())
{
AllPassbook.Items.Refresh();
AllPassbook.ItemsSource = db.PassBooks.ToList().Where(x => x.Settlement == false).ToList();
dtgridWithdrawal.ItemsSource = db.PassBooks.Where(x => x.Settlement == true).ToList();
}
}
public PassbookList()
{
InitializeComponent();
using (var db = new MoneyLoverDB())
{
AllPassbook.Items.Refresh();
AllPassbook.ItemsSource = db.PassBooks.ToList().Where(x => x.Settlement == false).ToList();
dtgridWithdrawal.ItemsSource = db.PassBooks.Where(x => x.Settlement == true).ToList();
//Combobox User
}
LoadTotalMoneyPassBook();
}
private void LoadTotal()
{
using (var db = new MoneyLoverDB())
{
var ct = db.PassBooks.SingleOrDefault(t => t.PassBookID.ToString() == cbPassbookId.SelectedValue.ToString());
if (ct.EndDate <= DateTime.Now)
{
txtTotal.Text = (ct.Deposit + (ct.Deposit * (ct.InterestRates / 100) * ct.Term) / 12).ToString();
}
else
{
txtTotal.Text = (ct.Deposit + (ct.Deposit * (ct.IndefiniteTerm / 100) * ct.Term) / 12).ToString();
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new MoneyLoverDB())
{
double moneyAdd = Convert.ToDouble(txtAddMoney.Text);
var ct = db.PassBooks.SingleOrDefault(t => t.PassBookID.ToString() == cbPassbookId.SelectedValue.ToString());
ct.Deposit += moneyAdd;
db.SaveChanges();
}
MessageBox.Show("Gửi thêm thành công", "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void btnSettlement_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Bạn muốn tất toán sổ tiết kiệm này?", "Thông báo", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
using (var db = new MoneyLoverDB())
{
var ct = db.PassBooks.SingleOrDefault(t => t.PassBookID.ToString() == cbPassbookId.SelectedValue.ToString());
ct.Settlement = true;
db.SaveChanges();
}
MessageBox.Show("Tất toán thành công", "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
public Withdrawal()
{
InitializeComponent();
using (var db = new MoneyLoverDB())
{
cbPassbookId.ItemsSource = db.PassBooks.Where(x => x.Settlement == false).ToList();
cbPassbookId.DisplayMemberPath = "PassBookID";
cbPassbookId.SelectedValuePath = "PassBookID";
}
cbbTerm.ItemsSource = term;
cbbTerm.SelectedValuePath = "Keys";
cbbTerm.DisplayMemberPath = "Value";
cbbPayInterest.ItemsSource = payInterest;
cbbPayInterest.SelectedValuePath = "Keys";
cbbPayInterest.DisplayMemberPath = "Value";
cbbDue.ItemsSource = due;
cbbDue.SelectedValuePath = "Keys";
cbbDue.DisplayMemberPath = "Value";
}
