protected void btnAgregar_Click(object sender, EventArgs e) { string cleanMessage = string.Empty; if (ddlPersonal.SelectedIndex < 1) { cleanMessage = "Seleccionar personal"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } else if (ddlPerfil.SelectedIndex < 1) { cleanMessage = "Seleccionar perfil"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } else if (ddlFamilia.SelectedIndex < 1) { cleanMessage = "Seleccionar familia"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } else if (ddlGerencia.SelectedItem.ToString() == string.Empty) { cleanMessage = "Selecciona gerencia"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } else if (ddlCentro.SelectedItem.ToString() == string.Empty) { cleanMessage = "Selecciona centro de costo"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } else { BE_RRHH_DESEMPENIO_FICHA oBESol = new BE_RRHH_DESEMPENIO_FICHA(); oBESol.IDE_DESEMPENIO = Convert.ToInt32(string.IsNullOrEmpty(lblCodigo.Text) ? "0" : lblCodigo.Text); oBESol.DNI = ddlPersonal.SelectedValue.ToString(); oBESol.ANIO = Convert.ToInt32(ddlanio.SelectedValue); oBESol.IDE_PERFIL = Convert.ToInt32(ddlPerfil.SelectedValue); oBESol.CODIGO_GERENCIA = ddlGerencia.SelectedValue.ToString(); oBESol.CCENTRO = ddlCentro.SelectedValue.ToString(); oBESol.IDE_FAMILIA = Convert.ToInt32(ddlFamilia.SelectedValue); oBESol.CARGO = BL_Session.NombreCargo; oBESol.USER_REGISTRA = Session["IDE_USUARIO"].ToString(); int dtrpta = 0; dtrpta = new BL_RRHH_DESEMPENIO_FICHA().uspINS_RRHH_DESEMPENIO_PERFIL(oBESol); if (dtrpta > 0) { lblCodigo.Text = string.Empty; cleanMessage = "Registro exitoso"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); ddlPersonal.Text = ""; Listar(); } } }
public DataTable uspSEL_RRHH_DESEMPENIO_ADICIONAR(BE_RRHH_DESEMPENIO_FICHA oBE) { try { return(new DA_RRHH_DESEMPENIO_FICHA().uspSEL_RRHH_DESEMPENIO_ADICIONAR(oBE)); } catch (Exception ex) { throw ex; } }
public int uspSEL_RRHH_DESEMPENIO_INSERT_VARIOS(BE_RRHH_DESEMPENIO_FICHA oBE) { try { return(new DA_RRHH_DESEMPENIO_FICHA().uspSEL_RRHH_DESEMPENIO_INSERT_VARIOS(oBE)); } catch (Exception ex) { throw ex; } }
public int uspINS_RRHH_DESEMPENIO_PERFIL(BE_RRHH_DESEMPENIO_FICHA oBE) { try { return(new DA_RRHH_DESEMPENIO_FICHA().uspINS_RRHH_DESEMPENIO_PERFIL(oBE)); } catch (Exception ex) { throw ex; } }
public int uspSEL_RRHH_DESEMPENIO_INSERT_VARIOS(BE_RRHH_DESEMPENIO_FICHA oBE) { object[] Parametros = new[] { (object)UC_FormWeb.mSQLFieldOrNull(oBE.CCENTRO, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.CODIGO_GERENCIA, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.IP_CENTRO, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.ANIO, tgSQLFieldType.NUMERIC), (object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_JEFE, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_GERENTE, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.USER_REGISTRA, tgSQLFieldType.TEXT), }; return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspSEL_RRHH_DESEMPENIO_INSERT_VARIOS", Parametros))); }
public int uspINS_RRHH_DESEMPENIO_PERFIL(BE_RRHH_DESEMPENIO_FICHA oBE) { object[] Parametros = new[] { (object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_DESEMPENIO, tgSQLFieldType.NUMERIC), (object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.ANIO, tgSQLFieldType.NUMERIC), (object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_PERFIL, tgSQLFieldType.NUMERIC), (object)UC_FormWeb.mSQLFieldOrNull(oBE.CODIGO_GERENCIA, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.CCENTRO, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_FAMILIA, tgSQLFieldType.NUMERIC), (object)UC_FormWeb.mSQLFieldOrNull(oBE.CARGO, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.USER_REGISTRA, tgSQLFieldType.TEXT), }; return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_DESEMPENIO_PERFIL", Parametros))); }
public DataTable uspSEL_RRHH_DESEMPENIO_ADICIONAR(BE_RRHH_DESEMPENIO_FICHA oBE) { object[] Parametros = new[] { (object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.CCENTRO, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.CODIGO_GERENCIA, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.IP_CENTRO, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.ANIO, tgSQLFieldType.NUMERIC), (object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_JEFE, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_GERENTE, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.USER_REGISTRA, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_FAMILIA, tgSQLFieldType.TEXT), (object)UC_FormWeb.mSQLFieldOrNull(oBE.COMENTARIOS, tgSQLFieldType.TEXT), }; return(new Utilitarios().EjecutaDatatable("uspSEL_RRHH_DESEMPENIO_ADICIONAR", Parametros)); }
protected void InsertarPersonalVarios() { BE_RRHH_DESEMPENIO_FICHA oBESol = new BE_RRHH_DESEMPENIO_FICHA(); oBESol.CCENTRO = Session["CCENTRO"].ToString(); oBESol.CODIGO_GERENCIA = Session["CODIGO_GERENCIA"].ToString(); oBESol.IP_CENTRO = Session["IP_CENTRO"].ToString(); oBESol.ANIO = Convert.ToInt32(Session["ANIO"].ToString()); oBESol.DNI_JEFE = Session["DNI_JEFE"].ToString(); oBESol.DNI_GERENTE = Session["DNI_GERENTE"].ToString(); oBESol.USER_REGISTRA = Session["IDE_USUARIO"].ToString(); int dtrpta = 0; dtrpta = new BL_RRHH_DESEMPENIO_FICHA().uspSEL_RRHH_DESEMPENIO_INSERT_VARIOS(oBESol); if (dtrpta > 0) { } }
protected void btnAgregar_Click(object sender, EventArgs e) { string cleanMessage = string.Empty; if (ddlPersonal.SelectedIndex < 1) { cleanMessage = "Seleccionar personal"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } else if (ddlFamilia.SelectedIndex < 1) { cleanMessage = "Seleccionar familia"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } else { BE_RRHH_DESEMPENIO_FICHA oBESol = new BE_RRHH_DESEMPENIO_FICHA(); oBESol.DNI = ddlPersonal.SelectedValue.ToString(); oBESol.CCENTRO = ddlCentro.SelectedValue.ToString(); oBESol.CODIGO_GERENCIA = ddlGerencia.SelectedValue.ToString(); oBESol.IP_CENTRO = string.Empty; oBESol.ANIO = Convert.ToInt32(ddlanio.SelectedValue); oBESol.DNI_JEFE = ddlJefe.SelectedValue.ToString(); oBESol.DNI_GERENTE = ddlGerencia.SelectedValue.ToString(); oBESol.USER_REGISTRA = Session["IDE_USUARIO"].ToString(); oBESol.IDE_FAMILIA = Convert.ToInt32(ddlFamilia.SelectedValue); oBESol.COMENTARIOS = txtcomentario.Text.Trim(); DataTable dtrpta = new DataTable(); BL_RRHH_DESEMPENIO_FICHA obj = new BL_RRHH_DESEMPENIO_FICHA(); dtrpta = obj.uspSEL_RRHH_DESEMPENIO_ADICIONAR(oBESol); if (dtrpta.Rows.Count > 0) { int codigo = Convert.ToInt32(dtrpta.Rows[0]["CODIGO"].ToString()); if (codigo == 0) { string _gerencia = dtrpta.Rows[0]["CODIGO_GERENCIA"].ToString(); string _cc = dtrpta.Rows[0]["CCENTRO"].ToString(); string _jefe = dtrpta.Rows[0]["JEFE"].ToString(); cleanMessage = "Personal ya se encuentra asignado al: <br /> - Centro de costo : " + _cc + "<br /> - Jefe directo : " + _jefe; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } else { Session["IDE_DESEMPENIO"] = dtrpta.Rows[0]["IDE_DESEMPENIO"].ToString(); ddlPersonal.Text = ""; txtcomentario.Text = string.Empty; cleanMessage = "Registro exitoso"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } } else { cleanMessage = "Error!! volver a intentarlo"; ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true); } } }