public ActionResult CommentList(Int64 RoomID) { Room room = new Room(); room.RoomID = RoomID; RoomRepository _RoomRepository = new RoomRepository(room); return PartialView(_RoomRepository.getdata()); }
public ActionResult RoomlistOwner() { Room model = new Room(); Account AccountModel = new Account(); AccountModel.username = User.Identity.Name; AccountRepository _accountRepository = new AccountRepository(AccountModel); model.UserID = _accountRepository.getData().ID; List<Room> modelList = new List<Room>(); RoomRepository _RoomAccountRepository = new RoomRepository(model); return View(_RoomAccountRepository.getRoomListByID()); }
public ActionResult AppointmentList(Int64 RoomID) { Room model = new Room(); model.RoomID = RoomID; Appointment _AppointmentModel = new Appointment(); Account AccountModel = new Account(); AccountModel.username = User.Identity.Name; AccountRepository _accountRepository = new AccountRepository(AccountModel); _AppointmentModel.UserID = _accountRepository.getData().ID; _AppointmentModel.RoomID = RoomID; AppointmentRepository _appointmentRepository = new AppointmentRepository(_AppointmentModel); return View(_appointmentRepository.getAppointmentList()); }
public ActionResult RoomUpdateProcess(Room model) { RoomRepository _RoomRepository = new RoomRepository(model); _RoomRepository.UpdateRoomData(); return RedirectToAction("RoomlistOwner"); }
public ActionResult RoomUpdate(Room _model) { return View(_model); }
public Room getdata() { Room _RoomAccount = new Room(); SqlCeCommand cmd = new SqlCeCommand("Select * from RoomInformation " + "inner join Comment on RoomInformation.RoomID = Comment.RoomID " + "inner join UserInformation on RoomInformation.UserID = UserInformation.User_ID " + "inner join UserInformation As CommentAccount on Comment.UserID = CommentAccount.User_ID " + "where RoomInformation.RoomID =@RoomID Order by Comment.CommentDateTime DESC", conn); cmd.Parameters.AddWithValue("@RoomID", this.roominformation.RoomID); SqlCeDataAdapter adapter = new SqlCeDataAdapter(); adapter.SelectCommand = cmd; DataSet setdata = new DataSet(); adapter.Fill(setdata, "RoomInformation"); if (setdata.Tables[0].Rows.Count > 0) { _RoomAccount.RoomID = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[0].ToString()); _RoomAccount.ApartmentName = setdata.Tables[0].Rows[0].ItemArray[1].ToString(); _RoomAccount.RoomForSale = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[2].ToString()); _RoomAccount.RoomForRent = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[3].ToString()); _RoomAccount.RoomType = setdata.Tables[0].Rows[0].ItemArray[4].ToString(); _RoomAccount.RoomSize = setdata.Tables[0].Rows[0].ItemArray[5].ToString(); _RoomAccount.RoomPrice = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[6].ToString()); _RoomAccount.District = setdata.Tables[0].Rows[0].ItemArray[7].ToString(); _RoomAccount.Tambon = setdata.Tables[0].Rows[0].ItemArray[8].ToString(); _RoomAccount.Road = setdata.Tables[0].Rows[0].ItemArray[9].ToString(); _RoomAccount.Soi = setdata.Tables[0].Rows[0].ItemArray[10].ToString(); _RoomAccount.PostCode = setdata.Tables[0].Rows[0].ItemArray[11].ToString(); _RoomAccount.FullAddress = setdata.Tables[0].Rows[0].ItemArray[12].ToString(); _RoomAccount.ElecPerUnit = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[13].ToString()); _RoomAccount.WaterPerUnit = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[14].ToString()); _RoomAccount.RoomStatus = setdata.Tables[0].Rows[0].ItemArray[15].ToString(); _RoomAccount.AirCon = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[16].ToString()); _RoomAccount.Fridge = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[17].ToString()); _RoomAccount.Balcony = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[18].ToString()); _RoomAccount.Tv = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[19].ToString()); _RoomAccount.Internet = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[20].ToString()); _RoomAccount.WHeater = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[21].ToString()); _RoomAccount.Pets = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[22].ToString()); _RoomAccount.Fitness = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[23].ToString()); _RoomAccount.Swimming = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[24].ToString()); _RoomAccount.Laundry = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[25].ToString()); _RoomAccount.Store = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[26].ToString()); _RoomAccount.Elevator = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[27].ToString()); _RoomAccount.Parking = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[28].ToString()); _RoomAccount.FrontDesk = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[29].ToString()); _RoomAccount.KeyCard = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[30].ToString()); _RoomAccount.FingerPrint = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[31].ToString()); _RoomAccount.CCTV = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[32].ToString()); _RoomAccount.Guard = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[33].ToString()); _RoomAccount.FireAlarm = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[34].ToString()); _RoomAccount.UserID = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[35].ToString()); _RoomAccount.Username = setdata.Tables[0].Rows[0].ItemArray[48].ToString(); for (int i = 0; i < setdata.Tables[0].Rows.Count; i++) { Comment _comment = new Comment(); _comment.CommentID = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[36].ToString()); _comment.Username = setdata.Tables[0].Rows[i].ItemArray[61].ToString(); _comment.CommentContent = setdata.Tables[0].Rows[i].ItemArray[39].ToString(); _comment.CommentDateTime = DateTime.Parse(setdata.Tables[0].Rows[0].ItemArray[40].ToString()); _RoomAccount.RoomCommentList.Add(_comment); } } return _RoomAccount; }
public List<Room> Searchwithcriterion() { string Criterion = " select * from RoomInformation "; int counter = 0; if (this._searchModel.District != null) { if (counter == 0) Criterion += "where District = @District "; else Criterion += "and District = @District "; counter++; } if (this._searchModel.RoomType != null) { if (counter == 0) Criterion += "where RoomType = @RoomType "; else Criterion += "and RoomType = @RoomType "; counter++; } if (this._searchModel.Max != 0) { //if ((this._searchModel.Max > this._searchModel.Mini) && (this._searchModel.Max >= 0)) //{ if (counter == 0) Criterion += "where RoomPrice <= @MaxPrice "; else Criterion += "and RoomPrice <= @MaxPrice "; counter++; //} } if (this._searchModel.Mini != 0) { //if (this._searchModel.Mini >= 0) //{ if (counter == 0) Criterion += "where RoomPrice >= @MinPrice "; else Criterion += "and RoomPrice >= @MinPrice "; counter++; //} } conn.Open(); SqlCeCommand cmd = new SqlCeCommand(Criterion, conn); if (this._searchModel.District != null) cmd.Parameters.AddWithValue("@District", this._searchModel.District); if (this._searchModel.RoomType != null) cmd.Parameters.AddWithValue("@RoomType", this._searchModel.RoomType); if (this._searchModel.Max != 0) cmd.Parameters.AddWithValue("@MaxPrice", this._searchModel.Max); if (this._searchModel.Mini != 0) cmd.Parameters.AddWithValue("@MinPrice", this._searchModel.Mini); SqlCeDataAdapter adapter = new SqlCeDataAdapter(); DataSet setdata = new DataSet(); adapter.SelectCommand = cmd; adapter.Fill(setdata); List<Room> RoomList = new List<Room>(); Room _RoomAccount = new Room(); for (int i = 0; i < setdata.Tables[0].Rows.Count; i++) { _RoomAccount = new Room(); _RoomAccount.RoomID = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[0].ToString()); _RoomAccount.ApartmentName = setdata.Tables[0].Rows[i].ItemArray[1].ToString(); _RoomAccount.RoomForSale = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[2].ToString()); _RoomAccount.RoomForRent = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[3].ToString()); _RoomAccount.RoomType = setdata.Tables[0].Rows[i].ItemArray[4].ToString(); _RoomAccount.RoomSize = setdata.Tables[0].Rows[i].ItemArray[5].ToString(); _RoomAccount.RoomPrice = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[6].ToString()); _RoomAccount.District = setdata.Tables[0].Rows[i].ItemArray[7].ToString(); _RoomAccount.Tambon = setdata.Tables[0].Rows[i].ItemArray[8].ToString(); _RoomAccount.Road = setdata.Tables[0].Rows[i].ItemArray[9].ToString(); _RoomAccount.Soi = setdata.Tables[0].Rows[i].ItemArray[10].ToString(); _RoomAccount.PostCode = setdata.Tables[0].Rows[i].ItemArray[11].ToString(); _RoomAccount.FullAddress = setdata.Tables[0].Rows[i].ItemArray[12].ToString(); _RoomAccount.ElecPerUnit = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[13].ToString()); _RoomAccount.WaterPerUnit = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[14].ToString()); _RoomAccount.RoomStatus = setdata.Tables[0].Rows[i].ItemArray[15].ToString(); _RoomAccount.AirCon = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[16].ToString()); _RoomAccount.Fridge = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[17].ToString()); _RoomAccount.Balcony = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[18].ToString()); _RoomAccount.Tv = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[19].ToString()); _RoomAccount.Internet = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[20].ToString()); _RoomAccount.WHeater = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[21].ToString()); _RoomAccount.Pets = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[22].ToString()); _RoomAccount.Fitness = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[23].ToString()); _RoomAccount.Swimming = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[24].ToString()); _RoomAccount.Laundry = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[25].ToString()); _RoomAccount.Store = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[26].ToString()); _RoomAccount.Elevator = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[27].ToString()); _RoomAccount.Parking = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[28].ToString()); _RoomAccount.FrontDesk = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[29].ToString()); _RoomAccount.KeyCard = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[30].ToString()); _RoomAccount.FingerPrint = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[31].ToString()); _RoomAccount.CCTV = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[32].ToString()); _RoomAccount.Guard = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[33].ToString()); _RoomAccount.FireAlarm = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[34].ToString()); _RoomAccount.UserID = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[35].ToString()); RoomList.Add(_RoomAccount); } conn.Close(); return RoomList; }
public List<Room> getRoomUser() { List<Room> _SelfRoomList = new List<Room>(); SqlCeCommand cmd = new SqlCeCommand("Select * from UserInformation inner join RoomInformation on UserInformation.User_ID = RoomInformation.UserID", conn); SqlCeDataAdapter adapter = new SqlCeDataAdapter(); adapter.SelectCommand = cmd; DataSet setdata = new DataSet(); adapter.Fill(setdata, "UserInformation"); if (setdata.Tables[0].Rows.Count > 0) { for (int i = 0; i < setdata.Tables[0].Rows.Count; i++) { Room _RoomAccount= new Room(); _RoomAccount.RoomID = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[0].ToString()); _RoomAccount.ApartmentName = setdata.Tables[0].Rows[i].ItemArray[1].ToString(); _RoomAccount.RoomForSale = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[2].ToString()); _RoomAccount.RoomForRent = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[3].ToString()); _RoomAccount.RoomType = setdata.Tables[0].Rows[i].ItemArray[4].ToString(); _RoomAccount.RoomSize = setdata.Tables[0].Rows[i].ItemArray[5].ToString(); _RoomAccount.RoomPrice = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[6].ToString()); _RoomAccount.District = setdata.Tables[0].Rows[i].ItemArray[7].ToString(); _RoomAccount.Tambon = setdata.Tables[0].Rows[i].ItemArray[8].ToString(); _RoomAccount.Road = setdata.Tables[0].Rows[i].ItemArray[9].ToString(); _RoomAccount.Soi = setdata.Tables[0].Rows[i].ItemArray[10].ToString(); _RoomAccount.PostCode = setdata.Tables[0].Rows[i].ItemArray[11].ToString(); _RoomAccount.FullAddress = setdata.Tables[0].Rows[i].ItemArray[12].ToString(); _RoomAccount.ElecPerUnit = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[13].ToString()); _RoomAccount.WaterPerUnit = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[14].ToString()); _RoomAccount.RoomStatus = setdata.Tables[0].Rows[i].ItemArray[15].ToString(); _RoomAccount.AirCon = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[16].ToString()); _RoomAccount.Fridge = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[17].ToString()); _RoomAccount.Balcony = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[18].ToString()); _RoomAccount.Tv = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[19].ToString()); _RoomAccount.Internet = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[20].ToString()); _RoomAccount.WHeater = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[21].ToString()); _RoomAccount.Pets = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[22].ToString()); _RoomAccount.Fitness = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[23].ToString()); _RoomAccount.Swimming = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[24].ToString()); _RoomAccount.Laundry = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[25].ToString()); _RoomAccount.Store = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[26].ToString()); _RoomAccount.Elevator = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[27].ToString()); _RoomAccount.Parking = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[28].ToString()); _RoomAccount.FrontDesk = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[29].ToString()); _RoomAccount.KeyCard = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[30].ToString()); _RoomAccount.FingerPrint = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[31].ToString()); _RoomAccount.CCTV = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[32].ToString()); _RoomAccount.Guard = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[33].ToString()); _RoomAccount.FireAlarm = bool.Parse(setdata.Tables[0].Rows[i].ItemArray[34].ToString()); _SelfRoomList.Add(_RoomAccount); } } return _SelfRoomList; }
public RoomRepository(Room _roominformation) { this.roominformation = _roominformation; }
public Room GetRoomData() { Room Roominfo = new Room(); SqlCeCommand cmd = new SqlCeCommand("Select * from RoomInformation where RoomID = @RoomID", conn); SqlCeDataAdapter adapter = new SqlCeDataAdapter(); cmd.Parameters.AddWithValue("@RoomID", this.roominformation.RoomID); adapter.SelectCommand = cmd; DataSet setdata = new DataSet(); adapter.Fill(setdata,"RoomInformation"); for (int i = 0; i < setdata.Tables[0].Rows.Count; i++) { Roominfo.RoomID = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[0].ToString()); Roominfo.ApartmentName = setdata.Tables[0].Rows[0].ItemArray[1].ToString(); Roominfo.RoomForSale = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[2].ToString()); Roominfo.RoomForRent = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[3].ToString()); Roominfo.RoomType = setdata.Tables[0].Rows[0].ItemArray[4].ToString(); Roominfo.RoomSize = setdata.Tables[0].Rows[0].ItemArray[5].ToString(); Roominfo.RoomPrice = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[6].ToString()); Roominfo.District = setdata.Tables[0].Rows[0].ItemArray[7].ToString(); Roominfo.Tambon = setdata.Tables[0].Rows[0].ItemArray[8].ToString(); Roominfo.Road = setdata.Tables[0].Rows[0].ItemArray[9].ToString(); Roominfo.Soi = setdata.Tables[0].Rows[0].ItemArray[10].ToString(); Roominfo.PostCode = setdata.Tables[0].Rows[0].ItemArray[11].ToString(); Roominfo.FullAddress = setdata.Tables[0].Rows[0].ItemArray[12].ToString(); Roominfo.ElecPerUnit = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[13].ToString()); Roominfo.WaterPerUnit = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[14].ToString()); Roominfo.RoomStatus = setdata.Tables[0].Rows[0].ItemArray[15].ToString(); Roominfo.AirCon = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[16].ToString()); Roominfo.Fridge = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[17].ToString()); Roominfo.Balcony = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[18].ToString()); Roominfo.Tv = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[19].ToString()); Roominfo.Internet = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[20].ToString()); Roominfo.WHeater = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[21].ToString()); Roominfo.Pets = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[22].ToString()); Roominfo.Fitness = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[23].ToString()); Roominfo.Swimming = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[24].ToString()); Roominfo.Laundry = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[25].ToString()); Roominfo.Store = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[26].ToString()); Roominfo.Elevator = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[27].ToString()); Roominfo.Parking = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[28].ToString()); Roominfo.FrontDesk = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[29].ToString()); Roominfo.KeyCard = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[30].ToString()); Roominfo.FingerPrint = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[31].ToString()); Roominfo.CCTV = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[32].ToString()); Roominfo.Guard = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[33].ToString()); Roominfo.FireAlarm = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[34].ToString()); Roominfo.UserID = Int64.Parse(setdata.Tables[0].Rows[0].ItemArray[35].ToString()); } return Roominfo; }
public ActionResult InsertRoomData(Room model) { //if (model.ApartmentName != "" || model.RoomType != "" || model.RoomSize != "" || model.RoomPrice != 0 || model.District != "" || model.FullAddress != "" || model.ElecPerUnit != 0 || model.WaterPerUnit != 0 || model.RoomStatus != "") //{ Account AccountModel = new Account(); AccountModel.username = User.Identity.Name; AccountRepository _accountRepository = new AccountRepository(AccountModel); model.UserID = _accountRepository.getData().ID; RoomRepository _RoomRepository = new RoomRepository(model); _RoomRepository.InsertRoomData(); return RedirectToAction("RoomlistOwner","MY"); //} //else //{ // ViewData["MSGREGISTER"] = "Please Input All The Data!!!"; // return View(); //} }
public ActionResult SearchResultDetail(Int64 ID) { Room room = new Room(); room.RoomID = ID; RoomRepository _RoomRepository = new RoomRepository(room); return View(_RoomRepository.GetRoomData()); }
public ActionResult RoomList() { Room model = new Room(); List<Room> modelList = new List<Room>(); RoomRepository _RoomAccountRepository = new RoomRepository(model); modelList = _RoomAccountRepository.getRoomList(); return View(modelList); }
public ActionResult RoomDeleteData(Room model) { RoomRepository _RoomRepository = new RoomRepository(model); _RoomRepository.DeleteRoomData(); return RedirectToAction("RoomlistOwner","MY"); }
public ActionResult MakeReservations(Int64 RoomID) { Room model = new Room(); model.RoomID = RoomID; RoomRepository _roomRepository = new RoomRepository(model); Reservation _ReservationtModel = new Reservation(); _ReservationtModel.RoomID = _roomRepository.getdata().RoomID; _ReservationtModel.RoomAccount = _roomRepository.getdata(); Account AccountModel = new Account(); AccountModel.username = User.Identity.Name; AccountRepository _accountRepository = new AccountRepository(AccountModel); _ReservationtModel.UserID = _accountRepository.getData().ID; return View(_ReservationtModel); }