public PopulateSubsidyBillingResult Step4(Step4Command command)
{
if (command.Period == default)
{
throw new Exception("Missing parameter: Period");
}
if (command.Period.Day != 1 || command.Period.Hour != 0 || command.Period.Minute != 0 || command.Period.Second != 0)
{
throw new Exception("Period must be midnight on the first day of the month.");
}
var startedAt = DateTime.Now;
using (var conn = NewConnection())
{
conn.Open();
var step4 = new BillingDataProcessStep4Subsidy(new Step4Config {
Connection = conn, Context = "ProcessRepository.Step4", Period = command.Period, ClientID = command.ClientID
});
PopulateSubsidyBillingResult result;
switch (command.Command)
{
case "subsidy":
result = step4.PopulateSubsidyBilling();
break;
case "distribution":
step4.DistributeSubsidyMoneyEvenly();
result = new PopulateSubsidyBillingResult(startedAt)
{
Command = "distribution",
Period = command.Period,
ClientID = command.ClientID,
RowsExtracted = 0,
RowsDeleted = 0,
RowsLoaded = 0
};
break;
default:
throw new Exception($"Unknown command: {command.Command}");
}
conn.Close();
return(result);
}
}
public UpdateClientBillingResult UpdateClientBilling(UpdateClientBillingCommand command)
{
if (command.Period == default)
{
throw new Exception("Missing parameter: Period");
}
if (command.Period.Day != 1)
{
throw new Exception("Period must be the first day of the month.");
}
using (var conn = NewConnection())
{
conn.Open();
DateTime now = DateTime.Now;
DateTime sd = command.Period;
DateTime ed = command.Period.AddMonths(1);
var toolDataClean = new WriteToolDataCleanProcess(new WriteToolDataCleanConfig {
Connection = conn, Context = "ProcessRepository.UpdateClientBilling", StartDate = sd, EndDate = ed, ClientID = command.ClientID
});
var toolData = new WriteToolDataProcess(WriteToolDataConfig.Create(conn, "ProcessRepository.UpdateClientBilling", sd, command.ClientID, 0, Cost.GetToolCosts(sd, 0)));
var roomDataClean = new WriteRoomDataCleanProcess(new WriteRoomDataCleanConfig {
Connection = conn, Context = "ProcessRepository.UpdateClientBilling", StartDate = sd, EndDate = ed, ClientID = command.ClientID
});
var roomData = new WriteRoomDataProcess(new WriteRoomDataConfig {
Connection = conn, Context = "ProcessRepository.UpdateClientBilling", Period = sd, ClientID = command.ClientID, RoomID = 0
});
var pr1 = toolDataClean.Start();
var pr2 = roomDataClean.Start();
var pr3 = toolData.Start();
var pr4 = roomData.Start();
bool temp = DateTime.Now.FirstOfMonth() == command.Period;
var step1 = new BillingDataProcessStep1(new Step1Config {
Connection = conn, Context = "ProcessRepository.UpdateClientBilling", Period = command.Period, Now = now, ClientID = command.ClientID, IsTemp = temp
});
var pr5 = step1.PopulateToolBilling();
var pr6 = step1.PopulateRoomBilling();
PopulateSubsidyBillingResult pr7 = null;
if (!temp)
{
var step4 = new BillingDataProcessStep4Subsidy(new Step4Config {
Connection = conn, Context = "ProcessRepository.UpdateClientBilling", Period = command.Period, ClientID = command.ClientID
});
pr7 = step4.PopulateSubsidyBilling();
}
var result = new UpdateClientBillingResult
{
WriteToolDataCleanProcessResult = pr1,
WriteRoomDataCleanProcessResult = pr2,
WriteToolDataProcessResult = pr3,
WriteRoomDataProcessResult = pr4,
PopulateToolBillingProcessResult = pr5,
PopulateRoomBillingProcessResult = pr6,
PopulateSubsidyBillingProcessResult = pr7
};
conn.Close();
return(result);
}
}
public void ProcessRequest(HttpContext context)
{
HttpContextBase ctx = new HttpContextWrapper(context);
ctx.Response.ContentType = "application/json";
string command = ctx.Request["Command"];
int clientId = Utility.ConvertTo(ctx.Request["ClientID"], 0);
DateTime period;
object result;
if (command == "update-billing")
{
period = Convert.ToDateTime(ctx.Request["Period"]);
Provider.Billing.Process.UpdateBilling(new UpdateBillingArgs
{
BillingCategory = BillingCategory.Tool | BillingCategory.Room,
ClientID = clientId,
Periods = new[] { period }
});
result = new { Error = false, Message = "ok" };
}
else if (command == "reservation-history-billing-update")
{
bool error = false;
string msg = "OK!";
DataCleanResult dataCleanResult = null;
DataResult dataResult = null;
Step1Result step1Result = null;
PopulateSubsidyBillingResult step4Result = null;
bool isTemp;
try
{
period = Convert.ToDateTime(ctx.Request["Period"]);
isTemp = Utility.IsCurrentPeriod(period);
dataCleanResult = Provider.Billing.Process.DataClean(new DataCleanCommand
{
BillingCategory = BillingCategory.Tool | BillingCategory.Room,
ClientID = clientId,
StartDate = period,
EndDate = period.AddMonths(1)
});
dataResult = Provider.Billing.Process.Data(new DataCommand
{
BillingCategory = BillingCategory.Tool | BillingCategory.Room,
ClientID = clientId,
Period = period,
Record = 0
});
step1Result = Provider.Billing.Process.Step1(new Step1Command
{
BillingCategory = BillingCategory.Tool | BillingCategory.Room,
ClientID = clientId,
Period = period,
Record = 0,
Delete = true,
IsTemp = isTemp
});
// [2022-01-06 jg] Adding subsidy calculation, not sure why this wasn't already being done. Definitely need to recalculate in case account is changed from
// internal to external or vice versa.
step4Result = Provider.Billing.Process.Step4(new Step4Command
{
ClientID = clientId,
Period = period,
Command = "subsidy"
});
// [2022-01-06 jg] This error check does not work for staff because repair reservations exist in ToolDataClean
// but are not added to ToolData (and subsequently ToolBilling), so ToolDataClean rows loaded
// can be greater than ToolData rows loaded. So now it will be skipped if the client is staff.
var c = Provider.Data.Client.GetClient(clientId);
if (!c.HasPriv(ClientPrivilege.Staff))
{
var toolDataRowsLoaded = dataResult.WriteToolDataProcessResult.RowsLoaded;
var toolDataCleanRowsLoaded = dataCleanResult.WriteToolDataCleanProcessResult.RowsLoaded;
var step1RowsLoaded = step1Result.PopulateToolBillingProcessResult.RowsLoaded;
string errmsg = string.Empty;
if (toolDataRowsLoaded < toolDataCleanRowsLoaded)
{
errmsg += $" Tool data row count ({toolDataRowsLoaded}) is less than tool data clean row count ({toolDataCleanRowsLoaded}).";
}
if (step1RowsLoaded < toolDataRowsLoaded)
{
errmsg += $" Step1 row count ({step1RowsLoaded}) is less than tool data row count ({toolDataRowsLoaded}).";
}
var errorCheck =
toolDataRowsLoaded >= toolDataCleanRowsLoaded &&
step1RowsLoaded >= toolDataRowsLoaded;
if (!errorCheck)
{
throw new Exception($"A problem occurred when trying to update billing data. {errmsg} Period: {period:yyyy-MM-dd:HH:mm:ss}, ClientID: {clientId}, Rows Loaded: DataClean = {dataCleanResult.WriteToolDataCleanProcessResult.RowsLoaded}, Data = {dataResult.WriteToolDataProcessResult.RowsLoaded}, Step1 = {step1Result.PopulateToolBillingProcessResult.RowsLoaded}");
}
}
}
catch (Exception ex)
{
error = true;
msg = ex.Message;
SendEmail.SendDebugEmail(clientId, "LNF.Web.Scheduler.Handlers.ReservationHandler.ProcessRequest", $"[DEBUG:{DateTime.Now:yyyy-MM-dd HH:mm:ss}] An error occurred while updating billing from the Reservation History page.", msg);
}
result = new { Error = error, Message = msg, DataCleanResult = dataCleanResult, DataResult = dataResult, Step1Result = step1Result, Step4Result = step4Result };
}
else if (command == "get-clients-for-reservation-history")
{
bool isok = clientId > 0;
DateTime sd, ed;
if (string.IsNullOrEmpty(ctx.Request.Form["StartDate"]))
{
sd = Reservations.MinReservationBeginDate;
}
else
{
isok &= DateTime.TryParse(ctx.Request.Form["StartDate"], out sd);
}
if (string.IsNullOrEmpty(ctx.Request.Form["EndDate"]))
{
ed = Reservations.MaxReservationEndDate;
}
else
{
isok &= DateTime.TryParse(ctx.Request.Form["EndDate"], out ed);
}
IEnumerable <ReservationHistoryClient> clients = null;
if (isok)
{
clients = ReservationHistoryUtility.Create(Provider).SelectReservationHistoryClients(sd, ed, clientId);
result = new { Error = false, Message = "OK", Clients = clients };
}
else
{
result = new { Error = true, Message = "One or more parameters are invalid.", Clients = clients };
}
}
else if (int.TryParse(ctx.Request["ReservationID"], out int reservationId))
{
switch (command)
{
case "start-reservation":
clientId = ctx.CurrentUser(Provider).ClientID;
result = ReservationHandlerUtility.Start(ctx, Provider, reservationId, clientId);
break;
case "get-reservation":
result = ReservationHandlerUtility.GetReservation(ctx, Provider, reservationId);
break;
case "save-reservation-history":
string notes = ctx.Request["Notes"];
double forgivenPct = Utility.ConvertTo(ctx.Request["ForgivenPct"], 0D);
int accountId = Utility.ConvertTo(ctx.Request["AccountId"], 0);
bool emailClient = Utility.ConvertTo(ctx.Request["EmailClient"], false);
double chargeMultiplier = 1.00 - (forgivenPct / 100.0);
clientId = ctx.CurrentUser(Provider).ClientID;
var model = new ReservationHistoryUpdate()
{
ReservationID = reservationId,
AccountID = accountId,
ChargeMultiplier = chargeMultiplier,
Notes = notes,
EmailClient = emailClient,
ClientID = clientId
};
bool updateResult = Provider.Scheduler.Reservation.UpdateReservationHistory(model);
string msg = updateResult ? "OK" : "An error occurred.";
result = new
{
Error = !updateResult,
Message = msg
};
break;
case "test":
result = new { Error = false, Message = "ok" };
break;
case "":
throw new Exception("Missing parameter: command");
default:
throw new Exception("Invalid command: " + command);
}
}
else
{
throw new Exception("Missing parameter: command");
}
ctx.Response.Write(JsonConvert.SerializeObject(result));
}
