コード例 #1
0
 public static BookingFile GetInfo(string MaBF)
 {
     DataTable dt = ShipBookingData.FillDataTable("spBookingFile_SelectByID", "@MaBF", MaBF);
     BookingFile bf = new BookingFile();
     if (dt.Rows.Count > 0)
     {
         bf.MaBF = dt.Rows[0]["MaBF"].ToString();
         bf.LoaiChuyen = dt.Rows[0]["LoaiChuyen"].ToString();
         bf.NoiDi = dt.Rows[0]["NoiDi"].ToString();
         bf.NoiDen = dt.Rows[0]["NoiDen"].ToString();
         bf.NgayDi = DateTime.Parse(dt.Rows[0]["NgayDi"].ToString());
         bf.NgayVe = DateTime.Parse(dt.Rows[0]["NgayVe"].ToString());
         bf.ThoiGian = dt.Rows[0]["ThoiGian"].ToString();
         bf.OpenChecking = Convert.ToBoolean(dt.Rows[0]["OpenChecking"].ToString());
         bf.LoaiVe = dt.Rows[0]["LoaiVe"].ToString();
         bf.SoGhe = dt.Rows[0]["SoGhe"].ToString();
         bf.GiaTien = dt.Rows[0]["GiaTien"].ToString();
         bf.ThanhToan = dt.Rows[0]["ThanhToan"].ToString();
         bf.MaNguoiNhan = dt.Rows[0]["MaNguoiNhan"].ToString();
         bf.MaHanhTrinh = dt.Rows[0]["HanhTrinh"].ToString();
         bf.GioKhoiHanh = DateTime.Parse(dt.Rows[0]["GioKhoiHanh"].ToString());
         bf.GioDen = DateTime.Parse(dt.Rows[0]["GioDen"].ToString());
         bf.SoVe = dt.Rows[0]["SoVe"].ToString();
     }
     else
     {
         bf = null;
     }
     return bf;
 }
コード例 #2
0
        protected void FillBookingDetailData(string MaBF)
        {
            BookingFile booking = new BookingFile();
            booking = BookingFileDB.GetInfo(MaBF);

            if (booking != null)
            {
                lblBookingID.Text = booking.MaBF.Trim();
                lblLoaiChuyen.Text = booking.LoaiChuyen.Trim();
                lblNoiDi.Text = booking.NoiDi.Trim();
                lblNoiDen.Text = booking.NoiDen.Trim();
                lblNgayDi.Text = booking.NgayDi.ToShortDateString();
                if (booking.LoaiChuyen.Equals("Khứ hồi") == true)
                {
                    lblNgayVeText.Visible = true;
                    lblNgayVe.Visible = true;
                    lblNgayVe.Text = booking.NgayVe.ToShortDateString();
                }
                else
                {
                    lblNgayVeText.Visible = false;
                    lblNgayVe.Visible = false;
                }
                lblGioKhoiHanh.Text = booking.GioKhoiHanh.ToShortTimeString();
                lblGioDen.Text = booking.GioDen.ToShortTimeString();
                lblLoaiVe.Text = booking.LoaiVe.Trim();

                List<HanhKhach> HKList = new List<HanhKhach>();
                HKList = HanhKhachDB.GetListHanhKhachByBookingID(booking.MaBF.Trim());
                string soghe = "";
                for (int i = 0; i < HKList.Count; i++)
                {
                    if (HKList[i].SoGhe.Trim() != "")
                    {
                        soghe = soghe + HKList[i].SoGhe.Trim();
                        if ((i + 1) < HKList.Count)
                        {
                            soghe = soghe + ", ";
                        }
                    }
                }
                lblSoGhe.Text = soghe;
                lblGiaTien.Text = booking.GiaTien.Trim();
            }
        }
