public long VerifiedUpdate(CLayer.Review feedback) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, feedback.PropertyId)); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, feedback.UserId)); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, feedback.BookingId)); param.Add(Connection.GetParameter("pDescription", DataPlug.DataType._Varchar, feedback.Description)); param.Add(Connection.GetParameter("pUpdatedUserId", DataPlug.DataType._BigInt, feedback.UpdatedBy)); param.Add(Connection.GetParameter("pUpdatedDate", DataPlug.DataType._DateTime, feedback.UpdatedDate)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, feedback.Status)); param.Add(Connection.GetParameter("pIsRecommended", DataPlug.DataType._Bool, feedback.Recommended)); param.Add(Connection.GetParameter("pAccommodationCity", DataPlug.DataType._Varchar, feedback.AccommodationCity)); param.Add(Connection.GetParameter("pAccessibility", DataPlug.DataType._Int, feedback.Accessibility)); param.Add(Connection.GetParameter("pEasiness", DataPlug.DataType._Int, feedback.Easiness)); param.Add(Connection.GetParameter("pCleanlinessBed", DataPlug.DataType._Int, feedback.CleanlinessBed)); param.Add(Connection.GetParameter("pCleanlinessBath", DataPlug.DataType._Int, feedback.CleanlinessBath)); param.Add(Connection.GetParameter("pSleepQuality", DataPlug.DataType._Int, feedback.SleepQuality)); param.Add(Connection.GetParameter("pStaffbehave", DataPlug.DataType._Int, feedback.Staffbehave)); param.Add(Connection.GetParameter("pOverallExp", DataPlug.DataType._Int, feedback.OverallExp)); param.Add(Connection.GetParameter("pConsiderfornext", DataPlug.DataType._Int, feedback.Considerfornext)); //param.Add(Connection.GetParameter("pRating", DataPlug.DataType._Int, feedback.Rating)); object result = Connection.ExecuteQueryScalar("review_Update", param); return(Connection.ToLong(result)); }
public CLayer.Review Get(long PropertyId, long UserId, long BookingId) { CLayer.Review rev = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, PropertyId)); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, UserId)); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, BookingId)); DataTable dt = Connection.GetTable("review_Details", param); if (dt.Rows.Count > 0) { rev = new CLayer.Review(); rev.PropertyId = Connection.ToLong(dt.Rows[0]["PropertyId"]); rev.UserId = Connection.ToLong(dt.Rows[0]["UserId"]); rev.BookingId = Connection.ToLong(dt.Rows[0]["BookingId"]); rev.Rating = Connection.ToInteger(dt.Rows[0]["Rating"]); rev.Status = Connection.ToInteger(dt.Rows[0]["Status"]); rev.ReviewDate = Connection.ToDate(dt.Rows[0]["ReviewDate"]); rev.FirstName = Connection.ToString(dt.Rows[0]["FirstName"]); rev.LastName = Connection.ToString(dt.Rows[0]["LastName"]); rev.Title = Connection.ToString(dt.Rows[0]["Title"]); rev.Location = Connection.ToString(dt.Rows[0]["Location"]); rev.Address = Connection.ToString(dt.Rows[0]["Address"]); rev.Description = Connection.ToString(dt.Rows[0]["Description"]); rev.UpdatedBy = Connection.ToLong(dt.Rows[0]["UpdatedBy"]); rev.UpdatedDate = Connection.ToDate(dt.Rows[0]["UpdatedDate"]); rev.Recommended = Connection.ToBoolean(dt.Rows[0]["IsRecommended"]); } return(rev); }
public long Chechreviewids(CLayer.Review feedback) { long pPropertyId = feedback.PropertyId; long pBookingId = feedback.BookingId; string sql = "SELECT COUNT(BookingId) FROM review WHERE BookingId=" + pBookingId + " and PropertyId=" + pPropertyId + ""; object obj = Connection.ExecuteSQLQueryScalar(sql); return(Connection.ToInteger(obj)); }
public ActionResult SaveData(Models.ReviewModel data) { try { ViewBag.LoginError = false; ViewBag.GuestError = false; long cid = 0; long.TryParse(User.Identity.GetUserId(), out cid); //if (ModelState.IsValid) //{ CLayer.Review d = new CLayer.Review() { PropertyId = data.PropertyId, UserId = cid, BookingId = data.BookingId, Rating = data.Rating, Description = data.Description, Status = (int)CLayer.ObjectStatus.StatusType.NotVerified, // ReviewDate = DateTime.Now AccommodationCity = data.AccommodationCity, Accessibility = data.Accessibility, Easiness = data.Easiness, CleanlinessBed = data.CleanlinessBed, CleanlinessBath = data.CleanlinessBath, SleepQuality = data.SleepQuality, Staffbehave = data.Staffbehave, OverallExp = data.OverallExp, Considerfornext = data.Considerfornext }; long idsch = BLayer.Review.Chechreviewids(d); if (idsch > 0) { ViewBag.LoginError = true; ViewBag.Message = "Review Already saved"; data.message1 = "Review Already saved"; ViewBag.Saved = true; //return RedirectToAction("IndexSave"); } else { ViewBag.LoginError = true; ViewBag.Message = "Waiting for verification"; data.message1 = "Waiting for verification"; ViewBag.Saved = true; BLayer.Review.Save(d); } return(RedirectToAction("Index", "BookingHistory")); } catch (Exception ex) { Common.LogHandler.HandleError(ex); //return Redirect("~/Admin/ErrorPage"); return(RedirectToAction("Index")); } }
public CLayer.Review Get(long PropertyId, long UserId, long BookingId) { CLayer.Review rev = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, PropertyId)); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, UserId)); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, BookingId)); DataTable dt = Connection.GetTable("review_Details", param); if (dt.Rows.Count > 0) { rev = new CLayer.Review(); rev.PropertyId = Connection.ToLong(dt.Rows[0]["PropertyId"]); rev.UserId = Connection.ToLong(dt.Rows[0]["UserId"]); rev.BookingId = Connection.ToLong(dt.Rows[0]["BookingId"]); rev.Rating = Connection.ToInteger(dt.Rows[0]["Rating"]); rev.Status = Connection.ToInteger(dt.Rows[0]["Status"]); rev.ReviewDate = Connection.ToDate(dt.Rows[0]["ReviewDate"]); rev.FirstName = Connection.ToString(dt.Rows[0]["FirstName"]); rev.LastName = Connection.ToString(dt.Rows[0]["LastName"]); rev.Title = Connection.ToString(dt.Rows[0]["Title"]); rev.Location = Connection.ToString(dt.Rows[0]["Location"]); rev.Address = Connection.ToString(dt.Rows[0]["Address"]); rev.Description = Connection.ToString(dt.Rows[0]["Description"]); rev.UpdatedBy = Connection.ToLong(dt.Rows[0]["UpdatedBy"]); rev.UpdatedDate = Connection.ToDate(dt.Rows[0]["UpdatedDate"]); rev.Recommended = Connection.ToBoolean(dt.Rows[0]["IsRecommended"]); rev.AccommodationCity = Connection.ToString(dt.Rows[0]["AccommodationCity"]); rev.Accessibility = Connection.ToInteger(dt.Rows[0]["Accessibilitytoproperty"]); rev.Easiness = Connection.ToInteger(dt.Rows[0]["EasinessInCheckIn"]); rev.CleanlinessBed = Connection.ToInteger(dt.Rows[0]["CleanlinessBedroom"]); rev.CleanlinessBath = Connection.ToInteger(dt.Rows[0]["CleanlinessBathroom"]); rev.SleepQuality = Connection.ToInteger(dt.Rows[0]["SleepQuality"]); rev.Staffbehave = Connection.ToInteger(dt.Rows[0]["StaffBehavior"]); rev.Considerfornext = Connection.ToInteger(dt.Rows[0]["ConsiderForNextTravel"]); rev.OverallExp = Connection.ToInteger(dt.Rows[0]["OverallExperience"]); } return(rev); }
public string Verify(Models.ReviewsModel data) { try { long cid = 0; long.TryParse(User.Identity.GetUserId(), out cid); CLayer.Review d = new CLayer.Review() { PropertyId = data.PropertyId, UserId = data.UserId, BookingId = data.BookingId, Description = data.Description, //Rating=data.Rating, UpdatedBy = cid, Status = data.Status, UpdatedDate = DateTime.Now, Recommended = data.Recommended, AccommodationCity = data.AccommodationCity, Accessibility = data.Accessibility, Easiness = data.Easiness, CleanlinessBed = data.CleanlinessBed, CleanlinessBath = data.CleanlinessBath, SleepQuality = data.SleepQuality, Staffbehave = data.Staffbehave, OverallExp = data.OverallExp, Considerfornext = data.Considerfornext }; BLayer.Review.Verified(d); return("Ok"); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return("Try"); } }
public ActionResult Details(long propertyId, long UserId, long BookingId) { Models.ReviewsModel search = new Models.ReviewsModel(); CLayer.Review users = BLayer.Review.Get(propertyId, UserId, BookingId); if (users != null) { search = new Models.ReviewsModel { PropertyId = users.PropertyId, UserId = users.UserId, BookingId = users.BookingId, Rating = users.Rating, Status = users.Status, ReviewDate = users.ReviewDate, FirstName = users.FirstName, LastName = users.LastName, Title = users.Title, Location = users.Location, Address = users.Address, Description = users.Description, UpdatedBy = users.UpdatedBy, UpdatedDate = users.UpdatedDate, Recommended = users.Recommended, AccommodationCity = users.AccommodationCity, Accessibility = users.Accessibility, Easiness = users.Easiness, CleanlinessBed = users.CleanlinessBed, CleanlinessBath = users.CleanlinessBath, SleepQuality = users.SleepQuality, Staffbehave = users.Staffbehave, OverallExp = users.OverallExp, Considerfornext = users.Considerfornext }; } return(PartialView("_Details", search)); }
public static long Save(CLayer.Review feedback) { DataLayer.Review task = new DataLayer.Review(); feedback.Validate(); return(task.Save(feedback)); }
public static long Verified(CLayer.Review feedback) { DataLayer.Review task = new DataLayer.Review(); feedback.Validate(); return(task.VerifiedUpdate(feedback)); }
//public static List<CLayer.Property> GetProperty(long propertyId) //{ // //long propertyId= feedback.PropertyId; // DataLayer.Review property = new DataLayer.Review(); // return property.ProprtyGet(propertyId ); //} public static long Chechreviewids(CLayer.Review feedback) { DataLayer.Review task = new DataLayer.Review(); feedback.Validate(); return(task.Chechreviewids(feedback)); }