public productDto GetProduct(ref OperationResult pobjOperationResult, string v_ProductId)
{
//mon.IsActive = true;
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
productDto objDtoEntity = null;
var objEntity = (from a in dbContext.product
where a.v_ProductId == v_ProductId
select a).FirstOrDefault();
if (objEntity != null)
{
objDtoEntity = productAssembler.ToDTO(objEntity);
}
pobjOperationResult.Success = 1;
return(objDtoEntity);
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
return(null);
}
}
public HttpResponseMessage Delete(productDto p)
{
if (rblh.DeleteProduct(p))
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
public HttpResponseMessage Post([FromBody] productDto p)
{
if (rblh.AddProduct(p))
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
private void LoadData()
{
OperationResult objOperationResult = new OperationResult();
////Llenado de combos
Utils.LoadComboTreeBoxList(ddlCategoryId, BLL.Utils.GetDataHierarchyForComboTreeBox(ref objOperationResult, 103, null), DropDownListAction.Select);
Utils.LoadDropDownList(ddlMeasurementUnitId, "Value1", "Id", BLL.Utils.GetDataHierarchyForCombo(ref objOperationResult, 105, null), DropDownListAction.Select);
dtpExpirationDate.CustomFormat = "dd/MM/yyyy";
if (_Mode == "New")
{
// Additional logic here.
}
else if (_Mode == "Edit")
{
// Get the Entity Data
_productDto = _objBL.GetProduct(ref objOperationResult, _ProductId);
ComboTreeNode nodoABuscar = ddlCategoryId.AllNodes.First(x => x.Tag.ToString() == _productDto.i_CategoryId.ToString());
ddlCategoryId.SelectedNode = nodoABuscar;
txtName.Text = _productDto.v_Name;
txtGenericName.Text = _productDto.v_GenericName;
txtBarCode.Text = _productDto.v_BarCode;
txtBarCode.Text = _productDto.v_ProductCode;
txtBrand.Text = _productDto.v_Brand;
txtModel.Text = _productDto.v_Model;
txtSerialNumber.Text = _productDto.v_SerialNumber;
if (_productDto.d_ExpirationDate == null)
{
dtpExpirationDate.Checked = false;
}
else
{
dtpExpirationDate.Checked = true;
dtpExpirationDate.Value = (DateTime)_productDto.d_ExpirationDate;
}
ddlMeasurementUnitId.SelectedValue = _productDto.i_MeasurementUnitId.ToString();
txtReferentialCostPrice.Text = _productDto.r_ReferentialCostPrice.ToString();
txtReferentialSalesPrice.Text = _productDto.r_ReferentialSalesPrice.ToString();
txtPresentation.Text = _productDto.v_Presentation;
txtAdiccionalInformation.Text = _productDto.v_AdditionalInformation;
}
}
public void UpdateProduct(ref OperationResult pobjOperationResult, productDto pobjDtoEntity, List <string> ClientSession)
{
//mon.IsActive = true;
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
// Obtener la entidad fuente
var objEntitySource = (from a in dbContext.product
where a.v_ProductId == pobjDtoEntity.v_ProductId
select a).FirstOrDefault();
// Crear la entidad con los datos actualizados
pobjDtoEntity.d_UpdateDate = DateTime.Now;
pobjDtoEntity.i_UpdateUserId = Int32.Parse(ClientSession[2]);
product objEntity = productAssembler.ToEntity(pobjDtoEntity);
// Copiar los valores desde la entidad actualizada a la Entidad Fuente
dbContext.product.ApplyCurrentValues(objEntity);
// Guardar los cambios
dbContext.SaveChanges();
pobjOperationResult.Success = 1;
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "PRODUCTO", "v_ProductId=" + objEntity.v_ProductId.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, "PRODUCTO", "v_ProductId=" + pobjDtoEntity.v_ProductId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
return;
}
}
public void AddProduct(ref OperationResult pobjOperationResult, productDto pobjDtoEntity, List <string> ClientSession)
{
//mon.IsActive = true;
string NewId = "(No generado)";
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
product objEntity = productAssembler.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, 6), "PI");;
objEntity.v_ProductId = NewId;
dbContext.AddToproduct(objEntity);
dbContext.SaveChanges();
pobjOperationResult.Success = 1;
// Llenar entidad Log
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "PRODUCTO", "v_ProductId=" + 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, "PRODUCTO", "v_ProductId=" + NewId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage);
return;
}
}
public bool DeleteProduct(productDto pd)
{
return(blsh.DeleteProduct(map.ProductDtoToProductDao(pd)));
}
public bool AddProduct(productDto pd)
{
return(blsh.AddProduct(map.ProductDtoToProductDao(pd)));
}
private void btnOK_Click(object sender, EventArgs e)
{
OperationResult objOperationResult = new OperationResult();
if (uvProduct.Validate(true, false).IsValid)
{
if (txtName.Text.Trim() == "")
{
MessageBox.Show("Por favor ingrese un nombre apropiado para el producto.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (_Mode == "New")
{
_productDto = new productDto();
_productDto.i_CategoryId = Convert.ToInt32(ddlCategoryId.SelectedNode.Tag);
_productDto.v_Name = txtName.Text.Trim();
_productDto.v_GenericName = txtGenericName.Text.Trim();
_productDto.v_BarCode = txtBarCode.Text.Trim();
_productDto.v_ProductCode = txtBarCode.Text.Trim();
_productDto.v_Brand = txtBrand.Text.Trim();
_productDto.v_Model = txtModel.Text.Trim();
_productDto.v_SerialNumber = txtSerialNumber.Text.Trim();
//_productDto.d_ExpirationDate = string.IsNullOrEmpty(dtpExpirationDate.Text) ? (DateTime?)null : DateTime.Parse(dtpExpirationDate.Text);
if (dtpExpirationDate.Checked == false)
{
_productDto.d_ExpirationDate = null;
}
else
{
_productDto.d_ExpirationDate = dtpExpirationDate.Value;
}
_productDto.i_MeasurementUnitId = Convert.ToInt32(ddlMeasurementUnitId.SelectedValue);
_productDto.r_ReferentialCostPrice = string.IsNullOrEmpty(txtReferentialCostPrice.Text) ? (float?)null : float.Parse(txtReferentialCostPrice.Text);
_productDto.r_ReferentialSalesPrice = string.IsNullOrEmpty(txtReferentialSalesPrice.Text) ? (float?)null : float.Parse(txtReferentialSalesPrice.Text);
_productDto.v_Presentation = txtPresentation.Text.Trim();
_productDto.v_AdditionalInformation = txtAdiccionalInformation.Text.Trim();
// Save the data
_objBL.AddProduct(ref objOperationResult, _productDto, Globals.ClientSession.GetAsList());
}
else if (_Mode == "Edit")
{
_productDto.i_CategoryId = Convert.ToInt32(ddlCategoryId.SelectedNode.Tag);
_productDto.v_Name = txtName.Text.Trim();
_productDto.v_GenericName = txtGenericName.Text.Trim();
_productDto.v_BarCode = txtBarCode.Text.Trim();
_productDto.v_ProductCode = txtBarCode.Text.Trim();
_productDto.v_Brand = txtBrand.Text.Trim();
_productDto.v_Model = txtModel.Text.Trim();
_productDto.v_SerialNumber = txtSerialNumber.Text.Trim();
if (dtpExpirationDate.Checked == false)
{
_productDto.d_ExpirationDate = null;
}
else
{
_productDto.d_ExpirationDate = dtpExpirationDate.Value;
}
//_productDto.d_ExpirationDate = string.IsNullOrEmpty(dtpExpirationDate.Text) ? (DateTime?)null : DateTime.Parse(dtpExpirationDate.Text);
_productDto.i_MeasurementUnitId = Convert.ToInt32(ddlMeasurementUnitId.SelectedValue);
_productDto.r_ReferentialCostPrice = string.IsNullOrEmpty(txtReferentialCostPrice.Text) ? (float?)null : float.Parse(txtReferentialCostPrice.Text);
_productDto.r_ReferentialSalesPrice = string.IsNullOrEmpty(txtReferentialSalesPrice.Text) ? (float?)null : float.Parse(txtReferentialSalesPrice.Text);
_productDto.v_Presentation = txtPresentation.Text.Trim();
_productDto.v_AdditionalInformation = txtAdiccionalInformation.Text.Trim();
// Save the data
_objBL.UpdateProduct(ref objOperationResult, _productDto, Globals.ClientSession.GetAsList());
}
//// Analizar el resultado de la operación
if (objOperationResult.Success == 1) // Operación sin error
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
else // Operación con error
{
MessageBox.Show(Constants.GenericErrorMessage, "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error);
// Se queda en el formulario.
}
}
else
{
MessageBox.Show("Por favor corrija la información ingresada. Vea los indicadores de error.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
