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
{
}
}
