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