private void button1_Click(object sender, EventArgs e)
{
if (updateImmobilier != null && updateImmobilier.id_categories != 0)
{
PFE.Entities.Immeubiliers updateImm = db.Immeubiliers.Where(c => c.id_immeubiliers == updateImmobilier.id_immeubiliers).First();
updateImm.id_villes = int.Parse(comboBoxVille.SelectedValue.ToString());
updateImm.id_quartiers = int.Parse(comboBoxQuartier.SelectedValue.ToString());
updateImm.nbr_chambre = int.Parse(textchambre.Text.ToString());
updateImm.superficie = int.Parse(textsype.Text.ToString());
updateImm.tarif = int.Parse(textTarif.Text.ToString());
updateImm.nom_proprietaire = textProp.Text.ToString();
updateImm.tel_proprietaire = textTel.Text.ToString();
updateImm.id_categories = int.Parse(comboBoxCategorie.SelectedValue.ToString());
db.Entry(updateImm).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("modification avec success");
}
else
{
PFE.Entities.Immeubiliers imm = new PFE.Entities.Immeubiliers();
imm.id_categories = int.Parse(comboBoxCategorie.SelectedValue.ToString());
imm.id_villes = int.Parse(comboBoxVille.SelectedValue.ToString());
imm.id_quartiers = int.Parse(comboBoxVille.SelectedValue.ToString());
imm.nbr_chambre = int.Parse(textchambre.Text.ToString());
imm.superficie = int.Parse(textsype.Text.ToString());
imm.tarif = int.Parse(textTarif.Text.ToString());
imm.nom_proprietaire = textProp.Text.ToString();
imm.tel_proprietaire = textTel.Text.ToString();
imm.status = "libre";
db.Immeubiliers.Add(imm);
db.SaveChanges();
MessageBox.Show("Vous avez ajouter un nouveau immobilier");
button1_Click(sender, e);
}
}
public void remplirTextOfDetails(PFE.Entities.Immeubiliers immobilierInf)
{
remplirComboCat();
remplirComboVille();
comboBoxCategorie.Enabled = true;
comboBoxVille.Enabled = true;
comboBoxQuartier.Enabled = true;
textchambre.Enabled = true;
textsype.Enabled = true;
textTarif.Enabled = true;
textProp.Enabled = true;
textDesc.Enabled = true;
textTel.Enabled = true;
buttonValider.Enabled = false;
comboBoxCategorie.SelectedValue = immobilierInf.id_categories;
comboBoxVille.SelectedValue = immobilierInf.id_villes;
comboBoxQuartier.SelectedValue = immobilierInf.id_quartiers;
textchambre.Text = immobilierInf.nbr_chambre.ToString();
textsype.Text = immobilierInf.superficie.ToString();
textTarif.Text = immobilierInf.tarif.ToString();
textProp.Text = immobilierInf.nom_proprietaire.ToString();
textDesc.Text = immobilierInf.description;
textTel.Text = immobilierInf.tel_proprietaire;
detailImmobilier = immobilierInf;
}
public void remplirChampText(PFE.Entities.Immeubiliers immobilierInf)
{
remplirComboCat();
remplirComboVille();
comboBoxCategorie.SelectedValue = immobilierInf.id_categories;
comboBoxVille.SelectedValue = immobilierInf.id_villes;
comboBoxQuartier.SelectedValue = immobilierInf.id_quartiers;
textchambre.Text = immobilierInf.nbr_chambre.ToString();
textsype.Text = immobilierInf.superficie.ToString();
textTarif.Text = immobilierInf.tarif.ToString();
textProp.Text = immobilierInf.nom_proprietaire.ToString();
textDesc.Text = immobilierInf.description;
textTel.Text = immobilierInf.tel_proprietaire;
updateImmobilier = immobilierInf;
}
private void btModifier_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow.Index != -1)
{
int id_imm = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Number"].Value);
PFE.Entities.Immeubiliers Objimm = db.Immeubiliers.Where(c => c.id_immeubiliers == id_imm).First();
PFE.Immobiliers.AjouterImmeubilier userModif = new PFE.Immobiliers.AjouterImmeubilier();
userModif.remplirChampText(Objimm);
this.Hide();
userModif.Show();
}
else
{
MessageBox.Show("Veuillez choisir un element parmi la liste");
}
}
private void button1_Click_1(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow.Index != -1)
{
int iddetails = (int)dataGridView1.CurrentRow.Cells["Number"].Value;
PFE.Immobiliers.AjouterImmeubilier userModif = new PFE.Immobiliers.AjouterImmeubilier();
PFE.Entities.Immeubiliers ObjectImm = db.Immeubiliers.Where(c => c.id_immeubiliers == iddetails).First();
userModif.remplirTextOfDetails(ObjectImm);
this.Hide();
userModif.Show();
}
else
{
MessageBox.Show("Veuillez choisir un element parmi la liste");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (id_immobilier != 0)
{
PFE.Entities.Immeubiliers immobl = db.Immeubiliers.Where(c => c.id_immeubiliers == id_immobilier).First();
if (immobl.status.Equals("libre"))
{
PFE.Entities.Reservations addReserv = new PFE.Entities.Reservations();
PFE.Entities.Clients client = null;
if (!String.IsNullOrEmpty(nomclt.Text) || !String.IsNullOrEmpty(cinclt.Text) || !String.IsNullOrEmpty(teleclt.Text))
{
client = new PFE.Entities.Clients();
client.nom = nomclt.Text;
client.cin = cinclt.Text;
client.tel = teleclt.Text;
db.Clients.Add(client);
db.SaveChanges();
}
else
{
int cltid = (int)dataGridUser.CurrentRow.Cells["Numero"].Value;
client = db.Clients.Where(c => c.id_clients == cltid).First();
}
PFE.Entities.Clients clt = db.Clients.Where(c => c.cin == client.cin).First();
addReserv.id_clients = clt.id_clients;
addReserv.id_immeubiliers = immobl.id_immeubiliers;
addReserv.nbr_personne = int.Parse(nbrclt.Text.ToString());
addReserv.date_debut = datedebut.Value;
addReserv.date_fin = datefin.Value;
addReserv.tarif = float.Parse(tarifText.Text.ToString());
addReserv.status = "reserve";
db.Reservations.Add(addReserv);
db.SaveChanges();
MessageBox.Show("Reservation bien effectuee");
}
}
else
{
PFE.Entities.Reservations addReserv = db.Reservations.Where(c => c.id_reservations == resUpdateObject.id_reservations).First();
PFE.Entities.Clients client = db.Clients.Where(c => c.id_clients == resUpdateObject.id_clients).First();
client.nom = nomclt.Text;
client.cin = cinclt.Text;
client.tel = teleclt.Text;
client.id_clients = addReserv.id_clients;
db.Entry(client).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
addReserv.id_clients = addReserv.id_clients;
addReserv.id_immeubiliers = addReserv.id_immeubiliers;
addReserv.nbr_personne = int.Parse(nbrclt.Text.ToString());
addReserv.date_debut = datedebut.Value;
addReserv.date_fin = datefin.Value;
addReserv.tarif = float.Parse(tarifText.Text.ToString());
addReserv.status = "reserve";
db.Entry(addReserv).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Modification bien effectuee");
}
}
