public IEnumerable <Regional> retornaRegional(Regional entity)
{
return(DataHelper.List <Regional>("PR_REGIONAL_CONSULTAR_DESC",
new SqlParameter("@ds_regional", entity.Descricao)
));
}
public List <Regional> DB_Desplegar_REGIONAL()
{
DA_Regional data = new DA_Regional();
DataTable dt = new DataTable();
dt = data.DA_Desplegar_REGIONAL();
List <Regional> listReg = new List <Regional>();
foreach (DataRow fila in dt.Rows)
{
Regional r = new Regional();
r.Id_Regional = Convert.ToInt32(fila[0]);
r.Tipo = Convert.ToString(fila[1]);
r.Nombre = Convert.ToString(fila[2]);
r.Departamento = Convert.ToString(fila[3]);
r.Ci_Responsable = Convert.ToString(fila[4]);
r.Direccion = Convert.ToString(fila[5]);
r.Telef_Fijo = Convert.ToString(fila[6]);
r.Telef_Movil = Convert.ToString(fila[7]);
r.Region = Convert.ToString(fila[8]);
r.Estado = Convert.ToString(fila[9]);
r.IdRegional_Padre = Convert.ToInt16(fila["IdRegional_Padre"]);
listReg.Add(r);
}
return(listReg);
}
public string InserirReserva(
string chave, string senha, Reserva reserva,
List <IMes> mes, Programa programa, Estrutura estrutura,
Fonte fonte, Regional regional)
{
try
{
var result = DataHelperProdesp.Procedure_InclusaoReserva(
chave, senha, reserva, mes, programa, estrutura, fonte, regional)[0];
//HttpContext.Current.Session["terminal"] = result.outTerminal;
HttpContext.Current.Session["terminal"] = result.outTerminal;
if (result.outErro != "")
{
throw new Exception("Prodesp - " + result.outErro);
}
return(result.outDocsNumeroReserva);
}
catch (Exception ex)
{
throw new Exception(ex.Message.Contains("EntradaCICS_Fora") ? "Erro na comunicação com WebService Prodesp." : ex.Message);
}
}
private void vueloMensual(DtoVuelo dto, AlasPUMEntities context, TimeSpan diferencia, DateTime myDate)
{
for (int i = 0; i < 3; i++)
{
Precio(dto, context);
Regional Reg = new Regional();
Reg.tasaRegional = dto.Regional.tasaRegional;
Reg.documentacion = dto.Regional.documentacion;
int numero = Int32.Parse(dto.numeroVuelo) + i;
Vuelo vuel = new Vuelo();
vuel.numeroVuelo = numero.ToString();
vuel.origen = dto.origen;
vuel.destino = dto.destino;
vuel.dtLlegada = dto.dtLlegada;
vuel.dtSalida = dto.dtSalida;
vuel.HorasTotales = dto.HorasTotales;
vuel.precio = dto.precio;
vuel.numeroAeronaveAsignada = dto.numeroAeronaveAsignada;
vuel.desde = dto.desde;
vuel.hasta = dto.hasta;
vuel.imagen = dto.imagen;
vuel.Regional.Add(Reg);
vuel.dtSalida = myDate.AddMonths(i);
vuel.dtLlegada = (myDate.AddMonths(i) + diferencia);
context.Vuelo.Add(vuel);
}
context.SaveChanges();
}
public List <T> ListarCidadesPor(Regional regional)
{
var query = GetQueryExpression <T>(true);
query.Criteria.Conditions.Add(new ConditionExpression("new_regionalid", ConditionOperator.Equal, regional.Id));
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <Regional> retornaRegional(string desc)
{
Regional reg = new Regional();
reg.Descricao = desc;
return(_regional.retornaRegional(reg).ToList());
}
public ActionResult DeleteConfirmed(int id)
{
Regional regional = db.Regional.Find(id);
db.Regional.Remove(regional);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public object ConsultaEmpenhoSaldo(IRap entity, string key, string password)
{
Regional regional = _regional.Fetch(new Regional {
Id = entity.RegionalId
}).FirstOrDefault();
return(_prodesp.ConsultaEmpenhoSaldo(key, password, entity, regional));
}
public IEnumerable <Regional> Fetch(Regional entity)
{
return(DataHelper.List <Regional>("PR_REGIONAL_CONSULTAR",
new SqlParameter("@ds_regional", entity.Descricao),
new SqlParameter("@id_regional", entity.Id),
new SqlParameter("@cd_orgao", entity.Orgao),
new SqlParameter("@cd_uge", entity.Uge)
));
}
public ActionResult Edit([Bind(Include = "RegionalId,Descripcion")] Regional regional)
{
if (ModelState.IsValid)
{
db.Entry(regional).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(regional));
}
public object ConsultaEmpenhoSaldo(string key, string password, IRap entity, Regional regional)
{
var result = DataHelperProdespLiquidacaoDespesa.Procedure_ConsultaEmpenhoSaldoRAP(key, password, entity, regional) ?? new Procedure_ConsultaEmpenhoSaldoRAPRecordType[] { };
if (!string.IsNullOrEmpty(result[0]?.outErro))
{
throw new Exception($"Prodesp - {result[0]?.outErro}");
}
return(result);
}
public ActionResult Create([Bind(Include = "RegionalId,Descripcion")] Regional regional)
{
if (ModelState.IsValid)
{
db.Regional.Add(regional);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(regional));
}
public List <Regional> Buscar(Regional obj)
{
try
{
return(_regional.Fetch(obj).ToList());
}
catch (Exception ex)
{
throw SaveLog(ex);
}
}
/// <summary>
/// Gets the regions to find the Pokémon as a string.
/// </summary>
/// <returns>Pokémon regions as a string.</returns>
public string RegionalToString()
{
List <string> regions = Regional.Split(',').ToList();
StringBuilder sb = new StringBuilder();
foreach (string region in regions)
{
sb.AppendLine(region);
}
return(sb.ToString().Trim());
}
// GET: /Regional/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Regional regional = db.Regional.Find(id);
if (regional == null)
{
return(HttpNotFound());
}
return(View(regional));
}
public bool Salvar(Regional regional, bool salvar)
{
try
{
if (salvar)
{
return(true);
}
return(false);
}
catch (SqlException exception)
{
throw exception;
}
}
public async Task <IActionResult> CreateRegional([FromBody] Common.Models.RegionalCommon RegionalCommon)
{
if (!ModelState.IsValid)
{
return(this.BadRequest(ModelState));
}
var entityRegional = new Regional
{
Nombre = RegionalCommon.Nombre
};
var newRegional = await this.RegionalRepository.CreateAsync(entityRegional);
return(Ok(newRegional));
}
public bool VueloRegional(DtoVuelo dto, List <string> days)
{
bool msg = true;
using (AlasPUMEntities context = new AlasPUMEntities())
{
using (TransactionScope scope = new TransactionScope())
{
try
{
Regional Reg = new Regional();
Reg.tasaRegional = dto.Regional.tasaRegional;
Reg.documentacion = dto.Regional.documentacion;
Vuelo vuel = new Vuelo();
vuel.numeroVuelo = dto.numeroVuelo;
vuel.origen = dto.origen;
vuel.destino = dto.destino;
vuel.dtLlegada = dto.dtLlegada;
vuel.dtSalida = dto.dtSalida;
vuel.HorasTotales = dto.HorasTotales;
vuel.precio = dto.precio;
vuel.numeroAeronaveAsignada = dto.numeroAeronaveAsignada;
vuel.desde = dto.desde;
vuel.hasta = dto.hasta;
vuel.imagen = dto.imagen;
vuel.Regional.Add(Reg);
context.Vuelo.Add(vuel);
context.SaveChanges();
scope.Complete();
}
catch (Exception ex)
{
scope.Dispose();
return(msg = false);
}
return(msg = true);
}
}
}
public static Regional MapToEntity(DtoRegional dto)
{
Regional entity = new Regional();
entity.numVueloR = dto.numeroVuelo;
entity.Vuelo.origen = dto.origen;
entity.Vuelo.destino = dto.destino;
entity.Vuelo.dtLlegada = dto.dtLlegada;
entity.Vuelo.dtSalida = dto.dtSalida;
entity.Vuelo.HorasTotales = dto.HorasTotales;
entity.Vuelo.precio = dto.precio;
entity.tasaRegional = dto.tasaRegional;
entity.documentacion = dto.documentacion;
entity.Vuelo.numeroAeronaveAsignada = dto.numeroAeronaveAsignada;
entity.Vuelo.imagen = dto.imagen;
return(entity);
}
public static DtoRegional MapToDto(Regional entity)
{
DtoRegional dto = new DtoRegional();
dto.numeroVuelo = entity.numVueloR;
dto.origen = entity.Vuelo.origen;
dto.destino = entity.Vuelo.destino;
dto.dtLlegada = entity.Vuelo.dtLlegada;
dto.dtSalida = entity.Vuelo.dtSalida;
dto.HorasTotales = entity.Vuelo.HorasTotales;
dto.precio = entity.Vuelo.precio;
dto.documentacion = entity.documentacion;
dto.tasaRegional = entity.tasaRegional;
dto.numeroAeronaveAsignada = entity.Vuelo.numeroAeronaveAsignada;
dto.imagen = entity.Vuelo.imagen;
return(dto);
}
public List <Municipio> ListarCidadesPor(string regionalId)
{
try
{
if (string.IsNullOrEmpty(regionalId))
{
throw new Exception("O id da regional do usuário está em branco é ou nulo");
}
var regional = new Regional(nomeOrganizacao, false)
{
Id = new Guid(regionalId)
};
return((new Domain.Servicos.RepositoryService()).Municipio.ListarCidadesPor(regional));
}
catch (Exception ex)
{
throw ex;
}
}
private void vueloSemanal(List <string> days, List <DateTime> colDate, DtoVuelo dto, AlasPUMEntities context, TimeSpan diferencia)
{
foreach (string item in days)
{
for (int i = 1; i <= 5; i++)
{
Precio(dto, context);
if (item == colDate[i].DayOfWeek.ToString())
{
Regional Reg = new Regional();
Reg.tasaRegional = dto.Regional.tasaRegional;
Reg.documentacion = dto.Regional.documentacion;
int numero = Int32.Parse(dto.numeroVuelo) + i;
Vuelo vuel = new Vuelo();
vuel.numeroVuelo = numero.ToString();
vuel.origen = dto.origen;
vuel.destino = dto.destino;
vuel.dtLlegada = dto.dtLlegada;
vuel.dtSalida = dto.dtSalida;
vuel.HorasTotales = dto.HorasTotales;
vuel.precio = dto.precio;
vuel.numeroAeronaveAsignada = dto.numeroAeronaveAsignada;
vuel.desde = dto.desde;
vuel.hasta = dto.hasta;
vuel.imagen = dto.imagen;
vuel.Regional.Add(Reg);
vuel.dtSalida = (colDate[i]);
vuel.dtLlegada = (colDate[i] + diferencia);
context.Vuelo.Add(vuel);
}
}
context.SaveChanges();
}
}
internal Boolean Gravar(Regional Regional)
{
b.getComandoSQL().Parameters.Clear();
if (Regional.GetCodigo() == 0)
{
b.getComandoSQL().CommandText = @"insert into Regional (reg_descricao, reg_stativo, pes_codigo) values(@descricao, @ativo, @pessoa);";
}
else
{
b.getComandoSQL().CommandText = @"update Regional set reg_descricao = @descricao, pes_codigo = @pessoa, reg_stativo = @ativo where reg_codigo = @codigo;";
b.getComandoSQL().Parameters.AddWithValue("@codigo", Regional.GetCodigo());
}
b.getComandoSQL().Parameters.AddWithValue("@descricao", Regional.GetDescricao());
b.getComandoSQL().Parameters.AddWithValue("@ativo", Regional.GetStAtivo());
b.getComandoSQL().Parameters.AddWithValue("@pessoa", Regional.GetPessoa().GetCodigo());
return(b.ExecutaComando() == 1);
}
public OutRegional GetRegionals()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutRegional response = new OutRegional();
var ora = new OracleServer(connectionString);
Regional regional;
List <Regional> list = new List <Regional>();
string command = string.Empty;
try
{
command = " SELECT CODIGO_REGIONAL, NOMBRE FROM BBS_LIQCOM_V_REGIONAL_BAYP ";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
regional = new Regional();
regional.Code = DBNull.Value.Equals(rdr["CODIGO_REGIONAL"]) ? 0 : double.Parse(rdr["CODIGO_REGIONAL"].ToString());
regional.Name = DBNull.Value.Equals(rdr["NOMBRE"]) ? string.Empty : rdr["NOMBRE"].ToString();
list.Add(regional);
}
rdr.Close();
response.lstRegionals = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ParametersDAO.GetRegionals", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
public string InserirReservaReforco(
string chave, string senha, ReservaReforco reforco,
List <IMes> reforcoMes, Regional regional)
{
try
{
var result = DataHelperProdesp.Procedure_ReservaReforco(chave, senha, reforco, reforcoMes)[0];
HttpContext.Current.Session["terminal"] = result.outTerminal;
if (result.outErro != "")
{
throw new Exception("Prodesp - " + result.outErro);
}
return(result.outSucesso);
}
catch (Exception ex)
{
throw new Exception(ex.Message.Contains("EntradaCICS_Fora")
? "Erro na comunicação com WebService Prodesp."
: ex.Message);
}
}
public int Gravar(int Codigo, string Descricao, Boolean StAtivo, int Operacao, int PesCodigo)
{
Regional Val = new Regional();
if (Codigo == 0) //inserção
{
if (Val.BuscarRegional(Descricao) == null) //tem que tratar operacao (Alterar)
{
Regional Regional = new Regional(Codigo, Descricao, StAtivo, PesCodigo, "");
if (Regional.Gravar())
{
return(10); //gravado
}
else
{
return(-10); //erro gravacao
}
}
else
{
return(-20); //regional ja existe
}
}
else //alteração
{
Regional Regional = new Regional(Codigo, Descricao, StAtivo, PesCodigo, "");
if (Regional.Gravar())
{
return(10); //gravado
}
else
{
return(-10);
}
}
}
private void TransmitirConfirmacaoProdesp(ConfirmacaoPagamento entity, ChaveCicsmo cicsmo, ref bool todosTransmitidos, ref string verificaNumeroGerador, Regional orgao, ConfirmacaoPagamentoItem item)
{
if (item.NumeroDocumentoGerador.Substring(0, 17) != verificaNumeroGerador)
{
ConfirmacaoPagamento confirmarPagamentoUnico = new ConfirmacaoPagamento();
confirmarPagamentoUnico.DataConfirmacao = entity.DataConfirmacao;
confirmarPagamentoUnico.AnoReferencia = entity.AnoReferencia;
confirmarPagamentoUnico.IdTipoDocumento = Convert.ToInt16(item.NumeroOp.Substring(4, 1));
confirmarPagamentoUnico.NumeroOP = item.NumeroOp;
confirmarPagamentoUnico.TipoPagamento = entity.TipoPagamento;
orgao.Id = Convert.ToInt16(item.NumeroOp.Substring(2, 2));
var result = DataHelperProdespPagamentoContaUnica.Procedure_ConfirmacaoPagtoOPApoio(cicsmo.Chave, cicsmo.Senha, confirmarPagamentoUnico, orgao);
verificaNumeroGerador = item.NumeroDocumentoGerador.Substring(0, 17);
if (!string.IsNullOrWhiteSpace(result[0].outErro))
{
confirmarPagamentoUnico.DataTransmitidoProdesp = DateTime.Now;
confirmarPagamentoUnico.StatusProdesp = "E";
confirmarPagamentoUnico.TransmitidoProdesp = false;
confirmarPagamentoUnico.NumeroDocumento = item.NumeroNlDocumento;
confirmarPagamentoUnico.Id = entity.Id;
confirmarPagamentoUnico.MensagemServicoProdesp = result[0].outErro;
confirmarPagamentoUnico.NumeroDocumentoItem = item.NumeroDocumentoGerador;
}
else
{
confirmarPagamentoUnico.DataTransmitidoProdesp = DateTime.Now;
confirmarPagamentoUnico.StatusProdesp = "S";
confirmarPagamentoUnico.TransmitidoProdesp = true;
confirmarPagamentoUnico.NumeroDocumento = entity.NumeroDocumento;
confirmarPagamentoUnico.Id = entity.Id;
confirmarPagamentoUnico.NumeroDocumentoItem = item.NumeroDocumentoGerador;
}
this.AtualizarPagamento(confirmarPagamentoUnico);
if (todosTransmitidos)
{
todosTransmitidos = confirmarPagamentoUnico.StatusProdesp.Equals("S");
}
}
}
private static Procedure_InclusaoReservaFiltersType CreateReservaFilterType(string key, string password, Reserva entity, IEnumerable <IMes> months, Programa program, Estrutura structure, Fonte source, Regional regional)
{
var inQuotaReserva_1 = Convert.ToString(months?.Where(x => B1.Contains(x.Descricao)).Sum(y => y.ValorMes));
var inQuotaReserva_2 = Convert.ToString(months?.Where(x => B2.Contains(x.Descricao)).Sum(y => y.ValorMes));
var inQuotaReserva_3 = Convert.ToString(months?.Where(x => B3.Contains(x.Descricao)).Sum(y => y.ValorMes));
var inQuotaReserva_4 = Convert.ToString(months?.Where(x => B4.Contains(x.Descricao)).Sum(y => y.ValorMes));
var inTotalReserva = months?.Sum(x => x.ValorMes).ToString();
return(new Procedure_InclusaoReservaFiltersType
{
inOperador = key,
inChave = password,
inAnoRefRes = entity?.AnoExercicio.ToString().Substring(2, 2),
inAnoExercicio = DateTime.Now.Month <= 2 ? entity?.AnoExercicio.ToString().Substring(2, 2) : default(string),
inCFPRes_1 = program?.Cfp?.Substring(0, 2),
inCFPRes_2 = program?.Cfp?.Substring(2, 3),
inCFPRes_3 = program?.Cfp?.Substring(5, 4),
inCFPRes_4 = program?.Cfp?.Substring(9, 4),
inCFPRes_5 = entity?.OrigemRecurso?.Substring(1, 2) + "00" ?? default(string),
inCEDRes_1 = structure?.Natureza?.Substring(0, 1),
inCEDRes_2 = structure?.Natureza?.Substring(1, 1),
inCEDRes_3 = structure?.Natureza?.Substring(2, 1),
inCEDRes_4 = structure?.Natureza?.Substring(3, 1),
inCEDRes_5 = structure?.Natureza?.Substring(4, 2),
inOrgao = regional?.Descricao?.Substring(2, 2),
inCodAplicacaoRes = entity?.Obra?.ToString(),
inOrigemRecursoRes = entity?.OrigemRecurso?.Substring(1, 2),
inDestinoRecursoRes = entity?.DestinoRecurso,
inNumProcessoRes = entity?.Processo,
inAutoProcFolhasRes = entity?.AutorizadoSupraFolha,
inCodEspecDespesaRes = entity?.EspecificacaoDespesa,
inEspecifDespesaRes = entity?.DescEspecificacaoDespesa.Replace(";", string.Empty),
inAutoPorAssRes = entity?.AutorizadoAssinatura,
inAutoPorGrupoRes = entity?.AutorizadoGrupo,
inAutoPorOrgaoRes = entity?.AutorizadoOrgao,
inExamPorAssRes = entity?.ExaminadoAssinatura,
inExamPorGrupoRes = entity?.ExaminadoGrupo,
inExamPorOrgaoRes = entity?.ExaminadoOrgao,
inRespEmissaoAssRes = entity?.ResponsavelAssinatura,
inRespEmissGrupoRes = entity?.ResponsavelGrupo,
inRespEmissOrgaoRes = entity?.ResponsavelOrgao,
inIdentContratoANORes = entity?.Contrato?.Substring(0, 2),
inIdentContratoORGAORes = entity?.Contrato?.Substring(2, 2),
inIdentContratoNUMRes = entity?.Contrato?.Substring(4, 5),
inIdentContratoDCRes = entity?.Contrato?.Substring(9, 1),
inQuotaReserva_1 = inQuotaReserva_1?.Length < 3 ? "0" + inQuotaReserva_1 : inQuotaReserva_1,
inQuotaReserva_2 = inQuotaReserva_2?.Length < 3 ? "0" + inQuotaReserva_2 : inQuotaReserva_2,
inQuotaReserva_3 = inQuotaReserva_3?.Length < 3 ? "0" + inQuotaReserva_3 : inQuotaReserva_3,
inQuotaReserva_4 = inQuotaReserva_4?.Length < 3 ? "0" + inQuotaReserva_4 : inQuotaReserva_4,
inTotalReserva = inTotalReserva?.Length < 3 ? "0" + inTotalReserva : inTotalReserva,
});
}
public static Procedure_InclusaoReservaRecordType[] Procedure_InclusaoReserva(string key, string password, Reserva entity, IEnumerable <IMes> months, Programa program, Estrutura structure, Fonte source, Regional regional)
{
return(new WSProdespReserva().Procedure_InclusaoReserva(
CreateReservaFilterType(key, password, entity, months, program, structure, source, regional),
new ModelVariablesType(),
new EnvironmentVariablesType()));
}
private void ProcessRegionalUpdateMessage(string msg, string[] values)
{
var regionUpdateMessage = RegionalUpdateMessage.CreateRegionalUpdateMessage(values);
Regional?.Invoke(regionUpdateMessage);
}
