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