public static void CheckIsPatientMethod(MainWindowForm mwf, TextBox textBox1, TextBox textBox2) { DoctorPatientDataContext dp = new DoctorPatientDataContext(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Arwin\documents\visual studio 2015\Projects\CSharpProjects\DoctorPatientPortal\DoctorPatient.mdf;Integrated Security=True;Connect Timeout=30"); Patient p = null; try { p = dp.Patients.FirstOrDefault(pl => pl.Email_ID == textBox1.Text && pl.Password == textBox2.Text); } catch (Exception) { mwf.IsPatient = false; } if (p != null) { mwf.IsPatient = true; } }
public static void AdminLogin(MainWindowForm mwf, string emailID, string password) { DoctorPatientDataContext dp = new DoctorPatientDataContext(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Arwin\documents\visual studio 2015\Projects\CSharpProjects\DoctorPatientPortal\DoctorPatient.mdf;Integrated Security=True;Connect Timeout=30"); Admin ad = null; try { ad = dp.Admins.Single(adml => adml.Email_ID == emailID && adml.Password == password); } catch (Exception) { MessageBox.Show("No data found on Database...Try agin.", "Query Result"); } if (ad != null) { //MessageBox.Show("Login successful...", "Query Result"); new AdminDashBoard(emailID).Show(); mwf.Hide(); } }