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;
}
}