private void metroButton4_Click(object sender, EventArgs e)
{
PatientDataContext up = new PatientDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Priom\Downloads\c#\Private_Clinic - Copy\Private_Clinic\Clinic.mdf;Integrated Security=True;Connect Timeout=30");
var x = up.Patients.Where(a => a.E_mail == metroTextBox2.Text).Count();
if (x != 0 && metroTextBox2.Text != "")
{
var z = up.Patients.Where(a => a.E_mail == metroTextBox2.Text);
z.First().Name = metroTextBox1.Text;
z.First().Age = metroTextBox3.Text;
z.First().Gender = metroComboBox1.Text;
z.First().Address = metroTextBox4.Text;
z.First().Password = metroTextBox6.Text;
up.SubmitChanges();
MessageBox.Show("Your data is updated");
this.Hide();
Form2 login = new Form2();
login.Show();
}
else
{
MessageBox.Show("Invalid value ");
}
}
private void metroButton1_Click(object sender, EventArgs e)
{
PatientDataContext pp = new PatientDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Priom\Downloads\c#\Private_Clinic - Copy\Private_Clinic\Clinic.mdf;Integrated Security=True;Connect Timeout=30");
if (metroTextBox2.Text != "" && metroTextBox6.Text != "")
{
Patient p = new Patient
{
Name = metroTextBox1.Text,
E_mail = metroTextBox2.Text,
Age = metroTextBox3.Text,
Gender = metroComboBox1.Text,
Address = metroTextBox4.Text,
Password = metroTextBox6.Text
};
pp.Patients.InsertOnSubmit(p);
pp.SubmitChanges();
MessageBox.Show("You are Registered ");
this.Hide();
Form1 menu = new Form1();
menu.Show();
}
else
{
MessageBox.Show("Invalid value ");
}
}
private void metroButton2_Click(object sender, EventArgs e)
{
PatientDataContext del = new PatientDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Priom\Downloads\c#\Private_Clinic - Copy\Private_Clinic\Clinic.mdf;Integrated Security=True;Connect Timeout=30");
//var x = from a in del.Patients
//where a.E_mail == metroTextBox2.Text
// select a;
var x = del.Patients.Where(a => a.E_mail == metroTextBox2.Text).Count();
if (x != 0 && metroTextBox2.Text != "")
{
var z = del.Patients.Where(a => a.E_mail == metroTextBox2.Text);
foreach (Patient p in z)
{
del.Patients.DeleteOnSubmit(p);
}
del.SubmitChanges();
MessageBox.Show("Your data deleted");
this.Hide();
Form8 details = new Form8();
details.Show();
}
else
{
MessageBox.Show("Input valid value ");
}
}
private void metroButton2_Click(object sender, EventArgs e)
{
PatientDataContext dbp = new PatientDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Priom\Downloads\c#\Private_Clinic - Copy\Private_Clinic\Clinic.mdf;Integrated Security=True;Connect Timeout=30");
var x = from a in dbp.Patients
select a;
dbp.SubmitChanges();
metroGrid1.DataSource = x.ToList();
}
private void metroButton1_Click(object sender, EventArgs e)
{
PatientDataContext log = new PatientDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Priom\Downloads\c#\Private_Clinic - Copy\Private_Clinic\Clinic.mdf;Integrated Security=True;Connect Timeout=30");
var x = log.Patients.Where(a => a.E_mail == metroTextBox1.Text && a.Password == metroTextBox2.Text).Count();
if (x != 0 && metroTextBox1.Text != "" && metroTextBox2.Text != "")
{
this.Hide();
Form9 pinfo = new Form9();
pinfo.Show();
}
else
{
MessageBox.Show("invalid Please try again ");
}
}
void UpdateGridView()
{
PatientDataContext up = new PatientDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Priom\Downloads\c#\Private_Clinic - Copy\Private_Clinic\Clinic.mdf;Integrated Security=True;Connect Timeout=30");
metroGrid1.DataSource = up.Patients;
}
