public void Interest(EmpFields emp)
{
Console.Write("Enter your Id : ");
emp.AccId = Convert.ToInt32(Console.ReadLine());
result = Search(emp.AccId, con);
string[] tokens = result.Split(',');
balance = Convert.ToInt32(tokens[0]);
if (balance < 0)
{
Console.WriteLine(" No record found with this Account Id. Please try again....");
}
else
{
AccType = tokens[1];
char[] ch = AccType.ToCharArray();
AccType = ch[0] + "";
float simpleInterest = 0;
if (AccType == "s")
{
simpleInterest = (balance * 4 * 1) / 100;
Console.WriteLine("Interest is: {0} Rs per Year", simpleInterest);
}
else if (AccType == "c")
{
simpleInterest = (balance * 1 * 1) / 100;
Console.WriteLine("Interest is: {0} Rs per Year", simpleInterest);
}
else
{
Console.WriteLine("Interest cannot be appliet on DMAT's Account");
}
}
}
public void Withdraw(EmpFields emp)
{
//int bal = emp.balance;
Console.Write("Enter your Id : ");
emp.AccId = Convert.ToInt32(Console.ReadLine());
result = Search(emp.AccId, con);
string[] tokens = result.Split(',');
balance = Convert.ToInt32(tokens[0]);
if (balance < 0)
{
Console.WriteLine(" No record found with this Account Id. Please try again....");
}
else
{
Console.WriteLine("Your available balance is : {0}", balance);
AccType = tokens[1];
char[] ch = AccType.ToCharArray();
AccType = ch[0] + "";
Console.WriteLine("Enter the amount you want to withdraw ");
int draw = Convert.ToInt32(Console.ReadLine());
if (AccType == "s")
{
if ((balance - draw) < 1000)
{
Console.WriteLine("Minimum Balance in savings account must be 1000 Rs. Please withdraw some less amount.");
}
else
{
balance = balance - draw;
}
}
else if (AccType == "c")
{
if ((balance - draw) < 0)
{
Console.WriteLine("Minimum Balance in current account must be 0 Rs. Please withdraw some less amount.");
}
else
{
balance = balance - draw;
}
}
else
{
if ((balance - draw) < -10000)
{
Console.WriteLine("Minimum Balance in current account must be -10000 Rs. Please withdraw some less amount.");
}
else
{
balance = balance - draw;
}
}
}
Update(balance, con, emp.AccId);
}
public void OpenAcc(EmpFields emp)
{
Console.WriteLine("Enter Name & Account Type (savings |current | DMAT) :");
emp.name = Console.ReadLine();
emp.AccType = Console.ReadLine();
Console.WriteLine("Enter starting balance :");
emp.balance = Convert.ToInt32(Console.ReadLine());
emp.AccId = Convert.ToInt32(GetNumber());
InsertInto(emp, con);
}
public void Deposit(EmpFields emp)
{
Console.Write("Enter your Account Id : ");
emp.AccId = Convert.ToInt32(Console.ReadLine());
result = Search(emp.AccId, con);
string[] tokens = result.Split(',');
balance = Convert.ToInt32(tokens[0]);
if (balance < 0)
{
Console.WriteLine(" No record found with this Account Id. Please try again....");
}
else
{
Console.WriteLine("Enter the amount you want to deposit ");
int depo = Convert.ToInt32(Console.ReadLine());
balance = balance + depo;
Update(balance, con, emp.AccId);
}
}
public void InsertInto(EmpFields emp, SqlConnection con)
{
// employee employe = new employee();
try
{
string s = "insert into employee(id , name , balance , accountType) values(@p1,@p2,@p3,@p4)";
cmd = new SqlCommand(s, con);
cmd.Parameters.AddWithValue("@p1", emp.AccId);
cmd.Parameters.AddWithValue("@p2", emp.name);
cmd.Parameters.AddWithValue("@p3", emp.balance);
cmd.Parameters.AddWithValue("@p4", emp.AccType);
int i = cmd.ExecuteNonQuery();
Console.ForegroundColor = ConsoleColor.DarkYellow;
Console.WriteLine("Your {0} Account is created with AccountID : {1}", emp.AccType, (55020600 + count));
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void Insert(EmpFields emp)
{
}
public void GetDetails(EmpFields emp)
{
Console.Write("Enter your Id : ");
emp.AccId = Convert.ToInt32(Console.ReadLine());
Display(emp.AccId, con);
}
public static void Main()
{
bool cont = true;
while (cont)
{
Console.WriteLine("Which Framework You want to use:\n1 for ADO.Net \n2 for Entity Framework");
int framework = Convert.ToInt32(Console.ReadLine());
if (framework == 1)
{
EmpFields emp = new EmpFields();
AccountHandling accounts = new AccountHandling();
con = accounts.Connect();
top:
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Enter \n 1 To Open new account \n 2 To Display account details \n 3 To Withdraw some amount \n 4 To Deposit money \n 5 To check Interest ");
int choice = Convert.ToInt32(Console.ReadLine());
if (choice == 1)
{
accounts.OpenAcc(emp);
}
else if (choice == 2)
{
accounts.GetDetails(emp);
}
else if (choice == 3)
{
accounts.Withdraw(emp);
}
else if (choice == 4)
{
accounts.Deposit(emp);
}
else if (choice == 5)
{
accounts.Interest(emp);
}
else
{
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine("You Entered wrong input. Please Try again...");
goto top;
}
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Do You want to Continue : Y or N ");
char ch = Convert.ToChar(Console.ReadLine());
ch = Char.ToUpper(ch);
if (ch == 'Y')
{
goto top;
}
}
else if (framework == 2)
{
employee emp = new employee();
AccountHandlingByEntity accounts = new AccountHandlingByEntity();
con = accounts.Connect();
top:
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Enter \n 1 To Open new account \n 2 To Display account details \n 3 To Withdraw some amount \n 4 To Deposit money \n 5 To check Interest ");
int choice = Convert.ToInt32(Console.ReadLine());
if (choice == 1)
{
accounts.OpenAcc(emp);
}
else if (choice == 2)
{
accounts.GetDetails(emp);
}
else if (choice == 3)
{
accounts.Withdraw(emp);
}
else if (choice == 4)
{
accounts.Deposit(emp);
}
else if (choice == 5)
{
accounts.Interest(emp);
}
else
{
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("You Entered wrong input. Please Try again...");
goto top;
}
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Do You want to Continue : Y or N ");
char ch = Convert.ToChar(Console.ReadLine());
ch = Char.ToUpper(ch);
if (ch == 'Y')
{
goto top;
}
}
else
{
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Wrong Input. Please try again....");
}
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Do You want to Switch Framework : Y or N ");
char ch1 = Convert.ToChar(Console.ReadLine());
ch1 = Char.ToUpper(ch1);
if (ch1 != 'Y')
{
cont = false;
}
}
}