public static AbstractAccount GetAccountFromDB(string accountNumber)
{
string sql = "SELECT idCustomer,idAccount,amount, type, isDebitAuthorized, creationDate, ceiling, overdraft,savingsRate " +
"FROM [Account] WHERE accountNumber = @accountNumber";
SqlCommand cmd = new SqlCommand();
cmd.Connection = GetConnexion;
cmd.CommandText = sql;
cmd.Parameters.Add(new SqlParameter("@accountNumber", accountNumber));
int idCustomer = 0;
int idAccount = 0;
decimal amount = 0;
string type = "";
bool isDebitAuthorized = true;
decimal ceiling = 0;
decimal overdraft = 0;
decimal savingsRate = 0;
DateTime creationDate = new DateTime();
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
idCustomer = reader.GetInt32(reader.GetOrdinal("idCustomer"));
idAccount = reader.GetInt32(reader.GetOrdinal("idAccount"));
amount = reader.GetDecimal(reader.GetOrdinal("amount"));
type = reader.GetString(reader.GetOrdinal("type"));
isDebitAuthorized = reader.GetBoolean(reader.GetOrdinal("isDebitAuthorized"));
creationDate = reader.GetDateTime(reader.GetOrdinal("creationDate"));
ceiling = reader.GetDecimal(reader.GetOrdinal("ceiling"));
overdraft = reader.GetDecimal(reader.GetOrdinal("overdraft"));
savingsRate = reader.GetDecimal(reader.GetOrdinal("savingsRate"));
}
}
AbstractAccount resultAccount = AccountFactory.Create(type);
resultAccount.AccountNumber = accountNumber;
resultAccount.Amount = amount;
resultAccount.CreationDate = creationDate;
resultAccount.IdAccount = idAccount;
resultAccount.IdCustomer = idCustomer;
resultAccount.IsDebitAuthorized = isDebitAuthorized;
resultAccount.Ceiling = ceiling;
resultAccount.Overdraft = overdraft;
resultAccount.SavingsRate = savingsRate;
return(resultAccount);
}
public static List <AbstractAccount> GetAccountsCustomer(int idCustomer)
{
string sql = " SELECT[idAccount],[idCustomer],[accountNumber],[amount],[type],[isDebitAuthorized],[creationDate], [ceiling], [overdraft], [savingsRate] FROM Account " +
"WHERE idCustomer = @idCustomer";
SqlCommand cmd = new SqlCommand();
cmd.Connection = GetConnexion;
cmd.CommandText = sql;
cmd.Parameters.Add(new SqlParameter("@idCustomer", idCustomer));
List <AbstractAccount> ListAccountsCustomer = new List <AbstractAccount>();
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
string typeAccount = reader.GetString(reader.GetOrdinal("type"));;
AbstractAccount currentCustomerAccount = AccountFactory.Create(typeAccount);
currentCustomerAccount.IdAccount = reader.GetInt32(reader.GetOrdinal("idAccount"));
currentCustomerAccount.IdCustomer = reader.GetInt32(reader.GetOrdinal("idCustomer"));
currentCustomerAccount.AccountNumber = reader.GetString(reader.GetOrdinal("accountNumber"));
currentCustomerAccount.Amount = reader.GetDecimal(reader.GetOrdinal("amount"));
currentCustomerAccount.IsDebitAuthorized = reader.GetBoolean(reader.GetOrdinal("isDebitAuthorized"));
currentCustomerAccount.CreationDate = reader.GetDateTime(reader.GetOrdinal("creationDate"));
currentCustomerAccount.Ceiling = reader.GetDecimal(reader.GetOrdinal("ceiling"));
currentCustomerAccount.Overdraft = reader.GetDecimal(reader.GetOrdinal("overdraft"));
currentCustomerAccount.SavingsRate = reader.GetDecimal(reader.GetOrdinal("savingsRate"));
ListAccountsCustomer.Add(currentCustomerAccount);
}
}
return(ListAccountsCustomer);
}
}
