bool CheckInputChuyenBay(ChuyenBay CB)
{
if (string.IsNullOrEmpty(CB.MaChuyenBay))
{
lbNotify.ForeColor = Color.Red;
lbNotify.Text = "Mã Chuyến Bay chưa được nhập";
return(false);
}
if (string.IsNullOrEmpty(CB.DonGia.ToString()))
{
lbNotify.ForeColor = Color.Red;
lbNotify.Text = "Đơn Giá chưa được nhập";
return(false);
}
if (string.IsNullOrEmpty(CB.MaSanBayDi))
{
lbNotify.ForeColor = Color.Red;
lbNotify.Text = "Mã Sân Bay Đi chưa được nhập";
return(false);
}
if (string.IsNullOrEmpty(CB.MaSanBayDen))
{
lbNotify.ForeColor = Color.Red;
lbNotify.Text = "Mã Sân Bay Đến chưa được nhập";
return(false);
}
if (CB.MaSanBayDi == CB.MaSanBayDen)
{
lbNotify.ForeColor = Color.Red;
lbNotify.Text = "Mã Sân Bay Đi không được trùng Mã Sân Bay Đến";
return(false);
}
if (string.IsNullOrEmpty(CB.NgayGio.ToString()))
{
lbNotify.ForeColor = Color.Red;
lbNotify.Text = "Ngày Giờ chưa được nhập";
return(false);
}
/* if(checkDateTimeFormat(CB.NgayGio.ToString()))
* {
* lbNotify.ForeColor = Color.Red;
* lbNotify.Text = "Bạn nhập sai định dạng ngày giờ";
* return false;
* } */
if (string.IsNullOrEmpty(CB.ThoiGianBay.ToString()))
{
lbNotify.ForeColor = Color.Red;
lbNotify.Text = "Thời Gian Bay chưa được nhập";
return(false);
}
if ((TimeSpan.Parse(CB.ThoiGianBay.ToString()).Hours * 60 + TimeSpan.Parse(CB.ThoiGianBay.ToString()).Minutes) < bllTS.getThoiGianBayToiThieu())
{
lbNotify.ForeColor = Color.Red;
lbNotify.Text = "Thời gian bay nhỏ hơn thời gian bay tối thiểu";
return(false);
}
lbNotify.ForeColor = Color.FromArgb(8, 186, 29);
return(true);
}
public static bool UpdateChuyenBay(ChuyenBay chuyenBay)
{
string cmdText = string.Format("UPDATE CHUYENBAY SET MaTB= {0},DonGia= {1},ThoiGian= '{2}',ThoiLuong= {3},SLGheTrong= {4},SLGheDat= {5} WHERE MaCB = {6}", chuyenBay.TB.maTB, chuyenBay.DonGia, chuyenBay.ThoiGian.ToString("MM/dd/yyyy HH:mm:ss"), chuyenBay.ThoiLuong, chuyenBay.SoGheTrong, chuyenBay.SoGheDat, chuyenBay.maCB);
bool update = DataProvider.ExecuteNonQuery(cmdText);
return(update);
}
public bool UpdateChuyenBay(ChuyenBay CB)
{
string sql = "UPDATE CHUYENBAY SET MaChuyenBay = @MaChuyenBay, DonGia = @DonGia, MaSanBayDi = @MaSanBayDi, MaSanBayDen = @MaSanBayDen," +
" NgayGio = @NgayGio, ThoiGianBay = @ThoiGianBay WHERE MaChuyenBay = @MaChuyenBay";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MaChuyenBay", SqlDbType.VarChar).Value = CB.MaChuyenBay;
cmd.Parameters.Add("@DonGia", SqlDbType.Money).Value = CB.DonGia;
cmd.Parameters.Add("@MaSanBayDen", SqlDbType.VarChar).Value = CB.MaSanBayDen;
cmd.Parameters.Add("@MaSanBayDi", SqlDbType.VarChar).Value = CB.MaSanBayDi;
cmd.Parameters.Add("@NgayGio", SqlDbType.DateTime).Value = CB.NgayGio;
cmd.Parameters.Add("@ThoiGianBay", SqlDbType.VarChar).Value = (CB.ThoiGianBay).ToString();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Thông báo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
return(true);
}
public static bool InsertChuyenBay(ChuyenBay chuyenBay)
{
string cmdText = string.Format("INSERT INTO CHUYENBAY(MaTB,DonGia,ThoiGian,ThoiLuong,SLGheTrong,SLGheDat) VALUES ({0},{1},'{2}',{3},{4},{5})", chuyenBay.TB.maTB, chuyenBay.DonGia, chuyenBay.ThoiGian.ToString("MM/dd/yyyy HH:mm:ss"), chuyenBay.ThoiLuong, 0, chuyenBay.SoGheDat);
bool insert = DataProvider.ExecuteNonQuery(cmdText);
return(insert);
}
public frmFlightEditing(ChuyenBay cb)
{
onloading = true;
chuyenBay = cb;
InitializeComponent();
checkState();
loadData();
cthvs = BLL_CTHV.GetCTHVs(chuyenBay.maCB);
ctcbs = BLL_CTCB.GetCTCBs(chuyenBay.maCB);
tbMaCB.Text = chuyenBay.strMaCB;
nGiaVe.Value = chuyenBay.DonGia;
cbSBDi.SelectedValue = chuyenBay.TB.SBDi.maSB;
cbSBDen.SelectedValue = chuyenBay.TB.SBDen.maSB;
dtpNgay.Value = chuyenBay.ThoiGian;
dtpGio.Value = chuyenBay.ThoiGian;
nTGBayH.Value = chuyenBay.ThoiLuong / 60;
nTGBayM.Value = chuyenBay.ThoiLuong % 60;
nSLGhe1.Value = cthvs[0].SLGhe;
nSLGhe2.Value = cthvs[1].SLGhe;
// thông tin chuyến bay trung gian
loaddgv();
//TuyenBay tb = new TuyenBay();
//int donGia = Convert.ToInt32(nGiaVe.Value);
//DateTime tg = dtpNgay.Value.Date + dtpGio.Value.TimeOfDay;
//int tl = Convert.ToInt32(nTGBayH.Value * 60 + nTGBayM.Value);
//int sg = Convert.ToInt32(nSLGhe1.Value + nSLGhe2.Value);
}
public void insertChuyenBay(ChuyenBay CB)
{
string sql = "insert into CHUYENBAY(MaChuyenBay, DonGia, MaSanBayDen, MaSanBayDi, NgayGio, ThoiGianBay)" +
" VALUES(@MaChuyenBay, @DonGia, @MaSanBayDen, @MaSanBayDi, @NgayGio, @ThoiGianBay)";
using (SqlConnection con = dc.getConnect())
{
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MaChuyenBay", SqlDbType.VarChar).Value = CB.MaChuyenBay;
cmd.Parameters.Add("@DonGia", SqlDbType.Money).Value = CB.DonGia;
cmd.Parameters.Add("@MaSanBayDen", SqlDbType.VarChar).Value = CB.MaSanBayDen;
cmd.Parameters.Add("@MaSanBayDi", SqlDbType.VarChar).Value = CB.MaSanBayDi;
cmd.Parameters.Add("@NgayGio", SqlDbType.DateTime).Value = CB.NgayGio;
cmd.Parameters.Add("@ThoiGianBay", SqlDbType.VarChar).Value = (CB.ThoiGianBay).ToString();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Thông báo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
ChuyenBay chuyenbay = GetInfo();
onAdd?.Invoke(chuyenbay);
onEdit?.Invoke(chuyenbay);
this.Close();
}
public FightInfoDetail(ChuyenBay chuyenbay)
{
InitializeComponent();
lblAirport.Text = chuyenbay.HangHangKhong;
lblStart.Text = chuyenbay.DiemKhoiHanh;
lblFinish.Text = chuyenbay.DiemDen;
lblLimit.Text = chuyenbay.SoLuongKhach.ToString();
}
public int Update(ChuyenBay ChuyenBay)
{
string sql = string.Format("Update ChuyenBay Set HangHangKhong=N'{1}', DiemKhoiHanh=N'{2}', DiemDen=N'{3}', SoLuongKhach={4} Where MaChuyenBay='{0}'",
ChuyenBay.MaChuyenBay, ChuyenBay.HangHangKhong, ChuyenBay.DiemKhoiHanh, ChuyenBay.DiemDen, ChuyenBay.SoLuongKhach);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public ActionResult Create(ChuyenBay collection)
{
if (ModelState.IsValid)
{
_dbContext.ChuyenBays.Add(collection);
_dbContext.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View());
}
public Add_EditFightInfo(ChuyenBay chuyenbay)
{
InitializeComponent();
id = chuyenbay.MaChuyenBay;
txtHangHangKhong.Text = chuyenbay.HangHangKhong;
txtDiemKhoiHanh.Text = chuyenbay.DiemKhoiHanh;
txtDiemDen.Text = chuyenbay.DiemDen;
txtSoLuongKhach.Text = chuyenbay.SoLuongKhach.ToString();
btnConfirm.Text = "Cập nhật";
}
private ChuyenBay GetInfo()
{
ChuyenBay inf = new ChuyenBay();
inf.MaChuyenBay = id;
inf.HangHangKhong = txtHangHangKhong.Text;
inf.DiemKhoiHanh = txtDiemKhoiHanh.Text;
inf.DiemDen = txtDiemDen.Text;
inf.SoLuongKhach = int.Parse(txtSoLuongKhach.Text);
return(inf);
}
ChuyenBay SetInfoFlightFromDataGridView()
{
ChuyenBay CB = new ChuyenBay();
CB.MaChuyenBay = DataGrid_DanhSachChuyenBay.Rows[Index].Cells[2].Value.ToString();
CB.DonGia = decimal.Parse(DataGrid_DanhSachChuyenBay.Rows[Index].Cells[3].Value.ToString());
CB.MaSanBayDi = DataGrid_DanhSachChuyenBay.Rows[Index].Cells[4].Value.ToString();
CB.MaSanBayDen = DataGrid_DanhSachChuyenBay.Rows[Index].Cells[5].Value.ToString();
CB.NgayGio = DateTime.Parse(DataGrid_DanhSachChuyenBay.Rows[Index].Cells[6].Value.ToString());
CB.ThoiGianBay = TimeSpan.Parse(DataGrid_DanhSachChuyenBay.Rows[Index].Cells[7].Value.ToString());
return(CB);
}
private void ucFightInfo_DetailClick(object sender, EventArgs e)
{
ChuyenBay chuyenbay = new ChuyenBay();
chuyenbay.MaChuyenBay = ucFightInfo.GridView.CurrentRow.Cells[0].Value.ToString();
chuyenbay.HangHangKhong = ucFightInfo.GridView.CurrentRow.Cells[1].Value.ToString();
chuyenbay.DiemKhoiHanh = ucFightInfo.GridView.CurrentRow.Cells[2].Value.ToString();
chuyenbay.DiemDen = ucFightInfo.GridView.CurrentRow.Cells[3].Value.ToString();
chuyenbay.SoLuongKhach = (int)ucFightInfo.GridView.CurrentRow.Cells[4].Value;
FightInfoDetail frm = new FightInfoDetail(chuyenbay);
frm.ShowDialog();
}
private void btnOK_Click(object sender, EventArgs e)
{
if (chuyenBay == null)
{
chuyenBay = new ChuyenBay();
}
chuyenBay.TB = currentTB;
chuyenBay.DonGia = Convert.ToInt32(nGiaVe.Value);
chuyenBay.ThoiGian = new DateTime(dtpNgay.Value.Year, dtpNgay.Value.Month, dtpNgay.Value.Day, dtpGio.Value.Hour, dtpGio.Value.Minute, 0);
chuyenBay.ThoiLuong = Convert.ToInt32(nTGBayH.Value * 60 + nTGBayM.Value);
chuyenBay.SoGheTrong = Convert.ToInt32(nSLGhe1.Value + nSLGhe2.Value);
if (chuyenBay.DonGia <= 10000)
{
lbNoti.Text = "Giá vé phải lớn hơn 10000";
lbNoti.Visible = true;
return;
}
if (chuyenBay.TB == null)
{
lbNoti.Text = "Bạn cần phải chọn sân bay đi và sân bay đến";
lbNoti.Visible = true;
return;
}
if (chuyenBay.ThoiGian < DateTime.Now)
{
lbNoti.Text = "Thời gian xuất phát không hợp lệ";
lbNoti.Visible = true;
return;
}
if (chuyenBay.ThoiLuong < ThamSo.TGBayToiThieu)
{
lbNoti.Text = "Thời gian bay tối thiểu là " + ThamSo.TGBayToiThieu + " phút";
lbNoti.Visible = true;
return;
}
cthvs[0].SLGheTrong = Convert.ToInt32(nSLGhe1.Value);
cthvs[1].SLGheTrong = Convert.ToInt32(nSLGhe2.Value);
cthvs[0].GiaVe = Convert.ToInt32(chuyenBay.DonGia * hvs[0].TiLe);
cthvs[1].GiaVe = Convert.ToInt32(chuyenBay.DonGia * hvs[1].TiLe);
cthvs[0].SLGhe = Convert.ToInt32(nSLGhe1.Value);
cthvs[1].SLGhe = Convert.ToInt32(nSLGhe2.Value);
button1.PerformClick();
}
public async Task <IActionResult> OnGetAsync(string id)
{
if (id == null)
{
return(NotFound());
}
ChuyenBay = await _context.ChuyenBay.FirstOrDefaultAsync(m => m.ChuyenBayId == id);
if (ChuyenBay == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(string id)
{
if (id == null)
{
return(NotFound());
}
ChuyenBay = await _context.ChuyenBay.FindAsync(id);
if (ChuyenBay != null)
{
_context.ChuyenBay.Remove(ChuyenBay);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public static List <ChuyenBay> SearchTenSBDen(string tenSBDen)
{
string cmdText = String.Format("select * from CHUYENBAY inner join TUYENBAY on CHUYENBAY.MATB = TUYENBAY.MATB inner join SANBAY on TUYENBAY.MASBDEN = SANBAY.MASB where SANBAY.TENSB like N'%{0}%'", tenSBDen);
DataTable dt = DataProvider.ExecuteReader(cmdText);
if (dt != null && dt.Rows.Count > 0)
{
List <ChuyenBay> chuyenBay = new List <ChuyenBay>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ChuyenBay cb = new ChuyenBay((int)dt.Rows[i]["MaCB"], DAL_TuyenBay.GetTuyenBay((int)dt.Rows[i]["MaTB"]), (int)dt.Rows[i]["DonGia"], (DateTime)dt.Rows[i]["ThoiGian"], (int)dt.Rows[i]["ThoiLuong"], (int)dt.Rows[i]["SLGheTrong"], (int)dt.Rows[i]["SLGheDat"]);
chuyenBay.Add(cb);
}
return(chuyenBay);
}
return(null);
}
public static List <ChuyenBay> SearchThoiLuong(string thoiLuong)
{
string cmdText = String.Format("select * from CHUYENBAY where ThoiLuong like '%{0}%'", thoiLuong == "" ? thoiLuong : DataProvider.ConvertToInt(thoiLuong));
DataTable dt = DataProvider.ExecuteReader(cmdText);
if (dt != null && dt.Rows.Count > 0)
{
List <ChuyenBay> chuyenBay = new List <ChuyenBay>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ChuyenBay cb = new ChuyenBay((int)dt.Rows[i]["MaCB"], DAL_TuyenBay.GetTuyenBay((int)dt.Rows[i]["MaTB"]), (int)dt.Rows[i]["DonGia"], (DateTime)dt.Rows[i]["ThoiGian"], (int)dt.Rows[i]["ThoiLuong"], (int)dt.Rows[i]["SoGheTrong"], (int)dt.Rows[i]["SoGheDat"]);
chuyenBay.Add(cb);
}
return(chuyenBay);
}
return(null);
}
public static List <ChuyenBay> GetChuyenBays()
{
string cmdText = @"select * from CHUYENBAY";
DataTable dt = DataProvider.ExecuteReader(cmdText);
if (dt != null && dt.Rows.Count > 0)
{
List <ChuyenBay> chuyenBay = new List <ChuyenBay>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ChuyenBay cb = new ChuyenBay((int)dt.Rows[i]["MaCB"], DAL_TuyenBay.GetTuyenBay((int)dt.Rows[i]["MaTB"]), (int)dt.Rows[i]["DonGia"], (DateTime)dt.Rows[i]["ThoiGian"], (int)dt.Rows[i]["ThoiLuong"], (int)dt.Rows[i]["SLGheTrong"], (int)dt.Rows[i]["SLGheDat"]);
chuyenBay.Add(cb);
}
return(chuyenBay);
}
return(null);
}
public async Task <IActionResult> Create([Bind("id_ChuyenBay,MaChuyenBay,NgayBay,id_LichBay,GhiChu")] ChuyenBay chuyenBay, int id_MayBay, int?ve0 = 0, int?ve1 = 0, int?ve2 = 0)
{
if (ModelState.IsValid)
{
chuyenBay.ChiTietChuyenBay = new List <ChiTietChuyenBay>();
//tim may bay cua chuyen bay nay cung voi chi tiet ghe tren no
IList <ChiTietGhe> DsGhe = _context.ChiTietGhe.Where(s => s.id_MayBay == id_MayBay).ToList();
foreach (var item in DsGhe)
{
//add chitietchuyenbay
chuyenBay.ChiTietChuyenBay.Add(new ChiTietChuyenBay()
{
id_ChuyenBay = chuyenBay.id_ChuyenBay, id_ChiTietGhe = item.id_ChiTietGhe
});
}
_context.Add(chuyenBay);
await _context.SaveChangesAsync();
var DsChiTiet = _context.ChiTietChuyenBay.Where(s => s.id_ChuyenBay == chuyenBay.id_ChuyenBay).Include(s => s.ChiTietGhe).ToList();
foreach (var item in DsChiTiet)
{
BangGia BGia = new BangGia();
BGia.id_ChiTietChuyenBay = item.id_ChiTietChuyenBay;
BGia.NgayNhap = DateTime.Today;
if (item.ChiTietGhe.id_HangVe == 1)
{
BGia.Gia = ve0;
}
if (item.ChiTietGhe.id_HangVe == 2)
{
BGia.Gia = ve1;
}
if (item.ChiTietGhe.id_HangVe == 3)
{
BGia.Gia = ve2;
}
_context.BangGia.Add(BGia);
await _context.SaveChangesAsync();
}
return(RedirectToAction(nameof(Index)));
}
ViewData["id_LichBay"] = new SelectList(_context.LichBay, "id_LichBay", "id_LichBay", chuyenBay.id_LichBay);
return(View(chuyenBay));
}
public int Insert(ChuyenBay ChuyenBay)
{
string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLBanvechuyenbay;Integrated Security=True";
SqlConnection conn = new SqlConnection(path);
string sql = string.Format("Select MAX(MaChuyenBay) From ChuyenBay");
SqlCommand command = new SqlCommand(sql, conn);
conn.Open();
var rd = command.ExecuteReader();
string tmp = "";
if (rd.Read())
{
tmp = rd.GetString(0);
}
conn.Close();
int id = int.Parse(tmp.Remove(0, 2));
id++;
tmp = "CB";
if (id < 10)
{
tmp += "00";
}
else if (id < 100)
{
tmp += "0";
}
tmp += id;
sql = string.Format("Insert into ChuyenBay(MaChuyenBay, HangHangKhong, DiemKhoiHanh, DiemDen, SoLuongKhach, DaXoa) Values('{0}','{1}',N'{2}',N'{3}','{4}','{5}')",
tmp, ChuyenBay.HangHangKhong, ChuyenBay.DiemKhoiHanh, ChuyenBay.DiemDen, ChuyenBay.SoLuongKhach, ChuyenBay.DaXoa);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public ActionResult Edit(ChuyenBay model)
{
try
{
var oldItem = _dbContext.ChuyenBays.Find(model.ID);
oldItem.ID = model.ID;
oldItem.MaChuyenBay = model.MaChuyenBay;
oldItem.MayBayID = model.MayBayID;
oldItem.SanBayDen_ID = model.SanBayDen_ID;
oldItem.SanBayDi_ID = model.SanBayDi_ID;
oldItem.SoGhe_Hang1 = model.SoGhe_Hang1;
oldItem.SoGhe_Hang2 = model.SoGhe_Hang2;
oldItem.ThoiGianDuKienBay = model.ThoiGianDuKienBay;
_dbContext.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public async Task <IActionResult> Edit([Bind("id_ChuyenBay,MaChuyenBay,NgayBay,id_LichBay,GhiChu")] ChuyenBay chuyenBay)
{
if (ModelState.IsValid)
{
try
{
_context.Update(chuyenBay);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ChuyenBayExists(chuyenBay.id_ChuyenBay))
{
return(NotFound());
}
else
{
throw;
}
}
}
return(RedirectToAction(nameof(Index)));
}
public int Update(ChuyenBay cb)
{
return(chuyenbayDAO.Update(cb));
}
private void Frm_onEdit(ChuyenBay chuyenbay)
{
thongtinchuyenbay.Update(chuyenbay);
ReloadData();
}
private void Frm_onAdd(ChuyenBay chuyenbay)
{
thongtinchuyenbay.Insert(chuyenbay);
ReloadData();
}
public int Insert(ChuyenBay cb)
{
return(chuyenbayDAO.Insert(cb));
}
private void btn_Excel_Click(object sender, EventArgs e)
{
Excel.Application ExcelObj = new Excel.Application();
OpenFileDialog dlg = new OpenFileDialog();
dlg.Filter = "Excel files|*.xls; *.xlsx";
if (dlg.ShowDialog() == DialogResult.OK)
{
Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open(dlg.FileName, 0, true, 5,
"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true);
Excel.Sheets sheets = theWorkbook.Worksheets;
Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1);
Excel.Range UsedRange = worksheet.UsedRange;
int lastUsedRow = UsedRange.Row + UsedRange.Rows.Count - 1;
for (int i = 2; i <= lastUsedRow; i++)
{
ChuyenBay CB = new ChuyenBay();
DanhSachGhe DSG = new DanhSachGhe();
SanBayTrungGian SBTG = new SanBayTrungGian();
if (!string.IsNullOrEmpty(worksheet.Cells[i, 1].Value))
{
CB.MaChuyenBay = worksheet.Cells[i, 1].Value.ToString();
CB.DonGia = decimal.Parse(worksheet.Cells[i, 2].Value.ToString());
CB.MaSanBayDi = worksheet.Cells[i, 3].Value.ToString();
CB.MaSanBayDen = worksheet.Cells[i, 4].Value.ToString();
CB.NgayGio = DateTime.Parse(worksheet.Cells[i, 5].Value.ToString());
CB.ThoiGianBay = TimeSpan.Parse(worksheet.Cells[i, 6].Value.ToString());
if (!bllCB.CheckTrungChuyenBay(CB.MaChuyenBay))
{
if (CheckInputChuyenBay(CB))
{
bllCB.InsertChuyenBay(CB);
}
else
{
return;
}
}
}
if (!string.IsNullOrEmpty(worksheet.Cells[i, 7].Value))
{
DSG.MaChuyenBay = worksheet.Cells[i, 7].Value.ToString();
DSG.HangVe = worksheet.Cells[i, 8].Value.ToString();
DSG.TongSoGhe = Int32.Parse(worksheet.Cells[i, 9].Value.ToString());
DSG.SoGheTrong = DSG.TongSoGhe;
if (!bllDSG.CheckTrungDanhSachGhe(DSG.MaChuyenBay, DSG.HangVe))
{
if (CheckInputDanhSachGhe(DSG))
{
bllDSG.InsertDanhSachGhe(DSG);
}
else
{
return;
}
}
}
if (!string.IsNullOrEmpty(worksheet.Cells[i, 10].Value))
{
SBTG.MaChuyenBay = worksheet.Cells[i, 10].Value.ToString();
SBTG.MaSanBay = worksheet.Cells[i, 11].Value.ToString();
SBTG.ThoiGianDung = TimeSpan.Parse(worksheet.Cells[i, 12].Value.ToString());
SBTG.GhiChu = worksheet.Cells[i, 13].Value.ToString();
if (!bllSBTG.CheckTrungSanBayTrungGian(SBTG.MaChuyenBay, SBTG.MaSanBay))
{
if (CheckIntputSanBayTrungGian(SBTG))
{
bllSBTG.InsertSanBayTrungGian(SBTG);
}
else
{
return;
}
}
}
}
}
lbNotify.Visible = true;
lbNotify.ForeColor = Color.Green;
lbNotify.Text = "Đã Thêm Danh Sách Các Chuyến Bay Từ File Excel Thành Công";
}
// Tra ve mot doi tuong khi biet khoa
public ChuyenBay FindEntity(string maCB)
{
ChuyenBay dbEntry = context.ChuyenBays.Find(maCB);
return(dbEntry);
}
