private void btn_save_supply_Click(object sender, EventArgs e)
        {
            int isDrug = (tb_dosage.Text == "") ? 0 : 1;

            DB = new FinalSanitariumMIS.Helpers.DatabaseHelper();

            DB2ResultSet rs = DB.QueryWithResultSet("SELECT ITEM_NUMBER FROM SUPPLY WHERE ITEM_NUMBER = " + tb_supply_no.Text);

            if (!rs.Read())
            {
                DB.Query("INSERT INTO SUPPLY VALUES (" +
                         tb_supply_no.Text + "," + tb_supplier.Text + ",'" + tb_supply_name.Text + "','" + tb_description.Text + "',0," +
                         tb_reorder_level.Text + ",'" + tb_unit.Text + "'," + tb_cost_per_unit.Text + "," + isDrug + ",'" + tb_dosage.Text + "','" +
                         cb_method_administration.Text + "')");
            }
            else
            {
                DB.Query("UPDATE SUPPLY SET " +
                         "SUPPLIER_NUMBER = " + tb_supplier.Text + ", ITEM_NAME = '" + tb_supply_name.Text + "', DESCRIPTION = '" + tb_description.Text +
                         "', REORDER_LEVEL = " + tb_reorder_level.Text + ", UNIT = '" + tb_unit.Text + "', COST_PER_UNIT = " + tb_cost_per_unit.Text +
                         ", ITEM_TYPE = " + isDrug + ", DOSAGE = '" + tb_dosage.Text + "', METHOD_OF_ADMINISTRATION = '" + cb_method_administration.Text +
                         "' WHERE ITEM_NUMBER = " + dgv_inventory.CurrentRow.Cells[0].Value.ToString());
            }

            RefreshMasterList();
            ClearAllFields();
        }
        private void btn_add_stock_Click(object sender, EventArgs e)
        {
            DB = new FinalSanitariumMIS.Helpers.DatabaseHelper();

            DB.Query("UPDATE SUPPLY SET QUANTITY = QUANTITY + " + tb_stock_quantity.Text + " WHERE ITEM_NUMBER = " + dgv_inventory.CurrentRow.Cells[0].Value.ToString());
            RefreshMasterList();

            tb_stock_quantity.Text  = "";
            panel_add_stock.Visible = false;
        }
        private void RefreshMasterList()
        {
            String modifier = "";

            if (cb_filter.SelectedIndex == 0 || cb_filter.SelectedIndex == -1)
            {
                modifier = "WHERE " +
                           " ITEM_NUMBER LIKE '" + tb_search.Text + "%' OR " +
                           " SUPPLIER_NUMBER LIKE '" + tb_search.Text + "%' OR " +
                           " ITEM_NAME LIKE '" + tb_search.Text + "%' OR " +
                           " DESCRIPTION LIKE '" + tb_search.Text + "%' OR " +
                           " QUANTITY LIKE '" + tb_search.Text + "%' OR " +
                           " REORDER_LEVEL LIKE '" + tb_search.Text + "%' OR " +
                           " UNIT LIKE '" + tb_search.Text + "%' OR " +
                           " COST_PER_UNIT LIKE '" + tb_search.Text + "%' OR " +
                           " ITEM_TYPE LIKE '" + tb_search.Text + "%' OR " +
                           " DOSAGE LIKE '" + tb_search.Text + "%' OR " +
                           " METHOD_OF_ADMINISTRATION  LIKE '%" + tb_search.Text + "'";
            }
            else
            {
                modifier = "WHERE " + cb_filter.SelectedItem.ToString() + " LIKE '" + tb_search.Text + "%'";
            }

            DB = new FinalSanitariumMIS.Helpers.DatabaseHelper();

            DB2ResultSet rs = DB.QueryWithResultSet("SELECT * FROM SUPPLY " + modifier);

            dgv_inventory.Rows.Clear();

            while (rs.Read())
            {
                Object[] d = new Object[11];

                d[0]  = rs.GetString(0);
                d[1]  = rs.GetString(2);
                d[2]  = rs.GetString(3);
                d[3]  = rs.GetString(4);
                d[4]  = rs.GetString(5);
                d[5]  = rs.GetString(6);
                d[6]  = rs.GetString(7);
                d[7]  = rs.GetString(1);
                d[8]  = (rs.GetInt32(8) == 0)? "Supply" : "Drug";
                d[9]  = rs.GetString(9);
                d[10] = rs.GetString(10);

                dgv_inventory.Rows.Add(d);
            }
        }
