public static TinhTrangChuyen GetInfo(string HanhTrinh) { DataTable dt = ShipBookingData.FillDataTable("spTinhTrangChuyen_SelectByID", "@HanhTrinh", HanhTrinh); TinhTrangChuyen obj = new TinhTrangChuyen(); if (dt.Rows.Count > 0) { obj.HanhTrinh = dt.Rows[0]["HanhTrinh"].ToString(); obj.TinhTrang = dt.Rows[0]["TinhTrang"].ToString(); obj.MaTPDi = dt.Rows[0]["MaTPDi"].ToString(); obj.MaTPDen = dt.Rows[0]["MaTPDen"].ToString(); obj.GiaVe1 = dt.Rows[0]["GiaVe1"].ToString(); obj.GiaVe2 = dt.Rows[0]["GiaVe2"].ToString(); obj.GiaVe3 = dt.Rows[0]["GiaVe3"].ToString(); obj.GiaVe1_TreEm = dt.Rows[0]["GiaVe1_TreEm"].ToString(); obj.GiaVe2_TreEm = dt.Rows[0]["GiaVe2_TreEm"].ToString(); obj.GiaVe3_TreEm = dt.Rows[0]["GiaVe3_TreEm"].ToString(); obj.MaSoTau = dt.Rows[0]["MaSoTau"].ToString(); obj.SoLuongVe1 = dt.Rows[0]["SoLuongVe1"].ToString(); obj.SoLuongVe2 = dt.Rows[0]["SoLuongVe2"].ToString(); obj.SoLuongVe3 = dt.Rows[0]["SoLuongVe3"].ToString(); obj.GioKhoiHanh_Thu2 = DateTime.Parse(dt.Rows[0]["GioKhoiHanh_Thu2"].ToString()); obj.GioKhoiHanh_Thu3 = DateTime.Parse(dt.Rows[0]["GioKhoiHanh_Thu3"].ToString()); obj.GioKhoiHanh_Thu4 = DateTime.Parse(dt.Rows[0]["GioKhoiHanh_Thu4"].ToString()); obj.GioKhoiHanh_Thu5 = DateTime.Parse(dt.Rows[0]["GioKhoiHanh_Thu5"].ToString()); obj.GioKhoiHanh_Thu6 = DateTime.Parse(dt.Rows[0]["GioKhoiHanh_Thu6"].ToString()); obj.GioKhoiHanh_Thu7 = DateTime.Parse(dt.Rows[0]["GioKhoiHanh_Thu7"].ToString()); obj.GioKhoiHanh_ChuNhat = DateTime.Parse(dt.Rows[0]["GioKhoiHanh_ChuNhat"].ToString()); obj.GioDen_Thu2 = DateTime.Parse(dt.Rows[0]["GioDen_Thu2"].ToString()); obj.GioDen_Thu3 = DateTime.Parse(dt.Rows[0]["GioDen_Thu3"].ToString()); obj.GioDen_Thu4 = DateTime.Parse(dt.Rows[0]["GioDen_Thu4"].ToString()); obj.GioDen_Thu5 = DateTime.Parse(dt.Rows[0]["GioDen_Thu5"].ToString()); obj.GioDen_Thu6 = DateTime.Parse(dt.Rows[0]["GioDen_Thu6"].ToString()); obj.GioDen_Thu7 = DateTime.Parse(dt.Rows[0]["GioDen_Thu7"].ToString()); obj.GioDen_ChuNhat = DateTime.Parse(dt.Rows[0]["GioDen_ChuNhat"].ToString()); obj.SoGhe = dt.Rows[0]["SoGhe"].ToString(); } else { obj = null; } return obj; }
protected void GetBookingData() { bf.LoaiChuyen = rblLoaiHanhTrinh.SelectedItem.Text; if (ddlNoiDen.Items.Count > 0) { bf.NoiDi = ddlNoiDi.SelectedItem.Text; } else { return; } if (ddlNoiDi.Items.Count > 0) { bf.NoiDen = ddlNoiDen.SelectedItem.Text; } else { return; } bf.NgayDi = DateTime.Parse(txtNgayDi.Text.Trim()); if (rblLoaiHanhTrinh.SelectedValue == "KhuHoi") { if (CheckDateNgayVe() == true) { bf.NgayVe = DateTime.Parse(txtNgayVe.Text.Trim()); } else { return; } } else { bf.NgayVe = DateTime.Parse(txtNgayDi.Text.Trim()); } bf.ThoiGian = ddlThoiGian.SelectedItem.Text; if (chkOpen.Checked == true) { bf.OpenChecking = true; } else { bf.OpenChecking = false; } bf.LoaiVe = ddlLoaiVe.SelectedItem.Text; if (rdbSoGhe.SelectedItem != null) { bf.SoGhe = rdbSoGhe.SelectedItem.Text; } else { bf.SoGhe = ""; } string strHanhTrinh = GetHanhTrinh(); TinhTrangChuyen obj = new TinhTrangChuyen(); obj = TinhTrangChuyenDB.GetInfo(strHanhTrinh); if (ddlLoaiVe.SelectedValue == "HangThuong") { bf.GiaTien = obj.GiaVe1; } else if (ddlLoaiVe.SelectedValue == "HangDoanhNhan") { bf.GiaTien = obj.GiaVe2; } else { bf.GiaTien = obj.GiaVe3; } bf.HanhTrinh = strHanhTrinh; }
protected void FillHanhTrinhInfoData() { ListItem item; string strHanhTrinh = GetHanhTrinh(); TinhTrangChuyen HanhTrinhInfo = new TinhTrangChuyen(); HanhTrinhInfo = TinhTrangChuyenDB.GetInfo(strHanhTrinh); List<BookingFile> BFList = new List<BookingFile>(); BFList = BookingFileDB.GetListBookingFileByDate(txtNgayDi.Text.Trim(), strHanhTrinh); if (HanhTrinhInfo != null) { #region Điền dữ liệu giờ khởi hành - giờ kết thúc if (CheckDateNgayDi() == true) { DateTime dt = DateTime.Parse(txtNgayDi.Text.Trim()); switch (dt.DayOfWeek) { case DayOfWeek.Monday: { if (HanhTrinhInfo.GioKhoiHanh_Thu2 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioKhoiHanh.Text = ""; ResetRdbSoGhe(); } else { lblGioKhoiHanh.Text = HanhTrinhInfo.GioKhoiHanh_Thu2.ToShortTimeString(); } if (HanhTrinhInfo.GioDen_Thu2 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioDen.Text = ""; ResetRdbSoGhe(); return; } else { lblGioDen.Text = HanhTrinhInfo.GioDen_Thu2.ToShortTimeString(); } } break; case DayOfWeek.Tuesday: { if (HanhTrinhInfo.GioKhoiHanh_Thu3 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioKhoiHanh.Text = ""; ResetRdbSoGhe(); } else { lblGioKhoiHanh.Text = HanhTrinhInfo.GioKhoiHanh_Thu3.ToShortTimeString(); } if (HanhTrinhInfo.GioDen_Thu3 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioDen.Text = ""; ResetRdbSoGhe(); return; } else { lblGioDen.Text = HanhTrinhInfo.GioDen_Thu3.ToShortTimeString(); } } break; case DayOfWeek.Wednesday: { if (HanhTrinhInfo.GioKhoiHanh_Thu4 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioKhoiHanh.Text = ""; ResetRdbSoGhe(); } else { lblGioKhoiHanh.Text = HanhTrinhInfo.GioKhoiHanh_Thu4.ToShortTimeString(); } if (HanhTrinhInfo.GioDen_Thu4 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioDen.Text = ""; ResetRdbSoGhe(); return; } else { lblGioDen.Text = HanhTrinhInfo.GioDen_Thu4.ToShortTimeString(); } } break; case DayOfWeek.Thursday: { if (HanhTrinhInfo.GioKhoiHanh_Thu5 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioKhoiHanh.Text = ""; ResetRdbSoGhe(); } else { lblGioKhoiHanh.Text = HanhTrinhInfo.GioKhoiHanh_Thu5.ToShortTimeString(); } if (HanhTrinhInfo.GioDen_Thu5 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioDen.Text = ""; ResetRdbSoGhe(); return; } else { lblGioDen.Text = HanhTrinhInfo.GioDen_Thu5.ToShortTimeString(); } } break; case DayOfWeek.Friday: { if (HanhTrinhInfo.GioKhoiHanh_Thu6 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioKhoiHanh.Text = ""; ResetRdbSoGhe(); } else { lblGioKhoiHanh.Text = HanhTrinhInfo.GioKhoiHanh_Thu6.ToShortTimeString(); } if (HanhTrinhInfo.GioDen_Thu6 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioDen.Text = ""; ResetRdbSoGhe(); return; } else { lblGioDen.Text = HanhTrinhInfo.GioDen_Thu6.ToShortTimeString(); } } break; case DayOfWeek.Saturday: { if (HanhTrinhInfo.GioKhoiHanh_Thu7 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioKhoiHanh.Text = ""; ResetRdbSoGhe(); } else { lblGioKhoiHanh.Text = HanhTrinhInfo.GioKhoiHanh_Thu7.ToShortTimeString(); } if (HanhTrinhInfo.GioDen_Thu7 == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioDen.Text = ""; ResetRdbSoGhe(); return; } else { lblGioDen.Text = HanhTrinhInfo.GioDen_Thu7.ToShortTimeString(); } } break; case DayOfWeek.Sunday: { if (HanhTrinhInfo.GioKhoiHanh_ChuNhat == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioKhoiHanh.Text = ""; ResetRdbSoGhe(); } else { lblGioKhoiHanh.Text = HanhTrinhInfo.GioKhoiHanh_ChuNhat.ToShortTimeString(); } if (HanhTrinhInfo.GioDen_ChuNhat == DateTime.Parse("1/1/1900 12:00:00 AM")) { lblGioDen.Text = ""; ResetRdbSoGhe(); return; } else { lblGioDen.Text = HanhTrinhInfo.GioDen_ChuNhat.ToShortTimeString(); } } break; default: break; } } else { ResetRdbSoGhe(); lblGioKhoiHanh.Text = ""; lblGioDen.Text = ""; return; } #endregion #region Điền dữ liệu số lượng vé switch (ddlLoaiVe.SelectedValue) { case "HangThuong": { int count = 0; int SoLuongVeConLai = 0; lblGiaVe.Text = HanhTrinhInfo.GiaVe1.Trim() + " VNĐ"; for (int i = 0; i < BFList.Count; i++) { if (BFList[i].LoaiVe.Equals("Hạng thường") == true) { count += 1; } } SoLuongVeConLai = Convert.ToInt16(HanhTrinhInfo.SoLuongVe1); SoLuongVeConLai -= count; if (SoLuongVeConLai > 0) { lblSoLuongVe.Text = Convert.ToString(SoLuongVeConLai) + " vé"; lblSoLuongVe.ForeColor = Color.Blue; } else { lblSoLuongVe.Text = "Đã hết vé"; lblSoLuongVe.ForeColor = Color.Red; return; } } break; case "HangDoanhNhan": { int count = 0; int SoLuongVeConLai = 0; lblGiaVe.Text = HanhTrinhInfo.GiaVe2.Trim() + " VNĐ"; for (int i = 0; i < BFList.Count; i++) { if (BFList[i].LoaiVe.Equals("Hạng doanh nhân") == true) { count += 1; } } SoLuongVeConLai = Convert.ToInt16(HanhTrinhInfo.SoLuongVe2); SoLuongVeConLai -= count; if (SoLuongVeConLai > 0) { lblSoLuongVe.Text = Convert.ToString(SoLuongVeConLai) + " vé"; lblSoLuongVe.ForeColor = Color.Blue; } else { lblSoLuongVe.Text = "Đã hết vé"; lblSoLuongVe.ForeColor = Color.Red; return; } } break; case "HangVIP": { int count = 0; int SoLuongVeConLai = 0; lblGiaVe.Text = HanhTrinhInfo.GiaVe3.Trim() + " VNĐ"; for (int i = 0; i < BFList.Count; i++) { if (BFList[i].LoaiVe.Equals("Hạng VIP") == true) { count += 1; } } SoLuongVeConLai = Convert.ToInt16(HanhTrinhInfo.SoLuongVe3); SoLuongVeConLai -= count; if (SoLuongVeConLai > 0) { lblSoLuongVe.Text = Convert.ToString(SoLuongVeConLai) + " vé"; lblSoLuongVe.ForeColor = Color.Blue; } else { lblSoLuongVe.Text = "Đã hết vé"; lblSoLuongVe.ForeColor = Color.Red; return; } } break; default: break; } #endregion #region Điền tất cả các ghế trên chuyến tàu int SoGhe = 0; SoGhe = Convert.ToInt16(HanhTrinhInfo.SoGhe.Trim()); for (int i = 1; i <= SoGhe; i++) { item = new ListItem(); item.Text = Convert.ToString(i); item.Value = Convert.ToString(i); rdbSoGhe.Items.Add(item); item = null; } //Remove những ghế đã được chọn trong ngày int SoGheDaDat = 0; for (int i = 1; i <= SoGhe; i++) { item = new ListItem(); item.Text = Convert.ToString(i); item.Value = Convert.ToString(i); for (int j = 0; j < BFList.Count; j++) { SoGheDaDat = Convert.ToInt16(BFList[j].SoGhe.Trim()); if (i == SoGheDaDat) { rdbSoGhe.Items.Remove(item); } } item = null; } #endregion } lblMsg.Text = ""; }
public static void Update(TinhTrangChuyen obj) { string[] parameters = new string[] { "@HanhTrinh", "@TinhTrang", "@MaTPDi", "@MaTPDen", "@GiaVe1", "@GiaVe2", "@GiaVe3", "@GiaVe1_TreEm", "@GiaVe2_TreEm", "@GiaVe3_TreEm", "@MaSoTau", "@SoLuongVe1", "@SoLuongVe2", "@SoLuongVe3", "@GioKhoiHanh_Thu2", "@GioKhoiHanh_Thu3", "@GioKhoiHanh_Thu4", "@GioKhoiHanh_Thu5", "@GioKhoiHanh_Thu6", "@GioKhoiHanh_Thu7", "@GioKhoiHanh_ChuNhat", "@GioDen_Thu2", "@GioDen_Thu3", "@GioDen_Thu4", "@GioDen_Thu5", "@GioDen_Thu6", "@GioDen_Thu7", "@GioDen_ChuNhat", "@SoGhe" }; string[] values = new string[] { obj.HanhTrinh, obj.TinhTrang, obj.MaTPDi, obj.MaTPDen, obj.GiaVe1, obj.GiaVe2, obj.GiaVe3, obj.GiaVe1_TreEm, obj.GiaVe2_TreEm, obj.GiaVe3_TreEm, obj.MaSoTau, obj.SoLuongVe1, obj.SoLuongVe2, obj.SoLuongVe3, obj.GioKhoiHanh_Thu2.ToString(), obj.GioKhoiHanh_Thu3.ToString(), obj.GioKhoiHanh_Thu4.ToString(), obj.GioKhoiHanh_Thu5.ToString(), obj.GioKhoiHanh_Thu6.ToString(), obj.GioKhoiHanh_Thu7.ToString(), obj.GioKhoiHanh_ChuNhat.ToString(), obj.GioDen_Thu2.ToString(), obj.GioDen_Thu3.ToString(), obj.GioDen_Thu4.ToString(), obj.GioDen_Thu5.ToString(), obj.GioDen_Thu6.ToString(), obj.GioDen_Thu7.ToString(), obj.GioDen_ChuNhat.ToString(), obj.SoGhe }; ExecuteData("spTinhTrangChuyen_UpdateByID", parameters, values); }