public bool AddProtocolSystemUser(List <ProtocolSystemUserBE> ListProtocolSystemUserDto, int pintSystemUserId, int userId, int nodeId)
{
string newId;
try
{
DatabaseContext dbContext = new DatabaseContext();
foreach (var objEntity in ListProtocolSystemUserDto)
{
// Autogeneramos el Pk de la tabla
newId = new Common.Utils().GetPrimaryKey(nodeId, 44, "PU");
// Grabar como nuevo
objEntity.v_ProtocolSystemUserId = newId;
objEntity.i_SystemUserId = pintSystemUserId;
objEntity.d_InsertDate = DateTime.Now;
objEntity.i_InsertUserId = userId;
objEntity.i_IsDeleted = 0;
dbContext.ProtocolSystemUser.Add(objEntity);
dbContext.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public void AddTemporaryDiagnostics(List <DiagnosticRepositoryDto> diagnostics, int nodeId, int systemUserId)
{
try
{
using (var ctx = new DatabaseContext())
{
foreach (var dto in diagnostics)
{
var id = new Common.Utils().GetPrimaryKey(nodeId, 29, "DR");
dto.v_DiagnosticRepositoryId = id;
dto.i_IsDeleted = (int)SiNo.No;
dto.d_InsertDate = DateTime.UtcNow;
dto.i_InsertUserId = systemUserId;
ctx.DiagnosticRepository.Add(dto);
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
public List <ServiceComponentTemp> AddServiceComponentInBlockTemp(List <ServiceComponentDto> list, int nodeId, int systemUserId)
{
using (var oCtx = new DatabaseContext())
{
var outList = new List <ServiceComponentTemp>();
foreach (var item in list)
{
var serviceComponentId = new Common.Utils().GetPrimaryKey(nodeId, 24, "SC");
item.v_ServiceComponentId = serviceComponentId;
item.i_IsDeleted = (int)Enumeratores.SiNo.No;
item.d_InsertDate = DateTime.UtcNow;
item.i_InsertUserId = systemUserId;
oCtx.ServiceComponent.Add(item);
var oClassCustom = new ServiceComponentTemp
{
v_ComponentId = item.v_ComponentId,
v_ServiceComponentId = serviceComponentId
};
outList.Add(oClassCustom);
}
oCtx.SaveChanges();
return(outList);
}
}
public static string AddProtocol(ProtocolBE protocolBE, List <ProtocolComponentDto> ListProtCompCreate, int nodeId, int userId)
{
try
{
DatabaseContext cnx = new DatabaseContext();
var newId = new Common.Utils().GetPrimaryKey(nodeId, 20, "PR");
protocolBE.v_ProtocolId = newId;
protocolBE.i_IsDeleted = (int)SiNo.No;
protocolBE.d_InsertDate = DateTime.Now;
protocolBE.i_InsertUserId = userId;
cnx.Protocol.Add(protocolBE);
cnx.SaveChanges();
var result = ProtocolComponentDal.AddProtocolComponent(ListProtCompCreate, newId, userId, nodeId);
if (!result)
{
return(null);
}
return(newId);
}
catch (Exception ex)
{
return(null);
}
}
public bool AddHospitalizacion(string personId, string serviceId, int nodeId, int userId)
{
try
{
DatabaseContext cnx = new DatabaseContext();
var hospitalizacionId = new Common.Utils().GetPrimaryKey(nodeId, 350, "HP");
HospitalizacionBE _HospitalizacionBE = new HospitalizacionBE();
_HospitalizacionBE.v_HopitalizacionId = hospitalizacionId;
_HospitalizacionBE.v_PersonId = personId;
_HospitalizacionBE.d_FechaIngreso = DateTime.Now;
_HospitalizacionBE.i_IsDeleted = (int)SiNo.No;
_HospitalizacionBE.i_InsertUserId = userId;
_HospitalizacionBE.d_InsertDate = DateTime.Now;
cnx.Hospitalizacion.Add(_HospitalizacionBE);
cnx.SaveChanges();
bool result = AddHospitalizacionService(hospitalizacionId, serviceId, nodeId, userId);
return(result);
}
catch (Exception ex)
{
return(false);
}
}
public IActionResult GetAssetList(
[FromQuery] string continuation,
[FromQuery] int take)
{
// until ASP.NET Core 2.1 data annotations on arguments do not work
if (take <= 0)
{
ModelState.AddModelError(nameof(take), "Must be greater than zero");
}
// kinda specific knowledge but there is no
// another way to ensure continuation token
if (!string.IsNullOrEmpty(continuation))
{
try
{
JsonConvert.DeserializeObject <TableContinuationToken>(CommonUtils.HexToString(continuation));
}
catch
{
ModelState.AddModelError(nameof(continuation), "Invalid continuation token");
}
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.ToBlockchainErrorResponse()));
}
return(Ok(PaginationResponse.From(null,
Constants.Assets.Values.Select(v => v.ToAssetContract()).ToArray())));
}
public string GetTransactionSigner(string signedTxData)
{
var signedTransaction = new Transaction(CommonUtils.HexToArray(signedTxData));
var signerPublicAddress = signedTransaction.Key?.GetPublicAddress().ToLowerInvariant();
return(signerPublicAddress);
}
public string AddMovement(BoardPrintRecipes data)
{
try
{
string NewId = "(No generado)";
var supplierId = data.SupplierId == null ? null : data.SupplierId;
var motiveType = data.MotiveTypeId == null ? 4 : data.MotiveTypeId;
DateTime _date = data.Date.Value == null ? DateTime.Now : data.Date.Value;
MovementBE oMovement = new MovementBE();
//New
NewId = new Common.Utils().GetPrimaryKey(data.NodeId.Value, 370, "MM");
oMovement.v_MovementId = NewId;
oMovement.i_MovementTypeId = data.MovementTypeId.Value;
oMovement.v_WarehouseId = data.WarehouseId;
oMovement.i_IsLocallyProcessed = (int)Enumeratores.SiNo.No;
oMovement.r_TotalQuantity = 0;
oMovement.v_ReferenceDocument = data.ReferenceDocument;
oMovement.i_MotiveTypeId = motiveType;
oMovement.v_SupplierId = supplierId;
oMovement.i_InsertUserId = data.InsertUserId.Value;
oMovement.d_Date = _date;
Ctx.Movement.Add(oMovement);
Ctx.SaveChanges();
return(NewId);
}
catch (Exception ex)
{
return(null);
}
}
public string AddHospitalizacion(string serviceId, int nodeId, int userId)
{
try
{
DatabaseContext cnx = new DatabaseContext();
var objCalendar = (from cal in cnx.Calendar
where cal.v_ServiceId == serviceId && cal.i_IsDeleted == 0
select cal).FirstOrDefault();
var hospitalizacionId = new Common.Utils().GetPrimaryKey(nodeId, 350, "HP");
HospitalizacionBE objHospitalizacionDto = new HospitalizacionBE();
objHospitalizacionDto.v_HopitalizacionId = hospitalizacionId;
objHospitalizacionDto.v_PersonId = objCalendar.v_PersonId;
objHospitalizacionDto.i_InsertUserId = userId;
objHospitalizacionDto.d_FechaIngreso = objCalendar.d_EntryTimeCM.Value;
objHospitalizacionDto.d_InsertDate = DateTime.Now;
objHospitalizacionDto.i_IsDeleted = (int)SiNo.No;
cnx.Hospitalizacion.Add(objHospitalizacionDto);
cnx.SaveChanges();
return(hospitalizacionId);
}
catch (Exception ex)
{
return(null);
}
}
public string AddDiagnosticRepository(DiagnosticCustom dataDiagnostic, int nodeId, int systemUserId)
{
try
{
DatabaseContext ctx = new DatabaseContext();
DiagnosticRepositoryDto objDiag = new DiagnosticRepositoryDto();
var id = new Common.Utils().GetPrimaryKey(nodeId, 29, "DR");
objDiag.v_DiagnosticRepositoryId = id;
objDiag.v_ServiceId = dataDiagnostic.ServiceId;
objDiag.v_DiseasesId = dataDiagnostic.DiseaseId;
objDiag.v_ComponentId = dataDiagnostic.ComponentId;
objDiag.i_AutoManualId = (int)AutoManual.Manual; // dr.AutoManualId;
objDiag.i_PreQualificationId = (int)PreQualification.Aceptado; // dr.PreQualificationId;
objDiag.i_FinalQualificationId = (int)FinalQualification.Definitivo; // dr.FinalQualificationId;
objDiag.i_DiagnosticTypeId = (int)TipoDx.Enfermedad_Comun; // dr.DiagnosticTypeId;
objDiag.i_IsDeleted = 0;
objDiag.i_InsertUserId = systemUserId;
objDiag.d_InsertDate = DateTime.Now;
ctx.DiagnosticRepository.Add(objDiag);
ctx.SaveChanges();
return(id);
}
catch (Exception ex)
{
return(null);
}
}
public void SaveConfigDX(List <ConfigDxCustom> pobjConfigDx, int nodeId, int systemUserId)
{
//mon.IsActive = true;
string NewId0 = "(No generado)";
string componentId = null;
if (pobjConfigDx != null)
{
foreach (var dr in pobjConfigDx)
{
#region DiagnosticRepository -> ADD / UPDATE / DELETE
// ADD
if (dr.RecordType == (int)RecordType.Temporal && (dr.RecordStatus == (int)RecordStatus.Agregado || dr.RecordStatus == (int)RecordStatus.Editado))
{
ConfigDxDto objEntity = new ConfigDxDto();
objEntity.v_DiseaseId = dr.v_DiseaseId;
objEntity.v_ProductId = dr.v_ProductId;
objEntity.d_InsertDate = DateTime.Now;
objEntity.i_InsertUserId = systemUserId;
objEntity.i_IsDeleted = 0;
// Autogeneramos el Pk de la tabla
NewId0 = new Common.Utils().GetPrimaryKey(nodeId, 370, "WD");
objEntity.v_ConfigDxId = NewId0;
Ctx.ConfigDx.Add(objEntity);
} // UPDATE
else if (dr.RecordType == (int)RecordType.NoTemporal && dr.RecordStatus == (int)RecordStatus.Editado)
{
// Obtener la entidad fuente
var objEntitySource = (from a in Ctx.ConfigDx
where a.v_ConfigDxId == dr.v_ConfigDxId
select a).FirstOrDefault();
objEntitySource.d_UpdateDate = DateTime.Now;
objEntitySource.i_UpdateUserId = systemUserId;
} // DELETE
else if (dr.RecordType == (int)RecordType.NoTemporal && dr.RecordStatus == (int)RecordStatus.Eliminado)
{
// Obtener la entidad fuente
var objEntitySource = (from a in Ctx.ConfigDx
where a.v_ConfigDxId == dr.v_ConfigDxId
select a).FirstOrDefault();
// Crear la entidad con los datos actualizados
objEntitySource.d_UpdateDate = DateTime.Now;
objEntitySource.i_UpdateUserId = systemUserId;
objEntitySource.i_IsDeleted = 1;
}
#endregion
}
Ctx.SaveChanges();
}
}
public void AddCalendar(CalendarDto oCalendarDto, int nodeId, int systemUserId)
{
var calendarId = new Common.Utils().GetPrimaryKey(nodeId, 22, "CA");
oCalendarDto.v_CalendarId = calendarId;
oCalendarDto.i_IsDeleted = (int)Enumeratores.SiNo.No;
oCalendarDto.d_InsertDate = DateTime.UtcNow;
oCalendarDto.i_InsertUserId = systemUserId;
ctx.Calendar.Add(oCalendarDto);
ctx.SaveChanges();
}
public string AddService(ServiceDto oServiceDto, int nodeId, int systemUserId)
{
var serviceId = new Common.Utils().GetPrimaryKey(nodeId, 23, "SR");
oServiceDto.v_ServiceId = serviceId;
oServiceDto.i_IsDeleted = (int)Enumeratores.SiNo.No;
oServiceDto.d_InsertDate = DateTime.UtcNow;
oServiceDto.i_InsertUserId = systemUserId;
ctx.Service.Add(oServiceDto);
ctx.SaveChanges();
return(oServiceDto.v_ServiceId);
}
private string AddPlanVigilancia(PlanVigilanciaDto oPlanVigilanciaDto, int nodeId, int systemUserId)
{
var planVigilanciaId = new Common.Utils().GetPrimaryKey(nodeId, 220, "PV");
oPlanVigilanciaDto.v_PlanVigilanciaId = planVigilanciaId;
oPlanVigilanciaDto.i_IsDeleted = (int)SiNo.No;
oPlanVigilanciaDto.d_InsertDate = DateTime.Now;
oPlanVigilanciaDto.i_InsertUserId = systemUserId;
_ctx.PlanVigilancia.Add(oPlanVigilanciaDto);
_ctx.SaveChanges();
return(planVigilanciaId);
}
private void AddPlanVigilanciaDiseases(List <PlanDiseasesCustom> list, string planVigilanciaId, int nodeId, int systemUserId)
{
foreach (var item in list)
{
var oPlanVigilanciaDiseasesDto = new PlanVigilanciaDiseasesDto();
if (item.RecordStatus == (int)RecordStatus.Agregado && item.RecordType == (int)RecordType.Temporal)
{
var planVigilanciaDiseasesId = new Common.Utils().GetPrimaryKey(nodeId, 221, "VD");
oPlanVigilanciaDiseasesDto.v_PlanVigilanciaDiseasesId = planVigilanciaDiseasesId;
oPlanVigilanciaDiseasesDto.v_PlanVigilanciaId = planVigilanciaId;
oPlanVigilanciaDiseasesDto.v_DiseasesId = item.DiseasesId;
oPlanVigilanciaDiseasesDto.i_IsDeleted = (int)SiNo.No;
oPlanVigilanciaDiseasesDto.d_InsertDate = DateTime.Now;
oPlanVigilanciaDiseasesDto.i_InsertUserId = systemUserId;
_ctx.PlanVigilanciaDiseases.Add(oPlanVigilanciaDiseasesDto);
}
else if (item.RecordStatus == (int)RecordStatus.Editado && item.RecordType == (int)RecordType.NoTemporal)
{
var objEntitySource = (from a in _ctx.PlanVigilanciaDiseases
where a.v_PlanVigilanciaDiseasesId == item.PlanVigilanciaDiseasesId
select a).FirstOrDefault();
if (objEntitySource != null)
{
objEntitySource.v_DiseasesId = item.DiseasesId;
objEntitySource.d_UpdateDate = DateTime.Now;
objEntitySource.i_UpdateUserId = systemUserId;
//_ctx.PlanVigilanciaDiseases.Add(objEntitySource);
}
}
else if (item.RecordStatus == (int)RecordStatus.Eliminado && item.RecordType == (int)RecordType.NoTemporal)
{
var objEntitySource = (from a in _ctx.PlanVigilanciaDiseases
where a.v_PlanVigilanciaDiseasesId == item.PlanVigilanciaDiseasesId
select a).FirstOrDefault();
if (objEntitySource != null)
{
objEntitySource.i_IsDeleted = (int)SiNo.Si;
objEntitySource.d_UpdateDate = DateTime.Now;
objEntitySource.i_UpdateUserId = systemUserId;
//_ctx.PlanVigilanciaDiseases.Add(objEntitySource);
}
}
_ctx.SaveChanges();
}
}
public int AddSystemUSer(SystemUserDto pobjDtoEntity, int userId, int nodeId)
{
//mon.IsActive = true;
int SecuentialId = 0;
SecuentialId = new Common.Utils().GetNextSecuentialId(nodeId, 9);
var conn = ConfigurationManager.ConnectionStrings["BDSigesoft"].ConnectionString;
string query = " INSERT INTO systemuser( i_SystemUserId, v_PersonId, v_UserName, v_Password, d_ExpireDate, v_SystemUserByOrganizationId, i_IsDeleted, i_InsertUserId, d_InsertDate, i_SystemUserTypeId)" +
" VALUES( " + SecuentialId + ", '" + pobjDtoEntity.v_PersonId + "', '" + pobjDtoEntity.v_UserName + "', '" + pobjDtoEntity.v_Password + "', '" + pobjDtoEntity.d_ExpireDate + "', '" + pobjDtoEntity.v_SystemUserByOrganizationId + "'" +
", 0, " + userId + ", '" + DateTime.Now + "', " + pobjDtoEntity.i_SystemUserTypeId + ")";
SqlConnection sqlConnection = new SqlConnection(conn);
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
try
{
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return(SecuentialId);
}
catch (Exception exc)
{
sqlConnection.Close();
return(-1);
}
//try
//{
// DatabaseContext dbContext = new DatabaseContext();
// pobjDtoEntity.d_InsertDate = DateTime.Now;
// pobjDtoEntity.i_InsertUserId = userId;
// pobjDtoEntity.i_IsDeleted = 0;
// pobjDtoEntity.i_SystemUserId = SecuentialId;
// pobjDtoEntity.i_RolVentaId = -1;
// dbContext.SystemUser.Add(pobjDtoEntity);
// dbContext.SaveChanges();
// return SecuentialId;
//}
//catch (Exception ex)
//{
// return -1;
//}
}
/// <inheritdoc />
public string UnsignTransaction(string signedTxData)
{
var signedTransaction = new Transaction(CommonUtils.HexToArray(signedTxData));
if (signedTransaction.Data != null)
{
throw new NotSupportedException("Transactions with data are not supported.");
}
var to = signedTransaction.ReceiveAddress.ToHex(true);
var amount = signedTransaction.Value.ToBigIntegerFromRLPDecoded();
var nonce = signedTransaction.Nonce.ToBigIntegerFromRLPDecoded();
var gasPrice = signedTransaction.GasPrice.ToBigIntegerFromRLPDecoded();
var gasLimit = signedTransaction.GasLimit.ToBigIntegerFromRLPDecoded();
return(BuildTransaction(to, amount, nonce, gasPrice, gasLimit));
}
public void AddServiceComponentInBlock(List <ServiceComponentDto> list, int nodeId, int systemUserId)
{
using (var oCtx = new DatabaseContext())
{
foreach (var item in list)
{
var serviceComponentId = new Common.Utils().GetPrimaryKey(nodeId, 24, "SC");
item.v_ServiceComponentId = serviceComponentId;
item.i_IsDeleted = (int)Enumeratores.SiNo.No;
item.d_InsertDate = DateTime.UtcNow;
item.i_InsertUserId = systemUserId;
oCtx.ServiceComponent.Add(item);
}
oCtx.SaveChanges();
}
}
public string AddVigilanciaService(VigilanciaServiceDto oVigilanciaServiceDto, int nodeId, int systemUserId)
{
using (var ctx = new DatabaseContext())
{
var vigilanciaServiceId = new Common.Utils().GetPrimaryKey(nodeId, 231, "VS");
oVigilanciaServiceDto.v_VigilanciaServiceId = vigilanciaServiceId;
oVigilanciaServiceDto.v_VigilanciaId = oVigilanciaServiceDto.v_VigilanciaId;
oVigilanciaServiceDto.i_IsDeleted = (int)Enumeratores.SiNo.No;
oVigilanciaServiceDto.d_InsertDate = DateTime.UtcNow;
oVigilanciaServiceDto.i_InsertUserId = systemUserId;
ctx.VigilanciaService.Add(oVigilanciaServiceDto);
ctx.SaveChanges();
return(vigilanciaServiceId);
}
}
public static string SaveOrganization(OrganizationBE data, int userId, int nodeId)
{
try
{
using (var ts = new TransactionScope())
{
string organization = GetOrganizationByRuc(data.v_IdentificationNumber);
if (organization != null)
{
return(organization);
}
string newId = "";
newId = new Common.Utils().GetPrimaryKey(nodeId, 5, "OO");
data.v_OrganizationId = newId;
data.i_InsertUserId = userId;
data.d_InsertDate = DateTime.Now;
data.i_IsDeleted = 0;
ctx.Organization.Add(data);
ctx.SaveChanges();
LocationBE loc = new LocationBE();
var arr = data.v_Address.Split('-').Reverse().ToArray();
var sede = arr[0].ToString();
loc.v_OrganizationId = newId;
loc.v_Name = sede;
string locationId = SaveLocationAndGroupOccupation(loc, userId, nodeId);
if (locationId == null)
{
throw new Exception("Error");
}
ts.Complete();
return(newId + "|" + locationId);
}
}
catch (Exception ex)
{
return(null);
}
}
public bool AddCalendar(CalendarDto oCalendarDto, int nodeId, int systemUserId)
{
try
{
var calendarId = new Common.Utils().GetPrimaryKey(nodeId, 22, "CA");
oCalendarDto.v_CalendarId = calendarId;
oCalendarDto.i_IsDeleted = (int)SiNo.No;
oCalendarDto.d_InsertDate = DateTime.UtcNow;
oCalendarDto.i_InsertUserId = systemUserId;
ctx.Calendar.Add(oCalendarDto);
return(ctx.SaveChanges() > 0);
}
catch (Exception ex)
{
return(false);
}
}
public void AddTestConcurrence(TestConcurrenceDto oTestConcurrenceDto)
{
try
{
using (var ctx = new DatabaseContext())
{
var TestConcurrenceId = new Common.Utils().GetPrimaryKey(1, 1000, "TT");
oTestConcurrenceDto.TestConcurrenceId = TestConcurrenceId;
oTestConcurrenceDto.Value = oTestConcurrenceDto.Value;
ctx.TestConcurrenc.Add(oTestConcurrenceDto);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
AddTestConcurrence(oTestConcurrenceDto);
}
}
public static bool AddProtocolSystemUser(List <ProtocolSystemUserBE> lista, int userId, int nodeId)
{
try
{
DatabaseContext cnx = new DatabaseContext();
foreach (var obj in lista)
{
var newId = new Common.Utils().GetPrimaryKey(nodeId, 44, "PU");
obj.i_IsDeleted = (int)SiNo.No;
obj.i_InsertUserId = userId;
obj.d_InsertDate = DateTime.Now;
obj.v_ProtocolSystemUserId = newId;
cnx.ProtocolSystemUser.Add(obj);
}
return(cnx.SaveChanges() > 0);
}
catch (Exception ex)
{
return(false);
}
}
public bool AddEmbarazo(EmbarazoBE objEmbarazo, int nodeId, int userId)
{
string NewId0 = null;
try
{
NewId0 = new Common.Utils().GetPrimaryKey(nodeId, 357, "EM");
DatabaseContext dbContext = new DatabaseContext();
objEmbarazo.v_EmbarazoId = NewId0;
objEmbarazo.d_InsertDate = DateTime.Now;
objEmbarazo.i_InsertUserId = userId;
objEmbarazo.i_IsDeleted = 0;
dbContext.Embarazo.Add(objEmbarazo);
return(dbContext.SaveChanges() > 0);
}
catch (Exception ex)
{
return(false);
}
}
public static bool AddProtocolComponent(List <ProtocolComponentDto> listProtComp, string protocolId, int userId, int nodeId)
{
try
{
DatabaseContext cnx = new DatabaseContext();
foreach (var objProtComp in listProtComp)
{
var newId = new Common.Utils().GetPrimaryKey(nodeId, 21, "PC");
objProtComp.v_ProtocolId = protocolId;
objProtComp.v_ProtocolComponentId = newId;
objProtComp.d_InsertDate = DateTime.Now;
objProtComp.i_IsDeleted = (int)SiNo.No;
objProtComp.i_InsertUserId = userId;
cnx.ProtocolComponent.Add(objProtComp);
}
return(cnx.SaveChanges() > 0);
}
catch (Exception ex)
{
return(false);
}
}
public bool AddHospitalizacionService(string hospitalizacionId, string serviceId, int nodeId, int userId)
{
try
{
DatabaseContext cnx = new DatabaseContext();
var hospitalizacionServiceId = new Common.Utils().GetPrimaryKey(nodeId, 351, "HS");
HospitalizacionServiceBE _HospitalizacionServiceBE = new HospitalizacionServiceBE();
_HospitalizacionServiceBE.v_HospitalizacionServiceId = hospitalizacionServiceId;
_HospitalizacionServiceBE.v_HopitalizacionId = hospitalizacionId;
_HospitalizacionServiceBE.v_ServiceId = serviceId;
_HospitalizacionServiceBE.i_IsDeleted = (int)SiNo.No;
_HospitalizacionServiceBE.i_InsertUserId = userId;
_HospitalizacionServiceBE.d_InsertDate = DateTime.Now;
cnx.HospitalizacionService.Add(_HospitalizacionServiceBE);
return(cnx.SaveChanges() > 0);
}
catch (Exception ex)
{
return(false);
}
}
public static string AddServiceOrder(ServiceOrderBE pobjDtoEntity, List <ServiceOrderDetailBE> pobjDtoEntityDetail, int userId, int nodeId)
{
//mon.IsActive = true;
string NewId = "(No generado)";
try
{
DatabaseContext dbContext = new DatabaseContext();
#region Service Order
if (pobjDtoEntity.v_ServiceOrderId == null) //Add
{
pobjDtoEntity.d_InsertDate = DateTime.Now;
pobjDtoEntity.i_InsertUserId = userId;
pobjDtoEntity.i_IsDeleted = 0;
NewId = new Common.Utils().GetPrimaryKey(nodeId, 101, "YY");
pobjDtoEntity.v_ServiceOrderId = NewId;
dbContext.ServiceOrder.Add(pobjDtoEntity);
}
else //update
{
NewId = pobjDtoEntity.v_ServiceOrderId;
var objServiceOrder = ctx.ServiceOrder.Where(x => x.v_ServiceOrderId == pobjDtoEntity.v_ServiceOrderId).FirstOrDefault();
objServiceOrder.d_UpdateDate = DateTime.Now;
objServiceOrder.i_UpdateUserId = userId;
objServiceOrder.i_MostrarPrecio = pobjDtoEntity.i_MostrarPrecio;
objServiceOrder.i_LineaCreditoId = pobjDtoEntity.i_LineaCreditoId;
objServiceOrder.i_NumberOfWorker = pobjDtoEntity.i_NumberOfWorker;
objServiceOrder.i_ServiceOrderStatusId = pobjDtoEntity.i_ServiceOrderStatusId;
objServiceOrder.r_TotalCost = pobjDtoEntity.r_TotalCost;
}
dbContext.SaveChanges();
#endregion
#region Service Order Detail
if (pobjDtoEntityDetail != null)
{
foreach (var item in pobjDtoEntityDetail)
{
if (item.v_ServiceOrderDetailId == null) //add
{
item.d_InsertDate = DateTime.Now;
item.i_InsertUserId = userId;
item.i_IsDeleted = 0;
// Autogeneramos el Pk de la tabla
item.v_ServiceOrderId = NewId;
item.v_ServiceOrderDetailId = new Common.Utils().GetPrimaryKey(nodeId, 102, "YA");
dbContext.ServiceOrderDetail.Add(item);
dbContext.SaveChanges();
}
else //Update
{
var objServiceOrderDetail = dbContext.ServiceOrderDetail.Where(x => x.v_ServiceOrderDetailId == item.v_ServiceOrderDetailId).FirstOrDefault();
objServiceOrderDetail.d_UpdateDate = DateTime.Now;
objServiceOrderDetail.i_UpdateUserId = userId;
objServiceOrderDetail.v_ProtocolId = item.v_ProtocolId;
objServiceOrderDetail.r_Total = item.r_Total;
objServiceOrderDetail.r_ProtocolPrice = item.r_ProtocolPrice;
objServiceOrderDetail.i_NumberOfWorkerProtocol = item.i_NumberOfWorkerProtocol;
}
}
dbContext.SaveChanges();
}
#endregion
return(NewId);
}
catch (Exception ex)
{
return(null);
}
}
public bool AddServiceComponentAtx(List <ProtocolComponentCustom> dataProtComponent, ServiceCustom dataService, int nodeId, int userId)
{
try
{
foreach (var obj in dataProtComponent)
{
var componentId = obj.ComponentId;
var serviceComponentId = new Common.Utils().GetPrimaryKey(nodeId, 24, "SC");
ServiceComponentDto oServiceComponentDto = new ServiceComponentDto();
oServiceComponentDto.v_ServiceComponentId = serviceComponentId;
oServiceComponentDto.v_ComponentId = obj.ComponentId;
oServiceComponentDto.i_MedicoTratanteId = dataService.MedicoTratanteId;
oServiceComponentDto.v_ServiceId = dataService.ServiceId;
oServiceComponentDto.i_ExternalInternalId = (int)ComponenteProcedencia.Interno;
oServiceComponentDto.i_ServiceComponentTypeId = obj.ComponentTypeId;
oServiceComponentDto.i_IsVisibleId = obj.UIIsVisibleId;
oServiceComponentDto.i_IsInheritedId = (int)SiNo.No;
oServiceComponentDto.d_StartDate = null;
oServiceComponentDto.d_EndDate = null;
oServiceComponentDto.i_index = obj.UIIndex;
var porcentajes = obj.Porcentajes.Split('-');
float p1 = porcentajes[0] == null || porcentajes[0] == "" ? 0 : float.Parse(porcentajes[0]);
float p2 = porcentajes[1] == null || porcentajes[1] == "" ? 0 : float.Parse(porcentajes[1]);
var pb = obj.Price;
oServiceComponentDto.r_Price = pb + (pb * p1 / 100) + (pb * p2 / 100);
oServiceComponentDto.r_Price = SetNewPrice(oServiceComponentDto.r_Price, obj.ComponentId);
oServiceComponentDto.i_IsInvoicedId = (int)SiNo.No;
oServiceComponentDto.i_ServiceComponentStatusId = (int)ServiceStatus.PorIniciar;
oServiceComponentDto.i_QueueStatusId = (int)QueueStatusId.Libre;
oServiceComponentDto.i_Iscalling = (int)FlagCall.NoseLlamo;
oServiceComponentDto.i_Iscalling_1 = (int)FlagCall.NoseLlamo;
oServiceComponentDto.v_IdUnidadProductiva = obj.IdUnidadProductiva;
var resultplan = new PlanDal().GetPlans(dataService.ProtocolId, obj.IdUnidadProductiva);
var tienePlan = false;
if (resultplan.Count > 0)
{
tienePlan = true;
}
else
{
tienePlan = false;
}
if (tienePlan)
{
if (resultplan[0].i_EsCoaseguro == 1)
{
oServiceComponentDto.d_SaldoPaciente = resultplan[0].d_Importe * decimal.Parse(oServiceComponentDto.r_Price.ToString()) / 100;
oServiceComponentDto.d_SaldoAseguradora = decimal.Parse(oServiceComponentDto.r_Price.ToString()) - oServiceComponentDto.d_SaldoPaciente;
}
if (resultplan[0].i_EsDeducible == 1)
{
oServiceComponentDto.d_SaldoPaciente = resultplan[0].d_Importe;
oServiceComponentDto.d_SaldoAseguradora = decimal.Parse(oServiceComponentDto.r_Price.ToString()) - resultplan[0].d_Importe;
}
}
var conditional = obj.IsConditionalId;
if (conditional == (int)SiNo.Si)
{
var fechaNacimiento = dataService.FechaNacimiento;
//Datos del paciente
if (fechaNacimiento != null)
{
var pacientAge = DateTime.Today.AddTicks(-fechaNacimiento.Ticks).Year - 1;
var pacientGender = dataService.GeneroId;
//Datos del protocolo
int analyzeAge = obj.Age.Value;
int analyzeGender = obj.GenderId.Value;
var @operator = (Operator2Values)obj.OperatorId;
GrupoEtario oGrupoEtario = (GrupoEtario)obj.GrupoEtarioId;
if ((int)@operator == -1)
{
//si la condicional del operador queda en --Seleccionar--
if (analyzeGender == (int)GenderConditional.Ambos)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else if (pacientGender == analyzeGender)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
else
{
if (analyzeGender == (int)GenderConditional.Masculino)
{
oServiceComponentDto.i_IsRequiredId = SwitchOperator2Values(pacientAge, analyzeAge,
@operator, pacientGender.Value, analyzeGender);
}
else if (analyzeGender == (int)GenderConditional.Femenino)
{
oServiceComponentDto.i_IsRequiredId = SwitchOperator2Values(pacientAge, analyzeAge,
@operator, pacientGender.Value, analyzeGender);
}
else if (analyzeGender == (int)GenderConditional.Ambos)
{
oServiceComponentDto.i_IsRequiredId = SwitchOperator2Values(pacientAge, analyzeAge,
@operator, pacientGender.Value, analyzeGender);
}
}
if (componentId == "N009-ME000000402") //Adolecente
{
if ((int)oGrupoEtario == -1)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else if (13 <= pacientAge && pacientAge <= 18)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
else if (componentId == "N009-ME000000403") //Adulto
{
if ((int)oGrupoEtario == -1)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else if (19 <= pacientAge && pacientAge <= 60)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
else if (componentId == "N009-ME000000404") //AdultoMayorCustom
{
if ((int)oGrupoEtario == -1)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else if (61 <= pacientAge)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
else if (componentId == "N009-ME000000406")
{
if ((int)oGrupoEtario == -1)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else if (12 >= pacientAge)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
else if (componentId == "N009-ME000000401") //plan integral
{
if ((int)oGrupoEtario == -1)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else if (12 >= pacientAge)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
else if (componentId == "N009-ME000000400") //atencion integral
{
if ((int)oGrupoEtario == -1)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else if (12 >= pacientAge)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
else if (componentId == "N009-ME000000405") //consulta
{
if ((int)oGrupoEtario == -1)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else if (12 >= pacientAge)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
}
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
if (obj.IsAdditional == null)
{
continue;
}
var adicional = obj.IsAdditional;
if (adicional == 1)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
oServiceComponentDto.i_ConCargoA = 0;
ctx.ServiceComponent.Add(oServiceComponentDto);
}
return(ctx.SaveChanges() > 0);
}
catch (Exception)
{
return(false);
}
}
public bool AddServiceComponent(List <ProtocolComponentCustom> dataProtComponent, ServiceCustom dataService, int nodeId, int userId)
{
try
{
foreach (var obj in dataProtComponent)
{
var serviceComponentId = new Common.Utils().GetPrimaryKey(nodeId, 24, "SC");
ServiceComponentDto oServiceComponentDto = new ServiceComponentDto();
oServiceComponentDto.v_ServiceComponentId = serviceComponentId;
oServiceComponentDto.v_ComponentId = obj.ComponentId;
oServiceComponentDto.i_MedicoTratanteId = dataService.MedicoTratanteId;
oServiceComponentDto.v_ServiceId = dataService.ServiceId;
oServiceComponentDto.i_ExternalInternalId = (int)ComponenteProcedencia.Interno;
oServiceComponentDto.i_ServiceComponentTypeId = obj.ComponentTypeId;
oServiceComponentDto.i_IsVisibleId = obj.UIIsVisibleId;
oServiceComponentDto.i_IsInheritedId = (int)SiNo.No;
oServiceComponentDto.d_StartDate = null;
oServiceComponentDto.d_EndDate = null;
oServiceComponentDto.i_index = obj.UIIndex;
oServiceComponentDto.i_IsDeleted = (int)SiNo.No;
oServiceComponentDto.d_InsertDate = DateTime.Now;
oServiceComponentDto.i_InsertUserId = userId;
var porcentajes = obj.Porcentajes.Split('-');
float p1 = porcentajes[0] == null || porcentajes[0] == "" ? 0 : float.Parse(porcentajes[0]);
float p2 = porcentajes[1] == null || porcentajes[1] == "" ? 0 : float.Parse(porcentajes[1]);
var pb = obj.Price;
oServiceComponentDto.r_Price = pb + (pb * p1 / 100) + (pb * p2 / 100);
oServiceComponentDto.r_Price = SetNewPrice(oServiceComponentDto.r_Price, obj.ComponentId);
oServiceComponentDto.i_IsInvoicedId = (int)SiNo.No;
oServiceComponentDto.i_ServiceComponentStatusId = (int)ServiceStatus.PorIniciar;
oServiceComponentDto.i_QueueStatusId = (int)QueueStatusId.Libre;
oServiceComponentDto.i_Iscalling = (int)FlagCall.NoseLlamo;
oServiceComponentDto.i_Iscalling_1 = (int)FlagCall.NoseLlamo;
oServiceComponentDto.v_IdUnidadProductiva = obj.IdUnidadProductiva;
var resultplan = new PlanDal().GetPlans(dataService.ProtocolId, obj.IdUnidadProductiva);
var tienePlan = false;
if (resultplan.Count > 0)
{
tienePlan = true;
}
else
{
tienePlan = false;
}
if (tienePlan)
{
if (resultplan[0].i_EsCoaseguro == 1)
{
oServiceComponentDto.d_SaldoPaciente = resultplan[0].d_Importe * decimal.Parse(oServiceComponentDto.r_Price.ToString()) / 100;
oServiceComponentDto.d_SaldoAseguradora = decimal.Parse(oServiceComponentDto.r_Price.ToString()) - oServiceComponentDto.d_SaldoPaciente;
}
if (resultplan[0].i_EsDeducible == 1)
{
oServiceComponentDto.d_SaldoPaciente = resultplan[0].d_Importe;
oServiceComponentDto.d_SaldoAseguradora = decimal.Parse(oServiceComponentDto.r_Price.ToString()) - resultplan[0].d_Importe;
}
}
//Condicionales
var conditional = obj.IsConditionalId;
if (conditional == (int)SiNo.Si)
{
var fechaNacimiento = dataService.FechaNacimiento;
//Datos del paciente
if (fechaNacimiento != null)
{
var pacientAge = DateTime.Today.AddTicks(-fechaNacimiento.Ticks).Year - 1;
var pacientGender = dataService.GeneroId;
//Datos del protocolo
int analyzeAge = obj.Age.Value;
int analyzeGender = obj.GenderId.Value;
var @operator = (Operator2Values)obj.OperatorId;
GrupoEtario oGrupoEtario = (GrupoEtario)obj.GrupoEtarioId;
if (analyzeAge >= 0) //condicional edad (SI)
{
if (analyzeGender != (int)GenderConditional.Ambos) //condicional genero (SI)
{
if (@operator == Operator2Values.X_esIgualque_A)
{
if (pacientAge == analyzeAge && pacientGender == analyzeGender)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
if (@operator == Operator2Values.X_esMayorIgualque_A)
{
if (pacientAge >= analyzeAge && pacientGender == analyzeGender)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
if (@operator == Operator2Values.X_esMayorque_A)
{
if (pacientAge > analyzeAge && pacientGender == analyzeGender)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
if (@operator == Operator2Values.X_esMenorIgualque_A)
{
if (pacientAge <= analyzeAge && pacientGender == analyzeGender)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
}
else//condicional genero (NO)
{
if (@operator == Operator2Values.X_esIgualque_A)
{
if (pacientAge == analyzeAge)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
if (@operator == Operator2Values.X_esMayorIgualque_A)
{
if (pacientAge >= analyzeAge)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
if (@operator == Operator2Values.X_esMayorque_A)
{
if (pacientAge > analyzeAge)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
if (@operator == Operator2Values.X_esMenorIgualque_A)
{
if (pacientAge <= analyzeAge)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
}
}
}
}
else
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.Si;
if (obj.IsAdditional == null)
{
continue;
}
var adicional = obj.IsAdditional;
if (adicional == 1)
{
oServiceComponentDto.i_IsRequiredId = (int)SiNo.No;
}
}
oServiceComponentDto.i_ConCargoA = 0;
oServiceComponentDto.i_IsManuallyAddedId = (int)SiNo.No;
ctx.ServiceComponent.Add(oServiceComponentDto);
}
return(ctx.SaveChanges() > 0);
}
catch (Exception)
{
return(false);
}
}
/// <inheritdoc />
public string GetTransactionHash(string txData)
{
return((new Transaction(CommonUtils.HexToArray(txData)))
.Hash.ToHex(true));
}
