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. } }