public bool setReembolsoStatusAP(ClsIncidente incidente) //Chamada pels APP
{
ClsIncidenteDao incd = new ClsIncidenteDao();
ClsIncidente inc = incidente;
if (this.verifyUpdateStatus(inc))
{
return(incd.setReembolsoStatusAP(inc));
}
else
{
return(false);
}
}
public List <ClsIncidente> setReembolsoStatusAP() //Chamada pels APP
{
ClsIncidenteDao incd = new ClsIncidenteDao();
List <ClsIncidente> incs = this.getReembolsosPendentesEN();
List <ClsIncidente> incsAlterados = new List <ClsIncidente>();
foreach (ClsIncidente inc in incs)
{
if (this.verifyUpdateStatus(inc))
{
if (incd.setReembolsoStatusAP(inc))
{
incsAlterados.Add(inc);
}
}
}
return(incsAlterados);
}
/// <summary>
/// Verifica novos incidentes no ORACLE e cadastra no SQL SERVER, tabela TAB_MONITORACAO
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public List <ClsIncidente> getInsertNewsIncidentesForMonitoracao()
{
List <ClsIncidente> lstIncs = new List <ClsIncidente>();
ClsIncidenteDao incd = new ClsIncidenteDao();
DataSet dt = incd.getReembolsosNovos();
ClsIncidente inc;
if (dt != null)
{
if (dt.Tables.Count > 0)
{
if (dt.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dt.Tables[0].Rows)
{
inc = new ClsIncidente();
inc.IncCliId = int.Parse(row["CLI_ID"].ToString());
inc.IncId = long.Parse(row["INC_ID"].ToString());
inc.IncEquipamento = long.Parse(row["EQP_ID"].ToString());
inc.IncDtAbert = DateTime.Parse(row["INC_DT_ABERT"].ToString());
inc.IncCartao = long.Parse(row["INC_CARTAO"].ToString());
inc.IncStatus = row["INC_STATUS"].ToString();
inc.IncNsuOrigem = row["INC_NSU_ORIGEM"].ToString();
inc.IncNsuResolucao = row["INC_NSU_RESOLUCAO"].ToString();
inc.IncValor = decimal.Parse(row["INC_VALOR"].ToString());
inc.IncMotivo = row["INC_MOTIVO"].ToString();
lstIncs.Add(inc);
}
}
}
}
ClsParametroBus pb = new ClsParametroBus();
if (lstIncs.Count > 0)
{
pb.setValorParam("COD_MAX_REEMBOLSO_RIOCARD", lstIncs[lstIncs.Count - 1].IncId.ToString());
insertNewsIncidentesMonitoracao(lstIncs);
}
return(lstIncs);
}
public List <ClsIncidente> getReembolsosPendentesEN()
{
List <ClsIncidente> lstIncs = new List <ClsIncidente>();
ClsIncidenteDao incd = new ClsIncidenteDao();
DataSet dt = incd.getReembolsosPendentesEN();
ClsIncidente inc;
try
{
if (dt != null)
{
if (dt.Tables.Count > 0)
{
if (dt.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dt.Tables[0].Rows)
{
inc = new ClsIncidente();
inc.IncCliId = int.Parse(row["CLI_ID"].ToString());
inc.IncId = long.Parse(row["INC_ID"].ToString());
inc.IncDtAbert = DateTime.Parse(row["INC_DT_ABERT"].ToString());
inc.IncCartao = long.Parse(row["INC_CARTAO"].ToString());
inc.IncStatus = row["INC_STATUS"].ToString();
inc.IncNsuOrigem = row["INC_NSU_ORIGEM"].ToString();
inc.IncNsuResolucao = row["INC_NSU_RESOLUCAO"].ToString();
inc.IncValor = decimal.Parse(row["INC_VALOR"].ToString());
lstIncs.Add(inc);
}
}
}
}
return(lstIncs);
}
catch (Exception ex)
{
throw ex;
return(null);
}
}
