Project Name: Online Bank Management Software and web apps for Greenrose Bank ltd. Introduction

Project Name: Online Bank Management Software and web apps for Greenrose Bank LTD.

Introduction:This is a online bank management software for a bank .I choose this type of software

because there are many essential feature that’s I added in my software. In doing my task , I faced many

new challenges as a developer . I try as my best to do this project. This project has divided in two part .

1. 
   For Official purpose, it has created C# .NET Framework another is,
   
2. 
   For User/Clint site , it has created ASP .NET which a clint want to get any transaction from home in online.
   

I describe my feature and sample input in below.

Sample inputs that help run my project:

For kind information, my database name is “ban info”.

1. 
   For Open my software project Username: zahid492
   

Password: zahid492

For enter admin panel Username: manager

Password: manager

Sample account no is 10001 to 10009. If you want any operation within those account No.

2. 
   For enter my personal account in website Username:zahid3
   

Password:zahid3@@@

Or,

Username:zahid4

Password:zahid4@@@

Feature:

1.Login Form: At first ,in my project ,if a officer or clark want to inside my software ,they have must be verified .For that reason there is a login panel that a clark or officer put there Username and Password, if the password match with database table “tbl_login” ,he/she goes to the main user interface.

2. 
   New Signup Page: If a officer have new join in bank, they should be also access the bank software as other officer or Clark. So a new officer should be fill up some information and match all information in “tbl_login” in my database.
   

3. Main Interface: This is the main window of my software. Here are many feature like as crate account, credit balance, debit balance, money transfer, balance check of a client, getting information for new loan, admin panel which support our day end summary or get any type of information, send client mail for alert, create new banking card, convert currency from one country to other country using web service in C# finally get a statement of a client by using crystal report.



4. Create New Account: It supports to hold all information in a new account holder. It also contain client own picture and his signature to security purpose. Signature is important, when a client credit any type of amount from bank via any person then officer check his signature. After completing store all information in “basicinfo” table in my database, it sends a client email that it succeeds to create account successfully and send all necessary thing.



5. Credit Amount: In this portion, I used to credit any type of amount from a client which can credit above 500 BDT and checked after credited his/her balance could not below in 1000 BDT. And I check his/her name in auto search option with help in “account textbox _changed” event and also check his/her signature that he/she is correct person or not , I also used sqltransaction function to overcome in deadlock. Save all information in “tbl_credit” table with date and time.



6. Debit Amount: In this portion, I used to debit any type of amount from a client which can debit any amount above 500. And I check his/her name in auto search option with help in “account_textbox _changed”, I also used “sqltransaction “function to overcome in deadlock. Save all information in “tbl_debit” table with date and time.



7.Transfer Amount: In this section ,I used to transfer any type of amount from a client to another client which can transfer above 500 and checked that after credited his/her balance could not below in 1000. And I check their name in auto search option with help in “account_textbox _changed” event and I also used “sqltransaction “function to overcome in deadlock. Finally I update their current balance and store credit and debit amount in “tbl_credit” and “tbl_debit” table as respectively .



8. Balance Check: If a user comes from officer to know his/her current balance information, the officer used in window to show all of his current information. I used “datagridview” to view all information.



9. Loan Management: Loan Management is the most important thing of a bank, in this chapter at first check that if you have any account in this bank, if there is no account then go to new create account form and if there are account then goes to select an option that what type of loan you need, after select an item then goes to those type of loan criteria. Input the amount you need to loan and get how about your month required to payment all loan amount, it calculate the total loan amount would be paid and

Calculate monthly installment charge in rule of basic interest law .And finally store all information in “tbl_loan” table in my “bankinfo” databsase.

Figure: Housing loan.



Figure: Education loan.

10. Generating Bank Card: Online bank card is so important in our daily life, in this section officer can create any type of banking card like as master card, ATM card, Credit card etc. Card serial number and pin no auto generated in randomly, after finally the pin no send in client email that it is most secure thing all others thing. And finally all information store in “tbl_card” table.



11. Admin Panel: In this site can only visited in manager of a particular bank, so a login panel has just create in this section that check the correct manager and password is match or not. After successfully login, we see there are many option. We know day end transaction or know transaction occur even in particular date end. We also see a “Update all current balance with interest” ,this button helps us to add interest of client after 15 days interleaved by law of accounting.



12. Currency conversion: Now a days, a bank is not only money transaction with related to current account, saving account, loan etc. They also support as a money exchanger or like as a broker. In this interface, it helps the currency from one country is converted to other country as officers want. I used web service, which request to the server as officers want and the sever get output as current currency rate of those nation. It supports above 160 nation money transaction.



13.Send Client Mail: I support send mail via in my user interface, that a Clark/officer not go to frequently in Gmail, yahoo etc to send alert or any type of information among clients.



13. Statement: Bank statement is the most important thing of a online banking, in daily life we need bank statement to get any buissness task,want to higher study in abroad etc.I used in dataset to create this feature.And finally connect the dataset into crystal report to show some basic information and credit information.

I also develop a web developing site that a user/client handle his/her account and get any type of transaction via in online. I used ASP .NET to develop this. Now I describe my project details.

1. 
   Front Page: My front page is given below. Here is a login panel that a specific person which holds account in this bank can only access this panel. If a client has no user account in before, he/she also open the account, for he goes to sign up page.
   

2.Sign Up page: Each sign up page has two part ,one page gets all information like as account no,name,pin no, serial no ,if all given information match in my database they can be access next page in showing step 2 .

Step 1:



Step 2:



3.Profile: Assume that, a client successfully login their account, in front page I get all necessary information of his/her .There are few menu where a client to do his/her transaction efficiently and easily. The screenshot has given below.



4. Transfer: A client want to be balance transfer at home, not goes to the bank as traditionally. They give account no and it search the account no is exist or not. If account no exists his/her name put in name textbox. Assume that, account no is valid then he put amount that he want to be transfer ,card serial no, pin no if all information match in my database ,I permit this transaction. The amount is must be below in 20000.



5. Inbox: Inbox is a procedure in stored email. When the bank gets any type of information via in mail, sometimes it was not notice. But my site i create an interface that he can see all messages which already sent from bank.



6. Mobile Banking: It’s my dream project, I cannot do this task at now but one day I can do inshallah.

My Idea: In my website there shall be an option to credit amount from my account. For that reason he/she request the bank to draw credited money. If he/she send correct information like as name, card serial and pin no, then the server accept his/her request to draw money. At mean time, he get an email with redirect link .If he goes to her email and click the link after few moment he receive an message in his/her mobile which store in bank database and also receive a serial key no. And finally he should be go to any Bkash, Pay point or nearest mobile recharge center and give the serial code , if the serial code is match in database then he can money or not . One rule must be followed that transaction will be complete within 30 minutes. After 30 minutes the serial code will be invalid. There is much security level for this purpose so that any cannot cheat with us.

7. Loan estimate Calculator: It is open for all to calculate loan amount of given month and finally give output his total payable loan amount and monthly installment charge.

There are many options in my site; I only describe important option in my site.

I already describe my whole project details ,if my project is efficient or interest with you, Please reply me, I am so much interest this internship. I will take a chance for showing my creativity.

Thanks

Mohammad Zahidur rahman

RUET,Rajshahi