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 String AddCarteForClient(int idClient, int numero, string dateExpi, int crypto, string typeCarte, string hisBank)
{
try
{
Client client = ClientDAO.Read(idClient);
if (client == null || client.IsDelete)
throw new Exception("Le client n'existe pas");
DateTime dateExpiration;
if (!DateTime.TryParse(dateExpi, out dateExpiration))
throw new Exception("La date rentrée est invalide");
List<TypeCarte> currentTypeCarte = TypeCarteDAO.Search("NOM='" + typeCarte + "'");
if (!currentTypeCarte.Any())
throw new Exception ("Le type de carte n'existe pas");
List<Banque> currentBank = BanqueDAO.Search("NOM='" + hisBank + "'");
if (!currentBank.Any())
throw new Exception ("La banque n'existe pas");
List<CarteBancaire> CarteBancaireDB = CarteBancaireDAO.Search("NUMERO = '" + numero.ToString() + "' AND DATE_EXPIRATION ='"
+ dateExpiration.ToShortDateString() + "' AND CRYPTOGRAMME='" + crypto.ToString() + "' AND ID_TYPE_CARTE='" + currentTypeCarte.FirstOrDefault().CardTypeId +
"' AND ID_BANQUE='" + currentBank.FirstOrDefault().BankId + "'");
if (CarteBancaireDB.Any())
throw new Exception ("La carte bancaire est déjà enregistrée");
CarteBancaire newCarteBancaire = new CarteBancaire(numero, dateExpiration, crypto, currentTypeCarte.FirstOrDefault(), currentBank.FirstOrDefault());
CarteBancaireDAO.Insert(newCarteBancaire);
ClientCarteBancaire.LinkClientAndCarteBancaire(client, newCarteBancaire);
BDDConnexion.CloseConnection();
}
catch(Exception ex)
{
return ex.Message;
}
return "La carte a été ajouté avec succès";
}
public static void Insert(CarteBancaire carteBancaire)
{
SqlCommand cmd = new SqlCommand();
const string query = "INSERT INTO CARTE_BANCAIRE VALUES ('{0}','{1}','{2}','{3}','{4}','{5}')";
cmd.CommandText = string.Format(query,carteBancaire.BankCardId.ToString(), carteBancaire.Number.ToString(), carteBancaire.ExperationDate.ToShortDateString()
, carteBancaire.Cryctogramme, carteBancaire.TypeCard.CardTypeId, carteBancaire.Banque.BankId);
cmd.CommandType = CommandType.Text;
cmd.Connection = BDDConnexion.Conn;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw (e);
}
finally
{
cmd.Dispose();
cmd = null;
}
}
private static List<CarteBancaire> ExecuteReader(SqlCommand cmd)
{
SqlDataReader reader;
List<CarteBancaire> result = new List<CarteBancaire>();
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
CarteBancaire currentBankCard = new CarteBancaire(Convert.ToInt32(reader["ID_CARTE_BANCAIRE"]), Convert.ToInt32(reader["NUMERO"])
, DateTime.Parse(reader["DATE_EXPIRATION"].ToString()), Convert.ToInt32(reader["CRYPTOGRAMME"])
, TypeCarteDAO.Read(Convert.ToInt32(reader["ID_TYPE_CARTE"])), BanqueDAO.Read(Convert.ToInt32(reader["ID_BANQUE"])));
result.Add(currentBankCard);
}
}
catch (Exception e)
{
throw (e);
}
reader.Close();
reader.Dispose();
reader = null;
return result;
}
public ClientCarteBancaire(Client cli, CarteBancaire bankcard)
{
client = cli;
bankCard = bankcard;
}