protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5DO_SDaSA_1634 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
foreach (var item in Parameter.AvailabilityDate)
{
#region Delete
if (item.IsDeleted)
{
ORM_CMN_BPT_BusinessParticipant_Availability.Query.SoftDelete(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant_Availability.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_BPT_BusinessParticipant_AvailabilityID = item.OfficeAvailabilityID
});
}
#endregion
else
{
var officeAvailabilityQuery = new ORM_CMN_BPT_BusinessParticipant_Availability.Query();
officeAvailabilityQuery.Tenant_RefID = securityTicket.TenantID;
officeAvailabilityQuery.IsDeleted = false;
officeAvailabilityQuery.CMN_BPT_BusinessParticipant_AvailabilityID = item.OfficeAvailabilityID;
var bpAvailability = ORM_CMN_BPT_BusinessParticipant_Availability.Query.Search(Connection, Transaction, officeAvailabilityQuery).SingleOrDefault();
#region Save
if (bpAvailability == null)
{
bpAvailability = new ORM_CMN_BPT_BusinessParticipant_Availability();
bpAvailability.CMN_BPT_BusinessParticipant_AvailabilityID = item.OfficeAvailabilityID;
bpAvailability.BusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID;
bpAvailability.CMN_CAL_AVA_Availability_RefID = Guid.NewGuid();
bpAvailability.Tenant_RefID = securityTicket.TenantID;
bpAvailability.Creation_Timestamp = DateTime.Now;
bpAvailability.Save(Connection, Transaction);
var availability = new ORM_CMN_CAL_AVA_Availability();
availability.CMN_CAL_AVA_AvailabilityID = bpAvailability.CMN_CAL_AVA_Availability_RefID;
availability.Tenant_RefID = securityTicket.TenantID;
availability.Creation_Timestamp = DateTime.Now;
var availabilityTypeQuery = new ORM_CMN_CAL_AVA_Availability_Type.Query();
availabilityTypeQuery.IsDeleted = false;
availabilityTypeQuery.Tenant_RefID = securityTicket.TenantID;
availabilityTypeQuery.GlobalPropertyMatchingID = item.Type;
var availabilityType = ORM_CMN_CAL_AVA_Availability_Type.Query.Search(Connection, Transaction, availabilityTypeQuery).First();
availability.Office_RefID = item.OfficeID;
availability.AvailabilityType_RefID = availabilityType.CMN_CAL_AVA_Availability_TypeID;
availability.IsAvailabilityExclusionItem = item.IsException;
availability.Save(Connection, Transaction);
Guid EventId = Guid.NewGuid();
var date = new ORM_CMN_CAL_AVA_Date();
date.CMN_CAL_AVA_DateID = Guid.NewGuid();
date.Availability_RefID = availability.CMN_CAL_AVA_AvailabilityID;
date.CMN_CAL_Event_RefID = EventId;
date.DateName = item.AvailabilityDate_Name;
date.DateComment = item.Reason;
date.Tenant_RefID = securityTicket.TenantID;
date.Creation_Timestamp = DateTime.Now;
date.Save(Connection, Transaction);
var events = new ORM_CMN_CAL_Event();
events.CMN_CAL_EventID = EventId;
events.IsRepetitive = item.IsRepetitive;
events.StartTime = item.AvailabilityDate_From;
events.EndTime = item.AvailabilityDate_To;
events.Tenant_RefID = securityTicket.TenantID;
events.Creation_Timestamp = DateTime.Now;
events.IsWholeDayEvent = item.IsWholeDay;
if (item.IsRepetitive)
{
events.Repetition_RefID = Guid.NewGuid();
var repetitions = new ORM_CMN_CAL_Repetition();
repetitions.CMN_CAL_RepetitionID = events.Repetition_RefID;
repetitions.IsMonthly = item.IsMontly;
repetitions.IsWeekly = item.IsWeekly;
repetitions.IsDaily = item.IsDaily;
repetitions.IsYearly = item.IsYearly;
repetitions.Tenant_RefID = securityTicket.TenantID;
repetitions.Creation_Timestamp = DateTime.Now;
repetitions.Save(Connection, Transaction);
if (item.IsWeekly)
{
var repetitionWeekly = new ORM_CMN_CAL_RepetitionPatterns_Weekly();
repetitionWeekly.CMN_CAL_RepetitionPattern_WeeklyID = Guid.NewGuid();
repetitionWeekly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionWeekly.Tenant_RefID = securityTicket.TenantID;
repetitionWeekly.Creation_Timestamp = DateTime.Now;
repetitionWeekly.HasRepeatingOn_Fridays = item.HasRepeatingOn_Fridays;
repetitionWeekly.HasRepeatingOn_Mondays = item.HasRepeatingOn_Mondays;
repetitionWeekly.HasRepeatingOn_Saturdays = item.HasRepeatingOn_Saturdays;
repetitionWeekly.HasRepeatingOn_Sundays = item.HasRepeatingOn_Sundays;
repetitionWeekly.HasRepeatingOn_Thursdays = item.HasRepeatingOn_Thursdays;
repetitionWeekly.HasRepeatingOn_Tuesdays = item.HasRepeatingOn_Tuesdays;
repetitionWeekly.HasRepeatingOn_Wednesdays = item.HasRepeatingOn_Wednesdays;
repetitionWeekly.Save(Connection, Transaction);
}
if (item.IsMontly)
{
var repetitionMontly = new ORM_CMN_CAL_RepetitionPatterns_Monthly();
repetitionMontly.CMN_CAL_RepetitionPattern_MonthlyID = Guid.NewGuid();
repetitionMontly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionMontly.Tenant_RefID = securityTicket.TenantID;
repetitionMontly.Creation_Timestamp = DateTime.Now;
repetitionMontly.Save(Connection, Transaction);
}
if (item.IsDaily)
{
var repetitionDaily = new ORM_CMN_CAL_RepetitionPatterns_Daily();
repetitionDaily.CMN_CAL_RepetitionPattern_DailyID = Guid.NewGuid();
repetitionDaily.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionDaily.Tenant_RefID = securityTicket.TenantID;
repetitionDaily.Creation_Timestamp = DateTime.Now;
repetitionDaily.Save(Connection, Transaction);
}
if (item.IsYearly)
{
var repetitionYearly = new ORM_CMN_CAL_RepetitionPatterns_Yearly();
repetitionYearly.CMN_CAL_RepetitionPattern_YearlyID = Guid.NewGuid();
repetitionYearly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionYearly.Tenant_RefID = securityTicket.TenantID;
repetitionYearly.Creation_Timestamp = DateTime.Now;
repetitionYearly.Save(Connection, Transaction);
}
}
events.Save(Connection, Transaction);
}
#endregion
#region Edit
else
{
bpAvailability.Save(Connection, Transaction);
var eventsQuery = new ORM_CMN_CAL_Event.Query();
eventsQuery.IsDeleted = false;
eventsQuery.Tenant_RefID = securityTicket.TenantID;
var availability = ORM_CMN_CAL_AVA_Availability.Query.Search(Connection, Transaction, new ORM_CMN_CAL_AVA_Availability.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_CAL_AVA_AvailabilityID = bpAvailability.CMN_CAL_AVA_Availability_RefID
}).Single();
availability.Office_RefID = item.OfficeID;
availability.Save(Connection, Transaction);
var dateQuery = new ORM_CMN_CAL_AVA_Date.Query();
dateQuery.IsDeleted = false;
dateQuery.Tenant_RefID = securityTicket.TenantID;
dateQuery.Availability_RefID = bpAvailability.CMN_CAL_AVA_Availability_RefID;
var date = ORM_CMN_CAL_AVA_Date.Query.Search(Connection, Transaction, dateQuery).Single();
date.DateName = item.AvailabilityDate_Name;
date.DateComment = item.Reason;
date.Save(Connection, Transaction);
eventsQuery.CMN_CAL_EventID = date.CMN_CAL_Event_RefID;
var Events = ORM_CMN_CAL_Event.Query.Search(Connection, Transaction, eventsQuery).Single();
Events.IsRepetitive = item.IsRepetitive;
Events.IsWholeDayEvent = item.IsWholeDay;
Events.StartTime = item.AvailabilityDate_From;
Events.EndTime = item.AvailabilityDate_To;
#region delete old repetation if exists
var repetitionsQuery = new ORM_CMN_CAL_Repetition.Query();
repetitionsQuery.IsDeleted = false;
repetitionsQuery.Tenant_RefID = securityTicket.TenantID;
repetitionsQuery.CMN_CAL_RepetitionID = Events.Repetition_RefID;
var repetitions = ORM_CMN_CAL_Repetition.Query.Search(Connection, Transaction, repetitionsQuery).SingleOrDefault();
if (repetitions != null)
{
repetitions.IsDeleted = true;
repetitions.Save(Connection, Transaction);
if (repetitions.IsWeekly)
{
ORM_CMN_CAL_RepetitionPatterns_Weekly.Query.SoftDelete(Connection, Transaction, new ORM_CMN_CAL_RepetitionPatterns_Weekly.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Repetition_RefID = repetitions.CMN_CAL_RepetitionID,
});
}
if (repetitions.IsMonthly)
{
ORM_CMN_CAL_RepetitionPatterns_Monthly.Query.SoftDelete(Connection, Transaction, new ORM_CMN_CAL_RepetitionPatterns_Monthly.Query()
{
Repetition_RefID = repetitions.CMN_CAL_RepetitionID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
}
if (repetitions.IsDaily)
{
ORM_CMN_CAL_RepetitionPatterns_Daily.Query.SoftDelete(Connection, Transaction, new ORM_CMN_CAL_RepetitionPatterns_Daily.Query()
{
Repetition_RefID = repetitions.CMN_CAL_RepetitionID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
}
if (repetitions.IsYearly)
{
ORM_CMN_CAL_RepetitionPatterns_Yearly.Query.SoftDelete(Connection, Transaction, new ORM_CMN_CAL_RepetitionPatterns_Yearly.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Repetition_RefID = repetitions.CMN_CAL_RepetitionID
});
}
}
#endregion
if (item.IsRepetitive)
{
Events.Repetition_RefID = Guid.NewGuid();
repetitions = new ORM_CMN_CAL_Repetition();
repetitions.CMN_CAL_RepetitionID = Events.Repetition_RefID;
repetitions.IsMonthly = item.IsMontly;
repetitions.IsWeekly = item.IsWeekly;
repetitions.IsDaily = item.IsDaily;
repetitions.IsYearly = item.IsYearly;
repetitions.Tenant_RefID = securityTicket.TenantID;
repetitions.Creation_Timestamp = DateTime.Now;
repetitions.Save(Connection, Transaction);
if (item.IsWeekly)
{
var repetitionWeekly = new ORM_CMN_CAL_RepetitionPatterns_Weekly();
repetitionWeekly.CMN_CAL_RepetitionPattern_WeeklyID = Guid.NewGuid();
repetitionWeekly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionWeekly.Tenant_RefID = securityTicket.TenantID;
repetitionWeekly.Creation_Timestamp = DateTime.Now;
repetitionWeekly.HasRepeatingOn_Fridays = item.HasRepeatingOn_Fridays;
repetitionWeekly.HasRepeatingOn_Mondays = item.HasRepeatingOn_Mondays;
repetitionWeekly.HasRepeatingOn_Saturdays = item.HasRepeatingOn_Saturdays;
repetitionWeekly.HasRepeatingOn_Sundays = item.HasRepeatingOn_Sundays;
repetitionWeekly.HasRepeatingOn_Thursdays = item.HasRepeatingOn_Thursdays;
repetitionWeekly.HasRepeatingOn_Tuesdays = item.HasRepeatingOn_Tuesdays;
repetitionWeekly.HasRepeatingOn_Wednesdays = item.HasRepeatingOn_Wednesdays;
repetitionWeekly.Save(Connection, Transaction);
}
if (item.IsMontly)
{
var repetitionMontly = new ORM_CMN_CAL_RepetitionPatterns_Monthly();
repetitionMontly.CMN_CAL_RepetitionPattern_MonthlyID = Guid.NewGuid();
repetitionMontly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionMontly.Tenant_RefID = securityTicket.TenantID;
repetitionMontly.Creation_Timestamp = DateTime.Now;
repetitionMontly.Save(Connection, Transaction);
}
if (item.IsDaily)
{
var repetitionDaily = new ORM_CMN_CAL_RepetitionPatterns_Daily();
repetitionDaily.CMN_CAL_RepetitionPattern_DailyID = Guid.NewGuid();
repetitionDaily.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionDaily.Tenant_RefID = securityTicket.TenantID;
repetitionDaily.Creation_Timestamp = DateTime.Now;
repetitionDaily.Save(Connection, Transaction);
}
if (item.IsYearly)
{
var repetitionYearly = new ORM_CMN_CAL_RepetitionPatterns_Yearly();
repetitionYearly.CMN_CAL_RepetitionPattern_YearlyID = Guid.NewGuid();
repetitionYearly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionYearly.Tenant_RefID = securityTicket.TenantID;
repetitionYearly.Creation_Timestamp = DateTime.Now;
repetitionYearly.Save(Connection, Transaction);
}
}
Events.Save(Connection, Transaction);
}
#endregion
}
}
var emp = ORM_CMN_BPT_EMP_Employee.Query.Search(Connection, Transaction, new ORM_CMN_BPT_EMP_Employee.Query {
BusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID
}).FirstOrDefault();
var oficeToDoctorList = ORM_CMN_BPT_EMP_Employee_2_Office.Query.Search(Connection, Transaction, new ORM_CMN_BPT_EMP_Employee_2_Office.Query {
CMN_BPT_EMP_Employee_RefID = emp.CMN_BPT_EMP_EmployeeID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID
});
if (Parameter.UpdateSlots)
{
foreach (var o2d in oficeToDoctorList)
{
cls_CreateUpdate_Slots_for_Practice.Invoke(Connection, Transaction, new P_L5S_SUSfP_1708()
{
PracticeID = o2d.CMN_STR_Office_RefID
}, securityTicket);
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5OU_SPUOH_1111 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
foreach (var item in Parameter.OpeningHours)
{
#region Non-working Hours
if (item.IsNonWorkingHours)
{
var workTimeExceptionsQuery = new ORM_CMN_STR_Office_WorktimeTemplateException.Query();
workTimeExceptionsQuery.IsDeleted = false;
workTimeExceptionsQuery.Tenant_RefID = securityTicket.TenantID;
workTimeExceptionsQuery.Office_RefID = Parameter.OfficeID;
workTimeExceptionsQuery.CMN_STR_Office_WorktimeTemplateExceptionID = item.TimeID;
var workTimeExceptions = ORM_CMN_STR_Office_WorktimeTemplateException.Query.Search(Connection, Transaction, workTimeExceptionsQuery).SingleOrDefault();
#region Delete
if (item.IsDeleted)
{
if (workTimeExceptions != null)
{
workTimeExceptions.IsDeleted = true;
workTimeExceptions.Save(Connection, Transaction);
}
}
#endregion
else
{
#region Save
if (workTimeExceptions == null)
{
workTimeExceptions = new ORM_CMN_STR_Office_WorktimeTemplateException();
workTimeExceptions.CMN_STR_Office_WorktimeTemplateExceptionID = item.TimeID;
workTimeExceptions.CMN_CAL_Event_RefID = Guid.NewGuid();
workTimeExceptions.Office_RefID = Parameter.OfficeID;
workTimeExceptions.Description = item.Description;
workTimeExceptions.Tenant_RefID = securityTicket.TenantID;
workTimeExceptions.Creation_Timestamp = DateTime.Now;
workTimeExceptions.Save(Connection, Transaction);
var Events = new ORM_CMN_CAL_Event();
Events.CMN_CAL_EventID = workTimeExceptions.CMN_CAL_Event_RefID;
Events.IsRepetitive = item.IsRepetitive;
Events.IsWholeDayEvent = item.IsWholeDay;
Events.StartTime = item.StartDate;
Events.EndTime = item.EndDate;
Events.Tenant_RefID = securityTicket.TenantID;
Events.Creation_Timestamp = DateTime.Now;
if (item.IsRepetitive)
{
Events.Repetition_RefID = Guid.NewGuid();
var repetitions = new ORM_CMN_CAL_Repetition();
repetitions.CMN_CAL_RepetitionID = Events.Repetition_RefID;
repetitions.IsMonthly = item.IsMontly;
repetitions.IsWeekly = item.IsWeekly;
repetitions.IsDaily = item.IsDaily;
repetitions.IsYearly = item.IsYearly;
repetitions.Tenant_RefID = securityTicket.TenantID;
repetitions.Creation_Timestamp = DateTime.Now;
repetitions.Save(Connection, Transaction);
if (item.IsWeekly)
{
var repetitionWeekly = new ORM_CMN_CAL_RepetitionPatterns_Weekly();
repetitionWeekly.CMN_CAL_RepetitionPattern_WeeklyID = Guid.NewGuid();
repetitionWeekly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionWeekly.Tenant_RefID = securityTicket.TenantID;
repetitionWeekly.Creation_Timestamp = DateTime.Now;
repetitionWeekly.Save(Connection, Transaction);
}
if (item.IsMontly)
{
var repetitionMontly = new ORM_CMN_CAL_RepetitionPatterns_Monthly();
repetitionMontly.CMN_CAL_RepetitionPattern_MonthlyID = Guid.NewGuid();
repetitionMontly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionMontly.Tenant_RefID = securityTicket.TenantID;
repetitionMontly.Creation_Timestamp = DateTime.Now;
repetitionMontly.Save(Connection, Transaction);
}
if (item.IsDaily)
{
var repetitionDaily = new ORM_CMN_CAL_RepetitionPatterns_Daily();
repetitionDaily.CMN_CAL_RepetitionPattern_DailyID = Guid.NewGuid();
repetitionDaily.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionDaily.Tenant_RefID = securityTicket.TenantID;
repetitionDaily.Creation_Timestamp = DateTime.Now;
repetitionDaily.Save(Connection, Transaction);
}
if (item.IsYearly)
{
var repetitionYearly = new ORM_CMN_CAL_RepetitionPatterns_Yearly();
repetitionYearly.CMN_CAL_RepetitionPattern_YearlyID = Guid.NewGuid();
repetitionYearly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionYearly.Tenant_RefID = securityTicket.TenantID;
repetitionYearly.Creation_Timestamp = DateTime.Now;
repetitionYearly.Save(Connection, Transaction);
}
}
Events.Save(Connection, Transaction);
}
#endregion
#region Edit
else
{
workTimeExceptions.Description = item.Description;
workTimeExceptions.Save(Connection, Transaction);
var EventsQuery = new ORM_CMN_CAL_Event.Query();
EventsQuery.CMN_CAL_EventID = workTimeExceptions.CMN_CAL_Event_RefID;
EventsQuery.IsDeleted = false;
EventsQuery.Tenant_RefID = securityTicket.TenantID;
var Events = ORM_CMN_CAL_Event.Query.Search(Connection, Transaction, EventsQuery).Single();
Events.IsRepetitive = item.IsRepetitive;
Events.IsWholeDayEvent = item.IsWholeDay;
Events.StartTime = item.StartDate;
Events.EndTime = item.EndDate;
#region delete old repetation if exists
var repetitionsQuery = new ORM_CMN_CAL_Repetition.Query();
repetitionsQuery.IsDeleted = false;
repetitionsQuery.Tenant_RefID = securityTicket.TenantID;
repetitionsQuery.CMN_CAL_RepetitionID = Events.Repetition_RefID;
var repetitions = ORM_CMN_CAL_Repetition.Query.Search(Connection, Transaction, repetitionsQuery).SingleOrDefault();
if (repetitions != null)
{
repetitions.IsDeleted = true;
repetitions.Save(Connection, Transaction);
if (repetitions.IsDaily)
{
var repetitionDailyQuery = new ORM_CMN_CAL_RepetitionPatterns_Daily.Query();
repetitionDailyQuery.IsDeleted = false;
repetitionDailyQuery.Tenant_RefID = securityTicket.TenantID;
repetitionDailyQuery.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
var repetitionDaily = ORM_CMN_CAL_RepetitionPatterns_Daily.Query.Search(Connection, Transaction, repetitionDailyQuery).Single();
repetitionDaily.IsDeleted = true;
repetitionDaily.Save(Connection, Transaction);
}
if (repetitions.IsWeekly)
{
var repetitionWeeklyQuery = new ORM_CMN_CAL_RepetitionPatterns_Weekly.Query();
repetitionWeeklyQuery.IsDeleted = false;
repetitionWeeklyQuery.Tenant_RefID = securityTicket.TenantID;
repetitionWeeklyQuery.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
var repetitionWeekly = ORM_CMN_CAL_RepetitionPatterns_Weekly.Query.Search(Connection, Transaction, repetitionWeeklyQuery).Single();
repetitionWeekly.IsDeleted = true;
repetitionWeekly.Save(Connection, Transaction);
}
if (repetitions.IsMonthly)
{
var repetitionMontlyQuery = new ORM_CMN_CAL_RepetitionPatterns_Monthly.Query();
repetitionMontlyQuery.IsDeleted = false;
repetitionMontlyQuery.Tenant_RefID = securityTicket.TenantID;
repetitionMontlyQuery.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
var repetitionMontly = ORM_CMN_CAL_RepetitionPatterns_Monthly.Query.Search(Connection, Transaction, repetitionMontlyQuery).Single();
repetitionMontly.IsDeleted = true;
repetitionMontly.Save(Connection, Transaction);
}
if (repetitions.IsYearly)
{
var repetitionYearlyQuery = new ORM_CMN_CAL_RepetitionPatterns_Yearly.Query();
repetitionYearlyQuery.IsDeleted = false;
repetitionYearlyQuery.Tenant_RefID = securityTicket.TenantID;
repetitionYearlyQuery.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
var repetitionYearly = ORM_CMN_CAL_RepetitionPatterns_Yearly.Query.Search(Connection, Transaction, repetitionYearlyQuery).Single();
repetitionYearly.IsDeleted = true;
repetitionYearly.Save(Connection, Transaction);
}
}
#endregion
if (item.IsRepetitive)
{
Events.Repetition_RefID = Guid.NewGuid();
repetitions = new ORM_CMN_CAL_Repetition();
repetitions.CMN_CAL_RepetitionID = Events.Repetition_RefID;
repetitions.IsMonthly = item.IsMontly;
repetitions.IsWeekly = item.IsWeekly;
repetitions.IsDaily = item.IsDaily;
repetitions.IsYearly = item.IsYearly;
repetitions.Tenant_RefID = securityTicket.TenantID;
repetitions.Creation_Timestamp = DateTime.Now;
repetitions.Save(Connection, Transaction);
if (item.IsWeekly)
{
var repetitionWeekly = new ORM_CMN_CAL_RepetitionPatterns_Weekly();
repetitionWeekly.CMN_CAL_RepetitionPattern_WeeklyID = Guid.NewGuid();
repetitionWeekly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionWeekly.Tenant_RefID = securityTicket.TenantID;
repetitionWeekly.Creation_Timestamp = DateTime.Now;
repetitionWeekly.Save(Connection, Transaction);
}
if (item.IsMontly)
{
var repetitionMontly = new ORM_CMN_CAL_RepetitionPatterns_Monthly();
repetitionMontly.CMN_CAL_RepetitionPattern_MonthlyID = Guid.NewGuid();
repetitionMontly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionMontly.Tenant_RefID = securityTicket.TenantID;
repetitionMontly.Creation_Timestamp = DateTime.Now;
repetitionMontly.Save(Connection, Transaction);
}
if (item.IsDaily)
{
var repetitionDaily = new ORM_CMN_CAL_RepetitionPatterns_Daily();
repetitionDaily.CMN_CAL_RepetitionPattern_DailyID = Guid.NewGuid();
repetitionDaily.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionDaily.Tenant_RefID = securityTicket.TenantID;
repetitionDaily.Creation_Timestamp = DateTime.Now;
repetitionDaily.Save(Connection, Transaction);
}
if (item.IsYearly)
{
var repetitionYearly = new ORM_CMN_CAL_RepetitionPatterns_Yearly();
repetitionYearly.CMN_CAL_RepetitionPattern_YearlyID = Guid.NewGuid();
repetitionYearly.Repetition_RefID = repetitions.CMN_CAL_RepetitionID;
repetitionYearly.Tenant_RefID = securityTicket.TenantID;
repetitionYearly.Creation_Timestamp = DateTime.Now;
repetitionYearly.Save(Connection, Transaction);
}
}
Events.Save(Connection, Transaction);
}
#endregion
}
}
#endregion
#region Standard Hours
else
{
var workTimeTemplateQuery = new ORM_CMN_STR_Office_Weekly_WorkTimeTemplate.Query();
workTimeTemplateQuery.IsDeleted = false;
workTimeTemplateQuery.Office_RefID = Parameter.OfficeID;
workTimeTemplateQuery.CMN_STR_Office_Weekly_WorkTimeTemplateID = item.TimeID;
workTimeTemplateQuery.Tenant_RefID = securityTicket.TenantID;
var workTimeTemplate = ORM_CMN_STR_Office_Weekly_WorkTimeTemplate.Query.Search(Connection, Transaction, workTimeTemplateQuery).SingleOrDefault();
#region Delete
if (item.IsDeleted)
{
if (workTimeTemplate != null)
{
workTimeTemplate.IsDeleted = true;
workTimeTemplate.Save(Connection, Transaction);
}
}
#endregion
else
{
#region Save
if (workTimeTemplate == null)
{
workTimeTemplate = new ORM_CMN_STR_Office_Weekly_WorkTimeTemplate();
workTimeTemplate.CMN_STR_Office_Weekly_WorkTimeTemplateID = item.TimeID;
workTimeTemplate.Office_RefID = Parameter.OfficeID;
workTimeTemplate.CMN_CAL_WeeklyOfficeHours_Interval_RefID = Guid.NewGuid();
workTimeTemplate.Tenant_RefID = securityTicket.TenantID;
workTimeTemplate.Creation_Timestamp = DateTime.Now;
workTimeTemplate.Save(Connection, Transaction);
ORM_CMN_CAL_WeeklyOfficeHours_Interval WeeklyOfficeHours_Interval = new ORM_CMN_CAL_WeeklyOfficeHours_Interval();
WeeklyOfficeHours_Interval.CMN_CAL_WeeklyOfficeHours_IntervalID = workTimeTemplate.CMN_CAL_WeeklyOfficeHours_Interval_RefID;
WeeklyOfficeHours_Interval.WeeklyOfficeHours_Template_RefID = Guid.NewGuid();
WeeklyOfficeHours_Interval.Tenant_RefID = securityTicket.TenantID;
WeeklyOfficeHours_Interval.Creation_Timestamp = DateTime.Now;
WeeklyOfficeHours_Interval.IsMonday = item.IsMonday;
WeeklyOfficeHours_Interval.IsTuesday = item.IsTuesday;
WeeklyOfficeHours_Interval.IsWednesday = item.IsWednesday;
WeeklyOfficeHours_Interval.IsThursday = item.IsThursday;
WeeklyOfficeHours_Interval.IsFriday = item.IsFriday;
WeeklyOfficeHours_Interval.IsSaturday = item.IsSaturday;
WeeklyOfficeHours_Interval.IsSunday = item.IsSunday;
WeeklyOfficeHours_Interval.IsWholeDay = item.IsWholeDay;
WeeklyOfficeHours_Interval.TimeFrom_InMinutes = item.TimeFrom_InMinutes;
WeeklyOfficeHours_Interval.TimeTo_InMinutes = item.TimeTo_InMinutes;
WeeklyOfficeHours_Interval.Save(Connection, Transaction);
ORM_CMN_CAL_WeeklyOfficeHours_Template WeeklyOfficeHours_Template = new ORM_CMN_CAL_WeeklyOfficeHours_Template();
WeeklyOfficeHours_Template.CMN_CAL_WeeklyOfficeHours_TemplateID = WeeklyOfficeHours_Interval.WeeklyOfficeHours_Template_RefID;
WeeklyOfficeHours_Template.OfficeHoursTemplate_Name = item.OfficeHoursTemplate_Name;
WeeklyOfficeHours_Template.Creation_Timestamp = DateTime.Now;
WeeklyOfficeHours_Template.Tenant_RefID = securityTicket.TenantID;
WeeklyOfficeHours_Template.Save(Connection, Transaction);
}
else
#endregion
#region Edit
{
var WeeklyOfficeHours_IntervalQuery = new ORM_CMN_CAL_WeeklyOfficeHours_Interval.Query();
WeeklyOfficeHours_IntervalQuery.IsDeleted = false;
WeeklyOfficeHours_IntervalQuery.Tenant_RefID = securityTicket.TenantID;
WeeklyOfficeHours_IntervalQuery.CMN_CAL_WeeklyOfficeHours_IntervalID = workTimeTemplate.CMN_CAL_WeeklyOfficeHours_Interval_RefID;
var WeeklyOfficeHours_Interval = ORM_CMN_CAL_WeeklyOfficeHours_Interval.Query.Search(Connection, Transaction, WeeklyOfficeHours_IntervalQuery).Single();
WeeklyOfficeHours_Interval.IsWholeDay = item.IsWholeDay;
WeeklyOfficeHours_Interval.TimeFrom_InMinutes = item.TimeFrom_InMinutes;
WeeklyOfficeHours_Interval.TimeTo_InMinutes = item.TimeTo_InMinutes;
WeeklyOfficeHours_Interval.Save(Connection, Transaction);
var WeeklyOfficeHours_TemplateQuery = new ORM_CMN_CAL_WeeklyOfficeHours_Template.Query();
WeeklyOfficeHours_TemplateQuery.IsDeleted = false;
WeeklyOfficeHours_TemplateQuery.Tenant_RefID = securityTicket.TenantID;
WeeklyOfficeHours_TemplateQuery.CMN_CAL_WeeklyOfficeHours_TemplateID = WeeklyOfficeHours_Interval.WeeklyOfficeHours_Template_RefID;
var WeeklyOfficeHours_Template = ORM_CMN_CAL_WeeklyOfficeHours_Template.Query.Search(Connection, Transaction, WeeklyOfficeHours_TemplateQuery).Single();
WeeklyOfficeHours_Template.OfficeHoursTemplate_Name = item.OfficeHoursTemplate_Name;
WeeklyOfficeHours_Template.Save(Connection, Transaction);
}
#endregion
}
}
#endregion
}
if (Parameter.UpdateSlots)
{
cls_CreateUpdate_Slots_for_Practice.Invoke(Connection, Transaction, new P_L5S_SUSfP_1708()
{
PracticeID = Parameter.OfficeID
}, securityTicket);
}
return(returnValue);
#endregion UserCode
}
