public int actualizarCargoPrincipal(RRHH_PERSONA_CARGO entity)
{
int resultado = 0;
Database db = DatabaseFactory.CreateDatabase(ConfigurationManager.AppSettings["conecion"].ToString());
using (DbConnection cone = db.CreateConnection())
{
cone.Open();
using (DbTransaction trans = cone.BeginTransaction())
{
try
{
DbCommand cmd = db.GetStoredProcCommand("RRHH_ACTUALIZAR_CARGO_PRINCIPAL");
db.AddInParameter(cmd, "C_COD_PERSONA", DbType.String, entity.C_COD_PERSONA);
db.AddInParameter(cmd, "I_COD_PERSONA_CARGO", DbType.Int32, entity.I_COD_PERSONA_CARGO);
resultado = Convert.ToInt32(db.ExecuteNonQuery(cmd, trans));
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
}
finally
{
if (cone.State == ConnectionState.Open)
{
cone.Close();
}
}
}
}
return(resultado);
}
public ActionResult actualizarCargoPrincipal(string codPersona, int codPersonaCargo)
{
RRHH_PERSONA_CARGO entity = new RRHH_PERSONA_CARGO {
C_COD_PERSONA = codPersona, I_COD_PERSONA_CARGO = codPersonaCargo
};
return(Json(personaChargeRepository.actualizarCargoPrincipal(entity), JsonRequestBehavior.AllowGet));
}
public int savePeopleCharge(RRHH_PERSONA_CARGO entity)
{
int resultado = 0;
Database db = DatabaseFactory.CreateDatabase(ConfigurationManager.AppSettings["conecion"]);
using (DbConnection cone = db.CreateConnection())
{
cone.Open();
using (DbTransaction trans = cone.BeginTransaction())
{
try
{
DbCommand cmd = db.GetStoredProcCommand("RRHH_SP_REGISTRAR_PERSONA_CARGO");
db.AddInParameter(cmd, "C_COD_PERSONA", DbType.String, entity.C_COD_PERSONA);
db.AddInParameter(cmd, "I_COD_INSTANCIA", DbType.String, entity.I_COD_INSTANCIA);
db.AddInParameter(cmd, "C_COD_AREA", DbType.String, entity.C_COD_AREA);
db.AddInParameter(cmd, "I_COD_CARGO", DbType.Int32, entity.I_COD_CARGO);
db.AddInParameter(cmd, "D_FEC_INGRESO", DbType.Date, entity.D_FEC_INGRESO);
db.AddInParameter(cmd, "V_OBSERVACION_INGRESO", DbType.String, entity.V_OBSERVACION_INGRESO);
db.AddInParameter(cmd, "C_ACTIVO", DbType.String, "S");
resultado = Convert.ToInt32(db.ExecuteNonQuery(cmd, trans));
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message);
}
finally
{
if (cone.State == ConnectionState.Open)
{
cone.Close();
}
}
}
}
return(resultado);
}
public ActionResult savePeopleCharge(RRHH_PERSONA_CARGO entity)
{
return(Json(personaChargeRepository.savePeopleCharge(entity), JsonRequestBehavior.AllowGet));
}
public int savePeopleCharge(RRHH_PERSONA_CARGO entity)
{
return(new peopleChargeDA().savePeopleCharge(entity));
}
public int actualizarCargoPrincipal(RRHH_PERSONA_CARGO entity)
{
return(new peopleChargeDA().actualizarCargoPrincipal(entity));
}
