public double AccountInterest(int AccNum)
{
try
{
BankDatabaseEntities bankDatabaseEntities = new BankDatabaseEntities();
int bal = bankDatabaseEntities.AccountDetails.Find(AccNum).Balance;
string AccType = bankDatabaseEntities.AccountDetails.Find(AccNum).AccountType;
AccType = AccType.Trim();
double interest;
if (AccType == "Current")
{
interest = (double)bal * 1.0 / 100.0;
}
else if (AccType == "Savings")
{
interest = (double)bal * 4.0 / 100.0;
}
else
{
interest = 0;
}
return(interest);
}
catch (Exception e)
{
return(-10001);
}
}
public int WithdrawingAmount(int AccNum, int Amount)
{
try
{
BankDatabaseEntities bankDatabaseEntities = new BankDatabaseEntities();
int bal = bankDatabaseEntities.AccountDetails.Find(AccNum).Balance;
String AccType = bankDatabaseEntities.AccountDetails.Find(AccNum).AccountType;
AccType = AccType.Trim();
if (AccType == "Current")
{
if (bal - Amount >= 0)
{
bal = bal - Amount;
}
else
{
return(-10000);
}
}
else if (AccType == "Savings")
{
if (bal - Amount >= 1000)
{
bal = bal - Amount;
}
else
{
return(-10000);
}
}
else
{
if (bal - Amount >= -1000)
{
bal = bal - Amount;
}
else
{
return(-10000);
}
}
bankDatabaseEntities.AccountDetails.Find(AccNum).Balance = bal;
bankDatabaseEntities.SaveChanges();
return(bal);
}
catch (Exception e)
{
return(-10001);
}
}
public int DepositingAmount(int AccNum, int Amount)
{
try
{
BankDatabaseEntities bankDatabaseEntities = new BankDatabaseEntities();
int bal = bankDatabaseEntities.AccountDetails.Find(AccNum).Balance;
bal = bal + Amount;
bankDatabaseEntities.AccountDetails.Find(AccNum).Balance = bal;
bankDatabaseEntities.SaveChanges();
return(bal);
}
catch (Exception e)
{
return(-10001);
}
}
public BankEntities getAccountDetails(int AccNum)
{
try
{
BankDatabaseEntities bankDatabaseEntities = new BankDatabaseEntities();
BankEntities EntityObject = new BankEntities();
EntityObject.AccountNumber = bankDatabaseEntities.AccountDetails.Find(AccNum).AccountNumber;
EntityObject.AccountBalance = bankDatabaseEntities.AccountDetails.Find(AccNum).Balance;
EntityObject.BranchName = bankDatabaseEntities.AccountDetails.Find(AccNum).BranchName;
EntityObject.AccountType = bankDatabaseEntities.AccountDetails.Find(AccNum).AccountType;
return(EntityObject);
}
catch (Exception e)
{
return(null);
}
}
public int AddingAccount(BankEntities FieldsObject)
{
try
{
BankDatabaseEntities bankDatabaseEntities = new BankDatabaseEntities();
AccountDetail accountDetail = new AccountDetail();
accountDetail.AccountNumber = FieldsObject.AccountNumber;
accountDetail.Balance = FieldsObject.AccountBalance;
accountDetail.BranchName = FieldsObject.BranchName;
accountDetail.AccountType = FieldsObject.AccountType;
bankDatabaseEntities.AccountDetails.Add(accountDetail);
bankDatabaseEntities.SaveChanges();
return(1);
}
catch (Exception e)
{
//Console.WriteLine(e.Message);
return(-10000);
}
}
public BankEntities[] DisplayAllDetails()
{
BankDatabaseEntities bankDatabaseEntities = new BankDatabaseEntities();
List <AccountDetail> list = new List <AccountDetail>();
list = bankDatabaseEntities.AccountDetails.ToList();
BankEntities[] EntityArray = new BankEntities[100];
int counter = 0;
foreach (AccountDetail accountDetailObject in list)
{
BankEntities bankEntities = new BankEntities();
bankEntities.AccountNumber = accountDetailObject.AccountNumber;
bankEntities.AccountBalance = accountDetailObject.Balance;
bankEntities.BranchName = accountDetailObject.BranchName;
bankEntities.AccountType = accountDetailObject.AccountType;
EntityArray[counter] = bankEntities;
counter++;
}
return(EntityArray);
}