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