Beispiel #1
0
        public void UpdateMedicalExamField(ref OperationResult pobjOperationResult, componentfieldDto pobjDtoEntity, string pstComponentId, List <string> ClientSession)
        {
            //mon.IsActive = true;

            try
            {
                SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();

                // Obtener la entidad fuente componentfield
                var objEntitySource = (from a in dbContext.componentfield
                                       where a.v_ComponentFieldId == pobjDtoEntity.v_ComponentFieldId
                                       select a).FirstOrDefault();

                // Crear la entidad con los datos actualizados
                pobjDtoEntity.d_UpdateDate   = DateTime.Now;
                pobjDtoEntity.i_UpdateUserId = Int32.Parse(ClientSession[2]);
                componentfield objEntity = componentfieldAssembler.ToEntity(pobjDtoEntity);

                // Copiar los valores desde la entidad actualizada a la Entidad Fuente
                dbContext.componentfield.ApplyCurrentValues(objEntity);

                dbContext.componentfield.ApplyCurrentValues(objEntity);
                // Guardar los cambios
                dbContext.SaveChanges();

                // Obtener la entidad fuente componentfields
                var objEntitySource1 = (from a in dbContext.componentfields
                                        where a.v_ComponentFieldId == pobjDtoEntity.v_ComponentFieldId && a.v_ComponentId == pstComponentId
                                        select a).FirstOrDefault();

                // Crear la entidad con los datos actualizados
                objEntitySource1.d_UpdateDate   = DateTime.Now;
                objEntitySource1.i_UpdateUserId = Int32.Parse(ClientSession[2]);
                dbContext.SaveChanges();

                pobjOperationResult.Success = 1;
                // Llenar entidad Log
                LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "EXAMEN MÉDICO CAMPO", "v_MedicalExamFieldsId=" + objEntity.v_ComponentFieldId.ToString(), Success.Ok, null);
                return;
            }
            catch (Exception ex)
            {
                pobjOperationResult.Success          = 0;
                pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
                // Llenar entidad Log
                LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "EXAMEN MÉDICO CAMPO", "v_MedicalExamFieldsId=" + pobjDtoEntity.v_ComponentFieldId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
                return;
            }
        }
        /// <summary>
        /// Converts this instance of <see cref="componentfield"/> to an instance of <see cref="componentfieldDto"/>.
        /// </summary>
        /// <param name="entity"><see cref="componentfield"/> to convert.</param>
        public static componentfieldDto ToDTO(this componentfield entity)
        {
            if (entity == null)
            {
                return(null);
            }

            var dto = new componentfieldDto();

            dto.v_ComponentFieldId  = entity.v_ComponentFieldId;
            dto.v_TextLabel         = entity.v_TextLabel;
            dto.i_LabelWidth        = entity.i_LabelWidth;
            dto.v_abbreviation      = entity.v_abbreviation;
            dto.v_DefaultText       = entity.v_DefaultText;
            dto.i_ControlId         = entity.i_ControlId;
            dto.i_GroupId           = entity.i_GroupId;
            dto.i_ItemId            = entity.i_ItemId;
            dto.i_WidthControl      = entity.i_WidthControl;
            dto.i_HeightControl     = entity.i_HeightControl;
            dto.i_MaxLenght         = entity.i_MaxLenght;
            dto.i_IsRequired        = entity.i_IsRequired;
            dto.i_IsCalculate       = entity.i_IsCalculate;
            dto.v_Formula           = entity.v_Formula;
            dto.i_Order             = entity.i_Order;
            dto.i_MeasurementUnitId = entity.i_MeasurementUnitId;
            dto.r_ValidateValue1    = entity.r_ValidateValue1;
            dto.r_ValidateValue2    = entity.r_ValidateValue2;
            dto.i_Column            = entity.i_Column;
            dto.i_defaultIndex      = entity.i_defaultIndex;
            dto.i_IsDeleted         = entity.i_IsDeleted;
            dto.i_InsertUserId      = entity.i_InsertUserId;
            dto.d_InsertDate        = entity.d_InsertDate;
            dto.i_UpdateUserId      = entity.i_UpdateUserId;
            dto.d_UpdateDate        = entity.d_UpdateDate;
            dto.i_NroDecimales      = entity.i_NroDecimales;
            dto.i_ReadOnly          = entity.i_ReadOnly;
            dto.i_Enabled           = entity.i_Enabled;
            dto.v_ComentaryUpdate   = entity.v_ComentaryUpdate;

            entity.OnDTO(dto);

            return(dto);
        }
        /// <summary>
        /// Converts this instance of <see cref="componentfieldDto"/> to an instance of <see cref="componentfield"/>.
        /// </summary>
        /// <param name="dto"><see cref="componentfieldDto"/> to convert.</param>
        public static componentfield ToEntity(this componentfieldDto dto)
        {
            if (dto == null)
            {
                return(null);
            }

            var entity = new componentfield();

            entity.v_ComponentFieldId  = dto.v_ComponentFieldId;
            entity.v_TextLabel         = dto.v_TextLabel;
            entity.i_LabelWidth        = dto.i_LabelWidth;
            entity.v_abbreviation      = dto.v_abbreviation;
            entity.v_DefaultText       = dto.v_DefaultText;
            entity.i_ControlId         = dto.i_ControlId;
            entity.i_GroupId           = dto.i_GroupId;
            entity.i_ItemId            = dto.i_ItemId;
            entity.i_WidthControl      = dto.i_WidthControl;
            entity.i_HeightControl     = dto.i_HeightControl;
            entity.i_MaxLenght         = dto.i_MaxLenght;
            entity.i_IsRequired        = dto.i_IsRequired;
            entity.i_IsCalculate       = dto.i_IsCalculate;
            entity.v_Formula           = dto.v_Formula;
            entity.i_Order             = dto.i_Order;
            entity.i_MeasurementUnitId = dto.i_MeasurementUnitId;
            entity.r_ValidateValue1    = dto.r_ValidateValue1;
            entity.r_ValidateValue2    = dto.r_ValidateValue2;
            entity.i_Column            = dto.i_Column;
            entity.i_defaultIndex      = dto.i_defaultIndex;
            entity.i_IsDeleted         = dto.i_IsDeleted;
            entity.i_InsertUserId      = dto.i_InsertUserId;
            entity.d_InsertDate        = dto.d_InsertDate;
            entity.i_UpdateUserId      = dto.i_UpdateUserId;
            entity.d_UpdateDate        = dto.d_UpdateDate;
            entity.i_NroDecimales      = dto.i_NroDecimales;
            entity.i_ReadOnly          = dto.i_ReadOnly;
            entity.i_Enabled           = dto.i_Enabled;
            entity.v_ComentaryUpdate   = dto.v_ComentaryUpdate;

            dto.OnEntity(entity);

            return(entity);
        }
 /// <summary>
 /// Invoked when <see cref="ToEntity"/> operation is about to return.
 /// </summary>
 /// <param name="entity"><see cref="componentfield"/> converted from <see cref="componentfieldDto"/>.</param>
 static partial void OnEntity(this componentfieldDto dto, componentfield entity);
 /// <summary>
 /// Invoked when <see cref="ToDTO"/> operation is about to return.
 /// </summary>
 /// <param name="dto"><see cref="componentfieldDto"/> converted from <see cref="componentfield"/>.</param>
 static partial void OnDTO(this componentfield entity, componentfieldDto dto);
