public static NguoiNhanVe GetInfo(string MaNguoiNhan)
 {
     DataTable dt = ShipBookingData.FillDataTable("spNguoiNhan_SelectByID", "@MaNguoiNhan", MaNguoiNhan);
     NguoiNhanVe NguoiNhan = new NguoiNhanVe();
     if (dt.Rows.Count > 0)
     {
         NguoiNhan.MaNguoiNhan = dt.Rows[0]["MaNguoiNhan"].ToString();
         NguoiNhan.Ten = dt.Rows[0]["Ten"].ToString();
         NguoiNhan.DiaChi = dt.Rows[0]["DiaChi"].ToString();
         NguoiNhan.MaThanhPho = dt.Rows[0]["MaThanhPho"].ToString();
         NguoiNhan.DienThoai = dt.Rows[0]["DienThoai"].ToString();
         NguoiNhan.Email = dt.Rows[0]["Email"].ToString();
         NguoiNhan.YeuCauKhac = dt.Rows[0]["YeuCauKhac"].ToString();
         NguoiNhan.ThoiGianGiaoVe = dt.Rows[0]["ThoiGianGiaoVe"].ToString();
     }
     else
     {
         NguoiNhan = null;
     }
     return NguoiNhan;
 }
        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();
                }
            }
        }
 public static void Update(NguoiNhanVe NguoiNhan)
 {
     string[] parameters = new string[] { "@MaNguoiNhan", "@Ten", "@DiaChi", "@MaThanhPho", "@DienThoai", "@Email", "@YeuCauKhac", "@ThoiGianGiaoVe" };
     string[] values = new string[] { NguoiNhan.MaNguoiNhan, NguoiNhan.Ten, NguoiNhan.DiaChi, NguoiNhan.MaThanhPho, NguoiNhan.DienThoai, NguoiNhan.Email, NguoiNhan.YeuCauKhac, NguoiNhan.ThoiGianGiaoVe };
     ExecuteData("spNguoiNhan_UpdateByID", parameters, values);
 }