public void AddOccupation(ref OperationResult pobjOperationResult, occupationDto pobjDtoEntity, List <string> ClientSession)
{
//mon.IsActive = true;
string NewId = "(No generado)";
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
occupation objEntity = occupationAssembler.ToEntity(pobjDtoEntity);
objEntity.d_InsertDate = DateTime.Now;
objEntity.i_InsertUserId = Int32.Parse(ClientSession[2]);
objEntity.i_IsDeleted = 0;
// Autogeneramos el Pk de la tabla
int intNodeId = int.Parse(ClientSession[0]);
NewId = Common.Utils.GetNewId(intNodeId, Utils.GetNextSecuentialId(intNodeId, 12), "OE");
objEntity.v_OccupationId = NewId;
dbContext.AddTooccupation(objEntity);
dbContext.SaveChanges();
pobjOperationResult.Success = 1;
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "GES", "v_OccupationId=" + NewId.ToString(), Success.Ok, null);
return;
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "GES", "v_OccupationId=" + NewId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
return;
}
}
public occupationDto GetOccupation(ref OperationResult pobjOperationResult, string pstrOccupationId)
{
//mon.IsActive = true;
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
occupationDto objDtoEntity = null;
var objEntity = (from a in dbContext.occupation
where a.v_OccupationId == pstrOccupationId
select a).FirstOrDefault();
if (objEntity != null)
{
objDtoEntity = occupationAssembler.ToDTO(objEntity);
}
pobjOperationResult.Success = 1;
return(objDtoEntity);
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
return(null);
}
}
public void UpdateOccupation(ref OperationResult pobjOperationResult, occupationDto pobjDtoEntity, List <string> ClientSession)
{
//mon.IsActive = true;
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
// Obtener la entidad fuente
var objEntitySource = (from a in dbContext.occupation
where a.v_OccupationId == pobjDtoEntity.v_OccupationId
select a).FirstOrDefault();
// Crear la entidad con los datos actualizados
pobjDtoEntity.d_UpdateDate = DateTime.Now;
pobjDtoEntity.i_UpdateUserId = Int32.Parse(ClientSession[2]);
occupation objEntity = occupationAssembler.ToEntity(pobjDtoEntity);
// Copiar los valores desde la entidad actualizada a la Entidad Fuente
dbContext.occupation.ApplyCurrentValues(objEntity);
// Guardar los cambios
dbContext.SaveChanges();
pobjOperationResult.Success = 1;
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "PUESTO", "v_OccupationId=" + objEntity.v_OccupationId.ToString(), Success.Ok, null);
return;
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "PUESTO", "v_OccupationId=" + pobjDtoEntity.v_OccupationId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
return;
}
}
