//Xoá chuyến bay
public bool XoaVeBay(VBDTO vb)
{
string query = string.Empty;
query += "DELETE FROM [Ve] WHERE [MaVe] = @MaVe";
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@MaVe", vb.MaVe);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
vb.Error = ex.Message.Remove(0, 65).Trim();
con.Close();
return(false);
}
}
}
return(true);
}
//Thêm chuyến bay
public bool ThemVeBay(VBDTO vb)
{
string query = string.Empty;
query += "INSERT INTO [Ve] ([MaVe], [MaHanhKhach], [MaChuyenBay], [MaHangVe]) ";
query += "VALUES (@MaVe,@MaHanhKhach,@MaChuyenBay,@MaHangVe)";
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@MaHanhKhach", vb.MaHanhKhach);
cmd.Parameters.AddWithValue("@MaChuyenBay", vb.MaChuyenBay);
cmd.Parameters.AddWithValue("@MaHangVe", vb.MaHangVe);
cmd.Parameters.AddWithValue("@MaVe", vb.MaVe);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
vb.Error = ex.Message.Remove(0, 65).Trim();
con.Close();
return(false);
}
}
}
return(true);
}
public List <VBDTO> select()
{
string query = string.Empty;
query += "SELECT *";
query += "FROM [VE]";
List <VBDTO> lsVeBay = new List <VBDTO>();
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
VBDTO vb = new VBDTO();
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
vb.MaChuyenBay = reader["MaChuyenBay"].ToString();
vb.MaHanhKhach = reader["MaHanhKhach"].ToString();
vb.MaHangVe = reader["MaHangVe"].ToString();
lsVeBay.Add(vb);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
vb.Error = ex.Message.Remove(0, 65).Trim();
con.Close();
return(null);
}
}
}
return(lsVeBay);
}
private void Luu_button_Click(object sender, EventArgs e)
{
VBDTO vbDTO = new VBDTO();
//2. Kiểm tra data hợp lệ or not
//1. Map data from GUI
vbDTO.MaVe = RandomString(5, true);
vbDTO.MaChuyenBay = MaChuyenBay_comboBox.SelectedValue.ToString();
vbDTO.MaHangVe = HangVe_comboBox.SelectedValue.ToString();
vbDTO.MaHanhKhach = MaHanhKhach_comboBox.SelectedValue.ToString();
//3. Thêm vào DB
bool kq = vbBUS.ThemVeBay(vbDTO);
if (kq == false)
{
MessageBox.Show("Thêm vé bay thất bại" + vbDTO.Error, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Thêm vé bay thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool XoaveBay(VBDTO vb)
{
bool re = vbDAL.XoaVeBay(vb);
return(re);
}
public bool ThemVeBay(VBDTO vb)
{
bool re = vbDAL.ThemVeBay(vb);
return(re);
}
