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