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