public int uspINS_RRHH_FORMATIVO_EXAMEN(BE_RRHH_FORMATIVO_EXAMEN obj) { try { return(new DA_RRHH_FORMATIVO_EXAMEN().uspINS_RRHH_FORMATIVO_EXAMEN(obj)); } catch (Exception ex) { throw ex; } }
public int uspINS_RRHH_FORMATIVO_EXAMEN(BE_RRHH_FORMATIVO_EXAMEN obj) { object[] Parametros = new[] { (object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_EVAL_EXAMEN, tgSQLFieldType.NUMERIC), (object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_FICHA, tgSQLFieldType.NUMERIC), (object)UC_FormWeb.mSQLFieldOrNull(obj.DNI_EVALUADOR, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(obj.DNI_EVALUADO, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(obj.FORTALEZAS, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(obj.MEJORAS, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(obj.COMPROMISOS, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_TIPO_EXA, tgSQLFieldType.NUMERIC), (object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_FASE, tgSQLFieldType.TEXT), }; return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_FORMATIVO_EXAMEN", Parametros))); }
protected void btnEnviar_Click(object sender, EventArgs e) { string cleanMessage = string.Empty; BE_RRHH_FORMATIVO_EXAMEN obj = new BE_RRHH_FORMATIVO_EXAMEN(); obj.IDE_EVAL_EXAMEN = Convert.ToInt32(string.IsNullOrEmpty(lblCodigo.Text) ? "0" : lblCodigo.Text); obj.IDE_FICHA = Convert.ToInt32(Session["IDE_FICHA"].ToString()); obj.DNI_EVALUADOR = Session["IDE_USUARIO"].ToString(); obj.DNI_EVALUADO = Session["DNI_EVALUADO"].ToString(); obj.FORTALEZAS = txtFortalezas.Text.Trim(); obj.MEJORAS = txtoportunidades.Text.Trim(); obj.COMPROMISOS = txtCompromiso.Text.Trim(); obj.IDE_TIPO_EXA = Convert.ToInt32(Session["IDE_EXAMEN"].ToString()); obj.IDE_FASE = Convert.ToInt32(Session["IDE_FASE"].ToString()); int rpta = 0; rpta = new BL_RRHH_FORMATIVO_EXAMEN().uspINS_RRHH_FORMATIVO_EXAMEN(obj); if (rpta > 0) { lblCodigo.Text = rpta.ToString(); registrarCompetencias(rpta); registrarEspecificas(rpta); BL_RRHH_FORMATIVO_EXAMEN objEx = new BL_RRHH_FORMATIVO_EXAMEN(); DataTable dtEx = new DataTable(); dtEx = objEx.uspSUMA_PTOS_EXA_FORMATIVO_EXAMEN(rpta, Convert.ToInt32(Session["IDE_FICHA"].ToString()), Convert.ToInt32(Session["IDE_EXAMEN"].ToString()), Convert.ToInt32(Session["IDE_FASE"].ToString())); BL_RRHH_FORMATIVO_EXAMEN objX = new BL_RRHH_FORMATIVO_EXAMEN(); DataTable dt = new DataTable(); dt = objX.USP_CORREO_EXAMEN_EJECUTADO(lblCabcera.Text.Trim(), Session["IDE_USUARIO"].ToString()); if (dt.Rows.Count > 0) { cleanMessage = "Envio satisfactorio"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } } }