private void BtnAttribuerBien_Click(object sender, RoutedEventArgs e)
{
DirectoryCreator dcr = new DirectoryCreator();
BiensController BC = new BiensController();
dcr.CreateDirectory3(inputNumAttri.Text);
AttributionController AC = new AttributionController();
AC.AjouterAttribution(inputDateAttribution.Text, inputNumClient.Text, inputNumProjet.Text, inputNumProgramme.Text, inputNatureProgramme.Text, inputTypeBien.Text, inputNumIlot.Text, inputNumLot.Text, inputNumBloc.Text, tempIdbien, inputDateDLE.Text, inputDateDLR.Text, inputRefDL.Text);
BC.ModifierEtat(tempIdbien, inputEtat.Text);
AddPayementController APC = new AddPayementController();
APC.AjouterPayement(inputDateAttribution.Text, int.Parse(inputNumAttri.Text), inputNumClient.Text, inputNomClient.Text, inputPrenomClient.Text, inputDateNaissance.Text, inputNumCNI.Text, int.Parse(inputNumProjet.Text), inputNomProjet.Text, int.Parse(inputNumProgramme.Text), inputNomProgramme.Text, inputNumIlot.Text, inputNumLot.Text, inputTypeBien.Text, inputNumBloc.Text, inputNiveau.Text, inputNbrPiece.Text, decimal.Parse(inputSurH.Text), decimal.Parse(inputSurU.Text), decimal.Parse(inputPrixTTC.Text), 0, decimal.Parse(inputPrixTTC.Text));
string queryL = "Select NumA from Attribution where NumA=(select MAX(NumA) from attribution)";
MySqlDataReader rdrL = null;
MySqlConnection conL = null;
MySqlCommand cmdL = null;
conL = new MySqlConnection(Database.ConnectionString());
conL.Open();
cmdL = new MySqlCommand(queryL);
cmdL.Connection = conL;
rdrL = cmdL.ExecuteReader();
while (rdrL.Read())
{
tempNumAttribution = int.Parse(rdrL["NumA"].ToString());
}
MessageBox.Show(tempNumAttribution.ToString());
string queryL2 = "Select NumPayement from payement where NumAttribution='" + tempNumAttribution + "'";
MySqlDataReader rdrL2 = null;
MySqlConnection conL2 = null;
MySqlCommand cmdL2 = null;
conL2 = new MySqlConnection(Database.ConnectionString());
conL2.Open();
cmdL2 = new MySqlCommand(queryL2);
cmdL2.Connection = conL2;
rdrL2 = cmdL2.ExecuteReader();
while (rdrL2.Read())
{
tempNumPayement = int.Parse(rdrL2["NumPayement"].ToString());
}
msh.ExecuteQuery("INSERT INTO `cnl` (`NumCNL`, `NumPayement`, `Etat`, `NumDeci`, `DateDeci`, `MontantCNL`, `DateConservation`, `DateControle`, `DateReserve`) VALUES (NULL, '" + tempNumAttribution + "', 'Non Admis', '', NULL, NULL, NULL, NULL, NULL)");
msh.ExecuteQuery("INSERT INTO `creditb` (`NumCB`, `NumPayement`, `NumConvBan`, `DateConv`, `NomBanque`, `BIC`, `MontantCb`) VALUES (NULL, '" + tempNumAttribution + "', '', NULL, '', '', NULL)");
msh.ExecuteQuery("INSERT INTO `fnpos` (`NumFNPOS`, `NumPayement`, `NumDeciF`, `DateDeciF`, `MontantFNPOS`) VALUES (NULL, '" + tempNumAttribution + "', NULL, NULL, NULL)");
BtnAttribuerBien.IsEnabled = false;
Attribution A = new Attribution("");
this.NavigationService.Navigate(A);
}
private void BtnSuppProjet_Click(object sender, RoutedEventArgs e)
{
if (tempRefProjet != "")
{
System.Windows.MessageBox.Show("Note: Lors de la supression d'un projet tous les élements qui appartienent au projet et au programmes du projet à savoir(Acte,Permis de lotir, permis de construire, Cahier des charges, Edd,Convention, et documents) seront automatiquement supprimé !", "Information", MessageBoxButton.OK, MessageBoxImage.Warning);
if (MessageBox.Show("Voulez-vous supprimer ce projet?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No)
{
Projet P = new Projet("", UserRole);
NavigationService.Navigate(P);
}
else
{
BiensController BC = new BiensController();
BC.SupprimerLogFromProjet(int.Parse(tempRefProjet));
ProjetController PC = new ProjetController();
DirectoryCreator DC = new DirectoryCreator();
ActeController AC = new ActeController();
ProgrammeController PRC = new ProgrammeController();
ActeProgrammeController APC = new ActeProgrammeController();
PermiLotirController PLC = new PermiLotirController();
PermisDeConstruireController PDCC = new PermisDeConstruireController();
CahierChargeProgrammeController CCPC = new CahierChargeProgrammeController();
EddController EC = new EddController();
ConventionController CC = new ConventionController();
DC.DeleteDirectory(@"Projet\" + tempRefProjet);
CC.SupprimerConventionFromProjet(tempnomprojet);
EC.SupprimerEddFromProjet(int.Parse(tempRefProjet));
CCPC.SupprimerCahierChargeFromProjet(tempnomprojet);
PDCC.SupprimerPermisConstruireFromProjet(int.Parse(tempRefProjet));
PLC.SupprimerPLFromProjet(int.Parse(tempRefProjet));
PRC.DeleteProgrammeFromProjet(int.Parse(tempRefProjet));
AC.SupprimerActe2(tempRefProjet);
PC.DeleteProjet(tempRefProjet);
MessageBox.Show("Le projet " + tempRefProjet + " à était bien supprimer");
Projet P = new Projet("", UserRole);
NavigationService.Navigate(P);
}
}
else
{
MessageBox.Show("Veuillez selectioner un projet", "Projet", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void BtnSupprimmerEdd_Click(object sender, RoutedEventArgs e)
{
if (tempNumEdd == "")
{
System.Windows.MessageBox.Show("Veuillez selectionner un EDD pour le supprimé", "information", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
BiensController BC = new BiensController();
DirectoryCreator DC = new DirectoryCreator();
DC.DeleteDirectory(@"Projet\" + RefProjet + @"\Programme\" + RefProgramme + @"\Edd \" + tempNumEdd);
BC.SupprimerLogFromEDD(int.Parse(tempNumEdd), int.Parse(RefProgramme), RefProjet);
EC.SupprimerEdd(tempNumEdd);
msh.LoadData("select *,DATE_FORMAT(DatePubli,'%d/%m/%y') AS Date from edd where RefProgramme='" + RefProgramme + "' and RefProjet='" + RefProjet + "'", dataViewListeEdd);
inputDateEnreg.Text = inputVolume.Text = inputConservation.Text = inputNotaire.Text = inputTelNotaire.Text = inputAdresseNotaire.Text = inputNomGeo.Text = inputTelGeo.Text = inputAddresseGeo.Text = inputNbrLog.Text = inputNbrLoc.Text = inputNbrCave.Text = inputNbrEQ.Text = inputNbrPS.Text = inputNbrBur.Text = "";
inputSupLog.Text = inputSupLoc.Text = inputSupBur.Text = inputSupCave.Text = inputSupEQ.Text = inputSupPS.Text = "0";
}
}
private void BtnEddmodificatif_Click(object sender, RoutedEventArgs e)
{
if (tempNumEdd == "" && inputNumEDD.Text == tempNumEdd && inputNumEDD.Text == "")
{
System.Windows.MessageBox.Show("Veuillez selectionner un EDD pour créer un EDD modificatif", "information", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
string NumEddModif = "";
BiensController BS = new BiensController();
EC.AjouterEdd(RefProjet, RefProgramme, inputDateEnreg.Text, inputVolume.Text, inputRefPub.Text, inputConservation.Text, inputNotaire.Text, inputTelNotaire.Text, inputAdresseNotaire.Text, inputNomGeo.Text, inputAddresseGeo.Text, inputTelGeo.Text, inputDateGeo.Text, inputRedicte.Text, inputNbrLog.Text, decimal.Parse(inputSupLog.Text), inputNbrLoc.Text, decimal.Parse(inputSupLoc.Text), inputNbrBur.Text, decimal.Parse(inputSupBur.Text), inputNbrCave.Text, decimal.Parse(inputSupCave.Text), inputNbrEQ.Text, decimal.Parse(inputSupEQ.Text), inputNbrPS.Text, decimal.Parse(inputSupPS.Text));
string query3 = "select MAX(NumEdd) AS Num from edd where RefProjet='" + RefProjet + "' and RefProgramme='" + RefProgramme + "';";
MySqlDataReader rdr3 = null;
MySqlConnection con3 = null;
MySqlCommand cmd3 = null;
con3 = new MySqlConnection(Database.ConnectionString());
con3.Open();
cmd3 = new MySqlCommand(query3);
cmd3.Connection = con3;
rdr3 = cmd3.ExecuteReader();
bool oneTime3 = true;
while (rdr3.Read())
{
NumEddModif = rdr3["Num"].ToString();
}
System.Windows.MessageBox.Show(NumEddModif);
string Edd = "Edd";
DirectoryCreator DC = new DirectoryCreator();
DC.CreateDirectoryProgramme(RefProjet.ToString(), RefProgramme + "/" + Edd + "/" + NumEddModif);
BS.BiensEddModificatif(int.Parse(tempNumEdd), int.Parse(NumEddModif), int.Parse(RefProgramme), RefProjet);
msh.LoadData("select *,DATE_FORMAT(DatePubli,'%d/%m/%y') AS Date from edd where RefProgramme='" + RefProgramme + "' and RefProjet='" + RefProjet + "'", dataViewListeEdd);
inputDateEnreg.Text = inputVolume.Text = inputConservation.Text = inputNotaire.Text = inputTelNotaire.Text = inputAdresseNotaire.Text = inputNomGeo.Text = inputTelGeo.Text = inputAddresseGeo.Text = inputNbrLog.Text = inputNbrLoc.Text = inputNbrCave.Text = inputNbrEQ.Text = inputNbrPS.Text = inputNbrBur.Text = "";
inputSupLog.Text = inputSupLoc.Text = inputSupBur.Text = inputSupCave.Text = inputSupEQ.Text = inputSupPS.Text = "0";
}
}
private void BtnSuppProgramme_Click(object sender, RoutedEventArgs e)
{
if (temprefprogramme != "")
{
System.Windows.MessageBox.Show("Note: Lors de la supression d'un programme tous les élements qui appartienent au programme à savoir(Acte,Permis de lotir, permis de construire, Cahier des charges, Edd,Convention, et documents) seront automatiquement supprimé !", "Information", MessageBoxButton.OK, MessageBoxImage.Warning);
if (System.Windows.MessageBox.Show("Voulez-vous supprimer ce projet?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No)
{
Programme P = new Programme("");
NavigationService.Navigate(P);
}
else
{
ProgrammeController PC = new ProgrammeController();
DirectoryCreator DC = new DirectoryCreator();
PermisDeConstruireController PDCC = new PermisDeConstruireController();
CahierChargeProgrammeController CCPC = new CahierChargeProgrammeController();
EddController EC = new EddController();
ConventionController CC = new ConventionController();
BiensController BC = new BiensController();
DC.DeleteDirectory(@"Projet\" + tempRefProjet + @"\Programme\" + temprefprogramme);
BC.SupprimerLogFromProgramme(int.Parse(temprefprogramme), int.Parse(tempRefProjet));
PDCC.SupprimerPermisConstruireFromProgramme(temprefprogramme);
CCPC.SupprimerCahierChargefromProgramme(temprefprogramme);
EC.SupprimerEddFromProgramme(temprefprogramme);
CC.SupprimerConventionFromProgramme(temprefprogramme);
PC.DeleteProgramme(int.Parse(temprefprogramme));
Programme P = new Programme("");
NavigationService.Navigate(P);
}
}
else
{
System.Windows.MessageBox.Show("Veuillez selectioner un projet", "Erreur", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Btnmodifier_Click(object sender, RoutedEventArgs e)
{
AttributionController AC = new AttributionController();
AC.ModifierAttribution(inputDateAttribution.Text, inputNumClient.Text, inputNumProjet.Text, inputNumProgramme.Text, inputNatureProgramme.Text, inputTypeBien.Text, inputNumIlot.Text, inputNumLot.Text, inputNumBloc.Text, tempIdbien, int.Parse(inputNumAttri.Text), inputDateDLE.Text, inputDateDLR.Text, inputRefDL.Text);
if (tempIdbien != tempIdbien2)
{
BiensController BC = new BiensController();
BC.ModifierEtat(tempIdbien2, "Libre");
BC.ModifierEtat(tempIdbien, "Réservé");
}
string queryload = "Select MontantVerse from payement where NumAttribution='" + inputNumAttri.Text + "'";
MySqlDataReader rdrP = null;
MySqlConnection conP = null;
MySqlCommand cmdP = null;
conP = new MySqlConnection(Database.ConnectionString());
conP.Open();
cmdP = new MySqlCommand(queryload);
cmdP.Connection = conP;
rdrP = cmdP.ExecuteReader();
bool oneTimeP = true;
while (rdrP.Read())
{
tempMontantVers = decimal.Parse(rdrP["MontantVerse"].ToString());
}
conP.Close();
tempreste = decimal.Parse(inputPrixTTC.Text) - tempMontantVers;
AddPayementController APC = new AddPayementController();
APC.ModifierPayement(int.Parse(inputNumProjet.Text), inputNomProjet.Text, int.Parse(inputNumProgramme.Text), inputNomProgramme.Text, inputNumIlot.Text, inputNumLot.Text, inputTypeBien.Text, inputNumBloc.Text, inputNiveau.Text, inputNbrPiece.Text, decimal.Parse(inputSurH.Text), decimal.Parse(inputSurU.Text), decimal.Parse(inputPrixTTC.Text), tempreste, int.Parse(inputNumAttri.Text));
}
