public serviceorderDto GetServiceOrder(ref OperationResult pobjOperationResult, string pstrServiceId) { //mon.IsActive = true; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); serviceorderDto objDtoEntity = null; var objEntity = (from a in dbContext.serviceorder where a.v_ServiceOrderId == pstrServiceId select a).FirstOrDefault(); if (objEntity != null) { objDtoEntity = serviceorderAssembler.ToDTO(objEntity); } pobjOperationResult.Success = 1; return(objDtoEntity); } catch (Exception ex) { pobjOperationResult.Success = 0; pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex); return(null); } }
public string AddServiceOrder(ref OperationResult pobjOperationResult, serviceorderDto pobjDtoEntity, List <serviceorderdetailDto> pobjDtoEntityDetail, List <string> ClientSession) { //mon.IsActive = true; string NewId = "(No generado)"; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); #region Service Order serviceorder objEntity = serviceorderAssembler.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, 101), "YY"); objEntity.v_ServiceOrderId = NewId; dbContext.AddToserviceorder(objEntity); dbContext.SaveChanges(); #endregion #region Service Order Detail if (pobjDtoEntityDetail != null) { foreach (var item in pobjDtoEntityDetail) { serviceorderdetail objEntityDetail = serviceorderdetailAssembler.ToEntity(item); objEntityDetail.d_InsertDate = DateTime.Now; objEntityDetail.i_InsertUserId = Int32.Parse(ClientSession[2]); objEntityDetail.i_IsDeleted = 0; // Autogeneramos el Pk de la tabla objEntityDetail.v_ServiceOrderId = NewId; objEntityDetail.v_ServiceOrderDetailId = Common.Utils.GetNewId(intNodeId, Utils.GetNextSecuentialId(intNodeId, 102), "YA"); dbContext.AddToserviceorderdetail(objEntityDetail); dbContext.SaveChanges(); } } pobjOperationResult.Success = 1; #endregion // Llenar entidad Log //LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "ORDERN SERVICIO", "v_ServiceOrderId=" + NewId.ToString(), Success.Ok, null); return(NewId); } 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, "ORDEN SERVICIO", "v_ServiceOrderId=" + NewId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage); return(null); } }
private void frmServiceOrderEdit_Load(object sender, EventArgs e) { OperationResult objOperationResult = new OperationResult(); List <ProtocolComponentList> oProtocolComponentList = new List <BE.ProtocolComponentList>(); ProtocolBL oProtocolBL = new ProtocolBL(); ProtocolList objProtocol = new ProtocolList(); float CostoTotal = 0; Utils.LoadDropDownList(ddlStatusOrderServiceId, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 194, null), DropDownListAction.Select); Utils.LoadDropDownList(cbLineaCredito, "Value1", "Id", BLL.Utils.GetDataHierarchyForCombo(ref objOperationResult, 122, null), DropDownListAction.Select); if (_Mode == "New") { txtNroTrabajadores.Select(); int Year = DateTime.Now.Year; int Month = DateTime.Now.Month; int intNodeId = int.Parse(Globals.ClientSession.GetAsList()[0]); txtNroDocument.Text = GenerarCorrelativo(Year, Month, Sigesoft.Node.WinClient.BLL.Utils.GetNextSecuentialNoSave(intNodeId, 101)) + "-" + intNodeId; txtDateTime.Text = DateTime.Now.Date.ToString(); ddlStatusOrderServiceId.SelectedValue = ((int)Common.ServiceOrderStatus.Iniciado).ToString(); if (_ProtocolId != "") { oProtocolComponentList = oProtocolBL.GetProtocolComponents(ref objOperationResult, _ProtocolId); var x = oProtocolComponentList.FindAll(P => P.r_Price != 0); // eliminamos los componentes con precio 0 foreach (var item in x) { CostoTotal += (float)item.r_Price; } //grdData.DataSource = x; txtTotal.Text = CostoTotal.ToString(); //txtTotalTrabajadores.Text = objProtocol = oProtocolBL.GetProtocolById(ref objOperationResult, _ProtocolId); txtProtocolName.Text = objProtocol.v_Protocol; txtOrganitation.Text = objProtocol.v_Organization; txtContact.Text = objProtocol.v_ContacName; txtAdress.Text = objProtocol.v_Address; txttypeProtocol.Text = objProtocol.v_EsoType; } this.Height = 517; groupBox1.Height = 47; this.groupBox2.Location = new System.Drawing.Point(13, 98); } else { _oserviceorderDto = _oServiceOrderBL.GetServiceOrder(ref objOperationResult, _ServiceOrderId); //txtNroTrabajadores.Text = _oserviceorderDto.i_NumberOfWorker.ToString(); txtNroDocument.Text = _oserviceorderDto.v_CustomServiceOrderId; txtComentary.Text = _oserviceorderDto.v_Comentary; //txtCostoTotal.Text = _oserviceorderDto.r_TotalCost.ToString(); txtDateTime.Text = _oserviceorderDto.d_InsertDate.Value.Date.ToString(); txtTotal.Text = _oserviceorderDto.r_TotalCost.ToString(); txtTotalTrabajadores.Text = _oserviceorderDto.i_NumberOfWorker.ToString(); if (_oserviceorderDto.d_DeliveryDate == null) { dtpDelirevy.Checked = false; } else { dtpDelirevy.Checked = true; dtpDelirevy.Value = (DateTime)_oserviceorderDto.d_DeliveryDate; } if (_oserviceorderDto.i_MostrarPrecio == 1 || _oserviceorderDto.i_MostrarPrecio == null) { rbSi.Checked = true; rbNo.Checked = false; } else { rbNo.Checked = true; rbSi.Checked = false; } if (_oserviceorderDto.i_EsProtocoloEspecial == 1) { chkProtocoloEspecial.Checked = true; } else { chkProtocoloEspecial.Checked = false; } ddlStatusOrderServiceId.SelectedValue = _oserviceorderDto.i_ServiceOrderStatusId.ToString(); cbLineaCredito.SelectedValue = _oserviceorderDto.i_LineaCreditoId.ToString(); // oProtocolComponentList = oProtocolBL.GetProtocolComponents(ref objOperationResult, _ProtocolId); //var x = oProtocolComponentList.FindAll(P => P.r_Price != 0); // eliminamos los componentes con precio 0 //foreach (var item in x) // { // CostoTotal += (float)item.r_Price; // } //grdData.DataSource = x; //objProtocol = oProtocolBL.GetProtocolById(ref objOperationResult, _ProtocolId); //txtProtocolName.Text = objProtocol.v_Protocol; //txtOrganitation.Text = objProtocol.v_Organization; //txtContact.Text = objProtocol.v_ContacName; //txtAdress.Text = objProtocol.v_Address; //txttypeProtocol.Text = objProtocol.v_EsoType; //txtTotal.Text = _TempServiceOrderDetail = _oServiceOrderBL.GetServiceOrderPagedAndFiltered(ref objOperationResult, 0, null, "", "v_ServiceOrderId==" + "\"" + _oserviceorderDto.v_ServiceOrderId + "\""); grdData1.DataSource = _TempServiceOrderDetail; _ProtocolId = _TempServiceOrderDetail[0].v_ProtocolId; } }
public void UpdateService(ref OperationResult pobjOperationResult, serviceorderDto pobjDtoEntity, List <serviceorderdetailDto> pobjDtoEntityDetail, List <string> ClientSession) { //mon.IsActive = true; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); #region ServiceOrder // Obtener la entidad fuente var objEntitySource = (from a in dbContext.serviceorder where a.v_ServiceOrderId == pobjDtoEntity.v_ServiceOrderId && a.i_IsDeleted == 0 select a).FirstOrDefault(); // Crear la entidad con los datos actualizados pobjDtoEntity.d_UpdateDate = DateTime.Now; pobjDtoEntity.i_UpdateUserId = Int32.Parse(ClientSession[2]); serviceorder objEntity = serviceorderAssembler.ToEntity(pobjDtoEntity); // Copiar los valores desde la entidad actualizada a la Entidad Fuente dbContext.serviceorder.ApplyCurrentValues(objEntity); #endregion #region ServiceOrderDetail // Obtener la entidad fuente List <serviceorderdetail> pobjserviceorderdetailList = new List <serviceorderdetail>(); var objEntitySourceDetail = (from a in dbContext.serviceorderdetail where a.v_ServiceOrderId == pobjDtoEntity.v_ServiceOrderId select a).ToList(); foreach (var item in objEntitySourceDetail) { dbContext.serviceorderdetail.DeleteObject(item); dbContext.SaveChanges(); } if (pobjDtoEntityDetail != null) { int intNodeId = int.Parse(ClientSession[0]); foreach (var item in pobjDtoEntityDetail) { serviceorderdetail objDetailEntity = serviceorderdetailAssembler.ToEntity(item); if (item.v_ServiceOrderDetailId == null) { objDetailEntity.v_ServiceOrderDetailId = Common.Utils.GetNewId(intNodeId, Utils.GetNextSecuentialId(intNodeId, 102), "YA"); } else { objDetailEntity.v_ServiceOrderDetailId = item.v_ServiceOrderDetailId; } objDetailEntity.v_ProtocolId = item.v_ProtocolId; objDetailEntity.v_ServiceOrderId = pobjDtoEntity.v_ServiceOrderId; objDetailEntity.r_ProtocolPrice = item.r_ProtocolPrice; objDetailEntity.i_NumberOfWorkerProtocol = item.i_NumberOfWorkerProtocol; objDetailEntity.i_IsDeleted = 0; objDetailEntity.d_UpdateDate = DateTime.Now; objDetailEntity.i_UpdateUserId = Int32.Parse(ClientSession[2]); // Agregar el detalle del movimiento a la BD dbContext.AddToserviceorderdetail(objDetailEntity); } // Guardar los cambios dbContext.SaveChanges(); } #endregion pobjOperationResult.Success = 1; // Llenar entidad Log //LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "ORDEN SERVICIO", "v_ServiceOrderId=" + objEntity.v_ServiceOrderId.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, "SERVICIO", "v_ServiceOrderId=" + pobjDtoEntity.v_ServiceOrderId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage); return; } }