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;
}
}
public Users Login(string Email, string Password)
{
try
{
if (string.IsNullOrEmpty(Email) || string.IsNullOrEmpty(Password))
{
throw new InternalProgramException("Email ou senha não informado!");
}
SQL = new StringBuilder();
SQL.AppendLine(" Select * From Users ");
SQL.AppendLine(" Where Active = 1 ");
SQL.AppendLine(" And Email Like '" + Functions.NoQuote(Email) + "'");
SQL.AppendLine(" And Password Like '" + Functions.Encript(Functions.NoQuote(Password)) + "'");
DataTable data = Functions.Conn.GetDataTable(SQL.ToString(), "Users");
if (data != null && data.Rows.Count > 0)
{
DataRow row = data.AsEnumerable().First();
Sessions session = SessionDomain.NewSession(row.Field <long>("UserId"));
if (session.SessionId > 0)
{
Users users = new Users();
users.UserId = row.Field <long>("UserId");
users.Name = row.Field <string>("Name");
users.LastName = row.Field <string>("LastName");
users.CPF = row.Field <string>("CPF");
users.Email = row.Field <string>("Email");
users.Password = Functions.Desencript(row.Field <string>("Password"));
users.SessionHash = session.SessionHash;
users.Active = row.Field <bool>("Active");
users.DateInsert = row.Field <DateTime>("DateInsert").ToString("dd-MM-yyyy");
users.DateUpdate = row.Field <DateTime>("DateUpdate").ToString("dd-MM-yyyy");
return(users);
}
throw new InternalProgramException("Não foi possivel gerar uma sessão para o usuário!");
}
throw new InternalProgramException("Email ou senha inválidos!");
}catch (Exception ex)
{
throw ex;
}
}
public Users Post(Users users)
{
try
{
Validate(users);
SQL = new StringBuilder();
SQL.AppendLine(" Insert Into Users ");
SQL.AppendLine(" (Name, ");
SQL.AppendLine(" LastName, ");
SQL.AppendLine(" CPF, ");
SQL.AppendLine(" Email, ");
SQL.AppendLine(" Password, ");
SQL.AppendLine(" Active, ");
SQL.AppendLine(" DateInsert, ");
SQL.AppendLine(" DateUpdate) ");
SQL.AppendLine(" Values( ");
SQL.AppendLine(" '" + Functions.NoQuote(users.Name) + "',");
SQL.AppendLine(" '" + Functions.NoQuote(users.LastName) + "',");
SQL.AppendLine(" '" + Functions.RemoveCharSpecial(Functions.NoQuote(users.CPF)) + "',");
SQL.AppendLine(" '" + Functions.NoQuote(users.Email) + "',");
SQL.AppendLine(" '" + Functions.Encript(Functions.NoQuote(users.Password)) + "',");
SQL.AppendLine(" 1,");
SQL.AppendLine(" GetDate(),");
SQL.AppendLine(" GetDate() ");
SQL.AppendLine(" ) ");
users.UserId = Functions.Conn.Insert(SQL.ToString());
Sessions session = SessionDomain.NewSession(users.UserId);
if (users.UserId > 0 && session.SessionId > 0)
{
users.SessionHash = session.SessionHash;
users.Active = true;
users.DateInsert = DateTime.Now.ToString("yyyy-MM-dd");
users.DateUpdate = DateTime.Now.ToString("yyyy-MM-dd");
return(users);
}
throw new InternalProgramException("Houve um problema ao cadastrar o usuário.");
}catch (Exception ex)
{
throw ex;
}
}
public static Sessions NewSession(long UserId)
{
try
{
if (UserId <= 0)
{
throw new InternalProgramException("Usuario não encontrado!");
}
Users users = new UsersDomain().Get(UserId);
if (users.UserId <= 0)
{
throw new InternalProgramException("Usuario não cadastrado na base de dados!");
}
DataTable data;
SQL = new StringBuilder();
SQL.AppendLine(" Select Top 1 ");
SQL.AppendLine(" SessionId ");
SQL.AppendLine(" From Session ");
SQL.AppendLine(" Where Active = 1 ");
SQL.AppendLine(" And DateDiff(MI, DateStart, Getdate()) <= " + Timeout);
SQL.AppendLine(" And Session.UserId = " + UserId);
data = Functions.Conn.GetDataTable(SQL.ToString(), "Session");
if (data != null && data.Rows.Count > 0 && data.AsEnumerable().First().Field <long>("SessionId") > 0)
{
return(SessionDomain.GetSessionById(data.AsEnumerable().First().Field <long>("SessionId")));
}
string Hash = SessionDomain.GenerateHash(users.UserId.ToString() + users.Password.ToString());
SQL = new StringBuilder();
SQL.AppendLine(" Insert Into Session ");
SQL.AppendLine(" (UserId, ");
SQL.AppendLine(" SessionHash,");
SQL.AppendLine(" DateStart, ");
SQL.AppendLine(" DateEnd, ");
SQL.AppendLine(" Active, ");
SQL.AppendLine(" DateInsert, ");
SQL.AppendLine(" DateUpdate)");
SQL.AppendLine(" Values ");
SQL.AppendLine(" ( " + UserId + ",");
SQL.AppendLine(" '" + Hash + "',");
SQL.AppendLine(" GetDate(),");
SQL.AppendLine(" DateAdd(MI," + Timeout + ",GetDate()),");
SQL.AppendLine(" 1, ");
SQL.AppendLine(" GetDate(), ");
SQL.AppendLine(" GetDate()) ");
Sessions session = new Sessions();
session.SessionId = Functions.Conn.Insert(SQL.ToString());
if (session.SessionId > 0)
{
return(SessionDomain.GetSessionById(session.SessionId));
}
throw new InternalProgramException("Não foi possivel criar uma sessão para o usuário!");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
