public ActionResult insertComment(Comment model) { Account AccountModel = new Account(); AccountModel.username = User.Identity.Name; AccountRepository _accountRepository = new AccountRepository(AccountModel); model.UserID = _accountRepository.getData().ID; model.CommentDateTime = DateTime.Now; CommentRepository _commentRepository = new CommentRepository(model); _commentRepository.insertComment(); return RedirectToAction("SearchResultDetail", "Room", new { id = model.RoomID }); }
public CommentRepository(Comment _comment) { this._comment = _comment; }
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 ActionResult comment(Int64 RoomID) { Comment model = new Comment(); model.RoomID = RoomID; return PartialView(model); }