static void Main(string[] args)
{
ConnectionDb nnn = new ConnectionDb();
try
{
nnn.connection_todo();
Console.WriteLine("opened");
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
}
/*
* Console.WriteLine("Getting Connection ...");
* conn = DBUtils.GetDBConnection();
* try
* {
* Console.WriteLine("Openning Connection ...");
* conn.Open();
* Console.WriteLine("Connection successful!");
* }
* catch (Exception e)
* {
* Console.WriteLine("Error: " + e.Message);
* } */
Operation Opre = new Operation();
//MySqlCommand comm = new MySqlCommand();
//comm.Connection =conn;
//comm.CommandText = "INSERT INTO `test`(`test`) VALUES('help2')";
//comm.ExecuteNonQuery();
string point = "10";
while (point != "0")
{
Operation.preMenu(point);
point = Console.ReadLine();
if (point == "1")
{
Operation.Ajouter();
}
else if (point == "2")
{
Operation.deeuMenu();
}
}
}
public static void Ajouter()
{
Console.Clear();
Console.WriteLine("==> entrer le numero de client ");
AjCli.setNum(int.Parse(Console.ReadLine()));
AjCmp.setNumclient(AjCli.getNum());
Console.WriteLine("==> entrer le nom ");
AjCli.setNom(Console.ReadLine());
Console.WriteLine("==> entrer le prenom ");
AjCli.setPrenom(Console.ReadLine());
Console.WriteLine("==> entrer le numero de GSM ");
AjCli.setGsm(Console.ReadLine());
Console.WriteLine("==> entrer E_mail ");
AjCli.setE_mail(Console.ReadLine());
Console.WriteLine("==> entrer le numero de compte ");
AjCmp.setNum(int.Parse(Console.ReadLine()));
Console.WriteLine("==> entrer le solde");
AjCmp.setMont(float.Parse(Console.ReadLine()));
Console.WriteLine("==> entrer le type ( courant/epargne)");
AjCmp.setType(Console.ReadLine());
ConnectionDb.Ajouter(AjCmp, AjCli);
AjCmp = new Compte();
AjCli = new Client();
}
public static void deeuMenu()
{
Console.Clear();
int b = 0;
Console.WriteLine("entrer le numero de compte(taper 0 pour annuller) :");
b = int.Parse(Console.ReadLine());
if (b == 0)
{
}
else if (b != 0)
{
DeeuMenu(b);
int p = 0;
//Console.WriteLine("");
OperMenu();
p = int.Parse(Console.ReadLine());
if (p == 1)
{
Console.WriteLine("entrer un solde pour verser :");
double S1 = double.Parse(Console.ReadLine());
S1 += AjCmp.getMont();
AjCmp.setMont(S1);
//Console.WriteLine(AjCmp.getNum()+" "+AjCmp.getMont());
ConnectionDb.Vesement(AjCmp);
ConnectionDb.insertOper(AjCmp.getNum(), "versement");
AjCmp = new Compte();
}
else if (p == 2)
{
Console.Clear();
int b1 = 0;
Console.WriteLine(" entrer le numero de compte de reception ");
b1 = int.Parse(Console.ReadLine());
ConnectionDb.saerchcompte(Cmp, b1);
Console.WriteLine("entrer un solde : ");
double S2 = double.Parse(Console.ReadLine());
if (S2 <= AjCmp.getMont() + 100)
{
AjCmp.setMont(AjCmp.getMont() - S2);
Cmp.setMont(Cmp.getMont() + S2);
ConnectionDb.Vesement(AjCmp);
ConnectionDb.Vesement(Cmp);
ConnectionDb.insertOper(AjCmp.getNum(), "Trensfaire");
AjCmp = new Compte();
Cmp = new Compte();
}
else
{
AjCmp = new Compte();
imposible();
//Console.WriteLine("imposiple de faire cette operation");
}
}
else if (p == 3)
{
Console.WriteLine("entrer un solde pour retrer :");
double S3 = double.Parse(Console.ReadLine());
if (S3 <= AjCmp.getMont())
{
S3 = AjCmp.getMont() - S3;
AjCmp.setMont(S3);
ConnectionDb.Vesement(AjCmp);
ConnectionDb.insertOper(AjCmp.getNum(), "retretement");
AjCmp = new Compte();
}
else
{
AjCmp = new Compte();
imposible();
}
}
}
}
public static void DeeuMenu(int b)
{
ConnectionDb.saerchcompte(AjCmp, b);
}