public static OverDue CalculateOverDueRate(DateTime CheckOutTime, long ReservationID, HotelBookingCalculate msg, HotelBookingObject hObject)
{
bool isWeekend = DateIsWeekend(CheckOutTime);
string query = string.Format("Select {0} from CheckTime as a, RoomOverDueRate as b where a.ReservationID = @ReservationID and a.RoomTypeID = b.RoomTypeID", isWeekend ? "b.WeekendRate" : "b.WeekDayRate");
SQLClient sqlclient = new SQLClient();
double overDueRate = sqlclient.GetOverDueRate(query, ReservationID);
DateTime expectedCheckIn = Convert.ToDateTime(hObject.ExpectedCheckInTime);
DateTime expectedCheckOut = Convert.ToDateTime(hObject.ExpectedCheckOutTime);
double expectedHours = expectedCheckOut.Subtract(expectedCheckIn).TotalHours;
bool hoursStretched = ExpectedHoursStretched(expectedHours);
int calculatedHours = Convert.ToInt32(Math.Ceiling(expectedHours));
WriteToFile(string.Format("Calculated Hours for ReservationID {0}: {1}", ReservationID, calculatedHours));
double initialAmount = Convert.ToDouble(hObject.HourlyRate) * calculatedHours;
double overDueAmount = GetOverDueAmount(CheckOutTime, expectedCheckOut, hoursStretched, overDueRate, Convert.ToDouble(hObject.HourlyRate));
double totalAmount = initialAmount + overDueAmount;
OverDue overdue = new OverDue
{
InitialAmount = initialAmount,
OverDueAmount = overDueAmount,
TotalAmount = totalAmount,
WeekendRate = isWeekend
};
return(overdue);
}
public static Dictionary <string, object> GetOverDueRate(long ReservationID, HotelBookingCalculate msg)
{
try
{
HotelBookingObject hObject = ExecuteHotelBookFetch(ReservationID);
if (string.IsNullOrEmpty(hObject.Error))
{
DateTime checkOutTime = Convert.ToDateTime(msg.CheckOutTime);
OverDue overDue = CalculateOverDueRate(checkOutTime, ReservationID, msg, hObject);
return(DeserializeToDictionary(JsonConvert.SerializeObject(overDue)));
}
else
{
Error err = new Error();
err.ErrorMessage = hObject.Error;
return(DeserializeToDictionary(JsonConvert.SerializeObject(err)));
}
}
catch (Exception ex)
{
WriteToFile(string.Format("{0}, {1}, {2}", ex.Message, ex.InnerException, ex.StackTrace));
return(DeserializeToDictionary(string.Format(ex.ToString())));
}
}
