private void bt_ok_Click(object sender, EventArgs e)
{
Customer customer = new Customer(tb_name.Text, tb_bien_so_xe.Text, textBox_phone.Text, bt_idCard.Text, textBox_CMNN.Text, dateTimePicker1.Text, dateTimePicker2.Text);
Query_Data_MySQL.insertCustomer(customer);
Display();
bt_ok.Visible = false;
}
private void viewCustomerInfoToolStripMenuItem_Click(object sender, EventArgs e)
{
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView2.DataSource = Query_Data_MySQL.getInfStatus(id).Tables[0];
dataGridView2.Visible = true;
input.Visible = false;
Gb_search.Visible = false;
}
private void update_Click(object sender, EventArgs e)
{
Customer customer = new Customer(tb_name.Text, tb_bien_so_xe.Text, textBox_phone.Text, bt_idCard.Text, textBox_CMNN.Text, dateTimePicker1.Text, dateTimePicker2.Text);
String message = Query_Data_MySQL.updateCustomer(customer, id);// xoa thông tin cua 1 khach hàng;
MessageBox.Show(message);
Display();
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult thongbao;
thongbao = MessageBox.Show("Bạn Có Muốn Xóa Hay Không?", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (thongbao == DialogResult.OK)
{
String query = "delete from customer1 where id = '" + id + "'";
String message = Query_Data_MySQL.deleteCustomer(query);// xoa thông tin cua 1 khach hàng;
MessageBox.Show(message);
}
Display();
}
private void timer1_Tick(object sender, EventArgs e)
{
if (serialPort1.IsOpen == true)
{
try
{
String ketqua = "";
try
{
id_card = serialPort1.ReadExisting();
if (id_card.Length != 0)
{
nhay_toi_day_khi_di_vao: // label goto
if (id_card.Length == 11)
{
id_card = id_card.Substring(0, 8);
string sql = "Select * from customer1 where Id_card= '" + id_card + "'";
int customer_id = getID(sql);
String query = "SELECT status.id FROM status where customer_id = '" + customer_id + "' and status.status_customer = 0 ";
int statusID = getID(query);
if (statusID != 0)
{
String message = Query_Data_MySQL.updateStatus(getID(query));
serialPort1.WriteLine("#2:Good bye!|"); //dieu khien servo mo cua
}
else
{
goto nhay_toi_day_khi_di_vao;
}
}
else
{
if (Query_Data_MySQL.checkPark())
{
serialPort1.WriteLine("#3:Sorry!Da het cho dau!|"); //dieu khien servo mo cua
return;
}
id_card = id_card.Substring(0, 8);
using (SqlConnection conn = new SqlConnection(ConnecttionString.connecttionString))
{
conn.Open();
try
{
// String query = "SELECT status.id FROM status INNER JOIN customer1 ON customer1.Id_card = '" + id_card + "' and status.status_customer = 0 ";
// if (getID(query) == 0)
string sql = "Select * from customer1 where Id_card= '" + id_card + "'";
// Tạo một đối tượng Command.
SqlCommand cmd = new SqlCommand(sql, conn);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
// Chỉ số (index) của cột ID trong câu lệnh SQL.
int Index_id = reader.GetOrdinal("id"); //
int id = reader.GetInt32(Index_id);
int startTime = reader.GetOrdinal("Start_Time"); //
DateTime startTimeKH = reader.GetDateTime(startTime);
// Chỉ số (index) của cột Emp_ID trong câu lệnh SQL.
int endTime = reader.GetOrdinal("End_Time");
DateTime endTimeKH = reader.GetDateTime(endTime);
if (checkActive(startTimeKH, endTimeKH))
{
serialPort1.WriteLine("#3:The da het han!|"); //dieu khien servo mo cua
break;
}
String query = "SELECT status.id FROM status where customer_id = '" + id + "' and status.status_customer = 0 ";
// Chỉ số (index) của cột Emp_ID trong câu lệnh SQL.
if (getID(query) != 0)
{
serialPort1.WriteLine("#3:Xe Dang Gui!|");
conn.Close();
return;
}
// them vao bang trang thai
String message = Query_Data_MySQL.insertStatus(id);
ListViewItem LVItem = new ListViewItem(stt.ToString());
// Chỉ số (index) của cột Emp_ID trong câu lệnh SQL.
int nameIndex = reader.GetOrdinal("Name"); // 0
// Cột Emp_No có index = 1.
string name = reader.GetString(nameIndex);
ListViewItem.ListViewSubItem LVSItem1 = new ListViewItem.ListViewSubItem(LVItem, name);
int id_theIndex = reader.GetOrdinal("Bien_so_xe"); // 2
string id_the = reader.GetString(id_theIndex);
ListViewItem.ListViewSubItem LVSItem2 = new ListViewItem.ListViewSubItem(LVItem, id_the);
int phone = reader.GetOrdinal("Phone");// 2
string phoneString = reader.GetString(phone);
ListViewItem.ListViewSubItem LVSItem3 = new ListViewItem.ListViewSubItem(LVItem, phoneString);
int cmnn = reader.GetOrdinal("CMNN");// 2
string cmnnString = reader.GetString(cmnn);
ListViewItem.ListViewSubItem LVSItem4 = new ListViewItem.ListViewSubItem(LVItem, cmnnString);
LVItem.SubItems.Add(LVSItem1);
LVItem.SubItems.Add(LVSItem2);
LVItem.SubItems.Add(LVSItem3);
LVItem.SubItems.Add(LVSItem4);
listView1.Items.Add(LVItem);
ketqua = name + "," + id_the;
stt++;
}
}
}
if (ketqua.Length >= 5)
{
serialPort1.WriteLine("#1:" + ketqua + "|"); //dieu khien servo mo cua
}
else
{
serialPort1.WriteLine("#3:Chua Dang Ky!|"); //dieu khien servo mo cua
}
}
catch (Exception en)
{
serialPort1.WriteLine("#3:Chua Dang Ky123!|"); //dieu khien servo mo cua
}
conn.Close();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
catch (Exception)
{
MessageBox.Show("hello pham duy thanh");
}
}
}
public void Display1Customer(String cmnn)
{
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.DataSource = Query_Data_MySQL.get1Customer(cmnn).Tables[0];
}
public void Display()
{
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.DataSource = Query_Data_MySQL.getAllCustomer().Tables[0];
}