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