public FormThanhToan(string tenphong, int sotang) { InitializeComponent(); lbsotang.Text = sotang.ToString(); lbtenphong.Text = tenphong; laytenphong = tenphong; HotelObject.ThuePhongHo tp = new HotelObject.ThuePhongHo(); ChuanHoa ch = new ChuanHoa(); HotelObject.SuDungDichVuHo sd = new HotelObject.SuDungDichVuHo(); string year, month, day, ngayvao = null; string year1, month1, day1, ngayra = null; lbhoten.Text = conn.LayBien("EXEC PROC_SELECT_TENKHACHHANG N'" + lbtenphong.Text + "'", 0); lbloaiphong.Text = conn.LayBien("EXEC PROC_SELECT_LOAIPHONG N'" + lbtenphong.Text + "'", 0); tp.NgayVao = conn.LayBien("EXEC PROC_SELECT_NGAYVAO N'" + lbtenphong.Text + "'", 0); tp.NgayRa = conn.LayBien("EXEC PROC_SELECT_NGAYRA N'" + lbtenphong.Text + "'", 0); ch.ChuanHoaDate(tp.NgayRa, out day, out month, out year); ch.ChuanHoaDate(tp.NgayVao, out day1, out month1, out year1); lbngayvao.Text = day1 + " / " + month1 + " / " + year1; lbngayra.Text = day + " / " + month + " / " + year; string giatien = conn.LayBien("EXEC PROC_SELECT_GIATIEN N'" + lbtenphong.Text + "'", 0); string tongtientt = ch.TongTien(ngayra, ngayvao, Int32.Parse(giatien)); sd.DonGia = conn.LayBien("EXEC PROC_SELECT_DONGIADV N'" + lbtenphong.Text + "'", 0); if (sd.DonGia == "") { sd.DonGia = "0"; } lbdichvu.Text = sd.DonGia.ToString(); TimeSpan time = DateTime.Parse(tp.NgayRa) - DateTime.Parse(tp.NgayVao); int dayz = time.Days + 1; lbthanhtien.Text = (Int32.Parse(tongtientt) * dayz).ToString(); lbtongtien.Text = (Int32.Parse(sd.DonGia) + (Int32.Parse(tongtientt) * dayz)).ToString(); }
public void ThanhToan(Label lbtenphong, Label lbhoten, Label lbloaiphong, Label lbngayvao, Label lbngayra, Label lbthanhtien, Label lbdichvu, Label lbtongtien) { HotelObject.ThanhToanHo tt = new HotelObject.ThanhToanHo(); HotelObject.ThuePhongHo tp = new HotelObject.ThuePhongHo(); HotelObject.SuDungDichVuHo sd = new HotelObject.SuDungDichVuHo(); string year, month, day, ngayvao = null; string year1, month1, day1, ngayra = null; string yearnow, monthnow, daynow; lbhoten.Text = conn.LayBien("EXEC PROC_SELECT_TENKHACHHANG N'" + lbtenphong.Text + "'", 0); lbloaiphong.Text = conn.LayBien("EXEC PROC_SELECT_LOAIPHONG N'" + lbtenphong.Text + "'", 0); tp.NgayVao = conn.LayBien("EXEC PROC_SELECT_NGAYVAO N'" + lbtenphong.Text + "'", 0); tp.NgayRa = conn.LayBien("EXEC PROC_SELECT_NGAYRA N'" + lbtenphong.Text + "'", 0); tp.MaThue = conn.LayBien("EXEC PROC_SELECT_MATHUE N'" + lbtenphong.Text + "'", 0); ch.ChuanHoaDate(tp.NgayRa, out day, out month, out year); ch.ChuanHoaDate(tp.NgayVao, out day1, out month1, out year1); ch.ChuanHoaDate(DateTime.Now.ToString(), out daynow, out monthnow, out yearnow); lbngayvao.Text = day + " / " + month + " / " + year; lbngayra.Text = day1 + " / " + month1 + " / " + year1; string giatien = conn.LayBien("EXEC PROC_SELECT_GIATIEN N'" + lbtenphong.Text + "'", 0); string tongtientt = ch.TongTien(ngayra, ngayvao, Int32.Parse(giatien)); sd.DonGia = conn.LayBien("EXEC PROC_SELECT_DONGIADV N'" + lbtenphong.Text + "'", 0); if (sd.DonGia == "") { sd.DonGia = "0"; } lbdichvu.Text = sd.DonGia.ToString(); TimeSpan time = DateTime.Parse(tp.NgayRa) - DateTime.Parse(tp.NgayVao); int dayz = time.Days + 1; lbthanhtien.Text = (Int32.Parse(tongtientt) * dayz * 1000).ToString(); lbtongtien.Text = (Int32.Parse(sd.DonGia) + (Int32.Parse(tongtientt) * dayz * 1000)).ToString(); conn.InsertDeleteUpdate("EXEC PROC_INSERT_THANHTOAN '" + tp.MaThue + "','" + giatien + "','" + yearnow + monthnow + daynow + "'"); }