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