private void button1_Click(object sender, EventArgs e) { Admin_option nw = new Admin_option(); nw.Show(); this.Hide(); }
private void button2_Click(object sender, EventArgs e) { Admin_option ado = new Admin_option(); ado.Show(); this.Hide(); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("Fill up all the fields for login "); return; } try { Connection CN = new Connection(); CN.thisConnection.Open(); OracleCommand thiscommand = new OracleCommand(); thiscommand.Connection = CN.thisConnection; thiscommand.CommandText = "Select * From admin where username ='******' AND password='******'"; OracleDataReader thisReader = thiscommand.ExecuteReader(); if (thisReader.Read()) { Admin_option adop = new Admin_option(); adop.Show(); this.Hide(); } else { MessageBox.Show("Username or Password incorrect"); } CN.thisConnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button2_Click(object sender, EventArgs e) { Connection sv = new Connection(); sv.thisConnection.Open(); OracleCommand thiscommand = sv.thisConnection.CreateCommand(); thiscommand.CommandText = "update admin set username = '******',password = '******' where password = '******'"; thiscommand.Connection = sv.thisConnection; thiscommand.CommandType = CommandType.Text; try { int a = thiscommand.ExecuteNonQuery(); if (a == 1) { MessageBox.Show("Updated Successfully"); } else { MessageBox.Show("Not Updated... Insert your old password Perfectly"); return; } } catch (Exception ex) { MessageBox.Show("Not Uddated"); } sv.thisConnection.Close(); this.Close(); Admin_option ob = new Admin_option(); ob.Show(); this.Hide(); }
private void button1_Click(object sender, EventArgs e) { Connection sv = new Connection(); sv.thisConnection.Open(); OracleCommand thisCommand = sv.thisConnection.CreateCommand(); thisCommand.CommandText = "select RoomNumber from New_User_add where RoomNumber = '" + textBox5.Text + "'"; thisCommand.Connection = sv.thisConnection; thisCommand.CommandType = CommandType.Text; try { OracleDataReader thisReader = thisCommand.ExecuteReader(); while (thisReader.Read()) { string sp = thisReader["RoomNumber"].ToString(); try { if (sp != "") { MessageBox.Show("This Room has Already Booked!!!"); sv.thisConnection.Close(); return; } } catch { MessageBox.Show("Failure"); } } thisReader.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return; } if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || comboBox1.Text == "" || comboBox2.Text == "") { MessageBox.Show("Fill up fields then press ok"); return; } OracleDataAdapter thisAdaptor = new OracleDataAdapter("select * from New_User_add", sv.thisConnection); OracleCommandBuilder thisBuilder = new OracleCommandBuilder(thisAdaptor); DataSet thisDataSet = new DataSet(); thisAdaptor.Fill(thisDataSet, "New_user_add"); DataRow thisRow = thisDataSet.Tables["New_User_add"].NewRow(); try { thisRow["Name"] = textBox1.Text; thisRow["PhoneNumber"] = textBox2.Text; thisRow["Email"] = textBox3.Text; thisRow["Address"] = textBox4.Text; thisRow["Profession"] = comboBox1.Text; thisRow["Gender"] = comboBox2.Text; thisRow["entryDate"] = dateTimePicker1.Value.Date.ToString(); thisRow["exitDate"] = dateTimePicker2.Value.Date.ToString(); thisRow["RoomNumber"] = textBox5.Text; thisDataSet.Tables["New_User_add"].Rows.Add(thisRow); thisAdaptor.Update(thisDataSet, "New_User_add"); MessageBox.Show("Add"); Admin_option ad = new Admin_option(); ad.Show(); this.Hide(); } catch (Exception ex) { Console.WriteLine(ex.Message); MessageBox.Show("Fill up all fiels.Exceptation Occour !!!"); } sv.thisConnection.Close(); }