private void button1_Click(object sender, EventArgs e)
{
Bank_Mangment_SystemEntities1 dbe = new Bank_Mangment_SystemEntities1();
if (usertextBox.Text != String.Empty || passwordtextBox.Text != String.Empty)
{
var user1 = dbe.Admin_Table.FirstOrDefault(a => a.Username.Equals(usertextBox.Text));
if (user1 != null)
{
if (user1.Password.Equals(passwordtextBox.Text))
{
Menu m1 = new Menu();
m1.ShowDialog();
}
else
{
MessageBox.Show("Incorrect password", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("please enter correct values", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Please enter username or password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void button2_Click(object sender, EventArgs e)
{
Bank_Mangment_SystemEntities1 dbe = new Bank_Mangment_SystemEntities1();
decimal b = Convert.ToDecimal(fromacctxt.Text);
var item = (from u in dbe.userAccounts where u.Account_No == b select u).FirstOrDefault();
decimal b1 = Convert.ToDecimal(item.balance);
decimal totalbal = Convert.ToDecimal(transfertxt.Text);
decimal transferacc = Convert.ToDecimal(desacctxt.Text);
if (b1 > totalbal)
{
userAccount item2 = (from u in dbe.userAccounts where u.Account_No == transferacc select u).FirstOrDefault();
item2.balance = item2.balance + totalbal;
item.balance = item.balance - totalbal;
Transfer transfer = new Transfer();
transfer.Account_No = Convert.ToDecimal(fromacctxt.Text);
transfer.Name = nametxt.Text;
transfer.ToTransfer = Convert.ToDecimal(desacctxt.Text);
transfer.Date = DateTime.UtcNow.ToString();
transfer.balance = Convert.ToDecimal(transfertxt.Text);
dbe.Transfers.Add(transfer);
dbe.SaveChanges();
MessageBox.Show("Transfer Money Successfully");
}
}
private void button1_Click(object sender, EventArgs e)
{
Bank_Mangment_SystemEntities1 dbe = new Bank_Mangment_SystemEntities1();
decimal accno = Convert.ToDecimal(accnotxt.Text);
var accounts = dbe.userAccounts.Where(x => x.Account_No == accno).SingleOrDefault();
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.FDs.Add(fdform);
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 bindgrids()
{
dataGridView1.AutoGenerateColumns = false;
Bank_Mangment_SystemEntities1 bs = new Bank_Mangment_SystemEntities1();
var item = bs.userAccounts.ToList();
dataGridView1.DataSource = item;
//throw new NotImplementedException();
}
private void button1_Click(object sender, EventArgs e)
{
Bank_Mangment_SystemEntities1 context = new Bank_Mangment_SystemEntities1();
decimal b = Convert.ToDecimal(acctext.Text);
var item = (from u in context.userAccounts where u.Account_No == b select u).FirstOrDefault();
nametext.Text = item.Name;
oldbaltext.Text = Convert.ToString(item.balance);
}
private void button4_Click(object sender, EventArgs e)
{
bi.RemoveAt(dataGridView1.SelectedRows[0].Index);
dbe = new Bank_Mangment_SystemEntities1();
decimal a = Convert.ToDecimal(accnotext.Text);
userAccount acc = dbe.userAccounts.First(s => s.Account_No.Equals(a));
dbe.userAccounts.Remove(acc);
dbe.SaveChanges();
}
private void button1_Click(object sender, EventArgs e)
{
bl = new BindingList <FD>();
dbe = new Bank_Mangment_SystemEntities1();
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 loadaccount()
{
BSE = new Bank_Mangment_SystemEntities1();
var item = BSE.userAccounts.ToArray();
if (!string.IsNullOrEmpty(accnotext.Text))
{
no = item.LastOrDefault().Account_No + 1;
accnotext.Text = Convert.ToString(no);
}
}
private void button2_Click(object sender, EventArgs e)
{
bi = new BindingList <userAccount>();
dbe = new Bank_Mangment_SystemEntities1();
var item = dbe.userAccounts.Where(a => a.Name == nametext.Text);
foreach (var item1 in item)
{
bi.Add(item1);
}
dataGridView1.DataSource = bi;
}
private void button1_Click(object sender, EventArgs e)
{
bi = new BindingList <userAccount>();
dbe = new Bank_Mangment_SystemEntities1();
decimal accno = Convert.ToDecimal(accnotext.Text);
var item = dbe.userAccounts.Where(a => a.Account_No == accno);
foreach (var item1 in item)
{
bi.Add(item1);
}
dataGridView1.DataSource = bi;
}
private void button1_Click(object sender, EventArgs e)
{
Bank_Mangment_SystemEntities1 dbe = new Bank_Mangment_SystemEntities1();
decimal b = Convert.ToDecimal(textBox1.Text);
var item = (from u in dbe.debits where u.AccountNo == b select u);
dataGridView1.DataSource = item.ToList();
var item1 = (from u in dbe.Deposits where u.AccountNo == 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 button3_Click(object sender, EventArgs e)
{
dbe = new Bank_Mangment_SystemEntities1();
decimal accountno = Convert.ToDecimal(accnotext.Text);
userAccount useraccount = dbe.userAccounts.First(s => s.Account_No.Equals(accnotext));
useraccount.Account_No = Convert.ToDecimal(accnotext.Text);
useraccount.Name = nametext.Text;
useraccount.Date = dateTimePicker1.Value.ToString();
useraccount.Mother_Name = mothertext.Text;
useraccount.Father_Name = fathertext.Text;
useraccount.PhoneNo = phonetextbox.Text;
if (maleradio.Checked == true)
{
useraccount.Gender = "Male";
}
else
{
if (femaleradio.Checked == true)
{
useraccount.Gender = "Female";
}
}
if (marriedradio.Checked == true)
{
useraccount.martial_status_ = "Married";
}
else
{
if (unmarriedradio.Checked == true)
{
useraccount.martial_status_ = "UnMarried";
}
}
Image img = pictureBox1.Image;
if (img.RawFormat != null)
{
if (ms != null)
{
img.Save(ms, img.RawFormat);
useraccount.Picture = ms.ToArray();
}
}
useraccount.District = districttext.Text;
useraccount.State = statetext.Text;
dbe.SaveChanges();
MessageBox.Show("Record Updated!");
}
private void button2_Click(object sender, EventArgs e)
{
if (maleradioButton.Checked)
{
gender = "Male";
}
else if (femaleradioButton.Checked)
{
gender = "Female";
}
else if (otherradioButton.Checked)
{
gender = "Other";
}
if (marriedradioButton.Checked)
{
m_status = "Married";
}
else if (unmarriedradioButton.Checked)
{
m_status = "UnMarried";
}
BSE = new Bank_Mangment_SystemEntities1();
userAccount acc = new userAccount();
acc.Account_No = Convert.ToDecimal(accnotext.Text);
acc.Name = nametext.Text;
acc.DOB = dateTimePicker1.Value.ToString();
acc.PhoneNo = phonetext.Text;
acc.District = distext.Text;
acc.State = comboBox1.SelectedItem.ToString();
acc.Gender = gender;
acc.martial_status_ = m_status;
acc.Mother_Name = mothertext.Text;
acc.Father_Name = fathertext.Text;
acc.balance = Convert.ToDecimal(balancetext.Text);
acc.Date = datelbl.Text;
acc.Picture = ms.ToArray();
BSE.userAccounts.Add(acc);
BSE.SaveChanges();
MessageBox.Show("FILE SAVED");
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
dbe = new Bank_Mangment_SystemEntities1();
decimal accno = Convert.ToDecimal(dataGridView1.Rows[e.RowIndex].Cells[0].Value);
var item = dbe.userAccounts.Where(a => a.Account_No == accno).FirstOrDefault();
accnotext.Text = item.Account_No.ToString();
nametext.Text = item.Name;
mothertext.Text = item.Mother_Name;
fathertext.Text = item.Father_Name;
phonetextbox.Text = item.PhoneNo;
byte[] img = item.Picture;
MemoryStream ms = new MemoryStream(img);
pictureBox1.Image = Image.FromStream(ms);
districttext.Text = item.District;
statetext.Text = item.State;
if (item.Gender == "Male")
{
maleradio.Checked = true;
}
if (item.Gender == "Female")
{
femaleradio.Checked = true;
}
if (item.Gender == "Other")
{
otherradio.Checked = true;
}
if (item.martial_status_ == "Married")
{
marriedradio.Checked = true;
}
if (item.martial_status_ == "UnMarried")
{
unmarriedradio.Checked = true;
}
if (item.Gender == "Male")
{
maleradio.Checked = true;
}
}
private void detailbutton_Click(object sender, EventArgs e)
{
Bank_Mangment_SystemEntities1 context = new Bank_Mangment_SystemEntities1();
NewAccount acc = new NewAccount();
Deposit dp = new Deposit();
dp.Date = datalbl.Text;
dp.AccountNo = Convert.ToDecimal(acctext.Text);
dp.Name = nametext.Text;
dp.OldBalance = Convert.ToDecimal(oldbaltext.Text);
dp.Mode = comboBox1.SelectedItem.ToString();
dp.DipAmount = Convert.ToDecimal(amounttext.Text);
context.SaveChanges();
decimal b = Convert.ToDecimal(acctext.Text);
var item = (from u in context.userAccounts where u.Account_No == b select u).FirstOrDefault();
item.balance = item.balance + Convert.ToDecimal(amounttext.Text);
context.SaveChanges();
MessageBox.Show("Deposit Money Succesfully :)");
}
private void button1_Click(object sender, EventArgs e)
{
Bank_Mangment_SystemEntities1 dbe = new Bank_Mangment_SystemEntities1();
NewAccount nacc = new NewAccount();
debit dp = new debit();
dp.Date = datelabel.Text;
dp.AccountNo = Convert.ToDecimal(acctxt.Text);
dp.Name = nametxt.Text;
dp.OldBalance = Convert.ToDecimal(oldbaltxt.Text);
dp.Mode = comboBox1.SelectedItem.ToString();
dp.DebAmount = Convert.ToDecimal(amounttxt.Text);
dbe.debits.Add(dp);
dbe.SaveChanges();
decimal b = Convert.ToDecimal(acctxt.Text);
var item = (from u in dbe.userAccounts where u.Account_No == b select u).FirstOrDefault();
item.balance = item.balance - Convert.ToDecimal(amounttxt.Text);
dbe.SaveChanges();
MessageBox.Show("Debit Money");
}
private void button1_Click(object sender, EventArgs e)
{
Bank_Mangment_SystemEntities1 dbe = new Bank_Mangment_SystemEntities1();
if (oldpasswordtxt.Text != string.Empty || newpasswordtxt.Text != string.Empty || retypepasswordtxt.Text != string.Empty)
{
Admin_Table user1 = dbe.Admin_Table.FirstOrDefault(a => a.Username.Equals(usertxt.Text));
if (user1 != null)
{
if (user1.Password.Equals(oldpasswordtxt.Text))
{
user1.Password = newpasswordtxt.Text;
dbe.SaveChanges();
MessageBox.Show("Password Changed Successfully!");
}
else
{
MessageBox.Show("Password Incorrect");
}
}
}
}
