private void button1_Click(object sender, EventArgs e)
{
textBox1.Text = "";
comboBox1.SelectedIndex = -1;
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection();
string myConnectionString;
myConnectionString = "server=127.0.0.1;"
+ "uid=root;"
+ "pwd=root;"
+ "SslMode=none;"
+ "database=db";
var a = new EquipmentUI();
a.dataGridView1.DefaultCellStyle.SelectionBackColor = a.dataGridView1.DefaultCellStyle.BackColor;
a.dataGridView1.DefaultCellStyle.SelectionForeColor = a.dataGridView1.DefaultCellStyle.ForeColor;
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks FROM items ", conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection();
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].Visible = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh();
}
}
}
}
}
private void Form3_Load(object sender, EventArgs e)
{
var a = new EquipmentUI();
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection();
string myConnectionString;
myConnectionString = "server=127.0.0.1;"
+ "uid=root;"
+ "pwd=root;"
+ "SslMode=none;"
+ "database=db";
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks,category.description,items.description,items.isDeployable,items.isDamaged,items.isOnrepair,items.isRented,items.isDeployed,items.isDamagedBeyondRepair FROM items left join category on items.categoryID = category.id where items.id =" + EquipmentUI.sendtext, conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
MySqlDataReader myreader = cmd.ExecuteReader();
if (myreader.Read())
{
Label2.Text = myreader.GetValue(1).ToString();
Label4.Text = myreader.GetValue(3).ToString();
Label8.Text = myreader.GetValue(2).ToString();
if (myreader.GetValue(4).ToString() == "")
{
Label6.Text = "Not specified";
}
else
{
Label6.Text = myreader.GetValue(4).ToString();
}
Label13.Text = myreader.GetValue(5).ToString();
Label14.Text = myreader.GetValue(6).ToString();
Label15.Text = myreader.GetValue(7).ToString();
Label16.Text = myreader.GetValue(8).ToString();
dep.Text = myreader.GetValue(9).ToString();
dbr.Text = myreader.GetValue(10).ToString();
this.Text = myreader.GetValue(1).ToString();
}
myreader.Close();
}
}
}
conn.Close();
}
public void Form1_Load(object sender, EventArgs e)
{
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection();
string myConnectionString;
myConnectionString = "server=127.0.0.1;"
+ "uid=root;"
+ "pwd=root;"
+ "SslMode=none;"
+ "database=db";
var a = new EquipmentUI();
dataGridView1.DefaultCellStyle.SelectionBackColor = dataGridView1.DefaultCellStyle.BackColor;
dataGridView1.DefaultCellStyle.SelectionForeColor = dataGridView1.DefaultCellStyle.ForeColor;
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks FROM items ", conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.ReadOnly = false;
dataGridView1.ClearSelection();
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[3].HeaderCell.Value = "Name";
dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[4].HeaderCell.Value = "Stock";
dataGridView1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[1].HeaderCell.Value = "";
dataGridView1.Columns[1].Width = 50;
dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[0].HeaderCell.Value = "";
dataGridView1.Columns[0].Width = 50;
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
}
}
}
private void Form3_Load(object sender, EventArgs e)
{
dataGridView1.ClearSelection();
dataGridView2.ClearSelection();
dataGridView3.ClearSelection();
dataGridView4.ClearSelection();
var a = new EquipmentUI();
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection();
string myConnectionString;
myConnectionString = "server=127.0.0.1;"
+ "uid=root;"
+ "pwd=root;"
+ "SslMode=none;"
+ "database=db";
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks,category.description,items.description,items.isDeployable,items.isDamaged,items.isOnrepair,items.isRented,items.isDeployed,items.isDamagedBeyondRepair FROM items left join category on items.categoryID = category.id where items.id =" + EquipmentUI.sendtext, conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
MySqlDataReader myreader = cmd.ExecuteReader();
if (myreader.Read())
{
Label2.Text = myreader.GetValue(1).ToString();
Label4.Text = myreader.GetValue(3).ToString();
if (myreader.GetValue(4).ToString() == "")
{
Label6.Text = "Not specified";
}
else
{
Label6.Text = myreader.GetValue(4).ToString();
}
this.Text = myreader.GetValue(1).ToString();
}
myreader.Close();
}
}
}
conn.Close();
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,itemcontent.modelNumber,itemcontent.id from items left join itemcontent on items.id = itemcontent.itemID where items.id =" + EquipmentUI.sendtext + " and itemcontent.tagID < 2", conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.ClearSelection();
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[3].HeaderCell.Value = "Name / Model Number";
dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[3].DefaultCellStyle.ForeColor = Color.Black;
dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[1].HeaderCell.Value = "";
dataGridView1.Columns[1].Width = 50;
dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[0].HeaderCell.Value = "";
dataGridView1.Columns[0].Width = 50;
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
}
}
conn.Close();
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,itemcontent.modelNumber,itemcontent.id,damagelogs.datedamaged from items left join itemcontent on items.id = itemcontent.itemID inner JOIN damagelogs on itemcontent.id = damagelogs.itemid where items.id =" + EquipmentUI.sendtext + " and itemcontent.tagID = 2 and damagelogs.datedamaged != '0000-00-00'", conn))
{ //SELECT damagelogs.daterdamaged,itemcontent.modelNumber from repairlogs inner JOIN itemcontent on itemcontent.id = repairlogs.itemID where itemcontent.itemID = " + EquipmentUI.sendtext + " and repairlogs.daterepaired != '0000-00-00'
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
dataGridView2.DefaultCellStyle.SelectionBackColor = Color.Transparent;
dataGridView2.DefaultCellStyle.SelectionForeColor = Color.Transparent;
dataGridView2.DataSource = dt;
dataGridView2.ClearSelection();
dataGridView2.Columns[1].Visible = false;
dataGridView2.Columns[3].Visible = false;
dataGridView2.Columns[2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.Columns[2].HeaderCell.Value = "Name / Model Number";
dataGridView2.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.Columns[2].DefaultCellStyle.ForeColor = Color.Black;
dataGridView2.Columns[4].DefaultCellStyle.ForeColor = Color.Black;
dataGridView2.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.Columns[1].HeaderCell.Value = "";
dataGridView2.Columns[1].Width = 50;
dataGridView2.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.Columns[0].HeaderCell.Value = "";
dataGridView2.Columns[0].Width = 100;
dataGridView2.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.Columns[4].HeaderCell.Value = "Date & Time";
dataGridView2.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
}
}
}
conn.Close();
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,itemcontent.modelNumber,itemcontent.id from items left join itemcontent on items.id = itemcontent.itemID where items.id =" + EquipmentUI.sendtext + " and itemcontent.tagID = 3", conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
dataGridView3.DataSource = dt;
dataGridView3.ClearSelection();
dataGridView3.Columns[1].Visible = false;
dataGridView3.Columns[3].Visible = false;
dataGridView3.Columns[2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView3.Columns[2].HeaderCell.Value = "Name / Model Number";
dataGridView3.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView3.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView3.Columns[1].HeaderCell.Value = "";
dataGridView3.Columns[1].Width = 50;
dataGridView3.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView3.Columns[0].HeaderCell.Value = "";
dataGridView3.Columns[0].Width = 100;
dataGridView3.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
}
}
conn.Close();
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con2 = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd2 = new MySql.Data.MySqlClient.MySqlCommand("SELECT repairlogs.daterepaired,itemcontent.modelNumber from repairlogs inner JOIN itemcontent on itemcontent.id = repairlogs.itemID where itemcontent.itemID = " + EquipmentUI.sendtext + " and repairlogs.daterepaired != '0000-00-00'", conn))
{
cmd2.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd2))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
dataGridView4.DataSource = dt;
dataGridView4.ClearSelection();
dataGridView4.Columns[1].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView4.Columns[1].HeaderCell.Value = "Name / Model Number";
dataGridView4.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView4.Columns[1].DefaultCellStyle.ForeColor = Color.Black;
dataGridView4.Columns[0].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView4.Columns[0].HeaderCell.Value = "Date & Time";
dataGridView4.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView4.Columns[0].DefaultCellStyle.ForeColor = Color.Black;
dataGridView4.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView4.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
}
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
var a = new EquipmentUI();
var t = int.Parse(comboBox1.SelectedIndex.ToString());
var i = t + 1;
if (comboBox1.Text.Equals(""))
{
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection();
string myConnectionString;
myConnectionString = "server=127.0.0.1;"
+ "uid=root;"
+ "pwd=root;"
+ "SslMode=none;"
+ "database=db";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor;
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks FROM items where items.name like '%" + textBox1.Text + "%'", conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection();
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh();
}
}
}
}
}
if (comboBox1.Text != "")
{
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection();
string myConnectionString;
myConnectionString = "server=127.0.0.1;"
+ "uid=root;"
+ "pwd=root;"
+ "SslMode=none;"
+ "database=db";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor;
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks,items.categoryID FROM items where items.name like '%" + textBox1.Text + "%' and items.categoryID=" + i, conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection();
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh();
}
}
}
}
}
if (comboBox1.Text.Equals(""))
{
var a1 = "";
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection();
string myConnectionString;
myConnectionString = "server=127.0.0.1;"
+ "uid=root;"
+ "pwd=root;"
+ "SslMode=none;"
+ "database=db";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor;
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name FROM items where items.name like '%" + textBox1.Text + "%' ", conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection();
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh();
}
}
}
}
}
if (comboBox1.Text != "" && textBox1.Text != "")
{
var a1 = "";
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection();
string myConnectionString;
myConnectionString = "server=127.0.0.1;"
+ "uid=root;"
+ "pwd=root;"
+ "SslMode=none;"
+ "database=db";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor;
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name FROM items where items.name like '%" + textBox1.Text + "%' and items.categoryID=" + i, conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection();
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
// (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].HeaderCell.Value = "Stock";
//(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh();
}
}
}
}
}
if (comboBox1.Text != "" && textBox1.Text == "")
{
var a1 = "";
MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection();
string myConnectionString;
myConnectionString = "server=127.0.0.1;"
+ "uid=root;"
+ "pwd=root;"
+ "SslMode=none;"
+ "database=db";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor;
conn.ConnectionString = myConnectionString;
conn.Open();
using (MySqlConnection con = new MySqlConnection(myConnectionString))
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name FROM items where items.categoryID=" + i, conn))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection();
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].HeaderCell.Value = "Stock";
// (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = "";
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh();
}
}
}
}
}
}
