private void Button2_Click(object sender, EventArgs e)
{
BankDataEntities dbe = new BankDataEntities();
decimal b = Convert.ToDecimal(txtFromAN.Text);
var item = (from u in dbe.user_Accounts where u.AccountNo == b select u).FirstOrDefault();
decimal b1 = Convert.ToDecimal(item.Balance);
decimal totalbal = Convert.ToDecimal(txtCurrentAmount.Text);////////check check//////
decimal transferacc = Convert.ToDecimal(txtDestAmt.Text);
if (b1 > totalbal)
{
user_Accounts item2 = (from u in dbe.user_Accounts where u.AccountNo == transferacc select u).FirstOrDefault();
item2.Balance = item2.Balance + totalbal;
item2.Balance = item2.Balance - totalbal;
Transfer transfer = new Transfer();
transfer.AccountNo = Convert.ToInt32(txtFromAN.Text);
transfer.ToTransfer = Convert.ToDecimal(txtDestAmt.Text);
transfer.Date = DateTime.UtcNow.ToString();
transfer.Name = txtName.Text;
transfer.Balance = Convert.ToDecimal(txtAmount.Text);
dbe.Transfers.Add(transfer);
dbe.SaveChanges();
MessageBox.Show("Transfer successful");
}
}
private void Button4_Click(object sender, EventArgs e)
{
bi.RemoveAt(dataGridView1.SelectedRows[0].Index);
dbe = new BankDataEntities();
int acc = Convert.ToInt32(txtAccountNo.Text);
user_Accounts a = dbe.user_Accounts.First(s => s.AccountNo.Equals(acc));
dbe.user_Accounts.Remove(a);
dbe.SaveChanges();
}
private void Button3_Click(object sender, EventArgs e)
{
dbe = new BankDataEntities();
decimal accno = Convert.ToInt32(txtAccountNo.Text);
user_Accounts ua = new user_Accounts();
// user_Accounts a = dbe.user_Accounts.First(s => s.AccountNo.Equals(ua));
ua.AccountNo = Convert.ToInt32(txtAccountNo.Text);
ua.Name = txtName.Text;
ua.DOB = dateTimePicker1.ToString();
ua.Mother_name = txtMN.Text;
ua.Father_name = txtFN.Text;
ua.PhoneNo = txtPN.Text;
if (btnRmale.Checked == true)
{
ua.Gender = "male";
}
else
{
if (btnRFemale.Checked == true)
{
ua.Gender = "female";
}
}
if (btnRMarried.Checked == true)
{
ua.marital_status = "married";
}
else
{
if (btnRUnMarried.Checked == true)
{
ua.marital_status = "Un-married";
}
}
//Image img = pictureBox1.Image;
// if (img.RawFormat != null)
///if (ms != null)
// {
// img.Save(ms, img.RawFormat);
// ua.Picture = ms.ToArray();
//}
ua.Address = txtA.Text;
ua.District = txtDistrict.Text;
ua.State = txtState.Text;
dbe.SaveChanges();
MessageBox.Show("Record Updated");
}
private void BtnSave_Click(object sender, EventArgs e)
{
BankDataEntities dbe = new BankDataEntities();
formNewAccount nacc = new formNewAccount();
Debit wd = new Debit();
wd.Date = lblDate.Text;
wd.AccountNo = Convert.ToInt32(txtAccountNo.Text);
wd.Name = txtName.Text;
wd.OldBalance = Convert.ToDecimal(txtOldBalance.Text);
wd.Mode = comboBox1.SelectedItem.ToString();
wd.DebitAmount = Convert.ToDecimal(txtAmount.Text);
dbe.Debits.Add(wd);
dbe.SaveChanges();
decimal b = Convert.ToDecimal(txtAccountNo.Text);
var item = (from u in dbe.user_Accounts where u.AccountNo == b select u).FirstOrDefault();
item.Balance = item.Balance - NewMethod();
dbe.SaveChanges();
MessageBox.Show("Debit Money");
}
private void Button2_Click(object sender, EventArgs e)//update
{
BankDataEntities context = new BankDataEntities();
decimal b = Convert.ToDecimal(txtAccountNo.Text);
var item = (from u in context.user_Accounts
where u.AccountNo == b
select u).FirstOrDefault();
//txtName.Text = item.Name;
//txtOB.Text = Convert.ToString(item.Balance);
item.Balance = item.Balance + Convert.ToDecimal(txtDepositAmt.Text);
// context.Deposits.Add()
context.SaveChanges();
MessageBox.Show("Deposit Money Successfully");
}
