private void EditLabel_MouseLeftButtonDown(object sender, RoutedEventArgs e)
{
try
{
objBankAccount = null;
btnAdd.IsEnabled = true;
btnEdit.Visibility = Visibility.Hidden;
EditLabel.Content = "";
this.clearFields();
}
catch
{
}
}
public void Add()
{
var tblBankAccount = new tblBankAccount()
{
BankAccountBankName = DBankName,
BankAccountBranchName = DBranchName,
BankAccountNum = DAccountNum,
BankAccountCardNum = DCardNum,
BankAccountInitialBalance = DInitialBalance,
BankAccountDescription = DDescription
};
_dbLoanEntities.tblBankAccount.Add(tblBankAccount);
_dbLoanEntities.SaveChanges();
}
public void Add(Interface.IbankAccounts bankAccounts)
{
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var newBankAcc = new tblBankAccount()
{
accountName = bankAccounts.AccountName,
accountNo = bankAccounts.AccountNo,
balance = Convert.ToDecimal(bankAccounts.Balance),
bank = bankAccounts.Bank,
regNo = bankAccounts.RegNo,
};
dbContext.tblBankAccounts.InsertOnSubmit(newBankAcc);
dbContext.SubmitChanges();
}
}
private void btnEditAccount_Click(object sender, RoutedEventArgs e)
{
try
{
objBankAccount = null;
this.clearFields();
objBankAccount = (tblBankAccount)dgAccounts.SelectedItem;
txtAccountTitle.Text = objBankAccount.AccountTitle;
txtBalance.Text = Convert.ToString(objBankAccount.Balance);
txtBankName.Text = objBankAccount.BankName;
dpDate.Text = objBankAccount.TimeStamp.ToString("yyyy-MM-dd");
btnAdd.IsEnabled = false;
btnEdit.Visibility = Visibility.Visible;
EditLabel.Content = "Update in Progress,\n Click to cancel.";
btnDone.Visibility = Visibility.Hidden;
}
catch
{
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
try
{
tblBankAccount row = (tblBankAccount)dgAccounts.SelectedItem;
if (row == null || row.Id < 1)
{
return;
}
if (MessageBox.Show(String.Format("Delete '{0}' ?", row.AccountTitle), "Confirm delete", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.Yes) == MessageBoxResult.No)
{
return;
}
db.tblBankAccounts.Remove(row);
db.SaveChanges();
this.RefreshDataGrid();
}
catch
{
}
}
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
try
{
var id = objBankAccount.Id;
var result = db.tblBankAccounts.SingleOrDefault(b => b.Id == id);
result.AccountTitle = txtAccountTitle.Text;
result.BankName = txtBankName.Text;
result.Balance = Convert.ToInt32(txtBalance.Text);
result.TimeStamp = Convert.ToDateTime(dpDate.SelectedDate.Value.Date.ToString("yyyy-MM-dd"));
db.SaveChanges();
RefreshDataGrid();
clearFields();
objBankAccount = null;
btnAdd.IsEnabled = true;
btnEdit.Visibility = Visibility.Hidden;
EditLabel.Content = "";
}
catch
{
}
}
private void btnAddAccount_Click(object sender, RoutedEventArgs e)
{
try
{
if (txtAccountTitle.Text == "")
{
MessageBox.Show("Please enter account title first.");
txtAccountTitle.Focus();
return;
}
if (txtBankName.Text == "")
{
MessageBox.Show("Please enter bank name first.");
txtBankName.Focus();
return;
}
var objBankAccount = new tblBankAccount();
objBankAccount.AccountTitle = txtAccountTitle.Text;
objBankAccount.BankName = txtBankName.Text;
if (String.IsNullOrEmpty(dpDate.Text))
{
dpDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
objBankAccount.Balance = Convert.ToInt32(txtBalance.Text);
if (String.IsNullOrEmpty(txtBankName.Text))
{
txtBankName.Text = "0";
}
objBankAccount.TimeStamp = Convert.ToDateTime(dpDate.SelectedDate.Value.Date.ToString("yyyy-MM-dd"));
db.tblBankAccounts.Add(objBankAccount);
db.SaveChanges();
this.RefreshDataGrid();
clearFields();
}
catch
{
}
}
