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