/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnResult <bool> Delete(Protocol model)
{
var rst = new ReturnResult <bool>();
using (var dal = new ProtocolDal())
{
rst = dal.Delete(model);
}
return(rst);
}
/// <summary>
/// 获取一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnResult <Protocol> GetOne(Protocol model)
{
var rst = new ReturnResult <Protocol>();
using (var dal = new ProtocolDal())
{
rst = dal.GetOne(model);
}
return(rst);
}
public ReturnResult <Protocol> GetOneByDeviceId(string deviceId)
{
var rst = new ReturnResult <Protocol>();
using (var dal = new ProtocolDal())
{
rst = dal.GetOneByDeviceId(deviceId);
}
return(rst);
}
/// <summary>
/// 新增多条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnResult <bool> AddList(List <Protocol> list)
{
var rst = new ReturnResult <bool>();
using (var dal = new ProtocolDal())
{
rst = dal.AddList(list);
}
return(rst);
}
public static ProtocolList GetProtocolById(string pstrProtocolId)
{
return(ProtocolDal.GetProtocolById(pstrProtocolId));
}
public string ReturnOrDuplicateProtocol(ServiceCustom data, int nodeId, int userId, List <ProtocolComponentCustom> ListProtocolComponent)
{
try
{
if (ListProtocolComponent == null)
{
return(null);
}
var id = data.DataProtocol.EmpresaEmpleadora.Split('|');
var id1 = data.DataProtocol.EmpresaCliente.Split('|');
var id2 = data.DataProtocol.EmpresaTrabajo.Split('|');
var masterServiceTypeId = data.DataProtocol.i_MasterServiceTypeId;
var masterServiceId = data.DataProtocol.i_MasterServiceId;
var groupOccupationName = data.DataProtocol.Geso;
var esoTypeId = data.DataProtocol.i_EsoTypeId;
bool ExisteProtocolo = ProtocolDal.ExisteProtocoloPropuestoSegunLaEmpresa(id[0], masterServiceTypeId, masterServiceId, groupOccupationName, esoTypeId);
if (!ExisteProtocolo)
{
ProtocolBE _ProtocolBE = new ProtocolBE();
var sufProtocol = data.DataProtocol.EmpresaEmpleadoraName.Split('/');
_ProtocolBE.v_Name = data.DataProtocol.ProtocolName + " " + sufProtocol[0].ToString();
_ProtocolBE.v_EmployerOrganizationId = id[0];
_ProtocolBE.v_EmployerLocationId = id[1];
_ProtocolBE.i_EsoTypeId = data.DataProtocol.i_EsoTypeId;
//obtener GESO
var gesoId = new OrganizationDal().GetGroupOcupation(id[1], groupOccupationName);
_ProtocolBE.v_GroupOccupationId = gesoId;
_ProtocolBE.v_CustomerOrganizationId = id1[0];
_ProtocolBE.v_CustomerLocationId = id1[1];
_ProtocolBE.v_WorkingOrganizationId = id2[0];
_ProtocolBE.v_WorkingLocationId = data.DataProtocol.EmpresaEmpleadora != "-1" ? id2[1] : "-1";
_ProtocolBE.i_MasterServiceId = masterServiceId;
_ProtocolBE.v_CostCenter = string.Empty;
_ProtocolBE.i_MasterServiceTypeId = masterServiceTypeId;
_ProtocolBE.i_HasVigency = 1;
_ProtocolBE.i_ValidInDays = null;
_ProtocolBE.i_IsActive = 1;
_ProtocolBE.v_NombreVendedor = string.Empty;
List <ProtocolComponentDto> ListProtocolComponentDto = new List <ProtocolComponentDto>();
foreach (var objProtCom in ListProtocolComponent)
{
ProtocolComponentDto _ProtocolComponentDto = new ProtocolComponentDto();
_ProtocolComponentDto.v_ComponentId = objProtCom.ComponentId;
_ProtocolComponentDto.r_Price = objProtCom.Price;
_ProtocolComponentDto.i_OperatorId = objProtCom.OperatorId;
_ProtocolComponentDto.i_Age = objProtCom.Age;
_ProtocolComponentDto.i_GenderId = objProtCom.GenderId;
_ProtocolComponentDto.i_IsAdditional = objProtCom.IsAdditional;
_ProtocolComponentDto.i_IsConditionalId = objProtCom.IsConditionalId;
_ProtocolComponentDto.i_GrupoEtarioId = objProtCom.GrupoEtarioId;
_ProtocolComponentDto.i_IsConditionalIMC = objProtCom.IsConditionalIMC;
_ProtocolComponentDto.r_Imc = objProtCom.Imc;
ListProtocolComponentDto.Add(_ProtocolComponentDto);
}
string protocolId = ProtocolDal.AddProtocol(_ProtocolBE, ListProtocolComponentDto, nodeId, userId);
if (protocolId == null)
{
return(null);
}
var ListUser = ProtocolDal.GetSystemUserSigesoft();
var extUserWithCustomer = ListUser.FindAll(p => p.v_SystemUserByOrganizationId == id1[0]).ToList();
var extUserWithEmployer = ListUser.FindAll(p => p.v_SystemUserByOrganizationId == id[0]).ToList();
var extUserWithWorking = ListUser.FindAll(p => p.v_SystemUserByOrganizationId == id2[0]).ToList();
foreach (var extUs in extUserWithCustomer)
{
var ListUserExter = ProtocolDal.GetProtocolSystemUser(extUs.i_SystemUserId);
var list = new List <ProtocolSystemUserBE>();
foreach (var perm in ListUserExter)
{
var oProtocolSystemUserBEo = new ProtocolSystemUserBE();
oProtocolSystemUserBEo.i_SystemUserId = extUs.i_SystemUserId;
oProtocolSystemUserBEo.v_ProtocolId = protocolId;
oProtocolSystemUserBEo.i_ApplicationHierarchyId = perm.i_ApplicationHierarchyId;
list.Add(oProtocolSystemUserBEo);
}
bool resultUs = ProtocolDal.AddProtocolSystemUser(list, userId, nodeId);
if (!resultUs)
{
return(null);
}
}
foreach (var extUs in extUserWithEmployer)
{
var ListUserExter = ProtocolDal.GetProtocolSystemUser(extUs.i_SystemUserId);
var list = new List <ProtocolSystemUserBE>();
foreach (var perm in ListUserExter)
{
var oProtocolSystemUserBEo = new ProtocolSystemUserBE();
oProtocolSystemUserBEo.i_SystemUserId = extUs.i_SystemUserId;
oProtocolSystemUserBEo.v_ProtocolId = protocolId;
oProtocolSystemUserBEo.i_ApplicationHierarchyId = perm.i_ApplicationHierarchyId;
list.Add(oProtocolSystemUserBEo);
}
bool resultUs = ProtocolDal.AddProtocolSystemUser(list, userId, nodeId);
if (!resultUs)
{
return(null);
}
}
foreach (var extUs in extUserWithWorking)
{
var ListUserExter = ProtocolDal.GetProtocolSystemUser(extUs.i_SystemUserId);
var list = new List <ProtocolSystemUserBE>();
foreach (var perm in ListUserExter)
{
var oProtocolSystemUserBEo = new ProtocolSystemUserBE();
oProtocolSystemUserBEo.i_SystemUserId = extUs.i_SystemUserId;
oProtocolSystemUserBEo.v_ProtocolId = protocolId;
oProtocolSystemUserBEo.i_ApplicationHierarchyId = perm.i_ApplicationHierarchyId;
list.Add(oProtocolSystemUserBEo);
}
bool resultUs = ProtocolDal.AddProtocolSystemUser(list, userId, nodeId);
if (!resultUs)
{
return(null);
}
}
return(protocolId);
}
else
{
return(data.ProtocolId);
}
}
catch (Exception ex)
{
return(null);
}
}
public static MessageCustom VerifyExistsProtocol(string protocolName)
{
return(ProtocolDal.VerifyExistsProtocol(protocolName));
}
public static List <OrganizationCustom> GetEmpresaByProtocoloId(string pstrProtocolId)
{
return(ProtocolDal.GetEmpresaByProtocoloId(pstrProtocolId));
}
public ProtocolCustom GetDataProtocol(string protocolId)
{
ProtocolDal protocolDal = new ProtocolDal();
return(protocolDal.GetDatosProtocolo(protocolId));
}
public static MessageCustom SaveProtocols(ProtocolList data, int userId, int nodeId)
{
MessageCustom msg = new MessageCustom();
try
{
using (var ts = new TransactionScope())
{
ProtocolBE protocolEntity = new ProtocolBE();
protocolEntity.v_ProtocolId = data.v_ProtocolId;
protocolEntity.v_Name = data.v_Name;
protocolEntity.v_GroupOccupationId = data.v_Geso;
protocolEntity.v_CustomerOrganizationId = data.v_CustomerOrganizationId.Split('|')[0];
protocolEntity.v_CustomerLocationId = data.v_CustomerOrganizationId.Split('|')[1];
protocolEntity.i_MasterServiceTypeId = data.i_ServiceTypeId;
protocolEntity.v_EmployerOrganizationId = data.v_IntermediaryOrganization.Split('|')[0];
protocolEntity.v_EmployerLocationId = data.v_IntermediaryOrganization.Split('|')[1];
protocolEntity.i_MasterServiceId = data.i_MasterServiceId;
protocolEntity.v_WorkingOrganizationId = data.v_WorkingOrganizationId.Split('|')[0];
protocolEntity.v_WorkingLocationId = data.v_WorkingOrganizationId.Split('|')[1];
protocolEntity.v_CostCenter = data.v_CostCenter;
protocolEntity.i_EsoTypeId = data.i_EsoTypeId;
protocolEntity.i_IsActive = data.i_IsActive;
protocolEntity.i_HasVigency = (int)SiNo.No;
protocolEntity.r_PriceFactor = data.r_PriceFactor == null ? 0 : data.r_PriceFactor;
protocolEntity.r_MedicineDiscount = data.r_MedicineDiscount == null ? 0 : data.r_MedicineDiscount;
protocolEntity.r_HospitalBedPrice = data.r_HospitalBedPrice == null ? 0 : data.r_HospitalBedPrice;
protocolEntity.r_ClinicDiscount = data.r_ClinicDiscount == null ? 0 : data.r_ClinicDiscount;
protocolEntity.r_DiscountExam = data.r_DiscountExam == null ? 0 : data.r_DiscountExam;
List <ProtocolComponentDto> ListProtocolComponentCreate = new List <ProtocolComponentDto>();
List <ProtocolComponentDto> ListProtocolComponentUpdate = new List <ProtocolComponentDto>();
if (data.ListComponents != null)
{
foreach (var obj in data.ListComponents)
{
ProtocolComponentDto objProtComp = new ProtocolComponentDto();
objProtComp.v_ProtocolComponentId = obj.v_ProtocolComponentId;
objProtComp.v_ComponentId = obj.v_ComponentId;
objProtComp.r_Price = obj.r_Price;
objProtComp.i_OperatorId = obj.i_OperadorId;
objProtComp.i_Age = obj.i_Edad;
objProtComp.i_GenderId = obj.i_GenderId;
objProtComp.i_GrupoEtarioId = obj.i_GrupoEtario;
objProtComp.i_IsConditionalId = obj.i_IsConditional;
objProtComp.i_IsConditionalIMC = obj.i_IsIMC;
objProtComp.r_Imc = obj.r_ValueIMC;
objProtComp.i_IsAdditional = obj.i_IsAditional;
objProtComp.v_ProtocolComponentId = obj.v_ProtocolComponentId;
if (obj.RecordStatus == (int)RecordStatus.Agregado && obj.RecordType == (int)RecordType.Temporal || obj.v_ProtocolComponentId == null)
{
ListProtocolComponentCreate.Add(objProtComp);
}
else if (obj.RecordStatus == (int)RecordStatus.Editado && obj.RecordType == (int)RecordType.NoTemporal || obj.v_ProtocolComponentId != null)
{
ListProtocolComponentUpdate.Add(objProtComp);
}
}
}
string protocolId = null;
if (data.v_ProtocolId == null)
{
protocolId = ProtocolDal.AddProtocol(protocolEntity, ListProtocolComponentCreate, nodeId, userId);
bool resultProtComp = ProtocolComponentDal.UpdateProtocolComponent(ListProtocolComponentUpdate, userId);
if (!resultProtComp)
{
return(null);
}
}
else
{
protocolId = ProtocolDal.UpdateProtocol(protocolEntity, ListProtocolComponentCreate, ListProtocolComponentUpdate, userId, nodeId);
}
if (protocolId == null)
{
msg.Error = true;
msg.Status = (int)HttpStatusCode.Conflict;
msg.Message = "Sucedió un error al crear el protocolo, por favor vuelva intentar.";
throw new Exception("");
}
else
{
msg.Error = false;
msg.Id = protocolId;
msg.Status = (int)HttpStatusCode.Created;
msg.Message = "El protocolo se creó correctamente.";
}
ts.Complete();
}
return(msg);
}
catch (Exception ex)
{
msg.Error = true;
msg.Status = (int)HttpStatusCode.Conflict;
msg.Message = "Sucedió un error al crear el protocolo, por favor vuelva intentar.";
return(msg);
}
}
public static BoardProtocol GetAllProtocol(BoardProtocol data)
{
return(ProtocolDal.GetAllProtocols(data));
}
public static MessageCustom AddServiceOrder(BoardServiceOrder data, int userId, int nodeId)
{
MessageCustom msg = new MessageCustom();
try
{
using (var ts = new TransactionScope())
{
#region Entities
ServiceOrderBE oServiceOrderBE = new ServiceOrderBE();
oServiceOrderBE.v_ServiceOrderId = data.EntityserviceOrder.v_ServiceOrderId;
oServiceOrderBE.v_CustomServiceOrderId = data.EntityserviceOrder.v_CustomServiceOrderId;
oServiceOrderBE.v_Description = data.EntityserviceOrder.v_Description;
oServiceOrderBE.v_Comentary = data.EntityserviceOrder.v_Comentary;
oServiceOrderBE.i_NumberOfWorker = data.EntityserviceOrder.i_NumberOfWorker;
oServiceOrderBE.r_TotalCost = data.EntityserviceOrder.r_TotalCost;
oServiceOrderBE.d_DeliveryDate = data.EntityserviceOrder.d_DeliveryDate;
oServiceOrderBE.i_ServiceOrderStatusId = data.EntityserviceOrder.i_ServiceOrderStatusId;
oServiceOrderBE.i_LineaCreditoId = data.EntityserviceOrder.i_LineaCreditoId;
oServiceOrderBE.i_MostrarPrecio = data.EntityserviceOrder.i_MostrarPrecio;
oServiceOrderBE.i_EsProtocoloEspecial = data.EntityserviceOrder.i_EsProtocoloEspecial;
List <ServiceOrderDetailBE> ListServiceOrderDetailBE = new List <ServiceOrderDetailBE>();
var iter = 0;
foreach (var obj in data.ListEntityServiceOrder)
{
iter++;
ProtocolList _prot = new ProtocolList();
_prot.v_ProtocolId = obj.v_ProtocolId;
bool existName = true;
while (existName)
{
_prot.v_Name = data.EntityserviceOrder.v_OrganizationName + "-" + obj.v_ProtocolTypeName + "-" + iter + "-" + obj.v_GesoName;
MessageCustom resultVerify = ProtocolDal.VerifyExistsProtocol(_prot.v_Name);
if (resultVerify.Id == null)
{
existName = false;
}
else
{
iter++;
}
}
_prot.v_CustomerOrganizationId = data.EntityserviceOrder.v_OrganizationId + "|" + data.EntityserviceOrder.v_LocationId;
_prot.v_IntermediaryOrganization = data.EntityserviceOrder.v_OrganizationId + "|" + data.EntityserviceOrder.v_LocationId;
_prot.v_WorkingOrganizationId = data.EntityserviceOrder.v_OrganizationId + "|" + data.EntityserviceOrder.v_LocationId;
_prot.v_Geso = obj.v_GroupOccupationId;
_prot.i_IsActive = 1;
_prot.i_EsoTypeId = obj.i_ProtocolType;
_prot.i_ServiceTypeId = 1; //Empresarial
_prot.i_MasterServiceId = 2; //Examen de salud ocupacional
_prot.ListComponents = obj.ProtocolComponents;
var result = ProtocolBL.SaveProtocols(_prot, userId, nodeId);
if (result.Error)
{
throw new Exception(result.Message);
}
obj.v_ProtocolId = result.Id;
ServiceOrderDetailBE oServiceOrderDetailBE = new ServiceOrderDetailBE();
oServiceOrderDetailBE.v_ServiceOrderDetailId = obj.v_ServiceOrderDetailId;
oServiceOrderDetailBE.v_ServiceOrderId = obj.v_ServiceOrderId;
oServiceOrderDetailBE.v_ProtocolId = obj.v_ProtocolId;
oServiceOrderDetailBE.r_ProtocolPrice = obj.r_ProtocolPrice;
oServiceOrderDetailBE.i_NumberOfWorkerProtocol = obj.i_NumberOfWorkerProtocol;
oServiceOrderDetailBE.r_Total = obj.r_Total;
ListServiceOrderDetailBE.Add(oServiceOrderDetailBE);
}
#endregion
string ServiceOrderId = ServiceOrderDal.AddServiceOrder(oServiceOrderBE, ListServiceOrderDetailBE, userId, nodeId);
msg.Error = false;
msg.Id = ServiceOrderId ?? throw new Exception("Sucedió un error al grabar las ordenes, por favor actualice y vuelva a intentar.");
msg.Message = "Se guardó correctamente.";
msg.Status = (int)HttpStatusCode.Created;
ts.Complete();
return(msg);
}
}
catch (Exception ex)
{
msg.Message = ex.Message;
msg.Error = true;
msg.Status = (int)HttpStatusCode.Conflict;
return(msg);
}
}
public string CreateService(ServiceCustom data, int nodeId, int userId)
{
string serviceId = "";
List <ProtocolComponentCustom> ListProtocolComponent = new ProtocolComponentDal().GetProtocolComponents(data.ProtocolId);
if (data.FechaCalendario == null)
{
data.ProtocolId = new ProtocolBL().ReturnOrDuplicateProtocol(data, nodeId, userId, ListProtocolComponent);
}
serviceId = new ServiceDal().CreateService(data, nodeId, userId);
if (serviceId == null)
{
return(null);
}
data.ServiceId = serviceId;
if (data.MasterServiceTypeId == (int)MasterServiceType.Empresarial)
{
bool result = new ServiceComponentDal().AddServiceComponent(ListProtocolComponent, data, nodeId, userId);
if (!result)
{
return(null);
}
}
else
{
bool result = new ServiceComponentDal().AddServiceComponent(ListProtocolComponent, data, nodeId, userId);
if (!result)
{
return(null);
}
}
CalendarDto _CalendarDto = new CalendarDto();
_CalendarDto.v_PersonId = data.PersonId;
_CalendarDto.v_ServiceId = data.ServiceId;
_CalendarDto.v_PersonId = data.PersonId;
_CalendarDto.d_DateTimeCalendar = data.FechaCalendario == null ? DateTime.Now : data.FechaCalendario;
_CalendarDto.d_CircuitStartDate = data.FechaCalendario == null ? DateTime.Now : data.FechaCalendario;
_CalendarDto.d_EntryTimeCM = data.FechaCalendario == null ? DateTime.Now : data.FechaCalendario;
_CalendarDto.i_ServiceTypeId = data.MasterServiceTypeId;
_CalendarDto.i_CalendarStatusId = 1;
_CalendarDto.i_ServiceId = data.MasterServiceId;
_CalendarDto.v_ProtocolId = data.ProtocolId;
_CalendarDto.i_NewContinuationId = 1;
_CalendarDto.i_LineStatusId = 1;
_CalendarDto.i_IsVipId = 0;
bool calendarResult = new CalendarDal().AddCalendar(_CalendarDto, nodeId, userId);
if (!calendarResult)
{
return(null);
}
int tipoEmpresa = ProtocolDal.ObtenerTipoEmpresaByProtocol(data.ProtocolId);
if ((data.MasterServiceId == 19 || data.MasterServiceId == 10 || data.MasterServiceId == 15 || data.MasterServiceId == 16 || data.MasterServiceId == 17 || data.MasterServiceId == 18 || data.MasterServiceId == 19) && tipoEmpresa == 4)
{
bool resultHospi = new HospitalizacionDal().AddHospitalizacion(data.PersonId, data.ServiceId, nodeId, userId);
if (!resultHospi)
{
return(null);
}
}
return(serviceId);
}
