public T Get <T>(long?TakerId = 0)
{
try
{
SQL = new StringBuilder();
SQL.AppendLine(" Select ");
SQL.AppendLine(" TakerId, ");
SQL.AppendLine(" CompanyId, ");
SQL.AppendLine(" IM, ");
SQL.AppendLine(" CPF_CNPJ, ");
SQL.AppendLine(" RG_IE, ");
SQL.AppendLine(" Name, ");
SQL.AppendLine(" NameFantasy, ");
SQL.AppendLine(" TypePerson, ");
SQL.AppendLine(" CEP, ");
SQL.AppendLine(" Street, ");
SQL.AppendLine(" Number, ");
SQL.AppendLine(" Neighborhood, ");
SQL.AppendLine(" City, ");
SQL.AppendLine(" State, ");
SQL.AppendLine(" Telephone, ");
SQL.AppendLine(" Email, ");
SQL.AppendLine(" Active, ");
SQL.AppendLine(" DateInsert, ");
SQL.AppendLine(" DateUpdate ");
SQL.AppendLine(" From Takers ");
SQL.AppendLine(" Where Active = 1 ");
SQL.AppendLine(" And CompanyId = " + SessionDomain.GetCompanySession().CompanyId);
if (TakerId > 0)
{
SQL.AppendLine(" And TakerId = " + TakerId);
}
DataTable data = Functions.Conn.GetDataTable(SQL.ToString(), "Takers");
if (data != null && data.Rows.Count > 0)
{
if (typeof(T) == typeof(List <Takers>))
{
List <Takers> lTakers = new List <Takers>();
foreach (DataRow row in data.Rows)
{
lTakers.Add(Fill(row));
}
return((T)Convert.ChangeType(lTakers, typeof(T)));
}
else if (typeof(T) == typeof(Takers))
{
return((T)Convert.ChangeType(Fill(data.AsEnumerable().First()), typeof(T)));
}
}
throw new InternalProgramException("Não foram encontrados registros!");
}catch (Exception ex)
{
throw ex;
}
}
public T Get <T>(long Id = 0)
{
try
{
SQL = new StringBuilder();
SQL.AppendLine(" Select ");
SQL.AppendLine(" NumeroNota As 'NumberNF', ");
SQL.AppendLine(" ChaveValidacao As 'KeyValidation', ");
SQL.AppendLine(" ValorTotalNota As 'Total', ");
SQL.AppendLine(" ISSQNTotal As 'TotalISS', ");
SQL.AppendLine(" ClienteNomeRazaoSocial As 'Name', ");
SQL.AppendLine(" ClienteNomeFantasia As 'NameFantasy', ");
SQL.AppendLine(" ClienteCNPJCPF As 'CPF_CNPJ', ");
SQL.AppendLine(" ClienteInscricaoEstadual As 'IE', ");
SQL.AppendLine(" ClienteInscricaoMunicipal As 'IM', ");
SQL.AppendLine(" DataEmissao As 'DateEmission', ");
SQL.AppendLine(" Observacao As 'Note', ");
SQL.AppendLine(" NotaFiscalPDF As 'PDF', ");
SQL.AppendLine(" URL as 'URL', ");
SQL.AppendLine(" URLAutenticidade As 'URLAuthenticity' ");
SQL.AppendLine(" From NFeS ");
SQL.AppendLine(" Where Active = 1 ");
SQL.AppendLine(" And CompanyId = " + SessionDomain.GetCompanySession().CompanyId);
if (Id > 0)
{
SQL.AppendLine(" And NFeSId = " + Id);
}
DataTable data = Functions.Conn.GetDataTable(SQL.ToString(), "NFeS");
if (data != null && data.Rows.Count > 0)
{
if (typeof(T) == typeof(List <NFeSRequestQuery>))
{
List <NFeSRequestQuery> lRequestQuery = new List <NFeSRequestQuery>();
foreach (DataRow row in data.Rows)
{
lRequestQuery.Add(Fill(row));
}
return((T)Convert.ChangeType(lRequestQuery, typeof(T)));
}
else if (typeof(T) == typeof(NFeSRequestQuery))
{
return((T)Convert.ChangeType(Fill(data.AsEnumerable().First()), typeof(T)));
}
}
throw new InternalProgramException("Não foram encontrados registros!");
}
catch (Exception ex)
{
throw ex;
}
}
public T Get <T>(long?ServicesId)
{
try
{
SQL = new StringBuilder();
SQL.AppendLine(" Select ");
SQL.AppendLine(" ServicesId, ");
SQL.AppendLine(" CompanyId, ");
SQL.AppendLine(" Unity, ");
SQL.AppendLine(" Value, ");
SQL.AppendLine(" Description, ");
SQL.AppendLine(" IRRF, ");
SQL.AppendLine(" PIS, ");
SQL.AppendLine(" CSLL, ");
SQL.AppendLine(" INSS, ");
SQL.AppendLine(" COFINS, ");
SQL.AppendLine(" Active, ");
SQL.AppendLine(" DateInsert, ");
SQL.AppendLine(" DateUpdate ");
SQL.AppendLine(" From Services ");
SQL.AppendLine(" Where Active = 1 ");
SQL.AppendLine(" And CompanyId = " + SessionDomain.GetCompanySession().CompanyId);
if (ServicesId > 0)
{
SQL.AppendLine(" And ServicesId = " + ServicesId);
}
DataTable data = Functions.Conn.GetDataTable(SQL.ToString(), "Services");
if (data != null && data.Rows.Count > 0)
{
if (typeof(T) == typeof(List <Services>))
{
List <Services> lServices = new List <Services>();
foreach (DataRow row in data.Rows)
{
lServices.Add(Fill(row));
}
return((T)Convert.ChangeType(lServices, typeof(T)));
}
else if (typeof(T) == typeof(Services))
{
return((T)Convert.ChangeType(Fill(data.AsEnumerable().First()), typeof(T)));
}
}
throw new InternalProgramException("Não foram encontrados registros!");
}
catch (Exception ex)
{
throw ex;
}
}
