private void button1_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(this.textBox1.Text) || string.IsNullOrWhiteSpace(this.textBox2.Text) || string.IsNullOrWhiteSpace(richTextBox1.Text)) { MessageBox.Show("Fill all the requierd field correctly", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try { conn.Open(); string sqlquery = "INSERT INTO MFG_INFO(MGF_NAME,MFG_ADD,MFG_PHN) VALUES('" + textBox1.Text + "','" + richTextBox1.Text + "','" + textBox2.Text + "')"; OracleCommand cmd = new OracleCommand(sqlquery,conn); int i = cmd.ExecuteNonQuery(); if (i > 0) { cmd.Dispose(); this.Hide(); adminControls adc = new adminControls(); adc.Show(); } } catch (Exception exe) { MessageBox.Show(exe.Message); } } }
private void button1_Click(object sender, EventArgs e) { string mgfnm = comboBox1.GetItemText(this.comboBox1.SelectedItem); string grp = comboBox2.GetItemText(this.comboBox2.SelectedItem); string mtype = comboBox3.GetItemText(this.comboBox3.SelectedItem); string nid = MedIDgen.IdGenrator(mgfnm); string mnm = textBox1.Text; string mbt = textBox3.Text; string mcp = textBox4.Text; string msp = textBox2.Text; string mnt = richTextBox1.Text; string stg = textBox6.Text; conn.Open(); try { OracleCommand cmd = new OracleCommand("INSERT INTO MED_INFO(MED_ID,MED_NAME,MED_STG,MED_MGF,MED_BATCH,MED_GROUP,MED_TYPE,COST_PRICE,SELL_PRICE,NOTES) VALUES('" + nid + "','" + mnm + "','"+stg+"','" + mgfnm + "','" + mbt + "','" + grp + "','" + mtype + "','" + mcp + "','" + msp + "','" + mnt + "')", conn); int i = cmd.ExecuteNonQuery(); if (i > 0) { MessageBox.Show("DONE"); cmd.Dispose(); this.Hide(); } } catch(Exception exe){ MessageBox.Show(exe.Message); } try { OracleCommand cmd = new OracleCommand("INSERT INTO MED_STORE(MED_ID,MED_NAME,MED_QNTY,DAM_QNTY,RE_LEVEL) VALUES('" + nid + "','" + mnm + "','" + 0 + "','" + 0 + "','" + 0 + "')", conn); int j = cmd.ExecuteNonQuery(); if (j > 0) { cmd.Dispose(); this.Hide(); adminControls adm = new adminControls(); adm.Show(); MedInfoView miv = new MedInfoView(nid); miv.Show(); } } catch (Exception exe) { MessageBox.Show(exe.Message); } conn.Close(); }
private void Store_FormClosing(object sender, FormClosingEventArgs e) { adminControls adm = new adminControls(); adm.Show(); }
private void button3_Click(object sender, EventArgs e) { try { if (comboBox2.SelectedIndex == -1 || string.IsNullOrWhiteSpace(this.textBox8.Text) || string.IsNullOrWhiteSpace(this.textBox9.Text) || string.IsNullOrWhiteSpace(this.textBox10.Text) || string.IsNullOrWhiteSpace(this.textBox11.Text)) { MessageBox.Show("Fill all the requierd field correctly", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (textBox10.Text != textBox11.Text) { MessageBox.Show("Password does not match..", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { position = comboBox2.GetItemText(this.comboBox2.SelectedItem); salary = textBox8.Text; unm = textBox9.Text; pass = textBox10.Text; conn.Open(); OracleParameter parm = new OracleParameter(); parm.OracleDbType = OracleDbType.Blob; parm.Value = imageBt; OracleCommand cmd = new OracleCommand("INSERT INTO EMPLOYE_INFO(EMP_NAME,F_NAME,M_NAME,DOB,BLOOD,EMAIL,MOBILE,GENDER,NID,MAIL_ADD,PAR_ADD,JOIN_DATE,IMAGE,POSITION,SALARY) VALUES('" + nm + "','" + fnm + "','" + mnm + "',TO_DATE('" + dob + "', 'DD/MM/YYYY'), '" + bdg + "','" + eml + "','" + mbn + "','" + radio_value + "','" + nid + "','" + madd + "','" + padd + "',TO_DATE('" + jod + "', 'DD/MM/YYYY'),:1,'" + position + "','" + salary + "')", conn); cmd.Parameters.Add(parm); cmd.ExecuteNonQuery(); // if (ni > 0) // { // MessageBox.Show("Information Uploaded..."); // } // cmd.Dispose(); if (position == "Manager") { cmd = new OracleCommand("INSERT INTO MANAGER_LOGIN(E_ID,U_NAME,PASSWORD) VALUES((SELECT MAX(EMP_ID) FROM EMPLOYE_INFO),'" + unm + "','" + pass + "')", conn); int i = cmd.ExecuteNonQuery(); if (i > 0) { MessageBox.Show("Information Uploaded..."); } } else { cmd = new OracleCommand("INSERT INTO STUFF_LOGIN(E_ID,U_NAME,PASSWORD) VALUES((SELECT MAX(EMP_ID) FROM EMPLOYE_INFO),'" + unm + "','" + pass + "')", conn); int i = cmd.ExecuteNonQuery(); if (i > 0) { MessageBox.Show("Information Uploaded..."); adminControls ad = new adminControls(); this.Hide(); ad.Show(); } } } } } catch (Exception exc) { MessageBox.Show(exc.Message); } conn.Close(); }
private void AddMgf_FormClosing(object sender, FormClosingEventArgs e) { adminControls adm = new adminControls(); adm.Show(); this.Hide(); }
private void button2_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(this.textBox1.Text) || string.IsNullOrWhiteSpace(this.textBox2.Text) || string.IsNullOrEmpty(comboBox1.Text)) { if (string.IsNullOrWhiteSpace(this.textBox1.Text)) { MessageBox.Show("Enter User Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.textBox1.Focus(); } else if (string.IsNullOrWhiteSpace(this.textBox2.Text)) { MessageBox.Show("Enter Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.textBox2.Focus(); } else { MessageBox.Show("Select your Status", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { ///////////start of admin log in////////////////////// if (comboBox1.SelectedIndex == 0) { adminControls adct = new adminControls(); try { conn.Open(); String admin_username = textBox1.Text; String pass_word = textBox2.Text; OracleCommand cmd = new OracleCommand("SELECT * FROM ADMIN WHERE ADMIN_USERNAME='******'", conn); OracleDataReader r = cmd.ExecuteReader(); if (r.HasRows) { cmd = new OracleCommand("SELECT PASSWORD FROM ADMIN WHERE ADMIN_USERNAME='******'", conn); r = cmd.ExecuteReader(); r.Read(); if (r.GetValue(0).ToString() == pass_word) { LoginName.name = textBox1.Text; adct.Show(); this.Hide(); } } else { MessageBox.Show("Invalid User Name Or Password", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Error); textBox2.Focus(); } r.Close(); conn.Close(); } catch (Exception exc) { MessageBox.Show(exc.Message); } } ///////////End of admin log in////////////////////// ///////////start of manager log in////////////////////// if (comboBox1.SelectedIndex == 1) { managerControls mnct = new managerControls(); try { conn.Open(); // String admin_username = textBox1.Text; // String pass_word = textBox2.Text; OracleCommand cmd = new OracleCommand("SELECT * FROM MANAGER_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn); OracleDataReader r = cmd.ExecuteReader(); if (r.HasRows) { // MessageBox.Show(); cmd = new OracleCommand("SELECT PASSWORD FROM MANAGER_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn); r = cmd.ExecuteReader(); r.Read(); // MessageBox.Show(r.GetString(0)); if (r.GetValue(0).ToString() == textBox2.Text) { // MessageBox.Show("wELCOM"); LoginName.name = textBox1.Text; mnct.Show(); this.Hide(); } } else { MessageBox.Show("Invalid User Name Or Password", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Error); } r.Close(); conn.Close(); } catch (Exception exc) { MessageBox.Show(exc.Message); } } ///////////End of manager log in////////////////////// //////////start of stuff log in///////////////////// if (comboBox1.SelectedIndex == 2) { stuffControls stct = new stuffControls(); try { conn.Open(); // String admin_username = textBox1.Text; // String pass_word = textBox2.Text; OracleCommand cmd = new OracleCommand("SELECT * FROM STUFF_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn); OracleDataReader r = cmd.ExecuteReader(); if (r.HasRows) { // MessageBox.Show(); cmd = new OracleCommand("SELECT PASSWORD FROM STUFF_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn); r = cmd.ExecuteReader(); r.Read(); // MessageBox.Show(r.GetString(0)); if (r.GetValue(0).ToString() == textBox2.Text) { // MessageBox.Show("wELCOM"); LoginName.name = textBox1.Text; stct.Show(); this.Hide(); } } else { MessageBox.Show("Invalid User Name Or Password", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Error); } r.Close(); conn.Close(); } catch (Exception exc) { MessageBox.Show(exc.Message); } } ///////////End of stuff log in////////////////////// } }