public DataSet sp_actualizar_log_inactivo(employees_compensations employee_compensations)
{
DataSet ds = new DataSet();
List <SqlParameter> listparameters = new List <SqlParameter>();
Datos data = new Datos();
listparameters.Add(new SqlParameter()
{
ParameterName = "@employee_number", SqlDbType = SqlDbType.Int, Value = employee_compensations.employee_number
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@id_bond_type", SqlDbType = SqlDbType.Int, Value = employee_compensations.id_bond_type
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@id_bond_type_automatic", SqlDbType = SqlDbType.Int, Value = employee_compensations.id_bond_type
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@UpdateBy", SqlDbType = SqlDbType.Int, Value = employee_compensations.modified_by
});
try
{
ds = data.enviar("sp_actualizar_log_inactivo", listparameters, false, 4);
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}
public DataSet sp_Insert_Employee_Compensations(employees_compensations employee_compensations)
{
DataSet ds = new DataSet();
List <SqlParameter> listparameters = new List <SqlParameter>();
Datos data = new Datos();
listparameters.Add(new SqlParameter()
{
ParameterName = "@employee_number", SqlDbType = SqlDbType.Int, Value = employee_compensations.employee_number
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@id_bond_type", SqlDbType = SqlDbType.Int, Value = employee_compensations.id_bond_type
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@amount", SqlDbType = SqlDbType.Int, Value = employee_compensations.amount
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@id_periodicity", SqlDbType = SqlDbType.Int, Value = employee_compensations.id_periodicity
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@created_by", SqlDbType = SqlDbType.Int, Value = employee_compensations.created_by
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@modified_by", SqlDbType = SqlDbType.Int, Value = employee_compensations.modified_by
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@Porcentaje", SqlDbType = SqlDbType.Int, Value = employee_compensations.percentage_extra
});
try
{
ds = data.enviar("sp_Insert_Employee_Compensations", listparameters, false, 4);
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}