private void SOCreation_Load(object sender, EventArgs e)
{
mc = new MyConnection();
mc.conn.Open();
cmd = new OleDbCommand("select CID from Customer where CStatus='Active';", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr["CID"]);
}
cmd = new OleDbCommand("select PModel from Products;", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox2.Items.Add(dr["PModel"]);
}
mc.conn.Close();
}
private void Customer_Load(object sender, EventArgs e)
{
mc = new MyConnection();
mc.conn.Open();
if (selection == "add")
{
this.Text = "Add Customer";
textBox11.Text = "Inactive";
textBox11.ReadOnly = true;
comboBox2.Visible = false;
mc = new MyConnection();
mc.conn.Open();
cmd = new OleDbCommand("select GrpName from CusGroup;", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr["GrpName"]);
}
}
else if (selection == "approve")
{
this.Text = "Approve Customer";
cmd = new OleDbCommand("select CID from Customer where CStatus='Inactive';", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox2.Items.Add(dr["CID"]);
}
mc.conn.Close();
button2.Text = "Approve";
textBox1.Visible = false;
comboBox2.Visible = true;
comboBox1.Enabled = false;
textBox2.ReadOnly = true;
textBox3.ReadOnly = true;
textBox4.ReadOnly = true;
textBox5.ReadOnly = true;
textBox6.ReadOnly = true;
textBox7.ReadOnly = true;
textBox8.ReadOnly = true;
textBox9.ReadOnly = true;
textBox10.ReadOnly = true;
textBox11.ReadOnly = true;
}
else if (selection == "search")
{
this.Text = "Search Customer";
button1.Visible = false;
button2.Visible = false;
button3.Visible = false;
textBox1.Visible = false;
comboBox2.Visible = true;
comboBox1.Enabled = false;
textBox2.ReadOnly = true;
textBox3.ReadOnly = true;
textBox4.ReadOnly = true;
textBox5.ReadOnly = true;
textBox6.ReadOnly = true;
textBox7.ReadOnly = true;
textBox8.ReadOnly = true;
textBox9.ReadOnly = true;
textBox10.ReadOnly = true;
textBox11.ReadOnly = true;
cmd = new OleDbCommand("select CID from Customer;", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox2.Items.Add(dr["CID"]);
}
}
else if (selection == "update")
{
this.Text = "Update Customer";
button2.Text = "Update";
cmd = new OleDbCommand("select CID from Customer;", mc.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox2.Items.Add(dr["CID"]);
}
textBox1.Visible = false;
comboBox1.Enabled = false;
textBox2.ReadOnly = false;
textBox3.ReadOnly = false;
textBox4.ReadOnly = false;
textBox5.ReadOnly = false;
textBox6.ReadOnly = false;
textBox7.ReadOnly = false;
textBox8.ReadOnly = false;
textBox9.ReadOnly = false;
textBox10.ReadOnly = false;
textBox11.ReadOnly = true;
}
mc.conn.Close();
}
