private void button4_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else { if (IsvalidDoctor(textBox1.Text)) { CabinDBDataContext cb = new CabinDBDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\AIUB\8th semester\C#\Project\Final\Hospital\HospitalManagementSystem.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in cb.Doctors where a.Doctor_Name == textBox1.Text select a; textBox2.Text = x.FirstOrDefault().Cabin_No; textBox3.Text = x.First().Phone; textBox4.Text = x.First().Address; textBox5.Text = x.First().Working_Hour.ToString(); textBox6.Text = x.First().Salary.ToString(); cb.SubmitChanges(); dataGridView1.DataSource = x.ToList(); } else { MessageBox.Show("No match Found"); } } }
private void button4_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else { if (IsvalidCabinNo(int.Parse(textBox1.Text))) { CabinDBDataContext cb = new CabinDBDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\AIUB\8th semester\C#\Project\Final\Hospital\HospitalManagementSystem.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in cb.CabinLists where a.Cabin_No == int.Parse(textBox1.Text) select a; textBox2.Text = x.FirstOrDefault().Type; textBox3.Text = x.First().Price.ToString(); textBox4.Text = x.First().Doctor_Name; cb.SubmitChanges(); dataGridView1.DataSource = x.ToList(); } else { MessageBox.Show("Invalid Cabin No"); } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else if (textBox2.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else if (textBox3.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else if (textBox4.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else if (textBox5.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else if (textBox6.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else { CabinDBDataContext cb = new CabinDBDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\AIUB\8th semester\C#\Project\Final\Hospital\HospitalManagementSystem.mdf;Integrated Security=True;Connect Timeout=30"); Doctor c1 = new Doctor(); c1.Doctor_Name = textBox1.Text; c1.Cabin_No = textBox2.Text; c1.Phone = textBox3.Text; c1.Address = textBox4.Text; c1.Working_Hour = int.Parse(textBox5.Text); c1.Salary = int.Parse(textBox6.Text); cb.Doctors.InsertOnSubmit(c1); cb.SubmitChanges(); updateGridView(); MessageBox.Show("Succesfully Added"); DoctorList f2 = new DoctorList(this); this.Hide(); f2.Show(); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else if (textBox2.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else if (textBox3.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else if (textBox4.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else if (textBox5.Text == "") { MessageBox.Show("Fillup Information Correctly"); } else { CabinDBDataContext cb = new CabinDBDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\AIUB\8th semester\C#\Project\Final\Hospital\HospitalManagementSystem.mdf;Integrated Security=True;Connect Timeout=30"); Paitent p1 = new Paitent(); p1.Paitent_Name = textBox1.Text; p1.Cabin_No = int.Parse(textBox2.Text); p1.Phone = textBox3.Text; p1.Room_Type = textBox4.Text; p1.Price = int.Parse(textBox5.Text); p1.Date = textBox6.Text; cb.Paitents.InsertOnSubmit(p1); cb.SubmitChanges(); updateGridView(); MessageBox.Show("Succesfully Registerd"); } }
private void button1_Click(object sender, EventArgs e) { if (IsvalidDoctor(textBox1.Text)) { CabinDBDataContext cb = new CabinDBDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\AIUB\8th semester\C#\Project\Final\Hospital\HospitalManagementSystem.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in cb.Doctors where a.Doctor_Name == textBox1.Text select a; x.First().Cabin_No = textBox2.Text; x.First().Phone = textBox3.Text; x.First().Address = textBox4.Text; x.First().Working_Hour = int.Parse(textBox5.Text); x.First().Salary = int.Parse(textBox6.Text); cb.SubmitChanges(); dataGridView1.DataSource = x.ToList(); MessageBox.Show("Updated"); } else { MessageBox.Show("Invalid Name"); } }