コード例 #3
0
        protected void FillNguoiNhanVeData(string MaBF)
        {
            BookingFile booking = new BookingFile();
            booking = BookingFileDB.GetInfo(MaBF);

            if (booking != null)
            {
                string MaNN = "";
                MaNN = booking.MaNguoiNhan.Trim();

                NguoiNhanVe nguoinhan = new NguoiNhanVe();
                nguoinhan = NguoiNhanVeDB.GetInfo(MaNN);

                if (nguoinhan != null)
                {
                    lblMaNN.Text = nguoinhan.MaNguoiNhan.Trim();
                    lblTenNN.Text = nguoinhan.Ten.Trim();
                    lblDiaChiNN.Text = nguoinhan.DiaChi.Trim();
                    lblSoDienThoaiNN.Text = nguoinhan.DienThoai.Trim();
                    lblEmailNN.Text = nguoinhan.Email.Trim();
                    lblYeuCauKhac.Text = nguoinhan.YeuCauKhac.Trim();
                }
            }
        }
コード例 #4
0
        public static List<BookingFile> GetListBookingFileByDate(string date, string hanhtrinh)
        {
            List<BookingFile> BFList = new List<BookingFile>();
            BookingFile BF;
            DataTable dt = ShipBookingData.FillDataTable("spBookingFile_SelectByDate", "@NgayDi", "@HanhTrinh", date, hanhtrinh);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                BF = new BookingFile();
                BF.LoaiChuyen = dt.Rows[i]["LoaiChuyen"].ToString();
                BF.NoiDi = dt.Rows[i]["NoiDi"].ToString();
                BF.NoiDen = dt.Rows[i]["NoiDen"].ToString();
                BF.NgayDi = DateTime.Parse(dt.Rows[i]["NgayDi"].ToString());
                BF.NgayVe = DateTime.Parse(dt.Rows[i]["NgayVe"].ToString());
                BF.ThoiGian = dt.Rows[i]["ThoiGian"].ToString();
                BF.OpenChecking = Convert.ToBoolean(dt.Rows[0]["OpenChecking"].ToString());
                BF.LoaiVe = dt.Rows[i]["LoaiVe"].ToString();
                BF.SoGhe = dt.Rows[i]["SoGhe"].ToString();
                BF.GiaTien = dt.Rows[i]["GiaTien"].ToString();
                BF.ThanhToan = dt.Rows[i]["ThanhToan"].ToString();
                BF.MaNguoiNhan = dt.Rows[i]["MaNguoiNhan"].ToString();
                BF.MaHanhTrinh = dt.Rows[i]["HanhTrinh"].ToString();
                BF.GioKhoiHanh = DateTime.Parse(dt.Rows[i]["GioKhoiHanh"].ToString());
                BF.GioDen = DateTime.Parse(dt.Rows[i]["GioDen"].ToString());
                BF.SoVe = dt.Rows[i]["SoVe"].ToString();

                BFList.Add(BF);
                BF = null;
            }

            return BFList;
        }
コード例 #5
0
 public static void Update(BookingFile bf)
 {
     string[] parameters = new string[] { "@MaBF", "@LoaiChuyen", "@NoiDi", "@NoiDen", "@NgayDi", "@NgayVe", "@ThoiGian", "@OpenChecking", "@LoaiVe", "@SoGhe", "@GiaTien", "@ThanhToan", "@MaNguoiNhan", "@HanhTrinh", "@GioKhoiHanh", "@GioDen", "@SoVe" };
     string[] values = new string[] { bf.MaBF, bf.LoaiChuyen, bf.NoiDi, bf.NoiDen, bf.NgayDi.ToString(), bf.NgayVe.ToString(), bf.ThoiGian, bf.OpenChecking.ToString(), bf.LoaiVe, bf.SoGhe, bf.GiaTien, bf.ThanhToan, bf.MaNguoiNhan, bf.MaHanhTrinh, bf.GioKhoiHanh.ToString(), bf.GioDen.ToString(), bf.SoVe };
     ExecuteData("spBookingFile_UpdateByID", parameters, values);
 }