public static User GetUser(int UserID)
{
using (var db = new DB.MoneyLoverDB())
{
return(db.Users.Find(UserID));
}
}
public PassBook()
{
InitializeComponent();
using (var db = new DB.MoneyLoverDB())
{
passBookService = new PassBookService();
current_user = db.Users.Find(System.Windows.Application.Current.Resources["current_user_id"]);
cbbBank.ItemsSource = db.Banks.ToList();
cbbBank.SelectedValuePath = "BankID";
cbbBank.DisplayMemberPath = "BankName";
cbbBank.SelectedIndex = 0;
cbbTerm.ItemsSource = term;
cbbTerm.SelectedValuePath = "Keys";
cbbTerm.DisplayMemberPath = "Value";
cbbTerm.SelectedIndex = 1;
cbbPayInterest.ItemsSource = payInterest;
cbbPayInterest.SelectedValuePath = "Keys";
cbbPayInterest.DisplayMemberPath = "Value";
cbbPayInterest.SelectedIndex = 0;
cbbDue.ItemsSource = due;
cbbDue.SelectedValuePath = "Keys";
cbbDue.DisplayMemberPath = "Value";
cbbDue.SelectedIndex = 0;
}
}
public static Bank GetBank(int id)
{
using (var db = new DB.MoneyLoverDB())
{
return(db.Banks.Find(id));
}
}
public bool ValidateAddDeposit(int UserID, double deposit, Models.PassBook passBook)
{
using (var db = new DB.MoneyLoverDB())
{
if (passBook.Due != 3)
{
Models.User user = db.Users.Find(UserID);
if (deposit < 100000)
{
MessageBox.Show("Số tiền gửi thêm tối thiểu là 100.000đ", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
else if (deposit > user.Wallet)
{
MessageBox.Show("Số tiền gửi phải bé hơn tiền mặt hiện có", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
else if ((DateTime.Now - passBook.EndDate).Days != 0)
{
MessageBox.Show("Chỉ được gửi thêm tiền khi đến kỳ hạn tính lãi suất", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
else
{
return(true);
}
}
else
{
MessageBox.Show("Gửi thêm tiền không áp dụng cho tất toán sổ khi đến hạn", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
}
}
public static void DueChoice3(Models.PassBook pb, Models.User user)
{
using (var db = new DB.MoneyLoverDB())
{
if (pb.PayInterest != 1)
{
if (DateTime.Now >= pb.EndDate)
{
Models.User User = db.Users.Find(user.UserID);
Models.PassBook passBook = db.PassBooks.Find(pb.PassBookID);
if (pb.Term != 99)
{
User.Wallet += (pb.Deposit + ((pb.Deposit * (pb.InterestRates / 100) * pb.Term) / 12));
User.SavingsWallet -= pb.Deposit;
passBook.Settlement = true;
}
}
}
else
{
if ((DateTime.Now - pb.EndDate).Days == 1 || (DateTime.Now >= pb.EndDate))
{
Models.User User = db.Users.Find(user.UserID);
Models.PassBook passBook = db.PassBooks.Find(pb.PassBookID);
if (pb.Term != 99)
{
User.Wallet += (pb.Deposit + ((pb.Deposit * (pb.InterestRates / 100) * pb.Term) / 12));
User.SavingsWallet -= pb.Deposit;
passBook.Settlement = true;
}
}
}
db.SaveChanges();
}
}
public List <int> GetListBankOfUser()
{
using (var db = new DB.MoneyLoverDB())
{
var result = db.PassBooks.Where(m => m.UserID == UserID).Select(m => m.BankID).Distinct().ToList();
return(result);
}
}
public void ShowDataGrid()
{
using (var db = new DB.MoneyLoverDB())
{
foreach (int BankID in GetListBankOfUser())
{
var ListPassBookOfBank = db.PassBooks.Where(m => m.Settlement == false && m.UserID == UserID && m.BankID == BankID).ToList();
ShowPassBookList(Models.Bank.GetBank(BankID), ListPassBookOfBank);
}
LoadWallet();
LoadTextBlockPassBook();
}
}
public UserInformation()
{
userInformation = new Views.UserInformation();
LoadWallet();
DisableInformation();
userInformation.btnEdit.Click += (sender, e) =>
{
userInformation.txtWallet.IsEnabled = userInformation.txtWallet.IsEnabled = true;
};
userInformation.btnSave.Click += (sender, e) =>
{
try
{
double wallet = getNumber(userInformation.txtWallet.Text);
if (IsValidWallet(wallet))
{
using (var db = new DB.MoneyLoverDB())
{
Models.User user = db.Users.Find(UserID);
user.Wallet = wallet;
db.SaveChanges();
}
Close();
}
}
catch
{
MessageBox.Show("Đã có lỗi xảy ra, vui lòng kiểm tra lại", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
};
userInformation.btnClose.Click += (sender, e) =>
{
Close();
};
userInformation.btnCancel.Click += (sender, e) =>
{
Close();
};
}
public bool ValidateEditDeposit(int UserID, double olddeposit, double deposit)
{
using (var db = new DB.MoneyLoverDB())
{
Models.User user = db.Users.Find(UserID);
if (deposit < 1000000)
{
MessageBox.Show("Số tiền không được bé hơn 1.000.000đ", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
else if (deposit > (user.Wallet + olddeposit))
{
MessageBox.Show("Số tiền gửi phải bé hơn tiền mặt hiện có", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
else
{
return(true);
}
}
}
public bool ValidateDeposit(int UserID, double deposit)
{
using (var db = new DB.MoneyLoverDB())
{
Models.User user = db.Users.Find(UserID);
if (deposit < 1000000)
{
MessageBox.Show("Số tiền gửi tối thiểu là 1.000.000đ", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
else if (deposit > user.Wallet)
{
MessageBox.Show("Số tiền gửi phải nhỏ hơn hoặc bằng số tiền mặt hiện có", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
else
{
return(true);
}
}
}
public static void DueChoice1(Models.PassBook pb, Models.User user)
{
using (var db = new DB.MoneyLoverDB())
{
if (pb.PayInterest != 1)
{
if (DateTime.Now >= pb.EndDate)
{
Models.User User = db.Users.Find(user.UserID);
Models.PassBook passBook = db.PassBooks.Find(pb.PassBookID);
if (pb.Term != 99)
{
passBook.Deposit += ((pb.Deposit * (pb.InterestRates / 100) * pb.Term) / 12);
User.SavingsWallet += ((pb.Deposit * (pb.InterestRates / 100) * pb.Term) / 12);
DateTime tmp = passBook.EndDate;
passBook.SentDate = tmp;
passBook.EndDate = tmp.AddMonths(passBook.Term);
}
}
}
else
{
if ((DateTime.Now - pb.EndDate).Days == 1 || (DateTime.Now >= pb.EndDate))
{
Models.User User = db.Users.Find(user.UserID);
Models.PassBook passBook = db.PassBooks.Find(pb.PassBookID);
if (pb.Term != 99)
{
passBook.Deposit += ((pb.Deposit * (pb.InterestRates / 100) * pb.Term) / 12);
User.SavingsWallet += ((pb.Deposit * (pb.InterestRates / 100) * pb.Term) / 12);
DateTime tmp = passBook.EndDate;
passBook.SentDate = tmp;
passBook.EndDate = tmp.AddMonths(passBook.Term);
}
}
}
db.SaveChanges();
}
}
public PassBook(PassbookList pbList)
{
using (var db = new DB.MoneyLoverDB())
{
passBook = new Views.PassBook();
pbService = new Services.PassBookService();
current_user = db.Users.Find(Application.Current.Resources["current_user_id"]);
passBook.cbbBank.ItemsSource = db.Banks.ToList();
passBook.cbbBank.SelectedValuePath = "BankID";
passBook.cbbBank.DisplayMemberPath = "BankName";
passBook.cbbBank.SelectedIndex = 0;
passBook.cbbTerm.ItemsSource = term;
passBook.cbbTerm.SelectedValuePath = "Keys";
passBook.cbbTerm.DisplayMemberPath = "Value";
passBook.cbbTerm.SelectedIndex = 1;
passBook.cbbPayInterest.ItemsSource = payInterest;
passBook.cbbPayInterest.SelectedValuePath = "Keys";
passBook.cbbPayInterest.DisplayMemberPath = "Value";
passBook.cbbPayInterest.SelectedIndex = 0;
passBook.cbbDue.ItemsSource = due;
passBook.cbbDue.SelectedValuePath = "Keys";
passBook.cbbDue.DisplayMemberPath = "Value";
passBook.cbbDue.SelectedIndex = 0;
}
passBook.btnSave.Click += (sender, e) =>
{
try
{
int BankID = Convert.ToInt32(passBook.cbbBank.SelectedValue);
int TermKey = Convert.ToInt32(((KeyValuePair <int, string>)passBook.cbbTerm.SelectedItem).Key);
int payInterestKey = Convert.ToInt32(((KeyValuePair <int, string>)passBook.cbbPayInterest.SelectedItem).Key);
int dueKey = Convert.ToInt32(((KeyValuePair <int, string>)passBook.cbbDue.SelectedItem).Key);
Models.Bank Bank = Models.Bank.GetBank(BankID);
if (IsDateBeforeOrToday(passBook.dpDate.Text) && ValidateDeposit(current_user.UserID, Convert.ToDouble(passBook.txtDeposit.Text)))
{
Models.PassBook pb = pbService.Create(BankID,
Convert.ToDouble(passBook.txtDeposit.Text),
dueKey,
GetIndefiniteTerm(passBook.txtIndefiniteTerm.Text),
TermKey,
payInterestKey,
DateTime.Parse(passBook.dpDate.Text),
current_user.UserID,
Convert.ToDouble(passBook.txtInterestRates.Text));
pbList.ShowPassBookList(Bank, Models.PassBook.getListPassBook(current_user.UserID, BankID));
passBook.Close();
}
}
catch
{
MessageBox.Show("Đã có lỗi xảy ra, vui lòng kiểm tra lại", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
};
passBook.btnAddBank.Click += (sender, e) =>
{
bank = new Bank(this);
bank.ShowDialog();
};
passBook.cbbTerm.SelectionChanged += (sender, e) =>
{
int TermKey = Convert.ToInt32(((KeyValuePair <int, string>)passBook.cbbTerm.SelectedItem).Key);
if (TermKey == 99)
{
passBook.txtIndefiniteTerm.IsEnabled = true;
passBook.txtInterestRates.Text = "0";
passBook.txtInterestRates.IsEnabled = false;
}
else
{
passBook.txtInterestRates.IsEnabled = passBook.txtIndefiniteTerm.IsEnabled = true;
}
};
passBook.btnCancel.Click += (sender, e) =>
{
passBook.Close();
};
passBook.btnClose.Click += (sender, e) =>
{
passBook.Close();
};
}
