private void comboBoxLoad()
{
MySqlConnection conn = new MySqlConnection(Login.connectionString);
DataSet ds = new DataSet();
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select * from login_details inner join employee on login_details.employeeId=employee.employeeId where login_details.authLevel='Doctor'", conn);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
doctorEntry.DisplayMember = "employeeId";
doctorEntry.ValueMember = "employeeId";
doctorEntry.DataSource = ds.Tables[0];
doctorEntry2.DisplayMember = "employeeId";
doctorEntry2.ValueMember = "employeeId";
doctorEntry2.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
//Exception Message
}
finally
{
conn.Close();
conn.Dispose();
}
string query = "select employee.employeeId,fname,lname from employee inner join login_details on employee.employeeId=login_details.employeeId where login_details.authLevel='Doctor'";
Crud employeeList = new Crud();
employeeList.createTable2(query, doctorList);
Crud employeeList2 = new Crud();
employeeList2.createTable2(query, doctorList2);
}
private void AddGlass_Click(object sender, EventArgs e)
{
int quantity = int.Parse(quantityUpDown.Text);
double cost = 0.0;
cost = Math.Round(Convert.ToDouble(costEntry.Text), 2);
Crud clash = new Crud();
clash.handleClash("glasses", "glassId", "glasses", glassIdEntry);
Glasses addGlass = new Glasses(glassIdEntry.Text, brandEntry.Text, cost, quantity, glassImageEntryBox.Text);
addGlass.addGlasses();
if (glassImageEntryBox.Text == "" || glassImageEntryBox.Text == "glasses.jpg")
{
glassImageEntryBox.Text = "glasses.jpg";
}
else
{
try
{
File.Copy(Crud.fileName, Crud.destination);
}
catch (Exception ex)
{
MessageBox.Show("An error occured while uploading image");
}
}
refreshInputs();
glassImageEntryBox.Text = "glasses.jpg";
Random rnd = new Random();
int glassesId = rnd.Next(1, 9999);
glassIdEntry.Text = "glasses" + glassesId.ToString();
}
private void button19_Click(object sender, EventArgs e)
{
Crud deleteUser = new Crud();
deleteUser.deleteData("login_details", "employeeId", removeUser.Text);
}
private void button14_Click(object sender, EventArgs e)
{
Crud uploadImage = new Crud();
uploadImage.insertImage(profileImage, updateImagePathBox, Login.userProfile);
}
