private void SaveDate()
{
banking_dbEntities dbe = new banking_dbEntities();
newAccount nacc = new newAccount();
debit dp = new debit();
dp.Date = lblDate.Text;
dp.AccountNo = Convert.ToDecimal(txtAccountNumber.Text);
dp.Name = txtName.Text;
dp.OldBalancae = Convert.ToDecimal(txtOldBalance.Text);
dp.Mode = cboMode.SelectedItem.ToString();
dp.DebAmount = Convert.ToDecimal(txtAmount.Text);
dbe.debits.Add(dp);
dbe.SaveChanges();
decimal b = Convert.ToDecimal(txtAccountNumber.Text);
var item = (from u in dbe.userAccounts
where u.Account_No == b
select u).FirstOrDefault();
item.Balance = item.Balance - Convert.ToDecimal(txtAmount.Text);
dbe.SaveChanges();
MessageBox.Show("Debit Money");
}
private void btnSave_Click(object sender, EventArgs e)
{
banking_dbEntities dbe = new banking_dbEntities();
decimal accno = Convert.ToDecimal(txtAccount.Text);
var accounts = dbe.userAccounts.Where(x => x.Account_No == accno).SingleOrDefault();
FD fdform = new FD();
fdform.Account_No = Convert.ToDecimal(txtAccount.Text);
fdform.Mode = cboMode.SelectedItem.ToString();
fdform.Dollar = txtDolar.Text;
//fdform.Period = Convert.ToInt32(txtPeriod.Text);
fdform.Interest_Rate = Convert.ToDecimal(txtInterest.Text);
fdform.Start_Date = DateTime.UtcNow.ToString("MM/dd/yyyy");
fdform.Maturity_Date = (DateTime.UtcNow.AddDays(Convert.ToInt32(txtPeriod.Text))).ToString("MM/dd/yyy");
fdform.Maturity_Mount = ((Convert.ToDecimal(txtDolar.Text) * Convert.ToInt32(txtPeriod.Text) * Convert.ToDecimal(txtInterest.Text)) /
(100 * 12 * 30)) + (Convert.ToDecimal(txtDolar.Text));
dbe.FDs.Add(fdform);
decimal amount = Convert.ToDecimal(txtDolar.Text);
decimal totalamount = Convert.ToDecimal(accounts.Balance);
decimal fdamount = totalamount - amount;
accounts.Balance = fdamount;
dbe.SaveChanges();
MessageBox.Show("FD Started Now");
}
private void btnTransfer_Click(object sender, EventArgs e)
{
banking_dbEntities dbe = new banking_dbEntities();
decimal b = Convert.ToDecimal(txtFromAccountNumber.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(txtTransferAmount.Text);
decimal transferacc = Convert.ToDecimal(txtDestinationAmount.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(txtFromAccountNumber.Text);
transfer.ToTransfer = Convert.ToDecimal(txtDestinationAmount.Text);
transfer.Date = DateTime.UtcNow.ToString();
transfer.Name = txtName.Text;
transfer.Balance = Convert.ToDecimal(txtTransferAmount.Text);
dbe.Transfers.Add(transfer);
dbe.SaveChanges();
MessageBox.Show("Transfer Money Succesfully");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
bi.RemoveAt(dataGridView1.SelectedRows[0].Index);
dbe = new banking_dbEntities();
decimal a = Convert.ToDecimal(txtAccountNumber.Text);
userAccount acc = dbe.userAccounts.First(s => s.Account_No.Equals(a));
dbe.userAccounts.Remove(acc);
dbe.SaveChanges();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
dbe = new banking_dbEntities();
decimal accountno = Convert.ToDecimal(txtAccountNumber.Text);
userAccount useraccount = dbe.userAccounts.First(s => s.Account_No.Equals(accountno));
useraccount.Account_No = Convert.ToDecimal(txtAccountNumber.Text);
useraccount.Name = txtName.Text;
useraccount.Date = dateTimePicker1.Value.ToString();
useraccount.Mother_Name = txtMotherName.Text;
useraccount.Father_Name = txtFatherName.Text;
useraccount.PhoneNo = txtPhoneNumber.Text;
if (rdbMale.Checked == true)
{
useraccount.Gender = "Male";
}
else
{
if (rdbFemale.Checked == true)
{
useraccount.Gender = "Female";
}
}
if (rdbMarried.Checked == true)
{
useraccount.Martital_Status = "Married";
}
else
{
if (rdbUnmarried.Checked == true)
{
useraccount.Martital_Status = "Unmarried";
}
}
Image img = pictureBox1.Image;
if (img.RawFormat != null)
{
if (ms != null)
{
img.Save(ms, img.RawFormat);
useraccount.Picture = ms.ToArray();
}
}
useraccount.Address = txtAddress.Text;
useraccount.District = txtDistrict.Text;
useraccount.State = txtState.Text;
dbe.SaveChanges();
MessageBox.Show("Record Updates ");
}
private void btnUpdate_Click(object sender, EventArgs e)
{
banking_dbEntities context = new banking_dbEntities();
newAccount acc = new newAccount();
Deposit dp = new Deposit();
dp.Date = lblDate.Text;
dp.AccountNo = Convert.ToDecimal(txtAccountNumber.Text);
dp.Name = txtName.Text;
dp.OldeBalance = Convert.ToDecimal(txtOldBalance.Text);
dp.Mode = cboMode.SelectedItem.ToString();
dp.DipAmount = Convert.ToDecimal(txtAmount.Text);
context.Deposits.Add(dp);
context.SaveChanges();
decimal b = Convert.ToDecimal(txtAccountNumber.Text);
var item = (from u in context.userAccounts
where u.Account_No == b
select u).FirstOrDefault();
item.Balance = item.Balance + Convert.ToDecimal(txtAmount.Text);
context.SaveChanges();
MessageBox.Show("Deposit Money Successfully");
}
private void btnSave_Click(object sender, EventArgs e)
{
if (rdbMale.Checked)
{
gender = "Male";
}
else if (rdbFemale.Checked)
{
gender = "Female";
}
if (rdbMarried.Checked)
{
m_status = "Married";
}
else if (rdbUnmarried.Checked)
{
m_status = "Unmarried";
}
BSE = new banking_dbEntities();
userAccount acc = new userAccount();
acc.Account_No = Convert.ToDecimal(txtAccountNumber.Text);
acc.Name = txtName.Text;
acc.DOB = dtpDOB.Text;
acc.PhoneNo = txtPhoneNumber.Text;
acc.Address = txtAddress.Text;
acc.District = txtDist.Text;
acc.State = cboState.SelectedItem.ToString();
acc.Gender = gender;
acc.Martital_Status = m_status;
acc.Mother_Name = txtMotherName.Text;
acc.Father_Name = txtFatherName.Text;
acc.Balance = Convert.ToDecimal(txtBalance.Text);
acc.Date = lblDate.Text;
acc.Picture = ms.ToArray();
BSE.userAccounts.Add(acc);
BSE.SaveChanges();
MessageBox.Show("File Saved");
}
private void btnChange_Click(object sender, EventArgs e)
{
banking_dbEntities dbe = new banking_dbEntities();
if (txtOldPassword.Text != string.Empty || txtNewPassword.Text != string.Empty || txtRetype.Text != string.Empty)
{
Admin_Table user1 = dbe.Admin_Table.FirstOrDefault(a => a.UserName.Equals(txtUsername.Text));
if (user1 != null)
{
if (user1.Password.Equals(txtOldPassword.Text))
{
user1.Password = txtNewPassword.Text;
dbe.SaveChanges();
MessageBox.Show("Password Change Successfully");
}
else
{
MessageBox.Show("Password Incorrect");
}
}
}
}
