public int RetornarIDUsuarioTelaLiberada(int iNroAgente)
{
preditivoDAL DPreditivo = new preditivoDAL();
string sSql = DPreditivo.RetornarIDUsuarioTelaLiberada(iNroAgente);
return(PontoBr.Banco.SqlServer.RetornarDadoUnicoDoBanco(sSql) == "" ? 0 : Convert.ToInt32(PontoBr.Banco.SqlServer.RetornarDadoUnicoDoBanco(sSql)));
}
public DataTable RetornarFilas()
{
preditivoDAL DPreditivo = new preditivoDAL();
string sSql = DPreditivo.RetornarFilas();
return(PontoBr.Banco.SqlServer.RetornarDataTable(sSql));
}
public DataTable RetornarProspectResubmit(int iIDProspect)
{
preditivoDAL DPreditivo = new preditivoDAL();
string sSql = DPreditivo.RetornarProspectResubmit(iIDProspect);
DataTable dataTable = PontoBr.Banco.SqlServer.RetornarDataTable(sSql);
return(dataTable);
}
public preditivo RetornarFila(string sIDFila)
{
preditivo Preditivo = new preditivo();
preditivoDAL DPreditivo = new preditivoDAL();
string sSql = DPreditivo.RetornarFila(sIDFila);
DataTable dataTable = PontoBr.Banco.SqlServer.RetornarDataTable(sSql);
Preditivo.IDCampanha = Convert.ToInt32(dataTable.Rows[0]["IDCampanha"].ToString());
Preditivo.IDFila = dataTable.Rows[0]["IDFila"].ToString();
Preditivo.Fila = dataTable.Rows[0]["Fila"].ToString();
return(Preditivo);
}
public prospect PretornarProspectPreditivoUsuario(int iIDUsuario)
{
preditivoDAL DPreditivo = new preditivoDAL();
string sSql = DPreditivo.PretornarProspectPreditivoUsuario(iIDUsuario);
DataTable dataTable = PontoBr.Banco.SqlServer.RetornarDataTable(sSql);
prospect Prospect = new prospect();
if (dataTable.Rows.Count > 0)
{
Prospect.IDProspect = Convert.ToInt32(dataTable.Rows[0]["IDProspect"].ToString());
Prospect.Telefone1 = Convert.ToDouble(dataTable.Rows[0]["Telefone1"].ToString());
Prospect.Telefone2 = Convert.ToDouble(dataTable.Rows[0]["Telefone2"].ToString());
Prospect.Telefone3 = Convert.ToDouble(dataTable.Rows[0]["Telefone3"].ToString());
Prospect.Nome = dataTable.Rows[0]["Nome"].ToString();
Prospect.CPF_CNPJ = dataTable.Rows[0]["CPF_CNPJ"].ToString();
Prospect.Logradouro = dataTable.Rows[0]["Logradouro"].ToString();
Prospect.Numero = dataTable.Rows[0]["Numero"].ToString();
Prospect.Complemento = dataTable.Rows[0]["Complemento"].ToString();
Prospect.Bairro = dataTable.Rows[0]["Bairro"].ToString();
Prospect.Cidade = dataTable.Rows[0]["Cidade"].ToString();
Prospect.Estado = dataTable.Rows[0]["Estado"].ToString();
Prospect.Email = dataTable.Rows[0]["Email"].ToString();
Prospect.Cep = dataTable.Rows[0]["Cep"].ToString();//rr
Prospect.Campo01 = dataTable.Rows[0]["Campo01"].ToString();
Prospect.Campo02 = dataTable.Rows[0]["Campo02"].ToString();
Prospect.Campo03 = dataTable.Rows[0]["Campo03"].ToString();
Prospect.Campo04 = dataTable.Rows[0]["Campo04"].ToString();
Prospect.Campo05 = dataTable.Rows[0]["Campo05"].ToString();
Prospect.Campo06 = dataTable.Rows[0]["Campo06"].ToString();
Prospect.Campo07 = dataTable.Rows[0]["Campo07"].ToString();
Prospect.Campo08 = dataTable.Rows[0]["Campo08"].ToString();
Prospect.Campo09 = dataTable.Rows[0]["Campo09"].ToString();
Prospect.Campo10 = dataTable.Rows[0]["Campo10"].ToString();
Prospect.IDMailing = Convert.ToInt32(dataTable.Rows[0]["IDMailing"].ToString());
Prospect.IDCampanha = Convert.ToInt32(dataTable.Rows[0]["IDCampanha"].ToString());
Prospect.Mailing = dataTable.Rows[0]["Mailing"].ToString();
}
return(Prospect);
}
