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; }