예제 #1
0
        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");
        }
예제 #2
0
        private void Button1_Click(object sender, EventArgs e)
        {
            banking_dbEntities dbe = new banking_dbEntities();

            if (usrtxt.Text != string.Empty || passtxt.Text != string.Empty)
            {
                var user1 = dbe.Admin_Table.FirstOrDefault(a => a.UserName.Equals(usrtxt.Text));   //일치하는 항목을 찾을 때까지 집합열거시킨다.

                if (user1 != null)
                {
                    if (user1.Password.Equals(passtxt.Text))
                    {
                        Menu m1 = new Menu();
                        m1.ShowDialog();
                    }
                    else
                    {
                        MessageBox.Show("password incorrect");
                    }
                }
                else
                {
                    MessageBox.Show("Null Value");
                }
            }
            else
            {
                MessageBox.Show("please enter username and password");
            }
        }
예제 #3
0
        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");
            }
        }
예제 #4
0
        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");
            }
        }
예제 #5
0
        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");
                    }
                }
            }
        }
예제 #6
0
        private void loadaccount()
        {
            BSE = new banking_dbEntities();
            var item = BSE.userAccount.ToArray();

            no             = item.LastOrDefault().Account_No + 1;
            accnotext.Text = Convert.ToString(no);
        }
예제 #7
0
        private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            dataGridView1.AutoGenerateColumns = false;//AutoGenerateColumns으로 열을 자동으로 만들지 여부를 나타내는 값을 가져오거나 설정 합니다.
            banking_dbEntities bs = new banking_dbEntities();
            var item = bs.userAccount.ToList();

            dataGridView1.DataSource = item;
        }
예제 #8
0
        private void Button2_Click(object sender, EventArgs e)
        {
            banking_dbEntities context = new banking_dbEntities();
            decimal            b       = Convert.ToDecimal(acctxt.Text);
            var item = (from u in context.userAccount where u.Account_No == b select u).FirstOrDefault();//FirstOrDefault으로 시퀀스의 첫 번째 요소를 반환 합니다.

            nametxt.Text   = item.Name;
            oldbaltxt.Text = Convert.ToString(item.balance);
        }
예제 #9
0
        private void Button1_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();

            nametxt.Text   = item.Name;
            amounttxt.Text = Convert.ToString(item.balance);
        }
예제 #10
0
        private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            b1  = new BindingList <FDForm>();
            dbe = new banking_dbEntities();
            string date = dateTimePicker1.Value.ToString("MM/dd/yyyy");

            MessageBox.Show(date);
            var item = dbe.FD.Where(a => a.Start_Date.Equals(date));

            dataGridView1.DataSource = item.ToList();//커넥터가 바인딩된 데이터 소스를 가져오거나 설정합니다.
        }
예제 #11
0
        private void Button4_Click(object sender, EventArgs e)
        {
            bi  = new BindingList <userAccount>();
            dbe = new banking_dbEntities();
            var item = dbe.userAccount.Where(a => a.Name == nametxt.Text);

            foreach (var item1 in item)
            {
                bi.Add(item1);
            }
            dataGridView1.DataSource = bi;
        }
예제 #12
0
        private void Button3_Click(object sender, EventArgs e)
        {
            bi  = new BindingList <userAccount>();
            dbe = new banking_dbEntities();
            decimal accno = Convert.ToDecimal(acctxt.Text);
            var     item  = dbe.userAccount.Where(a => a.Account_No == accno);

            foreach (var item1 in item)
            {
                bi.Add(item1);
            }
            dataGridView1.DataSource = bi;
        }
예제 #13
0
        private void Button2_Click(object sender, EventArgs e)
        {
            if (maleradio.Checked)
            {
                gender = "male";
            }
            else if (femalereadio.Checked)
            {
                gender = "female";
            }
            if (marriedradio.Checked)
            {
                m_status = "married";
            }
            else if (unmarriedradio.Checked)
            {
                m_status = "Un-Married";
            }

            BSE = new banking_dbEntities();
            userAccount acc = new userAccount();

            acc.Account_No      = Convert.ToDecimal(accnotext.Text);
            acc.Name            = nametxt.Text;
            acc.DOB             = dateTimePicker1.Value.ToString();
            acc.PhoneNo         = phonetxt.Text;
            acc.Address         = addtxt.Text;
            acc.District        = disttxt.Text;
            acc.State           = comboBox1.SelectedItem.ToString();
            acc.Gender          = gender;
            acc.maritial_status = m_status;
            acc.balance         = Convert.ToDecimal(balancetxt.Text);
            acc.Date            = date1b1.Text;
            acc.Picture         = ms.ToArray();
            // BSE = SaveChanges();
            BSE.userAccount.Add(acc);
            // MessageBox.Show("file saved");

            try

            {
                // BSE = SaveChanges();
                MessageBox.Show("file saved");
            }

            catch

            {
                MessageBox.Show("file saved");
            }
        }
예제 #14
0
        private void Button1_Click(object sender, EventArgs e)
        {
            banking_dbEntities dbe = new banking_dbEntities();
            decimal            b   = Convert.ToDecimal(textBox1.Text);
            var item = (from u in dbe.debit where u.Account == b select u);

            DataGridView1.DataSource = item.ToList();
            var item1 = (from u in dbe.Deposit where u.AccountNo == b select u);

            DataGridView2.DataSource = item1.ToList();
            var item2 = (from u in dbe.Transfer where u.Account_No == b select u);

            DataGridView3.DataSource = item2.ToList();
        }
예제 #15
0
        private void DataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
        {
            dbe = new banking_dbEntities();
            decimal accno = Convert.ToDecimal(dataGridView1.Rows[e.RowIndex].Cells[0].Value);
            var     item  = dbe.userAccount.Where(a => a.Account_No == accno).FirstOrDefault();

            acctxt.Text     = item.Account_No.ToString();
            nametxt.Text    = item.Name;
            phonetxt.Text   = item.PhoneNo;
            addresstxt.Text = item.Address;
            byte[]       img = item.Picture;
            MemoryStream mss = new MemoryStream(img);

            pictureBox1.Image       = Image.FromStream(mss);
            disttxt.Text            = item.District;
            comboBox1.Text          = item.State;
            dataGridView1.ForeColor = Color.Black;
            this.dataGridView1.DefaultCellStyle.ForeColor = Color.White; this.dataGridView1.DefaultCellStyle.BackColor = Color.White;
            //다른 셀 스타일 속성이 설정되어 있지 않은 경우 DataGridView의 셀에 적용할 기본 셀 스타일을 가져오거나 설정합니다.
            //this.dataGridView1.DefaultCellStyle.Font = new Font("Tahoma", 15);
            //this.dataGridView1.DefaultCellStyle.ForeColor = Color.Black;
            if (item.Gender == "male")
            {
                maleradio.Checked = true;
            }
            else if (item.Gender == "female")
            {
                famaeradio.Checked = true;
            }
            if (item.maritial_status == "married")
            {
                maleradio.Checked = true;
            }
            else if (item.maritial_status == "unmarried")
            {
                unmarriedradio.Checked = true;
            }
        }
예제 #16
0
        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");
            }
        }
예제 #17
0
        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");
                }
            }
        }