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