public void Refresh() { using (DbEntities dbrefresh = new DbEntities()) { var Query = from s in dbrefresh.Clients join r in dbrefresh.RendezVous on s.id equals r.id select new { Dossier = r.id, Patiant = s.CIN, Nom = s.nomCli, prénom = s.prenom, Tél = s.Tel, Adress = s.addressCli, Date_du_RV = r.RVdate }; DGVDossierClient.DataSource = Query.ToList(); } }
private void DossierDesPatiant_Load(object sender, EventArgs e) { using (DbEntities dbdocumentlist = new DbEntities()) { var Query = from s in dbdocumentlist.Clients join r in dbdocumentlist.RendezVous on s.id equals r.id select new { Dossier = r.id, Patiant = s.CIN, Nom = s.nomCli, prénom = s.prenom, Tél = s.Tel, Adress = s.addressCli, Date_du_RV = r.RVdate }; DGVDossierClient.DataSource = Query.ToList(); } }
private void RVAujourd_Load(object sender, EventArgs e) { using (DbEntities dbaujour = new DbEntities()) { var Query = from s in dbaujour.Clients join r in dbaujour.RendezVous on s.id equals r.id where r.RVdate == DateTime.Today select new { Patiant = s.CIN, Nom = s.nomCli, Prenom = s.prenom, Telephone = s.Tel, Sex = s.sex, Date_RV = r.RVdate, RV_a = r.RVTime }; DGVRVaujour.DataSource = Query.OrderBy(o => o.RV_a).ToList(); //DGVRVaujour.DataSource=dbaujour.RendezVous.Where(w => w.RVdate == DateTime.Today) // .Select(s => new { Patiant = s.CIN, rendez_vous_à = s.RVTime }).ToList(); } }
private void pictureBox3_Click(object sender, EventArgs e) { try { using (DbEntities dbDelete = new DbEntities()) { DialogResult myResult; myResult = MessageBox.Show("Voulez vous vraiment supprimer ce patient?", " Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (myResult == DialogResult.OK) { //Client cl = dbDelete.Clients.Where(w => w.CIN == txtCINNewRV.Text).First(); //dbDelete.Clients.Remove(cl); //dbDelete.SaveChanges(); MessageBox.Show("Vous n'avez pas le droit de supprimer", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); //Refresh(); } } } catch { //MessageBox.Show("you don't have a permession!!"); } }
private void BtnCommancer_Click(object sender, EventArgs e) { try { if (txtusername.Text == "" && txtpassword.Text == "") { MessageBox.Show("assurez-vous d'entrer votre nom d'utilisateur et votre mot de passe", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { using (DbEntities dbLogin = new DbEntities()) { switch (bunifuDropdown1.selectedValue) { case "": lblChoix.Text = "vous devez choisir pour commencer"; break; //Docteur case "Docteur": if (dbLogin.Doctors.Any(a => a.idDoc == txtusername.Text && a.PasswordDoc == txtpassword.Text)) { FDoctorSpace doc = new FDoctorSpace(); doc.Show(); this.Hide(); } if (dbLogin.Doctors.Any(w => w.idDoc != txtusername.Text)) { lblUsernam.Text = "nom d'utilisateur incorrect"; } else if (dbLogin.Doctors.Any(w => w.PasswordDoc != txtpassword.Text)) { lblpassword.Text = "Mot de passe incorrect"; } break; //Infermier case "Infirmier": if (dbLogin.Admines.Any(a => a.userName == txtusername.Text && a.Adminpassword == txtpassword.Text)) { FInfermierSpace fr = new FInfermierSpace(); fr.Show(); this.Hide(); } if (dbLogin.Admines.Any(w => w.userName != txtusername.Text)) { lblUsernam.Text = "nom d'utilisateur incorrect"; } else if (dbLogin.Admines.Any(w => w.Adminpassword != txtpassword.Text)) { lblpassword.Text = "Mot de passe incorrect"; } break; } } } } catch { } }
private void PictureBox6_Click(object sender, EventArgs e) { DbEntities db = new DbEntities(); //EditBye var cin = DGVClientInfo.CurrentRow.Cells["P_CIN"].Value.ToString(); Client old = db.Clients.Where(c => c.CIN == cin).First(); Client newCL = new Client(); newCL.CIN = txtCINNewRV.Text; newCL.nomCli = txtNomnewRV.Text; newCL.prenom = txtPrenomnewRV.Text; if (rdbFnewRV.Checked == true) { newCL.sex = "Femme"; } else { newCL.sex = "Homme"; } newCL.addressCli = richAdressnewRV.Text; newCL.Tel = int.Parse(txtTelnewRV.Text); newCL.DateNaissance = Convert.ToDateTime(mskDDN.Text); if (checkassurenewRV.Checked == true) { newCL.Assurer = "Oui"; } else { newCL.Assurer = "Non"; } old.CIN = newCL.CIN; old.nomCli = newCL.nomCli; old.prenom = newCL.prenom; old.sex = newCL.sex; old.addressCli = newCL.addressCli; old.Tel = newCL.Tel; old.DateNaissance = newCL.DateNaissance; old.Assurer = newCL.Assurer; db.SaveChanges(); SuucedDocs S = new SuucedDocs(); S.picSuuceAddDocs.Visible = true; S.pictureBox1.Visible = false; S.Show(); Refresh(); //Design------------------------------- btnConfirmer.Enabled = true; picSave.Visible = false; txtCINNewRV.Enabled = false; txtNomnewRV.Enabled = false; txtPrenomnewRV.Enabled = false; txtTelnewRV.Enabled = false; txtTelnewRV.Enabled = false; richAdressnewRV.Enabled = false; rdbFnewRV.Enabled = false; rdbHnewRV.Enabled = false; checkassurenewRV.Enabled = false; }
private void btnConfirmer_Click(object sender, EventArgs e) { //try //{ using (DbEntities dbnewRV = new DbEntities()) { var TimeRv = TimeSpan.Parse(dateTimePicker1.Value.ToString("HH:mm")); var DateRv = Convert.ToDateTime(dtpRVdatenewEV.Value.ToString("MM-dd-yyyy")); if (dbnewRV.RendezVous.Any(w => w.RVdate == DateRv && w.RVTime == TimeRv)) { MessageBox.Show("ce rendez-vous est déjà pris", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { dbnewRV.Clients.Any(a => a.CIN == txtCINNewRV.Text); RendezVou RV = new RendezVou(); Client Clnewrv = new Client(); DocumentsClient docs = new DocumentsClient(); cl.CIN = txtCINNewRV.Text; cl.nomCli = txtNomnewRV.Text; cl.prenom = txtPrenomnewRV.Text; cl.DateNaissance = Convert.ToDateTime(mskDDN.Text); cl.addressCli = richAdressnewRV.Text; cl.Tel = int.Parse(txtTelnewRV.Text); if (rdbFnewRV.Checked == true) { cl.sex = "Femme"; } else { cl.sex = "Homme"; } if (checkassurenewRV.Checked == true) { cl.Assurer = "Oui"; } else { cl.Assurer = "Non"; } ////------tabel RV //if (dbnewRV.RendezVous.Any(a => a.RVdate == dtpRVdatenewEV.Value && //a.RVTime.Value.Hours == dateTimePicker1.Value.Hour && //a.RVTime.Value.Minute == dateTimePicker1.Value.Minute).ToString().First(); //{ //} RendezVou rv = new RendezVou(); rv.RVdate = dtpRVdatenewEV.Value; rv.RVTime = TimeSpan.Parse(dateTimePicker1.Text); rv.id = cl.id; docs.id = cl.id; dbnewRV.Clients.Add(cl); dbnewRV.RendezVous.Add(rv); dbnewRV.DocumentsClients.Add(docs); SuucedDocs S = new SuucedDocs(); S.picSuuceAddDocs.Visible = false; S.pictureBox1.Visible = true; S.Show(); dbnewRV.SaveChanges(); Refresh(); } } //} //catch //{ //} }
private void BtnCommancer_Click_1(object sender, EventArgs e) { try { using (DbEntities db = new DbEntities()) { var TimeRv = TimeSpan.Parse(dtpRVtime.Value.ToString("HH:mm")); var DateRv = Convert.ToDateTime(dtpRVdate.Value.ToString("MM-dd-yyyy")); Client cl = new Client(); RendezVou rv = new RendezVou(); DocumentsClient docs = new DocumentsClient(); if (txtCIN.Text == "" || txtNom.Text == "" || txtPrenom.Text == "" || dtpRVdate.Value == null || dtpRVtime.Text == null || txtTel.Text == "") { MessageBox.Show("Assurez-vous d'insérer des champs obligatoires", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (db.RendezVous.Any(w => w.RVdate == DateRv && w.RVTime == TimeRv)) { MessageBox.Show("ce rendez-vous est déjà pris", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (db.Clients.Any(a => a.CIN == txtCIN.Text)) { MessageBox.Show("Ce Patiany est Deja existe"); } else { cl.CIN = txtCIN.Text; cl.nomCli = txtNom.Text; cl.prenom = txtPrenom.Text; cl.DateNaissance = Convert.ToDateTime(mskDDN.Text); cl.addressCli = richAdress.Text; cl.Tel = int.Parse(txtTel.Text); if (rdbF.Checked == true) { cl.sex = "Femme"; } else { cl.sex = "Homme"; } if (checkassure.Checked == true) { cl.Assurer = "Oui"; } else { cl.Assurer = "Non"; } //------tabel RV rv.RVdate = dtpRVdate.Value; rv.RVTime = TimeSpan.Parse(dtpRVtime.Text); //Document Cl docs.id = cl.id; rv.id = cl.id; db.Clients.Add(cl); db.RendezVous.Add(rv); db.DocumentsClients.Add(docs); db.SaveChanges(); Clear(); AvecSuccee av = new AvecSuccee(); av.Show(); this.Hide(); //MessageBox.Show("Ajouté Avec succès", "Message ℹ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch { } }
private void btnSaveSetti_Click(object sender, EventArgs e) { try { using (DbEntities dbS = new DbEntities()) { if (txtNomEtulisateur.Text == "" || txtcurrenpass.Text == "" || txtConfirmPasswrod.Text == "" || txtNouvPassword.Text == "" || txtNuvnomUtilisateur.Text == "") { MessageBox.Show("veuillez remplire les champs obligatoir", "message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { Admine newA = new Admine(); Admine oldusernam = (from c in dbS.Admines where c.userName == txtNomEtulisateur.Text && c.Adminpassword == txtcurrenpass.Text select c).FirstOrDefault(); if (dbS.Admines.Any(a => a.userName != txtNomEtulisateur.Text)) { lblcurrentname.Text = "cet utilisateur n'existe pas!"; } else if (dbS.Admines.Any(a => a.userName == txtNuvnomUtilisateur.Text)) { lblnewuser.Text = "Cet identifiant existe déjà"; } if (dbS.Admines.Any(a => a.Adminpassword != txtcurrenpass.Text)) { lblcurentpass.Text = "votre mot de passe incorrect"; } else if (dbS.Admines.Any(a => a.Adminpassword == txtNouvPassword.Text)) { lblnouvpassword.Text = "vous devez avoir un nouveau mot de passe"; } else { newA.userName = txtNuvnomUtilisateur.Text; if (txtNouvPassword.Text == txtConfirmPasswrod.Text) { newA.Adminpassword = txtConfirmPasswrod.Text; oldusernam.userName = newA.userName; oldusernam.Adminpassword = newA.Adminpassword; dbS.SaveChanges(); FrGCompte Go = new FrGCompte(); Go.Show(); this.Hide(); } else { lblconfirmpass.Text = "vos mots de passe doivent être égaux"; } } } } } catch { } }