private static Procedure_InclusaoReservaFiltersType GerarReservaFiltersType(string chave, string senha, Reserva reserva, List <IMes> mes, Programa programa, Estrutura estrutura, Fonte fonte, Regional regional) { var bim1 = new string[] { "01", "02", "03" }; var bim2 = new string[] { "04", "05", "06" }; var bim3 = new string[] { "07", "08", "09" }; var bim4 = new string[] { "10", "11", "12" }; var inQuotaReserva1 = mes?.Where(x => bim1.Contains(x.Descricao)).Sum(y => y.ValorMes).ToString(); var inQuotaReserva2 = mes?.Where(x => bim2.Contains(x.Descricao)).Sum(y => y.ValorMes).ToString(); var inQuotaReserva3 = mes?.Where(x => bim3.Contains(x.Descricao)).Sum(y => y.ValorMes).ToString(); var inQuotaReserva4 = mes?.Where(x => bim4.Contains(x.Descricao)).Sum(y => y.ValorMes).ToString(); var inTotalReserva = mes?.Sum(x => x.ValorMes).ToString(); Procedure_InclusaoReservaFiltersType reservaFiltersType = new Procedure_InclusaoReservaFiltersType { inOperador = chave, inChave = senha, inAnoRefRes = reserva?.AnoExercicio.ToString().Substring(2, 2), inAnoExercicio = DateTime.Now.Month <= 2 ? reserva?.AnoExercicio.ToString().Substring(2, 2) : null, inCFPRes_1 = programa?.Cfp?.Substring(0, 2), inCFPRes_2 = programa?.Cfp?.Substring(2, 3), inCFPRes_3 = programa?.Cfp?.Substring(5, 4), inCFPRes_4 = programa?.Cfp?.Substring(9, 4), inCFPRes_5 = reserva?.OrigemRecurso?.Substring(1, 2) + "00" ?? string.Empty, inCEDRes_1 = estrutura?.Natureza?.Substring(0, 1), inCEDRes_2 = estrutura?.Natureza?.Substring(1, 1), inCEDRes_3 = estrutura?.Natureza?.Substring(2, 1), inCEDRes_4 = estrutura?.Natureza?.Substring(3, 1), inCEDRes_5 = estrutura?.Natureza?.Substring(4, 2), inOrgao = regional?.Descricao?.Substring(2, 2), inCodAplicacaoRes = reserva?.Obra?.ToString(), inOrigemRecursoRes = reserva?.OrigemRecurso?.Substring(1, 2), inDestinoRecursoRes = reserva?.DestinoRecurso, inNumProcessoRes = reserva?.Processo, inAutoProcFolhasRes = reserva?.AutorizadoSupraFolha, inCodEspecDespesaRes = reserva?.EspecificacaoDespesa, inEspecifDespesaRes = reserva?.DescEspecificacaoDespesa.Replace(";", "").Replace(";", ""), inAutoPorAssRes = reserva?.AutorizadoAssinatura, inAutoPorGrupoRes = reserva?.AutorizadoGrupo, inAutoPorOrgaoRes = reserva?.AutorizadoOrgao, inExamPorAssRes = reserva?.ExaminadoAssinatura, inExamPorGrupoRes = reserva?.ExaminadoGrupo, inExamPorOrgaoRes = reserva?.ExaminadoOrgao, inRespEmissaoAssRes = reserva?.ResponsavelAssinatura, inRespEmissGrupoRes = reserva?.ResponsavelGrupo, inRespEmissOrgaoRes = reserva?.ResponsavelOrgao, inIdentContratoANORes = reserva?.Contrato?.Substring(0, 2), inIdentContratoORGAORes = reserva?.Contrato?.Substring(2, 2), inIdentContratoNUMRes = reserva?.Contrato?.Substring(4, 5), inIdentContratoDCRes = reserva?.Contrato?.Substring(9, 1), inQuotaReserva_1 = inQuotaReserva1?.Length < 3 ? "0" + inQuotaReserva1 : inQuotaReserva1, inQuotaReserva_2 = inQuotaReserva2?.Length < 3 ? "0" + inQuotaReserva2 : inQuotaReserva2, inQuotaReserva_3 = inQuotaReserva3?.Length < 3 ? "0" + inQuotaReserva3 : inQuotaReserva3, inQuotaReserva_4 = inQuotaReserva4?.Length < 3 ? "0" + inQuotaReserva4 : inQuotaReserva4, inTotalReserva = inTotalReserva?.Length < 3 ? "0" + inTotalReserva : inTotalReserva, inImprimirRes = "A" }; return(reservaFiltersType); }
private static Procedure_InclusaoReservaFiltersType GerarReservaFiltersType(Model.Entity.Reserva.Reserva reserva, List <ReservaMes> reservaMes, Programa programa, Estrutura estrutura, Fonte fonte) { var regional = App.RegionalService.Buscar(new Regional()).ToList(); var reservaFiltersType = new Procedure_InclusaoReservaFiltersType { inOperador = "roque 00", inChave = "manurafa2016", inAnoRefRes = reserva.AnoReferencia.ToString().Substring(2, 2), inCFPRes_1 = programa.Cfp.Substring(0, 2), inCFPRes_2 = programa.Cfp.Substring(2, 3), inCFPRes_3 = programa.Cfp.Substring(5, 4), inCFPRes_4 = programa.Cfp.Substring(9, 4), inCFPRes_5 = programa.Cfp.Substring(13, 2) + "00", inCEDRes_1 = estrutura.Natureza.ToString().Substring(0, 1), inCEDRes_2 = estrutura.Natureza.ToString().Substring(1, 1), inCEDRes_3 = estrutura.Natureza.ToString().Substring(2, 1), inCEDRes_4 = estrutura.Natureza.ToString().Substring(3, 1), inCEDRes_5 = estrutura.Natureza.ToString().Substring(4, 2), inOrgao = regional.FirstOrDefault(x => x.Id == reserva.Regional).Descricao.Substring(2, 2), inCodAplicacaoRes = estrutura.Aplicacao.ToString(), inOrigemRecursoRes = reserva.OrigemRecurso, inDestinoRecursoRes = reserva.DestinoRecurso, inNumProcessoRes = reserva.Processo, inAutoProcFolhasRes = reserva.AutorizadoSupraFolha, inCodEspecDespesaRes = reserva.EspecificacaoDespesa, inEspecifDespesaRes = reserva.DescEspecificacaoDespesa, inAutoPorAssRes = reserva.AutorizadoAssinatura, inAutoPorGrupoRes = reserva.AutorizadoGrupo, inAutoPorOrgaoRes = reserva.AutorizadoOrgao, inExamPorAssRes = reserva.ExaminadoAssinatura, inExamPorGrupoRes = reserva.ExaminadoGrupo, inExamPorOrgaoRes = reserva.ExaminadoOrgao, inRespEmissaoAssRes = reserva.ResponsavelAssinatura, inRespEmissGrupoRes = reserva.ResponsavelGrupo, inRespEmissOrgaoRes = reserva.ResponsavelOrgao, inIdentContratoANORes = reserva.Contrato == null ? "" : reserva.Contrato.ToString().Substring(0, 2), inIdentContratoORGAORes = reserva.Contrato == null ? "" : reserva.Contrato.ToString().Substring(2, 2), inIdentContratoNUMRes = reserva.Contrato == null ? "" : reserva.Contrato.ToString().Substring(4, 5), inIdentContratoDCRes = reserva.Contrato == null ? "" : reserva.Contrato.ToString().Substring(9, 1), inImprimirRes = "N", inQuotaReserva_1 = reservaMes.Where(x => x.Descricao.Contains("01") || x.Descricao.Contains("02") || x.Descricao.Contains("03")).Sum(y => y.ValorMes).ToString(), inQuotaReserva_2 = reservaMes.Where(x => x.Descricao.Contains("04") || x.Descricao.Contains("05") || x.Descricao.Contains("06")).Sum(y => y.ValorMes).ToString(), inQuotaReserva_3 = reservaMes.Where(x => x.Descricao.Contains("07") || x.Descricao.Contains("08") || x.Descricao.Contains("09")).Sum(y => y.ValorMes).ToString(), inQuotaReserva_4 = reservaMes.Where(x => x.Descricao.Contains("10") || x.Descricao.Contains("11") || x.Descricao.Contains("12")).Sum(y => y.ValorMes).ToString(), inTotalReserva = reservaMes.Sum(x => x.ValorMes).ToString() }; return(reservaFiltersType); }