public groupoccupationDto GetFirstGroupOccupationByLocationId(ref OperationResult pobjOperationResult, string locationId)
{
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
groupoccupationDto objDtoEntity = null;
var objEntity = (from a in dbContext.groupoccupation
where a.v_LocationId == locationId
select a).FirstOrDefault();
if (objEntity != null)
{
objDtoEntity = groupoccupationAssembler.ToDTO(objEntity);
}
pobjOperationResult.Success = 1;
return(objDtoEntity);
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
return(null);
}
}
public void AddGroupOccupation(ref OperationResult pobjOperationResult, groupoccupationDto pobjDtoEntity, List <string> ClientSession)
{
//mon.IsActive = true;
string NewId = "(No generado)";
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
groupoccupation objEntity = groupoccupationAssembler.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, 13), "OG");;
objEntity.v_GroupOccupationId = NewId;
dbContext.AddTogroupoccupation(objEntity);
dbContext.SaveChanges();
pobjOperationResult.Success = 1;
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "GESO", "v_GroupOccupationId=" + 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, "GESO", "v_GroupOccupationId=" + NewId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
return;
}
}
public void UpdateGroupOccupation(ref OperationResult pobjOperationResult, groupoccupationDto pobjDtoEntity, List <string> ClientSession)
{
//mon.IsActive = true;
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
// Obtener la entidad fuente
var objEntitySource = (from a in dbContext.groupoccupation
where a.v_GroupOccupationId == pobjDtoEntity.v_GroupOccupationId
select a).FirstOrDefault();
// Crear la entidad con los datos actualizados
pobjDtoEntity.d_UpdateDate = DateTime.Now;
pobjDtoEntity.i_UpdateUserId = Int32.Parse(ClientSession[2]);
groupoccupation objEntity = groupoccupationAssembler.ToEntity(pobjDtoEntity);
// Copiar los valores desde la entidad actualizada a la Entidad Fuente
dbContext.groupoccupation.ApplyCurrentValues(objEntity);
// Guardar los cambios
dbContext.SaveChanges();
pobjOperationResult.Success = 1;
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "GESO", "v_GroupOccupationId=" + objEntity.v_GroupOccupationId.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, "GESO", "v_GroupOccupationId=" + pobjDtoEntity.v_GroupOccupationId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
return;
}
}
protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
string Mode = Request.QueryString["Mode"].ToString();
OperationResult objOperationResult = new OperationResult();
if (Mode == "New")
{
// Create the entity
groupoccupationDto objEntity = new groupoccupationDto();
// Populate the entity
objEntity.v_LocationId = ddlLocation.SelectedValue.ToString();
objEntity.v_Name = txtSede.Text;
// Save the data
oOrganizationBL.AddGroupOccupation(ref objOperationResult, objEntity, ((ClientSession)Session["objClientSession"]).GetAsList());
if (txtSede2.Text.Trim() != "")
{
objEntity = new groupoccupationDto();
// Populate the entity
objEntity.v_LocationId = ddlLocation.SelectedValue.ToString();
objEntity.v_Name = txtSede2.Text;
// Save the data
oOrganizationBL.AddGroupOccupation(ref objOperationResult, objEntity, ((ClientSession)Session["objClientSession"]).GetAsList());
}
if (txtSede3.Text.Trim() != "")
{
objEntity = new groupoccupationDto();
// Populate the entity
objEntity.v_LocationId = ddlLocation.SelectedValue.ToString();
objEntity.v_Name = txtSede3.Text;
// Save the data
oOrganizationBL.AddGroupOccupation(ref objOperationResult, objEntity, ((ClientSession)Session["objClientSession"]).GetAsList());
}
if (txtSede4.Text.Trim() != "")
{
objEntity = new groupoccupationDto();
// Populate the entity
objEntity.v_LocationId = ddlLocation.SelectedValue.ToString();
objEntity.v_Name = txtSede4.Text;
// Save the data
oOrganizationBL.AddGroupOccupation(ref objOperationResult, objEntity, ((ClientSession)Session["objClientSession"]).GetAsList());
}
if (txtSede5.Text.Trim() != "")
{
objEntity = new groupoccupationDto();
// Populate the entity
objEntity.v_LocationId = ddlLocation.SelectedValue.ToString();
objEntity.v_Name = txtSede5.Text;
// Save the data
oOrganizationBL.AddGroupOccupation(ref objOperationResult, objEntity, ((ClientSession)Session["objClientSession"]).GetAsList());
}
}
else if (Mode == "Edit")
{
groupoccupationDto objEntity = new groupoccupationDto();
// Populate the entity
objEntity.v_GroupOccupationId = Session["v_GroupOccupationId"].ToString();
objEntity.v_LocationId = Session["v_LocationId"].ToString();
objEntity.v_Name = txtSede.Text;
oOrganizationBL.UpdateGroupOccupation(ref objOperationResult, objEntity, ((ClientSession)Session["objClientSession"]).GetAsList());
}
//Analizar el resultado de la operación
if (objOperationResult.Success == 1) // Operación sin error
{
// Cerrar página actual y hacer postback en el padre para actualizar
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
else // Operación con error
{
Alert.ShowInTop("Error en operación:" + System.Environment.NewLine + objOperationResult.ExceptionMessage);
// Se queda en el formulario.
}
}
