public void Put(Guid rowGuid, [FromBody] AppointmentBase value)
{
if (value == null)
{
throw new ArgumentNullException(nameof(value), $"Argument value cannot be null");
}
AG_B_APPOINTMENT Item = DBContext.AG_B_APPOINTMENT.SingleOrDefault(E => E.ROWGUID == rowGuid);
if (Item == null)
{
throw new NotFoundException($"No appointment found with RowGuid:{rowGuid}");
}
OperationResult <bool> check = CheckCanBookAppointment(value.CustomerCode, value.AppointmentShopCode, value.ServiceCode, value.AppointmentDate, rowGuid);
if (!check.Result)
{
throw new InvalidOperationException(check.Message);
}
EntityMapper.UpdateEntity(value, Item, Item.AG_B_APPOINTMENT_EXT_AUS);
value.SaveData <AG_B_APPOINTMENT>(DBContext, Item);
if (string.IsNullOrEmpty(Item.SHOP_CODE))
{
Item.SHOP_CODE = Item.AG_B_APPOINTMENT_EXT_AUS.SHOP_CODE = Item.LAPTOP_CODE = Item.AG_B_APPOINTMENT_EXT_AUS.LAPTOP_CODE = Item.APPOINTMENT_SHOP_CODE;
}
CM_B_SHOP shop = DBContext.CM_B_SHOP.FirstOrDefault(E => E.SHOP_CODE == Item.SHOP_CODE);
value.SaveData <AG_B_APPOINTMENT>(DBContext, Item);
using (IDbContextTransaction scope = DBContext.Database.BeginTransaction())
{
CheckAppointmentOverlap(Item);
//Complete the scope here to commit, otherwise it will rollback
//The table lock will be released after we exit the TransactionScope block
DBContext.SaveChanges();
scope.Commit();
}
}
public ActionResult <AddressBase> GetClinicAddress(string shopCode)
{
CM_B_SHOP shop = DBContext.CM_B_SHOP.FirstOrDefault(E => E.SHOP_CODE == shopCode);
if (shop == null)
{
throw new NotFoundException($"No clinic found with shopCode = {shopCode}");
}
CM_B_ADDRESS address = DBContext.CM_B_ADDRESS.FirstOrDefault(E => E.OBJ_CODE == shop.OBJ_CODE && E.ADDRESS_COUNTER == 1);
if (address == null)
{
throw new NotFoundException($"No address found with shopCode = {shopCode}");
}
AddressBase Result = EntityMapper.Map <AddressBase, CM_B_ADDRESS>(DBContext, address);
return(Result);
}
public ActionResult <Clinic> GetClinicByPostCode(string postCode)
{
string[] AllowedTypes = { "00", "01", "02" };
int ZipCode = 0;
if (!int.TryParse(postCode, out ZipCode))
{
postCode = null;
}
var qryShop = from shop in DBContext.CM_B_SHOP
join addr in DBContext.CM_B_ADDRESS on shop.OBJ_CODE equals addr.OBJ_CODE
where AllowedTypes.Contains(shop.SHOP_TYPE_CODE) && shop.FLG_ACTIVE == "Y" && !string.IsNullOrWhiteSpace(addr.ZIP_CODE) &&
shop.DT_START.GetValueOrDefault(DateTime.Today.Date) <= DateTime.Today && shop.DT_END.GetValueOrDefault(DateTime.Today) >= DateTime.Today.Date
orderby Math.Abs(Convert.ToInt32(addr.ZIP_CODE) - ZipCode)
select shop;
CM_B_SHOP item = !string.IsNullOrWhiteSpace(postCode) ? qryShop.FirstOrDefault() : DBContext.CM_B_SHOP.FirstOrDefault(E => E.SHOP_CODE == "000");
Clinic Result = EntityMapper.Map <Clinic, CM_B_SHOP>(DBContext, item);
return(Result);
}
public override void LoadData <T>(DbContext context, dynamic entity)
{
base.LoadData <T>(context, (T)entity);
DiaryContext DBContext = (DiaryContext)context;
AG_B_APPOINTMENT appointment = (AG_B_APPOINTMENT)entity;
//EmployeeName = string.Format("{0} {1}", appointment.CM_S_EMPLOYEE?.FIRSTNAME, appointment.CM_S_EMPLOYEE?.LASTNAME);
EmployeeName = appointment.CM_S_EMPLOYEE?.EMPLOYEE_DESCR;
ServiceDescription = appointment.AG_S_SERVICE?.SERVICE_DESCR;
StatusDescription = DBContext.SY_GENERAL_STATUS.FirstOrDefault(E => E.STATUS_CODE == StatusCode)?.STATUS_DESCR;
CU_B_ADDRESS_BOOK Customer = DBContext.CU_B_ADDRESS_BOOK.FirstOrDefault(E => E.CUSTOMER_CODE == CustomerCode);
if (Customer != null)
{
CustomerName = string.Format("{0} {1}", Customer.FIRSTNAME, Customer.LASTNAME);
}
CM_B_SHOP Shop = DBContext.CM_B_SHOP.FirstOrDefault(E => E.SHOP_CODE == AppointmentShopCode);
AppointmentShopDescription = Shop?.SHOP_DESCR;
CM_S_CITY_BOOK_SHOP ShopArea = DBContext.CM_S_CITY_BOOK_SHOP.FirstOrDefault(E => E.SHOP_CODE == AppointmentShopCode);
AreaCode = ShopArea?.AREA_CODE;
CM_S_AREA_BOOK AreaBook = DBContext.CM_S_AREA_BOOK.FirstOrDefault(E => E.AREA_CODE == AreaCode);
AreaDescription = AreaBook?.AREA_DESCR;
RegionCode = AreaBook?.REGION_CODE;
CM_S_REGION_BOOK Region = DBContext.CM_S_REGION_BOOK.FirstOrDefault(E => E.REGION_CODE == RegionCode);
RegionDescription = Region?.REGION_DESCR;
CU_B_ACTIVITY activity = DBContext.CU_B_ACTIVITY.FirstOrDefault(E => E.ACTIVITY_TYPE_CODE == "PR" && E.CUSTOMER_CODE == appointment.CUSTOMER_CODE && E.APPOINTMENT_ID == appointment.APPOINTMENT_ID);
MediaTypeDescription = activity?.CM_S_MEDIATYPE?.MEDIATYPE_DESCR;
AG_S_ROOM room = DBContext.AG_S_ROOM.FirstOrDefault(E => E.SHOP_CODE == appointment.APPOINTMENT_SHOP_CODE && E.ROOM_CODE == appointment.ROOM_CODE);
RoomDescription = room?.ROOM_DESCR;
}
public ActionResult <CustomerExtended> Post([FromBody] Customer value, string XID, string campaignCode, string mediaTypeCode)
{
CheckCustomerAge(value?.Birthday);
CU_B_ADDRESS_BOOK Item = EntityMapper.CreateEntity <CU_B_ADDRESS_BOOK>();
CU_B_ADDRESS_BOOK_EXT_AUS ItemExt = EntityMapper.CreateEntity <CU_B_ADDRESS_BOOK_EXT_AUS>();
CU_B_ACTIVITY activity = EntityMapper.CreateEntity <CU_B_ACTIVITY>();
CU_B_ACTIVITY_EXT_AUS activityExt = EntityMapper.CreateEntity <CU_B_ACTIVITY_EXT_AUS>();
EntityMapper.UpdateEntity(value, Item, ItemExt);
CM_B_SHOP shop = DBContext.CM_B_SHOP.FirstOrDefault(E => E.SHOP_CODE == ItemExt.SHOP_CODE);
//Add default values
Item.CUSTOMER_TYPE_CODE = "QL";
Item.COUNTRY_CODE = Settings.Value.CountryCode;
//Item.GENDER_CODE = Item.GENDER_CODE ?? "U";
Item.STATUS_CODE = "00"; //Force status to Active to avoid FOX issues
ItemExt.CURRENT_FILE_LOCATION = "000"; //Head office
ItemExt.CURRENT_LOCATION_TYPE_CODE = "00"; //Head office
ItemExt.SHOP_CODE = "000"; //Head office
Item.CUSTOMER_ID = XID;
//
Item.CUSTOMER_CODE = FoxDataService.GetNewCounter("CU_B_ADDRESS_BOOK", "CUSTOMER_CODE", ItemExt.SHOP_CODE, Item.USERINSERT).FORMATTEDVALUE;
activityExt.CUSTOMER_CODE = activity.CUSTOMER_CODE = value.ID = ItemExt.CUSTOMER_CODE = Item.CUSTOMER_CODE;
EntityMapper.InitializeEntityStandardFields(activity);
EntityMapper.InitializeEntityStandardFields(activityExt);
activity.ACTIVITY_TYPE_CODE = "RR";
activity.ACTIVITY_DATE = DateTime.Today;
activity.LAPTOP_CODE = activityExt.LAPTOP_CODE = activity.SHOP_CODE = activityExt.SHOP_CODE = ItemExt.SHOP_CODE;
activity.LOCATION_CODE = ItemExt.SHOP_CODE;
activity.LOCATION_TYPE_CODE = ItemExt.SHOP_CODE == "000" ? "03" : "01";
activity.ACTIVITY_ID = activityExt.ACTIVITY_ID = FoxDataService.GetNewCounter("CU_B_ACTIVITY", "ACTIVITY_ID", ItemExt.SHOP_CODE, Item.USERINSERT).VALUE.GetValueOrDefault();
EntityMapper.CheckEntityRowId(activity, activityExt, Guid.NewGuid());
/* 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);
* 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);
* activity.MEDIATYPE_CODE = mediaType?.MEDIATYPE_CODE;
* }
*/
activity.CAMPAIGN_CODE = campaignCode;
activity.MEDIATYPE_CODE = mediaTypeCode;
DBContext.CU_B_ADDRESS_BOOK.Add(Item);
DBContext.CU_B_ADDRESS_BOOK_EXT_AUS.Add(ItemExt);
DBContext.CU_B_ACTIVITY.Add(activity);
DBContext.CU_B_ACTIVITY_EXT_AUS.Add(activityExt);
value.SaveData <CU_B_ADDRESS_BOOK>(DBContext, Item);
if (value.Addresses != null)
{
int? AddressCounter = null;
Address Addr = value.Addresses.FirstOrDefault(E => E.IsHomeAddress);
if (Addr != null)
{
CreateAddressEntity(Addr, ref AddressCounter, Item.CUSTOMER_CODE);
}
Addr = value.Addresses.FirstOrDefault(E => !E.IsHomeAddress && E.IsInvoiceDefault);
if (Addr != null)
{
CreateAddressEntity(Addr, ref AddressCounter, Item.CUSTOMER_CODE);
}
Addr = value.Addresses.FirstOrDefault(E => !E.IsHomeAddress && E.IsMailingDefault);
if (Addr != null)
{
CreateAddressEntity(Addr, ref AddressCounter, Item.CUSTOMER_CODE);
}
Addr = value.Addresses.FirstOrDefault(E => !E.IsHomeAddress && E.IsOtherContact);
if (Addr != null)
{
CreateAddressEntity(Addr, ref AddressCounter, Item.CUSTOMER_CODE);
}
Addr = value.Addresses.FirstOrDefault(E => !E.IsHomeAddress && E.IsHomeVisitDefault);
if (Addr != null)
{
CreateAddressEntity(Addr, ref AddressCounter, Item.CUSTOMER_CODE);
}
}
if (!string.IsNullOrWhiteSpace(XID)) //Creating customer from lead
{
CU_B_LEAD_EXT_AUS Lead = DBContext.CU_B_LEAD_EXT_AUS.FirstOrDefault(E => E.XID == XID);
if (Lead != null)
{
Lead.CUSTOMER_CODE = Item.CUSTOMER_CODE;
Lead.STATUS_CODE = "30";
EntityMapper.UpdateEntityStandardFields(Lead);
}
}
DBContext.Database.GetDbConnection().Open();
try
{
var Transaction = DBContext.Database.GetDbConnection().BeginTransaction();
try
{
DBContext.Database.UseTransaction(Transaction);
DBContext.SaveChanges();
StringBuilder SQL = new StringBuilder("p_CU_B_CUSTOMER_MAPPING_getxidfrom_Customer_Code");
/*
* SQL.Append("@COMPANY_CODE = {0} ");
* SQL.Append(", @DIVISION_CODE = {1}");
* SQL.Append(", @CUSTOMER_CODE = {2}");
* SQL.Append(", @DT_INSERT = {3}");
* SQL.Append(", @USERINSERT = {4}");
* SQL.Append(", @DT_UPDATE = {5}");
* SQL.Append(", @USERUPDATE = {6}");
*/
object[] parameters = new object[] { Settings.Value.CompanyCode, Settings.Value.CompanyCode, Item.CUSTOMER_CODE, Item.DT_INSERT, Item.USERINSERT, Item.DT_UPDATE, Item.USERUPDATE };
var Connection = DBContext.Database.GetDbConnection();
var Command = Connection.CreateCommand();
Command.Transaction = Transaction;
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = SQL.ToString();
Command.Parameters.Add(new SqlParameter("@COMPANY_CODE", Settings.Value.CompanyCode));
Command.Parameters.Add(new SqlParameter("@DIVISION_CODE", Settings.Value.DivisionCode));
Command.Parameters.Add(new SqlParameter("@CUSTOMER_CODE", Item.CUSTOMER_CODE));
Command.Parameters.Add(new SqlParameter("@DT_INSERT", Item.DT_INSERT));
Command.Parameters.Add(new SqlParameter("@USERINSERT", Item.USERINSERT));
Command.Parameters.Add(new SqlParameter("@DT_UPDATE", Item.DT_UPDATE));
Command.Parameters.Add(new SqlParameter("@USERUPDATE", Item.USERUPDATE));
Command.ExecuteNonQuery();
//DBContext.Database.ExecuteSqlCommand(SQL.ToString(), parameters: parameters);
Transaction.Commit();
}
catch (Exception E)
{
Transaction.Rollback();
throw E;
}
return(Get(Item.CUSTOMER_CODE));
}
finally
{
DBContext.Database.GetDbConnection().Close();
}
}
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);
}
