public void GerarMailingCallFlex(int iIDCampanha, int iIDMailing)//CallFlex
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.GerarMailingCallFlex(iIDCampanha, iIDMailing);
PontoBr.Banco.SqlServer.ExecutarSql(sSql, 60 * 10);//Timeout para 5minutos
}
public void AtualizarProspectVonix(int iIDProspect, int iIDStatusVonix)
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.AtualizarProspectVonix(iIDProspect, iIDStatusVonix);
PontoBr.Banco.SqlServer.ExecutarSql(sSql);
}
public DataTable RetornarMailings(bool bAtivo, int iIDCampanha)
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.RetornarMailings(bAtivo, iIDCampanha);
return(PontoBr.Banco.SqlServer.RetornarDataTable(sSql));
}
public int RetornarMailingIndicacaoOperador(int iIDCampanha)
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.RetornarMailingIndicacaoOperador(iIDCampanha);
string sIDMailing = PontoBr.Banco.SqlServer.RetornarDadoUnicoDoBanco(sSql);
return(Convert.ToInt32(sIDMailing == "" ? "0" : sIDMailing));
}
public bool VerificarExistenciaMailing(string sMailing)
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.VerificarExistenciaMailing(sMailing);
return(PontoBr.Banco.SqlServer.VerificarExistenciaDeDados(sSql));
}
public void EditarMailing(mailing Mailing)
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.EditarMailing(Mailing);
PontoBr.Banco.SqlServer.ExecutarSql(sSql);
}
public DataTable RetornarMailings(int iIDCampanha)
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.RetornarMailings(iIDCampanha);
DataTable dataTable = PontoBr.Banco.SqlServer.RetornarDataTable(sSql);
return(dataTable);
}
public DataTable RetornarMailings_DataCadastro()
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.RetornarMailings_DataCadastro();
DataTable dataTable = PontoBr.Banco.SqlServer.RetornarDataTable(sSql);
return(dataTable);
}
public int CadastrarMailing(mailing Mailing, int iIDUsuario)
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.CadastrarMailing(Mailing, iIDUsuario);
return(Convert.ToInt32(PontoBr.Banco.SqlServer.ExecutarSqlComRetornoDeIdentity(sSql)));
}
public DataTable RetornarTodosMailingsAtivos(string sIDCampanha, int iAtivo)
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.RetornarTodosMailingsAtivos(sIDCampanha, iAtivo);
DataTable dataTable = PontoBr.Banco.SqlServer.RetornarDataTable(sSql);
return(dataTable);
}
public DataTable RetornarMailingsInativos(string sIDCampanhas, bool bSomentesAtivos)//r
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.RetornarMailingsInativos(sIDCampanhas, bSomentesAtivos);
DataTable dataTable = PontoBr.Banco.SqlServer.RetornarDataTable(sSql);
return(dataTable);
}
public void SalvarMailingIndicacao(int iIDCampanha, int iIDMailingIndicacao)
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.SalvarMailingIndicacao(iIDCampanha, iIDMailingIndicacao);
PontoBr.Banco.SqlServer.ExecutarSql(sSql);
}
public int RetornarIDMailing(string sMailing)//r
{
mailingDAL DMailing = new mailingDAL();
string sSql = DMailing.RetornarIDMailing(sMailing);
string sIDMailing = PontoBr.Banco.SqlServer.RetornarDadoUnicoDoBanco(sSql);
if (sIDMailing == "")
{
return(0);
}
else
{
return(Convert.ToInt32(sIDMailing));
}
}
public mailing RetornarMailing(int iIDMailing)
{
mailingDAL DMailing = new mailingDAL();
mailing Mailing = new mailing();
string sSql = DMailing.RetornarMailing(iIDMailing);
DataTable dataTable = PontoBr.Banco.SqlServer.RetornarDataTable(sSql);
if (dataTable.Rows.Count > 0)
{
Mailing.IDMailing = Convert.ToInt32(dataTable.Rows[0]["IDMailing"].ToString());
Mailing.Mailing = dataTable.Rows[0]["Mailing"].ToString();
Mailing.IDCampanha = Convert.ToInt32(dataTable.Rows[0]["IDCampanha"].ToString());
Mailing.Ativo = Convert.ToInt32(dataTable.Rows[0]["Ativo"]);
}
return(Mailing);
}
