public Irmao PesquisarporNome(ref IUnitOfWork unitOfWork, string nome, int?id = null) { return(unitOfWork.Connection.Query <Irmao>( (id != null) ? @"SELECT * FROM dbo.[Irmao] WHERE UPPER(Nome) = Upper(@Nome) and Codigo <> @Codigo " : "SELECT * FROM dbo.[Irmao] WHERE UPPER(Nome) = Upper(@Nome) ", param: new { @Nome = nome, @Codigo = (IntValues.IsNullorDefault(id)) ? (int?)null : id }, transaction: unitOfWork.Transaction ).FirstOrDefault()); }
public Grupo PesquisarporNomeGrupo(ref IUnitOfWork unitOfWork, string nome, int?id = null) { return(unitOfWork.Connection.Query <Grupo>( (id != null) ? @"SELECT G.* FROM dbo.[Grupo] G WHERE Nome = @Nome and G.Codigo <> @Codigo " : @" SELECT G.* FROM dbo.[Grupo] G WHERE Nome = @Nome ", param: new { @Nome = nome, @Codigo = (IntValues.IsNullorDefault(id)) ? (int?)null : id }, transaction: unitOfWork.Transaction ).FirstOrDefault()); }
public DataEvento PesquisarporDataeCongregacao(ref IUnitOfWork unitOfWork, DataEvento model, int?id = null) { return(unitOfWork.Connection.Query <DataEvento>( (id != null) ? @"SELECT DE.* FROM dbo.[DataEvento] DE WHERE Data = CAST(@Data As Date) and CongregacaoId = @CongregacaoId and DE.Codigo <> @Codigo " : @" SELECT DE.* FROM dbo.[DataEvento] DE WHERE Data = CAST(@Data As Date) and CongregacaoId = @CongregacaoId ", param: new { @Data = model.Data, @CongregacaoId = model.CongregacaoId, @Codigo = (IntValues.IsNullorDefault(id)) ? (int?)null : id }, transaction: unitOfWork.Transaction ).FirstOrDefault()); }
public Irmao PesquisarporEmail(ref IUnitOfWork unitOfWork, string email, int?id = null) { return(unitOfWork.Connection.Query <Irmao>( (id != null) ? @"SELECT I.*, C.Nome As CongregacaoNome, C.ExibirOracaoInicial FROM dbo.[Irmao] I INNER JOIN Congregacao C ON C.Codigo = I.CongregacaoId WHERE Email = @Email and I.Codigo <> @Codigo " : @" SELECT I.*, C.Nome As CongregacaoNome, C.ExibirOracaoInicial FROM dbo.[Irmao] I INNER JOIN Congregacao C ON C.Codigo = I.CongregacaoId WHERE Email = @Email ", param: new { @Email = email, @Codigo = (IntValues.IsNullorDefault(id)) ? (int?)null : id }, transaction: unitOfWork.Transaction ).FirstOrDefault()); }