public string General_DepositoCuenta(string cedula, string account_name, decimal balance_to_deposit)
{
try
{
//Prove Account has Funds
accountTableTableAdapter adapterAccount = new accountTableTableAdapter();
accountTableDataTable accountDataTable = new accountTableDataTable();
adapterAccount.FillByCedula_Account(accountDataTable, cedula);
//Create Account
Account tempAccount = new Account();
//Transfer Data to Local Object
foreach (accountTableRow row in accountDataTable.Rows)
{
tempAccount.Client_ID = row.IDENTIFIER;
tempAccount.Account_Name = row.ACCOUNT_NAME;
tempAccount.Account_State = row.ACCOUNT_STATE;
tempAccount.Account_Type = row.ACCOUNT_TYPE;
tempAccount.Balance = row.BALANCE;
}
//Calculo de balances
decimal balance_actual = 0;
balance_actual += tempAccount.Balance;
balance_actual += balance_to_deposit;
adapterAccount.DepositoCuenta_Normal(balance_actual, cedula, account_name);
return("El deposito fue exitoso");
}
catch
{
return("Datos Erroneos");
}
}
public Client General_Consulta_Cliente(string cedula)
{
//CREAR OBJETO VACIO
Client objClient = new Client();
List <Account> listAccounts = new List <Account>();
//GET DATOS_EN_clientTable
clientTableTableAdapter adapterClient = new clientTableTableAdapter();
clientTableDataTable clientDataTable = new clientTableDataTable();
adapterClient.FillByCedula_Cliente(clientDataTable, cedula);
//GET DATOS_EN_accountTable
accountTableTableAdapter adapterAccount = new accountTableTableAdapter();
accountTableDataTable accountDataTable = new accountTableDataTable();
adapterAccount.FillByCedula_Account(accountDataTable, cedula);
//Transferir datos de clientTable a ObjClient
foreach (clientTableRow row in clientDataTable.Rows)
{
Client tempClient = new Client();
objClient.Name = row.NAME;
objClient.Last_Name = row.LAST;
objClient.ID_Number = row.IDENTIFIER;
objClient.Email = row.EMAIL;
objClient.Client_State = row.STATE;
objClient.Direction = row.DIRECTION;
objClient.Pin = row.PIN;
objClient.Password = row.PASSWORD;
objClient.Number_Of_Accounts = row.ACCOUNTS;
}
//Transferir datos de clientTable a ObjClient
foreach (accountTableRow row in accountDataTable.Rows)
{
Account tempAccount = new Account();
tempAccount.Client_ID = row.IDENTIFIER;
tempAccount.Account_Name = row.ACCOUNT_NAME;
tempAccount.Account_State = row.ACCOUNT_STATE;
tempAccount.Account_Type = row.ACCOUNT_TYPE;
tempAccount.Balance = row.BALANCE;
}
objClient.Accounts = listAccounts;
return(objClient);
}
public List <Account> General_Devolver_ListCuenta(string Cedula)
{
List <Account> listAccount = new List <Account>();
accountTableTableAdapter adapterAccount = new accountTableTableAdapter();
accountTableDataTable accountDataTable = new accountTableDataTable();
adapterAccount.FillByCedula_Account(accountDataTable, Cedula);
//Transferir datos de clientTable a ObjClient
foreach (accountTableRow row in accountDataTable.Rows)
{
Account tempAccount = new Account();
tempAccount.Client_ID = row.IDENTIFIER;
tempAccount.Account_Name = row.ACCOUNT_NAME;
tempAccount.Account_State = row.ACCOUNT_STATE;
tempAccount.Account_Type = row.ACCOUNT_TYPE;
tempAccount.Balance = row.BALANCE;
listAccount.Add(tempAccount);
}
return(listAccount);
}
public string General_RetiroCuenta(string cedula, string account_name, decimal balance_to_withdraw)
{
try
{
//Prove Account has Funds
accountTableTableAdapter adapterAccount = new accountTableTableAdapter();
accountTableDataTable accountDataTable = new accountTableDataTable();
adapterAccount.FillByCedula_Account(accountDataTable, cedula);
//Create Account
Account tempAccount = new Account();
//Transfer Data to Local Object
foreach (accountTableRow row in accountDataTable.Rows)
{
tempAccount.Client_ID = row.IDENTIFIER;
tempAccount.Account_Name = row.ACCOUNT_NAME;
tempAccount.Account_State = row.ACCOUNT_STATE;
tempAccount.Account_Type = row.ACCOUNT_TYPE;
tempAccount.Balance = row.BALANCE;
}
//Calculo de balances
decimal Balance_Actual = tempAccount.Balance;
if (Balance_Actual > balance_to_withdraw)
{
decimal balance_despuesDeRetiro = 0;
balance_despuesDeRetiro = Balance_Actual - balance_to_withdraw;
adapterAccount.DepositoCuenta_Normal(balance_despuesDeRetiro, cedula, account_name);
return("Retiro Exitoso!");
}
else
{
return("Fondos insuficientes");
}
}
catch
{
return("Datos Erroneos");
}
}
