public CarteBancaire(int id, int numero, DateTime dateExpi, int crypto, TypeCarte type, Banque hisBank)
{
bankCardId = id;
number = numero;
experationDate = dateExpi;
cryctogramme = crypto;
typeCard = type;
banque = hisBank;
}
public static void Insert(TypeCarte typeCarte)
{
SqlCommand cmd = new SqlCommand();
const string query = "INSERT INTO TYPE_CARTE VALUES ('{0}','{1}')";
cmd.CommandText = string.Format(query, GenerateId().ToString(), typeCarte.CardName);
cmd.CommandType = CommandType.Text;
cmd.Connection = BDDConnexion.Conn;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw (e);
}
finally
{
cmd.Dispose();
cmd = null;
}
}
public static void Update(TypeCarte typeCarte)
{
SqlCommand cmd = new SqlCommand();
const string query = "UPDATE TYPE_CARTE set NOM = '{0}' where ID_TYPE_CARTE='{1}'";
cmd.CommandText = string.Format(query, typeCarte.CardName,typeCarte.CardTypeId.ToString());
cmd.CommandType = CommandType.Text;
cmd.Connection = BDDConnexion.Conn;
try
{
// pour créer une trasaction SqlTransaction req_trans;
// commencer la transaction req_trans = BDDConnexion.Conn.BeginTransaction();
// arrete une transaction et la valider req_trans.Commit();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw (e);
}
finally
{
cmd.Dispose();
cmd = null;
}
}
public string NewTypeCarte(int idAdmin, string nameCard)
{
string msg = string.Empty;
try
{
Administrateur adminDB = AdministrateurDAO.Read(idAdmin);
if (adminDB == null)
throw new Exception ("Authentification impossible: les identifiants sont incorrects.");
else
{
List<TypeCarte> typeCarteDB = TypeCarteDAO.Search("NOM = '" + nameCard + "'");
if (typeCarteDB.Any())
throw new Exception ("Action impossible. Le type de carte " + nameCard + " est déjà présent dans la base.");
else
{
TypeCarte newType = new TypeCarte(nameCard);
TypeCarteDAO.Insert(newType);
msg = "Le type de carte " + nameCard + " a été ajouté dans la base.";
}
}
BDDConnexion.CloseConnection();
}
catch (Exception ex)
{
msg = ex.Message;
}
return msg;
}
private static List<TypeCarte> ExecuteReader(SqlCommand cmd)
{
SqlDataReader reader;
List<TypeCarte> result = new List<TypeCarte> ();
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
TypeCarte currentTypeCard = new TypeCarte(Convert.ToInt32(reader["ID_TYPE_CARTE"]), reader["NOM"].ToString());
result.Add(currentTypeCard);
}
}
catch (Exception e)
{
throw (e);
}
reader.Close();
reader.Dispose();
reader = null;
return result;
}