//Alterado para SqlServer
private bool ConfigIncrementoCartao(TipoCartao cartao)
{
BD BD = new BD();
bool config = (BD.ExecuteScalar("select config.INCREMENTCODCARTIMP from config", null).ToString().ToUpper() == "S");
if (config)
{
if (cartao == 0)
{
IncrementoTitular();
}
else
{
string cartaoDep;
cartaoDep = BD.ExecuteScalar("select codigocartaoimpdep from config", null).ToString();
if (cartaoDep != "")
{
ConfigCodigoIncremento = (Convert.ToInt32(cartaoDep) + 1).ToString();
BD.ExecuteNoQuery(" update config set codigocartaoimpdep = " + ConfigCodigoIncremento + "", null);
}
else
{
IncrementoTitular();
}
}
}
return(config);
}
public static bool insereCupomUltimosCupons(string cupom, string serialNumber)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@serialNumber", serialNumber));
BD BD = new BD();
//deletando possível cupom existente
BD.ExecuteScalar("delete from webpos_ultimos_cupons where serial_number = @serialNumber", ps);
ps.Add(new Fields("@cupom", cupom));
//inserindo o novo cupom
BD.ExecuteScalar("insert into webpos_ultimos_cupons values(@cupom,@serialNumber)", ps);
return(Convert.ToInt32(BD.ExecuteScalar("select count(*) from webpos_ultimos_cupons where cupom = @cupom and serial_number = @serialNumber", ps)) > 0);
}
private static bool codCardTimpExiste(string codCardTimp)
{
BD BD = new BD();
string s = (BD.ExecuteScalar("select coalesce(codcartimp,'') as codcartimp from cartoes where codcartimp = '" + codCardTimp.ToString() + "'", null) == null ? "" : codCardTimp);
return(s.Equals(codCardTimp));
}
//Alterado para SqlServer
public static Double GetCupom(int conv_id, int ano, int mes)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("conv_id", conv_id));
BD BD = new BD();
int empresId = BD.ExecuteScalar(-1, "select top 1 empres_id from conveniados where apagado <> 'S' and conv_id = @conv_id", ps);
ps.Add(new Fields("fechamento", DALEmpresa.getDataFechamento(empresId, mes, ano)));
ps.Add(new Fields("cod_limite", "N"));
DataTable dt = new DataTable();
dt = BD.GetDataTable("exec SALDO_PROXFECHA_CONV " + conv_id + ",N,'" + DALEmpresa.getDataFechamento(empresId, mes, ano) + "'", null);
if (dt.Rows.Count != 0)
{
return(Convert.ToDouble(dt.Rows[0]["TOTAL"]));
}
else
{
return(0);
}
//return Convert.ToDouble(BD.ExecuteScalar("select coalesce(sum(total),0.00) total_saldo from saldo_conv(@conv_id) where fechamento = @fechamento", ps));
}
private void IncrementoTitular()
{
BD BD = new BD();
ConfigCodigoIncremento = (Int64.Parse(BD.ExecuteScalar("select codigocartaoimp from config", null).ToString()) + 1).ToString();
BD.ExecuteNoQuery(" update config set codigocartaoimp = " + ConfigCodigoIncremento + "", null);
}
public static Boolean CredenciadoAceitaParcelamento(int cred_id)
{
string sql = "SELECT ACEITA_PARC from CREDENCIADOS where cred_id = " + cred_id + "";
BD bd = new BD();
return(bd.ExecuteScalar(sql, null).Equals("S") ? true : false);
}
//Alterado para SqlServer
public static DateTime ProximoFechamento(int empres_id)
{
//Pega a proxima data de fechamento menos um dia depois da data atual
BD BD = new BD();
return((DateTime)BD.ExecuteScalar("SELECT MIN(data_fecha) FROM dia_fecha WHERE data_fecha >= current_timestamp AND empres_id = " + empres_id, null));
}
public static string EmpresIdPorCartao(string codcartimp)
{
BD BD = new BD();
SqlParamsList param = new SqlParamsList();
param.Add(new Fields("codcartimp", codcartimp));
return(BD.ExecuteScalar("", "SELECT FIRST 1 CONV.EMPRES_ID FROM CONVENIADOS CONV WHERE CONV.APAGADO <> 'S' and CONV.CONV_ID = (SELECT CARD.CONV_ID FROM CARTOES CARD WHERE CARD.APAGADO <> 'S' AND CARD.CODCARTIMP = @codcartimp)", param));
}
//Alterado para SqlServer
public static int CredID(int pos_serial_number)
{
string sql = " SELECT CRED_ID FROM POS WHERE POS_SERIAL_NUMBER = '" + pos_serial_number + "'";
BD BD = new BD();
int cred_id = (int)BD.ExecuteScalar(sql, null);
return(cred_id);
}
public static bool getAlteraLimiteSite(int empres_id)
{
bool status = false;
BD bd = new BD();
String sql = "select coalesce(altera_limite_site,'N') from empresas where EMPRES_ID = " + empres_id;
if ("S".Equals(bd.ExecuteScalar(sql, null)))
{
status = true;
}
else if ("N".Equals(bd.ExecuteScalar(sql, null)) || "".Equals(bd.ExecuteScalar(sql, null)))
{
status = false;
}
return(status);
}
/// <summary>
/// Método que verifica se o credenciado(estabelecimento)
/// está liberado para realizar vendas parceladas para uma determinada empresa do
/// tipo credito DROGABELLA
/// </summary>
/// <param name="cred_id"></param>
/// <param name="empres_id"></param>
/// <returns>bool</returns>
public static bool GetVerificaCredLiberadoParcelamentoEspecifico(int cred_id, int empres_id)
{
bool status = false;
BD bd = new BD();
String sql = "select coalesce ((select case cred_id when " + cred_id + " then 'S' else 'N' end from EMP_CRED_DESCONTO_ESPECIFICO WHERE EMPRES_ID = " + empres_id + "),'N')";
if ("S".Equals(bd.ExecuteScalar(sql, null)))
{
status = true;
}
else if ("N".Equals(bd.ExecuteScalar(sql, null)) || "".Equals(bd.ExecuteScalar(sql, null)))
{
status = false;
}
return(status);
}
//Alterado para SqlServer
public static int PagaCred(int cred_id)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@cred_id", cred_id));
BD BD = new BD();
return(BD.ExecuteScalar(-1, "select paga_cred_por_id from credenciados where cred_id = @cred_id", ps));
}
public static int PagamentoCredPor(int cred_id)
{
string sql;
sql = "Select paga_cred_por_id FROM credenciados WHERE cred_id = " + cred_id;
BD bd = new BD();
return(Convert.ToInt32(bd.ExecuteScalar(sql, null)));
}
public DateTime GetSegundoDiaUtilDoMes(DateTime PrimeiroDiaUtil)
{
string sql;
sql = "SELECT FORMAT(dbo.workday('" + PrimeiroDiaUtil + "'),'dd,MM,yyyy')";
BD BD = new BD();
return(Convert.ToDateTime(BD.ExecuteScalar(sql, null)));
}
public static int getCredIdFromCodAcesso(int codAcesso)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@codAcesso", codAcesso));
BD BD = new BD();
return(BD.ExecuteScalar(-1, "select cred_id from credenciados where codacesso = @codAcesso", ps));
}
public static int getSegmentoID(int cred_id)
{
SqlParamsList pl = new SqlParamsList();
pl.Add(new Fields("@cred_id", cred_id));
BD bd = new BD();
return(bd.ExecuteScalar(-1, "select seg_id from credenciados where cred_id = @cred_id", pl));
}
//Alterado para SqlServer
public static String getEmail(int empres_id)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@empres_id", empres_id));
BD BD = new BD();
return(BD.ExecuteScalar("", "select email from empresas where empres_id = @empres_id", ps).ToString());
}
//Alterado para SqlServer
public static int getCodAcessoPorCredId(int id)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@id", id));
BD BD = new BD();
return(BD.ExecuteScalar(-1, "select codacesso from credenciados where cred_id = @id", ps));
}
//Alterado para SqlServer
public static int GetTipoCredito(int empres_id)
{
string sql = "select top 1 tipo_credito from empresas where empres_id = @empres_id";
BD BD = new BD();
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("empres_id", empres_id));
return(BD.ExecuteScalar(-1, sql, ps));
}
public static string SNumAutorizacao(string transID)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@transID", transID));
BD BD = new BD();
return(BD.ExecuteScalar("select top 1 autor_id from autor_transacoes where trans_id = @transID", ps).ToString());
}
//Alterado para SqlServer
public static DateTime getDataVenda(string trans_id)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@trans_id", trans_id));
BD BD = new BD();
return(Convert.ToDateTime(BD.ExecuteScalar("select top 1 datavenda from contacorrente where trans_id = @trans_id", ps)));
}
public static string GetUsaLimiteDeCredito(int empres_id)
{
string sql = "select usa_limite_max from empresas where empres_id = @empres_id";
BD BD = new BD();
SqlParamsList pl = new SqlParamsList();
pl.Add(new Fields("empres_id", empres_id));
return(BD.ExecuteScalar(sql, pl).ToString());
}
public static decimal GetValorMaximoDoLimiteConv(int empres_id)
{
string sql = "select limite_max_por_conv from empresas where empres_id = @empres_id";
BD BD = new BD();
SqlParamsList pl = new SqlParamsList();
pl.Add(new Fields("empres_id", empres_id));
return(Convert.ToDecimal(BD.ExecuteScalar(sql, pl)));
}
//Alterado para Sqlserver
public static int GetModCartao(int empres_id)
{
string sql = "select top 1 mod_cart_id from empresas where empres_id = @empres_id";
BD BD = new BD();
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("empres_id", empres_id));
return(BD.ExecuteScalar(-1, sql, ps));
}
public static String getCNPJ(int credID)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@cred_id", credID));
BD BD = new BD();
return(BD.ExecuteScalar("", "select CGC from credenciados where cred_id = @cred_id", ps).ToString());
}
/// <summary>
/// Retorna se estabelecimento utiliza recarga a vista, convenio ou os dois
/// </summary>
/// <param name="numSerie"></param>
/// <returns>V - a vista, C - Convenio, T - os dois</returns>
//Alterado para SqlServer
public static string TipoRecarga(string numSerie)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@serial_number", numSerie));
BD BD = new BD();
return(BD.ExecuteScalar("select tipo_recarga from pos where pos_serial_number = @serial_number", ps).ToString());
}
public static string NumDigito(string transID)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@transID", transID));
BD BD = new BD();
return(BD.ExecuteScalar("select top 1 digito from contacorrente where trans_id = @transID", ps).ToString());
}
/// <summary>
///
/// </summary>
/// <param name="serial_number"></param>
/// <param name="cred_id"></param>
/// <returns></returns>
public static string getUltimoCupom(string numSerie)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@serial_number", numSerie));
BD BD = new BD();
string cupom = Convert.ToString(BD.ExecuteScalar("select top 1 cupom from webpos_ultimos_cupons where serial_number = @serial_number", ps));
return(cupom);
}
public static string GetVersaoNavs(string numSerie)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@serial_number", numSerie));
BD BD = new BD();
string s = Convert.ToString(BD.ExecuteScalar("", "select p.versao_navs from pos p where p.pos_serial_number = @serial_number", ps));
return(s);
}
//Alterado para SqlServer
public static string GetExibiDIRF(int cred_id)
{
string sql = "SELECT coalesce(exibir_dirf,'N') FROM credenciados WHERE apagado <> 'S' AND cred_id = @credID";
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("@credID", cred_id));
BD BD = new BD();
return(BD.ExecuteScalar(sql, ps).ToString());
}
