public void UpdateAppointmentStatus(Guid rowGuid, string statusCode)
{
AG_B_APPOINTMENT appointment = DBContext.AG_B_APPOINTMENT.FirstOrDefault(E => E.ROWGUID == rowGuid);
if (appointment == null)
{
throw new NotFoundException($"Cannot find appointment with RowGuid={rowGuid}");
}
appointmentStatus.CheckNewStatusAllowed(appointment, statusCode);
appointment.STATUS_CODE = statusCode;
EntityMapper.UpdateEntityStandardFields(appointment);
AG_B_APPOINTMENT_STATUS_HISTORY history = DBContext.AG_B_APPOINTMENT_STATUS_HISTORY.FirstOrDefault(E => E.ROWGUID == rowGuid);
if (history != null)
{
if (statusCode == appointmentStatus.Confirmed)
{
history.CONFIRMATION_STATUS = statusCode;
history.CONFIRMED_DATE = DateTime.Now;
history.CONFIRMED_USER = appointment.USERUPDATE;
EntityMapper.UpdateEntityStandardFields(history);
}
else if (statusCode == appointmentStatus.Deleted || statusCode == appointmentStatus.Rescheduled)
{
history.CONFIRMATION_STATUS = statusCode;
history.CANCEL_DATE = DateTime.Now;
history.CANCEL_USER = appointment.USERUPDATE;
EntityMapper.UpdateEntityStandardFields(history);
}
}
DBContext.SaveChanges();
}
private AppointmentListItem DoPost(AppointmentBase value, string campaignCode = null, string mediaTypeCode = null, string callID = null, Guid?rescheduledAppointmentRowGuid = null)
{
if (value == null)
{
throw new ArgumentNullException(nameof(value), "Argument 'value' cannot be null");
}
OperationResult <bool> check = CheckCanBookAppointment(value.CustomerCode, value.AppointmentShopCode, value.ServiceCode, value.AppointmentDate, rescheduledAppointmentRowGuid.GetValueOrDefault(Guid.Empty));
if (!check.Result)
{
throw new InvalidOperationException(check.Message);
}
AG_B_APPOINTMENT Item = EntityMapper.CreateEntity <AG_B_APPOINTMENT>();
AG_B_APPOINTMENT_EXT_AUS ItemExt = EntityMapper.CreateEntity <AG_B_APPOINTMENT_EXT_AUS>();
CU_B_ACTIVITY activity = EntityMapper.CreateEntity <CU_B_ACTIVITY>();
CU_B_ACTIVITY_EXT_AUS activityExt = EntityMapper.CreateEntity <CU_B_ACTIVITY_EXT_AUS>();
AG_B_APPOINTMENT_STATUS_HISTORY history = EntityMapper.CreateEntity <AG_B_APPOINTMENT_STATUS_HISTORY>();
if ((string.IsNullOrWhiteSpace(value.StatusCode) || value.StatusCode == appointmentStatus.Open) && value.AppointmentDate >= DateTime.Today && value.AppointmentDate < DateTime.Today.AddDays(2))
{
value.StatusCode = appointmentStatus.Confirmed;
}
EntityMapper.UpdateEntity(value, Item, ItemExt);
//Add default or other values
Item.APPOINTMENT_ID = ItemExt.APPOINTMENT_ID = string.Format("{0}00{1}", Item.APPOINTMENT_SHOP_CODE, FoxDataService.GetNewCounter("AG_B_APPOINTMENT", "APPOINTMENT_ID", "*", Item.USERINSERT).FORMATTEDVALUE);
if (string.IsNullOrEmpty(Item.SHOP_CODE))
{
Item.SHOP_CODE = ItemExt.SHOP_CODE = Item.LAPTOP_CODE = ItemExt.LAPTOP_CODE = Item.APPOINTMENT_SHOP_CODE;
}
string[] specialAvailabilityServiceCodes = FoxDataService.GetSpecialAvailabilityServiceCodes(Item.SHOP_CODE);
CM_B_SHOP shop = DBContext.CM_B_SHOP.FirstOrDefault(E => E.SHOP_CODE == Item.SHOP_CODE);
activity.ACTIVITY_TYPE_CODE = "PR";
activity.ACTIVITY_DATE = DateTime.Today;
activity.CUSTOMER_CODE = activityExt.CUSTOMER_CODE = Item.CUSTOMER_CODE;
activity.EMPLOYEE_CODE = Item.EMPLOYEE_CODE;
Item.LOCATION_CODE = activity.LOCATION_CODE = shop?.OBJ_CODE;
Item.LOCATION_TYPE_CODE = activity.LOCATION_TYPE_CODE = Item.SHOP_CODE == "000" ? "03" : "01";
Item.STATUS_CODE = Item.STATUS_CODE ?? appointmentStatus.Open;
activity.REFERENCE_DATE = Item.DT_APPOINTMENT;
activity.REFERENCE_NUMBER = Item.APPOINTMENT_ID;
history.APPOINTMENT_ID = activity.APPOINTMENT_ID = Item.APPOINTMENT_ID;
history.SHOP_CODE = history.LAPTOP_CODE = activity.SHOP_CODE = activity.LAPTOP_CODE = activityExt.SHOP_CODE = activityExt.LAPTOP_CODE = Item.SHOP_CODE;
activity.ACTIVITY_ID = activityExt.ACTIVITY_ID = FoxDataService.GetNewCounter("CU_B_ACTIVITY", "ACTIVITY_ID", Item.SHOP_CODE, Item.USERINSERT).VALUE.GetValueOrDefault();
history.CONFIRMATION_STATUS = Item.STATUS_CODE;
history.REASON_CODE = Item.REASON_CODE;
history.ROWGUID = Item.ROWGUID;
/* Disabled FK check
* //Check for valid campaign
* if (!string.IsNullOrWhiteSpace(campaignCode))
* {
* CM_S_CAMPAIGN campaign = DBContext.CM_S_CAMPAIGN.FirstOrDefault(E => E.CAMPAIGN_CODE == campaignCode);
* ItemExt.CAMPAIGN_CODE = activity.CAMPAIGN_CODE = campaign?.CAMPAIGN_CODE;
* }
* //Check for valid mediatype
* if (!string.IsNullOrWhiteSpace(mediaTypeCode))
* {
* CM_S_MEDIATYPE mediaType = DBContext.CM_S_MEDIATYPE.FirstOrDefault(E => E.MEDIATYPE_CODE == mediaTypeCode);
* ItemExt.MEDIATYPE_CODE = activity.MEDIATYPE_CODE = mediaType?.MEDIATYPE_CODE;
* }
*/
ItemExt.CAMPAIGN_CODE = activity.CAMPAIGN_CODE = campaignCode;
ItemExt.MEDIATYPE_CODE = activity.MEDIATYPE_CODE = mediaTypeCode;
ItemExt.SOURCE_TRACKING_ID = callID;
EntityMapper.CheckEntityRowId(activity, activityExt, Guid.NewGuid());
value.SaveData <AG_B_APPOINTMENT>(DBContext, Item);
value.SaveData <CU_B_ACTIVITY>(DBContext, activity);
// Set proper customer shop code if needed
CU_B_ADDRESS_BOOK customer = DBContext.CU_B_ADDRESS_BOOK.FirstOrDefault(E => E.CUSTOMER_CODE == Item.CUSTOMER_CODE && E.CU_B_ADDRESS_BOOK_EXT_AUS.SHOP_CODE == "000");
if (customer != null)
{
customer.CU_B_ADDRESS_BOOK_EXT_AUS.SHOP_CODE = Item.APPOINTMENT_SHOP_CODE;
}
DBContext.AG_B_APPOINTMENT.Add(Item);
DBContext.AG_B_APPOINTMENT_EXT_AUS.Add(ItemExt);
DBContext.CU_B_ACTIVITY.Add(activity);
DBContext.CU_B_ACTIVITY_EXT_AUS.Add(activityExt);
DBContext.AG_B_APPOINTMENT_STATUS_HISTORY.Add(history);
IDbContextTransaction scope = DBContext.Database.CurrentTransaction;
bool ownTransaction = (scope == null);
if (scope == null)
{
scope = DBContext.Database.BeginTransaction();
}
try
{
//Lock the table during this transaction
DBContext.AG_B_APPOINTMENT.FromSql("SELECT TOP 1 * FROM AG_B_APPOINTMENT WITH (TABLOCKX, HOLDLOCK)");
//Check for overlap
DateTime appointmentStart = Item.DT_APPOINTMENT;
DateTime appointmentEnd = Item.DT_APPOINTMENT.AddMinutes(Item.DURATION.GetValueOrDefault());
int overlappedAppointmentCount = DBContext.AG_B_APPOINTMENT.Where(E => AllowedAppointmentStatus.Contains(E.STATUS_CODE) &&
(E.ROOM_CODE == Item.ROOM_CODE || E.EMPLOYEE_CODE == Item.EMPLOYEE_CODE) &&
!specialAvailabilityServiceCodes.Contains(E.AG_S_SERVICE.SERVICE_TYPE_CODE) &&
((E.DT_APPOINTMENT >= appointmentStart && E.DT_APPOINTMENT < appointmentEnd) ||
(E.DT_APPOINTMENT.AddMinutes(E.DURATION.GetValueOrDefault()) > appointmentStart && E.DT_APPOINTMENT.AddMinutes(E.DURATION.GetValueOrDefault()) < appointmentEnd) ||
(E.DT_APPOINTMENT <= appointmentStart && E.DT_APPOINTMENT.AddMinutes(E.DURATION.GetValueOrDefault()) > appointmentEnd))).Count();
if (overlappedAppointmentCount > 0)
{
throw new Exception("There is already an appointment for the given time slot");
}
//Complete the scope here to commit, otherwise it will rollback
//The table lock will be released after we exit the TransactionScope block
DBContext.SaveChanges();
if (ownTransaction)
{
scope.Commit();
}
}
catch (Exception E)
{
if (ownTransaction)
{
scope.Rollback();
}
throw E;
}
return(Get(Item.ROWGUID).Value);
}
