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);
}
