public bool update(VeXe c) { String sql = "update VeXe set maChuyenDi = @maChuyenDi, maHanhKhach = @maHanhKhach, giaTien = @giaTien where maVeXe = @maVeXe"; SqlParameter p1 = new SqlParameter("@maVeXe", c.MaVeXe); SqlParameter p2 = new SqlParameter("@maChuyenDi", c.MaChuyenDi); SqlParameter p3 = new SqlParameter("@maHanhKhach", c.MaHanhKhach); SqlParameter p4 = new SqlParameter("@giaTien", c.GiaTien); SqlParameter[] param = { p1, p2, p3, p4 }; return(manager.executeUpdate(sql, param)); }
private void btnAdd_Click(object sender, EventArgs e) { if (lblSoGheTrong.Text == "0") { MessageBox.Show("Đã hết vé! Không thể thêm"); return; } string maVeXe = txtMaVeXe.Text.Trim(); string maChuyenDi = cbbMaChuyenDi.Text.Trim(); string maHanhKhach = cbbMaHanhKhach.Text.Trim(); decimal giaTien = Convert.ToDecimal(txtGiaTien.Text.Trim()); VeXe m = new VeXe(maVeXe, maChuyenDi, maHanhKhach, giaTien); addVeXe(m); }
public bool add(VeXe c) { try { String sql = "insert into VeXe values(@maVeXe, @maChuyenDi, @maHanhKhach, @giaTien)"; SqlParameter p1 = new SqlParameter("@maVeXe", c.MaVeXe); SqlParameter p2 = new SqlParameter("@maChuyenDi", c.MaChuyenDi); SqlParameter p3 = new SqlParameter("@maHanhKhach", c.MaHanhKhach); SqlParameter p4 = new SqlParameter("@giaTien", c.GiaTien); SqlParameter[] param = { p1, p2, p3, p4 }; return(manager.executeUpdate(sql, param)); } catch (Exception e) { return(false); } }
private void addVeXe(VeXe m) { try { bool kq = veXeDB.add(m); if (kq) { ClearInput(); MessageBox.Show("Them thanh cong"); } else { MessageBox.Show("Them ko thanh cong"); } } catch (Exception e) { MessageBox.Show("Khong the thuc hien duoc: " + e.Message); } }
public List <VeXe> getAll() { String sql = "select * from VeXe"; DataTable table = manager.executeQuery(sql); List <VeXe> list = new List <VeXe>(); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; string maVeXe = (string)row["maVeXe"]; string maChuyenDi = (string)row["maChuyenDi"]; string maHanhKhach = (string)row["maHanhKhach"]; decimal giaTien = (decimal)row["giaTien"]; VeXe c = new VeXe(maVeXe, maChuyenDi, maHanhKhach, giaTien); list.Add(c); } return(list); }