public void load()
{
IphongApiClient client = new IphongApiClient();
try
{
chitietdatphong chitiet = client.getPhongById(idP);
lb_tenp.Text = chitiet.Phong.Name;
lb_lp.Text = chitiet.Phong.LoaiPhong.Mota;
lp_gp.Text = chitiet.Phong.LoaiPhong.Gia.ToString();
txt_songuoidp.Text = chitiet.Phieudatphong.Songuoi.ToString() + "/" + chitiet.Phong.LoaiPhong.SoNguoi.ToString();
txt_ten.Text = chitiet.Phieudatphong.Khachhang.Hoten;
txt_sdt.Text = chitiet.Phieudatphong.Khachhang.Sdt;
txt_socm.Text = chitiet.Phieudatphong.Khachhang.Cmt;
txt_ngayden.Text = chitiet.Phieudatphong.Ngayden.ToString();
rd_kt.Checked = true;
idpdp = chitiet.Id_pdp;
}
catch
{
MessageBox.Show("Xảy ra lỗi mời thử lại");
//this.Hide();
}
}
//Thêm
public void insertChiTietDatPhong(ChiTietDatPhongDTO ctdpDTO)
{
chitietdatphong ctdp = new chitietdatphong();
ctdp.maphieudat = ctdpDTO.Maphieudat;
ctdp.maphong = ctdpDTO.Maphong;
htDataContext.chitietdatphongs.InsertOnSubmit(ctdp);
htDataContext.SubmitChanges();
}
public void LayThongTin()
{
chitiet = client.getPhieuDatPhongById(idpdp);
lb_tenp.Text = chitiet.Phong.Name;
lb_ten.Text = chitiet.Phieudatphong.Khachhang.Hoten;
lb_socm.Text = chitiet.Phieudatphong.Khachhang.Cmt;
lb_ngaytp.Text = DateTime.Now.ToString();
lb_ngaydp.Text = chitiet.Phieudatphong.Ngayden.ToString();
lb_tienphong.Text = chitiet.Phong.LoaiPhong.Gia.ToString();
lb_tc.Text = chitiet.Phieudatphong.Tiendatcoc.ToString();
}
public chitietdatphong getPhongById(int idPhong)
{
chitietdatphong phong = new chitietdatphong();
using (SqlConnection con = new SqlConnection(env.sqlConnectionString))
{
dt.TableName = "phong";
SqlCommand cmd = con.CreateCommand();
string query = "SELECT C.TIENDATCOC AS tiendatcoc, A.name AS name, A.MA_P AS idP,E.MOTA AS lp,E.GIA AS gia,E.SONGUOI AS songuoi,D.HOTEN AS tenkh,D.SDT AS sdt,D.CMT AS cmt,C.MA_PDP AS idpdp,C.SONGUOI AS slthue,C.NGAYDEN AS ngayden FROM dbo.PHONG AS A JOIN dbo.CHITIETDATPHONG AS B ON B.MA_P = A.MA_P JOIN dbo.PHIEUDATPHONG AS C ON C.MA_PDP = B.MA_PDP JOIN dbo.KHACHHANG D ON D.MA_KH = C.MA_KH JOIN dbo.LOAIPHONG AS E ON E.MA_LP = A.MA_LP WHERE C.STATUS=2 AND A.MA_P=@idPhong";
cmd.CommandText = query;
cmd.Parameters.Add("@idPhong", SqlDbType.Int).Value = idPhong;
con.Open();
cmd.ExecuteNonQuery();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
con.Close();
}
var list = (from row in dt.AsEnumerable()
select new chitietdatphong()
{
Id_p = Convert.ToInt32(row["idP"]),
Id_pdp = Convert.ToInt32(row["idpdp"]),
Phong = new phong()
{
Id = Convert.ToInt32(row["idP"]),
Name = row["name"].ToString(),
LoaiPhong = new loaiPhong()
{
Mota = row["lp"].ToString(),
Gia = Convert.ToDouble(row["gia"].ToString()),
Id = Convert.ToInt32(row["songuoi"].ToString()),
},
},
Phieudatphong = new phieudatphong()
{
Id = Convert.ToInt32(row["idpdp"]),
Songuoi = Convert.ToInt32(row["slthue"]),
Ngayden = Convert.ToDateTime(row["ngayden"]),
Tiendatcoc = Convert.ToDouble(row["tiendatcoc"]),
Khachhang = new khachhang()
{
Hoten = row["tenkh"].ToString(),
Sdt = row["sdt"].ToString(),
Cmt = row["cmt"].ToString(),
}
}
}
).ToList();
return(list[0]);
}
//Thêm chi tiết đặt phòng
public int insertChiTietDatPhong(ChiTietDatPhongDTO ctdpDTO)
{
try
{
chitietdatphong ctdp = new chitietdatphong();
ctdp.maphieudat = ctdpDTO.Maphieudat;
ctdp.maphong = ctdpDTO.Maphong;
htDataContext.chitietdatphongs.InsertOnSubmit(ctdp);
htDataContext.SubmitChanges();
return(1);
}
catch
{
return(0);
}
}
//Thêm chi tiết đặt phòng
public int insertChiTietDatPhong(ChiTietDatPhongDTO ctdpDTO)
{
try
{
chitietdatphong ctdp = new chitietdatphong();
ctdp.maphieudat = ctdpDTO.Maphieudat;
ctdp.maphong = ctdpDTO.Maphong;
htDataContext.chitietdatphongs.InsertOnSubmit(ctdp);
htDataContext.SubmitChanges();
return 1;
}
catch
{
return 0;
}
}
