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