private void bunifuButton4_Click_1(object sender, EventArgs e) { DTO_vehicle r = new DTO_vehicle(); if (bunifuTextBox1.Text == "" || bunifuTextBox2.Text == "" || bunifuTextBox3.Text == "" || bunifuTextBox4.Text == "" || bunifuDataGridView1.SelectedRows.Count != 1) { MessageBox.Show(" thông tin không chính xác"); } else { r.id_vehicle = bunifuTextBox1.Text; r.type = bunifuTextBox2.Text; r.name = bunifuTextBox3.Text; r.number_seat = Convert.ToInt32(bunifuTextBox4.Text); } try { BLL_vehicle.Instance.edit(r); load(); } catch (Exception l) { MessageBox.Show(" không thanh công"); } }
public void deleteVehicle_DALL(DTO_vehicle s) { string querry = "update Vehicle set id_vehicle = '" + s.id_vehicle + "', type = '" + s.type + "', name = '" + s.name + "', status_vehicle = '" + true + "', number_seat = '" + s.number_seat + "' where id_vehicle = '" + s.id_vehicle + "'"; DB_H.Instance.Ex(querry); }
public void updatevehiclebyid_vehicle(DTO_vehicle s) { string querry = "update Vehicle set id_vehicle = '" + s.id_vehicle + "', type = '" + s.type + "', name = '" + s.name + "', status_vehicle = '" + false + "', number_seat = '" + s.number_seat + "' where id_vehicle = '" + s.id_vehicle + "'"; DB_H.Instance.Ex(querry); }
public void addvehicle_DAL(DTO_vehicle r) { string query = "insert into Vehicle values ('"; query += r.id_vehicle + "', '" + r.type + "', '" + r.name + "', '" + r.number_seat + "','" + false + "');"; DB_H.Instance.Ex(query); }
public List <DTO_vehicle> sort(Compare cmp) { List <DTO_vehicle> data = BLL_vehicle.Instance.getallvehicle(); for (int i = 0; i < data.Count - 1; i++) { for (int j = i + 1; j < data.Count; j++) { if (cmp(data[i], data[j])) { DTO_vehicle t = data[i]; data[i] = data[j]; data[j] = t; } } } return(data); }
public DTO_vehicle Getid_vehicle(string id_vehicle) { if (id_vehicle == null) { return(null); } else { DTO_vehicle s = new DTO_vehicle(); foreach (DTO_vehicle i in DALL_vehicle.Instance.getallvehicle()) { if (i.id_vehicle == id_vehicle) { s = i; } } return(s); } }
private void bunifuButton3_Click_1(object sender, EventArgs e) { if (bunifuTextBox1.Text == "" || bunifuTextBox2.Text == "" || bunifuTextBox3.Text == "" || bunifuTextBox4.Text == "") { MessageBox.Show(" thông tin không đầy đủ"); } else { DTO_vehicle r = new DTO_vehicle(); r.id_vehicle = bunifuTextBox1.Text; r.type = bunifuTextBox2.Text; r.name = bunifuTextBox3.Text; r.number_seat = Convert.ToInt32(bunifuTextBox4.Text); try { BLL_vehicle.Instance.add_vehicle(r); load(); } catch (Exception l) { MessageBox.Show(" không thanh công"); } } }
public void edit(DTO_vehicle s) { DALL_vehicle.Instance.updatevehiclebyid_vehicle(s); }
public void add_vehicle(DTO_vehicle s) { DALL_vehicle.Instance.addvehicle_DAL(s); }