private void RefreshMasterList()
{
// not yet tested , requires view from db
DB = new FinalSanitariumMIS.Helpers.DatabaseHelper();
DB2ResultSet rs = DB.QueryWithResultSet("SELECT * FROM VW_STAFF WHERE POSITION = 'doctor'");
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);
}
}
private void btn_reigster_Click(object sender, EventArgs e)
{
DB = new FinalSanitariumMIS.Helpers.DatabaseHelper();
DB2ResultSet rs = DB.QueryWithResultSet("SELECT * FROM VW_STAFF WHERE supplier_number = '" + tb_tel_no.Text + "'");
if (rs.Read())
{
//DB.Query("UPDATE STAFF 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 + ")");
}
}
