private void NextStep2Btn_Click(object sender, EventArgs e) //truyen dtoChuyenBay, dtoTuyenBay sang step 2 de loc thong tin ve
{
int hang1 = 0, hang2 = 0;
if (HangVeDrpDwn.Text == "1")
{
hang1 = int.Parse(HangVeDrpDwn.Text);
}
else
{
hang2 = int.Parse(HangVeDrpDwn.Text);
}
dtoChuyenBayXuatPhat = new DTO_ChuyenBay {
NgayGio = XuatPhatDate.Text, ThoiGianBay = XuatPhatTime.Text, SoGheHang1 = hang1, SoGheHang2 = hang2
};
dtoTuyenBayXuatPhat = new DTO_TuyenBay {
SanBayDi = XuatPhatDrDwn.Text, SanBayDen = NoiDenDrpDwn.Text
};
if (KhuHoiCheckBox.Checked)
{
KhuHoi = true;
dtoChuyenBayKhuHoi = new DTO_ChuyenBay {
NgayGio = KhuHoiDate.Text, ThoiGianBay = KhuHoiTime.Text, SoGheHang1 = hang1, SoGheHang2 = hang2
};
dtoTuyenBayKhuHoi = new DTO_TuyenBay {
SanBayDi = NoiDenDrpDwn.Text, SanBayDen = XuatPhatDrDwn.Text
};
}
MessageBox.Show("Vui lòng tới bước 2 để điền thông tin");
}
public DataTable LoadVeMayBayDataGridView(DTO_ChuyenBay dtoChuyenBay, DTO_TuyenBay dtoTuyenBay)
{
DataTable dt = new DataTable();
try
{
OpenConection();
SqlCommand command = new SqlCommand();
command.Parameters.Add(new SqlParameter("@NgayGio", dtoChuyenBay.NgayGio));
command.Parameters.Add(new SqlParameter("@ThoiGianBay", dtoChuyenBay.ThoiGianBay));
command.Parameters.Add(new SqlParameter("@SogheHang1", dtoChuyenBay.SoGheHang1));
command.Parameters.Add(new SqlParameter("@SoGheHang2", dtoChuyenBay.SoGheHang2));
command.Parameters.Add(new SqlParameter("@SanBayDi", dtoTuyenBay.SanBayDi));
command.Parameters.Add(new SqlParameter("@SanBayDen", dtoTuyenBay.SanBayDen));
dt = ShowDataInTableStoredProcedure(command, "SelectVeMayBayXuatPhat");
return(dt);
}
catch
{
return(dt);
}
finally
{
CloseConnection();
}
}
private void Step2Btn_Click(object sender, EventArgs e)
{
ContentBanVePanel.Controls.Clear();
ContentBanVePanel.Controls.Add(step21);
dtoChuyenBayXuatPhat = step21.dtoChuyenBayXuatPhat = step11.dtoChuyenBayXuatPhat;
dtoTuyenBayXuatPhat = step21.dtoTuyenBayXuatPhat = step11.dtoTuyenBayXuatPhat;
KhuHoi = step21.KhuHoi = step11.KhuHoi;
dtoChuyenBayKhuHoi = step21.dtoChuyenBayKhuHoi = step11.dtoChuyenBayKhuHoi;
dtoTuyenBayKhuHoi = step21.dtoTuyenBayKhuHoi = step11.dtoTuyenBayKhuHoi;
step21.Step2_Load();
}
public void LoadDTOEditChuyenBay(DTO_ChiTietChuyenBay dtoChiTieTChuyenBay, DTO_ChuyenBay dtoChuyenBay, DTO_TuyenBay dtoTuyenBay)
{
this.dtoChiTieTChuyenBay = dtoChiTieTChuyenBay;
this.dtoChuyenBay = dtoChuyenBay;
this.dtoTuyenBay = dtoTuyenBay;
ThoiGianDungtext.Text = dtoChiTieTChuyenBay.ThoiGianDung;
MaChuyenBaytext.Text = dtoChuyenBay.MaChuyenBay;
SanBayDentext.Text = dtoTuyenBay.SanBayDen;
SanBayDitext.Text = dtoTuyenBay.SanBayDi;
NgayGioBaytext.Text = dtoChuyenBay.NgayGio;
SanBayTrungGiantext.Text = dtoChiTieTChuyenBay.SanBayTrungGian;
ThoiGianBaytext.Text = dtoChuyenBay.ThoiGianBay;
TenMayBaytext.Text = dtoChuyenBay.TenMayBay;
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtMaTuyenBay.Text.Trim() != "")
{
if (cboSanBayDen.Text.Trim() != "" && cboSanBayDi.Text.Trim() != "")
{
if (cboSanBayDi.Text == cboSanBayDen.Text)
{
MessageBox.Show("Sân bay đến và sân bay đi phải khác nhau!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
dtoTuyenBay = new DTO_TuyenBay(txtMaTuyenBay.Text, cboSanBayDi.SelectedValue.ToString(), cboSanBayDen.SelectedValue.ToString());
if (busTuyenBay.Update(dtoTuyenBay))
{
MessageBox.Show("Sửa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Sửa không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception a)
{
MessageBox.Show("Sửa không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
TaoLai();
}
}
else
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Vui lòng chọn một hàng trong danh sách!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool Update(DTO_TuyenBay dto)
{
try
{
_con.Open();
string sqlQuery = string.Format("UPDATE TUYENBAY SET MASANBAYDI='{0}', " +
"MASANBAYDEN='{1}' WHERE MATUYENBAY='{2}'",
dto.MaSanBayDi, dto.MaSanBayDen, dto.MaTuyenBay);
SqlCommand cmd = new SqlCommand(sqlQuery, _con);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception a)
{
}
finally
{
_con.Close();
}
return(false);
}
public bool Add(DTO_TuyenBay dto)
{
try
{
string maTuyenBay = TaoMaTuyenBay();
_con.Open();
string sqlQuery = string.Format("INSERT INTO TUYENBAY(MATUYENBAY, MASANBAYDI," +
" MASANBAYDEN) VALUES('{0}', '{1}', '{2}')",
maTuyenBay, dto.MaSanBayDi, dto.MaSanBayDen);
SqlCommand cmd = new SqlCommand(sqlQuery, _con);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception a)
{
}
finally
{
_con.Close();
}
return(false);
}
public bool LoadEditChuyenBay(DTO_ChiTietChuyenBay dtoChiTietChuyenBay, DTO_ChuyenBay dtoChuyenBay, DTO_TuyenBay dtoTuyenBay)
{
if (dalEditChuyenBay.EditChuyenBay(dtoChiTietChuyenBay, dtoChuyenBay, dtoTuyenBay))
{
return(true);
}
else
{
return(false);
}
}
public bool LoadThemMoiChuyenBay(DTO_ChiTietChuyenBay dtoChiTietChuyenBay, DTO_ChuyenBay dtoChuyenBay, DTO_TuyenBay dtoTuyenBay)
{
if (dalThemChuyenBay.ThemChuyenBay(dtoChiTietChuyenBay, dtoChuyenBay, dtoTuyenBay))
{
return(true);
}
else
{
return(false);
}
}
public bool Update(DTO_TuyenBay dto)
{
return(dal.Update(dto));
}
public bool Add(DTO_TuyenBay dto)
{
return(dal.Add(dto));
}
public DataTable LoadVeMayBayDatagridViewKhuHoi(DTO_ChuyenBay dtoChuyenBay, DTO_TuyenBay dtoTuyenBay)
{
return(dalStep2.LoadVeMayBayDataGridView(dtoChuyenBay, dtoTuyenBay));
}
public bool EditChuyenBay(DTO_ChiTietChuyenBay dtoChiTietChuyenBay, DTO_ChuyenBay dtoChuyenBay, DTO_TuyenBay dtoTuyenBay)
{
try
{
OpenConection();
SqlCommand command = new SqlCommand();
/*command.Parameters.Add(new SqlParameter("@cttbMaChiTietChuyenBay", dtoChiTietChuyenBay.MaChiTietChuyenBay));///
* command.Parameters.Add(new SqlParameter("@tbMaTuyenBay", dtoTuyenBay.MaTuyenBay));//*/
command.Parameters.Add(new SqlParameter("@MaChuyenBay", dtoChuyenBay.MaChuyenBay));
command.Parameters.Add(new SqlParameter("@SanBayDi", dtoTuyenBay.SanBayDi));
command.Parameters.Add(new SqlParameter("@SanBayDen", dtoTuyenBay.SanBayDen));
command.Parameters.Add(new SqlParameter("@NgayGio", dtoChuyenBay.NgayGio));
command.Parameters.Add(new SqlParameter("@ThoiGianBay", dtoChuyenBay.ThoiGianBay));
command.Parameters.Add(new SqlParameter("@ThoiGianDung", dtoChiTietChuyenBay.ThoiGianDung));
command.Parameters.Add(new SqlParameter("@SanBayTrungGian", dtoChiTietChuyenBay.SanBayTrungGian));
command.Parameters.Add(new SqlParameter("@TenMayBay", dtoChuyenBay.TenMayBay));
ExecuteQueriesStoredProcedure(command, "EditChuyenBay");
return(true);
}
catch
{
return(false);
}
finally
{
CloseConnection();
}
}
