public JsonResult Delete(string model)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
// parameter is passed in as a model with Json string
var entity = JsonConvert.DeserializeObject <ResolutionRevenueModel>(model);
var ownerPayoutId = entity.OwnerPayoutId;
try
{
var dataProvider = new ResolutionRevenueProvider(_dbContext);
dataProvider.Delete(entity.ResolutionId);
dataProvider.Commit();
var provider = new OwnerPayoutProvider(_dbContext);
provider.UpdateOwnerPayoutMatchStatus(ownerPayoutId);
return(Json("success", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(InternalError(string.Format("Delete Resolution {0:d} fails.", entity.ResolutionId), "fail", ex));
}
}
public JsonResult UpdateFieldStatus(int id, string field, int included)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
var provider = new ResolutionRevenueProvider(_dbContext);
var ok = provider.SetFieldStatus(id, field, (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 Resolution '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 UpdateWorkflowAll(DateTime month, 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 ResolutionRevenueProvider(_dbContext);
var nextState = dataProvider.MoveWorkflowAll(month, 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} Resolution workflow bulk update from {1:d} fails. {2}", month.ToString("MM/dd/yyyy"), state, ex.Message + ex.StackTrace);
return(InternalError(message, "-1", ex));
}
}
public JsonResult DeleteRevenue(int id)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
var dataProvider = new ResolutionRevenueProvider(_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 Resolution {0} fails. {1}", id.ToString(), ex.Message + ex.StackTrace);
return(InternalError(message, "fail", ex));
}
}
public JsonResult RetrieveView(DateTime month, string propertyCode)
{
if (!AuthorizationProvider.CanViewRevenue())
{
return(Forbidden());
}
var provider = new ResolutionRevenueProvider(_dbContext);
var view = provider.Retrieve(month, propertyCode);
return(Json(view, JsonRequestBehavior.AllowGet));
}
public ActionResult EditRevenue(int Id)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
var provider = new ResolutionRevenueProvider(_dbContext);
var resolution = provider.Retrieve(Id);
ViewBag.Title = "Edit Resolution";
ViewBag.ButtonText = "Update Resolution";
ViewBag.NewResolution = false;
return(PartialView("_ResolutionEditPartial", resolution));
}
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 JsonResult SaveRevenue(ResolutionRevenueModel form)
{
if (!AuthorizationProvider.CanEditRevenue())
{
return(Forbidden());
}
try
{
// Impact list is defined in lookup table; Advance Payout does not have a confirmation code
if (form.Impact == "Advance Payout")
{
form.ConfirmationCode = string.Empty;
}
var dataProvider = new ResolutionRevenueProvider(_dbContext);
if (form.ResolutionId == 0) // new
{
dataProvider.Create(form);
}
else // update
{
dataProvider.Update(form.ResolutionId, form);
}
dataProvider.Commit(); // ReservationId will be filled for new reservation by EF
// get the resolution ID
if (form.ResolutionId == 0)
{
form.ResolutionId = dataProvider.GetKey(form);
}
var provider = new OwnerPayoutProvider(_dbContext);
provider.UpdateOwnerPayoutMatchStatus(form.OwnerPayoutId);
return(Json(form.ResolutionId.ToString(), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var innerErrorMessage = ex.InnerException != null ? ex.InnerException.Message : string.Empty;
string message = string.Format("Saving Resolution {0} fails. {1},{2}", form.ResolutionId.ToString(), ex.Message, innerErrorMessage);
return(InternalError(message, string.Empty, ex));
}
}
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 ResolutionRevenueProvider(_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));
}
}
