public int GetidServico(string pnmServico)
{
ServicosModel servicosModel = new ServicosModel();
string script = "Select * from tb_Servicos where nm_Servico=@nm_Servico";
conexao.LimparParametros();
conexao.Parametros.Add(new SqlParameter()
{
ParameterName = "nm_Servico", Value = pnmServico
});
servicosModel.SetDados(conexao.ExecutarSelect(script));
return(servicosModel.id_servico);
}
public string GetNomeServico(int pIdServico)
{
ServicosModel servicosModel = new ServicosModel();
string script = "Select * from tb_Servicos where Id_Servico=@Id_Servico and lower(status)='ativo'";
conexao.LimparParametros();
conexao.Parametros.Add(new SqlParameter()
{
ParameterName = "Id_Servico", Value = pIdServico
});
servicosModel.SetDados(conexao.ExecutarSelect(script));
if (servicosModel.nm_servico == null)
{
return("");
}
else
{
return(servicosModel.nm_servico);
}
}
