private static List<ClientCarteBancaire> ExecuteReader(SqlCommand cmd)
{
SqlDataReader reader;
List<ClientCarteBancaire> result = new List<ClientCarteBancaire>();
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
ClientCarteBancaire currentClientCarteBancaire = new ClientCarteBancaire(
ClientDAO.Read(Convert.ToInt32(reader["ID_CLIENT"])), CarteBancaireDAO.Read(Convert.ToInt32(reader["ID_CARTE_BANCAIRE"])));
result.Add(currentClientCarteBancaire);
}
}
catch (Exception e)
{
throw (e);
}
reader.Close();
reader.Dispose();
reader = null;
return result;
}
public static bool LinkClientAndCarteBancaire(Client currentClient, CarteBancaire currentCard)
{
List<ClientCarteBancaire> clientCarteBancaireDB = ClientCarteBancaireDAO.Search("ID_CLIENT='" + currentClient.ClientId + "' AND ID_CARTE_BANCAIRE = '" + currentCard.BankCardId + "'");
if (clientCarteBancaireDB.Any())
return false;
ClientCarteBancaire newCarte = new ClientCarteBancaire(currentClient, currentCard);
ClientCarteBancaireDAO.Insert(newCarte);
return true;
}
public static void Insert(ClientCarteBancaire clientCarteBancaire)
{
SqlCommand cmd = new SqlCommand();
const string query = "INSERT INTO CLIENT_CARTE_BANCAIRE VALUES ('{0}','{1}')";
cmd.CommandText = string.Format(query, clientCarteBancaire.Client.ClientId.ToString()
, clientCarteBancaire.BankCard.BankCardId.ToString());
cmd.CommandType = CommandType.Text;
cmd.Connection = BDDConnexion.Conn;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw (e);
}
finally
{
cmd.Dispose();
cmd = null;
}
}