private void GetEmployeeRhData(ref EmployeeEntityOnject EmployeeInfo) { DataTable dt = new DataTable(); DataRow row = null; try { if (EmployeeInfo != null) { using (SqlConnection conn = new SqlConnection() { ConnectionString = _ConnectionString }) using (SqlCommand cmd = new SqlCommand() { Connection = conn }) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_GRL_GetTrabajadorDatosRH_"; cmd.Parameters.AddWithValue("@CLAVE_TRABAJADOR", EmployeeInfo.Clave); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) da.Fill(dt); } if (dt != null && dt.Rows.Count > 0) { row = dt.Rows[0]; EmployeeInfo.Calle = (row["calle"] != System.DBNull.Value) ? row["calle"].ToString() : ""; EmployeeInfo.Colonia = (row["colonia"] != System.DBNull.Value) ? row["colonia"].ToString() : ""; EmployeeInfo.Numero = (row["numero"] != System.DBNull.Value) ? row["numero"].ToString() : ""; EmployeeInfo.Calle = (row["estado"] != System.DBNull.Value) ? row["estado"].ToString() : ""; EmployeeInfo.Calle = (row["poblacion"] != System.DBNull.Value) ? row["poblacion"].ToString() : ""; EmployeeInfo.Calle = (row["telefono"] != System.DBNull.Value) ? row["telefono"].ToString() : ""; EmployeeInfo.Calle = (row["telefono2"] != System.DBNull.Value) ? row["telefono2"].ToString() : ""; EmployeeInfo.Calle = (row["telefono3"] != System.DBNull.Value) ? row["telefono3"].ToString() : ""; EmployeeInfo.Calle = (row["cp"] != System.DBNull.Value) ? row["cp"].ToString() : ""; EmployeeInfo.Calle = (row["escolaridad"] != System.DBNull.Value) ? row["escolaridad"].ToString() : ""; EmployeeInfo.Calle = (row["carrera"] != System.DBNull.Value) ? row["carrera"].ToString() : ""; EmployeeInfo.Calle = (row["sexo"] != System.DBNull.Value) ? row["sexo"].ToString() : ""; if (row["fecha_nacimiento"] != DBNull.Value) { EmployeeInfo.FechaNacimiento = Convert.ToDateTime(row["fecha_nacimiento"]); } EmployeeInfo.Calle = (row["lugar_nacimiento"] != System.DBNull.Value) ? row["lugar_nacimiento"].ToString() : ""; EmployeeInfo.Calle = (row["estado_civil"] != System.DBNull.Value) ? row["estado_civil"].ToString() : ""; EmployeeInfo.Calle = (row["padre"] != System.DBNull.Value) ? row["padre"].ToString() : ""; EmployeeInfo.Calle = (row["madre"] != System.DBNull.Value) ? row["madre"].ToString() : ""; EmployeeInfo.Calle = (row["localidad"] != System.DBNull.Value) ? row["localidad"].ToString() : ""; EmployeeInfo.Calle = (row["cve_instituto"] != System.DBNull.Value) ? row["cve_instituto"].ToString() : ""; EmployeeInfo.Calle = (row["estadonivel"] != System.DBNull.Value) ? row["estadonivel"].ToString() : ""; } } } catch (Exception ex) { throw ex; } }
public EmployeeEntityOnject GetEmployee(string ClaveTrabajador) { DataTable dt; DataRow[] rows; EmployeeEntityOnject _EmployeeInfo = null; try { dt = GetEmployeesTable(); rows = dt.Select(string.Format(@"CLAVE_TRABAJADOR='{0}'", ClaveTrabajador)); if (rows != null && rows.Length > 0) { _EmployeeInfo = GetEmployeeObject(rows[0]); //Se obtienen los datos de Nomina del Kardex GetEmployeeNominaData(ref _EmployeeInfo); } return(_EmployeeInfo); } catch (Exception ex) { throw ex; } }
private EmployeeEntityOnject GetEmployeeObject(DataRow row) { EmployeeEntityOnject _EmployeeInfo = null; if (row != null) { _EmployeeInfo = new EmployeeEntityOnject(); _EmployeeInfo.Clave = row["CLAVE_TRABAJADOR"].ToString(); _EmployeeInfo.Nombre = row["nombre"].ToString(); _EmployeeInfo.ApellidoPaterno = row["paterno"].ToString(); _EmployeeInfo.ApellidoMaterno = row["materno"].ToString(); if (row["fecha_alta"] != DBNull.Value) { _EmployeeInfo.FechaAlta = Convert.ToDateTime(row["fecha_alta"]); } if (row["fecha_ingreso"] != DBNull.Value) { _EmployeeInfo.FechaIngreso = Convert.ToDateTime(row["fecha_ingreso"]); } if (row["fecha_baja"] != DBNull.Value) { _EmployeeInfo.FechaBaja = Convert.ToDateTime(row["fecha_baja"]); } _EmployeeInfo.Empresa.Clave = row["CLAVE_COMPANIA"].ToString().Trim(); _EmployeeInfo.CentroCosto.Clave = row["CLAVE_CENTRO"].ToString().Trim(); _EmployeeInfo.Sucursal.Clave = row["CLAVE_SUCURSAL"].ToString().Trim(); _EmployeeInfo.Departamento.Clave = row["CLAVE_DEPTO"].ToString().Trim(); _EmployeeInfo.Puesto.Clave = row["CLAVE_PUESTO"].ToString().Trim(); _EmployeeInfo.TipoFactor = row["TIPO_FACTOR"].ToString().Trim(); if (row["factor_integracion"] != DBNull.Value) { _EmployeeInfo.FactorIntegracion = Convert.ToDecimal(row["factor_integracion"]); } if (row["sueldo_diario"] != DBNull.Value) { _EmployeeInfo.SueldoDiario = Convert.ToDecimal(row["sueldo_diario"]); } if (row["sueldo_variable"] != DBNull.Value) { _EmployeeInfo.SueldoVariable = Convert.ToDecimal(row["sueldo_variable"]); } if (row["sueldo_integrado"] != DBNull.Value) { _EmployeeInfo.SueldoVariable = Convert.ToDecimal(row["sueldo_integrado"]); } if (row["sueldo_infonavit"] != DBNull.Value) { _EmployeeInfo.SueldoInfonavit = Convert.ToDecimal(row["sueldo_infonavit"]); } _EmployeeInfo.Activo = (row["vigente"] != DBNull.Value && row["vigente"].ToString().ToUpper().Trim() == "SI") ? true : false; } return(_EmployeeInfo); }
private void GetEmployeeImssData(ref EmployeeEntityOnject EmployeeInfo) { try { if (EmployeeInfo != null) { } } catch (Exception ex) { throw ex; } }
protected void ASPxGridViewNomina_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e) { DevExpress.Web.ASPxGridView grid = (DevExpress.Web.ASPxGridView)sender; object employeeID = e.Parameters; string clave = employeeID.ToString().Trim(); //se obtiene el empleado mediante el ID EmployeeBusinessObject _EmployeeBAL = new EmployeeBusinessObject(); EmployeeEntityOnject _EmployeeInfo = _EmployeeBAL.GetEmployee(clave); if (_EmployeeInfo != null) { e.Result = new string[] { _EmployeeInfo.Clave, _EmployeeInfo.NombreCompleto }; } }
protected void ASPxGridViewNomina_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = (ASPxGridView)sender; ASPxComboBox cmb = (ASPxComboBox)grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ClaveTrabajador"], "cmbEmployee"); e.NewValues["ClaveTrabajador"] = cmb.Text; e.NewValues["ClaveConcepto"] = ((ASPxGridView)sender).GetMasterRowKeyValue(); //se obtiene la empresa del trabajador seleccionado EmployeeBusinessObject _EmployeeBAL = new EmployeeBusinessObject(); EmployeeEntityOnject _EmployeeInfo = _EmployeeBAL.GetEmployee(e.NewValues["ClaveTrabajador"].ToString()); PeriodoBusinessObject _PeriodoBAL = new PeriodoBusinessObject(); PeriodoEntityObject _PeriodoInfo = _PeriodoBAL.GetPeriodoActualByNominaEmpresa(_EmployeeInfo.ClaveNomina, _EmployeeInfo.Empresa.Clave); e.NewValues["Empresa"] = _EmployeeInfo.Empresa.Clave; e.NewValues["Periodo"] = _PeriodoInfo.ClavePeriodo; }
private void GetEmployeeNominaData(ref EmployeeEntityOnject EmployeeInfo) { string sql; DataTable dt; try { if (EmployeeInfo != null) { sql = string.Format(@"SELECT T.cve107 as CLAVE_TRABAJADOR ,txt123 as rfc ,txt124 as comisiones ,txt125 as cuenta ,cve119 as ptu ,cve120 as cuota_sindical ,txt130 as descanso1 ,cve116 as CLAVE_NOMINA ,cve117 as CLAVE_TURNO ,cve118 as tipo_pago ,txt126 as control_interno ,txt131 as descanso2 ,banco ,numero_tarjeta ,Tn.txt60 as DescNomina ,CLABE ,REGIMEN_CONT as REGIMEN ,TURNO_ACTUAL FROM dbENC77 T INNER JOIN dbENC73 ON T.num75 = dbENC73.NUM_DOC INNER JOIN dbENC46 Tn ON dbENC73.cve116 = Tn.cve63 and Tn.clave_empresa = T.cve340 WHERE (dbENC73.NUM_DOC > 0) AND (T.cve107 = '{0}')", EmployeeInfo.Clave); dt = ExecuteDataTable(sql, null, null); if (dt != null && dt.Rows.Count > 0) { EmployeeInfo.ClaveNomina = dt.Rows[0]["CLAVE_NOMINA"].ToString().Trim(); } } } catch (Exception ex) { throw ex; } }
public int Delete(EmployeeEntityOnject EmployeeInfo) { throw new NotImplementedException(); }