public static void LoadDataBases() { string server1 = Util.settings.ContainsKey("LOCAL.SERVER") && Util.settings["LOCAL.SERVER"].Trim() != "" ? "Data Source=" + Util.settings["LOCAL.SERVER"] : ""; string port1 = Util.settings.ContainsKey("LOCAL.PORT") && Util.settings["LOCAL.PORT"].Trim() != "" ? "," + Util.settings["LOCAL.PORT"] : ""; string database1 = Util.settings.ContainsKey("LOCAL.DATABASE") && Util.settings["LOCAL.DATABASE"].Trim() != "" ? "Database=" + Util.settings["LOCAL.DATABASE"] + ";" : ""; string user1 = Util.settings.ContainsKey("LOCAL.USER") && Util.settings["LOCAL.USER"].Trim() != "" ? "User Id=" + Util.settings["LOCAL.USER"] + ";" : ""; string password1 = Util.settings.ContainsKey("LOCAL.PASSWORD") && Util.settings["LOCAL.PASSWORD"].Trim() != "" ? "Password="******"LOCAL.PASSWORD"] + ";" : ""; string tipo1 = Util.settings.ContainsKey("LOCAL.TYPE") && Util.settings["LOCAL.TYPE"].Trim() != "" ? Util.settings["LOCAL.TYPE"].ToLower() : "sqlserver"; TypeBD t1 = TypeBD.MySql; if (tipo1 == "sqlserver") { t1 = TypeBD.SQLServer; } BDLocal = new BD(server1, port1, database1, user1, password1, t1); BDLocal.openDB(); string server2 = Util.settings.ContainsKey("SERVER.SERVER") && Util.settings["SERVER.SERVER"].Trim() != "" ? "Data Source=" + Util.settings["SERVER.SERVER"] : ""; string port2 = Util.settings.ContainsKey("SERVER.PORT") && Util.settings["SERVER.PORT"].Trim() != "" ? "," + Util.settings["SERVER.PORT"] : ""; string database2 = Util.settings.ContainsKey("SERVER.DATABASE") && Util.settings["SERVER.DATABASE"].Trim() != "" ? "Database=" + Util.settings["SERVER.DATABASE"] + ";" : ""; string user2 = Util.settings.ContainsKey("SERVER.USER") && Util.settings["SERVER.USER"].Trim() != "" ? "User Id=" + Util.settings["SERVER.USER"] + ";" : ""; string password2 = Util.settings.ContainsKey("SERVER.PASSWORD") && Util.settings["SERVER.PASSWORD"].Trim() != "" ? "Password="******"SERVER.PASSWORD"] + ";" : ""; string tipo2 = Util.settings.ContainsKey("SERVER.TYPE") && Util.settings["SERVER.TYPE"].Trim() != "" ? Util.settings["SERVER.TYPE"].ToLower() : "sqlserver"; TypeBD t2 = TypeBD.MySql; if (tipo2 == "sqlserver") { t2 = TypeBD.SQLServer; } BDServer = new BD(server2, port2, database2, user2, password2, t2); BDServer.openDB(); }
public void ActionAjouterOeuvre() { int choix; Ouvrage ouvrage = null; do { MenuTypeOuvrage(); choix = Convert.ToInt32(Console.ReadLine()); if (choix >= 1 && choix <= 3) { Console.Write("Merci de saisir le titre de l'oeuvre : "); string titre = Console.ReadLine(); Console.Write("Merci de saisir l'auteur de l'oeuvre : "); string auteur = Console.ReadLine(); Console.Write("Merci de saisir le prix : "); decimal prix = Convert.ToDecimal(Console.ReadLine()); switch (choix) { case 1: Console.Write("Merci de saisir la durée du film : "); int duree = Convert.ToInt32(Console.ReadLine()); ouvrage = new DVD(titre, auteur, prix, duree); break; case 2: Console.Write("Merci de saisir le nombre de page : "); int nombre = Convert.ToInt32(Console.ReadLine()); Console.Write("La BD est-elle couleur ou noir et blanc ? (0 => couleur, 1=> noir et blanc): "); TypeBD type = (TypeBD)Convert.ToInt32(Console.ReadLine()); ouvrage = new BD(titre, auteur, prix, nombre, type); break; case 3: Console.Write("Merci de saisir le nombre de page : "); int nombrePage = Convert.ToInt32(Console.ReadLine()); ouvrage = new Album(titre, auteur, prix, nombrePage); break; } if (ouvrage != null) { if (biblio.AjouterOuvrage(ouvrage)) { AfficherMessage("L'oeuvre a été ajoutée", ConsoleColor.Green); ouvrage = null; } else { AfficherMessage("Erreur d'ajout oeuvre", ConsoleColor.Red); } } } else if (choix != 0) { AfficherMessage("Merci de choisir une valeur entre 1 et 3", ConsoleColor.Red); } } while (choix != 0); }
public BD(string server, string port, string database, string user, string password, TypeBD type) { this.server = this.server.Trim() != "" ? "Data Source=" + this.server : ""; this.port = this.port.Trim() != "" ? "," + this.port : ""; this.database = this.database.Trim() != "" ? "Database=" + this.database + ";" : ""; this.user = this.user.Trim() != "" ? "User Id=" + this.user + ";" : ""; this.password = this.password.Trim() != "" ? "Password="******";" : ""; this.type = type; CONNECTION_STRING = database + server + port + ";" + user + password; }
public static void SaveProductShopToBD(List <ProductShop> products, TypeBD typeBD) { switch (typeBD) { case TypeBD.XML: SaveProductShopToXML(products); break; case TypeBD.SQL: SaveProductShopToSQL(products); break; case TypeBD.Entity: break; default: MessageBox.Show("ERROR typeBD"); break; } }
public static void LoadProductMovingFromDB(TypeBD typeBD) { switch (typeBD) { case TypeBD.XML: LoadProductMovingFromXML(); break; case TypeBD.SQL: LoadProductMovingFromSql(); break; case TypeBD.Entity: LoadProductMovingFromEntity(); break; default: MessageBox.Show("ERROR typeBD"); break; } }
public static void SaveUserShopToBD(int id, TypeBD typeBD) { switch (typeBD) { case TypeBD.XML: SaveUserShopToXML(id); break; case TypeBD.SQL: SaveUserShopToSQL(id); break; case TypeBD.Entity: SaveUserShopToEntity(id); break; default: MessageBox.Show("ERROR typeBD"); break; } }
public static void SaveProductMovingToBD(ProductMoving prMove, TypeBD typeBD) { switch (typeBD) { case TypeBD.XML: SaveProductMovingToXML(prMove); break; case TypeBD.SQL: SaveProductMovingToSQL(prMove); break; case TypeBD.Entity: SaveProductMovingToEntity(prMove); break; default: MessageBox.Show("ERROR typeBD"); break; } }
public static List <ProductMoving> LoadProductMovingFromDB(TypeBD typeBD) { List <ProductMoving> TempProductMoving = new List <ProductMoving>(); switch (typeBD) { case TypeBD.XML: TempProductMoving = LoadProductMovingFromXML(); break; case TypeBD.SQL: TempProductMoving = LoadProductMovingFromSql(); break; case TypeBD.Entity: break; default: MessageBox.Show("ERROR typeBD"); break; } return(TempProductMoving); }
public static List <UserShop> LoadUserShopFromDB(TypeBD typeBD) { List <UserShop> TempUsers = new List <UserShop>(); switch (typeBD) { case TypeBD.XML: TempUsers = LoadUserShopFromXML(); break; case TypeBD.SQL: TempUsers = LoadUserShopFromSql(); break; case TypeBD.Entity: break; default: MessageBox.Show("ERROR typeBD"); break; } return(TempUsers); }
public BD(string titre, string auteur, decimal prix, int nombrePage, TypeBD type) : base(titre, auteur, prix, nombrePage) { Type = type; }