private void btnOK_Click(object sender, EventArgs e) { SystemParameterBL _objProxy = new SystemParameterBL(); OperationResult objOperationResult = new OperationResult(); systemparameterDto objEntity = new systemparameterDto(); // Populate the entity objEntity.i_GroupId = 146; objEntity.i_ParameterId = _objProxy.GetSystemParameterMaxParameterId(146); ParameterId = objEntity.i_ParameterId; objEntity.v_Value1 = txtPeligro.Text; EppName = txtPeligro.Text; objEntity.i_Sort = null; objEntity.v_Value2 = ""; objEntity.v_Field = ""; objEntity.i_ParentParameterId = 16; // Save the data _objProxy.AddSystemParameter(ref objOperationResult, objEntity, Globals.ClientSession.GetAsList()); this.Close(); }
public void AddSystemParameter(ref OperationResult pobjOperationResult, systemparameterDto pobjDtoEntity, List <string> ClientSession) { //mon.IsActive = true; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); systemparameter objEntity = systemparameterAssembler.ToEntity(pobjDtoEntity); objEntity.d_InsertDate = DateTime.Now; objEntity.i_InsertUserId = Int32.Parse(ClientSession[2]); objEntity.i_IsDeleted = 0; dbContext.AddTosystemparameter(objEntity); dbContext.SaveChanges(); pobjOperationResult.Success = 1; // Llenar entidad Log LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "PARÁMETRO", "GroupId=" + objEntity.i_GroupId.ToString() + " / Descripción = " + objEntity.v_Value1, Success.Ok, null); return; } catch (Exception ex) { pobjOperationResult.Success = 0; pobjOperationResult.ExceptionMessage = ex.Message; // Llenar entidad Log LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "PARÁMETRO", "GroupId=" + pobjDtoEntity.i_GroupId.ToString() + " / Descripción = " + pobjDtoEntity.v_Value1, Success.Failed, ex.Message); return; } }
public systemparameterDto GetSystemParameter(ref OperationResult pobjOperationResult, int pintGroupId, int pintParameterId) { //mon.IsActive = true; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); systemparameterDto objDtoEntity = null; var objEntity = (from a in dbContext.systemparameter where a.i_GroupId == pintGroupId && a.i_ParameterId == pintParameterId select a).FirstOrDefault(); if (objEntity != null) { objDtoEntity = systemparameterAssembler.ToDTO(objEntity); } pobjOperationResult.Success = 1; return(objDtoEntity); } catch (Exception ex) { pobjOperationResult.Success = 0; pobjOperationResult.ExceptionMessage = ex.Message; return(null); } }
private void LoadData() { OperationResult objOperationResult = new OperationResult(); //Llenado de combos Utils UtilComboBox = new Utils(); string Mode = Request.QueryString["Mode"].ToString(); int GroupId = -1, ParameterId = -1; if (Request.QueryString["i_GroupId"] != null) { GroupId = int.Parse(Request.QueryString["i_GroupId"].ToString()); } if (Request.QueryString["i_ParameterId"] != null) { ParameterId = int.Parse(Request.QueryString["i_ParameterId"].ToString()); } ViewState["strFilterExpression"] = string.Format("i_GroupId={0} && i_IsDeleted==0", ParameterId); if (Mode == "Edit") { // Obtener el usuario autenticado int intUserPersonId = ((ClientSession)Session["objClientSession"]).i_SystemUserId; // Bloquear algunos campos txtParameterId.Enabled = false; txtDescription.Enabled = false; // Get the Entity Data systemparameterDto objEntity = _objBL.GetSystemParameter(ref objOperationResult, GroupId, ParameterId); // Save the entity on the session Session["objEntity"] = objEntity; // Show the data on the form txtParameterId.Text = objEntity.i_ParameterId.ToString(); txtDescription.Text = objEntity.v_Value1; BindGrid(); } }
public void UpdateSystemParameter(ref OperationResult pobjOperationResult, systemparameterDto pobjDtoEntity, List <string> ClientSession) { //mon.IsActive = true; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); // Obtener la entidad fuente var objEntitySource = (from a in dbContext.systemparameter where a.i_GroupId == pobjDtoEntity.i_GroupId && a.i_ParameterId == pobjDtoEntity.i_ParameterId select a).FirstOrDefault(); // Crear la entidad con los datos actualizados pobjDtoEntity.d_UpdateDate = DateTime.Now; pobjDtoEntity.i_UpdateUserId = Int32.Parse(ClientSession[2]); systemparameter objEntity = systemparameterAssembler.ToEntity(pobjDtoEntity); // Copiar los valores desde la entidad actualizada a la Entidad Fuente dbContext.systemparameter.ApplyCurrentValues(objEntity); // Guardar los cambios dbContext.SaveChanges(); pobjOperationResult.Success = 1; // Llenar entidad Log LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "PARÁMETRO", "GroupId=" + objEntity.i_GroupId.ToString() + " / Descripción = " + objEntity.v_Value1, Success.Ok, null); return; } catch (Exception ex) { pobjOperationResult.Success = 0; pobjOperationResult.ExceptionMessage = ex.Message; // Llenar entidad Log LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "PARÁMETRO", "GroupId=" + pobjDtoEntity.i_GroupId.ToString() + " / Descripción = " + pobjDtoEntity.v_Value1, Success.Failed, ex.Message); return; } }
private void LoadData() { OperationResult objOperationResult = new OperationResult(); //Llenado de combos Utils UtilComboBox = new Utils(); string Mode = Request.QueryString["Mode"].ToString(); int GroupId = -1, ParameterId = -1; if (Request.QueryString["i_GroupId"] != null) { GroupId = int.Parse(Request.QueryString["i_GroupId"].ToString()); } if (Request.QueryString["i_ParameterId"] != null) { ParameterId = int.Parse(Request.QueryString["i_ParameterId"].ToString()); } //Llenar combo ItemParameter Tree ddlParentParameterId.DataTextField = "Description"; ddlParentParameterId.DataValueField = "Id"; ddlParentParameterId.DataSimulateTreeLevelField = "Level"; ddlParentParameterId.DataEnableSelectField = "EnabledSelect"; List <DataForTreeViewSP> t = _objProxy.GetSystemParameterForComboTreeView(ref objOperationResult, GroupId).ToList(); ddlParentParameterId.DataSource = t; ddlParentParameterId.DataBind(); this.ddlParentParameterId.Items.Insert(0, new FineUI.ListItem("-- Seleccione --", "-1")); if (Mode == "New") { txtGroupId.Enabled = false; txtGroupId.Text = "0"; ddlParentParameterId.Enabled = false; // Autogenerar ID para el nuevo grupo var groupId = _objProxy.GetSystemParameterMaxGroupId(); txtGroupId.Text = groupId.ToString(); } else if (Mode == "Edit") { // Bloquear algunos campos txtGroupId.Enabled = false; txtParameterId.Enabled = false; ddlParentParameterId.Enabled = true; // Get the Entity Data systemparameterDto objEntity = _objProxy.GetSystemParameter(ref objOperationResult, GroupId, ParameterId); // Save the entity on the session Session["objEntity"] = objEntity; // Show the data on the form txtGroupId.Text = objEntity.i_GroupId.ToString(); txtParameterId.Text = objEntity.i_ParameterId.ToString(); txtDescription.Text = objEntity.v_Value1; if (objEntity.i_Sort.HasValue) { txtUserInterfaceOrder.Text = objEntity.i_Sort.Value.ToString(); } txtDescription2.Text = objEntity.v_Value2; txtField.Text = objEntity.v_Field; //Llenado de combos //Utils.LoadDropDownList(ddlParentGroupId, "Value1", "Id", _objProxy.GetSystemParameterForCombo(ref objOperationResult, 0), DropDownListAction.Select); //Utils.LoadDropDownList(ddlParentParameterId, "Value1", "Id", _objProxy.GetSystemParameterForCombo(ref objOperationResult, (int)objEntity.i_ParentGroupId), DropDownListAction.Select); //ddlParentGroupId.SelectedValue = objEntity.i_ParentGroupId.ToString(); ddlParentParameterId.SelectedValue = objEntity.i_ParentParameterId.ToString(); txtDescription2.Focus(true); if (GroupId == 0) { ddlParentParameterId.Enabled = false; } } if (Mode == "NewChildren") { txtGroupId.Text = GroupId.ToString(); txtGroupId.Enabled = false; // Autogenerar ID para el nuevo parametro var paramId = _objProxy.GetSystemParameterMaxParameterId(GroupId); txtParameterId.Text = paramId.ToString(); //txtParameterId.Enabled = false; txtUserInterfaceOrder.Focus(); } }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { string Mode = Request.QueryString["Mode"].ToString(); OperationResult objOperationResult = new OperationResult(); if (Mode == "New") { // Create the entity systemparameterDto objEntity = new systemparameterDto(); // Populate the entity objEntity.i_GroupId = int.Parse(txtGroupId.Text.Trim()); objEntity.i_ParameterId = int.Parse(txtParameterId.Text.Trim()); objEntity.v_Value1 = txtDescription.Text.Trim().ToUpper(); if (txtUserInterfaceOrder.Text == "") { objEntity.i_Sort = null; } else { objEntity.i_Sort = int.Parse(txtUserInterfaceOrder.Text.Trim()); } objEntity.v_Value2 = txtDescription2.Text.Trim().ToUpper(); objEntity.v_Field = txtField.Text.Trim().ToUpper(); //objEntity.i_ParentGroupId = string.IsNullOrEmpty(ddlParentGroupId.SelectedValue) ? (Int32?)null : Int32.Parse(ddlParentGroupId.SelectedValue); objEntity.i_ParentParameterId = string.IsNullOrEmpty(ddlParentParameterId.SelectedValue) ? (Int32?)null : Int32.Parse(ddlParentParameterId.SelectedValue); // Obtener el usuario autenticado int intUserPersonId = ((ClientSession)Session["objClientSession"]).i_SystemUserId; if (_objProxy.GetSystemParameter(ref objOperationResult, objEntity.i_GroupId, objEntity.i_ParameterId) != null) { Alert.Show("¡ La clave primaria ya existe!", MessageBoxIcon.Warning); return; } else { // Save the data _objProxy.AddSystemParameter(ref objOperationResult, objEntity, ((ClientSession)Session["objClientSession"]).GetAsList()); } } else if (Mode == "Edit") { // Obtener el usuario autenticado int intUserPersonId = ((ClientSession)Session["objClientSession"]).i_SystemUserId; // Get the entity from the session systemparameterDto objEntity = (systemparameterDto)Session["objEntity"]; // Populate the entity objEntity.i_GroupId = int.Parse(txtGroupId.Text.Trim()); objEntity.i_ParameterId = int.Parse(txtParameterId.Text.Trim()); objEntity.v_Value1 = txtDescription.Text.Trim().ToUpper(); if (txtUserInterfaceOrder.Text == "") { objEntity.i_Sort = null; } else { objEntity.i_Sort = int.Parse(txtUserInterfaceOrder.Text.Trim()); } objEntity.v_Value2 = txtDescription2.Text.Trim().ToUpper(); objEntity.v_Field = txtField.Text.Trim().ToUpper(); //objEntity.i_ParentGroupId = string.IsNullOrEmpty(ddlParentGroupId.SelectedValue) ? (Int32?)null : Int32.Parse(ddlParentGroupId.SelectedValue); objEntity.i_ParentParameterId = string.IsNullOrEmpty(ddlParentParameterId.SelectedValue) ? (Int32?)null : Int32.Parse(ddlParentParameterId.SelectedValue); // Save the data _objProxy.UpdateSystemParameter(ref objOperationResult, objEntity, ((ClientSession)Session["objClientSession"]).GetAsList()); } else if (Mode == "NewChildren") { // Obtener el usuario autenticado int intUserPersonId = ((ClientSession)Session["objClientSession"]).i_SystemUserId; // Create the entity systemparameterDto objEntity = new systemparameterDto(); // Populate the entity objEntity.i_GroupId = int.Parse(txtGroupId.Text.Trim()); objEntity.i_ParameterId = int.Parse(txtParameterId.Text.Trim()); objEntity.v_Value1 = txtDescription.Text.Trim().ToUpper(); if (txtUserInterfaceOrder.Text == "") { objEntity.i_Sort = null; } else { objEntity.i_Sort = int.Parse(txtUserInterfaceOrder.Text.Trim()); } objEntity.v_Value2 = txtDescription2.Text.Trim().ToUpper(); objEntity.v_Field = txtField.Text.Trim().ToUpper(); //objEntity.i_ParentGroupId = string.IsNullOrEmpty(ddlParentGroupId.SelectedValue) ? (Int32?)null : Int32.Parse(ddlParentGroupId.SelectedValue); objEntity.i_ParentParameterId = string.IsNullOrEmpty(ddlParentParameterId.SelectedValue) ? (Int32?)null : Int32.Parse(ddlParentParameterId.SelectedValue); if (_objProxy.GetSystemParameter(ref objOperationResult, objEntity.i_GroupId, objEntity.i_ParameterId) != null) { Alert.Show("¡La clave primaria ya existe new children!", MessageBoxIcon.Warning); return; } else { // Save the data _objProxy.AddSystemParameter(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. } }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { OperationResult objOperationResult = new OperationResult(); string Mode = Request.QueryString["Mode"].ToString(); string PersonId = ""; if (Request.QueryString["v_PersonId"] != null) { PersonId = Request.QueryString["v_PersonId"].ToString(); } if (Mode == "New") { familymedicalantecedentsDto personmedicalhistoryDtoDto = new familymedicalantecedentsDto(); var x = ddlDx.SelectedText.ToString().Split('|'); //Obtener Disease systemparameterDto objEntity = _objBL.GetSystemParameter(ref objOperationResult, 149, int.Parse(x[1].ToString())); personmedicalhistoryDtoDto.v_PersonId = Session["PersonId"].ToString(); personmedicalhistoryDtoDto.i_TypeFamilyId = int.Parse(x[1].ToString()); if (ddlDx.SelectedValue == "80" || ddlDx.SelectedValue == "81" || ddlDx.SelectedValue == "82" || ddlDx.SelectedValue == "83" || ddlDx.SelectedValue == "84") { personmedicalhistoryDtoDto.v_DiseasesId = Session["OtroDxId"].ToString(); } else { personmedicalhistoryDtoDto.v_DiseasesId = objEntity.v_Value1; } personmedicalhistoryDtoDto.v_Comment = txtComentario.Text; _objHistoryBL.AddFamiliar(ref objOperationResult, personmedicalhistoryDtoDto, ((ClientSession)Session["objClientSession"]).GetAsList()); } else if (Mode == "Edit") { familymedicalantecedentsDto personmedicalhistoryDtoDto = (familymedicalantecedentsDto)Session["objEntity"]; var x = ddlDx.SelectedText.ToString().Split('|'); //Obtener Disease systemparameterDto objEntity = _objBL.GetSystemParameter(ref objOperationResult, 149, int.Parse(x[1].ToString())); //personmedicalhistoryDtoDto.v_DiseasesId = objEntity.v_Value1; if (ddlDx.SelectedValue == "80" || ddlDx.SelectedValue == "81" || ddlDx.SelectedValue == "82" || ddlDx.SelectedValue == "83" || ddlDx.SelectedValue == "84") { personmedicalhistoryDtoDto.v_DiseasesId = Session["OtroDxId"].ToString(); } else { personmedicalhistoryDtoDto.v_DiseasesId = objEntity.v_Value1; } personmedicalhistoryDtoDto.v_Comment = txtComentario.Text; personmedicalhistoryDtoDto.i_TypeFamilyId = int.Parse(x[1].ToString()); _objHistoryBL.UpdateFamiliar(ref objOperationResult, personmedicalhistoryDtoDto, ((ClientSession)Session["objClientSession"]).GetAsList()); } Session["GrupoFamiliarId"] = null; //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. } }