public JsonResult UpdateFieldStatus(int id, string field, int included, double taxrate)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
var provider = new ReservationRevenueProvider(_dbContext);
var ok = provider.SetFieldStatus(id, field, taxrate, (included == 1 ? true : false));
if (ok)
{
return(Json(id, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(string.Empty, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
string message = string.Format("Change Reservation 'IncludeInStatement' for ID = {0:d} fails. {1}", id, ex.Message + ex.StackTrace);
return(InternalError(message, string.Empty, ex));
}
}
public JsonResult Update(string model)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
// parameter is passed in as a model with Json string
var entity = JsonConvert.DeserializeObject <ResolutionRevenueModel>(model);
try
{
if (!string.IsNullOrEmpty(entity.ConfirmationCode))
{
var provider = new ReservationRevenueProvider(_dbContext);
var propertycode = provider.GetPropertyCodeByConfirmationCode(entity.ConfirmationCode);
if (!string.IsNullOrEmpty(propertycode))
{
entity.PropertyCode = propertycode;
}
}
var dataProvider = new ResolutionRevenueProvider(_dbContext);
dataProvider.Update(entity.ResolutionId, entity);
dataProvider.Commit();
return(Json(entity, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var innerErrorMessage = ex.InnerException != null ? ex.InnerException.Message : string.Empty;
string message = string.Format("Saving Resolution {0:d} fails. {1} - {2}", entity.ResolutionId, ex.Message, innerErrorMessage);
return(InternalError(message, "fail", ex));
}
}
public JsonResult Update(string model)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
var codeModel = JsonConvert.DeserializeObject <MissingPropertyCodesModel>(model);
try
{
var dataProvider = new ReservationRevenueProvider(_dbContext);
var entity = dataProvider.Retrieve(codeModel.ReservationId);
entity.PropertyCode = codeModel.PropertyCode;
dataProvider.Update(codeModel.ReservationId, entity);
dataProvider.Commit();
return(Json(codeModel, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var innerErrorMessage = ex.InnerException != null ? ex.InnerException.Message : string.Empty;
string message = string.Format("Saving Property Code for Reservation {0:d} fails. {1},{2}", codeModel.ReservationId, ex.Message, innerErrorMessage);
return(InternalError(message, string.Empty, ex));
}
}
public JsonResult UpdateWorkflowAll(DateTime month, string propertyCode, int state, int direction)
{
RevenueApprovalStatus workflowState = (RevenueApprovalStatus)state;
if (!((AuthorizationProvider.CanReviewRevenue() && workflowState == RevenueApprovalStatus.Reviewed) ||
(AuthorizationProvider.CanApproveRevenue() && workflowState == RevenueApprovalStatus.Approved) ||
(AuthorizationProvider.CanFinalizeRevenue() && workflowState == RevenueApprovalStatus.Finalized)))
{
return(Forbidden());
}
try
{
var dataProvider = new ReservationRevenueProvider(_dbContext);
var nextState = dataProvider.MoveWorkflowAll(month, propertyCode, workflowState, direction);
if (nextState != null)
{
return(Json(nextState, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("-1", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
string message = string.Format("Change {0} Reservation workflow fails for property {1}. {2}", month.ToString("MM/dd/yyyy"), propertyCode, ex.Message + ex.StackTrace);
return(InternalError(message, "-1", ex));
}
}
public JsonResult SplitReservation(ResevationSplitModel form)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
var dataProvider = new ReservationRevenueProvider(_dbContext);
var result = dataProvider.SplitReservation(form);
if (result != null)
{
return(Json(result.Value.ToString(), JsonRequestBehavior.AllowGet));
}
else
{
return(Json("-1", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
var innerErrorMessage = ex.InnerException != null ? ex.InnerException.Message : string.Empty;
string message = string.Format("Splitting Reservation {0:d} for property code {1} fails. {2},{3}", form.ReservationId, form.PropertyCode, ex.Message, innerErrorMessage);
return(InternalError(message, string.Empty, ex));
}
}
public ActionResult SplitRevenue(int Id)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
var model = new ResevationSplitModel();
try
{
var provider = new ReservationRevenueProvider(_dbContext);
var entity = provider.Retrieve(Id);
if (entity != null)
{
model.ReservationId = Id;
model.PropertyCode = entity.PropertyCode;
model.ConfirmationCode = entity.ConfirmationCode;
model.ReservationAmount = entity.TotalRevenue;
ViewBag.Title = "Split Reservation";
}
}
catch
{
}
return(PartialView("_ReservationSplitPartial", model));
}
public JsonResult DeleteRevenue(int id)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
var dataProvider = new ReservationRevenueProvider(_dbContext);
var entity = dataProvider.Retrieve(id);
dataProvider.Delete(id);
dataProvider.Commit();
var provider = new OwnerPayoutProvider(_dbContext);
provider.UpdateOwnerPayoutMatchStatus(entity.OwnerPayoutId);
return(Json("success", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
string message = string.Format("Delete Reservation {0} fails. {1}", id.ToString(), ex.Message + ex.StackTrace);
return(InternalError(message, "fail", ex));
}
}
public ActionResult DetailInfoByConfirmationCode(int id, string data)
{
var provider = new ReservationRevenueProvider(_dbContext);
int reservationId = provider.GetIdByConfirmationCode(data);
return(DetailInfo(reservationId));
}
public JsonResult SaveRevenue(ReservationRevenueModel form)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
// treat checkin and checkout date as Hawaii time zone and covert it to UTC by adding 11 hours.
if (form.PayoutDate != null)
{
form.PayoutDate = ConversionHelper.ToUtcFromUs(form.PayoutDate.Value);
}
if (form.CheckinDate != null)
{
form.CheckinDate = ConversionHelper.ToUtcFromUs(form.CheckinDate.Value);
}
var dataProvider = new ReservationRevenueProvider(_dbContext);
if (form.ReservationId == 0) // new reservation
{
if (dataProvider.GetKey(form) != 0)
{
Response.StatusCode = (int)System.Net.HttpStatusCode.Conflict; // code = 409
return(Json(string.Empty, JsonRequestBehavior.AllowGet));
}
else
{
dataProvider.Create(form);
}
}
else // updating reservation
{
dataProvider.Update(form.ReservationId, form);
}
dataProvider.Commit(); // ReservationId will be filled for new reservation by EF
// get the reservation ID
if (form.ReservationId == 0)
{
form.ReservationId = dataProvider.GetKey(form);
}
var provider = new OwnerPayoutProvider(_dbContext);
provider.UpdateOwnerPayoutMatchStatus(form.OwnerPayoutId);
return(Json(form.ReservationId.ToString(), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var innerErrorMessage = ex.InnerException != null ? ex.InnerException.Message : string.Empty;
string message = string.Format("Saving Reservation {0} fails. {1},{2}", form.ReservationId.ToString(), ex.Message, innerErrorMessage);
return(InternalError(message, string.Empty, ex));
}
}
public JsonResult GetConfirmationCode(string account)
{
if (!AuthorizationProvider.CanViewRevenue())
{
return(Forbidden());
}
var provider = new ReservationRevenueProvider(_dbContext);
var data = provider.GetConfirmationCode(account);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public JsonResult GetMissingPropertyCodes(DateTime month)
{
if (!AuthorizationProvider.CanViewRevenue())
{
return(Forbidden());
}
var provider = new ReservationRevenueProvider(_dbContext);
var model = provider.GetMissingPropertyCodes(month);
return(Json(model, JsonRequestBehavior.AllowGet));
}
public JsonResult RevenueView(DateTime month, string propertyCode)
{
if (!AuthorizationProvider.CanViewRevenue())
{
return(Forbidden());
}
ReservationRevenueProvider provider = new ReservationRevenueProvider(_dbContext);
var viewModel = provider.Retrieve(month, propertyCode);
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
public ActionResult EditRevenue(int Id)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
var provider = new ReservationRevenueProvider(_dbContext);
var reservation = provider.Retrieve(Id);
ViewBag.Title = "Edit Reservation";
ViewBag.ButtonText = string.Format("Update Reservation for Property {0}", reservation.PropertyCode);
return(PartialView("_ReservationEditPartial", reservation));
}
public ActionResult TetrisRevenue(int Id)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
var model = new ResevationTetrisModel();
var provider = new ReservationRevenueProvider(_dbContext);
model.OldPropertyCode = provider.GetPropertyCodeById(Id);
model.ReservationId = Id;
ViewBag.Title = "Change Reservation";
return(PartialView("_ReservationTetrisPartial", model));
}
public JsonResult ConvertRevenue(int id)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
var reservationProvider = new ReservationRevenueProvider(_dbContext);
var entity = reservationProvider.Retrieve(id);
// create resolution entity
var resolutionModel = new ResolutionRevenueModel();
resolutionModel.ResolutionDate = entity.PayoutDate;
resolutionModel.OwnerPayoutId = entity.OwnerPayoutId;
resolutionModel.ConfirmationCode = entity.ConfirmationCode;
resolutionModel.PropertyCode = entity.PropertyCode;
resolutionModel.ResolutionType = "Cancellation";
resolutionModel.ResolutionDescription = "Converted from Reservation";
resolutionModel.ResolutionAmount = entity.TotalRevenue;
resolutionModel.IncludeOnStatement = true;
resolutionModel.Impact = string.Empty;
resolutionModel.ApprovalStatus = RevenueApprovalStatus.NotStarted;
var resolutionProvider = new ResolutionRevenueProvider(_dbContext);
resolutionProvider.Create(resolutionModel);
resolutionProvider.Commit();
// set reservation revenue to 0 and excluded from statement
entity.TotalRevenue = 0;
entity.IncludeOnStatement = false;
reservationProvider.Update(id, entity);
reservationProvider.Commit();
var provider = new OwnerPayoutProvider(_dbContext);
provider.UpdateOwnerPayoutMatchStatus(entity.OwnerPayoutId);
return(Json("success", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
string message = string.Format("Delete Reservation {0} fails. {1}", id.ToString(), ex.Message + ex.StackTrace);
return(InternalError(message, "fail", ex));
}
}
public ActionResult DetailInfo(int id)
{
if (!AuthorizationProvider.CanViewRevenue())
{
return(Forbidden());
}
ViewBag.EditClass = " app-field-readonly";
var details = new ReservationRevenueModel();
try
{
var provider = new ReservationRevenueProvider(_dbContext);
ViewBag.Title = "View Reservation Details";
details = provider.Retrieve(id);
if (details == null)
{
details = new ReservationRevenueModel();
}
// append property code to confirmation code for view-only mode
if (!string.IsNullOrEmpty(details.PropertyCode))
{
if (string.IsNullOrEmpty(details.ConfirmationCode))
{
details.ConfirmationCode = string.Empty;
}
details.ConfirmationCode += " | " + details.PropertyCode;
}
return(PartialView("_ReservationEditPartial", details));
}
catch (Exception ex)
{
string message = string.Format("Retrieve Reservation Details fails. {0}", ex.Message);
DojoLogger.Error(message, typeof(PropertyController));
}
return(PartialView("_ReservationEditPartial", details));
}
public JsonResult UpdateWorkflow(int id, int state, int direction)
{
RevenueApprovalStatus workflowState = (RevenueApprovalStatus)state;
if (!((AuthorizationProvider.CanReviewRevenue() && workflowState == RevenueApprovalStatus.Reviewed) ||
(AuthorizationProvider.CanApproveRevenue() && workflowState == RevenueApprovalStatus.Approved) ||
(AuthorizationProvider.CanFinalizeRevenue() && workflowState == RevenueApprovalStatus.Finalized)))
{
return(Forbidden());
}
try
{
var dataProvider = new ReservationRevenueProvider(_dbContext);
RevenueApprovalStatus?nextState = null;
if (direction > 0)
{
nextState = dataProvider.MoveWorkflow(id, workflowState);
}
else
{
nextState = dataProvider.BacktrackWorkflow(id, workflowState);
}
if (nextState != null)
{
return(Json(nextState, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("-1", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
string message = string.Format("Change Reservation {0} workflow fails. {1}", id.ToString(), ex.Message + ex.StackTrace);
return(InternalError(message, "-1", ex));
}
}
public JsonResult SaveNote(int id, string note)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
var dataProvider = new ReservationRevenueProvider(_dbContext);
var entity = dataProvider.Retrieve(id);
entity.ApprovedNote = note;
dataProvider.Update(id, entity);
dataProvider.Commit();
return(Json(id.ToString(), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var innerErrorMessage = ex.InnerException != null ? ex.InnerException.Message : string.Empty;
string message = string.Format("Saving Reservation {0:d} fails. {1},{2}", id, ex.Message, innerErrorMessage);
return(InternalError(message, string.Empty, ex));
}
}
public JsonResult ChangePropertyCode(ResevationTetrisModel form)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
var dataProvider = new ReservationRevenueProvider(_dbContext);
var entity = dataProvider.Retrieve(form.ReservationId);
entity.PropertyCode = form.NewPropertyCode;
dataProvider.Update(form.ReservationId, entity);
dataProvider.Commit();
return(Json(form.ReservationId.ToString(), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var innerErrorMessage = ex.InnerException != null ? ex.InnerException.Message : string.Empty;
string message = string.Format("Changing Reservation {0:d} property code to {1} fails. {2},{3}", form.ReservationId, form.NewPropertyCode, ex.Message, innerErrorMessage);
return(InternalError(message, string.Empty, ex));
}
}