protected static FR_L5RP_GSEfEW_1438 Execute(DbConnection Connection, DbTransaction Transaction, P_L5RP_GSEfEW_1438 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5RP_GSEfEW_1438(); //Put your code here returnValue.Result = new L5RP_GSEfEW_1438(); List <L3EV_GSEFCID_1042> retValList = new List <L3EV_GSEFCID_1042>(); foreach (var workplaceHistory in Parameter.EmployeeWorkplaceHistory) { ORM_CMN_STR_PPS_Workplace workplace = new ORM_CMN_STR_PPS_Workplace(); var workplaceRes = workplace.Load(Connection, Transaction, workplaceHistory.BoundTo_Workplace_RefID); if (workplaceRes.Status != FR_Status.Success || workplace.CMN_STR_PPS_WorkplaceID == Guid.Empty) { continue; } P_L3EV_GSEFCID_1042 structureEventPar = new P_L3EV_GSEFCID_1042(); structureEventPar.CalendarInstanceID = workplace.CMN_CAL_CalendarInstance_RefID; L3EV_GSEFCID_1042[] structureEvents = cls_get_StructureEvents_For_CalendarInstanceID.Invoke(Connection, Transaction, structureEventPar, securityTicket).Result; List <L3EV_GSEFCID_1042> eventItems; DateTime date; for (int i = 0; i < Parameter.EndTime.Day; i++) { date = Parameter.StartTime.AddDays(i); if (structureEvents.Any(s => s.StartTime.Ticks <= date.Date.Ticks && s.EndTime.Ticks >= date.Date.Ticks)) { eventItems = structureEvents.Where(s => s.StartTime.Ticks <= date.Date.Ticks && s.EndTime.Ticks >= date.Date.Ticks).ToList(); foreach (var item in eventItems) { if (!retValList.Contains(item)) { retValList.Add(item); } } } } } returnValue.Result.StructureEvents = retValList.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L5WP_DWP_0917 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Base(); ORM_CMN_STR_PPS_Workplace whereInstance = CSV2Core_MySQL.Support.SQLClassFilter.GetDefaultInstance <ORM_CMN_STR_PPS_Workplace>(); whereInstance.CMN_STR_PPS_WorkplaceID = Parameter.CMN_STR_PPS_WorkplaceID; int result = CSV2Core_MySQL.Support.SQLClassFilter.Delete(Connection, Transaction, whereInstance); ORM_CMN_CAL_CalendarInstance CalendarWhereInstance = CSV2Core_MySQL.Support.SQLClassFilter.GetDefaultInstance <ORM_CMN_CAL_CalendarInstance>(); CalendarWhereInstance.CMN_CAL_CalendarInstanceID = Parameter.CMN_CAL_CalendarInstance_RefID; CSV2Core_MySQL.Support.SQLClassFilter.Delete(Connection, Transaction, CalendarWhereInstance); return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5WP_SWP_1551 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new ORM_CMN_STR_PPS_Workplace(); if (Parameter.CMN_STR_PPS_WorkplaceID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_STR_PPS_WorkplaceID); if (result.Status != FR_Status.Success || item.CMN_STR_PPS_WorkplaceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.WorkPlaceDescription != null) { item.Description = Parameter.WorkPlaceDescription; } else { item.Description = new Dict(); item.Description.DictionaryID = Guid.NewGuid(); } item.Name = Parameter.WorkPlaceName; item.ShortName = Parameter.ShortName; item.DisplayColor = Parameter.DisplayColor; item.WorkArea_RefID = Parameter.WorkArea_RefID; item.Tenant_RefID = securityTicket.TenantID; item.CMN_CAL_CalendarInstance_RefID = Parameter.CMN_CAL_CalendarInstance_RefID; ORM_CMN_CAL_CalendarInstance calendar = new ORM_CMN_CAL_CalendarInstance(); if (Parameter.CMN_CAL_CalendarInstance_RefID != Guid.Empty) { var result = calendar.Load(Connection, Transaction, Parameter.CMN_CAL_CalendarInstance_RefID); if (result.Status != FR_Status.Success || calendar.CMN_CAL_CalendarInstanceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } calendar.WeekStartsOnDay = 1; calendar.Save(Connection, Transaction); item.CMN_CAL_CalendarInstance_RefID = calendar.CMN_CAL_CalendarInstanceID; item.Save(Connection, Transaction); CSV2Core.DlTrace.Trace("1 workPlace"); ORM_CMN_STR_PPS_Workplace_ResponsiblePerson whereInstance = CSV2Core_MySQL.Support.SQLClassFilter.GetDefaultInstance <ORM_CMN_STR_PPS_Workplace_ResponsiblePerson>(); CSV2Core.DlTrace.Trace("2 workPlace"); whereInstance.Workplace_RefID = item.CMN_STR_PPS_WorkplaceID; CSV2Core.DlTrace.Trace("3 workPlace"); CSV2Core_MySQL.Support.SQLClassFilter.Delete(Connection, Transaction, whereInstance); CSV2Core.DlTrace.Trace("4 workPlace"); if (Parameter.ResponsiblePersons != null && Parameter.ResponsiblePersons.Length > 0) { CSV2Core.DlTrace.Trace("5 workPlace"); foreach (P_L5WP_SWP_1551_ResponsiblePerson obj in Parameter.ResponsiblePersons) { CSV2Core.DlTrace.Trace("6 workPlace"); ORM_CMN_STR_PPS_Workplace_ResponsiblePerson person = new ORM_CMN_STR_PPS_Workplace_ResponsiblePerson(); if (obj.CMN_STR_PPS_Workplace_ResponsiblePersonID != Guid.Empty) { CSV2Core.DlTrace.Trace("7 workPlace"); var result = calendar.Load(Connection, Transaction, obj.CMN_STR_PPS_Workplace_ResponsiblePersonID); if (result.Status != FR_Status.Success || person.CMN_STR_PPS_Workplace_ResponsiblePersonID == Guid.Empty) { CSV2Core.DlTrace.Trace("8 workPlace"); var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (obj.CMN_STR_PPS_Workplace_ResponsiblePersonID != Guid.Empty) { CSV2Core.DlTrace.Trace("9 workPlace"); person.IsDeleted = true; } else { CSV2Core.DlTrace.Trace("10 workPlace"); person.CMN_BPT_EMP_Employee_RefID = obj.CMN_BPT_EMP_EmployeeID; person.Workplace_RefID = item.CMN_STR_PPS_WorkplaceID; person.Tenant_RefID = securityTicket.TenantID; } CSV2Core.DlTrace.Trace("11 workPlace"); person.Save(Connection, Transaction); } } CSV2Core.DlTrace.Trace("12 workPlace"); //Put your code here return(new FR_Guid(item.CMN_STR_PPS_WorkplaceID)); #endregion UserCode }
protected static FR_L5WP_GWPFWPID_1132 Execute(DbConnection Connection, DbTransaction Transaction, P_L5WP_GWPFWPID_1132 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5WP_GWPFWPID_1132(); returnValue.Result = new L5WP_GWPFWPID_1132(); L5WP_GWFT_1203 result = new L5WP_GWFT_1203(); ORM_CMN_STR_PPS_Workplace item = new ORM_CMN_STR_PPS_Workplace(); if (Parameter.workplaceID != Guid.Empty) { var resultWorkplace = item.Load(Connection, Transaction, Parameter.workplaceID); if (resultWorkplace.Status != FR_Status.Success || item.CMN_STR_PPS_WorkplaceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(null); } } result.CMN_CAL_CalendarInstance_RefID = item.CMN_CAL_CalendarInstance_RefID; result.CMN_STR_PPS_WorkplaceID = item.CMN_STR_PPS_WorkplaceID; result.ShortName = item.ShortName; result.WorkArea_RefID = item.WorkArea_RefID; result.WorkPlaceDescription = item.Description; result.WorkPlaceName = item.Name; var responsiblePersonsQuery = new ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query(); responsiblePersonsQuery.Tenant_RefID = securityTicket.TenantID; responsiblePersonsQuery.Workplace_RefID = item.CMN_STR_PPS_WorkplaceID; responsiblePersonsQuery.IsDeleted = false; var responsiblePersonsList = ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query.Search(Connection, Transaction, responsiblePersonsQuery); List <L5WP_GWFT_1203_ResponsiblePerson> responsiblePresonsResultList = new List <L5WP_GWFT_1203_ResponsiblePerson>(); foreach (var responsiblePerson in responsiblePersonsList) { L5WP_GWFT_1203_ResponsiblePerson responsiblePersonResult = new L5WP_GWFT_1203_ResponsiblePerson(); responsiblePersonResult.CMN_BPT_EMP_EmployeeID = responsiblePerson.CMN_BPT_EMP_Employee_RefID; responsiblePersonResult.CMN_STR_PPS_Workplace_ResponsiblePersonID = responsiblePerson.CMN_STR_PPS_Workplace_ResponsiblePersonID; ORM_CMN_BPT_EMP_Employee employee = new ORM_CMN_BPT_EMP_Employee(); employee.Load(Connection, Transaction, responsiblePerson.CMN_BPT_EMP_Employee_RefID); ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant(); bParticipant.Load(Connection, Transaction, employee.BusinessParticipant_RefID); ORM_CMN_PER_PersonInfo person = new ORM_CMN_PER_PersonInfo(); person.Load(Connection, Transaction, bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID); responsiblePersonResult.CMN_BPT_BusinessParticipantID = bParticipant.CMN_BPT_BusinessParticipantID; responsiblePersonResult.FirstName = person.FirstName; responsiblePersonResult.LastName = person.LastName; responsiblePersonResult.CMN_PER_PersonInfoID = person.CMN_PER_PersonInfoID; responsiblePresonsResultList.Add(responsiblePersonResult); } result.ResponsiblePersons = responsiblePresonsResultList.ToArray(); returnValue.Result.workplace = result; //Put your code here return(returnValue); #endregion UserCode }