private object[] UpdateMaster(EPersonal entity) { if (entity == null) return null; IDOUpdate objDO = new RHDOMnt.Personal(); if (entity.EntityState == EntityState.Unchanged) return null; object[] objRet = null; switch (entity.EntityState) { case EntityState.Added: objRet = objDO.Insert(entity); break; case EntityState.Modified: if (entity.StAnulado == ConstFlagEstado.DESACTIVADO) objDO.Update(entity); else objDO.Delete(entity); break; case EntityState.Deleted: objDO.Delete(entity); break; } return objRet; }
private void UpdateDetailB(IList<EPerContrato> col, object[] primKey) { if (col == null) return; IDOUpdate objDO = new RHDOMnt.PerContrato(); RHDOMnt.Personal objDOPer = new RHDOMnt.Personal(); EPersonal NewEPersonal = new EPersonal(); foreach (EPerContrato objE in col) { object[] objRet = null; if (primKey != null) { objE.IdPersonal = primKey[0].ToString(); } switch (objE.EntityState) { case EntityState.Added: objRet = objDO.Insert(objE); NewEPersonal.IdEmpresa = objE.IdEmpresa; NewEPersonal.IdPersonal = objE.IdPersonal; NewEPersonal.IdSituEmple = ConstSituacionEmpleado.ACTIVO_SUBSIDIADO; NewEPersonal.IdMotivFin = ""; NewEPersonal.FeCese = null; if (objE.StProrroga == ConstFlagEstado.ACTIVADO) { NewEPersonal.FeIngpla = null; } else { NewEPersonal.FeIngpla = objE.FeInicio; } objDOPer.UpdateEstadoFechaCese(NewEPersonal); break; case EntityState.Modified: if (objE.StAnulado == ConstFlagEstado.DESACTIVADO) objDO.Update(objE); if (objE.StContrato == ConstFlagEstado.ACTIVADO) { NewEPersonal.IdEmpresa = objE.IdEmpresa; NewEPersonal.IdPersonal = objE.IdPersonal; NewEPersonal.IdSituEmple = ConstSituacionEmpleado.BAJA; NewEPersonal.FeCese = objE.FeCese; NewEPersonal.FeIngpla = null; NewEPersonal.IdMotivFin = objE.IdMotivFin; objDOPer.UpdateEstadoFechaCese(NewEPersonal); } else objDO.Delete(objE); break; } } }
private ArrayList BuildParamInterface(EPersonal value) { ArrayList arrPrm = new ArrayList(); arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, value.IdEmpresa)); arrPrm.Add(DataHelper.CreateParameter("@pidPersonal", SqlDbType.Char, 7, value.IdPersonal)); arrPrm.Add(DataHelper.CreateParameter("@pidCliProv", SqlDbType.Char, 7, value.IdCliProv)); arrPrm.Add(DataHelper.CreateParameter("@pnuFotocheck", SqlDbType.VarChar, 15, value.NuFotocheck)); arrPrm.Add(DataHelper.CreateParameter("@pidEstable", SqlDbType.Char, 4, value.IdEstable)); arrPrm.Add(DataHelper.CreateParameter("@pidSexo", SqlDbType.Char, 3, value.IdSexo)); arrPrm.Add(DataHelper.CreateParameter("@pfeNacimien", SqlDbType.DateTime, value.FeNacimien)); arrPrm.Add(DataHelper.CreateParameter("@pidNacional", SqlDbType.Char, 6, value.IdNacional)); arrPrm.Add(DataHelper.CreateParameter("@pnuRUC", SqlDbType.Char, 11, value.NuRUC)); arrPrm.Add(DataHelper.CreateParameter("@pstEsSalud", SqlDbType.Char, 1, value.StEsSalud)); arrPrm.Add(DataHelper.CreateParameter("@pstDomiciliado", SqlDbType.Char, 1, value.StDomiciliado)); arrPrm.Add(DataHelper.CreateParameter("@pidCateTrab", SqlDbType.Char, 3, value.IdCateTrab)); arrPrm.Add(DataHelper.CreateParameter("@pidTipoTrab", SqlDbType.Char, 3, value.IdTipoTrab)); arrPrm.Add(DataHelper.CreateParameter("@pidCateOcupa", SqlDbType.Char, 3, value.IdCateOcupa)); arrPrm.Add(DataHelper.CreateParameter("@pidRegLaboral", SqlDbType.Char, 3, value.IdRegLaboral)); arrPrm.Add(DataHelper.CreateParameter("@pidNivEduc", SqlDbType.Char, 3, value.IdNivEduc)); arrPrm.Add(DataHelper.CreateParameter("@pidOcupa", SqlDbType.Char, 6, value.IdOcupa)); arrPrm.Add(DataHelper.CreateParameter("@pstDiscapa", SqlDbType.Char, 1, value.StDiscapa)); arrPrm.Add(DataHelper.CreateParameter("@pidRegPensi", SqlDbType.Char, 3, value.IdRegPensi)); arrPrm.Add(DataHelper.CreateParameter("@pfeInscRegPen", SqlDbType.DateTime, (value.FeInscRegPen.HasValue ? (object)value.FeInscRegPen : DBNull.Value))); arrPrm.Add(DataHelper.CreateParameter("@pnuCuspp", SqlDbType.Char, 15, value.NuCuspp)); arrPrm.Add(DataHelper.CreateParameter("@pidSctrSalud", SqlDbType.Char, 3, value.IdSctrSalud)); arrPrm.Add(DataHelper.CreateParameter("@pidSctrPens", SqlDbType.Char, 3, value.IdSctrPens)); arrPrm.Add(DataHelper.CreateParameter("@pidTipoCont", SqlDbType.Char, 3, value.IdTipoCont)); arrPrm.Add(DataHelper.CreateParameter("@pstSujRegAlter", SqlDbType.Char, 1, value.StSujRegAlter)); arrPrm.Add(DataHelper.CreateParameter("@pstJTMaxima", SqlDbType.Char, 1, value.StJTMaxima)); arrPrm.Add(DataHelper.CreateParameter("@pstJTHoraNoc", SqlDbType.Char, 1, value.StJTHoraNoc)); arrPrm.Add(DataHelper.CreateParameter("@pstJTAtipico", SqlDbType.Char, 1, value.StJTAtipico)); arrPrm.Add(DataHelper.CreateParameter("@pstOtrosIng5ta", SqlDbType.Char, 1, value.StOtrosIng5ta)); arrPrm.Add(DataHelper.CreateParameter("@pstSindical", SqlDbType.Char, 1, value.StSindical)); arrPrm.Add(DataHelper.CreateParameter("@pidPeriRemu", SqlDbType.Char, 3, value.IdPeriRemu)); arrPrm.Add(DataHelper.CreateParameter("@pidSegMedi", SqlDbType.Char, 3, value.IdSegMedi)); arrPrm.Add(DataHelper.CreateParameter("@pidEmpEps", SqlDbType.Char, 3, value.IdEmpEps)); arrPrm.Add(DataHelper.CreateParameter("@pidSituEmple", SqlDbType.Char, 3, value.IdSituEmple)); arrPrm.Add(DataHelper.CreateParameter("@pst5taExon", SqlDbType.Char, 1, value.St5taExon)); arrPrm.Add(DataHelper.CreateParameter("@pidSitEspTrab", SqlDbType.Char, 3, value.IdSitEspTrab)); arrPrm.Add(DataHelper.CreateParameter("@pidTipoRemu", SqlDbType.Char, 3, value.IdTipoRemu)); arrPrm.Add(DataHelper.CreateParameter("@pfeIngpla", SqlDbType.DateTime, (value.FeIngpla.HasValue ? (object)value.FeIngpla : DBNull.Value))); arrPrm.Add(DataHelper.CreateParameter("@pfeCese", SqlDbType.DateTime, (value.FeCese.HasValue ? (object)value.FeCese : DBNull.Value))); arrPrm.Add(DataHelper.CreateParameter("@pidMotivFin", SqlDbType.Char, 3, value.IdMotivFin)); arrPrm.Add(DataHelper.CreateParameter("@pstMadreResp", SqlDbType.Char, 1, value.StMadreResp)); arrPrm.Add(DataHelper.CreateParameter("@pidTipoCenFP", SqlDbType.Char, 3, value.IdTipoCenFP)); arrPrm.Add(DataHelper.CreateParameter("@pidCentroFP", SqlDbType.Char, 3, value.IdCentroFP)); arrPrm.Add(DataHelper.CreateParameter("@pidProvDest", SqlDbType.Char, 7, value.IdProvDest)); arrPrm.Add(DataHelper.CreateParameter("@pidEstaCivil", SqlDbType.Char, 3, value.IdEstaCivil)); arrPrm.Add(DataHelper.CreateParameter("@pidBcoAbono", SqlDbType.Char, 3, value.IdBcoAbono)); arrPrm.Add(DataHelper.CreateParameter("@pidTipoCtaAbo", SqlDbType.Char, 3, value.IdTipoCtaAbo)); arrPrm.Add(DataHelper.CreateParameter("@pnuCtaAbono", SqlDbType.VarChar, 30, value.NuCtaAbono)); arrPrm.Add(DataHelper.CreateParameter("@pstAsigFami", SqlDbType.Char, 1, value.StAsigFami)); arrPrm.Add(DataHelper.CreateParameter("@pidBcoCts", SqlDbType.Char, 3, value.IdBcoCts)); arrPrm.Add(DataHelper.CreateParameter("@pnuCtaCts", SqlDbType.VarChar, 30, value.NuCtaCts)); arrPrm.Add(DataHelper.CreateParameter("@pidUNegocio", SqlDbType.Char, 3, value.IdUNegocio)); arrPrm.Add(DataHelper.CreateParameter("@pidCCosto", SqlDbType.Char, 15, value.IdCCosto)); arrPrm.Add(DataHelper.CreateParameter("@pidTipoSangre", SqlDbType.Char, 3, value.IdTipoSangre)); arrPrm.Add(DataHelper.CreateParameter("@pdsEnfermedad", SqlDbType.VarChar, 50, value.DsEnfermedad)); arrPrm.Add(DataHelper.CreateParameter("@pdsAlergia", SqlDbType.VarChar, 50, value.DsAlergia)); arrPrm.Add(DataHelper.CreateParameter("@pdsPriAuxilios", SqlDbType.VarChar, 50, value.DsPriAuxilios)); arrPrm.Add(DataHelper.CreateParameter("@pnuTalla", SqlDbType.Decimal, value.NuTalla)); arrPrm.Add(DataHelper.CreateParameter("@pnuPeso", SqlDbType.Decimal, value.NuPeso)); arrPrm.Add(DataHelper.CreateParameter("@pdsTallaCalza", SqlDbType.VarChar, 10, value.DsTallaCalza)); arrPrm.Add(DataHelper.CreateParameter("@pdsTallaPanta", SqlDbType.VarChar, 10, value.DsTallaPanta)); arrPrm.Add(DataHelper.CreateParameter("@pdsTallaCamisa", SqlDbType.VarChar, 10, value.DsTallaCamisa)); arrPrm.Add(DataHelper.CreateParameter("@pdsClubSoDe", SqlDbType.VarChar, 80, value.DsClubSoDe)); arrPrm.Add(DataHelper.CreateParameter("@pdsHobby", SqlDbType.VarChar, 50, value.DsHobby)); arrPrm.Add(DataHelper.CreateParameter("@pdsReligion", SqlDbType.VarChar, 50, value.DsReligion)); arrPrm.Add(DataHelper.CreateParameter("@pidEstado", SqlDbType.Char, 3, value.IdEstado)); arrPrm.Add(DataHelper.CreateParameter("@pnuUltGen01", SqlDbType.Int, value.NuUltGen01)); arrPrm.Add(DataHelper.CreateParameter("@pstAnulado", SqlDbType.Char, 1, value.StAnulado)); return arrPrm; }
private void DeleteMaster(EPersonal entity) { IDOUpdate objDO = new RHDOMnt.Personal(); if (entity.EntityState == EntityState.Unchanged) return; objDO.Delete(entity); }
private ArrayList BuildParamInterface(EPersonal value) { ArrayList arrPrm = new ArrayList(); arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, value.IdEmpresa)); arrPrm.Add(DataHelper.CreateParameter("@pidPersonal", SqlDbType.Char, 7, value.IdPersonal)); return arrPrm; }