private void button1_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;
foreach (Doctor p in x)
{
cb.Doctors.DeleteOnSubmit(p);
}
cb.SubmitChanges();
MessageBox.Show("SUCCESFULLY DELETED");
}
else
{
MessageBox.Show("Invalid Name");
}
}
}
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
{
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");
Blood bl = new Blood
{
Blood_Group = textBox1.Text,
Available = int.Parse(textBox2.Text),
};
cb.Bloods.InsertOnSubmit(bl);
cb.SubmitChanges();
UpdateGridView();
}
}
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();
}
}
bool IsvalidDoctor(string name)
{
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 q = from p in cb.Doctors
where p.Doctor_Name == textBox1.Text
select p;
if (q.Any())
{
return(true);
}
else
{
return(false);
}
}
bool IsvalidCabinNo(int cabinNo)
{
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 q = from p in cb.CabinLists
where p.Cabin_No == int.Parse(textBox1.Text)
select p;
if (q.Any())
{
return(true);
}
else
{
return(false);
}
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.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");
var x = from a in cb.Bloods
where a.Blood_Group == textBox1.Text
select a;
textBox2.Text = x.FirstOrDefault().Available.ToString();
dataGridView1.DataSource = x.ToList();
}
}
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");
}
}
private void paitentCabinList_Load(object sender, EventArgs e)
{
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");
dataGridView1.DataSource = cb.CabinLists;
}
void updateGridView()
{
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");
dataGridView1.DataSource = cb.Doctors;
}