Example #4
0
        private void btnlogin_Click(object sender, EventArgs e)
        {
            DB = new FinalSanitariumMIS.Helpers.DatabaseHelper();

            DB2ResultSet rs = DB.QueryWithResultSet("SELECT * FROM VW_ACCOUNT WHERE USERNAME = '******' AND PASSCODE = '" + txtpassword.Text + "'");

            if (rs.Read())
            {
                Models.SessionMeta session = new Models.SessionMeta();

                this.Visible = false;

                new MedDirMainMenu().Visible = true;
            }
            else
            {
                MessageBox.Show("Incorrect Login Credentials!");
            }
        }
Example #5
0
        private void RefreshMasterList()
        {
            DB = new FinalSanitariumMIS.Helpers.DatabaseHelper();

            DB2ResultSet rs = DB.QueryWithResultSet("SELECT * FROM SUPPLIER");

            dgv_masterlist.Rows.Clear();

            while (rs.Read())
            {
                Object[] d = new Object[5];

                d[0] = rs.GetString(0);
                d[1] = rs.GetString(1);
                d[2] = rs.GetString(2);
                d[3] = rs.GetString(3);
                d[4] = rs.GetString(4);

                dgv_masterlist.Rows.Add(d);
            }
        }
Example #6
0
        private void btnsave_Click(object sender, EventArgs e)
        {
            DB = new FinalSanitariumMIS.Helpers.DatabaseHelper();

            DB2ResultSet rs = DB.QueryWithResultSet("SELECT * FROM SUPPLIER WHERE supplier_number = '" + tb_supplier_number.Text + "'");

            if (rs.Read())
            {
                DB.Query("UPDATE SUPPLIER SET " +
                         "SUPPLIER_NUMBER = " + tb_supplier_number.Text + "," +
                         "SUPPLIER_NAME = '" + tb_supplier_name.Text + "'," +
                         "ADDRESS = '" + tb_address.Text + "'," +
                         "TELNUMBER = " + tb_tel_no.Text + "," +
                         "FAXNUMBER = " + tb_fax_no.Text + " WHERE SUPPLIER_NUMBER = " +
                         dgv_masterlist.CurrentRow.Cells[0].Value.ToString());
            }
            else
            {
                DB.Query("INSERT INTO SUPPLIER VALUES (" +
                         tb_supplier_number.Text + ",'" + tb_supplier_name.Text + "','" +
                         tb_address.Text + "'," + tb_tel_no.Text + "," + tb_fax_no.Text + ")");
            }
        }
Example #7
0
 public StaffRegistration()
 {
     InitializeComponent();
     emptyAllInputFields();
     DB = new FinalSanitariumMIS.Helpers.DatabaseHelper("127.0.0.1", "50000", "Nicksplat93", "ANGELIE BUEN", "sanita");
 }
Example #8
0
        private void RefreshListofRequesitions()
        {
            DB = new FinalSanitariumMIS.Helpers.DatabaseHelper();

            DB2ResultSet rs = DB.QueryWithResultSet("SELECT * FROM REQUESITION");
        }
Example #9
0
        public HRMainMenu()
        {
            InitializeComponent();

            DB = new FinalSanitariumMIS.Helpers.DatabaseHelper("127.0.0.1", "50000", "Rheamaesabas12", "BILL-LAWRENCE", "sanita");
        }