private void button1_Click(object sender, EventArgs e)
{
bankmanagement_dbEntities2 db = new bankmanagement_dbEntities2();
if (usertxt.Text != string.Empty || passtxt.Text != string.Empty)
{
var user1 = db.Admins.FirstOrDefault(a => a.username.Equals(usertxt.Text));
if (user1 != null)
{
if (user1.password.Equals(passtxt.Text))
{
{
menu obj = new menu();
this.Hide();
obj.ShowDialog();
}
}
else
{
MessageBox.Show("password incorrect");
}
}
else
{
MessageBox.Show("please fill in details");
}
}
else
{
MessageBox.Show("enter deatils");
}
}
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 button1_Click(object sender, EventArgs e)
{
bankmanagement_dbEntities2 dbe = new bankmanagement_dbEntities2();
decimal no = Convert.ToDecimal(accnotxt.Text);
var accounts = dbe.userAccounts.Where(x => x.Account_no == no).SingleOrDefault();
FD farm = new FD();
farm.Account_no = Convert.ToDecimal(accnotxt.Text);
farm.Mode = comboBox1.SelectedItem.ToString();
farm.Rupees = rupeestxt.Text;
farm.period = Convert.ToInt32(periodtxt.Text);
farm.intrest = Convert.ToDecimal(intresttxt.Text);
farm.start_date = DateTime.UtcNow.ToString("MM/dd/yyyy");
farm.maturity_date = (DateTime.UtcNow.AddDays(Convert.ToInt32(periodtxt.Text))).ToString("MM/dd/yyyy");
farm.maturity_amount = ((Convert.ToDecimal(rupeestxt.Text) * Convert.ToInt32(periodtxt.Text) * Convert.ToDecimal(intresttxt.Text) / (100 * 12 * 30)) + (Convert.ToDecimal(rupeestxt.Text)));
dbe.FDs.Add(farm);
decimal amount = Convert.ToDecimal(rupeestxt.Text);
decimal totalamount = Convert.ToDecimal(accounts.balance);
decimal fdamount = totalamount - amount;
accounts.balance = fdamount;
dbe.SaveChanges();
MessageBox.Show("fd started now");
}
private void loadaccount()
{
bmd = new bankmanagement_dbEntities2();
var obj = bmd.userAccounts.ToArray();
no = obj.LastOrDefault().Account_no + 1;
accnotxt.Text = Convert.ToString(no);
}
private void button1_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();
nametxt.Text = item.Name;
amounttxt.Text = Convert.ToString(item.balance);
}
private void bindgrid()
{
//throw new NotImplementedException();
dataGridView1.AutoGenerateColumns = false;
bankmanagement_dbEntities2 bmd = new bankmanagement_dbEntities2();
var items = bmd.userAccounts.ToList();
dataGridView1.DataSource = items;
}
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 textBox1_TextChanged(object sender, EventArgs e)
{
bankmanagement_dbEntities2 con = new bankmanagement_dbEntities2();
decimal no = Convert.ToDecimal(accountxt.Text);
var item = (from u in con.userAccounts where u.Account_no == no select u).FirstOrDefault();
//oldbalancetxt.Text = Convert.ToString(item.balance);
//nametxt.Text = item.Name;
}
private void button1_Click(object sender, EventArgs e)
{
bankmanagement_dbEntities2 con = new bankmanagement_dbEntities2();
decimal accno = Convert.ToDecimal(accountxt.Text);
var item = con.userAccounts.Where(a => a.Account_no == accno).FirstOrDefault();
accountxt.Text = item.Account_no.ToString();
nametxt.Text = item.Name;
oldbalancetxt.Text = Convert.ToString(item.balance);
}
private void button1_Click(object sender, EventArgs e)
{
b1 = new BindingList <FD>();
dbe = new bankmanagement_dbEntities2();
String date = dateTimePicker1.Value.ToString("MM/dd/yyyy");
MessageBox.Show(date);
var item = dbe.FDs.Where(a => a.start_date.Equals(date));
dataGridView1.DataSource = item.ToList();
}
private void button5_Click(object sender, EventArgs e)
{
b1 = new BindingList <userAccount>();
bs = new bankmanagement_dbEntities2();
var items = bs.userAccounts.Where(a => a.Name == nametxt.Text);
foreach (var item1 in items)
{
b1.Add(item1);
}
dataGridView1.DataSource = b1;
}
private void button4_Click(object sender, EventArgs e)
{
b1 = new BindingList <userAccount>();
bs = new bankmanagement_dbEntities2();
decimal accno = Convert.ToDecimal(accnotxt.Text);
var items = bs.userAccounts.Where(a => a.Account_no == accno);
foreach (var item1 in items)
{
b1.Add(item1);
}
dataGridView1.DataSource = b1;
}
private void button1_Click(object sender, EventArgs e)
{
bankmanagement_dbEntities2 dbe = new bankmanagement_dbEntities2();
decimal b = Convert.ToDecimal(textBox1.Text);
var item = (from u in dbe.debits where u.Account_no == b select u);
dataGridView1.DataSource = item.ToList();
var item1 = (from u in dbe.deposit__ where u.Account_no == b select u);
dataGridView2.DataSource = item1.ToList();
var item2 = (from u in dbe.Transfers where u.Account_no == b select u);
dataGridView3.DataSource = item2.ToList();
}
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)
{
bankmanagement_dbEntities2 con = new bankmanagement_dbEntities2();
NewAccount ac = new NewAccount();
deposit__ dp = new deposit__();
decimal no = Convert.ToDecimal(accnotxt.Text);
dp.Name = nametxt.Text;
dp.old_balance = Convert.ToDecimal(oldbalancetxt.Text);
dp.depamount = Convert.ToDecimal(dpamounttxt.Text);
dp.Account_no = Convert.ToDecimal(value: accnotxt.Text);
dp.date = datelabel.Text;
dp.Mode = comboBox1.SelectedItem.ToString();
con.deposit__.Add(dp);
con.SaveChanges();
var item = (from u in con.userAccounts where u.Account_no == no select u).FirstOrDefault();
item.balance = item.balance + Convert.ToDecimal(dpamounttxt.Text);
con.SaveChanges();
MessageBox.Show("deposit success");
}
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();
}
private void button1_Click(object sender, EventArgs e)
{
bankmanagement_dbEntities2 dbe = new bankmanagement_dbEntities2();
if (oldpass.Text != string.Empty || newpass.Text != string.Empty)
{
Admin user1 = dbe.Admins.FirstOrDefault(a => a.username.Equals(usertxt.Text));
if (user1 != null)
{
if (user1.password.Equals(oldpass.Text))
{
user1.password = newpass.Text;
dbe.SaveChanges();
MessageBox.Show("password changed");
}
else
{
MessageBox.Show("passwordincorrect");
}
}
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
bs = new bankmanagement_dbEntities2();
decimal accno = Convert.ToDecimal(dataGridView1.Rows[e.RowIndex].Cells[0].Value);
var item = bs.userAccounts.Where(a => a.Account_no == accno).FirstOrDefault();
accnotxt.Text = item.Account_no.ToString();
nametxt.Text = item.Name;
mothertxt.Text = item.mothername;
fathertxt.Text = item.fathername;
phonetxt.Text = item.Phoneno;
addresstxt.Text = item.Address;
byte[] img = item.picture;
MemoryStream ms = new MemoryStream(img);
pictureBox1.Image = Image.FromStream(ms);
distxt.Text = item.District;
statetxt.Text = item.state;
if (item.Gender == "male")
{
maleradio.Checked = true;
}
else if (item.Gender == "female")
{
femaleradio.Checked = true;
}
if (item.m_status == "married")
{
marriedradio.Checked = true;
}
else if (item.m_status == "single")
{
singleradio.Checked = true;
}
}