public componentfieldvaluesDto GetMedicalExamFieldValues(ref OperationResult pobjOperationResult, string pstrMedicalExamFieldValuesId)
{
//mon.IsActive = true;
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
componentfieldvaluesDto objDtoEntity = null;
var objEntity = (from a in dbContext.componentfieldvalues
where a.v_ComponentFieldValuesId == pstrMedicalExamFieldValuesId
select a).FirstOrDefault();
if (objEntity != null)
{
objDtoEntity = componentfieldvaluesAssembler.ToDTO(objEntity);
}
pobjOperationResult.Success = 1;
return(objDtoEntity);
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
return(null);
}
}
private void frmMedicalExamEdicion_Load(object sender, EventArgs e)
{
#region Mayusculas - Normal
var _EsMayuscula = int.Parse(Common.Utils.GetApplicationConfigValue("EsMayuscula"));
if (_EsMayuscula == 1)
{
SearchControlAndSetEvents(this);
}
#endregion
OperationResult objOperationResult = new OperationResult();
MedicalExamFieldValuesBL objMedicalExamFieldValuesBLBL = new MedicalExamFieldValuesBL();
//Llenado de combos
Utils.LoadDropDownList(ddlOperatorId, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 129, "v_Value2"), DropDownListAction.Select);
//Utils.LoadDropDownList(ddlRestrictionId, "Value1", "Id", BLL.Utils.GetDataHierarchyForCombo(ref objOperationResult, 107, null), DropDownListAction.Select);
//Utils.LoadDropDownList(ddlRecommendationId, "Value1", "Id", BLL.Utils.GetDataHierarchyForCombo(ref objOperationResult, 112, null), DropDownListAction.Select);
Utils.LoadDropDownList(ddlIsAnormal, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 111, null), DropDownListAction.Select);
Utils.LoadDropDownList(ddlSexTypeId, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 100, null), DropDownListAction.Select);
txtAnalyzeValue1.Select();
if (Mode == "New")
{
// Additional logic here.
}
else if (Mode == "Edit")
{
// Get the Entity Data
_objmedicalexamfieldValuesDto = new componentfieldvaluesDto();
_objmedicalexamfieldValuesDto = _objMedicalExamFieldsBL.GetMedicalExamFieldValues(ref objOperationResult, _MedicalExamFliedValueId);
txtAnalyzeValue1.Text = _objmedicalexamfieldValuesDto.v_AnalyzingValue1.ToString();
txtAnalyzeValue2.Text = _objmedicalexamfieldValuesDto.v_AnalyzingValue2.ToString() == "0" ? string.Empty : _objmedicalexamfieldValuesDto.v_AnalyzingValue2.ToString();
ddlOperatorId.SelectedValue = _objmedicalexamfieldValuesDto.i_OperatorId.ToString();
txtLegalStandard.Text = _objmedicalexamfieldValuesDto.v_LegalStandard;
ddlIsAnormal.SelectedValue = _objmedicalexamfieldValuesDto.i_IsAnormal.ToString();
objdiseasesDto = _objMedicalExamFieldsBL.GetDiseases(ref objOperationResult, _objmedicalexamfieldValuesDto.v_DiseasesId);
ddlSexTypeId.SelectedValue = _objmedicalexamfieldValuesDto.i_GenderId.ToString();
txtDiagnostic.Text = objdiseasesDto == null ? String.Empty : objdiseasesDto.v_Name + " - CÓDIGO CIE10 : " + objdiseasesDto.v_CIE10Id;
_objDiseasesList.v_DiseasesId = objdiseasesDto == null ? null : objdiseasesDto.v_DiseasesId;
//_objDiseasesList.
_TempComponentFieldValuesRestrictionList = objMedicalExamFieldValuesBLBL.GetRestrictionsPagedAndFiltered(ref objOperationResult, 0, null, "", "v_ComponentFieldValuesId== \"" + _objmedicalexamfieldValuesDto.v_ComponentFieldValuesId + "\"");
grdDataRestrictions.DataSource = _TempComponentFieldValuesRestrictionList;
_TempComponentFieldValuesRecommendationList = objMedicalExamFieldValuesBLBL.GetRecommendationsPagedAndFiltered(ref objOperationResult, 0, null, "", "v_ComponentFieldValuesId== \"" + _objmedicalexamfieldValuesDto.v_ComponentFieldValuesId + "\"");
grdDataRecommendation.DataSource = _TempComponentFieldValuesRecommendationList;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
OperationResult objOperationResult = new OperationResult();
_componentfieldvaluesrestrictionListDto = new List <componentfieldvaluesrestrictionDto>();
_componentfieldvaluesrecommendationListDto = new List <componentfieldvaluesrecommendationDto>();
if (uvMedicalExamFiedValues.Validate(true, false).IsValid)
{
if (txtAnalyzeValue1.Text.Trim() == "")
{
MessageBox.Show("Por favor ingrese un nombre apropiado para el Nombre Valor Analizar 1.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBox.Show("¿Está seguro de agregar / modificar la Campos al examen?.", "Pregunta", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
if (Mode == "New")
{
_objmedicalexamfieldValuesDto = new componentfieldvaluesDto();
// Populate the entity+
_objmedicalexamfieldValuesDto.v_ComponentFieldId = MedicalExamFliedId;
_objmedicalexamfieldValuesDto.v_AnalyzingValue1 = txtAnalyzeValue1.Text;
_objmedicalexamfieldValuesDto.v_AnalyzingValue2 = txtAnalyzeValue2.Text;
_objmedicalexamfieldValuesDto.i_OperatorId = Int32.Parse(ddlOperatorId.SelectedValue.ToString());
_objmedicalexamfieldValuesDto.i_GenderId = int.Parse(ddlSexTypeId.SelectedValue.ToString());
_objmedicalexamfieldValuesDto.v_LegalStandard = txtLegalStandard.Text;
_objmedicalexamfieldValuesDto.i_IsAnormal = Int32.Parse(ddlIsAnormal.SelectedValue.ToString());
_objmedicalexamfieldValuesDto.v_DiseasesId = _objDiseasesList.v_DiseasesId;
// Save the data
_MedicalExamFliedValueId = _objMedicalExamFieldsBL.AddMedicalExamFieldValues(ref objOperationResult, _TempComponentFieldValuesRestrictionList, _TempComponentFieldValuesRecommendationList, _objmedicalexamfieldValuesDto, Globals.ClientSession.GetAsList());
}
else if (Mode == "Edit")
{
_componentfieldvaluesrestrictionListDtoDelete = new List <componentfieldvaluesrestrictionDto>();
_componentfieldvaluesrecommendationListDtoDelete = new List <componentfieldvaluesrecommendationDto>();
// Populate the entity
_objmedicalexamfieldValuesDto.v_ComponentFieldId = MedicalExamFliedId;
_objmedicalexamfieldValuesDto.v_AnalyzingValue1 = txtAnalyzeValue1.Text;
_objmedicalexamfieldValuesDto.v_AnalyzingValue2 = txtAnalyzeValue2.Text;
_objmedicalexamfieldValuesDto.i_OperatorId = Int32.Parse(ddlOperatorId.SelectedValue.ToString());
_objmedicalexamfieldValuesDto.i_GenderId = int.Parse(ddlSexTypeId.SelectedValue.ToString());
_objmedicalexamfieldValuesDto.v_LegalStandard = txtLegalStandard.Text;
_objmedicalexamfieldValuesDto.i_IsAnormal = Int32.Parse(ddlIsAnormal.SelectedValue.ToString());
_objmedicalexamfieldValuesDto.v_DiseasesId = _objDiseasesList.v_DiseasesId;
//Temporal de Restricción
foreach (var item in _TempComponentFieldValuesRestrictionList)
{
// Add
if (item.i_RecordType == (int)RecordType.Temporal && item.i_RecordStatus == (int)RecordStatus.Agregado)
{
componentfieldvaluesrestrictionDto componentfieldvaluesrestrictionDto = new componentfieldvaluesrestrictionDto();
componentfieldvaluesrestrictionDto.v_ComponentFieldValuesRestrictionId = item.v_ComponentFieldValuesRestrictionId;
componentfieldvaluesrestrictionDto.v_ComponentFieldValuesId = item.v_ComponentFieldValuesId;
componentfieldvaluesrestrictionDto.v_MasterRecommendationRestricctionId = item.v_MasterRecommendationRestricctionId;
_componentfieldvaluesrestrictionListDto.Add(componentfieldvaluesrestrictionDto);
}
// Delete
if (item.i_RecordType == (int)RecordType.NoTemporal && item.i_RecordStatus == (int)RecordStatus.EliminadoLogico)
{
componentfieldvaluesrestrictionDto componentfieldvaluesrestrictionDto = new componentfieldvaluesrestrictionDto();
componentfieldvaluesrestrictionDto.v_ComponentFieldValuesRestrictionId = item.v_ComponentFieldValuesRestrictionId;
_componentfieldvaluesrestrictionListDtoDelete.Add(componentfieldvaluesrestrictionDto);
}
}
//Temporal de Recomendaciones
foreach (var item in _TempComponentFieldValuesRecommendationList)
{
// Add
if (item.i_RecordType == (int)RecordType.Temporal && item.i_RecordStatus == (int)RecordStatus.Agregado)
{
componentfieldvaluesrecommendationDto componentfieldvaluesrecommendationDto = new componentfieldvaluesrecommendationDto();
componentfieldvaluesrecommendationDto.v_ComponentFieldValuesRecommendationId = item.v_ComponentFieldValuesRecommendationId;
componentfieldvaluesrecommendationDto.v_ComponentFieldValuesId = item.v_ComponentFieldValuesId;
componentfieldvaluesrecommendationDto.v_MasterRecommendationRestricctionId = item.v_MasterRecommendationRestricctionId;
_componentfieldvaluesrecommendationListDto.Add(componentfieldvaluesrecommendationDto);
}
// Delete
if (item.i_RecordType == (int)RecordType.NoTemporal && item.i_RecordStatus == (int)RecordStatus.EliminadoLogico)
{
componentfieldvaluesrecommendationDto componentfieldvaluesrecommendationDto = new componentfieldvaluesrecommendationDto();
componentfieldvaluesrecommendationDto.v_ComponentFieldValuesRecommendationId = item.v_ComponentFieldValuesRecommendationId;
_componentfieldvaluesrecommendationListDtoDelete.Add(componentfieldvaluesrecommendationDto);
}
}
// Save the data
_objMedicalExamFieldsBL.UpdateMedicalExamFieldValues(ref objOperationResult,
_componentfieldvaluesrestrictionListDto,
_componentfieldvaluesrestrictionListDtoDelete,
_componentfieldvaluesrecommendationListDto,
_componentfieldvaluesrecommendationListDtoDelete,
_objmedicalexamfieldValuesDto,
Globals.ClientSession.GetAsList());
}
//// Analizar el resultado de la operación
if (objOperationResult.Success == 1) // Operación sin error
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
else // Operación con error
{
MessageBox.Show("Error en operación:" + System.Environment.NewLine + objOperationResult.ExceptionMessage, "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error);
// Se queda en el formulario.
}
}
else
{
MessageBox.Show("Por favor corrija la información ingresada. Vea los indicadores de error.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public string AddMedicalExamFieldValues(ref OperationResult pobjOperationResult, List <ComponentFieldValuesRestrictionList> ComponentFieldValuesRestrictionList, List <ComponentFieldValuesRecommendationList> ComponentFieldValuesRecommendationList, componentfieldvaluesDto pobjDtoEntity, List <string> ClientSession)
{
//mon.IsActive = true;
string NewId = "(No generado)";
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
componentfieldvalues objEntity = componentfieldvaluesAssembler.ToEntity(pobjDtoEntity);
componentfieldvaluesrestrictionDto objcomponentfieldvaluesrestrictionDto = new componentfieldvaluesrestrictionDto();
componentfieldvaluesrecommendationDto objcomponentfieldvaluesrecommendationDto = new componentfieldvaluesrecommendationDto();
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, 19), "MV");
objEntity.v_ComponentFieldValuesId = NewId;
dbContext.AddTocomponentfieldvalues(objEntity);
dbContext.SaveChanges();
if (ComponentFieldValuesRestrictionList != null)
{
for (int i = 0; i < ComponentFieldValuesRestrictionList.Count; i++)
{
objcomponentfieldvaluesrestrictionDto.v_ComponentFieldValuesId = NewId;
objcomponentfieldvaluesrestrictionDto.v_MasterRecommendationRestricctionId = ComponentFieldValuesRestrictionList[i].v_MasterRecommendationRestricctionId;
AddRestriction(ref pobjOperationResult, objcomponentfieldvaluesrestrictionDto, ClientSession);
}
}
if (ComponentFieldValuesRecommendationList != null)
{
for (int i = 0; i < ComponentFieldValuesRecommendationList.Count; i++)
{
objcomponentfieldvaluesrecommendationDto.v_ComponentFieldValuesId = NewId;
objcomponentfieldvaluesrecommendationDto.v_ComponentFieldValuesRecommendationId = ComponentFieldValuesRecommendationList[i].v_MasterRecommendationRestricctionId;
AddRecommendation(ref pobjOperationResult, objcomponentfieldvaluesrecommendationDto, ClientSession);
}
}
pobjOperationResult.Success = 1;
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "EXAMEN MÉDICO CAMPO VALOR", "v_MedicalExamFieldValuesId=" + 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 VALOR", "v_MedicalExamFieldValuesId=" + NewId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
return(null);
}
}
public void UpdateMedicalExamFieldValues(ref OperationResult pobjOperationResult, List <componentfieldvaluesrestrictionDto> pobjComponentFieldValuesRestrictionAdd, List <componentfieldvaluesrestrictionDto> pobjComponentFieldValuesRestrictionDelete, List <componentfieldvaluesrecommendationDto> pobjComponentFieldValuesRecommendationAdd, List <componentfieldvaluesrecommendationDto> pobjComponentFieldValuesRecommendationDelete, componentfieldvaluesDto pobjDtoEntity, List <string> ClientSession)
{
//mon.IsActive = true;
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
#region Actualizar Valor
componentfieldvaluesrestrictionDto objcomponentfieldvaluesrestrictionDto = new componentfieldvaluesrestrictionDto();
// Obtener la entidad fuente
var objEntitySource = (from a in dbContext.componentfieldvalues
where a.v_ComponentFieldValuesId == pobjDtoEntity.v_ComponentFieldValuesId
select a).FirstOrDefault();
// Crear la entidad con los datos actualizados
pobjDtoEntity.d_UpdateDate = DateTime.Now;
pobjDtoEntity.i_UpdateUserId = Int32.Parse(ClientSession[2]);
componentfieldvalues objEntity = componentfieldvaluesAssembler.ToEntity(pobjDtoEntity);
// Copiar los valores desde la entidad actualizada a la Entidad Fuente
dbContext.componentfieldvalues.ApplyCurrentValues(objEntity);
// Guardar los cambios
dbContext.SaveChanges();
#endregion
#region Crear Restriccion
int intNodeId = int.Parse(ClientSession[0]);
foreach (var item in pobjComponentFieldValuesRestrictionAdd)
{
componentfieldvaluesrestriction objEntity1 = componentfieldvaluesrestrictionAssembler.ToEntity(item);
objEntity1.d_InsertDate = DateTime.Now;
objEntity1.i_InsertUserId = Int32.Parse(ClientSession[2]);
objEntity1.i_IsDeleted = 0;
var NewId1 = Common.Utils.GetNewId(intNodeId, Utils.GetNextSecuentialId(intNodeId, 28), "VR");
objEntity1.v_ComponentFieldValuesRestrictionId = NewId1;
objEntity1.v_ComponentFieldValuesId = pobjDtoEntity.v_ComponentFieldValuesId;
dbContext.AddTocomponentfieldvaluesrestriction(objEntity1);
}
// Guardar los cambios
dbContext.SaveChanges();
#endregion
#region Eliminar Restriccion
if (pobjComponentFieldValuesRestrictionDelete != null)
{
// Eliminar Componentes del protocolo
foreach (var item in pobjComponentFieldValuesRestrictionDelete)
{
// Obtener la entidad fuente
var objEntitySource1 = (from a in dbContext.componentfieldvaluesrestriction
where a.v_ComponentFieldValuesRestrictionId == item.v_ComponentFieldValuesRestrictionId
select a).FirstOrDefault();
// Crear la entidad con los datos actualizados
objEntitySource1.d_UpdateDate = DateTime.Now;
objEntitySource1.i_UpdateUserId = Int32.Parse(ClientSession[2]);
objEntitySource1.i_IsDeleted = 1;
}
}
// Guardar los cambios
dbContext.SaveChanges();
#endregion
#region Crear Recommendation
foreach (var item in pobjComponentFieldValuesRecommendationAdd)
{
componentfieldvaluesrecommendation objEntity1 = componentfieldvaluesrecommendationAssembler.ToEntity(item);
objEntity1.d_InsertDate = DateTime.Now;
objEntity1.i_InsertUserId = Int32.Parse(ClientSession[2]);
objEntity1.i_IsDeleted = 0;
var NewId1 = Common.Utils.GetNewId(intNodeId, Utils.GetNextSecuentialId(intNodeId, 31), "VC");
objEntity1.v_ComponentFieldValuesRecommendationId = NewId1;
objEntity1.v_ComponentFieldValuesId = pobjDtoEntity.v_ComponentFieldValuesId;
dbContext.AddTocomponentfieldvaluesrecommendation(objEntity1);
}
// Guardar los cambios
dbContext.SaveChanges();
#endregion
#region Eliminar Recommendation
if (pobjComponentFieldValuesRecommendationDelete != null)
{
// Eliminar Componentes del protocolo
foreach (var item in pobjComponentFieldValuesRecommendationDelete)
{
// Obtener la entidad fuente
var objEntitySource1 = (from a in dbContext.componentfieldvaluesrecommendation
where a.v_ComponentFieldValuesRecommendationId == item.v_ComponentFieldValuesRecommendationId
select a).FirstOrDefault();
// Crear la entidad con los datos actualizados
objEntitySource1.d_UpdateDate = DateTime.Now;
objEntitySource1.i_UpdateUserId = Int32.Parse(ClientSession[2]);
objEntitySource1.i_IsDeleted = 1;
}
}
// Guardar los cambios
dbContext.SaveChanges();
#endregion
//// Guardar los cambios
//dbContext.SaveChanges();
pobjOperationResult.Success = 1;
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "EXAMEN MÉDICO CAMPO VALOR", "v_MedicalExamId=" + objEntity.v_ComponentFieldValuesId.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 VALOR", "v_MedicalExamId=" + pobjDtoEntity.v_ComponentFieldValuesId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
return;
}
}
