4
Answers

C# for making Transactions with Microsoft SQL Server DB

Photo of Abwaank Khaliif

Abwaank Khaliif

13y
4.7k
1
first Thanks to all C-sharpcorner members.

i would like to develop a banking system using ASP.NET 3.5 with C# as front end and MS SQL Server 2008 as Back end, so, i need the members of this great forum to help me in view point like
  1- Database Tables like 
         a - Customer Table
         b - Deposits
         c - Withdrawals
         d - Transfers
  2- Tables relationships
  3- Complex stored procedures for the Bank Transactions
  4- and many more on the subject as can.

my Emails are:
abwaanka99@hotmail.com
abwaanka99@gmail.com
abwaanka99@yahoo.com

specially Mr. Mahesh Chand, please contribute me some of your valuable time to prepare this project, and email me one of the above mentioned email.

thanks

Answers (4)

0
Photo of Rahul Kaushik
NA 383 14.6k 7y
There is a perfect way while using flag to detect whether someone is already logged in or not and in case if System get power off , you need an event handler called as SystemEvents.SessionEnds.
 
Use this to change the flag value from true to false
 
Use this link as a reference
https://stackoverflow.com/questions/6799955/how-to-detect-windows-shutdown-or-logoff 
0
Photo of Mann Maurya
NA 47 869 7y
Hey Ajeesh
 
one more question... ??
 
If power off happen then how you suppose to Reset the flag
 
0
Photo of Ajeesh
NA 349 1.6k 7y
You can take a look at this article which discuss a similar topic. 
 
https://blog.learningtree.com/preventing-duplicate-logins-in-asp-net/
 
Another option would be to have a flag in your table and set the value to true when an user login and when user log off set the value to false.  Also for when a second user tries to login we will first check if login flag has been set to true for any other user. If its true then show message to user and display the login page, if not allow the user to login.