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