[ValidateAntiForgeryToken]//将此处改为用户按了按钮才筛选，点击换页不筛选，或者去掉换页
public ActionResult Index([Bind(Include = "MEMBERID,ROOMID,RESERVETIME,DEADLINE,NUMOFPEOPLE")] ROOMRESERVATION rOOMRESERVATION)
{
var roomreservation = db.ROOMRESERVATIONs.SqlQuery("select * from ROOMRESERVATION where ROOMID = '" + rOOMRESERVATION.ROOMID + "'") as IEnumerable <ROOMRESERVATION>;
ViewBag.ROOMID = new SelectList(db.STUDYROOMS, "ROOMID", "ROOMID");
return(View(roomreservation.ToList()));
}
public ActionResult DeleteConfirmed(string id)
{
ROOMRESERVATION rOOMRESERVATION = db.ROOMRESERVATIONs.Find(id);
db.ROOMRESERVATIONs.Remove(rOOMRESERVATION);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "MEMBERID,ROOMID,RESERVETIME,DEADLINE,NUMOFPEOPLE")] ROOMRESERVATION rOOMRESERVATION)
{
if (ModelState.IsValid)
{
var time = DateTime.Now;
if (rOOMRESERVATION.RESERVETIME < time)
{
ModelState.AddModelError("RESERVETIME", "输入时间非法");
ViewBag.MEMBERID = new SelectList(db.MEMBERS, "MEMBERID", "PASSWORDS");
ViewBag.ROOMID = new SelectList(db.STUDYROOMS, "ROOMID", "ROOMID");
return(View());
}
var capacity = db.STUDYROOMS.SqlQuery("select * from STUDYROOMS where ROOMID = '" + rOOMRESERVATION.ROOMID + "'").ToList();
var roomcapacity = capacity.First();
if (rOOMRESERVATION.NUMOFPEOPLE <= 0 || rOOMRESERVATION.NUMOFPEOPLE > roomcapacity.ROOMCAPACITY)
{
ModelState.AddModelError("NUMOFPEOPLE", "输入人数非法");
ViewBag.MEMBERID = new SelectList(db.MEMBERS, "MEMBERID", "PASSWORDS");
ViewBag.ROOMID = new SelectList(db.STUDYROOMS, "ROOMID", "ROOMID");
return(View());
}
DateTime dt = rOOMRESERVATION.RESERVETIME;
rOOMRESERVATION.DEADLINE = dt.AddHours(1);
var query = db.ROOMRESERVATIONs.SqlQuery("select * from ROOMRESERVATION where ROOMID = '" + rOOMRESERVATION.ROOMID + "'");
foreach (var item in query)
{
if (rOOMRESERVATION.RESERVETIME < item.DEADLINE && rOOMRESERVATION.RESERVETIME >= item.RESERVETIME)
{
ModelState.AddModelError("RESERVETIME", "这个房间要在" + item.DEADLINE.ToString() + "后才有空");
ViewBag.MEMBERID = new SelectList(db.MEMBERS, "MEMBERID", "PASSWORDS");
ViewBag.ROOMID = new SelectList(db.STUDYROOMS, "ROOMID", "ROOMID");
return(View());
}
if (rOOMRESERVATION.DEADLINE <= item.DEADLINE && rOOMRESERVATION.RESERVETIME > item.RESERVETIME)
{
ModelState.AddModelError("DEADLINE", "这个房间在" + item.RESERVETIME.ToString() + "后被占用");
ViewBag.MEMBERID = new SelectList(db.MEMBERS, "MEMBERID", "PASSWORDS");
ViewBag.ROOMID = new SelectList(db.STUDYROOMS, "ROOMID", "ROOMID");
return(View());
}
}
string temp1 = rOOMRESERVATION.RESERVETIME.ToString();
string temp2 = rOOMRESERVATION.DEADLINE.ToString();
string membername = User.Identity.GetUserName();
var queryid = from d in db.MEMBERS where d.MEMBERNAME == membername select d.MEMBERID;
string memberid = queryid.ToList().First();
string temp3 = "insert into ROOMRESERVATION values('" + memberid + "','" + rOOMRESERVATION.ROOMID + "', to_date('" + temp1 + "','yyyy-mm-dd hh24:mi:ss'), to_date('" + temp2 + "','yyyy-mm-dd hh24:mi:ss')," + rOOMRESERVATION.NUMOFPEOPLE + ")";
db.Database.ExecuteSqlCommand(temp3);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MEMBERID = new SelectList(db.MEMBERS, "MEMBERID", "PASSWORDS", rOOMRESERVATION.MEMBERID);
ViewBag.ROOMID = new SelectList(db.STUDYROOMS, "ROOMID", "ROOMID", rOOMRESERVATION.ROOMID);
return(View(rOOMRESERVATION));
}
// GET: ROOMRESERVATIONs/Details/5
public ActionResult Details(string roomid, DateTime reservetime)
{
if (roomid == null || reservetime == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ROOMRESERVATION rOOMRESERVATION = db.ROOMRESERVATIONs.Find("0000100002", roomid, reservetime);
//var query = db.ROOMRESERVATIONs.SqlQuery("select * from ROOMRESERVATION where ROOMID = '" + roomid + "'");
return(View(rOOMRESERVATION));
}
public ActionResult Edit([Bind(Include = "MEMBERID,ROOMID,RESERVETIME,DEADLINE,NUMOFPEOPLE")] ROOMRESERVATION rOOMRESERVATION)
{
if (ModelState.IsValid)
{
db.Entry(rOOMRESERVATION).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MEMBERID = new SelectList(db.MEMBERS, "MEMBERID", "PASSWORDS", rOOMRESERVATION.MEMBERID);
ViewBag.ROOMID = new SelectList(db.STUDYROOMS, "ROOMID", "ROOMID", rOOMRESERVATION.ROOMID);
return(View(rOOMRESERVATION));
}
// GET: ROOMRESERVATIONs/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ROOMRESERVATION rOOMRESERVATION = db.ROOMRESERVATIONs.Find(id);
if (rOOMRESERVATION == null)
{
return(HttpNotFound());
}
return(View(rOOMRESERVATION));
}
public ActionResult ReturnRoom([Bind(Include = "MEMBERID,ROOMID,RESERVETIME,DEADLINE,NUMOFPEOPLE")] ROOMRESERVATION rOOMRESERVATION)
{
var reserve = db.ROOMRESERVATIONs.Find(rOOMRESERVATION.MEMBERID, rOOMRESERVATION.ROOMID, rOOMRESERVATION.RESERVETIME);
db.ROOMRESERVATIONs.Remove(reserve);
var time = DateTime.Now;
var occupation = new ROOMOCCUPATION();
occupation.MEMBERID = rOOMRESERVATION.MEMBERID;
occupation.ROOMID = rOOMRESERVATION.ROOMID;
occupation.STARTTIME = rOOMRESERVATION.RESERVETIME;
occupation.DEADLINE = rOOMRESERVATION.DEADLINE;
occupation.RETURNTIME = time;
db.ROOMOCCUPATIONs.Add(occupation);
return(View());
}
// GET: ROOMRESERVATIONs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ROOMRESERVATION rOOMRESERVATION = db.ROOMRESERVATIONs.Find(id);
if (rOOMRESERVATION == null)
{
return(HttpNotFound());
}
ViewBag.MEMBERID = new SelectList(db.MEMBERS, "MEMBERID", "PASSWORDS", rOOMRESERVATION.MEMBERID);
ViewBag.ROOMID = new SelectList(db.STUDYROOMS, "ROOMID", "ROOMID", rOOMRESERVATION.ROOMID);
return(View(rOOMRESERVATION));
}
