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");
}
}
public void AddComponentFields(ref OperationResult pobjOperationResult, List <componentfieldsDto> pobjcomponentfieldsAdd, List <componentfieldsDto> pobjcomponentfieldsUpdate, List <componentfieldsDto> pobjcomponentfieldsDelete, List <string> ClientSession)
{
try
{
OperationResult objOperationResult = new OperationResult();
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
int intNodeId = int.Parse(ClientSession[0]);
#region Add Component Fields
foreach (var item in pobjcomponentfieldsAdd)
{
componentfields objEntity1 = new componentfields();
objEntity1.d_InsertDate = DateTime.Now;
objEntity1.i_InsertUserId = Int32.Parse(ClientSession[2]);
objEntity1.i_IsDeleted = 0;
objEntity1.v_ComponentFieldId = item.v_ComponentFieldId;
objEntity1.v_ComponentId = item.v_ComponentId;
objEntity1.v_Group = item.v_Group;
//Verificar si se encuentra en la BD eliminado
var objEntitySource1 = (from a in dbContext.componentfields
where a.v_ComponentFieldId == item.v_ComponentFieldId && a.v_ComponentId == item.v_ComponentId
select a).FirstOrDefault();
if (objEntitySource1 == null)
{
dbContext.AddTocomponentfields(objEntity1);
}
else
{
objEntitySource1.i_IsDeleted = 0;
objEntitySource1.d_UpdateDate = DateTime.Now;
objEntitySource1.i_UpdateUserId = Int32.Parse(ClientSession[2]);
}
}
// Guardar los cambios
dbContext.SaveChanges();
#endregion
#region Update Component Fields
if (pobjcomponentfieldsUpdate != null)
{
// Actualizar Componentes del protocolo
foreach (var item in pobjcomponentfieldsUpdate)
{
// Obtener la entidad fuente
var objEntitySource1 = (from a in dbContext.componentfields
where a.v_ComponentFieldId == item.v_ComponentFieldId && a.v_ComponentId == item.v_ComponentId
select a).FirstOrDefault();
// Crear la entidad con los datos actualizados
objEntitySource1.v_Group = item.v_Group;
objEntitySource1.i_IsDeleted = 0;
objEntitySource1.d_UpdateDate = DateTime.Now;
objEntitySource1.i_UpdateUserId = Int32.Parse(ClientSession[2]);
}
}
// Guardar los cambios
dbContext.SaveChanges();
#endregion
#region Delete Component Fields
if (pobjcomponentfieldsDelete != null)
{
foreach (var item in pobjcomponentfieldsDelete)
{
// Obtener la entidad fuente
var objEntitySource1 = (from a in dbContext.componentfields
where a.v_ComponentFieldId == item.v_ComponentFieldId && a.v_ComponentId == item.v_ComponentId
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
pobjOperationResult.Success = 1;
// Llenar entidad Log
//LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "CAMPOS DEL COMPONENTE", "v_ComponentId=" + objEntity1.v_ComponentId + "v_ComponentFieldId= " + objEntity1.v_ComponentFieldId, 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.CREACION, "CAMPOS DEL COMPONENTE", "v_ComponentId= No generado ,v_ComponentFieldId= No generado ", Success.Failed, pobjOperationResult.ExceptionMessage);
return;
}
}