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