public warehouseDto GetWarehouse(ref OperationResult pobjOperationResult, string pstrWarehouseId) { //mon.IsActive = true; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); warehouseDto objDtoEntity = null; var objEntity = (from a in dbContext.warehouse where a.v_WarehouseId == pstrWarehouseId select a).FirstOrDefault(); if (objEntity != null) { objDtoEntity = warehouseAssembler.ToDTO(objEntity); } pobjOperationResult.Success = 1; return(objDtoEntity); } catch (Exception ex) { pobjOperationResult.Success = 0; pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex); return(null); } }
public void AddWarehouse(ref OperationResult pobjOperationResult, warehouseDto pobjDtoEntity, List <string> ClientSession) { //mon.IsActive = true; string NewId = "(No generado)"; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); warehouse objEntity = warehouseAssembler.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, 2), "WW"); objEntity.v_WarehouseId = NewId; //int SecuentialId = Utils.GetNextSecuentialId(1, 2); //objEntity.v_WarehouseId = SecuentialId.ToString(); dbContext.AddTowarehouse(objEntity); dbContext.SaveChanges(); pobjOperationResult.Success = 1; // Llenar entidad Log LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "ALMACÉN", "v_WarehouseId=" + 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, "ALMACÉN", "v_WarehouseId=" + NewId.ToString(), Success.Failed, ex.Message); return; } }
public void UpdateWarehouse(ref OperationResult pobjOperationResult, warehouseDto pobjDtoEntity, List <string> ClientSession) { //mon.IsActive = true; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); // Obtener la entidad fuente var objEntitySource = (from a in dbContext.warehouse where a.v_WarehouseId == pobjDtoEntity.v_WarehouseId select a).FirstOrDefault(); // Crear la entidad con los datos actualizados pobjDtoEntity.d_UpdateDate = DateTime.Now; pobjDtoEntity.i_UpdateUserId = Int32.Parse(ClientSession[2]); warehouse objEntity = warehouseAssembler.ToEntity(pobjDtoEntity); // Copiar los valores desde la entidad actualizada a la Entidad Fuente dbContext.warehouse.ApplyCurrentValues(objEntity); // Guardar los cambios dbContext.SaveChanges(); pobjOperationResult.Success = 1; // Llenar entidad Log LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "ALMACÉN", "v_WarehouseId=" + objEntity.v_WarehouseId.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, "ALMACÉN", "v_WarehouseId=" + pobjDtoEntity.v_WarehouseId.ToString(), Success.Failed, ex.Message); return; } }
private void LoadData() { OperationResult objOperationResult = new OperationResult(); Utils.LoadDropDownList(ddlProductId, "Value1", "Id", BLL.Utils.GetProductWarehouse(ref objOperationResult, "Id==" + "\"" + -1 + "\""), DropDownListAction.Select); // el combo producto se carga vacio hasta que se seleccione un almacén de origen. lblNodeSource.Text = Globals.ClientSession.v_CurrentExecutionNodeName; dtpDate.CustomFormat = "dd/MM/yyyy"; if (_Mode == "New") { _booAlreadySaved = false; //Source Utils.LoadDropDownList(ddlOrganizationLocationSourceId, "Value1", "Id", BLL.Utils.GetJoinOrganizationAndLocationNotInRestricted(ref objOperationResult, Globals.ClientSession.i_CurrentExecutionNodeId), DropDownListAction.Select); Utils.LoadDropDownList(ddlWarehouseSourceId, "Value1", "Id", BLL.Utils.GetWarehouseNotInRestricted(ref objOperationResult, Globals.ClientSession.i_CurrentExecutionNodeId, "-1", "-1"), DropDownListAction.Select); //Destination Utils.LoadDropDownList(ddlNodeDestinationId, "Value1", "Id", BLL.Utils.GetAllNodeForCombo(ref objOperationResult), DropDownListAction.Select); if (rbLocal.Checked == true) { ddlNodeDestinationId.Enabled = false; ddlNodeDestinationId.SelectedValue = Globals.ClientSession.i_CurrentExecutionNodeId.ToString(); } else { ddlNodeDestinationId.Enabled = true; } Utils.LoadDropDownList(ddlOrganizationLocationDestinationId, "Value1", "Id", BLL.Utils.GetJoinOrganizationAndLocationNotInRestricted(ref objOperationResult, Globals.ClientSession.i_CurrentExecutionNodeId), DropDownListAction.Select); Utils.LoadDropDownList(ddlWarehouseDestinationId, "Value1", "Id", BLL.Utils.GetWarehouseNotInRestricted(ref objOperationResult, Globals.ClientSession.i_CurrentExecutionNodeId, "-1", "-1"), DropDownListAction.Select); txtIsProcessed.Text = "NO"; txtDocReference.Text = ""; dtpDate.Value = DateTime.Now.Date; } else if (_Mode == "Edit") { // Get the Entity Data warehouseDto objwarehouseDto = new warehouseDto(); WarehouseBL objWarehouseBL = new WarehouseBL(); movementDto objMovementDto = new movementDto(); MovementBL objMovementBL = new MovementBL(); movementdetailDto objmovementdetailDto = new movementdetailDto(); supplierDto objSupplierDto = new supplierDto(); SupplierBL objSupplierBL = new SupplierBL(); nodeorganizationlocationwarehouseprofileDto objnodeorganizationlocationwarehouseprofileDto = new nodeorganizationlocationwarehouseprofileDto(); NodeBL objNodeBL = new NodeBL(); _booAlreadySaved = true; string pstrFilterExpression = null; objMovementDto = objMovementBL.GetMovement(ref objOperationResult, _MovementId); //Source Utils.LoadDropDownList(ddlOrganizationLocationSourceId, "Value1", "Id", BLL.Utils.GetJoinOrganizationAndLocationNotInRestricted(ref objOperationResult, Globals.ClientSession.i_CurrentExecutionNodeId), DropDownListAction.Select); objwarehouseDto = objWarehouseBL.GetWarehouse(ref objOperationResult, objMovementDto.v_WarehouseId); ddlOrganizationLocationSourceId.SelectedValue = Globals.ClientSession.i_CurrentExecutionNodeId + "|" + objwarehouseDto.v_OrganizationId + "|" + objwarehouseDto.v_LocationId; ddlWarehouseSourceId.SelectedValue = objwarehouseDto.v_WarehouseId; //Destination Utils.LoadDropDownList(ddlNodeDestinationId, "Value1", "Id", BLL.Utils.GetAllNodeForCombo(ref objOperationResult), DropDownListAction.Select); objnodeorganizationlocationwarehouseprofileDto = objNodeBL.GetNodeOrganizationLocationWarehouseProfile(ref objOperationResult, objMovementDto.v_RemoteWarehouseId); if (Globals.ClientSession.i_CurrentExecutionNodeId.ToString() == objnodeorganizationlocationwarehouseprofileDto.i_NodeId.ToString()) { ddlNodeDestinationId.Enabled = false; rbLocal.Checked = true; } else { ddlNodeDestinationId.Enabled = true; rbRemote.Checked = true; } ddlNodeDestinationId.SelectedValue = objnodeorganizationlocationwarehouseprofileDto.i_NodeId.ToString(); ddlOrganizationLocationDestinationId.SelectedValue = objnodeorganizationlocationwarehouseprofileDto.i_NodeId.ToString() + "|" + objnodeorganizationlocationwarehouseprofileDto.v_OrganizationId + "|" + objnodeorganizationlocationwarehouseprofileDto.v_LocationId; ddlWarehouseDestinationId.SelectedValue = objMovementDto.v_RemoteWarehouseId; txtDocReference.Text = objMovementDto.v_ReferenceDocument; dtpDate.Value = (DateTime)objMovementDto.d_Date; if (objMovementDto.i_IsLocallyProcessed == (int)Common.SiNo.NO) { txtIsProcessed.Text = "NO"; btnSaveRefresh.Enabled = true; btnConfirmProcess.Enabled = true; btnDiscardProcess.Enabled = true; } else { txtIsProcessed.Text = "SI"; btnSaveRefresh.Enabled = false; btnConfirmProcess.Enabled = false; btnDiscardProcess.Enabled = false; } pstrFilterExpression = "v_MovementId==" + "\"" + objMovementDto.v_MovementId + "\"" + "&&" + "v_WarehouseId==" + "\"" + objMovementDto.v_WarehouseId + "\""; _TempMovementDetailList = objMovementBL.GetMovementDeatilPagedAndFiltered(ref objOperationResult, 0, null, "", pstrFilterExpression); lblRecordCount.Text = string.Format("Se encontraron {0} registros.", _TempMovementDetailList.Count()); grdData.DataSource = _TempMovementDetailList; } }