private void Button1_Click(object sender, EventArgs e) { banking_dbEntities context = new banking_dbEntities(); newAccount acc = new newAccount(); Deposit dp = new Deposit(); dp.Date = date1b1.Text; dp.AccountNo = Convert.ToDecimal(acctxt.Text); dp.Name = nametxt.Text; dp.OldBalance = Convert.ToDecimal(oldbaltxt.Text); dp.Mode = ComboBox.SelectedItem.ToString(); dp.DipAmount = Convert.ToDecimal(amounttxt.Text); context.Deposit.Add(dp); decimal b = Convert.ToDecimal(acctxt.Text); var item = (from u in context.userAccount where u.Account_No == b select u).FirstOrDefault(); item.balance = item.balance + Convert.ToDecimal(amounttxt.Text); try { context.SaveChanges(); MessageBox.Show("Deposit Money Sucessfully"); } catch { // throw new NotImplementedException(); MessageBox.Show("Deposit Money Sucessfully"); } // MessageBox.Show("Deposit Money Sucessfully"); }
private void Button1_Click(object sender, EventArgs e) { banking_dbEntities dbe = new banking_dbEntities(); decimal accno = Convert.ToDecimal(accnotxt.Text); var accounts = dbe.userAccount.Where(x => x.Account_No == accno).SingleOrDefault(); //SingleOrDefault()으로 시퀀스의 특정 단일 요소를 반환 합니다. FD fdform = new FD(); //FD fdform = new FD(); fdform.Account_No = Convert.ToDecimal(accnotxt.Text); fdform.Mode = comboBox1.SelectedItem.ToString(); fdform.Rupees = rupeestxt.Text; fdform.Period = Convert.ToInt32(periodtxt.Text); fdform.Interest_rate = Convert.ToDecimal(interesttxt.Text); fdform.Start_Date = DateTime.UtcNow.ToString("MM/dd/yyyy"); fdform.Maturity_Date = (DateTime.UtcNow.AddDays(Convert.ToInt32(periodtxt.Text))).ToString("MM/dd/yyyy"); fdform.Maturity_Amount = ((Convert.ToDecimal(rupeestxt.Text) * Convert.ToInt32(periodtxt.Text) * Convert.ToDecimal(interesttxt.Text)) / (100 * 12 * 30)) + (Convert.ToDecimal(rupeestxt.Text)); dbe.FD.Add(fdform); decimal amount = Convert.ToDecimal(rupeestxt.Text); decimal totalamount = Convert.ToDecimal(accounts.balance); decimal fdammount = totalamount - amount; accounts.balance = fdammount; try { dbe.SaveChanges(); MessageBox.Show("FD Started Now"); } catch { // throw new NotImplementedException(); MessageBox.Show("FD Started Now"); } }
private void Button2_Click(object sender, EventArgs e) { banking_dbEntities dbe = new banking_dbEntities(); newAccount nacc = new newAccount(); debit dp = new debit();//debit dp dp.Date = date1b1.Text; dp.Account = Convert.ToDecimal(acctxt.Text); dp.Name = nametxt.Text; dp.OldBalance = Convert.ToDecimal(oldbaltxt.Text); dp.Mode = comboBox1.SelectedItem.ToString(); dp.DebAmount = Convert.ToDecimal(DebAmount1.Text); dbe.debit.Add(dp); decimal b = Convert.ToDecimal(acctxt.Text); var item = (from u in dbe.userAccount where u.Account_No == b select u).FirstOrDefault(); item.balance = item.balance - Convert.ToDecimal(DebAmount1.Text); try { dbe.SaveChanges(); MessageBox.Show("Debit Money"); } catch { // throw new NotImplementedException(); MessageBox.Show("Debit Money"); } }
private void Button2_Click(object sender, EventArgs e) { banking_dbEntities dbe = new banking_dbEntities(); if (textBox1.Text != string.Empty || textBox3.Text != string.Empty || repass.Text != string.Empty) { userTable user1 = dbe.userTable.FirstOrDefault(a => a.UserName.Equals(usrtxt.Text)); try { MessageBox.Show("Password Change Successfully"); } catch { MessageBox.Show("Password Change Successfully"); } if (user1 != null) { if (user1.PassWord.Equals(textBox1.Text)) { user1.PassWord = textBox3.Text; dbe.SaveChanges(); MessageBox.Show("Password Change Successfully"); } else { MessageBox.Show("Password Incorrect"); } } } }
private void Button2_Click(object sender, EventArgs e) { banking_dbEntities dbe = new banking_dbEntities(); decimal b = Convert.ToDecimal(fromacctxt.Text); var item = (from u in dbe.userAccount where u.Account_No == b select u).FirstOrDefault(); decimal b1 = Convert.ToDecimal(item.balance); decimal totalbal = Convert.ToDecimal(transfertxt.Text);//이체금액 decimal transferacc = Convert.ToDecimal(desaccounttxt.Text); if (b1 > totalbal) { userAccount item2 = (from u in dbe.userAccount where u.Account_No == transferacc select u).FirstOrDefault(); item2.balance = item2.balance + totalbal; item.balance = item.balance - totalbal; //dbe.SaveChanged(); Transfer transfer = new Transfer(); //Transfer transfer = new transfer.Account_No = Convert.ToDecimal(fromacctxt.Text); transfer.ToTransfer = Convert.ToDecimal(desaccounttxt.Text); //입금계좌번호 transfer.Date = DateTime.UtcNow.ToString(); transfer.Name = nametxt.Text; transfer.balance = Convert.ToDecimal(amounttxt.Text);//db에 있는잔액을 가져온다 dbe.Transfer.Add(transfer); dbe.SaveChanges(); try { dbe.SaveChanges(); MessageBox.Show("Transfer Money Successfully"); } catch { // throw new NotImplementedException(); MessageBox.Show("Transfer Money Successfully"); } } }
private void Button2_Click(object sender, EventArgs e) { try { bi.RemoveAt(dataGridView1.SelectedRows[0].Index); //RemoveAt으로 List<T>의 지정된 인덱스에 있는 요소를 제거합니다. dbe = new banking_dbEntities(); decimal a = Convert.ToDecimal(acctxt.Text); userAccount acc = dbe.userAccount.First(s => s.Account_No.Equals(a)); //db불러옴 dbe.userAccount.Remove(acc); //db 제거 해준다 dbe.SaveChanges(); //db 변경해준다 //MessageBox.Show("file saved"); // BSE = SaveChanges(); MessageBox.Show("file saved"); } catch { MessageBox.Show("file saved"); } }