public static MessageCustom SaveOrganization(OrganizationBE data, int userId, int nodeId) { MessageCustom msg = new MessageCustom(); try { using (var ts = new TransactionScope()) { data.i_OrganizationTypeId = 1; string result = OrganizationDal.SaveOrganization(data, userId, nodeId); if (result == null) { msg.Error = true; msg.Message = "Sucedió un error al guardar la empresa, por favor actualiza y vuelva a intentar"; msg.Status = (int)HttpStatusCode.Conflict; } else { msg.Error = false; msg.Message = "Se guardó correctamente."; msg.Status = (int)HttpStatusCode.Created; msg.Id = result; } ts.Complete(); return(msg); } } catch (Exception ex) { return(msg); } }
public int InsertUpdateOrganizationLocation(OrganizationLocation location) { int id = 0; id = OrganizationDal.InsertUpdateOrganizationLocation(location); return(id); }
public List <OrganizationLocation> GetLocationsAgainstOrganization(int orgId, SearchCriteria criteria, out int TotalRecords) { List <OrganizationLocation> locations = new List <OrganizationLocation>(); locations = OrganizationDal.GetLocationsAgainstOrganization(orgId, criteria, out TotalRecords); return(locations); }
private void OnFormLoad(object sender, EventArgs e) { orgDal = new OrganizationDal(); if (orgEntity != null) { this.Text = "组织-修改"; txtCode.Enabled = false; layoutControlItem3.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; ShowEditInfo(orgEntity); isNew = false; } }
private void OnFormLoad(object sender, EventArgs e) { ImageCollection ic = AppResource.LoadToolImages(); barManager1.Images = ic; toolAdd.ImageIndex = (int)AppResource.EIcons.add; toolEdit.ImageIndex = (int)AppResource.EIcons.edit; toolDel.ImageIndex = (int)AppResource.EIcons.delete; toolRefresh.ImageIndex = (int)AppResource.EIcons.refresh; toolSearch.ImageIndex = (int)AppResource.EIcons.search; OrgDal = new OrganizationDal(); WarehouseDal = new WarehouseDal(); ReLoad(); }
// private dynamic GetOrgTree() { try { SysLogBll.Create("组织单位", "获取组织单位树形数据2", UserName); string OrgCode = orgDal.GetHighestOrgCode(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("["); Organization modelData = new OrganizationDal().GetModel(OrgCode); stringBuilder.Append("{\"id\":\"" + modelData.OrgCode + "\", \"text\":\"" + modelData.OrgShortName + "\",\"children\":[" + AddNodes(modelData.OrgCode) + "]}"); stringBuilder.Append("]"); return(stringBuilder.ToString()); } catch (Exception ex) { SystemErrorPlug.ErrorRecord("时间:[" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "]类名:[" + this.GetType().Name + "],行号:[" + Component.GetLineNum().ToString() + "行],错误信息:[" + ex.Message + "]"); return(string.Empty); } }
private List <OrganizationSystemUser> GetOrganization(string systemUserByOrganizationId) { var array = systemUserByOrganizationId.Split(','); var listIds = new List <string>(array); var organizations = new OrganizationDal().GetOrganizationByIds(listIds); var list = new List <OrganizationSystemUser>(); foreach (var item in array) { var oOrganizationSystemUser = new OrganizationSystemUser(); var org = organizations.Find(p => p.v_OrganizationId == item.Trim()); oOrganizationSystemUser.Name = org.v_Name; oOrganizationSystemUser.OrganizationId = org.v_OrganizationId; oOrganizationSystemUser.WareHouses = new OrganizationDal().GetWareHouses(org.v_OrganizationId); list.Add(oOrganizationSystemUser); } return(list); }
public OrganizationBll() { dal = new OrganizationDal(); }
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 OrganizationLocation GetLocationsById(int orgId, int locationId) { return(OrganizationDal.GetLocationsById(orgId, locationId)); }
public MessageCustom AddSystemUserExternal(PersonDto pobjPerson, ProfessionalBE pobjProfessional, SystemUserDto pobjSystemUser, List <ProtocolSystemUserBE> ListProtocolSystemUser, int userId, int nodeId) { //mon.IsActive = true; string newId = string.Empty; int systemUserId = -1; MessageCustom msg = new MessageCustom(); OperationResult objOperationResult = new OperationResult(); try { using (var ts = new TransactionScope()) { #region Validations // Validar el DNI de la persona DatabaseContext dbContext = new DatabaseContext(); if (pobjPerson != null) { if (pobjSystemUser.i_SystemUserId == -1) //-1 es nuevo { // Grabar Persona var _recordCount1 = GetPersonCount(pobjPerson.v_DocNumber); if (_recordCount1 != 0) { throw new Exception("El número de documento <strong>" + pobjPerson.v_DocNumber + "</strong> ya se encuentra registrado. Por favor ingrese otro número de documento."); } pobjPerson.d_InsertDate = DateTime.Now; pobjPerson.i_InsertUserId = userId; pobjPerson.i_IsDeleted = 0; // Autogeneramos el Pk de la tabla newId = new Common.Utils().GetPrimaryKey(nodeId, 8, "PP"); pobjPerson.v_PersonId = newId; dbContext.Person.Add(pobjPerson); dbContext.SaveChanges(); // Grabar Profesional pobjProfessional.v_PersonId = pobjPerson.v_PersonId; bool resultProf = AddProfessional(pobjProfessional, userId, nodeId); if (!resultProf) { throw new Exception("Sucedió un error al guardar el profesional, por favor actualice la pagina y vuelva a intentar"); } } else {//actualiza var objPerson = dbContext.Person.Where(x => x.v_PersonId == pobjPerson.v_PersonId).FirstOrDefault(); objPerson.v_FirstName = pobjPerson.v_FirstName; objPerson.v_FirstLastName = pobjPerson.v_FirstLastName; objPerson.v_SecondLastName = pobjPerson.v_SecondLastName; objPerson.i_DocTypeId = pobjPerson.i_DocTypeId; objPerson.v_DocNumber = pobjPerson.v_DocNumber; objPerson.i_SexTypeId = pobjPerson.i_SexTypeId; objPerson.i_MaritalStatusId = pobjPerson.i_MaritalStatusId; objPerson.i_LevelOfId = pobjPerson.i_LevelOfId; objPerson.v_Mail = pobjPerson.v_Mail; objPerson.v_BirthPlace = pobjPerson.v_BirthPlace; objPerson.v_TelephoneNumber = pobjPerson.v_TelephoneNumber; objPerson.d_Birthdate = pobjPerson.d_Birthdate; objPerson.v_AdressLocation = pobjPerson.v_AdressLocation; objPerson.i_UpdateUserId = userId; objPerson.d_UpdateDate = DateTime.Now; dbContext.SaveChanges(); var objProfessional = dbContext.Professional.Where(x => x.v_PersonId == pobjPerson.v_PersonId).FirstOrDefault(); objProfessional.i_ProfessionId = pobjProfessional.i_ProfessionId; objProfessional.v_ProfessionalCode = pobjProfessional.v_ProfessionalCode; objProfessional.v_ProfessionalInformation = pobjProfessional.v_ProfessionalInformation; objProfessional.i_UpdateUserId = userId; objProfessional.d_UpdateDate = DateTime.Now; dbContext.SaveChanges(); } } // Validar existencia de UserName en la BD if (pobjSystemUser != null) { if (pobjSystemUser.i_SystemUserId == -1) { OperationResult objOperationResult7 = new OperationResult(); var _recordCount2 = new SecurityDal().GetSystemUserCount(pobjSystemUser.v_UserName); if (_recordCount2 != 0) { throw new Exception("El nombre de usuario <strong>" + pobjSystemUser.v_UserName + "</strong> ya se encuentra registrado.<br> Por favor ingrese otro nombre de usuario."); } } } #endregion // Grabar Usuario if (pobjSystemUser != null) { if (pobjSystemUser.i_SystemUserId == -1)//-1 es nuevo { pobjSystemUser.v_PersonId = pobjPerson.v_PersonId; pobjSystemUser.i_SystemUserTypeId = (int)SystemUserTypeId.External; pobjSystemUser.i_RolVentaId = -1; pobjSystemUser.v_SystemUserByOrganizationId = ListProtocolSystemUser != null?OrganizationDal.GetOrganizationIdByProtocolId(ListProtocolSystemUser[0].v_ProtocolId) : ""; systemUserId = new SecurityDal().AddSystemUSer(pobjSystemUser, userId, nodeId); if (systemUserId == -1) { throw new Exception("Sucedió un error al guardar el usuario, por favor actualice la pagina y vuelva a intentar"); } } else {//actualiza var objUser = dbContext.SystemUser.Where(x => x.i_SystemUserId == pobjSystemUser.i_SystemUserId).FirstOrDefault(); objUser.v_UserName = pobjSystemUser.v_UserName; objUser.v_Password = pobjSystemUser.v_Password; objUser.d_ExpireDate = pobjSystemUser.d_ExpireDate; objUser.i_UpdateUserId = userId; objUser.d_UpdateDate = DateTime.Now; systemUserId = objUser.i_SystemUserId; dbContext.SaveChanges(); } } #region GRABA ProtocolSystemUser if (ListProtocolSystemUser != null) { if (pobjSystemUser.i_SystemUserId == -1)//-1 es nuevo { bool resultProt = new ProtocolSystemUserDal().AddProtocolSystemUser(ListProtocolSystemUser, systemUserId, userId, nodeId); if (!resultProt) { throw new Exception("Sucedió un error al guardar los protocolos del usuario, por favor actualice la pagina y vuelva a intentar"); } } else //actualiza { bool deletedProt = ProtocolSystemUserDal.DeletedProtocolSystemUser(systemUserId, userId); if (!deletedProt) { throw new Exception("Sucedió un error al actualizar los protocolos del usuario, por favor actualice la pagina y vuelva a intentar"); } bool resultProt = new ProtocolSystemUserDal().AddProtocolSystemUser(ListProtocolSystemUser, systemUserId, userId, nodeId); if (!resultProt) { throw new Exception("Sucedió un error al actualizar los protocolos del usuario, por favor actualice la pagina y vuelva a intentar"); } } } #endregion msg.Error = false; msg.Status = (int)HttpStatusCode.Created; msg.Message = "Se guardó correctamente"; ts.Complete(); } return(msg); } catch (Exception ex) { msg.Error = true; msg.Status = (int)HttpStatusCode.BadRequest; msg.Message = ex.Message; return(msg); } }