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