private void ward_Click(object sender, EventArgs e) { ward ob = new ward(); ob.Show(); this.Hide(); }
private void button1_Click(object sender, EventArgs e) { connection sv = new connection(); sv.thisConnection.Open(); OracleDataAdapter thisAdapter = new OracleDataAdapter("SELECT * FROM ward_allocation", sv.thisConnection); OracleCommandBuilder thisBuilder = new OracleCommandBuilder(thisAdapter); DataSet thisDataSet = new DataSet(); thisAdapter.Fill(thisDataSet, "ward_allocation"); DataRow thisRow = thisDataSet.Tables["ward_allocation"].NewRow(); try { thisRow["ward_no"] = textBox1.Text; thisRow["total_bed"] = "0"; thisRow["bed_free"] = "0"; thisRow["empty_ward"] = "0"; thisDataSet.Tables["ward_allocation"].Rows.Add(thisRow); thisAdapter.Update(thisDataSet, "ward_allocation"); MessageBox.Show("Submitted"); } catch (Exception ex) { MessageBox.Show(ex.Message); } sv.thisConnection.Close(); this.Hide(); ward ss = new ward(); ss.Show(); }
private void button2_Click(object sender, EventArgs e) { connection sv = new connection(); sv.thisConnection.Open(); OracleCommand thisCommand = sv.thisConnection.CreateCommand(); thisCommand.CommandText = "SELECT * FROM ward_allocation where ward_no= '" + textBox3.Text + "'"; OracleDataReader thisReader = thisCommand.ExecuteReader(); while (thisReader.Read()) { string cmd1 = thisReader["total_bed"].ToString(); int cc = Convert.ToInt32(cmd1); string cmd2 = thisReader["bed_free"].ToString(); int cc2 = Convert.ToInt32(cmd2); int text = Convert.ToInt32(textBox2.Text); result = (text - cc) + cc2; res = result.ToString(); if (cc2 != 0 || Convert.ToInt32(textBox3.Text) != 0) { thisCommand.CommandText = "update ward_allocation set empty_ward = ward_no where ward_no= '" + textBox3.Text + "'"; OracleDataReader thisReader2 = thisCommand.ExecuteReader(); } try { // string filePath = thisReader["picture"].ToString(); // this.pb_profilepics.Image = Image.FromFile(filePath); } catch { MessageBox.Show("Failure"); } } // OracleCommand thisCommand = sv.thisConnection.CreateCommand(); thisCommand.CommandText = "update ward_allocation set Total_bed = '" + textBox2.Text + "', " + "bed_free='" + res + "' where ward_no= '" + textBox3.Text + "'"; thisCommand.Connection = sv.thisConnection; thisCommand.CommandType = CommandType.Text; //For Insert Data Into Oracle// try { thisCommand.ExecuteNonQuery(); MessageBox.Show("Updated"); } catch (Exception ex) { Console.WriteLine(ex.Message); } sv.thisConnection.Close(); this.Hide(); ward ob = new ward(); ob.Show(); }