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)); }