public CBPayement(int NumPayement, decimal Reste, AddPayement AddPayement, int NumAttribution)
{
InitializeComponent();
this.NumPayement = NumPayement;
this.AddPayement = AddPayement;
this.NumAttribution = NumAttribution;
this.Reste = Reste;
string query = "select * FROM creditb where NumCB=(select MAX(NumCB)) and NumPayement='" + NumPayement + "'";
MySqlDataReader rdr = null;
MySqlConnection con = null;
MySqlCommand cmd = null;
con = new MySqlConnection(Database.ConnectionString());
con.Open();
cmd = new MySqlCommand(query);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
bool oneTime = true;
while (rdr.Read())
{
inputNumConv.Text = rdr["NumConvBan"].ToString();
inputDateConv.Text = rdr["DateConv"].ToString();
inputNomBanque.Text = rdr["NomBanque"].ToString();
inputBIC.Text = rdr["BIC"].ToString();
inputMontant.Text = rdr["MontantCb"].ToString();
}
if (inputNumConv.Text != "")
{
BtnValiderCB.IsEnabled = false;
}
}
public FNPOSPayement(int NumPayement, decimal Reste, AddPayement AddPayement, int NumAttribution)
{
InitializeComponent();
this.NumPayement = NumPayement;
this.NumAttribution = NumAttribution;
this.Reste = Reste;
this.AddPayement = AddPayement;
string query = "select * FROM fnpos where NumFNPOS=(select MAX(NumFNPOS)) and NumPayement='" + NumPayement + "'";
MySqlDataReader rdr = null;
MySqlConnection con = null;
MySqlCommand cmd = null;
con = new MySqlConnection(Database.ConnectionString());
con.Open();
cmd = new MySqlCommand(query);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
bool oneTime = true;
while (rdr.Read())
{
inputDeciF.Text = rdr["NumDeciF"].ToString();
inputDateDeciF.Text = rdr["DateDeciF"].ToString();
inputMontantFNPOS.Text = rdr["MontantFNPOS"].ToString();
}
if (inputDeciF.Text != "")
{
BtnValiderFNPOS.IsEnabled = false;
}
}
public ListeVers(int NumPayement, decimal Reste, int NumAttribution, AddPayement AddPayement, string CodeClient, string NomProgramme, string id, string username)
{
InitializeComponent();
msh.FillDropDownList("select NatureP from naturepayement", inputNaturePayement, "NatureP");
inputNatureFrais.IsEnabled = false;
msh.LoadData("select * from ov where NumPayement='" + NumPayement + "'", dataViewOV);
this.NumPayement = NumPayement;
this.Reste = Reste;
this.AddPayement = AddPayement;
this.NumAttribution = NumAttribution;
this.CodeClient = CodeClient;
this.NomProgramme = NomProgramme;
this.id = id;
this.username = username;
inputNumPayement.Text = NumPayement.ToString();
inputEtat.IsEnabled = false;
string query = "SELECT count(IdOvSolde) as APPORT FROM `ovsolde` WHERE CodeClient='1' and NomProgramme='LPA 160 logts' and EtatOvSolde='Terminé'";
MySqlDataReader rdr = null;
MySqlConnection con = null;
MySqlCommand cmd = null;
con = new MySqlConnection(Database.ConnectionString());
con.Open();
cmd = new MySqlCommand(query);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
bool oneTime = true;
while (rdr.Read())
{
tempApport = rdr["APPORT"].ToString();
}
if (int.Parse(tempApport) == 0)
{
BtnimportApport.IsEnabled = false;
}
else
{
BtnimportApport.IsEnabled = true;
}
}
public CNLPayement(int NumPayement, decimal Reste, AddPayement AddPayement, int NumAttribution)
{
InitializeComponent();
this.NumPayement = NumPayement;
this.AddPayement = AddPayement;
this.NumAttribution = NumAttribution;
this.Reste = Reste;
string query = "select * from cnl where NumCNL=(select MAX(NumCNL)) and NumPayement='" + NumPayement + "'";
MySqlDataReader rdr = null;
MySqlConnection con = null;
MySqlCommand cmd = null;
con = new MySqlConnection(Database.ConnectionString());
con.Open();
cmd = new MySqlCommand(query);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
bool oneTime = true;
while (rdr.Read())
{
NumCNL = int.Parse(rdr["NumCNL"].ToString());
inputNumDeci.Text = rdr["NumDeci"].ToString();
inputDateDeci.Text = rdr["DateDeci"].ToString();
inputMontantCNL.Text = rdr["MontantCNL"].ToString();
inputEtat.Text = rdr["Etat"].ToString();
inputDateConserv.Text = rdr["DateConservation"].ToString();
inputDatecontrole.Text = rdr["DateControle"].ToString();
inputDatereserve.Text = rdr["DateReserve"].ToString();
}
if (NumCNL.ToString() != "")
{
BtnAddCNL.IsEnabled = false;
}
if (inputNumDeci.Text != "")
{
BtnValiderverssement.IsEnabled = false;
}
}
private void BtnModifierpayement_Click(object sender, RoutedEventArgs e)
{
AddPayement AP = new AddPayement(tempNumPayement, id, username);
this.NavigationService.Navigate(AP);
}
