private void comboboxDoctorName_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
///////Loading Doctor Department Value
try
{
string Query = "select id,department from doctor where name='" + comboboxDoctorName.SelectedItem.ToString() + "';";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
docId = MyReader2.GetString(0);
docDept = MyReader2.GetString(1);
textboxDoctorDept.Text = docDept;
}
MyReader2.Close();
string Query1 = "select department from doctor where name='" + comboboxDoctorName.SelectedItem.ToString() + "';";
MySqlCommand MyCommand = new MySqlCommand(Query, conn);
MySqlDataReader MyReader;
MyReader = MyCommand.ExecuteReader();
MyReader.Close();
assd.IsEnabled = true;
}
catch { }
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
string Query = ("select * from itp.opd where PatientID LIKE '%" + this.txtPatient.Text + "%';");
// string Query = "select * from hospital.opd where patientID= " + this.txtPatient.Text + "; ";
MySqlConnection MyConn2 = new MySqlConnection(MyConnection);
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
if (MyReader2.Read())
{
this.txtFirstName.Text = MyReader2.GetString("Fname");
this.txtLastName.Text = MyReader2.GetString("Lname");
this.txtGender.Text = MyReader2.GetString("Gender");
this.txtAge.Text = MyReader2.GetString("Age");
}
MyConn2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool isPasswordvalid(string lietotajs, string parole)
{
string hash = CreateStrongHash(parole);
try
{
string MyConnection2 = "server=localhost; port=3306; database=aktuapstrade; username=root; password=qwerty123; SslMode=none";
string Query = "SELECT `password` FROM `users` WHERE `username` = " + "'" + lietotajs + "'";
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
MyReader2.Read();
string a = MyReader2.GetString("password");
if (MyReader2.GetString("password") == hash)
{
MyConn2.Close();
return(true);
}
else
{
MyConn2.Close();
return(false);
}
}
catch (Exception errors)
{
var a = errors;
return(false);
}
}
private void txtAccountNo_TextChanged(object sender, EventArgs e)
{
if (txtAccountNo.Text.Length == 12 && cboChequeName.Text != "Manager's Check Continues")
{
string sql = "SELECT BRSTN, Name1, Name2 FROM captive_database.sbtc_history WHERE AccountNo = '" + txtAccountNo.Text + "' ORDER BY PrimaryKey DESC LIMIT 1";
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
MySqlCommand MyCommand2 = new MySqlCommand(sql, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string BRSTN = MyReader2.GetString(0);
string Name1 = MyReader2.GetString(1);
string Name2 = MyReader2.GetString(2);
txtBRSTN.Text = BRSTN;
txtName1.Text = Name1;
txtName2.Text = Name2;
}
MyConn2.Close();
}
}
private void redact(string Name1)
{
try
{
string Query = "SELECT * FROM Info WHERE `Name` = '" + Name1 + "';";
MySqlConnection MyConn2 = new MySqlConnection(connect);
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
this.textBox1.Clear();
this.textBox2.Clear();
this.textBox3.Clear();
while (MyReader2.Read())
{
this.textBox1.Text = MyReader2.GetString("Name");
this.textBox2.Text = MyReader2.GetString("Description");
this.textBox3.Text = MyReader2.GetString("Category");
}
MyConn2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void unidade_Endereco()
{
//consulta para mostrar o telefone quando clicar no enderenco
MySqlConnection conexao = conexaoMysql.GetConexaoNote();
string sqlQuery2 = "select Endereco from enderecos where NomeUnidade = '" + pegaUnidadeEnd + "'";
try
{
MySqlCommand objComm = new MySqlCommand(sqlQuery2, conexao);
MySqlDataReader MyReader2;
MyReader2 = objComm.ExecuteReader();
//MessageBox.Show("Alterado com sucesso !!!");
while (MyReader2.Read())
{
Endereco1 = MyReader2.GetString("Endereco");
}
conexao.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void check_doctor_dept()
{
try
{
Query78 = "select department from user.doctor where id='" + hmmtext.Text + "';";
MySqlCommand MyCommand2 = new MySqlCommand(Query78, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
doc_dept = MyReader2.GetString(0);
}
MyReader2.Close();
if (doc_dept.Equals("Cardiology"))
{
string Query100 = "select distinct disease_type from user.medicine_name where disease_type='" + "Cardiac" + "';";
MySqlCommand MyCommand100 = new MySqlCommand(Query100, conn);
MySqlDataReader MyReader100;
MyReader100 = MyCommand100.ExecuteReader();
while (MyReader100.Read())
{
testingprocess.Text = MyReader100.GetString(0).ToString();
}
MyReader100.Close();
}
else if (doc_dept.Equals("Nurology"))
{
string Query101 = "select distinct disease_type from user.medicine_name where disease_type='" + "Neurological" + "';";
MySqlCommand MyCommand101 = new MySqlCommand(Query101, conn);
MySqlDataReader MyReader101;
MyReader101 = MyCommand101.ExecuteReader();
while (MyReader101.Read())
{
testingprocess.Text = MyReader101.GetString(0).ToString();
}
MyReader101.Close();
}
else if (doc_dept.Equals("Orthopedics"))
{
string Query102 = "select distinct disease_type from user.medicine_name where disease_type='" + "Orthopedic" + "';";
MySqlCommand MyCommand102 = new MySqlCommand(Query102, conn);
MySqlDataReader MyReader102;
MyReader102 = MyCommand102.ExecuteReader();
while (MyReader102.Read())
{
testingprocess.Text = MyReader102.GetString(0).ToString();;
}
MyReader102.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public List <Item> GetItemData(string code, Boolean isTarget)
{
List <Item> array = new List <Item>();
try
{
string Query = "select code, name, target, status, day_start_date, day_end_date, min_start_date, min_end_date, day_avg_start_date, day_avg_end_date, min_avg_start_date, min_avg_end_date, upd_date, type " +
"from item ";
if (code != null)
{
Query += " where name like '@val%'";
}
if (isTarget)
{
Query += " where target = 'T'";
}
Query += " order by target asc, upd_date desc;";
MySqlConnection MyConn2 = GetConnection();
MySqlCommand cmd = new MySqlCommand(Query, MyConn2);
if (code != null)
{
cmd.Parameters.AddWithValue("@val", code);
}
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = cmd.ExecuteReader();
while (MyReader2.Read())
{
Item entity = new Item();
entity.code = MyReader2.GetString(0);
entity.name = MyReader2.GetString(1);
entity.target = MyReader2.GetString(2);
entity.status = MyReader2.GetString(3);
entity.dayStartDate = Util.GetNotNullInT(4, MyReader2);
entity.dayEndDate = Util.GetNotNullInT(5, MyReader2);
entity.minStartDate = Util.GetNotNullInT(6, MyReader2);
entity.minEndDate = Util.GetNotNullInT(7, MyReader2);
entity.dayAvgStartDate = Util.GetNotNullInT(8, MyReader2);
entity.dayAvgEndDate = Util.GetNotNullInT(9, MyReader2);
entity.minAvgStartDate = Util.GetNotNullInT(10, MyReader2);
entity.minAvgEndDate = Util.GetNotNullInT(11, MyReader2);
entity.updDate = Util.GetNotNullInT(12, MyReader2);
entity.update = "UPDATE";
entity.type = MyReader2.GetString(13);
array.Add(entity);
}
MyConn2.Close();
}
catch (Exception e)
{
Console.Write(e);
}
return(array);
}
private void comboBox4_SelectedIndexChanged(object sender, EventArgs e)
{
string Constring = "datasource=localhost;port=3306;username=root;password="******"select * from youken_springs.employee where e_id ='" + comboBox4.Text + "';";
string quarry2 = "select * from youken_springs.job where e_id ='" + comboBox4.Text + "';";
MySqlConnection ConDataBase = new MySqlConnection(Constring);
MySqlConnection ConDataBase2 = new MySqlConnection(Constring);
MySqlCommand cmdDataBase = new MySqlCommand(quarry, ConDataBase);
MySqlCommand cmdDataBase2 = new MySqlCommand(quarry2, ConDataBase2);
MySqlDataReader MyReader;
MySqlDataReader MyReader2;
try
{
ConDataBase.Open();
MyReader = cmdDataBase.ExecuteReader();
/* IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("en-GB", true);
* DateTime join_date = DateTime.ParseExact(txt_joinDate.Text, "dd/MM/yyyy", theCultureInfo);
* DateTime today = DateTime.Now;
* txt_wkdduration.Text = ((today - join_date).TotalDays).ToString();*/
//DateTime date = DateTime.ParseExact(this.Text, "dd/MM/yyyy", null)theCultureInfo
while (MyReader.Read())
{
txt_flname.Text = MyReader.GetString("e_full_name");
txt_add1.Text = MyReader.GetString("address_line1");
txt_add2.Text = MyReader.GetString("address_line2");
txt_addCity.Text = MyReader.GetString("city");
// txt_sal.Text = (MyReader["salary"].ToString());
lbl_em_id.Text = MyReader.GetUInt32("e_id").ToString();
lbl_pro_em_id.Text = MyReader.GetUInt32("e_id").ToString();
e_id = lbl_pro_em_id.Text;
lbl_fullAdd.Text = txt_add1.Text + "," + "" + txt_add2.Text + "," + "" + txt_addCity.Text;
}
ConDataBase.Close();
ConDataBase2.Open();
MyReader2 = cmdDataBase2.ExecuteReader();
while (MyReader2.Read())
{
txt_joinDate.Text = MyReader2.GetString("join_date");
txt_position.Text = MyReader2.GetString("designation");
}
ConDataBase2.Close();
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string Query = "select * from `Info` where `Name` = '" + this.listBox1.Text + "';";
MySqlConnection MyConn2 = new MySqlConnection(connect);
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
this.textBox3.Text = MyReader2.GetString("Description");
}
MyConn2.Close();
}
private void Patient_Load(object sender, EventArgs e)
{
panelNewPatient.Visible = false;
panelEdit.Visible = false;
try
{
string Query = "select Name from patient;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
AutoCompleteStringCollection mycollection = new AutoCompleteStringCollection();
while (MyReader2.Read())
{
mycollection.Add(MyReader2.GetString(0));
}
textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
textBox1.AutoCompleteCustomSource = mycollection;
textBox20.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox20.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
textBox20.AutoCompleteCustomSource = mycollection;
MyConn2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
string Query = "select Name as 'Name',Email as 'Email',birth as 'Birth Date',Age,Gender,Blood_type as 'Blood Type',Phone as 'Phone',Address as 'Address',Disease as 'Disease' from patient;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
MyAdapter.SelectCommand = MyCommand2;
DataTable dTable = new DataTable();
MyAdapter.Fill(dTable);
dataGridView1.DataSource = dTable;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void updat()
{
string Query = "select * from `Users`;";
MySqlConnection MyConn2 = new MySqlConnection(connect);
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
this.listBox1.Items.Clear();
while (MyReader2.Read())
{
this.listBox1.Items.Add(MyReader2.GetString("Login"));
}
MyConn2.Close();
}
public void fillFields(string guid)
{
try
{
string MyConnection2 = "server=localhost; port=3306; database=akturegistracijadb; username=root; password=qwerty123; SslMode=none";
string query = "SELECT * FROM `aktudati` WHERE `GUID` = " + "'" + guid + "'";
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
MySqlCommand MyCommand2 = new MySqlCommand(query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
this.pas_nos_text.Text = MyReader2.GetString("Pasakuma Nosaukums");
this.pas_dat_text.Text = MyReader2.GetString("Pasakuma Datums");
this.vards_uzvards_text.Text = MyReader2.GetString("Vards Uzvards");
this.personas_kods_text.Text = MyReader2.GetString("Personas Kods");
this.mail_text.Text = MyReader2.GetString("Epasts");
this.tel_tex.Text = MyReader2.GetString("Telefona NR");
this.cena_text.Text = MyReader2.GetString("Biletes Cena");
this.id_text.Text = MyReader2.GetString("Bilesu ID");
this.bil_id_nr.Text = MyReader2.GetString("Bilesu Veidlapas Nummuri");
this.pirk_dat_text.Text = MyReader2.GetString("Pirkuma Datums");
this.ieg_viet_text.Text = MyReader2.GetString("Iegades vieta");
this.tirdz_punkta_text.Text = MyReader2.GetString("Tirdzniecibas vieta");
this.other_info_text.Text = MyReader2.GetString("Cits info");
this.konta_text.Text = MyReader2.GetString("Bankas Konts");
this.swift_text.Text = MyReader2.GetString("Swift Kods");
this.bank_nos_text.Text = MyReader2.GetString("Bankas Nosaukums");
this.guid_text.Text = MyReader2.GetString("GUID");
this.aizpildisanas_datums_text.Text = MyReader2.GetString("Aizpildisanas datums");
if (MyReader2.GetString("Statuss") == "Apstrādāts")
{
this.apstradats_checkbox.IsChecked = true;
}
else
{
this.apstradats_checkbox.IsChecked = false;
}
}
MyReader2.Close();
}
catch (Exception error)
{
MessageBox.Show(error.ToString());
}
}
public void load_combo_disease_namee()
{
try
{
string Query = "select distinct disease_name from test_name where disease_type='" + comboDiseaseType.SelectedItem.ToString() + "';";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
this.comboDiseaseName.Items.Add(name);
}
MyReader2.Close();
}
catch {}
}
void load_doctor_name()
{
try
{
string Query = "select name from doctor;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
this.comboboxDoctorName.Items.Add(name);
}
MyReader2.Close();
}
catch { }
}
void load_disease()
{
try
{
string Query = "select distinct disease_name from medicine_name;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
comboboxDisease.Items.Add(name);
}
MyReader2.Close();
}
catch { }
}
void load_blood_group()
{
try
{
string Query = "select * from blood_group;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
comboboxBloodGroup.Items.Add(name);
}
MyReader2.Close();
}
catch { }
}
void fill_combo_medicine_name()
{
try
{
MySqlCommand MyCommand2 = new MySqlCommand(QueryMedicine, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
this.comboboxMedicineName.Items.Add(name);
}
MyReader2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void afterDonorCheckOther_Load(object sender, EventArgs e)
{
try
{
string Query = "select Name from donor;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
AutoCompleteStringCollection mycollection = new AutoCompleteStringCollection();
while (MyReader2.Read())
{
mycollection.Add(MyReader2.GetString(0));
}
textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
textBox1.AutoCompleteCustomSource = mycollection;
MyConn2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
string Query = "select * from donor;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
MyAdapter.SelectCommand = MyCommand2;
DataTable dTable = new DataTable();
MyAdapter.Fill(dTable);
dataGridView1.DataSource = dTable;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void pass_user_Load(object sender, EventArgs e)
{
panel242.Visible = false;
panelAdminInfo.Visible = true;
try
{
string Query = "select Email from pass_user ";
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
AutoCompleteStringCollection mycollection = new AutoCompleteStringCollection();
while (MyReader2.Read())
{
mycollection.Add(MyReader2.GetString(0));
}
textBox2.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox2.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
textBox2.AutoCompleteCustomSource = mycollection;
MyConn2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MySqlDataAdapter sda = new MySqlDataAdapter("select * from admin_pass", MyConn2);
DataTable dt = new DataTable();
sda.Fill(dt);
try
{
textBox123.Text = dt.Rows[0]["username"].ToString();
textBox124.Text = dt.Rows[0]["password"].ToString();
textBox125.Text = dt.Rows[0]["id"].ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void load_combo_disease_typee()
{
try
{
string Query = "select distinct disease_type from test_name;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
this.comboDiseaseType.Items.Add(name);
}
MyReader2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void fill_combo_timming()
{
try
{
string Query = "select * from timing;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
this.comboboxTiming.Items.Add(name);
}
MyReader2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void loadtest()
{
try
{
//Query = "select test_name from user.test_name where disease_name='" + disease + "';";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
this.comboboxTestName.Items.Add(name);
}
MyReader2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void load_sex()
{
try
{
string Query = "select * from hopedatabase.patient_sex;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, connn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
comboboxPatient_sex.Items.Add(name);
//comboboxBloodGroup.Items.Add(name);
}
MyReader2.Close();
}
catch (Exception eee)
{
MessageBox.Show(eee.Message.ToString());
}
}
protected void ss(int xer)
{
string Query = $"select * from `quiz` where role = (select Role from Users where Login = '******') limit {xer};";
MySqlConnection MyConn2 = new MySqlConnection(connect);
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
//this.textBox1.Text = MyReader2.GetString("Description");
this.textBox1.Text = MyReader2.GetString("name");
this.radioButton1.Text = MyReader2.GetString("win");
this.radioButton2.Text = MyReader2.GetString("q1");
this.radioButton3.Text = MyReader2.GetString("q2");
this.label2.Text = xer.ToString();
}
next++;
MyConn2.Close();
}
private void load_patient()
{
try
{
comboboxpatient_name.Items.Clear();
string Query = "select patient_name from hopedatabase.patient_data;";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
string name = MyReader2.GetString(0);
comboboxpatient_name.Items.Add(name);
}
MyReader2.Close();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
}
}
public void SelectGroepNaam()
{
try
{
Query = "SELECT groepnaam FROM productgroepen";
MySqlConnection MyCon2 = new MySqlConnection(MyCon);
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyCon2);
MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
MyAdapter.SelectCommand = MyCommand2;
MySqlDataReader MyReader2;
MyCon2.Open();
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
cbProductGroepenVerwijderen.Items.Add(MyReader2.GetString("groepnaam"));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void radiobtnNormal_Checked(object sender, RoutedEventArgs e)
{
comboboxChooseBed.Items.Clear();
comboboxChooseWard.Items.Clear();
try
{
string Query = "select distinct ward_name from user.ward_bed where bed_type='" + "Normal" + "';";
MySqlCommand MyCommand2 = new MySqlCommand(Query, conn);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader();
while (MyReader2.Read())
{
name = MyReader2.GetString(0);
comboboxChooseWard.Items.Add(name);
}
MyReader2.Close();
}
catch
{
}
this.comboboxChooseWard.IsEnabled = true;
}
private void button4_Click(object sender, EventArgs e)
{
try
{
string Query = "SELECT * FROM Users WHERE `Login` LIKE'%" + this.textBox1.Text + "%';";
MySqlConnection MyConn2 = new MySqlConnection(connect);
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader();
this.listBox1.Items.Clear();
while (MyReader2.Read())
{
this.listBox1.Items.Add(MyReader2.GetString("Login"));
}
MyConn2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}