private void button2_Click(object sender, EventArgs e) { bankmanagement_dbEntities2 con = new bankmanagement_dbEntities2(); decimal no = Convert.ToDecimal(fromaccounttxt.Text); var item = (from u in con.userAccounts where u.Account_no == no select u).FirstOrDefault(); decimal b1 = Convert.ToDecimal(item.balance); decimal totalbal = Convert.ToDecimal(tranfertxt.Text); decimal trasferacc = Convert.ToDecimal(desaccounttxt.Text); if (b1 > totalbal) { userAccount item2 = (from u in con.userAccounts where u.Account_no == trasferacc select u).FirstOrDefault(); item2.balance = item2.balance + totalbal; item.balance = item.balance - totalbal; //on.SaveChanges(); Transfer trans = new Transfer(); trans.Account_no = Convert.ToDecimal(fromaccounttxt.Text); trans.Totransfer = Convert.ToDecimal(desaccounttxt.Text); trans.Date = DateTime.UtcNow.ToString(); trans.Name = nametxt.Text; trans.Balance = Convert.ToDecimal(tranfertxt.Text); con.Transfers.Add(trans); con.SaveChanges(); MessageBox.Show("transfer complete"); } }
private void button2_Click(object sender, EventArgs e) { b1.RemoveAt(dataGridView1.SelectedRows[0].Index); bs = new bankmanagement_dbEntities2(); decimal a = Convert.ToDecimal(accnotxt.Text); userAccount acc = bs.userAccounts.First(s => s.Account_no.Equals(a)); bs.userAccounts.Remove(acc); bs.SaveChanges(); }
private void button1_Click(object sender, EventArgs e) { bs = new bankmanagement_dbEntities2(); decimal accno = Convert.ToDecimal(accnotxt.Text); userAccount us = bs.userAccounts.First(s => s.Account_no.Equals(accnotxt)); us.Account_no = Convert.ToDecimal(accnotxt.Text); us.Name = nametxt.Text; us.Date = dateTimePicker1.Value.ToString(); us.mothername = mothertxt.Text; us.fathername = fathertxt.Text; us.Phoneno = phonetxt.Text; if (maleradio.Checked == true) { us.Gender = "male"; } else if (femaleradio.Checked == true) { us.Gender = "female"; } if (marriedradio.Checked == true) { us.m_status = "married"; } else if (singleradio.Checked == true) { us.m_status = "single"; } Image img = pictureBox1.Image; if (img.RawFormat != null) { if (ms != null) { img.Save(ms, img.RawFormat); us.picture = ms.ToArray(); } } us.Address = addresstxt.Text; us.District = distxt.Text; us.state = statetxt.Text; bs.SaveChanges(); MessageBox.Show("record updated"); }
private void button2_Click(object sender, EventArgs e) { if (maleradio.Checked) { gender = "male"; } else if (femaleradio.Checked) { gender = "female"; } if (marriedradio.Checked) { m_status = "married"; } else if (singleradio.Checked) { m_status = "single"; } bmd = new bankmanagement_dbEntities2(); userAccount acc = new userAccount(); acc.Account_no = Convert.ToDecimal(accnotxt.Text); acc.Name = nametxt.Text; acc.Dob = dateTimePicker1.Value.ToString(); acc.Phoneno = phonetxt.Text; acc.Address = addresstxt.Text; acc.District = disttxt.Text; acc.state = comboBox1.SelectedItem.ToString(); acc.Gender = gender; acc.m_status = m_status; acc.fathername = fathertxt.Text; acc.mothername = mothertxt.Text; acc.balance = Convert.ToDecimal(balancetxt.Text); acc.Date = datelal.Text; acc.picture = ms.ToArray(); _ = bmd.userAccounts.Add(acc); _ = bmd.SaveChanges(); _ = MessageBox.Show("succesfull"); this.Hide(); }