private void NouvelleCommande_Load(object sender, EventArgs e)
{
this.comboCodeClient.Focus();
//----------------Informations Societe (BEGIN)------------------------------//
InfoSociete Societe = new InfoSociete();
string titre = Societe.nom + "\n" + Societe.adresse + "\nTel:" + Societe.tel + " Fax:" + Societe.fax;
label10.Text = titre;
MemoryStream ms = new MemoryStream();
ms.Write(Societe.logo, 0, Societe.logo.Length);
Image imgPhoto = Image.FromStream(ms);
picLogo.Image = imgPhoto;
//----------------Informations Societe (END)------------------------------//
labelCodeFacture.Text = facture.GenerateCode();
comboCodeClient.DataSource = TB_Client.GetList();
comboCodeClient.DisplayMember = "Code";
dateTimePicker2.Value = dateTimePicker2.Value.AddDays(1);
comboCodeClient.Text = client.GenerateCode();
textNomClient.Text = "";
textPrenomClient.Text = "";
maskedTextTelClient.Text = "";
textAdresseClient.Text = "";
}
private void buttonOk_Click(object sender, EventArgs e)
{
if (ValiderChamps())
{
#region //------------------Ticket a imprimer (Begin)----------------///
if (checkBox1.Checked)
{
this.Enabled = false;
wait.Show();
TicketClient ticket = new TicketClient();
TicketPiece piece = new TicketPiece();
InfoSociete societe = new InfoSociete();
List <ListAF> s = new List <ListAF>();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
DataGridViewRow row = dataGridView1.Rows[i];
s.Add(new ListAF());
s[i].Code_Article = (string)row.Cells["Code_Article"].Value;
s[i].Libelle_Article = (string)row.Cells["Article_Libelle"].Value;
s[i].Libelle_Famille = (string)row.Cells["Famille"].Value;
s[i].Operation = (string)row.Cells["Operation"].Value;
s[i].Prix = decimal.Parse((string)row.Cells["Prix"].Value);
s[i].Quantite = int.Parse((string)row.Cells["Quantite"].Value);
}
ticket.SetDataSource(s);
ticket.SetParameterValue("Code_Facture", facture.Code);
ticket.SetParameterValue("CodeClient", comboCodeClient.Text);
ticket.SetParameterValue("NomClient", textNomClient.Text);
ticket.SetParameterValue("PrenomClient", textPrenomClient.Text);
ticket.SetParameterValue("dateLivraison", dateTimePicker2.Value);
ticket.SetParameterValue("PrixPayee", numericPrixPayee.Value);
ticket.SetParameterValue("Prix_Total", labelTotal.Text);
ticket.SetParameterValue("Societe", societe.nom);
ticket.SetParameterValue("Tel", societe.tel);
ticket.SetParameterValue("Adress", societe.adresse);
if (GlobalVars.namePrinter == string.Empty)
{
MessageBox.Show("Verifier les Option de l'imprimante");
return;
}
//ticket.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)Enum.GetValues(typeof(CrystalDecisions.Shared.PaperSize)).GetValue(int.Parse(GlobalVars.page));
//piece.PrintOptions.PaperSize = ticket.PrintOptions.PaperSize;
ticket.PrintOptions.PrinterName = GlobalVars.namePrinter;
piece.PrintOptions.PrinterName = GlobalVars.namePrinter;
int nb = int.Parse(GlobalVars.nombreCopieTicket);
for (int i = 0; i < nb; i++)
{
ticket.PrintToPrinter(1, true, 1, 1);
}
foreach (ListAF d in s)
{
piece.SetParameterValue("Code_Facture", facture.Code);
piece.SetParameterValue("Nom", textNomClient.Text + " " + textPrenomClient.Text);
piece.SetParameterValue("Date_Liv", dateTimePicker2.Value);
int n = (int)d.article.N_Pieces * d.Quantite;
if (d.article.Print)
{
continue;
}
switch (d.Operation)
{
case "Pressing":
if (GlobalVars.maxPressing != "#")
{
if (d.Quantite > int.Parse(GlobalVars.maxPressing))
{
piece.PrintToPrinter(1, true, 1, 1);
}
}
else
{
for (int i = 0; i < n; i++)
{
piece.PrintToPrinter(1, true, 1, 1);
}
}
break;
case "Repassage":
if (GlobalVars.maxRepassage != "#")
{
if (d.Quantite > int.Parse(GlobalVars.maxRepassage))
{
piece.PrintToPrinter(1, true, 1, 1);
}
}
else
{
for (int i = 0; i < n; i++)
{
piece.PrintToPrinter(1, true, 1, 1);
}
}
break;
case "Tenture":
if (GlobalVars.maxTenture != "#")
{
if (d.Quantite > int.Parse(GlobalVars.maxTenture))
{
piece.PrintToPrinter(1, true, 1, 1);
}
}
else
{
for (int i = 0; i < n; i++)
{
piece.PrintToPrinter(1, true, 1, 1);
}
}
break;
case "Autre":
if (GlobalVars.maxAutre != "#")
{
if (d.Quantite > int.Parse(GlobalVars.maxAutre))
{
piece.PrintToPrinter(1, true, 1, 1);
}
}
else
{
for (int i = 0; i < n; i++)
{
piece.PrintToPrinter(1, true, 1, 1);
}
}
break;
}
}
this.Enabled = true;
wait.Close();
}
#endregion //------------------Ticket a imprimer (End)----------------///
#region //-----------------Enrigstrment de la Facture (Begin)------------------------///
//client///
//
client.Nom = textNomClient.Text;
client.Prenom = textPrenomClient.Text;
client.Adresse = textAdresseClient.Text;
client.NTel = maskedTextTelClient.Text;
client.Code = comboCodeClient.Text;
if (!clientExiste)
{
client.SaveData();
}
//Table Facture
facture.Client = client;
facture.Date_livraison = dateTimePicker2.Value;
facture.Date_Recu = dateTimePicker1.Value;
facture.Prix_Total = double.Parse(labelTotal.Text);
facture.Prix_Partiel = (double)numericPrixPayee.Value;
facture.Mode_Payement = "Espece";
facture.Etat = "Non Reglee";
facture.Livree = "Non Livree";
facture.SaveData();
//lignes de commandes
foreach (DataGridViewRow row in dataGridView1.Rows)
{
ListAF sd = new ListAF();
sd.Code_Article = (string)row.Cells["Code_Article"].Value;
sd.Code_Facture = facture.Code;
sd.Operation = (string)row.Cells["Operation"].Value;
sd.Quantite = int.Parse((string)row.Cells["Quantite"].Value);
sd.Prix = decimal.Parse((string)row.Cells["Prix"].Value);
sd.saveData();
}
#endregion //-----------------Enrigstrment de la Facture (End)------------------------///
if (checkBox2.Checked)
{
Payement p = new Payement(facture.Code);
p.ShowDialog(this.Owner);
}
this.Close();
}
}
private void LoadChamps()
{
/*** PARTIE Configuration Connexion */
string connString = GlobalVars.connString;
if (connString != null)
{
foreach (string s in connString.Split(";".ToCharArray()))
{
switch ((s.Split("=".ToCharArray()))[0])
{
case "Server":
textBoxServer.Text = (s.Split("=".ToCharArray()))[1];
break;
case "Port":
textBoxPort.Text = (s.Split("=".ToCharArray()))[1];
break;
case "User Id":
textBoxDBUser.Text = (s.Split("=".ToCharArray()))[1];
break;
case "Password":
textBoxDBUserPass.Text = (s.Split("=".ToCharArray()))[1];
break;
case "DataBase":
textBoxDB.Text = (s.Split("=".ToCharArray()))[1];
break;
}
}
}
/*** PARTIE Configuration Societe */
InfoSociete societe = new InfoSociete();
if (societe.existe)
{
txtNom.Text = societe.nom;
txtAdresse.Text = societe.adresse;
txttele.Text = societe.tel;
txtfax.Text = societe.fax;
MemoryStream ms = new MemoryStream();
ms.Write(societe.logo, 0, societe.logo.Length);
Image imgPhoto = Image.FromStream(ms);
pbxLogo.Image = imgPhoto;
}
/*** PARTIE Configuration Client */
textPrefixFacture.Text = GlobalVars.PrefixFacture;
textPremierFacture.Text = GlobalVars.PremierFacture;
textPrefixClient.Text = GlobalVars.PrefixClient;
textMaxAutre.Text = GlobalVars.maxAutre;
textMaxPressing.Text = GlobalVars.maxPressing;
textMaxRepassage.Text = GlobalVars.maxRepassage;
textMaxTenture.Text = GlobalVars.maxTenture;
/*** PARTIE Configuration Imprimante */
comboPrinters.Text = GlobalVars.namePrinter;
comboPage.DataSource = Enum.GetNames(typeof(CrystalDecisions.Shared.PaperSize));
try
{
comboPage.SelectedIndex = int.Parse(GlobalVars.page);
}
catch (Exception)
{
comboPage.SelectedIndex = 0;
}
textNbTicket.Text = GlobalVars.nombreCopieTicket;
foreach (string s in System.Drawing.Printing.PrinterSettings.InstalledPrinters)
{
comboPrinters.Items.Add(s);
}
}
private void button1_Click(object sender, EventArgs e)
{
//----------------------------------------------------
DB_PostgreSQL dataBase = new DB_PostgreSQL();
string connString = string.Empty;
connString += "Server=" + textBoxServer.Text + ";";
connString += "Port=" + textBoxPort.Text + ";";
connString += "User Id=" + textBoxDBUser.Text + ";";
connString += "Password="******";";
connString += "DataBase=" + textBoxDB.Text + ";";
GlobalVars.connString = connString;
if (dataBase.testConnection(connString))
{
ConfigSettings.WriteSetting("connString", connString);
}
else
{
MessageBox.Show("Vérifiez la configuration de la base de données =>" + connString);
}
//--------------------------------------------------------
string Printer = comboPrinters.Text;
string Page = comboPage.SelectedIndex.ToString();
string NbTicket = textNbTicket.Text;
string MaxPressing = textMaxPressing.Text;
string MaxRepassage = textMaxRepassage.Text;
string MaxTenture = textMaxTenture.Text;
string MaxAutre = textMaxAutre.Text;
GlobalVars.page = comboPage.SelectedIndex.ToString();
GlobalVars.namePrinter = Printer;
GlobalVars.nombreCopieTicket = NbTicket;
GlobalVars.maxAutre = MaxAutre;
GlobalVars.maxPressing = MaxPressing;
GlobalVars.maxRepassage = MaxRepassage;
GlobalVars.maxTenture = MaxTenture;
ConfigSettings.WriteSetting("Printer", Printer);
ConfigSettings.WriteSetting("Page", Page);
ConfigSettings.WriteSetting("NbTicket", NbTicket);
ConfigSettings.WriteSetting("MaxPressing", MaxPressing);
ConfigSettings.WriteSetting("MaxRepassage", MaxRepassage);
ConfigSettings.WriteSetting("MaxTenture", MaxTenture);
ConfigSettings.WriteSetting("MaxAutre", MaxAutre);
//--------------------------------------------------------
string PrefixFacture = textPrefixFacture.Text;
string PremierFacture = textPremierFacture.Text;
string PrefixClient = textPrefixClient.Text;
GlobalVars.PrefixFacture = PrefixFacture;
GlobalVars.PremierFacture = PremierFacture;
GlobalVars.PrefixClient = PrefixClient;
ConfigSettings.WriteSetting("prefixFacutre", PrefixFacture);
ConfigSettings.WriteSetting("firstFacutre", PremierFacture);
ConfigSettings.WriteSetting("prefixClient", PrefixClient);
//----------------------------------------------------------
//----------------------------------------------------------
MyUtils myUtils = new MyUtils();
if (validateFields())
{
InfoSociete societe = new InfoSociete();
societe.nom = txtNom.Text;
societe.adresse = txtAdresse.Text;
societe.tel = txttele.Text;
societe.fax = txtfax.Text;
if (tbxPhoto.Text != string.Empty)
{
societe.logo = myUtils.GetPhoto(tbxPhoto.Text);
}
societe.SaveData();
}
//-------------------------------------------------------------
this.Close();
}
