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