Beispiel #6
0
        public string AddMedicalExamFields(ref OperationResult pobjOperationResult, componentfieldDto pobjDtoEntity, componentfieldsDto pobjDtoEntitys, string pstrComponentId, List <string> ClientSession)
        {
            //mon.IsActive = true;
            string NewId = "(No generado)";

            try
            {
                SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
                var query1 = (from a in dbContext.componentfield
                              join b in dbContext.componentfields on a.v_ComponentFieldId equals b.v_ComponentFieldId
                              where a.v_TextLabel.ToUpper() == pobjDtoEntity.v_TextLabel.ToUpper() && b.v_ComponentId == pobjDtoEntitys.v_ComponentId && b.v_Group == pobjDtoEntitys.v_Group
                              select a).ToList();
                if (query1.Count > 0)
                {
                    pobjOperationResult.ErrorMessage = "Nombre del componente duplicado";
                    return("0");
                }
                #region ComponentField
                componentfield objEntity = componentfieldAssembler.ToEntity(pobjDtoEntity);


                objEntity.d_InsertDate   = DateTime.Now;
                objEntity.i_InsertUserId = Int32.Parse(ClientSession[2]);
                objEntity.i_IsDeleted    = 0;
                // Autogeneramos el Pk de la tabla
                int intNodeId = int.Parse(ClientSession[0]);
                NewId = Common.Utils.GetNewId(intNodeId, Utils.GetNextSecuentialId(intNodeId, 18), "MF");

                objEntity.v_ComponentFieldId = NewId;



                dbContext.AddTocomponentfield(objEntity);
                dbContext.SaveChanges();
                #endregion

                #region ComponentFields
                componentfields objEntitys = componentfieldsAssembler.ToEntity(pobjDtoEntitys);
                objEntitys.v_ComponentFieldId = NewId;
                objEntitys.v_ComponentId      = pstrComponentId;
                objEntitys.d_InsertDate       = DateTime.Now;
                objEntitys.i_InsertUserId     = Int32.Parse(ClientSession[2]);
                objEntitys.i_IsDeleted        = 0;

                dbContext.AddTocomponentfields(objEntitys);
                dbContext.SaveChanges();

                #endregion

                pobjOperationResult.Success = 1;
                // Llenar entidad Log
                LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "EXAMEN MÉDICO CAMPO", "v_MedicalExamFieldsId=" + NewId.ToString(), Success.Ok, null);
                return(NewId);
            }
            catch (Exception ex)
            {
                pobjOperationResult.Success          = 0;
                pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
                // Llenar entidad Log
                LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "EXAMEN MÉDICO CAMPO", "v_MedicalExamFieldsId=" + NewId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
                return("0");
            }
        }