public int GetIdParametro(string pNomeParametro)
{
int Result = 0;
string script = $"Select id_parametro from tb_parametros where nm_parametro='{pNomeParametro}'";
using (SqlDataReader dr = conexao.ExecutarSelect(script))
{
if (dr.HasRows)
{
while (dr.Read())
{
Result = Convert.ToInt32(CadParametrosBase.isNullResultZero(dr["id_parametro"].ToString()));
}
}
}
return(Result);
}
public int GetIdGrupoDaCategoria(string pIdCategoria)
{
int Result = 0;
string script = $"select id_grupo from tb_categorias where id_categoria ='{pIdCategoria}'";
using (SqlDataReader dr = conexao.ExecutarSelect(script))
{
if (dr.HasRows)
{
while (dr.Read())
{
Result = Convert.ToInt32(CadGruposBase.isNullResultZero(dr["id_grupo"].ToString()));
}
}
}
return(Result);
}
public int GetIdGrupo(string pNomeGrupo)
{
int Result = 0;
string script = $"Select id_grupo from tb_grupos where nm_grupo='{pNomeGrupo}' and status='ativo'";
using (SqlDataReader dr = conexao.ExecutarSelect(script))
{
if (dr.HasRows)
{
while (dr.Read())
{
Result = Convert.ToInt32(CadCategoriasBase.isNullResultZero(dr["id_grupo"].ToString()));
}
}
}
return(Result);
}
