private void metroButton1_Click(object sender, EventArgs e) { DocDataDataContext MDC = new DocDataDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\arbab\Downloads\UserHospital-20171213T080148Z-001\UserHospital\UserHospital\DB.mdf;Integrated Security=True;Connect Timeout=30"); Doctor a = new Doctor(); a.DregDate = dRegDate.Value.Date.ToString(); a.DName = dName.Text; a.Dgender = dGender.Text; a.Ddepartment = dDepartment.Text; a.Ddob = dDob.Value.Date.ToString(); a.Dage = dAge.Text; a.DbloodGroup = dBloodGroup.Text; a.DmaritialStatus = dMaritialstatus.Text; a.Daddress = dAddress.Text; a.Dcity = dCity.Text; a.Dcountry = dCountry.Text; a.DcontactNo = dContactNo.Text; a.DpatientList = DBNull.Value.ToString(); a.DuserName = dUsername.Text; a.Dpassword = dPassword.Text; MDC.Doctors.InsertOnSubmit(a); MDC.SubmitChanges(); }
private void login_Click(object sender, EventArgs e) { //if (IsvalidUser(metroTextBox2.Text, metroTextBox3.Text)) //{ // DashBoard u = new DashBoard(); // u.Show(); // this.Hide(); //} if (metroComboBox1.Text == "OfficeUser") { officeUsersLoginDataContext mdb = new officeUsersLoginDataContext(); var q = from a in mdb.UserTables where a.userName == metroTextBox2.Text && a.password == metroTextBox3.Text select a; if (q.Any()) { DashBoard u = new DashBoard(); u.Show(); this.Hide(); } else { metroLabel4.Text = "Invalid Information please use correct information"; //return false; } } if (metroComboBox1.Text == "Doctor") { DocDataDataContext mdb = new DocDataDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\arbab\Downloads\UserHospital-20171213T080148Z-001\UserHospital\UserHospital\DB.mdf;Integrated Security=True;Connect Timeout=30"); var q = from a in mdb.Doctors where a.DuserName == metroTextBox2.Text && a.Dpassword == metroTextBox3.Text select a; if (q.Any()) { DocDash u = new DocDash(); DocDataDataContext mdt = new DocDataDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\arbab\Downloads\UserHospital-20171213T080148Z-001\UserHospital\UserHospital\DB.mdf;Integrated Security=True;Connect Timeout=30"); var c = from a in mdt.Doctors where a.DuserName == metroTextBox2.Text select a; u.Show(); this.Hide(); u.DDage.Text = c.First().Dage; u.DDbloodgroup.Text = c.First().DbloodGroup; u.DDdepartment.Text = c.First().Ddepartment; u.DDdob.Text = c.First().Ddob; u.DDgender.Text = c.First().Dgender; u.DDname.Text = c.First().DName; u.DDregDate.Text = c.First().DregDate; u.DDmaritialSattus.Text = c.First().DmaritialStatus; //this.Hide(); } else { metroLabel4.Text = "Invalid Information please use correct information"; } } }