Qt; namespace WindowsFormsApplication4
{
public partial class Form1 : Form { SqlConnection sc = new SqlConnection(@"Data Source=OMAIR;Initial Catalog=bloodbank_Management;User ID=sa;Password=123"); SqlCommand cmd; public Form1() { InitializeComponent(); }

private void label1_Click(object sender, EventArgs e) {

}

private void label2_Click(object sender, EventArgs e) {

}

private void label4_Click(object sender, EventArgs e) {

}

private void label6_Click(object sender, EventArgs e) {

}

private void label5_Click(object sender, EventArgs e) {

}

private void Form1_Load(object sender, EventArgs e) { }

private void textBox16_TextChanged(object sender, EventArgs e) {

}

private void button12_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("delete from Bloodbank_Manager where M_ID='" + this.mid.Text + "'", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Deleted! :) "); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void label12_Click(object sender, EventArgs e) {

}

private void button1_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("Insert into Donor (D_ID,D_FirstName,D_LastName,D_Age,D_Gender,D_telephone,D_Address,Recep_ID) values('" + id.Text + "','" + Dfirst.Text + "','" + Dlast.Text + "','" + Dage.Text + "','" + Dgender.Text + "','" + Dtele.Text + "','" + Dadd.Text + "','" + recepid.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Insertion Successful to the Database! :) "); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void textBox4_TextChanged(object sender, EventArgs e) {

}

private void button3_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("delete from Donor where D_ID='" + this.id.Text + "'", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Deleted! :) "); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button2_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand(" Update donor set D_FirstName = '" + Dfirst.Text + "' , D_LastName = '" + Dlast.Text + "' , D_Age = '" + Dage.Text + "' , D_Gender ='" + Dgender.Text + "', D_telephone ='" + Dtele.Text + "', D_Address ='" + Dadd.Text + "', Recep_ID ='" + recepid.Text + "' where ( D_ID = '" + id.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Update Successful to the Database! :) "); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button4_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("Insert into receptionist (Emp_ID,Emp_FirstName,Emp_LastName,Emp_telephone,Emp_Address) values('" + emid.Text + "','" + emfirst.Text + "','" + emlast.Text + "','" + emtel.Text + "','" + emadd.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Insertion Successful to the Database! :)"); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void textBox8_TextChanged(object sender, EventArgs e) {

}

private void button5_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand(" Update receptionist set Emp_FirstName = '" + emfirst.Text + "' , Emp_LastName = '" + emlast.Text + "' , Emp_telephone ='" + emtel.Text + "', Emp_Address ='" + emadd.Text + "' where ( Emp_ID = '" + emid.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Update Successful to the Database! :) "); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button6_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("delete from receptionist where Emp_ID='" + this.emid.Text + "'", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Deleted! :)"); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button7_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("Insert into blood (B_Code,B_type,B_Cost,DonorID,bloodbnk_no) values('" + bcode.Text + "','" + btype.Text + "','" + bcost.Text + "','" + dnrid.Text + "','" + bnkno.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Insertion Successful to the Database! :)"); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button8_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand(" Update blood set B_type = '" + btype.Text + "' , B_Cost = '" + bcost.Text + "' , DonorID = '" + dnrid.Text + "' , bloodbnk_no = '" + bnkno.Text + "' where ( B_Code = '" + bcode.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Update Successful to the Database! :)"); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button9_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("delete from blood where B_Code='" + this.bcode.Text + "'", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Deleted! :)"); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button10_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("Insert into Bloodbank_Manager (M_ID,M_FirstName,M_LastName,M_telephone,M_address) values('" + mid.Text + "','" + mfirst.Text + "','" + mlast.Text + "','" + mtel.Text + "','" + madd.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Insertion Successful to the Database! :)"); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button11_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand(" Update Bloodbank_Manager set M_FirstName = '" + mfirst.Text + "' , M_LastName = '" + mlast.Text + "' , M_telephone ='" + mtel.Text + "', M_address ='" + madd.Text + "' where ( M_ID = '" + mid.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Update Successful to the Database! :) "); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button16_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("Insert into Hospital (H_ID,H_Name,H_telephone,H_address) values('" + hid.Text + "','" + hname.Text + "','" + htel.Text + "','" + hadd.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Insertion Successful to the Database! :) "); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button17_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand(" Update Hospital set H_Name = '" + hname.Text + "' , H_telephone ='" + htel.Text + "', H_address ='" + hadd.Text + "' where ( H_ID = '" + hid.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Update Successful to the Database! :)"); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); }

}

private void button18_Click(object sender, EventArgs e) {

try { sc.Open(); cmd = new SqlCommand("delete from Hospital where H_ID='" + this.hid.Text + "'", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Deleted! :) "); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button13_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand("Insert into Bloodbank (b_no,bl_type,b_orders,Recep_ID,Mang_ID,Hosp_ID) values('" + bncode.Text + "','" + bntype.Text + "','" + bnorders.Text + "','" + bnrec.Text + "','" + bnman.Text + "','" + bnhos.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Insertion Successful to the Database! :)"); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); }

}

private void button14_Click(object sender, EventArgs e) { try { sc.Open(); cmd = new SqlCommand(" Update Bloodbank set bl_type = '" + bntype.Text + "' , b_orders = '" + bnorders.Text + "' , Recep_id = '" + bnrec.Text + "' , Mang_ID = '" + bnman.Text + "' , Hosp_ID = '" + bnhos.Text + "' where ( b_no = '" + bncode.Text + "')", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Update Successful to the Database! :) "); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void button15_Click(object sender, EventArgs e) {

try { sc.Open(); cmd = new SqlCommand("delete from Bloodbank where b_no='" + this.bncode.Text + "'", sc); cmd.ExecuteNonQuery(); MessageBox.Show("Deleted! :)"); sc.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

private void tableLayoutPanel1_Paint(object sender, PaintEventArgs e) {

}

private void recepid_TextChanged(object sender, EventArgs e) {

}

private void label35_Click(object sender, EventArgs e) {

} }
}