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