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