// GET: DSPhongs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var dsphong = db.DSPhongs.ToList();
var khachhang = db.KhachHangs.ToList();
var chitietphong = from k in khachhang
join d in dsphong on k.MaPhong equals d.MaPhong
where (k.MaPhong == id)
select new ViewModel
{
khachHang = k,
dsPhong = d
};
//DSPhong dSPhong = db.DSPhongs.Find(id);
KhachHang kh = db.KhachHangs.Where(x => x.MaPhong == id).SingleOrDefault();
DSPhong ds = db.DSPhongs.Where(x => x.MaPhong == id).SingleOrDefault();
//if (dSPhong == null)
//{
// return HttpNotFound();
//}
if (kh == null)
{
ViewBag.kh = 0;
ViewBag.dsphong = ds;
}
ViewBag.ChiTietPhong = chitietphong;
return(View());
}
void LoadAll(DataTable dt)
{
DataTable dulieu = new DataTable();
dulieu.Columns.Add("MaPhong");
dulieu.Columns.Add("TenPhong");
dulieu.Columns.Add("SoNguoi");
dulieu.Columns.Add("SDK");
dulieu.Columns.Add("MaLau");
dulieu.Columns.Add("DoiTuong");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dulieu.NewRow();
dr[0] = dt.Rows[i]["MaPhong"];
dr[1] = dt.Rows[i]["TenPhong"];
dr[2] = dt.Rows[i]["SoNguoi"];
dr[3] = xl.LaySoLuong(dr[0].ToString());
dr[4] = xl.LayTenLau(dr[0].ToString());
if (dt.Rows[i]["DoiTuong"].ToString() == "False")
{
dr[5] = "Nữ";
}
else
{
dr[5] = "Nam";
}
dulieu.Rows.Add(dr);
}
DSPhong.DataSource = dulieu;
DSPhong.DataBind();
}
public ActionResult DeleteConfirmed(string id)
{
DSPhong dSPhong = db.DSPhongs.Find(id);
db.DSPhongs.Remove(dSPhong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void Sua_Click(object sender, CommandEventArgs e)
{
if (e.CommandName == "sua")
{
int room_id = Convert.ToInt16(e.CommandArgument);
DSPhong dsphong = data.get1Room(room_id);
Session["room"] = dsphong;
Response.Redirect("EditPhong.aspx");
}
}
public ActionResult Edit([Bind(Include = "MaPhong,TenPhong,TinhTrangPhong,GiaTienPhong,HinhPhong,ThongTinChiTietPhong")] DSPhong dSPhong)
{
if (ModelState.IsValid)
{
db.Entry(dSPhong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dSPhong));
}
public ActionResult Create([Bind(Include = "MaPhong,TenPhong,TinhTrangPhong,GiaTienPhong,HinhPhong,ThongTinChiTietPhong")] DSPhong dSPhong)
{
if (ModelState.IsValid)
{
db.DSPhongs.Add(dSPhong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dSPhong));
}
// GET: DSPhongs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DSPhong dSPhong = db.DSPhongs.Find(id);
if (dSPhong == null)
{
return(HttpNotFound());
}
return(View(dSPhong));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DSPhong dsphong = (DSPhong)Session["room"];
txtMaPhong.Text = dsphong.MaPhong.ToString();
txtTenPhong.Text = dsphong.TenPhong;
DDL_LoaiPhong.DataSource = data.getRoomTypes();
DDL_LoaiPhong.DataValueField = "MaLoaiPhong";
DDL_LoaiPhong.DataTextField = "TenLoaiPhong";
DataBind();
DDL_LoaiPhong.SelectedValue = dsphong.MaLoaiPhong.ToString();
DDL_TrangThai.Items.FindByValue(dsphong.TrangThai.ToString()).Selected = true;
}
}
// GET: KhachHangs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
KhachHang khachHang = db.KhachHangs.Find(id);
DSPhong dsPhong = db.DSPhongs.Where(x => x.MaPhong == khachHang.MaPhong).SingleOrDefault();
if (khachHang == null)
{
return(HttpNotFound());
}
if (dsPhong == null)
{
ViewBag.dSPhong = 0;
}
return(View(khachHang));
}
protected void btnThemPhong_Click(object sender, EventArgs e)
{
try
{
DSPhong ds = new DSPhong();
ds.TenPhong = txtTenPhong.Text;
ds.TrangThai = Convert.ToBoolean(DDL_TrangThai.SelectedValue);
ds.MaLoaiPhong = Convert.ToInt32(DDL_LoaiPhong.SelectedValue);
data.themPhong(ds);
err_msg.ForeColor = System.Drawing.Color.Green;
err_msg.Text = "Thêm phòng thành công!";
}
catch (Exception ex)
{
err_msg.ForeColor = System.Drawing.Color.Red;
err_msg.Text = "Đã xảy ra lỗi: " + ex.Message;
}
}
protected void btnSuaPhong_Click(object sender, EventArgs e)
{
try
{
DSPhong dsPhong = new DSPhong();
dsPhong.MaPhong = int.Parse(txtMaPhong.Text);
dsPhong.TenPhong = txtTenPhong.Text;
dsPhong.TrangThai = Convert.ToBoolean(DDL_TrangThai.SelectedValue);
dsPhong.MaLoaiPhong = int.Parse(DDL_LoaiPhong.SelectedValue);
data.updateRoom(dsPhong);
err_msg.ForeColor = System.Drawing.Color.Green;
err_msg.Text = "Cập nhật phòng thành công!";
}
catch (Exception ex)
{
err_msg.ForeColor = System.Drawing.Color.Red;
err_msg.Text = "Da xay ra loi: " + ex.Message;
}
}
